View In:   ArcGIS Online Map Viewer

Name: Site Address Points

Display Field: FULLNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Site address points represent the location of site or service delivery addresses assigned by local governments.

Service Item Id: eb9871d99e5040dc9f1de2be0d1b845b

Copyright Text: NENA, ECD

Default Visibility: true

MaxRecordCount: 32000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 4514

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: -17463800
YMin: -46132600
XMax: 2828345.94160023
YMax: 739204.664606254
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [0, 0, 0, 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: System-maintained ObjectID )
• OIRID ( type: esriFieldTypeString, alias: OIRID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OIRID )
• 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 )
• SEGID ( type: esriFieldTypeDouble, alias: SEGID, editable: true, nullable: true, defaultValue: null, modelName: SEGID )
• TSSEGID ( type: esriFieldTypeDouble, alias: TSSEGID, editable: true, nullable: true, defaultValue: null, modelName: TSSEGID )
• MSAGLINK ( type: esriFieldTypeInteger, alias: MSAGLINK, editable: true, nullable: true, defaultValue: null, modelName: MSAGLINK )
• SIDE ( type: esriFieldTypeSmallInteger, alias: Side, editable: true, nullable: true, defaultValue: null, modelName: SIDE )
• 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 )
• LHN ( type: esriFieldTypeString, alias: LHN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LHN )
• 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] , [BSMT: Basement] , [BLDG: Building] , ...22 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] , [BSMT: Basement] , [BLDG: Building] , ...22 more... )
• ALTUNITID ( type: esriFieldTypeString, alias: Alternate Address Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ALTUNITID )
• BUILDING ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 16, defaultValue: null, modelName: BUILDING )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 12, defaultValue: null, modelName: FLOOR )
• 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 )
• ALTFULLRDNAM ( type: esriFieldTypeString, alias: Alt Full Road Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ALTFULLRDNAM )
• 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: null, modelName: MUNICIPALITY )
• MSAG ( type: esriFieldTypeString, alias: MSAG Community, editable: true, nullable: true, length: 35, defaultValue: null, modelName: MSAG )
• ESN ( type: esriFieldTypeString, alias: Emergency Service Number, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ESN )
• ZIPCODE ( type: esriFieldTypeString, alias: Zip Code, editable: true, nullable: true, length: 10, defaultValue: null, modelName: ZIPCODE )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 30, defaultValue: HAMBLEN, modelName: COUNTY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 16, defaultValue: TN, modelName: STATE )
• SUBDIV ( type: esriFieldTypeString, alias: Subdivision, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBDIV )
• PSAP ( type: esriFieldTypeString, alias: Public Safety Answering Point, editable: true, nullable: true, length: 4, defaultValue: 6261, modelName: PSAP )
• 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: [500: Agricultural (General)] , [1001: Airport (General)] , [1002: Airport Hanger] , ...107 more... )
• POINTTYPE ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 30, defaultValue: null, modelName: POINTTYPE , Coded Values: [Building: Building] , [Parcel: Parcel] , [Unit, Condo, Office or Suite: Unit, Condo, Office or Suite] , ...3 more... )
• CAPTUREMETH ( type: esriFieldTypeString, alias: Capture Method, editable: true, nullable: true, length: 30, defaultValue: Placed on Map, modelName: CAPTUREMETH , Coded Values: [Geocoded: Geocoded] , [GPS: GPS] , [Site Visit: Site Visit] , ...2 more... )
• FIELDNOTE ( type: esriFieldTypeString, alias: Field Note, editable: true, nullable: true, length: 70, defaultValue: null, modelName: FIELDNOTE )
• SOURCE ( type: esriFieldTypeString, alias: Source, editable: true, nullable: true, length: 40, defaultValue: 3, modelName: SOURCE , Coded Values: [1: Address resolved using reliable external source] , [3: Located address from Road Centerline] , [0: Field Verified by DDTi staff during collection process] , ...1 more... )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STATUS , Coded Values: [Current: Current] , [Pending: Pending] , [Retired: Retired] , ...3 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 )
• 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 )
• 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 )
• SWHOTSPOT ( type: esriFieldTypeString, alias: Stormwater Hot Spot, editable: true, nullable: true, length: 10, defaultValue: No, modelName: SWHOTSPOT , Coded Values: [Yes: Yes] , [No: No] )
• GISLINK ( type: esriFieldTypeString, alias: GISLINK, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GISLINK )
• LAT ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LAT )
• LON ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LON )
• Y_SP ( type: esriFieldTypeDouble, alias: Y Coordinate-SP, editable: true, nullable: true, defaultValue: null, modelName: Y_SP )
• X_SP ( type: esriFieldTypeDouble, alias: X Coordinate-SP, editable: true, nullable: true, defaultValue: null, modelName: X_SP )
• CAD_Address ( type: esriFieldTypeString, alias: CAD_Address, editable: true, nullable: true, length: 250, defaultValue: null, modelName: CAD_Address )
• LocationID ( type: esriFieldTypeString, alias: LocationID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: LocationID )
• SEG_SIDE ( type: esriFieldTypeString, alias: Segment Side, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SEG_SIDE , Coded Values: [L: Left] , [R: Right] , [U: Unknown] )
• R_SEGID ( type: esriFieldTypeString, alias: Route Segment ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: R_SEGID )
• A_SEGID ( type: esriFieldTypeString, alias: Address Segment ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: A_SEGID )
• STNUM_H ( type: esriFieldTypeString, alias: Street Number High, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUM_H )
• STNUM_L ( type: esriFieldTypeString, alias: Street Number Low, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUM_L )
• PREDIR ( type: esriFieldTypeString, alias: Prefix Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• PRETYPE ( type: esriFieldTypeString, alias: Prefix Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PRETYPE , Coded Values: [AVE: Avenue] , [ALY: Alley] , [ANX: Anex] , ...207 more... )
• NAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 40, defaultValue: null, modelName: NAME )
• TYPE ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: TYPE , Coded Values: [AVE: Avenue] , [ALY: Alley] , [ANX: Anex] , ...207 more... )
• SUFDIR ( type: esriFieldTypeString, alias: Suffix Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFDIR , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• POSTMOD ( type: esriFieldTypeString, alias: Post Modifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTMOD )
• ADDR_ESN ( type: esriFieldTypeString, alias: Address with ESN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDR_ESN )
• NG_Status ( type: esriFieldTypeSmallInteger, alias: NG911 Status, editable: true, nullable: true, defaultValue: 730, modelName: NG_Status , Coded Values: [730: ACTIVE] , [734: PROPOSED] , [736: POTENTIAL] , ...1 more... )
• STRUCDESC ( type: esriFieldTypeString, alias: Structure Description, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STRUCDESC )

Templates:

• Name: Site Address Points
  Description:
  Prototype:
  NG_Status: 730
  ADDR_ESN: null
  OIRID: null
  SITEADDID: null
  ADDPTKEY: null
  SEGID: null
  TSSEGID: null
  MSAGLINK: null
  SIDE: null
  PREADDRNUM: null
  ADDRNUMSUF: null
  ADDRNUM: null
  LHN: null
  ADDRRANGE: null
  UNITTYPE: null
  UNITID: null
  ALTUNITTYPE: null
  ALTUNITID: null
  BUILDING: null
  FLOOR: null
  FULLNAME: null
  FULLADDR: null
  ALTFULLRDNAM: null
  PLACENAME: null
  MUNICIPALITY: null
  MSAG: null
  ESN: null
  ZIPCODE: null
  COUNTY: HAMBLEN
  STATE: TN
  SUBDIV: null
  PSAP: 6261
  USNGCOORD: null
  ADDRCLASS: null
  POINTTYPE: null
  CAPTUREMETH: Placed on Map
  FIELDNOTE: null
  SOURCE: 3
  STATUS: null
  LASTUPDATE: null
  LASTEDITOR: null
  STRUCDESC: null
  POSTMOD: null
  SUFDIR: null
  TYPE: null
  NAME: null
  SWHOTSPOT: No
  GISLINK: null
  LAT: null
  LON: null
  Y_SP: null
  X_SP: null
  CAD_Address: null
  LocationID: null
  SEG_SIDE: null
  R_SEGID: null
  A_SEGID: null
  STNUM_H: null
  STNUM_L: null
  PREDIR: null
  PRETYPE: null
  
  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