Layer: DSNYGIS.DBO.CSCL_AddressPoint

View In: Map Viewer

Name: DSNYGIS.DBO.CSCL_AddressPoint_4326

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Address points were initially created from data in the Department of City Planning Property Address Directory (PAD) file. Points were created approximately five feet inside building footprints along the correct street frontage. A field collection/verification process was undertaken to validate "multi-valued" addresses contained in the PAD file (i.e. those locations with a range of addresses). Additionally, a statistical sample of PAD single valued addresses was field checked. Approximately 100,000 locations were visited (about 10% of the total).

Copyright Text: City of New York - Department of Information Technology & Telecommunications

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[47,145,122,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:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ADDRESSPOINTID (type: esriFieldTypeInteger, alias: ADDRESSPOINTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
COMPLEXID (type: esriFieldTypeInteger, alias: COMPLEXID, SQL Type: sqlTypeOther, nullable: true, editable: true)
BIN (type: esriFieldTypeInteger, alias: BIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
HOUSE_NUMBER (type: esriFieldTypeString, alias: HOUSE_NUMBER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
HOUSE_NUMBER_SUFFIX (type: esriFieldTypeString, alias: HOUSE_NUMBER_SUFFIX, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
HYPHEN_TYPE (type: esriFieldTypeString, alias: HYPHEN_TYPE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [R: Building Range], [Q: Queens Type], [X: Range of Queens Style], ... 2 more ...)
SOSINDICATOR (type: esriFieldTypeString, alias: SOSINDICATOR, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Left], [2: Right])
SPECIAL_CONDITION (type: esriFieldTypeString, alias: SPECIAL_CONDITION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [A: Alt Address - SAF record same as LION record], [B: Alt Address - SAF record and LION record differ], [C: Ruby Street on Brooklyn-Queens border], ... 12 more ...)
ADDRESS_SOURCE (type: esriFieldTypeString, alias: ADDRESS_SOURCE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Signage], [3: BPO], [4: PAD], ... 2 more ...)
ADDRESS_STATUS (type: esriFieldTypeString, alias: ADDRESS_STATUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Proposed], [2: Permitted], [3: UnderConstruction], ... 2 more ...)
VALIDATION (type: esriFieldTypeString, alias: VALIDATION, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Delivery Point Verification], [2: Field], [3: Not Validated], ... 2 more ...)
BOROUGHCODE (type: esriFieldTypeString, alias: BOROUGHCODE, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: Manhattan], [2: Bronx], [3: Brooklyn], ... 5 more ...)
ZIPCODE (type: esriFieldTypeString, alias: ZIPCODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
COLLECTIONMETHOD (type: esriFieldTypeString, alias: COLLECTIONMETHOD, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [F: Field Collection], [A: Auto Generated], [O: Other], ... 1 more ...)
CREATED_DATE (type: esriFieldTypeDate, alias: CREATED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MODIFIED_DATE (type: esriFieldTypeDate, alias: MODIFIED_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
B7SC_ACTUAL (type: esriFieldTypeString, alias: B7SC_ACTUAL, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
B7SC_VANITY (type: esriFieldTypeString, alias: B7SC_VANITY, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
A4ID (type: esriFieldTypeInteger, alias: A4ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
HOUSE_NUMBER_RANGE (type: esriFieldTypeString, alias: HOUSE_NUMBER_RANGE, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
HOUSE_NUMBER_RANGE_SUFFIX (type: esriFieldTypeString, alias: HOUSE_NUMBER_RANGE_SUFFIX, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
PHYSICALID (type: esriFieldTypeInteger, alias: PHYSICALID, SQL Type: sqlTypeOther, nullable: true, editable: true)
PRE_MODIFIER (type: esriFieldTypeString, alias: PRE_MODIFIER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
PRE_DIRECTIONAL (type: esriFieldTypeString, alias: PRE_DIRECTIONAL, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [W: West], [E: East], [S: South], ... 9 more ...)
PRE_TYPE (type: esriFieldTypeString, alias: PRE_TYPE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
POST_TYPE (type: esriFieldTypeString, alias: POST_TYPE, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
POST_DIRECTIONAL (type: esriFieldTypeString, alias: POST_DIRECTIONAL, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [W: West], [E: East], [S: South], ... 9 more ...)
POST_MODIFIER (type: esriFieldTypeString, alias: POST_MODIFIER, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
FULL_STREET_NAME (type: esriFieldTypeString, alias: FULL_STREET_NAME, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
wkt_geometry (type: esriFieldTypeString, alias: wkt_geometry, SQL Type: sqlTypeOther, length: 1073741822, nullable: true, editable: true)
srid (type: esriFieldTypeInteger, alias: srid, SQL Type: sqlTypeOther, nullable: true, editable: true)
etl_datetime (type: esriFieldTypeDate, alias: etl_datetime, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/20/2023 12:00:58 PM

Schema Last Edit Date: 4/20/2023 12:00:58 PM

Data Last Edit Date: 4/20/2023 12:00:58 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: DSNYGIS.DBO.CSCL_AddressPoint_4326 (ID:0)