{ "layers": [ { "currentVersion": 10.61, "id": 0, "name": "Signs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 2223, "latestWkid": 2223 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SYMBOLTYPE", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "f29667da9c24259870f9df48b1deac6d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAHVJREFUKJHtzrEJg1AYxPF/8cFXCAlYaCMZIIKVK2SozOMOGcBOF7C1sZNXpBAOLFI4gI9XWeTq+3FnJMYAfPZRpipKTDS8WA1Aix7UlKfoC/7xp1BvANzYuSdcTckfXg96652kIaJfZHm2CR1Q0jt2KYQAwA8AgB0Kk8ycOAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "D", "label": "Details", "description": "" }, { "symbol": { "type": "esriPMS", "url": "ba98568c8b66572bfccfe1eb72359e1e", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAYpJREFUKJGd0jFLAmEcx/FfePjQqZcmhJZ1BoI0NNVmS5Mt1dLkC+gFRCAVvgLHhpbDTRtdsvIWI4iGaOhQXDzwgdMHjA47jrODlIZStMSi//Y88IHv8/Dn8M/hhg+apk13u939TqezZ5rmIiHkWRCEC4fDcRoKhfSxkFK6rGlayTAM0eVywe12w7IskTG27nQ6DyilW6Io3o/AWq1GVFW98Xq9S9FodCQpEAjAsiyhWq3K9Xp9JRwOawNIKT3xeDxLfr9/7Ht4nocoiu5yuXwGYHsATdPciUQiEz+D53lwHLcxkkoI8U5UX+Pz+Wbi8fhCsVhscADQ6/WMv0BCyKuiKLMAPmG73X4CsPobbLVaj4yxxiA1m82WYrHYJoCFCe5NluUrAPoAFgqF61wuJyQSiSMAc2NQR1GU40wmc9e/6C9AM51O36mqephKpdYA7AKYB/ACQM7n85fJZNKwbfvhO4Su6w+SJDUkSXoHcAugB2AKgDMYDFZs264MJ4zsKoAmgPPvnYyxH+0fkCCU+BRUbzgAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "I", "label": "Info", "description": "" }, { "symbol": { "type": "esriSMS", "style": "esriSMSDiamond", "color": [ 255, 0, 0, 255 ], "size": 10, "angle": 0, "xoffset": 0, "yoffset": 0, "outline": { "color": [ 0, 0, 0, 255 ], "width": 1 } }, "value": "R", "label": "Regulatory", "description": "" }, { "symbol": { "type": "esriPMS", "url": "a009b172e2ea9eb31b5f09eb92e17b7c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAwAAAALCAYAAABLcGxfAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAQhJREFUKJFjYcAORBgYGN5gk2DBJtYYyrDy3G2Ggo0XGC4T1FDkzZBV6sdgtfEEQ83GCwzhhDSIBJgyhHOyMXC4GjK4pDkx+Mzax7AFp4amUPYKa82flgwMDAzCvAxCXsYMmbP2MWxnYGD4i6FBSEhIP9zqnScTAwMjTMxNj8Exx5MhZcp2hpkYGpr83pWqSTFoIdvIycbAGWLKED5lO8NyBgaGT3AN3uoMoRE2DI7oHmRgYGCw1WKwq/ZlyG/dzNAM08AZ48IQL8zLIIVNAxMjA3OYLYN362aGJQwMDPdZQg0Y6tRlGJxvPsWmHALYWRjM8z0ZOiZuZwhnWX2BoXL1BYZK3MpRAQC64DmeKhaKtQAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 9, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "W", "label": "Warning", "description": "" }, { "symbol": { "type": "esriPMS", "url": "0091e4726baddcadd4d0648d31d2424d", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAYdJREFUKJGd0rFLAnEUB/DvDyX5wXkXKoJpRTg5ONXYEgi2VEt/guQeLdl/IDcIDaG7NLg4RKWLEUiDOijILW6Xd0N42J1SB9lrqI40kehtvwefH9/3eG78s9w/H0TEARyNx+NDy7JWOedPkiRdAThnjBlzIRFtqKpaGw6H616vF6IowrKsdVVVtzwezzER7TLGHqYgEXkURbnz+/1r8Xjc+dXn8yESiWA0GontdrtKRDHG2KMDFUU5kyRpLRgMzp1HEAREo1Gh1WpdANhzoGma+7FYbOEyBEGAy+XanorKOV9eqL4qEAhIyWQyXKlU+m4AmEwm5l8g5/y50+n4AHzCwWDQBhBfzABN01q6rvedqIVCoZZIJHYAhBe413K5fAPAcGCpVLrN5/NiOp0+BTBvtS/NZjOTy+Xq343vA9AymUy91+udZLPZTcbYAYAVAAMiqhaLxetUKmXatt2YhTAMoyHLcl+W5TcA9wDeATAAS6FQqGvbdvdnhKlbBaABuJzNqev6r+wfKdqUklIpkgMAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "O", "label": "Object Markers", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 868060.583989501, "ymin": 122368.25918634981, "xmax": 1157055.8720472455, "ymax": 274052.14370078593, "spatialReference": { "wkid": 2223, "latestWkid": 2223 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "STREETNAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SIGNID", "type": "esriFieldTypeString", "alias": "Sign ID (Secondary)", "length": 10, "domain": null }, { "name": "STREETNAME", "type": "esriFieldTypeString", "alias": "Road Street Name", "length": 100, "domain": null }, { "name": "STREETAKA", "type": "esriFieldTypeString", "alias": "Street Also Known As", "length": 100, "domain": null }, { "name": "MILEPOST", "type": "esriFieldTypeDouble", "alias": "Mile Post", "domain": null }, { "name": "MPOFFSET", "type": "esriFieldTypeString", "alias": "Offset LR", "length": 10, "domain": null }, { "name": "OWNEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Owned By", "domain": { "type": "codedValue", "name": "OWNBY_2", "description": "Asset ownership", "codedValues": [ { "name": "Unknown", "code": -99 }, { "name": "SCC county sign has been removed or replaced w/ another type", "code": -1 }, { "name": "Does Not Exist", "code": 0 }, { "name": "Santa Cruz County Public Works", "code": 1 }, { "name": "City of Nogales Public Works", "code": 2 }, { "name": "Arizona Department of Transportation", "code": 3 }, { "name": "US Department of Argriculture Forest Service", "code": 4 }, { "name": "National Geodetic Society", "code": 5 }, { "name": "US Postal Service", "code": 6 }, { "name": "Liberty Utilities", "code": 7 }, { "name": "Town of Patagonia", "code": 8 }, { "name": "Tubac", "code": 9 }, { "name": "Pima County Department of Transportation", "code": 10 }, { "name": "Private Individuals", "code": 11 }, { "name": "Arizona State Parks", "code": 12 }, { "name": "Cochise County Public Works", "code": 13 }, { "name": "BLM", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MAINTEDBY", "type": "esriFieldTypeSmallInteger", "alias": "Maintained By", "domain": { "type": "codedValue", "name": "OWNBY_2", "description": "Asset ownership", "codedValues": [ { "name": "Unknown", "code": -99 }, { "name": "SCC county sign has been removed or replaced w/ another type", "code": -1 }, { "name": "Does Not Exist", "code": 0 }, { "name": "Santa Cruz County Public Works", "code": 1 }, { "name": "City of Nogales Public Works", "code": 2 }, { "name": "Arizona Department of Transportation", "code": 3 }, { "name": "US Department of Argriculture Forest Service", "code": 4 }, { "name": "National Geodetic Society", "code": 5 }, { "name": "US Postal Service", "code": 6 }, { "name": "Liberty Utilities", "code": 7 }, { "name": "Town of Patagonia", "code": 8 }, { "name": "Tubac", "code": 9 }, { "name": "Pima County Department of Transportation", "code": 10 }, { "name": "Private Individuals", "code": 11 }, { "name": "Arizona State Parks", "code": 12 }, { "name": "Cochise County Public Works", "code": 13 }, { "name": "BLM", "code": 14 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SUPDIST", "type": "esriFieldTypeString", "alias": "Supervisor District", "length": 10, "domain": null }, { "name": "SRA", "type": "esriFieldTypeSmallInteger", "alias": "Sign Replacement Area", "domain": null }, { "name": "PLACEMENTYEAR", "type": "esriFieldTypeSmallInteger", "alias": "Install or Last Replacement Year", "domain": null }, { "name": "MUTCD", "type": "esriFieldTypeString", "alias": "MUTCD", "length": 20, "domain": null }, { "name": "SIGNCODE", "type": "esriFieldTypeString", "alias": "SCC Sign Code", "length": 20, "domain": null }, { "name": "SPEEDLIMIT", "type": "esriFieldTypeString", "alias": "Posted Speed Limit", "length": 5, "domain": null }, { "name": "LEGEND1", "type": "esriFieldTypeString", "alias": "Legend (Primary)", "length": 100, "domain": null }, { "name": "LEGEND2", "type": "esriFieldTypeString", "alias": "Legend (Secondary)", "length": 100, "domain": null }, { "name": "SIGN", "type": "esriFieldTypeString", "alias": "Sign", "length": 75, "domain": null }, { "name": "ATTACHEDSIGN", "type": "esriFieldTypeString", "alias": "Attached Sign", "length": 75, "domain": null }, { "name": "SCCPHOTOLOCATION", "type": "esriFieldTypeString", "alias": "SCC Photo Location", "length": 200, "domain": null }, { "name": "SYMBOLSIGN", "type": "esriFieldTypeString", "alias": "Symbol Sign", "length": 100, "domain": null }, { "name": "SYMBOLROTATION", "type": "esriFieldTypeSmallInteger", "alias": "Symbol Rotation", "domain": null }, { "name": "SYMBOLSIZE", "type": "esriFieldTypeSmallInteger", "alias": "Symbol Size", "domain": null }, { "name": "Sign_UID", "type": "esriFieldTypeString", "alias": "Sign UID", "length": 100, "domain": null }, { "name": "Roadname_UID", "type": "esriFieldTypeString", "alias": "Roadname UID", "length": 100, "domain": null }, { "name": "LASTUPDATE", "type": "esriFieldTypeDate", "alias": "Date of Last Update", "length": 8, "domain": null }, { "name": "LASTEDITOR", "type": "esriFieldTypeString", "alias": "Last Edit By", "length": 50, "domain": null }, { "name": "COMMENTS", "type": "esriFieldTypeString", "alias": "GIS Comments", "length": 250, "domain": null }, { "name": "PHOTOLOCATION", "type": "esriFieldTypeString", "alias": "Local Photo Location", "length": 200, "domain": null }, { "name": "RID", "type": "esriFieldTypeString", "alias": "RID", "length": 50, "domain": null }, { "name": "BASE_UID", "type": "esriFieldTypeString", "alias": "Base Universal ID", "length": 100, "domain": null }, { "name": "SYMBOLTYPE", "type": "esriFieldTypeString", "alias": "Symbol Type", "length": 50, "domain": { "type": "codedValue", "name": "SIGNTYPE", "description": "sign type", "codedValues": [ { "name": "Info", "code": "I" }, { "name": "Regulatory", "code": "R" }, { "name": "Details", "code": "D" }, { "name": "Warning", "code": "W" }, { "name": "Object Markers", "code": "O" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R383_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_383", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1170SIGNCODE", "fields": "SIGNCODE", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1170Sign_UID", "fields": "Sign_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1170BASE_UID", "fields": "BASE_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_383", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S285_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Signs_Tbl_SignInspectionToTbl_SignInspection", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "Sign_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 1, "name": "Signs_Tbl_SignOtherDataToTbl_SignOtherData", "relatedTableId": 3, "role": "esriRelRoleOrigin", "keyField": "Sign_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false }, { "id": 2, "name": "Signs_Tbl_SignTextToTbl_SignText", "relatedTableId": 4, "role": "esriRelRoleOrigin", "keyField": "SIGNCODE", "cardinality": "esriRelCardinalityOneToOne", "composite": false }, { "id": 3, "name": "SignsToPosts_Signs", "relatedTableId": 1, "role": "esriRelRoleDestination", "keyField": "BASE_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "dateFieldsTimeReference": null, "supportsCoordinatesQuantization": true }, { "currentVersion": 10.61, "id": 1, "name": "Posts", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryMultipoint", "sourceSpatialReference": { "wkid": 2223, "latestWkid": 2223 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 24000, "maxScale": 0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "NSIGN", "field2": null, "field3": null, "defaultSymbol": null, "defaultLabel": null, "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "891394e5029caf87a0b3d8d8c1013f73", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAAsAAAALCAYAAACprHcmAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAALFJREFUGJWlkL8KgmAUxX/q11SD9GeoqaGthoZCfAAfR3yVwt5JzBfIcI6g3HKI/LShPhEpITrT4XfOvVyuoKH5Lpjkj1IHiBfZCccpVCaa5bvkiK51AayDOQrh+rXcJgFg+dFQgbTIq/AsZd/yIwBCd5WKd+HyaVNHK2M1vNzsx7+fAWQ11q35ihu5VgiAxLN7Cs62wU0NDHQxDd31H9+oy4Bcgnylsmwtx55tKp80sidH5TaSsv0SgAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 8, "height": 8, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "1", "label": "1", "description": "" }, { "symbol": { "type": "esriPMS", "url": "707bdcee8101cd10108b3990e3a60270", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAALpJREFUKJFjYSATsKAL7L7Yz8fE9FsLoYDxkb1u6TOCGlmYfhsxMPzfD+P/Y2CoZGBg6CCokWynkqRx/+WuCoTQPyUGBkYEl/G//f7LXXAuE9PfBfbalS+gNv5vR1KJavR/Bg8Ghv8eMO6ffyx7GBgYXgyQHxkYGB0RQv8MGBgY+xH8/7MZGJiWwTWwfbsJ1+ioW3YAJgEJiP9IZjPdQ5anllORLWD8z/Dv/184n/H/P6I0OmqXHiTGJQAVtzJaUonJAAAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "2", "label": "2", "description": "" }, { "symbol": { "type": "esriPMS", "url": "2802407b898aa01f1eb80479df087384", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA8AAAAPCAYAAAA71pVKAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAJ5JREFUKJFjYcAC/m511Wb4z6SKEPn3jdln9y50dSzYNDP8Z0hkYPhXjCTykIGBQYE4zUSCAdb8d4vrAzRxQTS+DIaa/0xJMJvlCVjCjK6GkfE318AHWC+auD0DA4MJEv8TAwPDbGQF/xlY77IwMDAwMPvsLkGW+LvFtQdN83t0Ncg2kwVooZnpLwPDv79I/D9Ea2b22VnOwMBQTshmAEWqJJDzBVkbAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 11, "height": 11, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "3", "label": "3", "description": "" }, { "symbol": { "type": "esriPMS", "url": "6ce4a8e03d82da017ae15f9a59af462c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAAK9JREFUOI3NjzEKwkAURF9CJLYuBF0vYOklBA8jeC3v4QlUsLQTEy1+7UKysd2sSlyNkCnnD2/mJ3Sk5N3hBiOr9aZhGnOaiKyCQCWksTFLz94HLwpVj0GFUru2kghmfi6C7Vhk7Ybnba01DP1cnabnl63fqscgK6IbB60za8zByx+tyMI1Yrg3QFMo3MAlz4mV8otLP/e06Ff9HzSAuoLK9SIog0EZXBH5eHFnrz0AZpwvVna5aswAAAAASUVORK5CYII=", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "4", "label": "4", "description": "" } ], "fieldDelimiter": "," }, "transparency": 0, "labelingInfo": null }, "defaultVisibility": false, "extent": { "xmin": 868060.583989501, "ymin": 122368.25918634981, "xmax": 1157055.8720472455, "ymax": 274052.14370078593, "spatialReference": { "wkid": 2223, "latestWkid": 2223 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "BASE_UID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "BASE_UID", "type": "esriFieldTypeString", "alias": "Base Universal ID", "length": 100, "domain": null }, { "name": "Type", "type": "esriFieldTypeString", "alias": "Type", "length": 50, "domain": null }, { "name": "NSIGN", "type": "esriFieldTypeSmallInteger", "alias": "Number of Signs on Post", "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R382_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_382", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1169BASE_UID", "fields": "BASE_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_382", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S284_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 3, "name": "Posts_SignsToSigns", "relatedTableId": 0, "role": "esriRelRoleOrigin", "keyField": "BASE_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF, geoJSON", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsHavingClause": true, "supportsCountDistinct": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsPagination": true, "supportsTrueCurve": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true }, "supportsDatumTransformation": true, "supportsCoordinatesQuantization": true } ], "tables": [ { "currentVersion": 10.61, "id": 2, "name": "Inspection", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SIGNID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SIGNID", "type": "esriFieldTypeString", "alias": "Sign ID (Secondary)", "length": 10, "domain": null }, { "name": "Sign_UID", "type": "esriFieldTypeString", "alias": "Sign Universal ID", "length": 50, "domain": null }, { "name": "INSTALLDATE", "type": "esriFieldTypeDate", "alias": "Installation Date", "length": 8, "domain": null }, { "name": "LASTINSPECTIONDATE", "type": "esriFieldTypeDate", "alias": "Date Last Inspected", "length": 8, "domain": null }, { "name": "LASTICONDITION", "type": "esriFieldTypeString", "alias": "Last Inspected Condition", "length": 100, "domain": null }, { "name": "LASTINSPECTEDBY", "type": "esriFieldTypeString", "alias": "Last Inspected By", "length": 50, "domain": null }, { "name": "SIGNCODE", "type": "esriFieldTypeString", "alias": "SCC Sign Code", "length": 20, "domain": null }, { "name": "FGROUNDCOLOR1", "type": "esriFieldTypeString", "alias": "Fore Ground Color Primary", "length": 25, "domain": null }, { "name": "BGROUNDCOLOR1", "type": "esriFieldTypeString", "alias": "Back Ground Color Primary", "length": 25, "domain": null }, { "name": "FGROUNDCOLOR2", "type": "esriFieldTypeString", "alias": "Fore Ground Color Secondary", "length": 25, "domain": null }, { "name": "BGROUNDCOLOR2", "type": "esriFieldTypeString", "alias": "Back Ground Color Secondary", "length": 25, "domain": null }, { "name": "W1", "type": "esriFieldTypeSmallInteger", "alias": "Width Primary", "domain": null }, { "name": "H1", "type": "esriFieldTypeSmallInteger", "alias": "Height Primary", "domain": null }, { "name": "W2", "type": "esriFieldTypeSmallInteger", "alias": "Width Secondary", "domain": null }, { "name": "H2", "type": "esriFieldTypeSmallInteger", "alias": "Height Secondary", "domain": null }, { "name": "SIGNDESCRIPTION", "type": "esriFieldTypeString", "alias": "Sign Detail", "length": 120, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R381_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_381", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "G1167Sign_UID", "fields": "Sign_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1167SIGNID", "fields": "SIGNID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_381", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Tbl_SignInspectionToSigns_Tbl_SignInspection", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Sign_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 }, "dateFieldsTimeReference": null }, { "currentVersion": 10.61, "id": 3, "name": "Other Data", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SIGNID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SIGNID", "type": "esriFieldTypeString", "alias": "Sign ID (Secondary)", "length": 10, "domain": null }, { "name": "Sign_UID", "type": "esriFieldTypeString", "alias": "Sign Universal ID", "length": 50, "domain": null }, { "name": "FACILITYID", "type": "esriFieldTypeString", "alias": "Facility ID", "length": 50, "domain": null }, { "name": "PUBWORKSCODE", "type": "esriFieldTypeString", "alias": "PubWorks Code", "length": 50, "domain": null }, { "name": "SIGNTYPE", "type": "esriFieldTypeString", "alias": "Type Sign", "length": 10, "domain": null }, { "name": "SIGNASPECT", "type": "esriFieldTypeSmallInteger", "alias": "Sign Aspect", "domain": null }, { "name": "NSIGNS", "type": "esriFieldTypeSmallInteger", "alias": "Number of Signs on Post", "domain": null }, { "name": "DESCRIPTION", "type": "esriFieldTypeString", "alias": "Symbol Description", "length": 200, "domain": null }, { "name": "ACTIVE", "type": "esriFieldTypeString", "alias": "Active", "length": 10, "domain": null }, { "name": "SIGNSYMBOL_2", "type": "esriFieldTypeString", "alias": "Symbol Sign Alternate", "length": 40, "domain": null }, { "name": "Size_", "type": "esriFieldTypeString", "alias": "Size", "length": 255, "domain": null }, { "name": "Direction", "type": "esriFieldTypeString", "alias": "Direction", "length": 255, "domain": null }, { "name": "D3Sign1", "type": "esriFieldTypeString", "alias": "D3 Sign Legend", "length": 255, "domain": null }, { "name": "NumberOfCharacters", "type": "esriFieldTypeDouble", "alias": "Number of Characters", "domain": null }, { "name": "SHOWSIGNS", "type": "esriFieldTypeString", "alias": "Show Signs", "length": 24, "domain": { "type": "codedValue", "name": "SHOWSIGNS", "description": "on post", "codedValues": [ { "name": "Single sign on base", "code": "Single" }, { "name": "Multiple sign on base", "code": "Multi" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "MULTLOC", "type": "esriFieldTypeString", "alias": "Multiple Street Location", "length": 50, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R380_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_380", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1166Sign_UID", "fields": "Sign_UID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1166SIGNID", "fields": "SIGNID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_380", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 1, "name": "Tbl_SignOtherDataToSigns_Tbl_SignOtherData", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "Sign_UID", "cardinality": "esriRelCardinalityOneToMany", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 } }, { "currentVersion": 10.61, "id": 4, "name": "Text", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "SIGNCODE_TBL", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "SIGNCODE_TBL", "type": "esriFieldTypeString", "alias": "SIGNCODE_TBL", "length": 255, "domain": null }, { "name": "SIGNLEGEND_TBL", "type": "esriFieldTypeString", "alias": "SIGNLEGEND_TBL", "length": 255, "domain": null }, { "name": "SIGNLOCATION", "type": "esriFieldTypeString", "alias": "SIGNLOCATION", "length": 255, "domain": null }, { "name": "GlobalID", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R379_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_379", "fields": "GlobalID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "I1165SIGNCODE_TB", "fields": "SIGNCODE_TBL", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_379", "fields": "GlobalID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 2, "name": "Tbl_SignTextToSigns_Tbl_SignText", "relatedTableId": 0, "role": "esriRelRoleDestination", "keyField": "SIGNCODE_TBL", "cardinality": "esriRelCardinalityOneToOne", "composite": false } ], "capabilities": "Map,Query,Data", "maxRecordCount": 1000, "supportsStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, AMF", "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 } } ] }