Name: ML

Display Field: asset_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d207dd603c2642efb6c9064e4806e244

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: objectid, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• ml_id ( type: esriFieldTypeDouble, alias: ML_ID, editable: true, nullable: true, defaultValue: null, modelName: ml_id )
• map_2 ( type: esriFieldTypeString, alias: Map_2, editable: true, nullable: true, length: 255, defaultValue: null, modelName: map_2 )
• ds_mh ( type: esriFieldTypeString, alias: DS_MH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_mh )
• subbasin ( type: esriFieldTypeString, alias: SubBasin, editable: true, nullable: true, length: 255, defaultValue: null, modelName: subbasin )
• ds_easting ( type: esriFieldTypeString, alias: DS_Easting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_easting )
• ds_northing ( type: esriFieldTypeString, alias: DS_Northing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_northing )
• ds_elevation ( type: esriFieldTypeString, alias: DS_Elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_elevation )
• map_1 ( type: esriFieldTypeString, alias: Map_1, editable: true, nullable: true, length: 255, defaultValue: null, modelName: map_1 )
• sewer_category ( type: esriFieldTypeString, alias: Sewer_Category, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sewer_category )
• year_renewed ( type: esriFieldTypeString, alias: Year_Renewed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: year_renewed )
• suburb ( type: esriFieldTypeString, alias: Suburb, editable: true, nullable: true, length: 255, defaultValue: null, modelName: suburb )
• surface_type ( type: esriFieldTypeString, alias: Surface_Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: surface_type )
• us_rimtoinvert ( type: esriFieldTypeString, alias: US_RimtoInvert, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_rimtoinvert )
• us_elevation ( type: esriFieldTypeString, alias: US_Elevation, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_elevation )
• us_northing ( type: esriFieldTypeString, alias: US_Northing, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_northing )
• us_easting ( type: esriFieldTypeString, alias: US_Easting, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_easting )
• us_mh ( type: esriFieldTypeString, alias: US_MH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_mh )
• section_length ( type: esriFieldTypeString, alias: Section_Length, editable: true, nullable: true, length: 255, defaultValue: null, modelName: section_length )
• remark ( type: esriFieldTypeString, alias: Remark, editable: true, nullable: true, length: 255, defaultValue: null, modelName: remark )
• owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: owner )
• year_constructed ( type: esriFieldTypeDouble, alias: Year_Constructed, editable: true, nullable: true, defaultValue: null, modelName: year_constructed )
• drainage_area ( type: esriFieldTypeString, alias: Drainage_Area, editable: true, nullable: true, length: 255, defaultValue: null, modelName: drainage_area )
• ml_assetid ( type: esriFieldTypeString, alias: ML_ASSETID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ml_assetid )
• us_rimtograde ( type: esriFieldTypeString, alias: US_RimtoGrade, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_rimtograde )
• flooded ( type: esriFieldTypeString, alias: FLOODED, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flooded )
• asset_use ( type: esriFieldTypeString, alias: Asset_Use, editable: true, nullable: true, length: 255, defaultValue: null, modelName: asset_use )
• asset_system ( type: esriFieldTypeString, alias: Asset_System, editable: true, nullable: true, length: 255, defaultValue: null, modelName: asset_system )
• easement ( type: esriFieldTypeString, alias: EASEMENT, editable: true, nullable: true, length: 255, defaultValue: null, modelName: easement )
• flushing ( type: esriFieldTypeString, alias: FLUSHING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: flushing )
• tv_priority ( type: esriFieldTypeString, alias: TV_PRIORITY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tv_priority )
• tv_rating ( type: esriFieldTypeString, alias: TV_RATING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tv_rating )
• notes ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: notes )
• diameter ( type: esriFieldTypeDouble, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: diameter )
• tv_notes ( type: esriFieldTypeString, alias: TV_NOTES, editable: true, nullable: true, length: 255, defaultValue: null, modelName: tv_notes )
• pipe_direction ( type: esriFieldTypeString, alias: PIPE_DIRECTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe_direction )
• creation_date ( type: esriFieldTypeDate, alias: Creation_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: creation_date )
• ds_rimtoinvert ( type: esriFieldTypeString, alias: DS_RimtoInvert, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_rimtoinvert )
• location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: location )
• last_modified_date ( type: esriFieldTypeDate, alias: Last_Modified_Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: last_modified_date )
• asset_name ( type: esriFieldTypeString, alias: Asset_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: asset_name )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 255, defaultValue: null, modelName: city )
• status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 255, defaultValue: null, modelName: status )
• street ( type: esriFieldTypeString, alias: Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: street )
• us_gradetoinvert ( type: esriFieldTypeString, alias: US_GradetoInvert, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_gradetoinvert )
• ml_name ( type: esriFieldTypeString, alias: ML_Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ml_name )
• lining ( type: esriFieldTypeString, alias: Lining, editable: true, nullable: true, length: 255, defaultValue: null, modelName: lining )
• us_street ( type: esriFieldTypeString, alias: US_Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: us_street )
• pipe_shape ( type: esriFieldTypeString, alias: Pipe_Shape, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe_shape )
• ds_gradetoinvert ( type: esriFieldTypeString, alias: DS_GradetoInvert, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_gradetoinvert )
• ds_rimtograde ( type: esriFieldTypeString, alias: DS_RimtoGrade, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_rimtograde )
• protection ( type: esriFieldTypeString, alias: Protection, editable: true, nullable: true, length: 255, defaultValue: null, modelName: protection )
• location_details ( type: esriFieldTypeString, alias: Location_Details, editable: true, nullable: true, length: 255, defaultValue: null, modelName: location_details )
• material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 255, defaultValue: null, modelName: material )
• ds_street ( type: esriFieldTypeString, alias: DS_Street, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ds_street )
• pipe_width ( type: esriFieldTypeDouble, alias: Pipe_Width, editable: true, nullable: true, defaultValue: null, modelName: pipe_width )
• pipe_height ( type: esriFieldTypeDouble, alias: Pipe_Height, editable: true, nullable: true, defaultValue: null, modelName: pipe_height )
• grid ( type: esriFieldTypeString, alias: Grid, editable: true, nullable: true, length: 255, defaultValue: null, modelName: grid )
• joint_length ( type: esriFieldTypeString, alias: Joint_Length, editable: true, nullable: true, length: 255, defaultValue: null, modelName: joint_length )
• pipe_depth ( type: esriFieldTypeString, alias: Pipe_Depth, editable: true, nullable: true, length: 255, defaultValue: null, modelName: pipe_depth )
• merge_guid ( type: esriFieldTypeString, alias: Merge_GUID, editable: true, nullable: true, length: 255, defaultValue: null, modelName: merge_guid )
• sync_error ( type: esriFieldTypeString, alias: Sync_Error, editable: true, nullable: true, length: 255, defaultValue: null, modelName: sync_error )
• syncdate ( type: esriFieldTypeString, alias: SyncDate, editable: true, nullable: true, length: 255, defaultValue: null, modelName: syncdate )
• ams_assettype ( type: esriFieldTypeString, alias: AMS_AssetType, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ams_assettype )
• basin ( type: esriFieldTypeString, alias: BASIN, editable: true, nullable: true, length: 255, defaultValue: null, modelName: basin )
• branch ( type: esriFieldTypeString, alias: BRANCH, editable: true, nullable: true, length: 255, defaultValue: null, modelName: branch )

Templates:

• Name: ML
  Description:
  Prototype:
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata