View In:   ArcGIS Online Map Viewer

Name: Addresses

Display Field: ADD_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.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.07060964257E7
YMin: 3802487.9899000004
XMax: -1.06885072043E7
YMax: 3810519.520499997
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [128, 0, 104, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
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 ( modelName: OBJECTID, nullable: false, editable: false, defaultValue: N/A, alias: OBJECTID, type: esriFieldTypeOID )
• ASSETID ( modelName: ASSETID, nullable: true, editable: true, defaultValue: N/A, length: 20, alias: ASSETID, type: esriFieldTypeString )
• SOURCE ( modelName: SOURCE, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: SOURCE, type: esriFieldTypeString )
• USER_ID ( modelName: USER_ID, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: USER ID, type: esriFieldTypeString )
• ADD_NUMBER ( modelName: ADD_NUMBER, nullable: true, editable: true, defaultValue: N/A, alias: ADDRESS NUMBER, type: esriFieldTypeInteger )
• ADD_PRE ( modelName: ADD_PRE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ADDRESS PREFIX, type: esriFieldTypeString )
• ADD_NAME ( modelName: ADD_NAME, nullable: true, editable: true, defaultValue: N/A, length: 60, alias: ADDRESS NAME, type: esriFieldTypeString )
• ADD_TYPE ( modelName: ADD_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ADDRESS TYPE, type: esriFieldTypeString )
• ADD_SUF ( modelName: ADD_SUF, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: ADDRESS SUFFIX, type: esriFieldTypeString )
• ADD_FULLNAME ( modelName: ADD_FULLNAME, nullable: true, editable: true, defaultValue: N/A, length: 75, alias: ADDRESS FULLNAME, type: esriFieldTypeString )
• ADD_UNIT ( modelName: ADD_UNIT, nullable: true, editable: true, defaultValue: N/A, length: 12, alias: ADDRESS UNIT, type: esriFieldTypeString )
• ADD_HIST_ADD ( modelName: ADD_HIST_ADD, nullable: true, editable: true, defaultValue: N/A, length: 75, alias: HISTORICAL ADDRESS, type: esriFieldTypeString )
• RR_ADD ( modelName: RR_ADD, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: RURAL ROUTE ADDRESS, type: esriFieldTypeString )
• ALIAS_ADD ( modelName: ALIAS_ADD, nullable: true, editable: true, defaultValue: N/A, length: 75, alias: ALIAS ADDRESS, type: esriFieldTypeString )
• ADDRESS_CLASS ( modelName: ADDRESS_CLASS, nullable: true, editable: true, defaultValue: 1, alias: ADDRESS CLASSIFICATION, type: esriFieldTypeInteger )
• SUPP_INFO ( modelName: SUPP_INFO, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: SUPPLEMENTAL INFORMATION, type: esriFieldTypeString )
• STRUCT_TYPE ( modelName: STRUCT_TYPE, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: STRUCTURE TYPE, type: esriFieldTypeString )
• STRUCT_NOTES1 ( modelName: STRUCT_NOTES1, nullable: true, editable: true, defaultValue: N/A, length: 125, alias: STRUCTURE NOTES 1, type: esriFieldTypeString )
• STRUCT_NOTES2 ( modelName: STRUCT_NOTES2, nullable: true, editable: true, defaultValue: N/A, length: 125, alias: STRUCTURE NOTES 2, type: esriFieldTypeString )
• STRUCT_PHONE1 ( modelName: STRUCT_PHONE1, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: STRUCTURE PHONE 1, type: esriFieldTypeString )
• STRUCT_PHONE2 ( modelName: STRUCT_PHONE2, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: STRUCTURE PHONE 2, type: esriFieldTypeString )
• OWNER_LN ( modelName: OWNER_LN, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: OWNER LAST NAME, type: esriFieldTypeString )
• OWNER_FN ( modelName: OWNER_FN, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: OWNER FIRST NAME, type: esriFieldTypeString )
• RES_LN ( modelName: RES_LN, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: RESIDENT LAST NAME, type: esriFieldTypeString )
• RES_FN ( modelName: RES_FN, nullable: true, editable: true, defaultValue: N/A, length: 40, alias: RESIDENT FIRST NAME, type: esriFieldTypeString )
• DATE_CREATE ( modelName: DATE_CREATE, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: DATE CREATE, type: esriFieldTypeDate )
• ZIP5 ( modelName: ZIP5, nullable: true, editable: true, defaultValue: N/A, alias: ZIP5, type: esriFieldTypeInteger )
• EXCHANGE ( modelName: EXCHANGE, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: EXCHANGE, type: esriFieldTypeString )
• COMM_NAME ( modelName: COMM_NAME, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: COMMUNITY NAME, type: esriFieldTypeString )
• POSTAL_COMM ( modelName: POSTAL_COMM, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: POSTAL COMMUNITY, type: esriFieldTypeString )
• COLLECT_METHOD ( modelName: COLLECT_METHOD, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: COLLECT METHOD, type: esriFieldTypeString )
• GEOCODE_LEVEL ( modelName: GEOCODE_LEVEL, nullable: true, editable: true, defaultValue: N/A, length: 35, alias: GEOCODE LEVEL, type: esriFieldTypeString )
• MSAG_COMMUNITY ( modelName: MSAG_COMMUNITY, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: MSAG COMMUNITY, type: esriFieldTypeString , Coded Values: [CHANDLER: CHANDLER] , [BIG SANDY: BIG SANDY] , [ELKHART: ELKHART] , ...85 more... )
• CREATION_USER ( modelName: CREATION_USER, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: CREATION_USER, type: esriFieldTypeString )
• CREATION_DATE ( modelName: DATE_CREATED, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: CREATION DATE, type: esriFieldTypeDate )
• MODIFY_USER ( modelName: MODIFY_USER, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: MODIFY_USER, type: esriFieldTypeString )
• MODIFY_DATE ( modelName: DATE_MODIFY, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: MODIFY DATE, type: esriFieldTypeDate )
• created_user ( modelName: created_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: created_user, type: esriFieldTypeString )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: false, defaultValue: N/A, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• C1_EXCEPTION ( modelName: C1_EXCEPTION, nullable: true, editable: true, defaultValue: N/A, alias: C1_EXCEPTION, type: esriFieldTypeInteger )
• creationuserM ( modelName: creationuserM, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: creationuserM, type: esriFieldTypeString )
• creationdateM ( modelName: creationdateM, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: creationdateM, type: esriFieldTypeDate )
• modifyuserM ( modelName: modifyuserM, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: modifyuserM, type: esriFieldTypeString )
• modifydateM ( modelName: modifydateM, nullable: true, editable: true, defaultValue: N/A, length: 8, alias: modifydateM, type: esriFieldTypeDate )
• PHONES_OLD ( modelName: PHONES_OLD, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: PHONES_OLD, type: esriFieldTypeString )
• COMMENTS_OLD ( modelName: COMMENTS_OLD, nullable: true, editable: true, defaultValue: N/A, length: 255, alias: COMMENTS_OLD, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: false, defaultValue: N/A, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• COUNTY ( modelName: COUNTY, nullable: true, editable: true, defaultValue: N/A, length: 15, alias: COUNTY, type: esriFieldTypeString , Coded Values: [ANDERSON: ANDERSON] , [CAMP: CAMP] , [CHEROKEE: CHEROKEE] , ...12 more... )
• GlobalID ( modelName: GlobalID, nullable: false, editable: false, defaultValue: N/A, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• City ( modelName: City, nullable: true, editable: true, defaultValue: N/A, length: 50, alias: City, type: esriFieldTypeString , Coded Values: [CHANDLER: CHANDLER] , [GLADEWATER: GLADEWATER] , [BIG SANDY: BIG SANDY] , ...65 more... )

Templates:

• Name: gis_services.DBO.Address911
  Description:
  Prototype:
  RES_LN: null
  MSAG_COMMUNITY: null
  creationuserM: null
  ADD_UNIT: null
  modifyuserM: null
  CREATION_USER: null
  ADD_TYPE: null
  RES_FN: null
  USER_ID: null
  ADD_HIST_ADD: null
  STRUCT_PHONE1: null
  STRUCT_PHONE2: null
  COLLECT_METHOD: null
  creationdateM: null
  STRUCT_TYPE: null
  ADD_SUF: null
  ADD_FULLNAME: null
  C1_EXCEPTION: null
  MODIFY_DATE: null
  COMMENTS_OLD: null
  modifydateM: null
  EXCHANGE: null
  PHONES_OLD: null
  DATE_CREATE: null
  RR_ADD: null
  COUNTY: null
  ASSETID: null
  STRUCT_NOTES2: null
  STRUCT_NOTES1: null
  OWNER_LN: null
  CREATION_DATE: null
  City: null
  ADD_PRE: null
  SUPP_INFO: null
  ADDRESS_CLASS: 1
  GEOCODE_LEVEL: null
  COMM_NAME: null
  POSTAL_COMM: null
  ADD_NAME: null
  SOURCE: null
  ADD_NUMBER: null
  ALIAS_ADD: null
  OWNER_FN: null
  MODIFY_USER: null
  ZIP5: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Create,Update,Delete,Uploads,Editing

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

Child Resources:

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata