Name: AddressPoints

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

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:

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[59,147,255,0],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"if($feature.ADDRNUM != \"\") return $feature.ADDRNUM\nelse return \"No address\"","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementCenterCenter","deconflictionStrategy":"static","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":null,"haloSize":null,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}

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)
• ADDPTKEY (type: esriFieldTypeString, alias: Address Point ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ADDRNUMSUF (type: esriFieldTypeString, alias: Address Number Suffix, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• ADDRNUM (type: esriFieldTypeString, alias: Full Address Number, SQL Type: sqlTypeOther, length: 20, 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], ... 22 more ...)
• UNITID (type: esriFieldTypeString, alias: Address Unit Number, 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)
• MUNICIPALITY (type: esriFieldTypeString, alias: Municipality Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [BLUE SPRINGS: BLUE SPRINGS], [BUCKNER: BUCKNER], [GRAIN VALLEY: GRAIN VALLEY], ... 17 more ...)
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Current: Current], [Pending: Pending], [Retired: Retired])
• XCOORD (type: esriFieldTypeDouble, alias: X Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• YCOORD (type: esriFieldTypeDouble, alias: Y Coordinate, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ZIP (type: esriFieldTypeString, alias: Zip Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• TCA (type: esriFieldTypeString, alias: TCA, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [001: 001], [007: 007], [008: 008], ... 107 more ...)
• IMAGENAME (type: esriFieldTypeString, alias: Image Name, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• IMAGEPATH (type: esriFieldTypeString, alias: Image Path, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• PRIMARYADDRESS (type: esriFieldTypeString, alias: PRIMARYADDRESS, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Primary: Primary], [Multiple: Multiple])
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Directional_Prefix (type: esriFieldTypeString, alias: Directional Prefix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [E: E], [N: N], [S: S], ... 5 more ...)
• Directional_Suffix (type: esriFieldTypeString, alias: Directional Suffix, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [E: E], [N: N], [S: S], ... 5 more ...)
• Road_type (type: esriFieldTypeString, alias: Road_type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AVE: AVE], [CIR: CIR], [DR: DR], ... 16 more ...)
• ESN (type: esriFieldTypeString, alias: EmergencyServiceNumberE911, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• NFHA (type: esriFieldTypeString, alias: NFHA, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• TELEXCH (type: esriFieldTypeString, alias: TELEXCH, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• AddrType (type: esriFieldTypeString, alias: AddressType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• StateAbbrv (type: esriFieldTypeString, alias: StateAbbreviation, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Name: Address_Points
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• State: Missouri
• FULLNAME: NO ADDRESS ASSIGNED BY CITY
• FULLADDR: NO ADDRESS ASSIGNED BY CITY
• STATUS: Current
• StateAbbrv: MO

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/28/2026 4:50:20 PM

Schema Last Edit Date: 4/28/2026 4:50:20 PM

Data Last Edit Date: 4/28/2026 4:50:20 PM

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