View In:   ArcGIS Online Map Viewer

Name: Sumner County E911 Addresses

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1b006f3293e0407cb6b79becf876a2d2

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

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: 1790647.7591413856
YMin: 712762.4419889003
XMax: 1873204.5608909726
YMax: 774846.1934773177
Spatial Reference: 102736  (2274)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [83, 63, 150, 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

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: OBJECTID )
• OIRID ( type: esriFieldTypeString, alias: GIS Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OIRID )
• R_SEGID ( type: esriFieldTypeString, alias: Route Segment Identifier, editable: true, nullable: true, length: 25, defaultValue: null, modelName: R_SEGID )
• A_SEGID ( type: esriFieldTypeString, alias: Address Segment Identifier, editable: true, nullable: true, length: 25, defaultValue: null, modelName: A_SEGID )
• SEG_SIDE ( type: esriFieldTypeString, alias: Segment Side, editable: true, nullable: true, length: 1, defaultValue: null, modelName: SEG_SIDE )
• GISLINK ( type: esriFieldTypeString, alias: Parcel Link Identifier, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GISLINK )
• STRUCTYPE ( type: esriFieldTypeSmallInteger, alias: Structure Type, editable: true, nullable: true, defaultValue: 1, modelName: STRUCTYPE )
• STRUCDESC ( type: esriFieldTypeString, alias: Structure Description, editable: true, nullable: true, length: 30, defaultValue: null, modelName: STRUCDESC )
• 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 )
• STNUM ( type: esriFieldTypeString, alias: Street Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUM )
• STNUMSUF ( type: esriFieldTypeString, alias: Street Number Suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STNUMSUF )
• BUILDING ( type: esriFieldTypeString, alias: Building, editable: true, nullable: true, length: 35, defaultValue: null, modelName: BUILDING )
• FLOOR ( type: esriFieldTypeString, alias: Floor, editable: true, nullable: true, length: 10, defaultValue: null, modelName: FLOOR )
• UNIT_TYPE ( type: esriFieldTypeString, alias: Unit Type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: UNIT_TYPE )
• UNIT_NUM ( type: esriFieldTypeString, alias: Unit Number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: UNIT_NUM )
• PREDIR ( type: esriFieldTypeString, alias: Prefix Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: PREDIR )
• PRETYPE ( type: esriFieldTypeString, alias: Prefix Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PRETYPE )
• 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 )
• SUFDIR ( type: esriFieldTypeString, alias: Suffix Directional, editable: true, nullable: true, length: 2, defaultValue: null, modelName: SUFDIR )
• POSTMOD ( type: esriFieldTypeString, alias: Post Modifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: POSTMOD )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDRESS )
• ADDR_ESN ( type: esriFieldTypeString, alias: Address with ESN, editable: true, nullable: true, length: 100, defaultValue: null, modelName: ADDR_ESN )
• LABEL ( type: esriFieldTypeString, alias: Label, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LABEL )
• SUBNAME ( type: esriFieldTypeString, alias: Subdivision Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBNAME )
• VANITY ( type: esriFieldTypeString, alias: Vanity, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VANITY )
• ZIP ( type: esriFieldTypeString, alias: ZIP, editable: true, nullable: true, length: 5, defaultValue: null, modelName: ZIP )
• ZIP4 ( type: esriFieldTypeString, alias: ZIP+4, editable: true, nullable: true, length: 4, defaultValue: null, modelName: ZIP4 )
• ESN ( type: esriFieldTypeString, alias: ESN, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ESN )
• CITY ( type: esriFieldTypeString, alias: MSAG Community Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CITY )
• COUNTY ( type: esriFieldTypeString, alias: County, editable: true, nullable: true, length: 30, defaultValue: SUMNER, modelName: COUNTY )
• STATE ( type: esriFieldTypeString, alias: State, editable: true, nullable: true, length: 2, defaultValue: TN, modelName: STATE )
• LON ( type: esriFieldTypeString, alias: Longitude, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LON )
• LAT ( type: esriFieldTypeString, alias: Latitude, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LAT )
• X_SP ( type: esriFieldTypeDouble, alias: X Coordinate, editable: true, nullable: true, defaultValue: null, modelName: X_SP )
• Y_SP ( type: esriFieldTypeDouble, alias: Y Coordinate, editable: true, nullable: true, defaultValue: null, modelName: Y_SP )
• Z_VAL ( type: esriFieldTypeInteger, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Z_VAL )
• GPSDATE ( type: esriFieldTypeDate, alias: Initial Edit Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• ADDRAUTH ( type: esriFieldTypeString, alias: Addressing Authority, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRAUTH )
• SOURCE ( type: esriFieldTypeSmallInteger, alias: Derived Source, editable: true, nullable: true, defaultValue: null, modelName: SOURCE )
• EDITOR ( type: esriFieldTypeString, alias: Editor, editable: true, nullable: true, length: 10, defaultValue: null, modelName: EDITOR )
• GEOMOD ( type: esriFieldTypeString, alias: Geometry Modification Type, editable: true, nullable: true, length: 75, defaultValue: null, modelName: GEOMOD )
• GEOSRCE ( type: esriFieldTypeString, alias: Geometry Modification Derived Source, editable: true, nullable: true, length: 45, defaultValue: null, modelName: GEOSRCE )
• GEODATE ( type: esriFieldTypeDate, alias: Geometry Modification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GEODATE )
• ATTMOD ( type: esriFieldTypeString, alias: Attribute Modification, editable: true, nullable: true, length: 75, defaultValue: null, modelName: ATTMOD )
• ATTSRCE ( type: esriFieldTypeString, alias: Attribute Modification Derived Source, editable: true, nullable: true, length: 45, defaultValue: null, modelName: ATTSRCE )
• ATTDATE ( type: esriFieldTypeDate, alias: Attribute Modification Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ATTDATE )
• STATUS ( type: esriFieldTypeSmallInteger, alias: Lifecycle Status, editable: true, nullable: true, defaultValue: 730, modelName: STATUS )
• DELNOTES ( type: esriFieldTypeString, alias: Delete Notes, editable: true, nullable: true, length: 75, defaultValue: null, modelName: DELNOTES )
• NOTES ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NOTES )
• LOCATION_NAME ( type: esriFieldTypeString, alias: Location Name, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LOCATION_NAME )
• PSAP ( type: esriFieldTypeString, alias: PSAP, editable: true, nullable: true, length: 4, defaultValue: SECC, modelName: PSAP )
• VOIPESN ( type: esriFieldTypeString, alias: VoIP ESN, editable: true, nullable: true, length: 3, defaultValue: 047, modelName: VOIPESN )
• CITYCODE ( type: esriFieldTypeString, alias: City Code (TriTech), editable: true, nullable: true, length: 10, defaultValue: null, modelName: CITYCODE )
• COUNTYCODE ( type: esriFieldTypeString, alias: County Code (TriTech), editable: true, nullable: true, length: 5, defaultValue: SMNR, modelName: COUNTYCODE )
• SERVICEPROVIDERAREA ( type: esriFieldTypeString, alias: Service Provider Area (TriTech), editable: true, nullable: true, length: 36, defaultValue: null, modelName: SERVICEPROVIDERAREA )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• RoutingStreetExtKey ( type: esriFieldTypeString, alias: RoutingStreetExtKey, editable: true, nullable: true, length: 36, defaultValue: null, modelName: RoutingStreetExtKey )
• LOT ( type: esriFieldTypeString, alias: Lot, editable: true, nullable: true, length: 10, defaultValue: null, modelName: LOT )
• SECUNTNUM ( type: esriFieldTypeString, alias: SECUNTNUM, editable: true, nullable: true, length: 4, defaultValue: null, modelName: SECUNTNUM )
• ADDR_ID ( type: esriFieldTypeString, alias: ADDR_ID, editable: true, nullable: true, length: 41, defaultValue: null, modelName: ADDR_ID )
• FULLADDR ( type: esriFieldTypeString, alias: FULLADDR, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FULLADDR )

Templates:

• Name: Sumner County E911 Addresses
  Description:
  Prototype:
  ADDR_ID: null
  FULLADDR: null
  OIRID: null
  R_SEGID: null
  A_SEGID: null
  SEG_SIDE: null
  GISLINK: null
  STRUCTYPE: 1
  STRUCDESC: null
  STNUM_H: null
  STNUM_L: null
  STNUM: null
  STNUMSUF: null
  BUILDING: null
  FLOOR: null
  UNIT_TYPE: null
  UNIT_NUM: null
  PREDIR: null
  PRETYPE: null
  NAME: null
  TYPE: null
  SUFDIR: null
  POSTMOD: null
  ADDRESS: null
  ADDR_ESN: null
  LABEL: null
  SUBNAME: null
  VANITY: null
  ZIP: null
  ZIP4: null
  ESN: null
  CITY: null
  COUNTY: SUMNER
  STATE: TN
  LON: null
  LAT: null
  X_SP: null
  Y_SP: null
  Z_VAL: null
  GPSDATE: null
  ADDRAUTH: null
  SOURCE: null
  EDITOR: null
  GEOMOD: null
  GEOSRCE: null
  GEODATE: null
  ATTMOD: null
  ATTSRCE: null
  ATTDATE: null
  STATUS: 730
  DELNOTES: null
  NOTES: null
  LOCATION_NAME: null
  PSAP: SECC
  VOIPESN: 047
  CITYCODE: null
  COUNTYCODE: SMNR
  SERVICEPROVIDERAREA: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  RoutingStreetExtKey: null
  LOT: null
  SECUNTNUM: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata