Name: MainLines

Display Field: asset_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 9a910b1ea32d49d58d056d82f16329ec

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

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

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 )
• asset_name ( modelName: asset_name, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset_Name, type: esriFieldTypeString )
• asset_system ( modelName: asset_system, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset_System, type: esriFieldTypeString )
• asset_use ( modelName: asset_use, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset_Use, type: esriFieldTypeString )
• city ( modelName: city, nullable: true, editable: true, defaultValue: null, length: 50, alias: City, type: esriFieldTypeString )
• coating_method ( modelName: coating_method, nullable: true, editable: true, defaultValue: null, length: 50, alias: Coating_Method, type: esriFieldTypeString )
• coordinate_system ( modelName: coordinate_system, nullable: true, editable: true, defaultValue: null, length: 50, alias: Coordinate_System, type: esriFieldTypeString )
• creation_date ( modelName: creation_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Creation_Date, type: esriFieldTypeDate )
• drainage_area ( modelName: drainage_area, nullable: true, editable: true, defaultValue: null, length: 50, alias: Drainage_Area, type: esriFieldTypeString )
• ds_easting ( modelName: ds_easting, nullable: true, editable: true, defaultValue: null, length: 50, alias: DS_Easting, type: esriFieldTypeString )
• ds_elevation ( modelName: ds_elevation, nullable: true, editable: true, defaultValue: null, length: 50, alias: DS_Elevation, type: esriFieldTypeString )
• ds_gradetoinvert ( modelName: ds_gradetoinvert, nullable: true, editable: true, defaultValue: null, alias: DS_GradetoInvert, type: esriFieldTypeDouble )
• us_mh ( modelName: us_mh, nullable: true, editable: true, defaultValue: null, length: 50, alias: US_MH, type: esriFieldTypeString )
• ds_mh ( modelName: ds_mh, nullable: true, editable: true, defaultValue: null, length: 50, alias: DS_MH, type: esriFieldTypeString )
• ds_northing ( modelName: ds_northing, nullable: true, editable: true, defaultValue: null, length: 50, alias: DS_Northing, type: esriFieldTypeString )
• ds_rimtograde ( modelName: ds_rimtograde, nullable: true, editable: true, defaultValue: null, alias: DS_RimtoGrade, type: esriFieldTypeDouble )
• ds_rimtoinvert ( modelName: ds_rimtoinvert, nullable: true, editable: true, defaultValue: null, alias: DS_RimtoInvert, type: esriFieldTypeDouble )
• ds_street ( modelName: ds_street, nullable: true, editable: true, defaultValue: null, length: 50, alias: DS_Street, type: esriFieldTypeString )
• gps_accuracy ( modelName: gps_accuracy, nullable: true, editable: true, defaultValue: null, length: 30, alias: GPS_Accuracy, type: esriFieldTypeString )
• grid ( modelName: grid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Grid, type: esriFieldTypeString )
• joint_length ( modelName: joint_length, nullable: true, editable: true, defaultValue: null, alias: Joint_Length, type: esriFieldTypeDouble )
• last_modified_date ( modelName: last_modified_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Last_Modified_Date, type: esriFieldTypeDate )
• lining ( modelName: lining, nullable: true, editable: true, defaultValue: null, length: 50, alias: Lining, type: esriFieldTypeString )
• location ( modelName: location, nullable: true, editable: true, defaultValue: null, length: 150, alias: Location, type: esriFieldTypeString )
• location_details ( modelName: location_details, nullable: true, editable: true, defaultValue: null, length: 255, alias: Location_Details, type: esriFieldTypeString )
• map_1 ( modelName: map_1, nullable: true, editable: true, defaultValue: null, length: 50, alias: Map_1, type: esriFieldTypeString )
• map_2 ( modelName: map_2, nullable: true, editable: true, defaultValue: null, length: 50, alias: Map_2, type: esriFieldTypeString )
• material ( modelName: material, nullable: true, editable: true, defaultValue: null, length: 50, alias: Material, type: esriFieldTypeString )
• merge_guid ( modelName: merge_guid, nullable: true, editable: true, defaultValue: null, length: 255, alias: Merge_GUID, type: esriFieldTypeString )
• ml_name ( modelName: ml_name, nullable: true, editable: true, defaultValue: null, length: 51, alias: ML_Name, type: esriFieldTypeString )
• owner ( modelName: owner, nullable: true, editable: true, defaultValue: null, length: 50, alias: Owner, type: esriFieldTypeString )
• pipe_depth ( modelName: pipe_depth, nullable: true, editable: true, defaultValue: null, alias: Pipe_Depth, type: esriFieldTypeInteger )
• pipe_height ( modelName: pipe_height, nullable: true, editable: true, defaultValue: null, alias: Pipe_Height, type: esriFieldTypeInteger )
• pipe_shape ( modelName: pipe_shape, nullable: true, editable: true, defaultValue: null, length: 50, alias: Pipe_Shape, type: esriFieldTypeString )
• pipe_width ( modelName: pipe_width, nullable: true, editable: true, defaultValue: null, alias: Pipe_Width, type: esriFieldTypeInteger )
• projecttitle ( modelName: projecttitle, nullable: true, editable: true, defaultValue: null, length: 64, alias: ProjectTitle, type: esriFieldTypeString )
• protection ( modelName: protection, nullable: true, editable: true, defaultValue: null, length: 255, alias: Protection, type: esriFieldTypeString )
• remark ( modelName: remark, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: Remark, type: esriFieldTypeString )
• section_length ( modelName: section_length, nullable: true, editable: true, defaultValue: null, alias: Section_Length, type: esriFieldTypeDouble )
• sewer_category ( modelName: sewer_category, nullable: true, editable: true, defaultValue: null, length: 255, alias: Sewer_Category, type: esriFieldTypeString )
• status ( modelName: status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Status, type: esriFieldTypeString )
• street ( modelName: street, nullable: true, editable: true, defaultValue: null, length: 100, alias: Street, type: esriFieldTypeString )
• subbasin ( modelName: subbasin, nullable: true, editable: true, defaultValue: null, length: 255, alias: SubBasin, type: esriFieldTypeString )
• suburb ( modelName: suburb, nullable: true, editable: true, defaultValue: null, length: 50, alias: Suburb, type: esriFieldTypeString )
• surface_type ( modelName: surface_type, nullable: true, editable: true, defaultValue: null, length: 50, alias: Surface_Type, type: esriFieldTypeString )
• us_easting ( modelName: us_easting, nullable: true, editable: true, defaultValue: null, length: 50, alias: US_Easting, type: esriFieldTypeString )
• us_elevation ( modelName: us_elevation, nullable: true, editable: true, defaultValue: null, length: 50, alias: US_Elevation, type: esriFieldTypeString )
• us_gradetoinvert ( modelName: us_gradetoinvert, nullable: true, editable: true, defaultValue: null, alias: US_GradetoInvert, type: esriFieldTypeDouble )
• us_northing ( modelName: us_northing, nullable: true, editable: true, defaultValue: null, length: 50, alias: US_Northing, type: esriFieldTypeString )
• us_rimtograde ( modelName: us_rimtograde, nullable: true, editable: true, defaultValue: null, alias: US_RimtoGrade, type: esriFieldTypeDouble )
• us_rimtoinvert ( modelName: us_rimtoinvert, nullable: true, editable: true, defaultValue: null, alias: US_RimtoInvert, type: esriFieldTypeDouble )
• us_street ( modelName: us_street, nullable: true, editable: true, defaultValue: null, length: 100, alias: US_Street, type: esriFieldTypeString )
• vertical_datum ( modelName: vertical_datum, nullable: true, editable: true, defaultValue: null, length: 50, alias: Vertical_Datum, type: esriFieldTypeString )
• year_constructed ( modelName: year_constructed, nullable: true, editable: true, defaultValue: null, alias: Year_Constructed, type: esriFieldTypeInteger )
• year_renewed ( modelName: year_renewed, nullable: true, editable: true, defaultValue: null, alias: Year_Renewed, type: esriFieldTypeInteger )
• sync_error ( modelName: sync_error, nullable: true, editable: true, defaultValue: null, length: 50, alias: Sync_Error, type: esriFieldTypeString )
• syncdate ( modelName: syncdate, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: SyncDate, type: esriFieldTypeDate )
• ams_assettype ( modelName: ams_assettype, nullable: true, editable: true, defaultValue: null, length: 50, alias: AMS_AssetType, type: esriFieldTypeString )
• gis_receive_date ( modelName: gis_receive_date, nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: GIS_Receive_Date, type: esriFieldTypeDate )
• gis_asset_doesnt_exist ( modelName: gis_asset_doesnt_exist, nullable: true, editable: true, defaultValue: null, alias: GIS_Asset_Doesnt_Exist, type: esriFieldTypeSmallInteger )
• syncstatus ( modelName: syncstatus, nullable: true, editable: true, defaultValue: null, length: 50, alias: SyncStatus, type: esriFieldTypeString )
• syncstatusmessage ( modelName: syncstatusmessage, nullable: true, editable: true, defaultValue: null, length: 500, alias: SyncStatusMessage, type: esriFieldTypeString )
• syncretrycount ( modelName: syncretrycount, nullable: true, editable: true, defaultValue: null, alias: SyncRetryCount, type: esriFieldTypeInteger )
• gis_asset_exists ( modelName: gis_asset_exists, nullable: true, editable: true, defaultValue: null, alias: GIS_Asset_Exists, type: esriFieldTypeSmallInteger )
• gis_asset_up_to_date ( modelName: gis_asset_up_to_date, nullable: true, editable: true, defaultValue: null, alias: GIS_Asset_Up_To_Date, type: esriFieldTypeSmallInteger )
• ml_id ( modelName: ml_id, nullable: true, editable: true, defaultValue: null, alias: ML_ID_First, type: esriFieldTypeInteger )

Templates:

• Name: MainLines
  Description:
  Prototype:
  ds_northing: null
  us_gradetoinvert: null
  ams_assettype: null
  last_modified_date: null
  ml_id: null
  ds_rimtograde: null
  us_rimtoinvert: null
  year_constructed: null
  pipe_width: null
  asset_name: null
  ds_street: null
  us_elevation: null
  syncdate: null
  vertical_datum: null
  map_2: null
  map_1: null
  syncstatus: null
  ds_rimtoinvert: null
  us_northing: null
  creation_date: null
  pipe_depth: null
  gis_asset_exists: null
  ds_elevation: null
  section_length: null
  location_details: null
  gps_accuracy: null
  coordinate_system: null
  status: null
  asset_system: null
  merge_guid: null
  city: null
  pipe_height: null
  year_renewed: null
  protection: null
  remark: null
  asset_use: null
  gis_receive_date: null
  subbasin: null
  gis_asset_doesnt_exist: null
  street: null
  owner: null
  us_easting: null
  gis_asset_up_to_date: null
  sync_error: null
  coating_method: null
  ds_gradetoinvert: null
  drainage_area: null
  ml_name: null
  ds_easting: null
  material: null
  syncstatusmessage: null
  grid: null
  sewer_category: null
  us_rimtograde: null
  lining: null
  us_street: null
  syncretrycount: null
  suburb: null
  us_mh: null
  location: null
  projecttitle: null
  ds_mh: null
  pipe_shape: null
  surface_type: null
  joint_length: 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: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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