Name: ADDRESS_POINT

Display Field: FullName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: This is a Feature of known and addressable structures in the Ponca City PSAP in Kay County OK. The remediated dataset was completed [Date Placeholder] structures were assigned addresses based on geocoding from the driveway. Points were placed on visible structures. City addresses were generated from a variety of sources. See attribute InitSource for source information.

Copyright Text: Data remediated by Surveying and Mapping LLC

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: -97.209972105
YMin: 36.5944129150001
XMax: -96.7527953109999
YMax: 36.9988188310001
Spatial Reference: 4326 (4326)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"b8454b2c032e9b331723efeb24e04ac4","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAIAAAADCAYAAAC56t6BAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAADklEQVQImWNhgAIWDAYAAPMADUvyQqQAAAAASUVORK5CYII=","contentType":"image/png","width":1,"height":2,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"$feature.Address+textformatting.newline+$feature.Street","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":1500,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[104,104,104,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":"Swis721 Ex BT","size":6,"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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• DiscrpAgID (type: esriFieldTypeString, alias: DiscrpAgID, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [cog.acog.ok.gov: cog.acog.ok.gov], [cog.ascog.ok.gov: cog.ascog.ok.gov], [cog.coedd.ok.gov: cog.coedd.ok.gov], ... 128 more ...)
• NGUID_ADD (type: esriFieldTypeString, alias: NGUID_ADD, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Agency_ID (type: esriFieldTypeString, alias: Agency_ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [cog.acog.ok.gov: cog.acog.ok.gov], [cog.ascog.ok.gov: cog.ascog.ok.gov], [cog.coedd.ok.gov: cog.coedd.ok.gov], ... 128 more ...)
• FullAddr (type: esriFieldTypeString, alias: FullAddr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FullName (type: esriFieldTypeString, alias: FullName, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Label (type: esriFieldTypeString, alias: Label, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• AddPre (type: esriFieldTypeString, alias: AddPre, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Address (type: esriFieldTypeInteger, alias: Address, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddSuf (type: esriFieldTypeString, alias: AddSuf, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• PreMod (type: esriFieldTypeString, alias: PreMod, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• PreDir (type: esriFieldTypeString, alias: PreDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [NORTH: NORTH], [SOUTH: SOUTH], [EAST: EAST], ... 5 more ...)
• PreType (type: esriFieldTypeString, alias: PreType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ALLEY: ALLEY], [ANNEX: ANNEX], [ARCADE: ARCADE], ... 199 more ...)
• PreTypeSep (type: esriFieldTypeString, alias: PreTypeSep, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [OF THE: OF THE], [AT: AT], [DE LAS: DE LAS], ... 5 more ...)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• StreetType (type: esriFieldTypeString, alias: StreetType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [ALLEY: ALLEY], [ANNEX: ANNEX], [ARCADE: ARCADE], ... 199 more ...)
• SufDir (type: esriFieldTypeString, alias: SufDir, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [NORTH: NORTH], [SOUTH: SOUTH], [EAST: EAST], ... 5 more ...)
• SufMod (type: esriFieldTypeString, alias: SufMod, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Country (type: esriFieldTypeString, alias: Country, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [US: UNITED STATES OF AMERICA])
• State (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [OK: OKLAHOMA], [TX: TEXAS], [CO: COLORADO], ... 4 more ...)
• County (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [ADAIR COUNTY: ADAIR COUNTY], [ALFALFA COUNTY: ALFALFA COUNTY], [ATOKA COUNTY: ATOKA COUNTY], ... 117 more ...)
• City (type: esriFieldTypeString, alias: City, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• UnincComm (type: esriFieldTypeString, alias: UnincComm, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• NbrhdComm (type: esriFieldTypeString, alias: NbrhdComm, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• ESN (type: esriFieldTypeString, alias: ESN, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• PSAP (type: esriFieldTypeString, alias: PSAP, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• MSAGComm (type: esriFieldTypeString, alias: MSAGComm, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• PostComm (type: esriFieldTypeString, alias: PostComm, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• Zipcode (type: esriFieldTypeString, alias: Zipcode, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
• Zipcode4 (type: esriFieldTypeString, alias: Zipcode4, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LandmkName (type: esriFieldTypeString, alias: LandmkName, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• AddtnlLoc (type: esriFieldTypeString, alias: AddtnlLoc, SQL Type: sqlTypeOther, length: 225, nullable: true, editable: true)
• BldgName (type: esriFieldTypeString, alias: BldgName, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Floor (type: esriFieldTypeString, alias: Floor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• BldgUnit (type: esriFieldTypeString, alias: BldgUnit, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Room (type: esriFieldTypeString, alias: Room, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• Seat (type: esriFieldTypeString, alias: Seat, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• GrpQuarter (type: esriFieldTypeString, alias: GrpQuarter, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• OccupTime (type: esriFieldTypeString, alias: OccupTime, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• StrmSheltr (type: esriFieldTypeString, alias: StrmSheltr, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [ABOVE GROUND IN STRUCTURE: ABOVE GROUND IN STRUCTURE], [ABOVE GROUND OUTSIDE: ABOVE GROUND OUTSIDE], [BELOW GROUND IN STRUCTURE: BELOW GROUND IN STRUCTURE], ... 1 more ...)
• Basement (type: esriFieldTypeString, alias: Basement, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• PlaceType (type: esriFieldTypeString, alias: PlaceType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [AIRCRAFT: AIRCRAFT], [AIRPORT: AIRPORT], [ARENA: ARENA], ... 41 more ...)
• Placement (type: esriFieldTypeString, alias: Placement, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [GEOCODING: GEOCODING], [PARCEL: PARCEL], [PROPERTY ACCESS: PROPERTY ACCESS], ... 3 more ...)
• MilePost (type: esriFieldTypeString, alias: MilePost, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• Longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddDataUri (type: esriFieldTypeString, alias: AddDataUri, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• InitiSrce (type: esriFieldTypeString, alias: InitiSrce, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• InitiDate (type: esriFieldTypeDate, alias: InitiDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RevEditor (type: esriFieldTypeString, alias: RevEditor, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: false)
• RevDate (type: esriFieldTypeDate, alias: RevDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• EffectDate (type: esriFieldTypeDate, alias: EffectDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ExpireDate (type: esriFieldTypeDate, alias: ExpireDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Comment (type: esriFieldTypeString, alias: Comment, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LgcyAdd (type: esriFieldTypeString, alias: LgcyAdd, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• LgcyPreDir (type: esriFieldTypeString, alias: LgcyPreDir, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: NORTH], [S: SOUTH], [E: EAST], ... 5 more ...)
• LgcyStreet (type: esriFieldTypeString, alias: LgcyStreet, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• LgcyType (type: esriFieldTypeString, alias: LgcyType, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true, Coded Values: [ALY: ALLEY], [ANNX: ANNEX], [ARC: ARCADE], ... 199 more ...)
• LgcySufDir (type: esriFieldTypeString, alias: LgcySufDir, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true, Coded Values: [N: NORTH], [S: SOUTH], [E: EAST], ... 5 more ...)
• SUBMIT (type: esriFieldTypeString, alias: SUBMIT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Y], [N: N])
• RCLMatch (type: esriFieldTypeString, alias: RCLMatch, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• RCLSide (type: esriFieldTypeString, alias: RCLSide, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [L: L], [R: R], [N: N])
• SAM_Notes (type: esriFieldTypeString, alias: SAM_Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• Adjusted (type: esriFieldTypeString, alias: Adjusted, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• ForReview (type: esriFieldTypeString, alias: ForReview, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• Kim_Notes (type: esriFieldTypeString, alias: Kim_Notes, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• labelCheck (type: esriFieldTypeString, alias: labelCheck, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• TN_JoinAdd (type: esriFieldTypeString, alias: TN_JoinAdd, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)

Templates:

Name: ADDRESS_POINT
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Country: US
• State: OK
• SUBMIT: Y

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/17/2025 3:04:26 PM

Schema Last Edit Date: 2/17/2025 3:04:26 PM

Data Last Edit Date: 2/17/2025 3:04:26 PM

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