View In:   ArcGIS Online Map Viewer

Name: AddressPoints_Existing

Display Field: st_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 8eb964c37c564c1e926eb68f92470e12

Copyright Text:

Default Visibility: true

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

Extent:

XMin: 769881.9311529994
YMin: 137603.7941173911
XMax: 781664.3787166625
YMax: 147190.43472097814
Spatial Reference: 103756  (103756)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [230, 0, 0, 255]
Size: 10.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: 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: true
Supports Query With LOD Spatial Reference: true
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, defaultValue: null, editable: false, alias: OBJECTID, type: esriFieldTypeOID )
• add_id ( modelName: ADD_ID, nullable: true, editable: true, defaultValue: null, length: 36, alias: Address Unique Identifier, type: esriFieldTypeString )
• add_id_loc ( modelName: ADD_ID_LOC, nullable: true, editable: true, defaultValue: null, length: 50, alias: Local Address Unique Identifier, type: esriFieldTypeString )
• anumberpre ( modelName: ANUMBERPRE, nullable: true, editable: true, defaultValue: null, length: 15, alias: Address Number Prefix, type: esriFieldTypeString )
• anumber ( modelName: ANUMBER, nullable: true, editable: true, defaultValue: null, alias: Address Number, type: esriFieldTypeInteger )
• anumbersuf ( modelName: ANUMBERSUF, nullable: true, editable: true, defaultValue: null, length: 15, alias: Address Number Suffix, type: esriFieldTypeString )
• st_pre_mod ( modelName: ST_PRE_MOD, nullable: true, editable: true, defaultValue: null, length: 15, alias: Street Name Pre Modifier, type: esriFieldTypeString )
• st_pre_dir ( modelName: ST_PRE_DIR, nullable: true, editable: true, defaultValue: null, length: 9, alias: Street Name Pre Directional, type: esriFieldTypeString , Coded Values: [North: North] , [South: South] , [East: East] , ...5 more... )
• st_pre_typ ( modelName: ST_PRE_TYP, nullable: true, editable: true, defaultValue: null, length: 35, alias: Street Name Pre Type, type: esriFieldTypeString , Coded Values: [Avenue: Avenue] , [County Highway: County Highway] , [County Road: County Road] , ...6 more... )
• st_pre_sep ( modelName: ST_PRE_SEP, nullable: true, editable: true, defaultValue: null, length: 20, alias: Street Name Pre Separator, type: esriFieldTypeString , Coded Values: [at: at] , [de las: de las] , [des: des] , ...6 more... )
• st_name ( modelName: ST_NAME, nullable: true, editable: true, defaultValue: null, length: 60, alias: Street Name, type: esriFieldTypeString )
• st_pos_typ ( modelName: ST_POS_TYP, nullable: true, editable: true, defaultValue: null, length: 15, alias: Street Name Post Type, type: esriFieldTypeString , Coded Values: [Abbey: Abbey] , [Alcove: Alcove] , [Alley: Alley] , ...230 more... )
• st_pos_dir ( modelName: ST_POS_DIR, nullable: true, editable: true, defaultValue: null, length: 9, alias: StreetName Post Directional, type: esriFieldTypeString , Coded Values: [North: North] , [South: South] , [East: East] , ...5 more... )
• st_pos_mod ( modelName: ST_POS_MOD, nullable: true, editable: true, defaultValue: null, length: 15, alias: Street Name Post Modifier, type: esriFieldTypeString )
• sub_type1 ( modelName: SUB_TYPE1, nullable: true, editable: true, defaultValue: null, length: 12, alias: Subaddress Type 1, type: esriFieldTypeString , Coded Values: [Apartment: Apartment] , [Building: Building] , [Center: Center] , ...19 more... )
• sub_id1 ( modelName: SUB_ID1, nullable: true, editable: true, defaultValue: null, length: 30, alias: Subaddress Identifier 1, type: esriFieldTypeString )
• sub_type2 ( modelName: SUB_TYPE2, nullable: true, editable: true, defaultValue: null, length: 12, alias: Subaddress Type 2, type: esriFieldTypeString , Coded Values: [Apartment: Apartment] , [Building: Building] , [Center: Center] , ...19 more... )
• sub_id2 ( modelName: SUB_ID2, nullable: true, editable: true, defaultValue: null, length: 30, alias: Subaddress Identifier 2, type: esriFieldTypeString )
• zip ( modelName: ZIP, nullable: true, editable: true, defaultValue: null, length: 5, alias: ZIP Code, type: esriFieldTypeString )
• zip4 ( modelName: ZIP4, nullable: true, editable: true, defaultValue: null, length: 4, alias: ZIP Plus 4, type: esriFieldTypeString )
• ctu_name ( modelName: CTU_NAME, nullable: true, editable: true, defaultValue: null, length: 100, alias: CTU Name, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [Unorganized Territory: Unorganized Territory] , [Aastad Township: Aastad Township] , ...2538 more... )
• ctu_id_txt ( modelName: CTU_ID_TXT, nullable: true, editable: true, defaultValue: null, length: 8, alias: CTU Code, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [00000000: Unorganized Territory] , [00663375: Aastad Township] , ...2634 more... )
• postcomm ( modelName: POSTCOMM, nullable: true, editable: true, defaultValue: null, length: 40, alias: Postal Community Name, type: esriFieldTypeString )
• co_code ( modelName: CO_CODE, nullable: true, editable: true, defaultValue: null, length: 5, alias: County Code, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [27001: Aitkin] , [27003: Anoka] , ...118 more... )
• co_name ( modelName: CO_NAME, nullable: true, editable: true, defaultValue: null, length: 40, alias: County Name, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [Aitkin: Aitkin] , [Allamakee: Allamakee] , ...113 more... )
• state_code ( modelName: STATE_CODE, nullable: true, editable: true, defaultValue: null, length: 2, alias: State Code, type: esriFieldTypeString , Coded Values: [IA: Iowa] , [MN: Minnesota] , [ND: North Dakota] , ...2 more... )
• loc_desc ( modelName: LOC_DESC, nullable: true, editable: true, defaultValue: null, length: 254, alias: Location Description, type: esriFieldTypeString )
• landmark ( modelName: LANDMARK, nullable: true, editable: true, defaultValue: null, length: 150, alias: Complete Landmark Name, type: esriFieldTypeString )
• residence ( modelName: RESIDENCE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Residence, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• mailable ( modelName: MAILABLE, nullable: true, editable: true, defaultValue: null, length: 10, alias: Mailable Address, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• state_pin ( modelName: STATE_PIN, nullable: true, editable: true, defaultValue: null, length: 28, alias: Parcel Unique Identifier, type: esriFieldTypeString )
• place_loc ( modelName: PLACE_LOC, nullable: true, editable: true, defaultValue: null, length: 2, alias: Placement Location, type: esriFieldTypeString , Coded Values: [0: Unknown] , [1: Centroid or random placement within parcel polygon] , [2: Aligned to doorstop] , ...8 more... )
• cen_geo ( modelName: CEN_GEO, nullable: true, editable: true, defaultValue: null, length: 10, alias: Centerline Geocodable, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• uni_wo_sub ( modelName: UNI_WO_SUB, nullable: true, editable: true, defaultValue: null, length: 10, alias: Unique Without Subaddresses, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• longitude ( modelName: LONGITUDE, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• latitude ( modelName: LATITUDE, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• usng_code ( modelName: USNG_CODE, nullable: true, editable: true, defaultValue: null, length: 15, alias: US National Grid Code, type: esriFieldTypeString )
• gis911poc ( modelName: GIS911POC, nullable: true, editable: true, defaultValue: null, length: 75, alias: 911 GIS Point-of-Contact, type: esriFieldTypeString , Coded Values: [Aitkin: Aitkin] , [Anoka: Anoka] , [Becker: Becker] , ...86 more... )
• esn ( modelName: ESN, nullable: true, editable: true, defaultValue: null, length: 5, alias: Emergency Service Number, type: esriFieldTypeString , Coded Values: [OOJ: OOJ] , [0: 0] , [1: 1] , ...2361 more... )
• psap_code ( modelName: PSAP_CODE, nullable: true, editable: true, defaultValue: null, length: 5, alias: PSAP Code, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [AIRP: Minneapolis St Paul Airport Communications Center] , [AITK: Aitkin County PSAP] , ...99 more... )
• msag_c ( modelName: MSAG_C, nullable: true, editable: true, defaultValue: null, length: 30, alias: MSAG Community Name, type: esriFieldTypeString , Coded Values: [OOJ: Out of Jurisdiction] , [Ada: Ada] , [Adams: Adams] , ...1308 more... )
• verror_911 ( modelName: VERROR_911, nullable: true, editable: true, defaultValue: null, length: 10, alias: 911 Validation Error, type: esriFieldTypeString , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• status ( modelName: STATUS, nullable: true, editable: true, defaultValue: null, length: 10, alias: Lifecycle Status, type: esriFieldTypeString , Coded Values: [Active: Active] , [Proposed: Proposed] , [Retired: Retired] )
• eff_date ( modelName: EFF_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Effective Date, type: esriFieldTypeDate )
• ret_date ( modelName: RET_DATE, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Retired Date, type: esriFieldTypeDate )
• source ( modelName: SOURCE, nullable: true, editable: true, defaultValue: null, length: 75, alias: Source, type: esriFieldTypeString )
• aauthority ( modelName: AAUTHORITY, nullable: true, editable: true, defaultValue: null, length: 40, alias: Address Authority, type: esriFieldTypeString )
• edit_org ( modelName: EDIT_ORG, nullable: true, editable: true, defaultValue: null, length: 40, alias: Editing Organization, type: esriFieldTypeString )
• edited_dt ( modelName: EDITED_DT, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Edited Date, type: esriFieldTypeDate )
• comments ( modelName: COMMENTS, nullable: true, editable: true, defaultValue: null, length: 254, alias: Comments, type: esriFieldTypeString )
• st_pre_dir_abbr ( modelName: ST_PRE_DIR_ABBR, nullable: true, editable: true, defaultValue: null, length: 2, alias: ST_PRE_DIR_ABBR, type: esriFieldTypeString , Coded Values: [N: N] , [NE: NE] , [NW: NW] , ...5 more... )
• st_pos_typ_abbr ( modelName: ST_POS_TYP_ABBR, nullable: true, editable: true, defaultValue: null, length: 4, alias: ST_POS_TYP_ABBR, type: esriFieldTypeString , Coded Values: [AVE: AVE] , [ST: ST] , [CT: CT] , ...4 more... )
• st_pos_dir_abbr ( modelName: ST_POS_DIR_ABBR, nullable: true, editable: true, defaultValue: null, length: 2, alias: ST_POS_DIR_ABBR, type: esriFieldTypeString , Coded Values: [N: N] , [NE: NE] , [NW: NW] , ...5 more... )
• gis_externalid ( modelName: PWA_ID, nullable: true, editable: true, defaultValue: null, length: 10, alias: GIS_ExternalID, type: esriFieldTypeString )
• gis_status ( modelName: PWA_STATUS, nullable: true, editable: true, defaultValue: null, length: 50, alias: GIS_Status, type: esriFieldTypeString )
• gis_comments ( modelName: PWA_COMMENTS, nullable: true, editable: true, defaultValue: null, length: 250, alias: GIS_Comments, type: esriFieldTypeString )
• st_conct ( modelName: ST_CONCT, nullable: true, editable: true, defaultValue: null, length: 150, alias: FULL ADDRESS, type: esriFieldTypeString )
• st_conc_abbr ( modelName: ST_CONC_ABBR, nullable: true, editable: true, defaultValue: null, length: 150, alias: ST_CONC_ABBR, type: esriFieldTypeString )
• created_user ( modelName: created_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( modelName: created_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( modelName: last_edited_user, nullable: true, editable: true, defaultValue: null, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( modelName: last_edited_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: last_edited_date, type: esriFieldTypeDate )
• lst_predir ( modelName: lst_predir, nullable: true, editable: true, defaultValue: null, length: 2, alias: LST_PREDIR, type: esriFieldTypeString )
• lst_name ( modelName: lst_name, nullable: true, editable: true, defaultValue: null, length: 75, alias: LST_NAME, type: esriFieldTypeString )
• lst_type ( modelName: lst_type, nullable: true, editable: true, defaultValue: null, length: 4, alias: LST_TYPE, type: esriFieldTypeString )
• lst_posdir ( modelName: lst_posdir, nullable: true, editable: true, defaultValue: null, length: 2, alias: LST_POSDIR, type: esriFieldTypeString )
• addcode ( modelName: addcode, nullable: true, editable: true, defaultValue: null, length: 6, alias: Additional Code, type: esriFieldTypeString )
• adddatauri ( modelName: adddatauri, nullable: true, editable: true, defaultValue: null, length: 254, alias: Additional Data URI, type: esriFieldTypeString )
• country ( modelName: country, nullable: true, editable: true, defaultValue: null, length: 2, alias: COUNTRY, type: esriFieldTypeString )
• mile_post ( modelName: mile_post, nullable: true, editable: true, defaultValue: null, length: 150, alias: MILE_POST, type: esriFieldTypeString )

Templates:

• Name: AddressPoints_Existing
  Description:
  Prototype:
  country: null
  esn: null
  gis_externalid: null
  st_pos_dir_abbr: null
  st_pre_mod: null
  postcomm: null
  zip4: null
  source: null
  st_pos_mod: null
  uni_wo_sub: null
  loc_desc: null
  landmark: null
  residence: null
  st_pre_dir: null
  addcode: null
  st_pre_typ: null
  co_name: null
  longitude: null
  zip: null
  lst_type: null
  gis_status: null
  created_user: null
  st_conct: null
  edit_org: null
  verror_911: null
  st_pre_dir_abbr: null
  msag_c: null
  add_id_loc: null
  anumbersuf: null
  ctu_name: null
  co_code: null
  state_code: null
  status: null
  st_conc_abbr: null
  eff_date: null
  cen_geo: null
  gis911poc: null
  aauthority: null
  psap_code: null
  latitude: null
  lst_posdir: null
  adddatauri: null
  add_id: null
  sub_id1: null
  usng_code: null
  anumberpre: null
  state_pin: null
  ctu_id_txt: null
  last_edited_date: null
  st_pos_typ_abbr: null
  sub_id2: null
  place_loc: null
  mile_post: null
  comments: null
  gis_comments: null
  st_name: null
  st_pre_sep: null
  st_pos_dir: null
  last_edited_user: null
  edited_dt: null
  lst_name: null
  st_pos_typ: null
  sub_type2: null
  sub_type1: null
  mailable: null
  lst_predir: null
  ret_date: null
  created_date: null
  anumber: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata