{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 38, "name": "ML", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "infoInEstimates": [ "count" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "asset_name", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "ml_id", "type": "esriFieldTypeDouble", "alias": "ML_ID", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ml_id" }, { "name": "map_2", "type": "esriFieldTypeString", "alias": "Map_2", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "map_2" }, { "name": "ds_mh", "type": "esriFieldTypeString", "alias": "DS_MH", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_mh" }, { "name": "subbasin", "type": "esriFieldTypeString", "alias": "SubBasin", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "subbasin" }, { "name": "ds_easting", "type": "esriFieldTypeString", "alias": "DS_Easting", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_easting" }, { "name": "ds_northing", "type": "esriFieldTypeString", "alias": "DS_Northing", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_northing" }, { "name": "ds_elevation", "type": "esriFieldTypeString", "alias": "DS_Elevation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_elevation" }, { "name": "map_1", "type": "esriFieldTypeString", "alias": "Map_1", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "map_1" }, { "name": "sewer_category", "type": "esriFieldTypeString", "alias": "Sewer_Category", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sewer_category" }, { "name": "year_renewed", "type": "esriFieldTypeString", "alias": "Year_Renewed", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "year_renewed" }, { "name": "suburb", "type": "esriFieldTypeString", "alias": "Suburb", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "suburb" }, { "name": "surface_type", "type": "esriFieldTypeString", "alias": "Surface_Type", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "surface_type" }, { "name": "us_rimtoinvert", "type": "esriFieldTypeString", "alias": "US_RimtoInvert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_rimtoinvert" }, { "name": "us_elevation", "type": "esriFieldTypeString", "alias": "US_Elevation", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_elevation" }, { "name": "us_northing", "type": "esriFieldTypeString", "alias": "US_Northing", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_northing" }, { "name": "us_easting", "type": "esriFieldTypeString", "alias": "US_Easting", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_easting" }, { "name": "us_mh", "type": "esriFieldTypeString", "alias": "US_MH", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_mh" }, { "name": "section_length", "type": "esriFieldTypeString", "alias": "Section_Length", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "section_length" }, { "name": "remark", "type": "esriFieldTypeString", "alias": "Remark", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "remark" }, { "name": "owner", "type": "esriFieldTypeString", "alias": "Owner", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "owner" }, { "name": "year_constructed", "type": "esriFieldTypeDouble", "alias": "Year_Constructed", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "year_constructed" }, { "name": "drainage_area", "type": "esriFieldTypeString", "alias": "Drainage_Area", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "drainage_area" }, { "name": "ml_assetid", "type": "esriFieldTypeString", "alias": "ML_ASSETID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ml_assetid" }, { "name": "us_rimtograde", "type": "esriFieldTypeString", "alias": "US_RimtoGrade", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_rimtograde" }, { "name": "flooded", "type": "esriFieldTypeString", "alias": "FLOODED", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "flooded" }, { "name": "asset_use", "type": "esriFieldTypeString", "alias": "Asset_Use", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_use" }, { "name": "asset_system", "type": "esriFieldTypeString", "alias": "Asset_System", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_system" }, { "name": "easement", "type": "esriFieldTypeString", "alias": "EASEMENT", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "easement" }, { "name": "flushing", "type": "esriFieldTypeString", "alias": "FLUSHING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "flushing" }, { "name": "tv_priority", "type": "esriFieldTypeString", "alias": "TV_PRIORITY", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tv_priority" }, { "name": "tv_rating", "type": "esriFieldTypeString", "alias": "TV_RATING", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tv_rating" }, { "name": "notes", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "notes" }, { "name": "diameter", "type": "esriFieldTypeDouble", "alias": "DIAMETER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "diameter" }, { "name": "tv_notes", "type": "esriFieldTypeString", "alias": "TV_NOTES", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "tv_notes" }, { "name": "pipe_direction", "type": "esriFieldTypeString", "alias": "PIPE_DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "pipe_direction" }, { "name": "creation_date", "type": "esriFieldTypeDate", "alias": "Creation_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "creation_date" }, { "name": "ds_rimtoinvert", "type": "esriFieldTypeString", "alias": "DS_RimtoInvert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_rimtoinvert" }, { "name": "location", "type": "esriFieldTypeString", "alias": "Location", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "location" }, { "name": "last_modified_date", "type": "esriFieldTypeDate", "alias": "Last_Modified_Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "last_modified_date" }, { "name": "asset_name", "type": "esriFieldTypeString", "alias": "Asset_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "asset_name" }, { "name": "city", "type": "esriFieldTypeString", "alias": "City", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "city" }, { "name": "status", "type": "esriFieldTypeString", "alias": "Status", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "status" }, { "name": "street", "type": "esriFieldTypeString", "alias": "Street", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "street" }, { "name": "us_gradetoinvert", "type": "esriFieldTypeString", "alias": "US_GradetoInvert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_gradetoinvert" }, { "name": "ml_name", "type": "esriFieldTypeString", "alias": "ML_Name", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ml_name" }, { "name": "lining", "type": "esriFieldTypeString", "alias": "Lining", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "lining" }, { "name": "us_street", "type": "esriFieldTypeString", "alias": "US_Street", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "us_street" }, { "name": "pipe_shape", "type": "esriFieldTypeString", "alias": "Pipe_Shape", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "pipe_shape" }, { "name": "ds_gradetoinvert", "type": "esriFieldTypeString", "alias": "DS_GradetoInvert", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_gradetoinvert" }, { "name": "ds_rimtograde", "type": "esriFieldTypeString", "alias": "DS_RimtoGrade", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_rimtograde" }, { "name": "protection", "type": "esriFieldTypeString", "alias": "Protection", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "protection" }, { "name": "location_details", "type": "esriFieldTypeString", "alias": "Location_Details", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "location_details" }, { "name": "material", "type": "esriFieldTypeString", "alias": "Material", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "material" }, { "name": "ds_street", "type": "esriFieldTypeString", "alias": "DS_Street", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ds_street" }, { "name": "pipe_width", "type": "esriFieldTypeDouble", "alias": "Pipe_Width", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pipe_width" }, { "name": "pipe_height", "type": "esriFieldTypeDouble", "alias": "Pipe_Height", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "pipe_height" }, { "name": "grid", "type": "esriFieldTypeString", "alias": "Grid", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "grid" }, { "name": "joint_length", "type": "esriFieldTypeString", "alias": "Joint_Length", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "joint_length" }, { "name": "pipe_depth", "type": "esriFieldTypeString", "alias": "Pipe_Depth", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "pipe_depth" }, { "name": "merge_guid", "type": "esriFieldTypeString", "alias": "Merge_GUID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "merge_guid" }, { "name": "sync_error", "type": "esriFieldTypeString", "alias": "Sync_Error", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "sync_error" }, { "name": "syncdate", "type": "esriFieldTypeString", "alias": "SyncDate", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "syncdate" }, { "name": "ams_assettype", "type": "esriFieldTypeString", "alias": "AMS_AssetType", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "ams_assettype" }, { "name": "basin", "type": "esriFieldTypeString", "alias": "BASIN", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "basin" }, { "name": "branch", "type": "esriFieldTypeString", "alias": "BRANCH", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "branch" } ], "indexes": [ { "name": "r96_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "ML", "description": "", "prototype": { "attributes": {} }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d207dd603c2642efb6c9064e4806e244" }