Description: <p>A table of the addresses in the city with their location represented as points.</p><p>When an address is related to a unit, its location is the center point of the building that unit is related to. In the future, this location may be upgraded to be the rooftop location of that unit within the building. When an address describes a building and not a unit, the location is the center point of the related building. When an address is only related to a parcel, its location is the center point of that related parcel.</p><p>The address_id field is the unique ID for this address. Unit, parcel, building, and street ID fields are the unique IDs for the corresponding physical base units. The geo_source field indicates the physical base unit that this address got its location from.</p>
Description: <p>A table of all street segments in the City. This data is maintained collaboratively by the Department of Public Works (DPW) and the Department of Information Technology (DoIT).</p>
Description: <p>A table of all buildings in the city maintained by the Department of Innovation and Technology (DoIT).</p><p>This table links to the other base unit tables. Addresses should generally link to a building, but do not have to. The major exception is for parcel addresses where no building exists. Units must link to a building.</p><p>The building_id field is the unique ID for the building. The parcel_id field identifies the parcel where the building is located and should be populated.</p>