{ "currentVersion": 10.71, "id": 151, "name": "production.PWGIS.SignsData", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Jurisdiction", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "Subtype", "type": "esriFieldTypeInteger", "alias": "Subtype" }, { "name": "Jurisdiction", "type": "esriFieldTypeString", "alias": "Jurisdiction", "length": 60 }, { "name": "Administration", "type": "esriFieldTypeString", "alias": "Administration", "length": 60 }, { "name": "AssetID", "type": "esriFieldTypeString", "alias": "AssetID", "length": 20 }, { "name": "SignText", "type": "esriFieldTypeString", "alias": "Sign Text", "length": 75 }, { "name": "MUTCDcode", "type": "esriFieldTypeString", "alias": "MUTCDcode", "length": 24 }, { "name": "CodeDescription", "type": "esriFieldTypeString", "alias": "CodeDescription", "length": 255 }, { "name": "SheetingMaterial", "type": "esriFieldTypeString", "alias": "SheetingMaterial", "length": 30 }, { "name": "BackingMaterial", "type": "esriFieldTypeString", "alias": "BackingMaterial", "length": 20 }, { "name": "SizeHeight", "type": "esriFieldTypeDouble", "alias": "SizeHeight" }, { "name": "SizeWidth", "type": "esriFieldTypeDouble", "alias": "SizeWidth" }, { "name": "MountHeight", "type": "esriFieldTypeDouble", "alias": "MountHeight" }, { "name": "DirectionFacing", "type": "esriFieldTypeString", "alias": "DirectionFacing", "length": 15 }, { "name": "PostAssetID", "type": "esriFieldTypeString", "alias": "PostAssetID", "length": 20 }, { "name": "Status", "type": "esriFieldTypeString", "alias": "Status", "length": 20 }, { "name": "MUTCDsymbol", "type": "esriFieldTypeString", "alias": "MUTCDsymbol", "length": 255 }, { "name": "MUTCDshape", "type": "esriFieldTypeString", "alias": "MUTCDshape", "length": 30 }, { "name": "MUTCDclass", "type": "esriFieldTypeString", "alias": "MUTCDclass", "length": 30 }, { "name": "MUTCDactions", "type": "esriFieldTypeString", "alias": "MUTCDactions", "length": 30 }, { "name": "SignSymbol", "type": "esriFieldTypeString", "alias": "SignSymbol", "length": 255 }, { "name": "BackColor", "type": "esriFieldTypeString", "alias": "BackColor", "length": 25 }, { "name": "LegendColor", "type": "esriFieldTypeString", "alias": "LegendColor", "length": 25 }, { "name": "Notes", "type": "esriFieldTypeString", "alias": "Notes", "length": 255 }, { "name": "WorkArea", "type": "esriFieldTypeString", "alias": "WorkArea", "length": 4 } ], "indexes": [ { "name": "R749_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "G1786PostAssetID", "fields": "PostAssetID", "isAscending": true, "isUnique": false, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true } }