Layers:

Layer: Addresses (0)


Name: Addresses

Display Field: street_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Description: <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><p>The geometry is a Point in the EPSG:2898 projection.</p>

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.2874649519999
YMin: 42.2555642310001
XMax: -82.911115275
YMax: 42.4500211800001
Spatial Reference: 4326 (4326)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[84,43,150,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• address_id (type: esriFieldTypeInteger, alias: Address ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• unit_id (type: esriFieldTypeInteger, alias: Unit ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• building_id (type: esriFieldTypeInteger, alias: Building ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_id (type: esriFieldTypeInteger, alias: Street ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• streetname_id (type: esriFieldTypeInteger, alias: Street Name ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• street_number (type: esriFieldTypeInteger, alias: Street Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_type (type: esriFieldTypeString, alias: Unit Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• unit_number (type: esriFieldTypeString, alias: Unit Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• zip_four (type: esriFieldTypeString, alias: Zip Four, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• council_district (type: esriFieldTypeInteger, alias: Council District, SQL Type: sqlTypeOther, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• geo_source (type: esriFieldTypeString, alias: Geo Source, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• updated_at (type: esriFieldTypeDate, alias: updated_at, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• condo_plan_number (type: esriFieldTypeInteger, alias: Condo Plan Number, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: addresses
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2026 7:06:45 AM

Schema Last Edit Date: 7/12/2026 7:08:46 AM

Data Last Edit Date: 7/19/2026 7:06:45 AM

Layer: Streets (1)


Name: Streets

Display Field: street_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: development.dbt_mart_base_units.street_feature_service

Copyright Text:

Min. Scale: 22449

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.2878190719999
YMin: 42.254984968
XMax: -82.91054818
YMax: 42.450398893
Spatial Reference: 4326 (4326)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[57,77,142,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• street_id (type: esriFieldTypeInteger, alias: Street ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• streetname_id (type: esriFieldTypeInteger, alias: Street Name ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• lrs_link (type: esriFieldTypeString, alias: LRS Link, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• street_prefix (type: esriFieldTypeString, alias: Street Prefix, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• full_street_name (type: esriFieldTypeString, alias: Full Street Name, SQL Type: sqlTypeOther, length: 60000, nullable: true, editable: true)
• from_address_left (type: esriFieldTypeInteger, alias: From Address Left, SQL Type: sqlTypeOther, nullable: true, editable: true)
• to_address_left (type: esriFieldTypeInteger, alias: To Address Left, SQL Type: sqlTypeOther, nullable: true, editable: true)
• from_address_right (type: esriFieldTypeInteger, alias: From Address Right, SQL Type: sqlTypeOther, nullable: true, editable: true)
• to_address_right (type: esriFieldTypeInteger, alias: To Address Right, SQL Type: sqlTypeOther, nullable: true, editable: true)
• functional_class_code (type: esriFieldTypeString, alias: Framework Classification Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• legal_system (type: esriFieldTypeString, alias: Legal System, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• national_functional_class (type: esriFieldTypeString, alias: National Functional Class, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: streets
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/6/2026 4:26:07 PM

Schema Last Edit Date: 7/6/2026 2:31:48 PM

Data Last Edit Date: 6/9/2025 12:56:11 PM

Layer: Buildings (2)


Name: Buildings

Display Field: parcel_id

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Description: <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 this building. The parcel_id field identifies the parcel this building sits on and should be populated.</p><p>The geometry is a Polygon in the EPSG:2898 projection. In the future, it should be a 3D multipatch type to allow for extrusion and texturing.</p>

Copyright Text:

Min. Scale: 30721

Max. Scale: 624

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -83.2875322579999
YMin: 42.255679521
XMax: -82.91097609
YMax: 42.4501045570001
Spatial Reference: 4326 (4326)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[234,252,186,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: objectid

Unique ID Field:

Name : objectid

IsSystemMaintained : True


Global ID Field:

Type ID Field:

Fields:
• objectid (type: esriFieldTypeOID, alias: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• building_id (type: esriFieldTypeInteger, alias: Building ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcel_id (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• semcog_id (type: esriFieldTypeInteger, alias: Semcog ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• also_known_as (type: esriFieldTypeString, alias: Also Known As, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• condo_plan_number (type: esriFieldTypeInteger, alias: Condo Plan Number, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: buildings
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:


Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/19/2026 7:07:14 AM

Schema Last Edit Date: 7/12/2026 7:09:31 AM

Data Last Edit Date: 7/19/2026 7:07:14 AM