View In:   ArcGIS Online Map Viewer

Parent Layer: Addresses

Name: Sugar_Creek_Address_Point

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This feature class represents situs location addresses within the City of Independence, Missouri. Situs addresses are physical locations used for property identification and are essential for emergency response, property assessment, planning, and public services. Each feature includes key attribute information such as address numbers, street names, unit designations, and location coordinates.Attributes:SITEADDID: Unique Identifier for Address Points Used in Cityworks. ADDRNUM: Numeric value representing the building number (e.g., 123).StreetSuffix: Suffix direction for street (i.e. 123 Oak St Ter N, etc...)PREADDRNUM: Prefix direction for street (.e. N Main, S Oak, etc.)FULLNAME: Name of the street (e.g., Main St).FULLADDR: Full street address for the Situs Location including the number unit, unit type, street type, road name and any prefixes and/or suffix. UNITID: Unit, suite, or apartment number, if applicable.UNITTYPE: Unit type (i.e. STE, APT, BLDG, UNIT, etc.) if applicable.MUNICIPALITY: Name of the city (e.g., Independence).ZipCode: Postal code (e.g., 64050).STATUS: Status of the address. ParcelID: Unique identifier linked to property parcel data.StreetType: The type of street (i.e. ST, AVE, BLVD, etc.)COUNCILDIST: City Council District that the address falls within. C_ACCOUNT: Utility service location address tied to the Situs Address. Location: Full address field for Cityworks. Updates:Updated as new addresses/updates are established by Community Development & New Subdivisions.

Service Item Id: 1cf3a54dc2384870880f960fc71c3200

Copyright Text: City of Independence Missouri (2025)

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: -1.0514537804552594E7
YMin: 4736332.815490827
XMax: -1.0501670925040228E7
YMax: 4746646.316090717
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [51, 144, 147, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• SITEADDID ( type: esriFieldTypeString, alias: Site Address ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITEADDID )
• ADDPTKEY ( type: esriFieldTypeString, alias: Address Point ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDPTKEY )
• PREADDRNUM ( type: esriFieldTypeString, alias: Address Number Prefix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PREADDRNUM , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• ADDRNUMSUF ( type: esriFieldTypeString, alias: Address Number Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ADDRNUMSUF )
• ADDRNUM ( type: esriFieldTypeString, alias: Full Address Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADDRNUM )
• ADDRRANGE ( type: esriFieldTypeString, alias: Address Range, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRRANGE )
• UNITTYPE ( type: esriFieldTypeString, alias: Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITTYPE , Coded Values: [APT: APARTMENT] , [BLDG: BUILDING] , [BSMT: BASEMENT] , ...24 more... )
• UNITID ( type: esriFieldTypeString, alias: Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNITID )
• ALTUNITTYPE ( type: esriFieldTypeString, alias: Alternate Address Unit Type, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITTYPE , Coded Values: [APT: APARTMENT] , [BLDG: BUILDING] , [BSMT: BASEMENT] , ...24 more... )
• ALTUNITID ( type: esriFieldTypeString, alias: Alternate Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITID )
• FULLNAME ( type: esriFieldTypeString, alias: Full Road Name, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULLNAME )
• FULLADDR ( type: esriFieldTypeString, alias: Full Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULLADDR )
• PLACENAME ( type: esriFieldTypeString, alias: Place Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PLACENAME )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: INDEPENDENCE, modelName: MUNICIPALITY , Coded Values: [KANSAS CITY: KANSAS CITY] , [GRAIN VALLEY: GRAIN VALLEY] , [BLUE SPRINGS: BLUE SPRINGS] , ...7 more... )
• ESN ( type: esriFieldTypeString, alias: Emergency Service Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• PSAP ( type: esriFieldTypeString, alias: Public Safety Answering Point, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSAP )
• MSAG ( type: esriFieldTypeString, alias: MSAG Community, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MSAG )
• USNGCOORD ( type: esriFieldTypeString, alias: USNG Coordinate, editable: true, nullable: true, length: 50, defaultValue: null, modelName: USNGCOORD )
• ADDRCLASS ( type: esriFieldTypeInteger, alias: Description, editable: true, nullable: true, defaultValue: null, modelName: ADDRCLASS , Coded Values: [701: Agriculture, Food, and Livestock] , [710: Industry] , [720: Commercial and Retail] , ...13 more... )
• POINTTYPE ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE , Coded Values: [Building: Building] , [Other: Other] , [Parcel: Parcel] , ...5 more... )
• CAPTUREMETH ( type: esriFieldTypeString, alias: Capture Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CAPTUREMETH , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...2 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: Current, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...2 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• ComplexName ( type: esriFieldTypeString, alias: ComplexName, editable: true, nullable: true, length: 35, defaultValue: null, modelName: ComplexName )
• ParcelID ( type: esriFieldTypeString, alias: Parcel ID, editable: true, nullable: true, length: 29, defaultValue: null, modelName: ParcelID )
• ZipCode ( type: esriFieldTypeInteger, alias: ZipCode, editable: true, nullable: true, defaultValue: null, modelName: ZipCode , Coded Values: [64136: 64136] , [64133: 64133] , [64129: 64129] , ...17 more... )
• StreetType ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 8, defaultValue: null, modelName: StreetType , Coded Values: [ST: ST] , [RD: RD] , [AVE: AVE] , ...14 more... )
• StreetSuffix ( type: esriFieldTypeString, alias: StreetSuffix, editable: true, nullable: true, length: 6, defaultValue: null, modelName: StreetSuffix , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• COUNCILDIST ( type: esriFieldTypeString, alias: COUNCILDIST, editable: true, nullable: true, length: 10, defaultValue: null, modelName: COUNCILDIST , Coded Values: [1: COUNCIL DISTRICT 1] , [2: COUNCIL DISTRICT 2] , [3: COUNCIL DISTRICT 3] , ...1 more... )
• X_COORD ( type: esriFieldTypeDouble, alias: X_COORD, editable: true, nullable: true, defaultValue: null, modelName: X_COORD )
• Y_COORD ( type: esriFieldTypeDouble, alias: Y_COORD, editable: true, nullable: true, defaultValue: null, modelName: Y_COORD )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Location )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Templates:

• Name: Sugar_Creek_Address_Point
  Description:
  Prototype:
  Location: null
  Y_COORD: null
  SITEADDID: null
  ADDPTKEY: null
  PREADDRNUM: null
  ADDRNUMSUF: null
  ADDRNUM: null
  ADDRRANGE: null
  UNITTYPE: null
  UNITID: null
  ALTUNITTYPE: null
  ALTUNITID: null
  FULLNAME: null
  FULLADDR: null
  PLACENAME: null
  MUNICIPALITY: INDEPENDENCE
  ESN: null
  PSAP: null
  MSAG: null
  USNGCOORD: null
  ADDRCLASS: null
  POINTTYPE: null
  CAPTUREMETH: null
  STATUS: Current
  LASTUPDATE: null
  LASTEDITOR: null
  ComplexName: null
  ParcelID: null
  ZipCode: null
  StreetType: null
  StreetSuffix: null
  COUNCILDIST: null
  X_COORD: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata