{ "currentVersion": 10.91, "id": 1, "name": "MasterRouteDefinition", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": false, "relationships": [], "isDataVersioned": false, "isDataArchived": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": true, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true }, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "", "displayField": "COM_NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "SR_SID", "type": "esriFieldTypeString", "alias": "SR_SID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SR_SID" }, { "name": "SR_ORDER", "type": "esriFieldTypeInteger", "alias": "SR_ORDER", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SR_ORDER" }, { "name": "SR_DIST", "type": "esriFieldTypeDouble", "alias": "SR_DIST", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SR_DIST" }, { "name": "SR_TYPE", "type": "esriFieldTypeString", "alias": "SR_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SR_TYPE" }, { "name": "SR_ACCUM", "type": "esriFieldTypeString", "alias": "SR_ACCUM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SR_ACCUM" }, { "name": "SR_CATEG", "type": "esriFieldTypeString", "alias": "SR_CATEG", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "SR_CATEG" }, { "name": "ETE_EID", "type": "esriFieldTypeString", "alias": "ETE_EID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ETE_EID" }, { "name": "ETE_TYPE", "type": "esriFieldTypeString", "alias": "ETE_TYPE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "ETE_TYPE" }, { "name": "ETE_FMI", "type": "esriFieldTypeDouble", "alias": "ETE_FMI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ETE_FMI" }, { "name": "ETE_TMI", "type": "esriFieldTypeDouble", "alias": "ETE_TMI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ETE_TMI" }, { "name": "TWN_TID", "type": "esriFieldTypeString", "alias": "TWN_TID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TWN_TID" }, { "name": "TWN_FMI", "type": "esriFieldTypeDouble", "alias": "TWN_FMI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TWN_FMI" }, { "name": "TWN_TMI", "type": "esriFieldTypeDouble", "alias": "TWN_TMI", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TWN_TMI" }, { "name": "TWN_FSTA", "type": "esriFieldTypeInteger", "alias": "TWN_FSTA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TWN_FSTA" }, { "name": "TWN_TSTA", "type": "esriFieldTypeInteger", "alias": "TWN_TSTA", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "TWN_TSTA" }, { "name": "STATE_SYS", "type": "esriFieldTypeString", "alias": "STATE_SYS", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "STATE_SYS" }, { "name": "FED_AID", "type": "esriFieldTypeString", "alias": "FED_AID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FED_AID" }, { "name": "MAINT_RESP", "type": "esriFieldTypeString", "alias": "MAINT_RESP", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "MAINT_RESP" }, { "name": "TWNMAP_ID", "type": "esriFieldTypeString", "alias": "TWNMAP_ID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TWNMAP_ID" }, { "name": "HWYSGN_DOM", "type": "esriFieldTypeString", "alias": "HWYSGN_DOM", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HWYSGN_DOM" }, { "name": "HWYSGN_ANC", "type": "esriFieldTypeString", "alias": "HWYSGN_ANC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "HWYSGN_ANC" }, { "name": "FC_RTID", "type": "esriFieldTypeString", "alias": "FC_RTID", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FC_RTID" }, { "name": "TOWN", "type": "esriFieldTypeString", "alias": "TOWN", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TOWN" }, { "name": "LEN_SRC", "type": "esriFieldTypeString", "alias": "LEN_SRC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "LEN_SRC" }, { "name": "FROM_DESC", "type": "esriFieldTypeString", "alias": "FROM_DESC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "FROM_DESC" }, { "name": "TO_DESC", "type": "esriFieldTypeString", "alias": "TO_DESC", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "TO_DESC" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 60, "defaultValue": null, "modelName": "NOTES" }, { "name": "CTCODE", "type": "esriFieldTypeString", "alias": "CTCODE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "CTCODE" }, { "name": "COL_ROUTE", "type": "esriFieldTypeString", "alias": "COL_ROUTE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COL_ROUTE" }, { "name": "COL_LRTWN", "type": "esriFieldTypeString", "alias": "COL_LRTWN", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COL_LRTWN" }, { "name": "COL_TWNFMM", "type": "esriFieldTypeDouble", "alias": "COL_TWNFMM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COL_TWNFMM" }, { "name": "COL_TWNTMM", "type": "esriFieldTypeDouble", "alias": "COL_TWNTMM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COL_TWNTMM" }, { "name": "COL_LRETE", "type": "esriFieldTypeString", "alias": "COL_LRETE", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COL_LRETE" }, { "name": "COL_ETEFMM", "type": "esriFieldTypeDouble", "alias": "COL_ETEFMM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COL_ETEFMM" }, { "name": "COL_ETETMM", "type": "esriFieldTypeDouble", "alias": "COL_ETETMM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COL_ETETMM" }, { "name": "COL_SRORD", "type": "esriFieldTypeInteger", "alias": "COL_SRORD", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "COL_SRORD" }, { "name": "PLACARD_RT", "type": "esriFieldTypeString", "alias": "PLACARD_RT", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PLACARD_RT" }, { "name": "DIRECTION", "type": "esriFieldTypeString", "alias": "DIRECTION", "domain": null, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "DIRECTION" }, { "name": "AOTCLASS", "type": "esriFieldTypeSmallInteger", "alias": "AOTCLASS", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AOTCLASS" }, { "name": "Inventory_Route_Number", "type": "esriFieldTypeString", "alias": "Inventory_Route_Number", "domain": null, "editable": true, "nullable": true, "length": 12, "defaultValue": null, "modelName": "Inventory_Route_Number" }, { "name": "COM_NAME", "type": "esriFieldTypeString", "alias": "COM_NAME", "domain": null, "editable": true, "nullable": true, "length": 50, "defaultValue": null, "modelName": "COM_NAME" }, { "name": "TWN_LR_PartNum", "type": "esriFieldTypeSmallInteger", "alias": "TWN_LR_PartNum", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "TWN_LR_PartNum" }, { "name": "ETE_LR_PartNum", "type": "esriFieldTypeSmallInteger", "alias": "ETE_LR_PartNum", "domain": null, "editable": true, "nullable": true, "defaultValue": 1, "modelName": "ETE_LR_PartNum" }, { "name": "ETE_LR_Order", "type": "esriFieldTypeSmallInteger", "alias": "ETE_LR_Order", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "ETE_LR_Order" }, { "name": "ETE_Only", "type": "esriFieldTypeString", "alias": "ETE_Only", "domain": null, "editable": true, "nullable": true, "length": 15, "defaultValue": null, "modelName": "ETE_Only" }, { "name": "CREATIONUSER", "type": "esriFieldTypeString", "alias": "CREATIONUSER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATIONUSER" }, { "name": "DATECREATED", "type": "esriFieldTypeDate", "alias": "DATECREATED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATECREATED" }, { "name": "LASTUSER", "type": "esriFieldTypeString", "alias": "LASTUSER", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LASTUSER" }, { "name": "DATEMODIFIED", "type": "esriFieldTypeDate", "alias": "DATEMODIFIED", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "DATEMODIFIED" }, { "name": "RecordDate", "type": "esriFieldTypeDate", "alias": "RecordDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RecordDate" }, { "name": "RecordStatus", "type": "esriFieldTypeString", "alias": "RecordStatus", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "RecordStatus" }, { "name": "RecStatusBeginDate", "type": "esriFieldTypeDate", "alias": "RecStatusBeginDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RecStatusBeginDate" }, { "name": "RecStatusEndDate", "type": "esriFieldTypeDate", "alias": "RecStatusEndDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "RecStatusEndDate" }, { "name": "AffectedRecordDate", "type": "esriFieldTypeDate", "alias": "AffectedRecordDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AffectedRecordDate" }, { "name": "Editor", "type": "esriFieldTypeString", "alias": "Editor", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "Editor" }, { "name": "EditReason", "type": "esriFieldTypeString", "alias": "EditReason", "domain": null, "editable": true, "nullable": true, "length": 32, "defaultValue": null, "modelName": "EditReason" }, { "name": "EditComment", "type": "esriFieldTypeString", "alias": "EditComment", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "EditComment" } ], "indexes": [ { "name": "R136698_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "types": [], "templates": [ { "name": "MasterRouteDefinition", "description": "", "prototype": { "attributes": { "EditReason": null, "EditComment": null, "SR_SID": null, "SR_ORDER": null, "SR_DIST": null, "SR_TYPE": null, "SR_ACCUM": null, "SR_CATEG": null, "ETE_EID": null, "ETE_TYPE": null, "ETE_FMI": null, "ETE_TMI": null, "TWN_TID": null, "TWN_FMI": null, "TWN_TMI": null, "TWN_FSTA": null, "TWN_TSTA": null, "STATE_SYS": null, "FED_AID": null, "MAINT_RESP": null, "TWNMAP_ID": null, "HWYSGN_DOM": null, "HWYSGN_ANC": null, "FC_RTID": null, "TOWN": null, "LEN_SRC": null, "FROM_DESC": null, "TO_DESC": null, "NOTES": null, "CTCODE": null, "COL_ROUTE": null, "COL_LRTWN": null, "COL_TWNFMM": null, "COL_TWNTMM": null, "COL_LRETE": null, "COL_ETEFMM": null, "COL_ETETMM": null, "COL_SRORD": null, "PLACARD_RT": null, "DIRECTION": null, "AOTCLASS": null, "Inventory_Route_Number": null, "COM_NAME": null, "TWN_LR_PartNum": 1, "ETE_LR_PartNum": 1, "ETE_LR_Order": null, "ETE_Only": null, "CREATIONUSER": null, "DATECREATED": null, "LASTUSER": null, "DATEMODIFIED": null, "RecordDate": null, "RecordStatus": null, "RecStatusBeginDate": null, "RecStatusEndDate": null, "AffectedRecordDate": null, "Editor": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 1000, "supportedQueryFormats": "JSON, geoJSON", "capabilities": "Query", "useStandardizedQueries": true, "standardMaxRecordCount": 32000, "tileMaxRecordCount": 1000, "maxRecordCountFactor": 1 }