Name: O'Fallon Address Points

Display Field: FullAddrNorm

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 77777

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 2353218.75120291
YMin: 684874.61819157
XMax: 2388393.38492174
YMax: 721674.072151572
Spatial Reference: 102672 (3436)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"AddType","defaultSymbol":{"color":[170,170,170,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"defaultLabel":"Other","uniqueValueInfos":[{"value":"R","symbol":{"color":[255,255,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[77,77,77,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Residential"},{"value":"C","symbol":{"color":[255,0,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":null,"width":0.75,"type":"esriSLS","style":"esriSLSNull"}},"label":"Commercial"},{"value":"Government","symbol":{"color":[0,77,168,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Government"},{"value":"Church","symbol":{"color":[169,0,230,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Church"},{"value":"School","symbol":{"color":[60,175,153,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"School"},{"value":"I","symbol":{"color":[77,77,77,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Industrial"},{"value":"ParkingLot","symbol":{"color":[255,170,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Parking Lot"},{"value":"VacantLot","symbol":{"color":[152,230,0,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"label":"Vacant Lot"}]},"transparency":0}

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: AddType

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• FacilityID (type: esriFieldTypeString, alias: Facility ID, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• LifeCycleStatus (type: esriFieldTypeString, alias: Life Cycle Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ACT: Active], [ABN: Abandoned], [PRP: Proposed], ... 5 more ...)
• FullAddrNorm (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Municipality (type: esriFieldTypeString, alias: Municipality Responsible, SQL Type: sqlTypeOther, length: 90, nullable: true, editable: true)
• AddNum (type: esriFieldTypeInteger, alias: Address Number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• PreDir (type: esriFieldTypeString, alias: Pre-Direction, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• St_Name (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• St_Type (type: esriFieldTypeString, alias: Street Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AVE: AVE], [BLVD: BLVD], [CIR: CIR], ... 14 more ...)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Zip (type: esriFieldTypeDouble, alias: Zipcode, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UnitDescr (type: esriFieldTypeString, alias: Unit Descriptor, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [APT: APARTMENT], [LOT: LOT], [ROOM: ROOM], ... 4 more ...)
• LocCollectionMethod (type: esriFieldTypeString, alias: Location Collection Method, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Geocoded: Geocoded], [FieldCollect: Field Collected], [PlacedonMap: Placed On Map], ... 4 more ...)
• AddType (type: esriFieldTypeString, alias: Address Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [R: Residential], [C: Commercial], [I: Industrial], ... 9 more ...)
• ResClass (type: esriFieldTypeString, alias: Residential Class, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [SF: Single Family], [MF: Multi Family], [Oth: Other], ... 5 more ...)
• LocType (type: esriFieldTypeString, alias: Address Pt Location Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Entrance: Building Entrance], [Building: Building], [Parcel: Parcel], ... 3 more ...)
• AccLevel (type: esriFieldTypeString, alias: Access Level, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [1: 1st Floor], [2: 2nd Floor], [3: 3rd Floor], ... 10 more ...)
• ParcelID (type: esriFieldTypeString, alias: Parcel ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ParcelNum (type: esriFieldTypeString, alias: Parcel Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Subdivision (type: esriFieldTypeString, alias: Subdivision Name, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• LotNumber (type: esriFieldTypeString, alias: Lot ID Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ETSBControl (type: esriFieldTypeString, alias: ETSB Control Number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• ETSBDate (type: esriFieldTypeDate, alias: ETSB Date Initiated, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• PreliminaryAddress (type: esriFieldTypeString, alias: Preliminary Address, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• TextAngle (type: esriFieldTypeDouble, alias: Text Angle, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TaxRecord_HotLink01 (type: esriFieldTypeString, alias: TaxRecord_HotLink01, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude (WGS84 DD - Y value), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude (WGS84 DD - X Value), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Elevation (type: esriFieldTypeDouble, alias: Elevation (NAVD88 USFeet Height), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Create_Date (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• CREATE_BY (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EDIT_DATE (type: esriFieldTypeDate, alias: Last Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EDIT_BY (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Types:

ID: R
Name: Residential
Domains:

Templates:

Name: Residential
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: R

---

ID: C
Name: Commercial
Domains:

Templates:

Name: Commercial
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: C

---

ID: Government
Name: Government
Domains:

Templates:

Name: Government
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: Government

---

ID: Church
Name: Church
Domains:

Templates:

Name: Church
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: Church

---

ID: School
Name: School
Domains:

Templates:

Name: School
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: School

---

ID: I
Name: Industrial
Domains:

Templates:

Name: Industrial
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: I

---

ID: ParkingLot
Name: Parking Lot
Domains:

Templates:

Name: Parking Lot
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: ParkingLot

---

ID: VacantLot
Name: Vacant Lot
Domains:

Templates:

Name: Vacant Lot
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• AddType: VacantLot

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/28/2026 9:45:40 PM

Schema Last Edit Date: 7/28/2026 9:45:40 PM

Data Last Edit Date: 7/28/2026 9:45:40 PM

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