{ "currentVersion": 11.1, "cimVersion": "3.1.0", "id": 2, "name": "stategis.sde.PMGSY_InProgressRoads", "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, "supportsApplyEditsbyUploadID": true, "supportedApplyEditsUploadIDFormats": "JSON" }, "hasMetadata": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "objectid", "globalIdField": "", "displayField": "blockname", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "objectid", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "objectid" }, { "name": "sanctioned_length", "type": "esriFieldTypeDouble", "alias": "sanctioned_length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sanctioned_length" }, { "name": "preparatory_work", "type": "esriFieldTypeDouble", "alias": "preparatory_work", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "preparatory_work" }, { "name": "earthwork_subgrade", "type": "esriFieldTypeDouble", "alias": "earthwork_subgrade", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "earthwork_subgrade" }, { "name": "subbase_preparation", "type": "esriFieldTypeDouble", "alias": "subbase_preparation", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "subbase_preparation" }, { "name": "base_course", "type": "esriFieldTypeDouble", "alias": "base_course", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "base_course" }, { "name": "surface_course", "type": "esriFieldTypeDouble", "alias": "surface_course", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "surface_course" }, { "name": "miscelaneous", "type": "esriFieldTypeDouble", "alias": "miscelaneous", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "miscelaneous" }, { "name": "completed_length", "type": "esriFieldTypeDouble", "alias": "completed_length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "completed_length" }, { "name": "balance_length", "type": "esriFieldTypeDouble", "alias": "balance_length", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "balance_length" }, { "name": "completed_percentage", "type": "esriFieldTypeDouble", "alias": "completed_percentage", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "completed_percentage" }, { "name": "contractor_phone_no", "type": "esriFieldTypeDouble", "alias": "contractor_phone_no", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "contractor_phone_no" }, { "name": "code", "type": "esriFieldTypeInteger", "alias": "code", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "code" }, { "name": "blockname", "type": "esriFieldTypeString", "alias": "blockname", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "blockname" }, { "name": "distname", "type": "esriFieldTypeString", "alias": "distname", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "distname" }, { "name": "road_name", "type": "esriFieldTypeString", "alias": "road_name", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "road_name" }, { "name": "package_number", "type": "esriFieldTypeString", "alias": "package_number", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "package_number" }, { "name": "sanctioned_year", "type": "esriFieldTypeInteger", "alias": "sanctioned_year", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "sanctioned_year" }, { "name": "is_completed", "type": "esriFieldTypeString", "alias": "is_completed", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "is_completed" }, { "name": "complete_staged", "type": "esriFieldTypeString", "alias": "complete_staged", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "complete_staged" }, { "name": "flag_category", "type": "esriFieldTypeString", "alias": "flag_category", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "flag_category" }, { "name": "flag_color", "type": "esriFieldTypeString", "alias": "flag_color", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "flag_color" }, { "name": "target_completion_date", "type": "esriFieldTypeDate", "alias": "target_completion_date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "target_completion_date" }, { "name": "upload_date", "type": "esriFieldTypeString", "alias": "upload_date", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "upload_date" }, { "name": "contractor_name", "type": "esriFieldTypeString", "alias": "contractor_name", "domain": null, "editable": true, "nullable": true, "length": 8000, "defaultValue": null, "modelName": "contractor_name" } ], "indexes": [ { "name": "r205_sde_rowid_uk", "fields": "objectid", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "stategis.sde.PMGSY_InProgressRoads", "description": "", "prototype": { "attributes": { "upload_date": null, "contractor_name": null, "sanctioned_length": null, "preparatory_work": null, "earthwork_subgrade": null, "subbase_preparation": null, "base_course": null, "surface_course": null, "miscelaneous": null, "completed_length": null, "balance_length": null, "completed_percentage": null, "contractor_phone_no": null, "code": null, "blockname": null, "distname": null, "road_name": null, "package_number": null, "sanctioned_year": null, "is_completed": null, "complete_staged": null, "flag_category": null, "flag_color": null, "target_completion_date": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 3000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 3000, "maxRecordCountFactor": 1, "serviceItemId": "a1e045f8be9a4129b54b6b2794ee45f9" }