How do I find the state within which an object falls?
You can find the state within which an object falls by joining the Census table to the Objects table on the OBJ_ID field. This provides all Census information (such as state or place names) for the objects.
How do I attach the 1:many tables to the Objects table?
For available dataset formats mentioned above, an inner join operation would be used to relate all the records in a 1:many table to the object with the matching OBJ_ID. For SHP format, a relate operation would be used in the GIS software in which the data was loaded.
How do I separate neighborhoods by neighborhood type?
To separate out neighborhood types for your application, simply query the data by the following object sub-type values:
| OBJ_TYP | OBJ_SUBTYP | OBJ_SUBTCD |
| Neighborhood | Macro Neighborhood | M |
| Neighborhood | Neighborhood | N |
| Neighborhood | Sub Neighborhood | S |