View In:   ArcGIS Online Map Viewer

Name: NG911 Address Point

Display Field: FullName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 52d9efdd15f94e4ab5713e7ac4e9933b

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4513.988705

Max Scale: 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.0863088129870478E7
YMin: 4203510.579017031
XMax: -1.0844226532166941E7
YMax: 4215349.658566446
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [40, 109, 155, 0]
Size: 1.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 0] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:
Label Placement: esriServerPointLabelPlacementCenterCenter
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [255, 255, 255, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 8
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 2256.994353
Max. Scale: 0.0

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

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• DiscrpAgID ( type: esriFieldTypeString, alias: DiscrpAgID, editable: true, nullable: true, length: 75, defaultValue: cog.acog.ok.gov, modelName: DiscrpAgID , Coded Values: [psap.5578.ok.gov: psap.5578.ok.gov] , [psap.5603.ok.gov: psap.5603.ok.gov] , [psap.5579.ok.gov: psap.5579.ok.gov] , ...142 more... )
• NGUID_ADD ( type: esriFieldTypeString, alias: NGUID_ADD, editable: true, nullable: true, length: 254, defaultValue: null, modelName: NGUID_ADD )
• Agency_ID ( type: esriFieldTypeString, alias: Agency_ID, editable: true, nullable: true, length: 100, defaultValue: psap.5680.ok.gov, modelName: Agency_ID , Coded Values: [psap.5578.ok.gov: psap.5578.ok.gov] , [psap.5603.ok.gov: psap.5603.ok.gov] , [psap.5579.ok.gov: psap.5579.ok.gov] , ...142 more... )
• FullAddr ( type: esriFieldTypeString, alias: FullAddr, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FullAddr )
• FullName ( type: esriFieldTypeString, alias: FullName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: FullName )
• Label ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Label )
• AddPre ( type: esriFieldTypeString, alias: AddPre, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddPre )
• Address ( type: esriFieldTypeInteger, alias: Address, editable: true, nullable: true, defaultValue: null, modelName: Address )
• AddSuf ( type: esriFieldTypeString, alias: AddSuf, editable: true, nullable: true, length: 15, defaultValue: null, modelName: AddSuf )
• PreMod ( type: esriFieldTypeString, alias: PreMod, editable: true, nullable: true, length: 15, defaultValue: null, modelName: PreMod )
• PreDir ( type: esriFieldTypeString, alias: PreDir, editable: true, nullable: true, length: 9, defaultValue: null, modelName: PreDir , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...5 more... )
• PreType ( type: esriFieldTypeString, alias: PreType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PreType , Coded Values: [ALLEY: ALLEY] , [ANNEX: ANNEX] , [ARCADE: ARCADE] , ...199 more... )
• PreTypeSep ( type: esriFieldTypeString, alias: PreTypeSep, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PreTypeSep , Coded Values: [OF THE: OF THE] , [AT: AT] , [DE LAS: DE LAS] , ...6 more... )
• Street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 60, defaultValue: null, modelName: Street )
• StreetType ( type: esriFieldTypeString, alias: StreetType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: StreetType , Coded Values: [ALLEY: ALLEY] , [ANNEX: ANNEX] , [ARCADE: ARCADE] , ...199 more... )
• SufDir ( type: esriFieldTypeString, alias: SufDir, editable: true, nullable: true, length: 9, defaultValue: null, modelName: SufDir , Coded Values: [NORTH: NORTH] , [SOUTH: SOUTH] , [EAST: EAST] , ...5 more... )
• SufMod ( type: esriFieldTypeString, alias: SufMod, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SufMod )
• Country ( type: esriFieldTypeString, alias: Country, editable: true, nullable: true, length: 2, defaultValue: US, modelName: Country , Coded Values: [US: UNITED STATES OF AMERICA] )
• State ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: OK, modelName: State , Coded Values: [OK: OKLAHOMA] , [TX: TEXAS] , [CO: COLORADO] , ...4 more... )
• County ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 40, defaultValue: CLEVELAND COUNTY, modelName: County , Coded Values: [ADAIR COUNTY: ADAIR COUNTY] , [ALFALFA COUNTY: ALFALFA COUNTY] , [ATOKA COUNTY: ATOKA COUNTY] , ...117 more... )
• City ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 100, defaultValue: MOORE, modelName: City )
• UnincComm ( type: esriFieldTypeString, alias: UnincComm, editable: true, nullable: true, length: 100, defaultValue: null, modelName: UnincComm )
• NbrhdComm ( type: esriFieldTypeString, alias: NbrhdComm, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NbrhdComm )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• PSAP ( type: esriFieldTypeString, alias: PSAP, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PSAP )
• MSAGComm ( type: esriFieldTypeString, alias: MSAGComm, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MSAGComm )
• PostComm ( type: esriFieldTypeString, alias: PostComm, editable: true, nullable: true, length: 40, defaultValue: null, modelName: PostComm )
• Zipcode ( type: esriFieldTypeString, alias: Zipcode, editable: true, nullable: true, length: 7, defaultValue: null, modelName: Zipcode )
• Zipcode4 ( type: esriFieldTypeString, alias: Zipcode4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Zipcode4 )
• LandmkName ( type: esriFieldTypeString, alias: LandmkName, editable: true, nullable: true, length: 150, defaultValue: null, modelName: LandmkName )
• AddtnlLoc ( type: esriFieldTypeString, alias: AddtnlLoc, editable: true, nullable: true, length: 225, defaultValue: null, modelName: AddtnlLoc )
• BldgName ( type: esriFieldTypeString, alias: BldgName, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BldgName )
• Floor ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Floor )
• BldgUnit ( type: esriFieldTypeString, alias: BldgUnit, editable: true, nullable: true, length: 75, defaultValue: null, modelName: BldgUnit )
• Room ( type: esriFieldTypeString, alias: Room, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Room )
• Seat ( type: esriFieldTypeString, alias: Seat, editable: true, nullable: true, length: 75, defaultValue: null, modelName: Seat )
• GrpQuarter ( type: esriFieldTypeString, alias: GrpQuarter, editable: true, nullable: true, length: 1, defaultValue: null, modelName: GrpQuarter , Coded Values: [Y: Y] , [N: N] )
• OccupTime ( type: esriFieldTypeString, alias: OccupTime, editable: true, nullable: true, length: 50, defaultValue: null, modelName: OccupTime )
• StrmSheltr ( type: esriFieldTypeString, alias: StrmSheltr, editable: true, nullable: true, length: 25, defaultValue: null, modelName: StrmSheltr , 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, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Basement , Coded Values: [Y: Y] , [N: N] )
• PlaceType ( type: esriFieldTypeString, alias: PlaceType, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PlaceType , Coded Values: [AIRCRAFT: AIRCRAFT] , [AIRPORT: AIRPORT] , [ARENA: ARENA] , ...41 more... )
• Placement ( type: esriFieldTypeString, alias: Placement, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Placement , Coded Values: [GEOCODING: GEOCODING] , [PARCEL: PARCEL] , [PROPERTY ACCESS: PROPERTY ACCESS] , ...3 more... )
• MilePost ( type: esriFieldTypeString, alias: MilePost, editable: true, nullable: true, length: 150, defaultValue: null, modelName: MilePost )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: Longitude )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: Latitude )
• Elevation ( type: esriFieldTypeSmallInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• AddDataURI ( type: esriFieldTypeString, alias: AddDataURI, editable: true, nullable: true, length: 254, defaultValue: null, modelName: AddDataURI )
• InitiSrce ( type: esriFieldTypeString, alias: InitiSrce, editable: true, nullable: true, length: 75, defaultValue: CITY OF MOORE, modelName: InitiSrce )
• InitiDate ( type: esriFieldTypeDate, alias: InitiDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InitiDate )
• RevEditor ( type: esriFieldTypeString, alias: RevEditor, editable: true, nullable: true, length: 75, defaultValue: null, modelName: RevEditor )
• RevDate ( type: esriFieldTypeDate, alias: RevDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RevDate )
• EffectDate ( type: esriFieldTypeDate, alias: EffectDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: EffectDate )
• ExpireDate ( type: esriFieldTypeDate, alias: ExpireDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ExpireDate )
• Comment ( type: esriFieldTypeString, alias: Comment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: Comment )
• LgcyAdd ( type: esriFieldTypeString, alias: LgcyAdd, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LgcyAdd )
• LgcyPreDir ( type: esriFieldTypeString, alias: LgcyPreDir, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LgcyPreDir , Coded Values: [N: NORTH] , [S: SOUTH] , [E: EAST] , ...5 more... )
• LgcyStreet ( type: esriFieldTypeString, alias: LgcyStreet, editable: true, nullable: true, length: 75, defaultValue: null, modelName: LgcyStreet )
• LgcyType ( type: esriFieldTypeString, alias: LgcyType, editable: true, nullable: true, length: 4, defaultValue: null, modelName: LgcyType , Coded Values: [ALY: ALLEY] , [ANNX: ANNEX] , [ARC: ARCADE] , ...199 more... )
• LgcySufDir ( type: esriFieldTypeString, alias: LgcySufDir, editable: true, nullable: true, length: 2, defaultValue: null, modelName: LgcySufDir , Coded Values: [N: NORTH] , [S: SOUTH] , [E: EAST] , ...5 more... )
• SUBMIT ( type: esriFieldTypeString, alias: SUBMIT, editable: true, nullable: true, length: 1, defaultValue: Y, modelName: SUBMIT , Coded Values: [Y: Y] , [N: N] )
• RCLMatch ( type: esriFieldTypeString, alias: RCLMatch, editable: true, nullable: true, length: 254, defaultValue: null, modelName: RCLMatch )
• RCLSide ( type: esriFieldTypeString, alias: RCLSide, editable: true, nullable: true, length: 1, defaultValue: null, modelName: RCLSide , Coded Values: [R: R] , [L: L] , [N: N] )
• SITEADDID ( type: esriFieldTypeString, alias: Site Address ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: SITEADDID )
• ADDRCLASS ( type: esriFieldTypeInteger, alias: Description, editable: true, nullable: true, defaultValue: null, modelName: ADDRCLASS )
• PLACENAME ( type: esriFieldTypeString, alias: Place Name, editable: true, nullable: true, length: 250, defaultValue: null, modelName: PLACENAME )
• POINTTYPE ( type: esriFieldTypeString, alias: Address Point Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE )
• CAPTUREMETH ( type: esriFieldTypeString, alias: Capture Method, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CAPTUREMETH )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS )
• nguid ( type: esriFieldTypeString, alias: nguid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: nguid )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• 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 )
• 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 )
• 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 )
• ALTUNITID ( type: esriFieldTypeString, alias: Alternate Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITID )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MUNICIPALITY )
• 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 )
• 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 )
• CREATEDBY ( type: esriFieldTypeString, alias: Created By, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATEDBY )
• CREATEDDATE ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CREATEDDATE )
• FULLNAME_ORIGINAL ( type: esriFieldTypeString, alias: Full Road Name_ORIGINAL, editable: true, nullable: true, length: 125, defaultValue: null, modelName: FULLNAME_ORIGINAL )
• FULLADDR_ORGINAL ( type: esriFieldTypeString, alias: Full Address_ORGINAL, editable: true, nullable: true, length: 250, defaultValue: null, modelName: FULLADDR_ORGINAL )
• ZIPCODE_ORIGINAL ( type: esriFieldTypeString, alias: Postal Zip 5_ORIGINAL, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ZIPCODE_ORIGINAL )
• ESN_ORIGINAL ( type: esriFieldTypeString, alias: Emergency Service Number_ORIGINAL, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN_ORIGINAL )
• PSAP_ORIGINAL ( type: esriFieldTypeString, alias: Public Safety Answering Point_ORIGINAL, editable: true, nullable: true, length: 4, defaultValue: null, modelName: PSAP_ORIGINAL )
• 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 )
• VALIDATIONSTATUS ( type: esriFieldTypeSmallInteger, alias: Validation status, editable: true, nullable: true, defaultValue: 6, modelName: VALIDATIONSTATUS , Coded Values: [0: No calculation required, no validation required, no error] , [1: No calculation required, no validation required, has error(s)] , [2: No calculation required, validation required, no error] , ...5 more... )

Templates:

• Name: N
  Description:
  Prototype:
  SUBMIT: N
  
  Drawing Tool: esriFeatureEditToolPoint
• Name: Y
  Description:
  Prototype:
  SUBMIT: Y
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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 Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata