Name: Address Points

Display Field: COMPLEXNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: St. Louis County GIS Service Center

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10100855.0901526
YMin: 4635537.79911896
XMax: -10033117.8164865
YMax: 4704623.89941799
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[150,163,79,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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• LOCATOR (type: esriFieldTypeString, alias: LOCATOR, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PARENT_LOC (type: esriFieldTypeString, alias: PARENT_LOC, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• ADRNO (type: esriFieldTypeDouble, alias: ADRNO, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ADRDIR (type: esriFieldTypeString, alias: ADRDIR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [E: E], [W: W], [N: N], ... 2 more ...)
• ADRSTR (type: esriFieldTypeString, alias: ADRSTR, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• ADRSUF (type: esriFieldTypeString, alias: ADRSUF, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• UNITDESC (type: esriFieldTypeString, alias: UNITDESC, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [APT: APARTMENT], [UNIT: UNIT], [SUITE: SUITE], ... 7 more ...)
• UNITNO (type: esriFieldTypeString, alias: UNITNO, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MAILINGCITY (type: esriFieldTypeString, alias: MAILINGCITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ZIPCODE (type: esriFieldTypeString, alias: ZIPCODE, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• MUNI (type: esriFieldTypeString, alias: MUNI, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [BAL: BALLWIN], [BLV: BELLA VILLA], [BFN: BELLEFONTAINE NEIGHBORS], ... 92 more ...)
• MUNICODE (type: esriFieldTypeString, alias: MUNICODE, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [093: BALLWIN], [002: BELLA VILLA], [088: BELLEFONTAINE NEIGHBORS], ... 91 more ...)
• STATUS (type: esriFieldTypeString, alias: STATUS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Current: Current Address], [Preliminary: Preliminary Address], [Historical: Historical Address])
• MAILTYPE (type: esriFieldTypeString, alias: MAILTYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Mailing: Mailing Address], [Non-Mailing: Non-Mailing Address])
• ADDRTYPE (type: esriFieldTypeString, alias: ADDRTYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Building: Building Address], [Parcel: Parcel Address])
• COMPLEXNAME (type: esriFieldTypeString, alias: COMPLEXNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• COMPLEXTYPE (type: esriFieldTypeString, alias: COMPLEXTYPE, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Apts: Apartments], [Condos: Condos], [Park: Park], ... 5 more ...)
• BUSINESSNAME (type: esriFieldTypeString, alias: BUSINESSNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUILDINGNAME (type: esriFieldTypeString, alias: BUILDINGNAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FLOOR (type: esriFieldTypeString, alias: FLOOR, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• TRASH_DISTRICT (type: esriFieldTypeSmallInteger, alias: TRASH_DISTRICT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRASH_OPTOUT (type: esriFieldTypeString, alias: TRASH_OPTOUT, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true, Coded Values: [Opt_Out: Opt_Out])
• TRASH_ELIGIBILITY (type: esriFieldTypeString, alias: TRASH_ELIGIBILITY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Eligible: Eligible], [Not Eligible: Not Eligible], [Muny: Muny])
• SECONDARY (type: esriFieldTypeString, alias: SECONDARY, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• STATE (type: esriFieldTypeString, alias: STATE, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• PROP_ADD (type: esriFieldTypeString, alias: PROP_ADD, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PARIDADDRUNIT (type: esriFieldTypeString, alias: PARIDADDRUNIT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FULL_NAME (type: esriFieldTypeString, alias: FULL_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• DATE_PUBLIC (type: esriFieldTypeDate, alias: DATE_PUBLIC, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• FULL_ADDRESS (type: esriFieldTypeString, alias: FULL_ADDRESS, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• COUNTY (type: esriFieldTypeString, alias: COUNTY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [FRANKLIN COUNTY: FRANKLIN COUNTY], [JEFFERSON COUNTY: JEFFERSON COUNTY], [SAINT LOUIS COUNTY: SAINT LOUIS COUNTY], ... 5 more ...)
• MSAG_COMMUNITY_NAME (type: esriFieldTypeString, alias: MSAG_COMMUNITY_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [BALLWIN: BALLWIN], [BELLA VILLA: BELLA VILLA], [BELLEFONTAINE NEIGHBORS: BELLEFONTAINE NEIGHBORS], ... 93 more ...)
• LOTNUM (type: esriFieldTypeString, alias: LOTNUM, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• POINT_X (type: esriFieldTypeDouble, alias: POINT_X, SQL Type: sqlTypeOther, nullable: true, editable: true)
• POINT_Y (type: esriFieldTypeDouble, alias: POINT_Y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

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

Attributes:

• STATE: MO
• COUNTY: SAINT LOUIS COUNTY
• MSAG_COMMUNITY_NAME: ST LOUIS COUNTY

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/13/2023 7:13:10 PM

Schema Last Edit Date: 4/13/2023 7:13:10 PM

Data Last Edit Date: 4/13/2023 7:13:10 PM

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