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:
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
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat