View In:   ArcGIS Online Map Viewer

Name: Water Meter Pit Inspections

Display Field: MTG_NUMBER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 96ca749e85c7442ca39470efd2ce6272

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 75000.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: 709131.2907999996
YMin: 4312152.6734
XMax: 738912.6895000003
YMax: 4330224.651699999
Spatial Reference: 32612  (32612)  LatestVCSWkid(0)

Drawing Info:

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

• MTG_MAP1_NO ( type: esriFieldTypeString, alias: MTG_MAP1_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MTG_MAP1_NO )
• MTG_PURP_CD ( type: esriFieldTypeInteger, alias: MTG_PURP_CD, editable: true, nullable: true, defaultValue: null, modelName: MTG_PURP_CD , Coded Values: [2: Area] , [1: Service] )
• MTG_PURP_TY ( type: esriFieldTypeString, alias: MTG_PURP_TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MTG_PURP_TY )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MTG_NUMBER ( type: esriFieldTypeString, alias: Meter Location No, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MTG_NUMBER )
• MTG_STYPE_CD ( type: esriFieldTypeInteger, alias: GIS SubType, editable: true, nullable: true, defaultValue: 0, modelName: MTG_STYPE_CD )
• MTG_TYPE_CD ( type: esriFieldTypeInteger, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: MTG_TYPE_CD )
• MTG_ELEV ( type: esriFieldTypeDouble, alias: Elevation (ft), editable: true, nullable: true, defaultValue: null, modelName: MTG_ELEV )
• MTG_ADR_BDG ( type: esriFieldTypeInteger, alias: Address, editable: true, nullable: true, defaultValue: null, modelName: MTG_ADR_BDG )
• MTG_ADR_DIR ( type: esriFieldTypeString, alias: Direction, editable: true, nullable: true, length: 2, defaultValue: null, modelName: MTG_ADR_DIR )
• MTG_ADR_STR ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MTG_ADR_STR )
• MTG_ADR_TY ( type: esriFieldTypeString, alias: Street Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MTG_ADR_TY )
• MTG_GPS_FLG ( type: esriFieldTypeSmallInteger, alias: GPS Located, editable: true, nullable: true, defaultValue: 0, modelName: MTG_GPS_FLG )
• MTG_SC_ID ( type: esriFieldTypeInteger, alias: Service Tap Rec #, editable: true, nullable: true, defaultValue: null, modelName: MTG_SC_ID )
• MTG_ID ( type: esriFieldTypeInteger, alias: Meter AutoID, editable: true, nullable: true, defaultValue: null, modelName: MTG_ID )
• MTG_DB ( type: esriFieldTypeSmallInteger, alias: In GBA Database?, editable: true, nullable: true, defaultValue: 0, modelName: MTG_DB )
• LastModBy ( type: esriFieldTypeString, alias: Last Modified By, editable: true, nullable: true, length: 40, defaultValue: null, modelName: LastModBy )
• LastModDate ( type: esriFieldTypeDate, alias: Last Modified date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastModDate )
• LastSynDate ( type: esriFieldTypeDate, alias: Last Synchronized Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LastSynDate )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• MTG_USER1CD ( type: esriFieldTypeInteger, alias: Pit Material, editable: true, nullable: true, defaultValue: null, modelName: MTG_USER1CD )
• MTG_LOCATE ( type: esriFieldTypeString, alias: General Location, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MTG_LOCATE )
• MTG_ACCTNO ( type: esriFieldTypeString, alias: Account Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MTG_ACCTNO )
• MTG_PROPTAG ( type: esriFieldTypeString, alias: Property ID Tag, editable: true, nullable: true, length: 52, defaultValue: null, modelName: MTG_PROPTAG )
• MTG_ADR_SFX ( type: esriFieldTypeString, alias: Street Suffix, editable: true, nullable: true, length: 5, defaultValue: null, modelName: MTG_ADR_SFX )
• MTG_APT_NO ( type: esriFieldTypeString, alias: Apt Number, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MTG_APT_NO )
• MTG_OP_A_CD ( type: esriFieldTypeInteger, alias: Operating Status, editable: true, nullable: true, defaultValue: null, modelName: MTG_OP_A_CD )
• MTG_INST_DT ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MTG_INST_DT )
• MTG_LOC_CD ( type: esriFieldTypeInteger, alias: Installation, editable: true, nullable: true, defaultValue: null, modelName: MTG_LOC_CD )
• MTG_MSET_CD ( type: esriFieldTypeInteger, alias: Meter Set, editable: true, nullable: true, defaultValue: null, modelName: MTG_MSET_CD )
• MTG_ACTIVE ( type: esriFieldTypeInteger, alias: Active, editable: true, nullable: true, defaultValue: null, modelName: MTG_ACTIVE )
• MTG_PP_ID ( type: esriFieldTypeInteger, alias: Pipe Rec #, editable: true, nullable: true, defaultValue: null, modelName: MTG_PP_ID )
• MTG_X1 ( type: esriFieldTypeDouble, alias: Longitude, editable: true, nullable: true, defaultValue: null, modelName: MTG_X1 )
• MTG_Y1 ( type: esriFieldTypeDouble, alias: Latitude, editable: true, nullable: true, defaultValue: null, modelName: MTG_Y1 )
• MTG_MAP_NO ( type: esriFieldTypeString, alias: Map Number, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MTG_MAP_NO )
• MT_ID ( type: esriFieldTypeInteger, alias: MT_ID, editable: true, nullable: false, defaultValue: null, modelName: MT_ID )
• MT_NUMBER ( type: esriFieldTypeString, alias: MT_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MT_NUMBER )
• MT_MAP_NO ( type: esriFieldTypeString, alias: MT_MAP_NO, editable: true, nullable: true, length: 15, defaultValue: null, modelName: MT_MAP_NO )
• MT_PP_ID ( type: esriFieldTypeInteger, alias: MT_PP_ID, editable: true, nullable: true, defaultValue: null, modelName: MT_PP_ID )
• MT_SC_ID ( type: esriFieldTypeInteger, alias: MT_SC_ID, editable: true, nullable: true, defaultValue: null, modelName: MT_SC_ID )
• MT_ACCTNO ( type: esriFieldTypeString, alias: MT_ACCTNO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MT_ACCTNO )
• MI_NUMBER ( type: esriFieldTypeString, alias: MI_NUMBER, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MI_NUMBER )
• MI_INSP_DT ( type: esriFieldTypeDate, alias: MI_INSP_DT, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MI_INSP_DT )
• MI_STAT_TY ( type: esriFieldTypeString, alias: MI_STAT_TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MI_STAT_TY )
• MI_STAT_CD ( type: esriFieldTypeSmallInteger, alias: MI_STAT_CD, editable: true, nullable: true, defaultValue: null, modelName: MI_STAT_CD )
• MI_LATEST ( type: esriFieldTypeSmallInteger, alias: MI_LATEST, editable: true, nullable: false, defaultValue: null, modelName: MI_LATEST )
• MI_ACT_CD ( type: esriFieldTypeSmallInteger, alias: MI_ACT_CD, editable: true, nullable: true, defaultValue: null, modelName: MI_ACT_CD )
• MI_ACT_TY ( type: esriFieldTypeString, alias: MI_ACT_TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MI_ACT_TY )
• MI_INSP_BY ( type: esriFieldTypeString, alias: MI_INSP_BY, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MI_INSP_BY )
• MI_COND_CD ( type: esriFieldTypeSmallInteger, alias: MI_COND_CD, editable: true, nullable: true, defaultValue: null, modelName: MI_COND_CD )
• MI_COND_TY ( type: esriFieldTypeString, alias: MI_COND_TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MI_COND_TY )
• MI_USER16CD ( type: esriFieldTypeSmallInteger, alias: MI_USER16CD, editable: true, nullable: true, defaultValue: null, modelName: MI_USER16CD )
• MI_USER16TY ( type: esriFieldTypeString, alias: MI_USER16TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MI_USER16TY )
• MI_USER1CD ( type: esriFieldTypeSmallInteger, alias: MI_USER1CD, editable: true, nullable: true, defaultValue: null, modelName: MI_USER1CD )
• MI_USER1TY ( type: esriFieldTypeString, alias: MI_USER1TY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MI_USER1TY )
• MI_ID ( type: esriFieldTypeInteger, alias: MI_ID, editable: true, nullable: false, defaultValue: null, modelName: MI_ID )
• PP_ID ( type: esriFieldTypeInteger, alias: PP_ID, editable: true, nullable: true, defaultValue: null, modelName: PP_ID )
• PP_NUMBER ( type: esriFieldTypeString, alias: PP_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PP_NUMBER )
• SC_ID ( type: esriFieldTypeInteger, alias: SC_ID, editable: true, nullable: true, defaultValue: null, modelName: SC_ID )
• SC_SERVNO ( type: esriFieldTypeString, alias: SC_SERVNO, editable: true, nullable: true, length: 30, defaultValue: null, modelName: SC_SERVNO )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )

Templates:

• Name: gjgislucity.DBO.WaterMeterPitInsp
  Description:
  Prototype:
  MTG_NUMBER: null
  MTG_ADR_TY: null
  MI_USER1TY: null
  MTG_ID: null
  MTG_MAP_NO: null
  MI_STAT_CD: null
  SC_SERVNO: null
  MTG_MAP1_NO: null
  MTG_PURP_CD: null
  MTG_PURP_TY: null
  MTG_STYPE_CD: 0
  MTG_TYPE_CD: null
  MTG_ELEV: null
  MTG_ADR_BDG: null
  MTG_ADR_DIR: null
  MTG_ADR_STR: null
  MTG_GPS_FLG: 0
  MTG_SC_ID: null
  MTG_DB: 0
  LastModBy: null
  LastModDate: null
  LastSynDate: null
  SC_ID: null
  MTG_USER1CD: null
  MTG_LOCATE: null
  MTG_ACCTNO: null
  MTG_PROPTAG: null
  MTG_ADR_SFX: null
  MTG_APT_NO: null
  MTG_OP_A_CD: null
  MTG_INST_DT: null
  MTG_LOC_CD: null
  MTG_MSET_CD: null
  MTG_ACTIVE: null
  MTG_PP_ID: null
  MTG_X1: null
  MTG_Y1: null
  MT_ID: 0
  MT_NUMBER: null
  MT_MAP_NO: null
  MT_PP_ID: null
  MT_SC_ID: null
  MT_ACCTNO: null
  MI_NUMBER: null
  MI_INSP_DT: null
  MI_STAT_TY: null
  MI_LATEST: 0
  MI_ACT_CD: null
  MI_ACT_TY: null
  MI_INSP_BY: null
  MI_COND_CD: null
  MI_COND_TY: null
  MI_USER16CD: null
  MI_USER16TY: null
  MI_USER1CD: null
  MI_ID: 0
  PP_ID: null
  PP_NUMBER: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query,Sync

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: true

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