Layers:

Layer: DSNYGIS.DBO.CSCL_AddressPoint_4326 (0)


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:

XMin: -74.255145575
YMin: 40.4984810180001
XMax: -73.7002405549999
YMax: 40.913844727
Spatial Reference: 4326 (4326)


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:

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)
• 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:

Name: DSNYGIS.DBO.CSCL_AddressPoint_4326
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:


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