View In:   ArcGIS Online Map Viewer

Name: Pave Box

Display Field: PIN

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 1cd3f9f9f36f45e8a7de7bcfd54f5907

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 10000.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: 5207828.615784818
YMin: 3588531.033661188
XMax: 5268764.064010251
YMax: 3673680.3153653317
Spatial Reference: 102675  (3417)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID )
• PIN ( type: esriFieldTypeString, alias: PIN, editable: true, nullable: true, length: 12, defaultValue: null, modelName: PIN )
• PINTEXT ( type: esriFieldTypeString, alias: PINTEXT, editable: true, nullable: true, length: 254, defaultValue: null, modelName: PINTEXT )
• TYPE ( type: esriFieldTypeString, alias: TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TYPE )
• Point_Type ( type: esriFieldTypeInteger, alias: Point_Type, editable: true, nullable: true, defaultValue: null, modelName: Point_Type )
• Label_Clas ( type: esriFieldTypeInteger, alias: Label_Clas, editable: true, nullable: true, defaultValue: null, modelName: Label_Clas )
• Acreage ( type: esriFieldTypeDouble, alias: Acreage, editable: true, nullable: true, defaultValue: null, modelName: Acreage )
• Txt_Angle ( type: esriFieldTypeDouble, alias: Txt_Angle, editable: true, nullable: true, defaultValue: null, modelName: Txt_Angle )
• CONDOID ( type: esriFieldTypeInteger, alias: CONDOID, editable: true, nullable: true, defaultValue: null, modelName: CONDOID )
• ParcelID ( type: esriFieldTypeInteger, alias: ParcelID, editable: true, nullable: true, defaultValue: null, modelName: ParcelID )
• parcel ( type: esriFieldTypeString, alias: parcel, editable: true, nullable: true, length: 12, defaultValue: null, modelName: parcel )
• propertyad ( type: esriFieldTypeString, alias: propertyad, editable: true, nullable: true, length: 30, defaultValue: null, modelName: propertyad )
• SEQ_S ( type: esriFieldTypeInteger, alias: SEQ_S, editable: true, nullable: true, defaultValue: null, modelName: SEQ_S )
• CISAccount ( type: esriFieldTypeString, alias: CISAccount, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CISAccount )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREET )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• CITY ( type: esriFieldTypeString, alias: CITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CITY )
• ACCOUNT ( type: esriFieldTypeString, alias: ACCOUNT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ACCOUNT )
• APARTMENT ( type: esriFieldTypeString, alias: APARTMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: APARTMENT )
• LOT ( type: esriFieldTypeString, alias: LOT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOT )
• ADDITION ( type: esriFieldTypeString, alias: ADDITION, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDITION )
• UNITS ( type: esriFieldTypeSmallInteger, alias: UNITS, editable: true, nullable: true, defaultValue: null, modelName: UNITS )
• DATE_TAP ( type: esriFieldTypeDate, alias: DATE_TAP, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_TAP )
• PLUMBER ( type: esriFieldTypeString, alias: PLUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PLUMBER )
• DEPTH ( type: esriFieldTypeString, alias: DEPTH, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DEPTH )
• CORPORATION ( type: esriFieldTypeString, alias: CORPORATION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CORPORATION )
• PAVE_BOX ( type: esriFieldTypeString, alias: PAVE_BOX, editable: true, nullable: true, length: 255, defaultValue: null, modelName: PAVE_BOX )
• SHORT ( type: esriFieldTypeString, alias: SHORT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SHORT )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: NOTES )
• INACTIVE_OR_STUB ( type: esriFieldTypeSmallInteger, alias: INACTIVE_OR_STUB, editable: true, nullable: true, defaultValue: null, modelName: INACTIVE_OR_STUB , Coded Values: [0: No] , [1: Yes] )
• VAULT ( type: esriFieldTypeSmallInteger, alias: VAULT, editable: true, nullable: true, defaultValue: null, modelName: VAULT , Coded Values: [0: No] , [1: Yes] )
• MULTIPLE_PB ( type: esriFieldTypeSmallInteger, alias: MULTIPLE_PB, editable: true, nullable: true, defaultValue: null, modelName: MULTIPLE_PB , Coded Values: [0: No] , [1: Yes] )
• MASTER_PB ( type: esriFieldTypeSmallInteger, alias: MASTER_PB, editable: true, nullable: true, defaultValue: null, modelName: MASTER_PB , Coded Values: [0: No] , [1: Yes] )
• PB_SERVES_MULTIPLE_ACCTS ( type: esriFieldTypeSmallInteger, alias: PB_SERVES_MULTIPLE_ACCTS, editable: true, nullable: true, defaultValue: null, modelName: PB_SERVES_MULTIPLE_ACCTS , Coded Values: [0: No] , [1: Yes] )
• FF_FEES_DUE ( type: esriFieldTypeSmallInteger, alias: FF_FEES_DUE, editable: true, nullable: true, defaultValue: null, modelName: FF_FEES_DUE , Coded Values: [0: No] , [1: Yes] )
• KILLED_AT_MAIN ( type: esriFieldTypeSmallInteger, alias: KILLED_AT_MAIN, editable: true, nullable: true, defaultValue: null, modelName: KILLED_AT_MAIN , Coded Values: [0: No] , [1: Yes] )
• CORP_SIZE ( type: esriFieldTypeString, alias: CORP_SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CORP_SIZE )
• PB_SIZE ( type: esriFieldTypeString, alias: PB_SIZE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PB_SIZE )
• CORP_IN ( type: esriFieldTypeString, alias: CORP_IN, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CORP_IN )
• GlobalID ( type: esriFieldTypeGlobalID, alias: ALOGDB.DBO.Pave_Box.GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: ALOGDB.DBO.Pave_Box.created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: ALOGDB.DBO.Pave_Box.created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: ALOGDB.DBO.Pave_Box.last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: ALOGDB.DBO.Pave_Box.last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• Owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Owner , Coded Values: [CITY OF WATERLOO: CITY OF WATERLOO] , [BLACK HAWK COUNTY: BLACK HAWK COUNTY] , [PRIVATE: PRIVATE] , ...6 more... )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Status , Coded Values: [Active: Active] , [Removed: Removed] , [Abandoned: Abandoned] , ...1 more... )
• GPS ( type: esriFieldTypeString, alias: GPS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Needs_GPS , Coded Values: [YES: YES] , [NO: NO] )
• Elevation ( type: esriFieldTypeDouble, alias: Elevation, editable: true, nullable: true, defaultValue: null, modelName: Elevation )
• PaveBoxID ( type: esriFieldTypeString, alias: Pave Box ID, editable: false, nullable: true, length: 255, defaultValue: null, modelName: PaveBoxID )
• ServiceLineMainToPB ( type: esriFieldTypeString, alias: Service Line Main to Pave Box Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceLineMainToPB , Coded Values: [Galvanized: Galvanized] , [Copper: Copper] , [Plastic: Plastic] , ...3 more... )
• ServiceLinePBToMeter ( type: esriFieldTypeString, alias: Service Line Pave Box to Meter Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ServiceLinePBToMeter , Coded Values: [Galvanized: Galvanized] , [Copper: Copper] , [Plastic: Plastic] , ...3 more... )
• Northing ( type: esriFieldTypeDouble, alias: Northing, editable: true, nullable: true, defaultValue: null, modelName: Northing )
• Easting ( type: esriFieldTypeDouble, alias: Easting, editable: true, nullable: true, defaultValue: null, modelName: Easting )
• Elements_SO ( type: esriFieldTypeString, alias: Elements SO Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Elements_SO )
• Elements_Task ( type: esriFieldTypeString, alias: Elements Task Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Elements_Task )
• Killed_Plugged_Date ( type: esriFieldTypeDate, alias: Killed & Plugged Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Killed_Plugged_Date )
• Killed_Plugged_Year ( type: esriFieldTypeString, alias: Killed & Plugged Year, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Killed_Plugged_Year , Coded Values: [2025: 2025] , [2026: 2026] , [2027: 2027] , ...3 more... )

Templates:

• Name: Pave Box
  Description:
  Prototype:
  Killed_Plugged_Date: null
  OBJECTID: null
  PIN: null
  PINTEXT: null
  TYPE: null
  Point_Type: null
  Label_Clas: null
  Acreage: null
  Txt_Angle: null
  CONDOID: null
  ParcelID: null
  parcel: null
  propertyad: null
  SEQ_S: null
  CISAccount: null
  STREET: null
  ADDRESS: null
  CITY: null
  ACCOUNT: null
  APARTMENT: null
  LOT: null
  ADDITION: null
  UNITS: null
  DATE_TAP: null
  PLUMBER: null
  DEPTH: null
  CORPORATION: null
  PAVE_BOX: null
  SHORT: null
  NOTES: null
  INACTIVE_OR_STUB: null
  VAULT: null
  MULTIPLE_PB: null
  MASTER_PB: null
  PB_SERVES_MULTIPLE_ACCTS: null
  FF_FEES_DUE: null
  KILLED_AT_MAIN: null
  CORP_SIZE: null
  PB_SIZE: null
  CORP_IN: null
  Killed_Plugged_Year: null
  Elements_Task: null
  Elements_SO: null
  Easting: null
  Northing: null
  Owner: null
  Status: null
  GPS: null
  Elevation: null
  ServiceLinePBToMeter: null
  ServiceLineMainToPB: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

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 Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata