Name: JoCoAddresses

Display Field: streetname

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d3c26acc5c9c4d0c9129b76ae8e83661

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

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: false
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• source ( modelName: source, nullable: true, editable: true, defaultValue: null, length: 75, alias: Source, type: esriFieldTypeString )
• county ( modelName: county, nullable: true, editable: true, defaultValue: null, length: 40, alias: County, type: esriFieldTypeString )
• inc_muni ( modelName: inc_muni, nullable: true, editable: true, defaultValue: null, length: 100, alias: IncorporatedMunicipality, type: esriFieldTypeString , Coded Values: [CORALVILLE: CORALVILLE] , [HILLS: HILLS] , [IOWA CITY: IOWA CITY] , ...10 more... )
• uninc_comm ( modelName: uninc_comm, nullable: true, editable: true, defaultValue: null, length: 100, alias: UnincorporatedCommunity, type: esriFieldTypeString , Coded Values: [LINCOLN TWP: LINCOLN TWP] , [MONROE TWP: MONROE TWP] , [GRAHAM TWP: GRAHAM TWP] , ...18 more... )
• nbrhd_comm ( modelName: nbrhd_comm, nullable: true, editable: true, defaultValue: null, length: 100, alias: NeighborhoodCommunity, type: esriFieldTypeString )
• addnum_pre ( modelName: addnum_pre, nullable: true, editable: true, defaultValue: null, length: 15, alias: AddressNumberPrefix, type: esriFieldTypeString )
• add_number ( modelName: add_number, nullable: true, editable: true, defaultValue: null, alias: AddressNumber, type: esriFieldTypeInteger )
• addnum_suf ( modelName: addnum_suf, nullable: true, editable: true, defaultValue: null, length: 15, alias: AddressNumberSuffix, type: esriFieldTypeString )
• stn_premod ( modelName: stn_premod, nullable: true, editable: true, defaultValue: null, length: 25, alias: StreetNumberPreModifier, type: esriFieldTypeString )
• stn_predir ( modelName: stn_predir, nullable: true, editable: true, defaultValue: null, length: 2, alias: StreetNamePreDirection, type: esriFieldTypeString , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• stn_pretyp ( modelName: stn_pretyp, nullable: true, editable: true, defaultValue: null, length: 20, alias: StreetNamePreType, type: esriFieldTypeString , Coded Values: [HIGHWAY: HIGHWAY] , [INTERSTATE: INTERSTATE] )
• streetname ( modelName: streetname, nullable: true, editable: true, defaultValue: null, length: 60, alias: StreetName, type: esriFieldTypeString )
• stn_postype ( modelName: stn_postype, nullable: true, editable: true, defaultValue: null, length: 4, alias: StreetName_PostType, type: esriFieldTypeString , Coded Values: [ALY: ALY] , [BLF: BLF] , [BLVD: BLVD] , ...37 more... )
• stn_posdir ( modelName: stn_posdir, nullable: true, editable: true, defaultValue: null, length: 2, alias: StreetName_PostDirection, type: esriFieldTypeString , Coded Values: [N: N] , [S: S] , [E: E] , ...5 more... )
• stn_posmod ( modelName: stn_posmod, nullable: true, editable: true, defaultValue: null, length: 12, alias: StreetNamePostModifier, type: esriFieldTypeString )
• post_comm ( modelName: post_comm, nullable: true, editable: true, defaultValue: null, length: 40, alias: PostCommunityName, type: esriFieldTypeString , Coded Values: [LISBON: LISBON] , [WEST LIBERTY: WEST LIBERTY] , [MOUNT VERNON: MOUNT VERNON] , ...25 more... )
• post_code ( modelName: post_code, nullable: true, editable: true, defaultValue: null, length: 5, alias: PostalCode, type: esriFieldTypeString , Coded Values: [52201: 52201 - AINSWORTH] , [52203: 52203 - AMANA] , [52227: 52227 - ELY] , ...30 more... )
• unit ( modelName: unit, nullable: true, editable: true, defaultValue: null, length: 75, alias: Unit, type: esriFieldTypeString )
• addtl_loc ( modelName: addtl_loc, nullable: true, editable: true, defaultValue: null, length: 255, alias: AddtionalLocationInformation, type: esriFieldTypeString )
• landmkname ( modelName: landmkname, nullable: true, editable: true, defaultValue: null, length: 255, alias: CompleteLandmarkName, type: esriFieldTypeString )
• place_type ( modelName: place_type, nullable: true, editable: true, defaultValue: null, length: 75, alias: PlaceType, type: esriFieldTypeString , Coded Values: [UNIVERSITY BUILDING: UNIVERSITY BUILDING] , [COMMERCIAL CONDOMINIUM: COMMERCIAL CONDOMINIUM] , [RESIDENTIAL CONDOMINIUM: RESIDENTIAL CONDOMINIUM] , ...60 more... )
• long ( modelName: long, nullable: true, editable: true, defaultValue: null, alias: Longitude, type: esriFieldTypeDouble )
• lat ( modelName: lat, nullable: true, editable: true, defaultValue: null, alias: Latitude, type: esriFieldTypeDouble )
• combined_street_name ( modelName: combined_street_name, nullable: true, editable: true, defaultValue: null, length: 150, alias: CombinedStreetName, type: esriFieldTypeString )
• address ( modelName: address, nullable: true, editable: true, defaultValue: null, length: 65, alias: ADDRESS, type: esriFieldTypeString )
• geolynx_landmark_label ( modelName: geolynx_landmark_label, nullable: true, editable: true, defaultValue: null, length: 1, alias: GeoLynxLandmarkLabel, type: esriFieldTypeString )
• ppn ( modelName: ppn, nullable: true, editable: true, defaultValue: null, length: 10, alias: PPN, type: esriFieldTypeString )
• add_number_label ( modelName: add_number_label, nullable: true, editable: true, defaultValue: null, length: 20, alias: AddressNumberLabel, type: esriFieldTypeString )
• addr_city ( modelName: addr_city, nullable: true, editable: true, defaultValue: null, length: 100, alias: Address_City, type: esriFieldTypeString )
• landmark_address ( modelName: landmark_address, nullable: true, editable: true, defaultValue: null, length: 400, alias: Landmark_w_address, type: esriFieldTypeString )
• address_id ( modelName: address_id, nullable: true, editable: true, defaultValue: null, length: 20, alias: ADDRESS_ID, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• 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 )

Templates:

• Name: JoCoAddresses
  Description:
  Prototype:
  inc_muni: null
  landmark_address: null
  streetname: null
  county: null
  source: null
  addnum_suf: null
  long: null
  post_comm: null
  stn_postype: null
  combined_street_name: null
  stn_premod: null
  place_type: null
  stn_predir: null
  last_edited_date: null
  stn_pretyp: null
  lat: null
  stn_posmod: null
  address: null
  created_user: null
  landmkname: null
  geolynx_landmark_label: null
  address_id: null
  stn_posdir: null
  add_number: null
  nbrhd_comm: null
  addnum_pre: null
  ppn: null
  last_edited_user: null
  unit: null
  add_number_label: null
  post_code: null
  addtl_loc: null
  created_date: null
  uninc_comm: null
  addr_city: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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