{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Sign Poles & Street Signs", "type": "Feature Layer", "description": "", "geometryType": "esriGeometryPoint", "sourceSpatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3048.0060960121928, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "copyrightText": "", "parentLayer": null, "subLayers": [], "minScale": 0, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "uniqueValue", "field1": "SZ_SignStatus", "uniqueValueInfos": [ { "symbol": { "type": "esriPMS", "url": "987c8070719bafb656bde0f1bbec4e9c", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAvUlEQVQoka3RsUqCYRQG4OeQYxCRBA1dQRCtFs1dQaN30FCQ1RV0Ce6CQWtreBEOLW1tTk4KgRCn5RdM/08jerdz4OE9cBr+mMa/w2QHn8FsI0wCV+jgEF/JALfB27rGRzwszFu4wFlyHgxXYHJSNdVlG12c1jVeVg2ltJKDYLQMm2vQPHtq4PsGNMNH3ak93GO/APvBdAUG46SNZ+wuoQGuFxc/3hG8Jke4wTEmeMFTkEVY4RHuCueW4W/zDdnsI7sfP7QHAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "3", "label": "COMPLETED" }, { "symbol": { "type": "esriPMS", "url": "7809e448d740d00c96567c03af952a5b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAs0lEQVQokbXRMWoCQRSA4U9iKQQxBCw8gSC2MaTOCVJ6AwsFjZ7AI9gLEWzTBg+RIo2dnZWVgrAgWrjCssyuIuTv3sDHm2GK7qz4H/ARe0S3wAI6GKCGAxbo4y8PjjFKzA94xyve8BuCzXhTqBImaIXgR7whqxdUsU7Dpxx0qRKCyysowuoyJOEUQzxnwC/sQnCDNuYop9AC3eRB+jt+UEcPDWzxjRmOeZDz4z8zrpsLb+oEe7UbuiT57jQAAAAASUVORK5CYII=", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "2", "label": "REMOVED" }, { "symbol": { "type": "esriPMS", "url": "846a128d64c125b9f62d77ded8ff909b", "imageData": "iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABBklEQVQoka3SvUrEQBQF4DM3KQUJimDhEwhiq2LtE5hOUmSSFNlCwb8n8BGEGZgBQcHWVvYhLGzs7KxsoiC7xBybLRJiVli85YGPuT8TYsEK/x0aY5ajKPqK43j6JySpvPcjkmcANqqq+nbOjUmeaq2fB6H3/orkZSsKSB4A2LPW7ud5/tSD1trt2Uu/1ZKIXAPY7UGl1CGAYGhmADvGmPWiKN46UERWSc5xQBAEKwC6EMDLXAVMJ5PJa6/VMAxv6rq+ILk2AG/LsvzswSRJ3p1zRwDuAURtQXIsIsftrHOONE0fjTGbInIiIlsAPpqmedBa3ymlOAgBYLa183aWZVmv74X/6g9N9F7FtIXm1AAAAABJRU5ErkJggg==", "contentType": "image/png", "width": 10, "height": 10, "angle": 0, "xoffset": 0, "yoffset": 0 }, "value": "1", "label": "OLD" } ], "fieldDelimiter": ",", "authoringInfo": { "colorRamp": { "type": "multipart", "colorRamps": [ { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 51, 130, 98, 255 ], "toColor": [ 51, 130, 98, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 169, 38, 173, 255 ], "toColor": [ 169, 38, 173, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 43, 50, 255 ], "toColor": [ 173, 43, 50, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 37, 78, 148, 255 ], "toColor": [ 37, 78, 148, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 147, 59, 255 ], "toColor": [ 173, 147, 59, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 72, 166, 38, 255 ], "toColor": [ 72, 166, 38, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 133, 46, 87, 255 ], "toColor": [ 133, 46, 87, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 33, 33, 138, 255 ], "toColor": [ 33, 33, 138, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 67, 127, 153, 255 ], "toColor": [ 67, 127, 153, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 138, 90, 67, 255 ], "toColor": [ 138, 90, 67, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 118, 66, 140, 255 ], "toColor": [ 118, 66, 140, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 93, 128, 50, 255 ], "toColor": [ 93, 128, 50, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 38, 164, 166, 255 ], "toColor": [ 38, 164, 166, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "defaultVisibility": true, "extent": { "xmin": 2356804.1243600547, "ymin": 7044064.012268305, "xmax": 2494725.555537641, "ymax": 7098157.2321656495, "spatialReference": { "wkid": 102738, "latestWkid": 2276, "xyTolerance": 0.003280833333333333, "zTolerance": 2, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": 0, "zUnits": 1, "falseM": -100000, "mUnits": 10000 } }, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "displayField": "FacilityID", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Pole ID", "length": 255, "domain": null }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "length": 8, "domain": null }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector Name", "length": 2, "domain": { "type": "codedValue", "name": "cvd_Inspector", "description": "DESC", "codedValues": [ { "name": "Mika Clark", "code": "MC" }, { "name": "Inspected", "code": "IN" }, { "name": "Jeff Shafer", "code": "JS" }, { "name": "Martin Trillo", "code": "MT" }, { "name": "Edward Waugh", "code": "EW" }, { "name": "Travis Jordan", "code": "TJ" }, { "name": "Haylee McKissick", "code": "HM" }, { "name": "Eduardo Tanguma", "code": "ET" }, { "name": "Aaron Stuart", "code": "AS" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleCondition", "type": "esriFieldTypeString", "alias": "Pole Condition", "length": 7, "domain": { "type": "codedValue", "name": "cvd_PoleCondition", "description": "DESC", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Sector", "type": "esriFieldTypeInteger", "alias": "Sector", "domain": { "type": "codedValue", "name": "SignDistrict_Integer", "description": "Sign District Domain using string", "codedValues": [ { "name": "District 1", "code": 1 }, { "name": "District 2", "code": 2 }, { "name": "District 3", "code": 3 }, { "name": "District 4", "code": 4 }, { "name": "District 5", "code": 5 }, { "name": "District 6", "code": 6 }, { "name": "District 7", "code": 7 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "Pole Type", "length": 8, "domain": { "type": "codedValue", "name": "cvd_PoleType", "description": "DESC", "codedValues": [ { "name": "Round", "code": "ROUND" }, { "name": "Square", "code": "SQUARE" }, { "name": "Wood", "code": "WOOD" }, { "name": "Telspar", "code": "TELSPAR" }, { "name": "U-Channel", "code": "UCHANNEL" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "length": 7, "domain": { "type": "codedValue", "name": "cvd_Owner", "description": "DESC", "codedValues": [ { "name": "Town", "code": "TOWN" }, { "name": "Private", "code": "PRIVATE" }, { "name": "TXDOT", "code": "STATE" }, { "name": "Other", "code": "OTHER" }, { "name": "Unknown", "code": "UNKNOWN" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleInstallDate", "type": "esriFieldTypeDate", "alias": "Date Pole Installed", "length": 8, "domain": null }, { "name": "PoleComment", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "REF_COMPL", "type": "esriFieldTypeString", "alias": "REF_COMPL", "length": 5, "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SZ_InspectionDate", "type": "esriFieldTypeDate", "alias": "SZ_InspectionDate", "length": 8, "domain": null }, { "name": "SZ_SignStatus", "type": "esriFieldTypeInteger", "alias": "SZ_SignStatus", "domain": { "type": "codedValue", "name": "SignSZHourUpdates", "description": "School Zone Sign Annual Updates", "codedValues": [ { "name": "OLD", "code": 1 }, { "name": "REMOVED", "code": 2 }, { "name": "COMPLETED", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null }, { "name": "AS_InspectionDate", "type": "esriFieldTypeDate", "alias": "AS_InspectionDate", "length": 8, "domain": null }, { "name": "AS_SignStatus", "type": "esriFieldTypeInteger", "alias": "AS_SignStatus", "domain": { "type": "codedValue", "name": "SignASUpdates", "description": "Adopt-A-Spot Status", "codedValues": [ { "name": "ADOPTED", "code": 1 }, { "name": "AVAILABLE", "code": 2 }, { "name": "UNKNOWN", "code": 3 } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape" }, "indexes": [ { "name": "R282_pk", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_282", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_282", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "S212_idx", "fields": "Shape", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Signs", "relatedTableId": 2, "role": "esriRelRoleOrigin", "keyField": "globalid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "canModifyLayer": true, "canScaleSymbols": false, "hasLabels": false, "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "isDataVersioned": true, "ownershipBasedAccessControlForFeatures": {"allowOthersToQuery": true}, "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsTrueCurve": true, "supportsQueryWithDatumTransformation": true, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "supportsDatumTransformation": true, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsCoordinatesQuantization": true, "supportsDynamicLegends": true, "serviceItemId": "124e724faeec419b8252fe7d9ca1a16a" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "GISEDIT.DBO.Signs", "type": "Table", "description": null, "hasAttachments": true, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "Primary_", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "length": 38, "domain": null }, { "name": "Primary_", "type": "esriFieldTypeString", "alias": "Primary Sign", "length": 3, "domain": { "type": "codedValue", "name": "cvd_Primary", "description": "DESC", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "PoleID", "type": "esriFieldTypeString", "alias": "Pole ID", "length": 255, "domain": null }, { "name": "SignID", "type": "esriFieldTypeString", "alias": "Sign ID", "length": 255, "domain": null }, { "name": "SignDistrict", "type": "esriFieldTypeString", "alias": "Sign District", "length": 255, "domain": { "type": "codedValue", "name": "SignDistrict", "description": "", "codedValues": [ { "name": "1", "code": "1" }, { "name": "2", "code": "2" }, { "name": "3", "code": "3" }, { "name": "4", "code": "4" }, { "name": "5", "code": "5" }, { "name": "6", "code": "6" }, { "name": "7", "code": "7" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignType", "type": "esriFieldTypeString", "alias": "Sign Type", "length": 10, "domain": { "type": "codedValue", "name": "cvd_SignType", "description": "DESC", "codedValues": [ { "name": "Guide", "code": "Guide" }, { "name": "Other", "code": "Other" }, { "name": "Regulatory", "code": "Regulatory" }, { "name": "School", "code": "School" }, { "name": "Warning", "code": "Warning" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SchoolType", "type": "esriFieldTypeString", "alias": "School Type", "length": 10, "domain": { "type": "codedValue", "name": "cvd_SchoolType", "description": "DESC", "codedValues": [ { "name": "Elementary", "code": "ELEMENTARY" }, { "name": "Middle", "code": "MIDDLE" }, { "name": "Combo", "code": "COMBO" }, { "name": "High", "code": "HIGH" }, { "name": "Argyle", "code": "ARGYLE" }, { "name": "Other", "code": "OTHER" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignCode", "type": "esriFieldTypeString", "alias": "MUTCD Code", "length": 255, "domain": { "type": "codedValue", "name": "SignMUTCD", "description": "MUTCD Codes for Flower Mound Signs", "codedValues": [ { "name": "Private SNB", "code": "SNB-Private" }, { "name": "Public SNB", "code": "SNB1-1" }, { "name": "Adopt A Spot w/ Sponsor Plaque", "code": "ADS-1" }, { "name": "We Heart Our Children", "code": "WH-1" }, { "name": "Universal Other", "code": "OTH-1" }, { "name": "Neighborhood Watch", "code": "NW-1" }, { "name": "National Night Out", "code": "NNO-1" }, { "name": "Town Population", "code": "PopLogo" }, { "name": "Town Entrance Signs", "code": "TE-1" }, { "name": "Town Facility Direction", "code": "WFR-3" }, { "name": "ClickIt or Ticket Texas", "code": "ClickIt" }, { "name": "Cross Traffic Does Not Stop", "code": "CrossTrafficDoesNotStop" }, { "name": "Universal Regulatory", "code": "Reg-1" }, { "name": "End Of Road Marker", "code": "OM4-3" }, { "name": "Stop", "code": "R1-1" }, { "name": "Yield", "code": "R1-2" }, { "name": "All Way Plaque", "code": "R1-3P" }, { "name": "Yield to Pedestrians", "code": "R1-8L" }, { "name": "20 MPH", "code": "R2-1_20MPH" }, { "name": "25 MPH", "code": "R2-1_25MPH" }, { "name": "30 MPH", "code": "R2-1_30MPH" }, { "name": "35 MPH", "code": "R2-1_35MPH" }, { "name": "40 MPH", "code": "R2-1_40MPH" }, { "name": "45 MPH", "code": "R2-1_45MPH" }, { "name": "Neighborhood", "code": "R2-5bP" }, { "name": "No U-Turn", "code": "R3-4" }, { "name": "Left Lane Plaque", "code": "R3-5bP_LeftLane" }, { "name": "Right Lane Plaque", "code": "R3-5bP_RightLane" }, { "name": "Left Only Arrow", "code": "R3-5L" }, { "name": "Right Only Arrow", "code": "R3-5R" }, { "name": "Lane Designation Multi Directional", "code": "R3-8" }, { "name": "Lane Designation Left Turn", "code": "R3-8L" }, { "name": "Lane Designation Right Turn", "code": "R3-8R" }, { "name": "Bike Lane", "code": "R3-17" }, { "name": "Keep Right Of Median", "code": "R4-7" }, { "name": "Do Not Enter", "code": "R5-1" }, { "name": "Wrong Way", "code": "R5-1a" }, { "name": "No Trucks", "code": "R5-2" }, { "name": "One way", "code": "R6-2R" }, { "name": "Chevrons", "code": "R5-5" }, { "name": "Roundabout", "code": "R6-5P" }, { "name": "No Parking", "code": "R8-3" }, { "name": "No Pedestrian Crossing", "code": "R9-3" }, { "name": "Pedestrian Crossing Push Button Timed", "code": "R10-3i" }, { "name": "No Turn On Red", "code": "R10-11" }, { "name": "Left Turn Yield On Green", "code": "R10-12" }, { "name": "Left Turn Yield On Flashing Yellow", "code": "R10-17T" }, { "name": "Bus Stop Advance Warning", "code": "S3-1" }, { "name": "End School Zone", "code": "S5-2" }, { "name": "School Crosswalk", "code": "S1-1" }, { "name": "School Zone Time Plaque", "code": "S4-1" }, { "name": "School Plaque", "code": "S4-3" }, { "name": "School Speed Limit with Times", "code": "S5-1" }, { "name": "Cell Phone Use Prohibited", "code": "S7-1" }, { "name": "End School Zone Plaque", "code": "S5-2Plaque" }, { "name": "Here Plaque (School)", "code": "W16-7Lp(S)" }, { "name": "Ahead Plaque (School)", "code": "W16-9p(S)" }, { "name": "Universal Warning", "code": "WGEN-1" }, { "name": "High Water Road Closed", "code": "WHW1-1" }, { "name": "Object Marker", "code": "OM3-L" }, { "name": "Left Curve", "code": "W1-1L" }, { "name": "Right Curve", "code": "W1-1R" }, { "name": "Left S-Curve", "code": "W1-4L" }, { "name": "Right S-Curve", "code": "W1-4R" }, { "name": "Left Arrow", "code": "W1-6L" }, { "name": "Right Arrow", "code": "W1-6R" }, { "name": "Chevron Left", "code": "W1-8L" }, { "name": "4 Way Intersection Advance", "code": "W2-1" }, { "name": "Side Road Advance", "code": "W2-2" }, { "name": "T Intersection Advance", "code": "W2-4" }, { "name": "Roundabout", "code": "W2-6" }, { "name": "Stop Advance warning", "code": "W3-1" }, { "name": "Signal Advance Warning", "code": "W3-3" }, { "name": "Speed Change Ahead", "code": "W3-5" }, { "name": "Left Lane Ends", "code": "W4-2" }, { "name": "Two way Traffic", "code": "W6-3" }, { "name": "Dip Ahead", "code": "W8-2" }, { "name": "Duck Crossing", "code": "W11-25T" }, { "name": "Pedestrian Crossing", "code": "W11-2" }, { "name": "Deer Crossing", "code": "W11-3" }, { "name": "Equestrian Crossing", "code": "W11-7" }, { "name": "Fire Truck", "code": "W11-8R" }, { "name": "Bike and Ped Crossing", "code": "W11-15" }, { "name": "Advisory Speed Plaque", "code": "W13-1" }, { "name": "No Outlet", "code": "W14-2" }, { "name": "Playground", "code": "W15-1" }, { "name": "Here", "code": "W16-7Lp" }, { "name": "Ahead", "code": "W16-9p" }, { "name": "Roundabout Plaque", "code": "W16-17p" }, { "name": "Bridges May Ice", "code": "CW8-13Modified" }, { "name": "Push Button for Crosswalk", "code": "R10-4b" }, { "name": "Primary Median Location", "code": "M1" }, { "name": "Secondary Median Location", "code": "M2" }, { "name": "Watershed Sign", "code": "BakersBranch" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SheetingType", "type": "esriFieldTypeString", "alias": "Sheeting Type", "length": 3, "domain": { "type": "codedValue", "name": "cvd_SheetingType", "description": "DESC", "codedValues": [ { "name": "Diamond", "code": "D" }, { "name": "Engineering", "code": "E" }, { "name": "High Intensity Prismatic", "code": "HIP" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "length": 1, "domain": { "type": "codedValue", "name": "cvd_Material", "description": "DESC", "codedValues": [ { "name": "Aluminum", "code": "A" }, { "name": "Plastic", "code": "P" }, { "name": "Steel", "code": "S" }, { "name": "Wood", "code": "W" }, { "name": "Unknown", "code": "U" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignSize", "type": "esriFieldTypeString", "alias": "Sign Size", "length": 9, "domain": { "type": "codedValue", "name": "cvd_SignSize", "description": "DESC", "codedValues": [ { "name": "30 x 30 Octagon", "code": "30x30o" }, { "name": "30 x 30 x 30 Yield", "code": "30x30x30y" }, { "name": "36 x 36 x 36 Yield", "code": "36x36x36y" }, { "name": "9 x 24 SNB", "code": "9x24snb" }, { "name": "9 x 30 SNB", "code": "9x30snb" }, { "name": "9 x 36 SNB", "code": "9x36snb" }, { "name": "9 x 42 SNB", "code": "9x42snb" }, { "name": "9 x 48 SNB", "code": "9x48snb" }, { "name": "9 x 54 SNB", "code": "9x54snb" }, { "name": "9 x 60 SNB", "code": "9x60snb" }, { "name": "6 x 12", "code": "6x12" }, { "name": "6 x 18", "code": "6x18" }, { "name": "6 x 24", "code": "6x24" }, { "name": "8 x 18", "code": "8x18" }, { "name": "8 x 24", "code": "8x24" }, { "name": "9 x 12", "code": "9x12" }, { "name": "9 x 15", "code": "9x15" }, { "name": "9 x 18", "code": "9x18" }, { "name": "10 x 24", "code": "10x24" }, { "name": "12 x 18", "code": "12x18" }, { "name": "12 x 24", "code": "12x24" }, { "name": "12 x 30", "code": "12x30" }, { "name": "15 x 30", "code": "15x30" }, { "name": "18 x 24", "code": "18x24" }, { "name": "18 x 30", "code": "18x30" }, { "name": "18 x 36", "code": "18x36" }, { "name": "20 x 36", "code": "20x36" }, { "name": "24 x 30", "code": "24x30" }, { "name": "24 x 36", "code": "24x36" }, { "name": "24 x 48", "code": "24x48" }, { "name": "18 x 18", "code": "18x18" }, { "name": "30 x 36", "code": "30x36" }, { "name": "36 x 42", "code": "36x42" }, { "name": "24 x 24 Diamond / Square", "code": "24x24ds" }, { "name": "30 x 30 Diamond / Square", "code": "30x30ds" }, { "name": "36 x 36 Diamond / Square", "code": "36x36ds" }, { "name": "30 x 30 Pentagon", "code": "30x30p" }, { "name": "36 x 36 Pentagon", "code": "36x36p" }, { "name": "Unknown", "code": "Unk" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Sign Direction", "length": 2, "domain": { "type": "codedValue", "name": "cvd_Orientation", "description": "DESC", "codedValues": [ { "name": "North", "code": "N" }, { "name": "South", "code": "S" }, { "name": "East", "code": "E" }, { "name": "West", "code": "W" }, { "name": "Northeast", "code": "NE" }, { "name": "Northwest", "code": "NW" }, { "name": "Southeast", "code": "SE" }, { "name": "Southwest", "code": "SW" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignColor", "type": "esriFieldTypeString", "alias": "Sign Color", "length": 255, "domain": { "type": "codedValue", "name": "SignColor", "description": "", "codedValues": [ { "name": "Green", "code": "GREEN" }, { "name": "Brown", "code": "BROWN" }, { "name": "Red", "code": "RED" }, { "name": "Blue", "code": "BLUE" }, { "name": "Yellow", "code": "YELLOW" }, { "name": "Other", "code": "OTH" }, { "name": "White", "code": "WHITE" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "Reflectivity", "type": "esriFieldTypeInteger", "alias": "Reflectivity", "domain": null }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Sign Condition", "length": 255, "domain": { "type": "codedValue", "name": "cvd_PoleCondition", "description": "DESC", "codedValues": [ { "name": "Good", "code": "Good" }, { "name": "Fair", "code": "Fair" }, { "name": "Poor", "code": "Poor" }, { "name": "Unknown", "code": "Unknown" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" } }, { "name": "SignInstallDate", "type": "esriFieldTypeDate", "alias": "Date Sign Installed", "length": 8, "domain": null }, { "name": "SignComment", "type": "esriFieldTypeString", "alias": "Comments", "length": 255, "domain": null }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "ParentGlobalID", "length": 38, "domain": null } ], "indexes": [ { "name": "R288_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_288", "fields": "globalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_2901_parentg", "fields": "parentglobalid", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_288", "fields": "globalid,OBJECTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [ { "id": 0, "name": "Sign_Poles", "relatedTableId": 4, "role": "esriRelRoleDestination", "keyField": "parentglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "124e724faeec419b8252fe7d9ca1a16a" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 3, "name": "GISEDIT.DBO.Signs__ATTACH", "type": "Table", "description": null, "hasAttachments": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "displayField": "ATT_NAME", "typeIdField": null, "subtypeFieldName": null, "subtypeField": null, "defaultSubtypeCode": null, "fields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null }, { "name": "REL_GLOBALID", "type": "esriFieldTypeGUID", "alias": "REL_GLOBALID", "length": 38, "domain": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "length": 150, "domain": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "length": 250, "domain": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null }, { "name": "DATA", "type": "esriFieldTypeBlob", "alias": "DATA", "domain": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "domain": null } ], "indexes": [ { "name": "R295_SDE_ROWID_UK", "fields": "ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_295", "fields": "GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "GDB_3314_REL_GLO", "fields": "REL_GLOBALID", "isAscending": true, "isUnique": false, "description": "" }, { "name": "UUID_OID_295", "fields": "GLOBALID,ATTACHMENTID", "isAscending": true, "isUnique": true, "description": "" } ], "subtypes": [], "relationships": [], "capabilities": "Map,Query,Data", "maxRecordCount": 5000, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportedQueryFormats": "JSON, PBF", "isDataVersioned": true, "useStandardizedQueries": true, "advancedQueryCapabilities": { "useStandardizedQueries": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsPagination": true, "supportsTrueCurve": false, "supportsReturningQueryExtent": true, "supportsQueryWithDistance": true, "supportsSqlExpression": true, "supportsTimeRelation": true, "supportsSqlFormat": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "dateFieldsTimeReference": null, "preferredTimeReference": null, "datesInUnknownTimezone": false, "hasMetadata": true, "isDataArchived": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "serviceItemId": "124e724faeec419b8252fe7d9ca1a16a" } ] }