{ "currentVersion": 11.5, "cimVersion": "3.5.0", "id": 43, "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, "hasContingentValuesDefinition": false, "advancedQueryCapabilities": { "supportsPagination": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryRelatedPagination": true, "supportsCurrentUserQueries": true, "supportsFullTextSearch": true, "fullTextSearchCapabilities": { "supportsSearchOperator": true, "supportsOperator": false, "supportsSqlExpressionInFullText": true }, "fullTextSearchableFields": [], "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsReturningGeometryEnvelope": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true, "supportsQueryWithCacheHint": false }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": true, "supportsPercentileAnalytic": false }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "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": "r598_sde_rowid_uk", "isAscending": true, "isUnique": true, "description": "", "fields": "objectid" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "preferredTimeReference": { "timeZone": "Central Standard Time", "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true }, "types": [], "templates": [ { "name": "ML", "description": "", "prototype": { "attributes": { "basin": null, "ml_id": null, "map_2": null, "ds_mh": null, "subbasin": null, "ds_easting": null, "ds_northing": null, "ds_elevation": null, "map_1": null, "sewer_category": null, "year_renewed": null, "suburb": null, "surface_type": null, "us_rimtoinvert": null, "us_elevation": null, "us_northing": null, "us_easting": null, "us_mh": null, "section_length": null, "remark": null, "owner": null, "year_constructed": null, "drainage_area": null, "ml_assetid": null, "us_rimtograde": null, "flooded": null, "asset_use": null, "asset_system": null, "easement": null, "flushing": null, "tv_priority": null, "tv_rating": null, "notes": null, "diameter": null, "tv_notes": null, "pipe_direction": null, "creation_date": null, "ds_rimtoinvert": null, "location": null, "last_modified_date": null, "asset_name": null, "city": null, "status": null, "street": null, "us_gradetoinvert": null, "ml_name": null, "lining": null, "us_street": null, "pipe_shape": null, "ds_gradetoinvert": null, "ds_rimtograde": null, "protection": null, "location_details": null, "material": null, "ds_street": null, "pipe_width": null, "pipe_height": null, "grid": null, "joint_length": null, "pipe_depth": null, "merge_guid": null, "sync_error": null, "syncdate": null, "ams_assettype": null, "branch": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query", "useStandardizedQueries": true, "bigIntegerRestrictedTo53Bits": true, "supportsAppend": true, "supportedAppendFormats": "FILEGDB,PBF", "standardMaxRecordCount": 32000, "tileMaxRecordCount": 2000, "maxRecordCountFactor": 1, "serviceItemId": "d207dd603c2642efb6c9064e4806e244" }