Name: Site Address Points

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Site address points represent the location of site or service delivery addresses assigned by local governments.

Copyright Text: Schema provided by a combination of ESRI Local Government and NENA's NG-911 requirements.

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: 1576150.9976958
YMin: 83189.7225173712
XMax: 2098629.90680414
YMax: 503796.256220601
Spatial Reference: 102748 (2285)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[135,52,63,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: GlobalID

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• SITEADDID (type: esriFieldTypeString, alias: Site Address ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ADDPTKEY (type: esriFieldTypeString, alias: Address Point ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• PREADDRNUM (type: esriFieldTypeString, alias: Address No Prefix, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ADDRNUMSUF (type: esriFieldTypeString, alias: Address No Suffix, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ADDRNUM (type: esriFieldTypeString, alias: Full Address No, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ADDRRANGE (type: esriFieldTypeString, alias: Address Range, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNITTYPE (type: esriFieldTypeString, alias: Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 24 more ...)
• UNITID (type: esriFieldTypeString, alias: Address Unit No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ALTUNITTYPE (type: esriFieldTypeString, alias: Alternate Address Unit Type, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: Apartment], [BSMT: Basement], [BLDG: Building], ... 24 more ...)
• ALTUNITID (type: esriFieldTypeString, alias: Alternate Address Unit No, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FULLNAME (type: esriFieldTypeString, alias: Full Road Name, SQL Type: sqlTypeOther, length: 125, nullable: true, editable: true)
• FULLADDR (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PLACENAME (type: esriFieldTypeString, alias: Place Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• POST_COMM (type: esriFieldTypeString, alias: Postal Community Name, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: Emergency Service No, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• PSAP (type: esriFieldTypeString, alias: Public Safety Answering Point, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• MSAG (type: esriFieldTypeString, alias: MSAG Community, SQL Type: sqlTypeOther, length: 35, nullable: true, editable: true)
• USNGCOORD (type: esriFieldTypeString, alias: USNG Coordinate, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRCLASS (type: esriFieldTypeInteger, alias: Description, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [701: Agriculture, Food, and Livestock], [710: Industry], [720: Commercial and Retail], ... 13 more ...)
• POINTTYPE (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Building: Building], [Parcel: Parcel], [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite], ... 3 more ...)
• CAPTUREMETH (type: esriFieldTypeString, alias: Capture Method, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Geocoded: Geocoded], [GPS: GPS], [Site Visit: Site Visit], ... 2 more ...)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Current: Current], [Pending: Pending], [Retired: Retired], ... 2 more ...)
• LASTUPDATE (type: esriFieldTypeDate, alias: Last Update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRESSNUM (type: esriFieldTypeString, alias: Address No, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDED_DATE (type: esriFieldTypeDate, alias: Added Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADDED_BY (type: esriFieldTypeString, alias: Added By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EDITDESCRIPTION (type: esriFieldTypeString, alias: Edit Description, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• ADDRESS_SUBTYPE (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 155, nullable: true, editable: true, Coded Values: [Apartment/Condo: Apartment/Condo], [Assisted Living: Assisted Living], [Bank: Bank], ... 39 more ...)
• PARCELNUM (type: esriFieldTypeString, alias: Parcel No, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• PLATNAME (type: esriFieldTypeString, alias: Plat Name, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• FIREHAZARD (type: esriFieldTypeString, alias: Fire Hazard, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ESMPG (type: esriFieldTypeString, alias: ESMPG, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• Mpbk_Lbl (type: esriFieldTypeString, alias: Mapbook Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ALT_PLCNM (type: esriFieldTypeString, alias: Alternate Place Name, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• PRV_ADD (type: esriFieldTypeString, alias: Previous Address, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source of Data, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• COUNTRY (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• SITE_NGUID (type: esriFieldTypeString, alias: Site Unique ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• INC_MUNI (type: esriFieldTypeString, alias: Incorporated Municipality, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• POST_CODE (type: esriFieldTypeString, alias: Postal Code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MILE_POST (type: esriFieldTypeString, alias: Mile Post, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LAT (type: esriFieldTypeDouble, alias: Lat, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LONG (type: esriFieldTypeDouble, alias: Long, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CITYCD (type: esriFieldTypeString, alias: City Code, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• QAQC_XMPT (type: esriFieldTypeString, alias: QAQC_XMPT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• QAQC_COMM (type: esriFieldTypeString, alias: QAQC_COMM, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EFFECTIVE (type: esriFieldTypeDate, alias: Effective, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• EXPIRATION (type: esriFieldTypeDate, alias: Expiration, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• NWADND (type: esriFieldTypeString, alias: New Address Needed, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• Elev (type: esriFieldTypeSmallInteger, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Bldg (type: esriFieldTypeString, alias: Building, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• DiscrpAgID (type: esriFieldTypeString, alias: Discrepancy Ag ID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)

Templates:

Name: Site Address Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/3/2026 9:43:30 PM

Schema Last Edit Date: 6/3/2026 9:43:30 PM

Data Last Edit Date: 9/26/2025 8:59:26 PM

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