{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "Sign Poles", "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": 24000, "maxScale": 0, "referenceScale": 0.0, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriPMS", "url": "76887354a53709d50a30e743d0d71efb", "imageData": "iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABpElEQVQ4jbXUv0vUYRwH8NfjKV4USh2VFJQWDllIS1RC3GJDLUVDS/UX1FBRQyWlYzQErrnVIkWLEJxBFARFi2lFaEFDSZ4QgZd6nOjTkIU/vp4X1Gd74Hlez/sDn+ep9o+q+r9DMdqLY9iBEt7iQQhGK4JitB4906NOfL5PYYRUmswBth53M0a3cCMEcytCMarH8+HbWt5cZba4+JK1TWrbenVs2KcJp8sl6h7p1vL6YnK7k5942k77S6di9CwEd5ZBMWos5p0ZupKM/K6ZCQbOk83piFFPCOLSREe+PBRmp8pDMPaY4pht6QatGFwKbS+MrI78ik9hmHSDxiRoOpWuEEJqDfiTfyE0mDlYGVK9jvpWcxhKgnJbjsrX7bJ54n15qPkcqbRcCPLLoBBMx+hSW6+7T7KUvicjG7Ps6TSFy4tSLlyE4F6Mdh5+pXPgAl8fEefnt6ae5rPsvm6yqtbJELxbEZrHumL04lCfrtI3+wsfhVSauhalqhp9uBaC4aXnEh9tCPrRH6NNmYxGzOBDCH4kN7zKNxKCcYyX21MR9Df1E4GRe/OrXephAAAAAElFTkSuQmCC", "contentType": "image/png", "width": 13, "height": 13, "angle": 0, "xoffset": 0, "yoffset": 0 } }, "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": 0.001, "mTolerance": 0.001, "falseX": -123407700, "falseY": -86123500, "xyUnits": 3.592069011000888E7, "falseZ": -100000, "zUnits": 10000, "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": "Shape", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null }, { "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": "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": 20000, "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": "bebc9e0cacf14126812daa181819f30d" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 1, "name": "Sign Attachments", "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": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "length": 38, "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 } ], "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": 20000, "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": "bebc9e0cacf14126812daa181819f30d" }, { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "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": "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 }, { "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" } } ], "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": 0, "role": "esriRelRoleDestination", "keyField": "parentglobalid", "cardinality": "esriRelCardinalityOneToMany", "composite": true } ], "capabilities": "Map,Query,Data", "maxRecordCount": 20000, "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": "bebc9e0cacf14126812daa181819f30d" } ] }