{ "layers": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 4, "name": "Sign Poles & Street Signs", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPoint", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Signs", "relatedTableId": 2, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleOrigin", "keyField": "globalid", "composite": true } ], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": 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 } }, "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 }, "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": [ 153, 35, 114, 255 ], "toColor": [ 153, 35, 114, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 101, 176, 48, 255 ], "toColor": [ 101, 176, 48, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 45, 148, 173, 255 ], "toColor": [ 45, 148, 173, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 171, 101, 44, 255 ], "toColor": [ 171, 101, 44, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 55, 38, 171, 255 ], "toColor": [ 55, 38, 171, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 49, 71, 130, 255 ], "toColor": [ 49, 71, 130, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 39, 161, 110, 255 ], "toColor": [ 39, 161, 110, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 173, 38, 52, 255 ], "toColor": [ 173, 38, 52, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 129, 130, 59, 255 ], "toColor": [ 129, 130, 59, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 130, 52, 68, 255 ], "toColor": [ 130, 52, 68, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 120, 74, 168, 255 ], "toColor": [ 120, 74, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 158, 40, 168, 255 ], "toColor": [ 158, 40, 168, 255 ] }, { "type": "algorithmic", "algorithm": "esriCIELabAlgorithm", "fromColor": [ 163, 173, 52, 255 ], "toColor": [ 163, 173, 52, 255 ] } ] } } }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "hasM": false, "hasZ": false, "allowGeometryUpdates": true, "allowTrueCurvesUpdates": false, "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "FacilityID", "typeIdField": "SZ_SignStatus", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "FacilityID", "type": "esriFieldTypeString", "alias": "Pole ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "FacilityID" }, { "name": "InspectionDate", "type": "esriFieldTypeDate", "alias": "Inspection Date", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "InspectionDate" }, { "name": "Inspector", "type": "esriFieldTypeString", "alias": "Inspector Name", "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" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Inspector" }, { "name": "PoleCondition", "type": "esriFieldTypeString", "alias": "Pole Condition", "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" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "PoleCondition" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Sector" }, { "name": "PoleType", "type": "esriFieldTypeString", "alias": "Pole Type", "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" }, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PoleType" }, { "name": "Owner", "type": "esriFieldTypeString", "alias": "Owner", "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" }, "editable": true, "nullable": true, "length": 7, "defaultValue": null, "modelName": "Owner" }, { "name": "PoleInstallDate", "type": "esriFieldTypeDate", "alias": "Date Pole Installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "PoleInstallDate" }, { "name": "PoleComment", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleComment" }, { "name": "REF_COMPL", "type": "esriFieldTypeString", "alias": "REF_COMPL", "domain": { "type": "codedValue", "name": "YesNo", "description": "Yes or No", "codedValues": [ { "name": "Yes", "code": "Yes" }, { "name": "No", "code": "No" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 5, "defaultValue": null, "modelName": "REF_COMPL" }, { "name": "SZ_InspectionDate", "type": "esriFieldTypeDate", "alias": "SZ_InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SZ_InspectionDate" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "SZ_SignStatus" }, { "name": "AS_InspectionDate", "type": "esriFieldTypeDate", "alias": "AS_InspectionDate", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "AS_InspectionDate" }, { "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" }, "editable": true, "nullable": true, "defaultValue": null, "modelName": "AS_SignStatus" } ], "geometryField": { "name": "Shape", "type": "esriFieldTypeGeometry", "alias": "Shape", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [ { "id": 3, "name": "COMPLETED", "domains": { "Inspector": {"type": "inherited"}, "PoleCondition": {"type": "inherited"}, "Sector": {"type": "inherited"}, "PoleType": {"type": "inherited"}, "Owner": {"type": "inherited"}, "REF_COMPL": {"type": "inherited"}, "SZ_SignStatus": {"type": "inherited"}, "AS_SignStatus": {"type": "inherited"} }, "templates": [ { "name": "COMPLETED", "description": "", "prototype": { "attributes": {"SZ_SignStatus": 3} }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": 2, "name": "REMOVED", "domains": { "Inspector": {"type": "inherited"}, "PoleCondition": {"type": "inherited"}, "Sector": {"type": "inherited"}, "PoleType": {"type": "inherited"}, "Owner": {"type": "inherited"}, "REF_COMPL": {"type": "inherited"}, "SZ_SignStatus": {"type": "inherited"}, "AS_SignStatus": {"type": "inherited"} }, "templates": [ { "name": "REMOVED", "description": "", "prototype": { "attributes": {"SZ_SignStatus": 2} }, "drawingTool": "esriFeatureEditToolPoint" } ] }, { "id": 1, "name": "OLD", "domains": { "Inspector": {"type": "inherited"}, "PoleCondition": {"type": "inherited"}, "Sector": {"type": "inherited"}, "PoleType": {"type": "inherited"}, "Owner": {"type": "inherited"}, "REF_COMPL": {"type": "inherited"}, "SZ_SignStatus": {"type": "inherited"}, "AS_SignStatus": {"type": "inherited"} }, "templates": [ { "name": "OLD", "description": "", "prototype": { "attributes": {"SZ_SignStatus": 1} }, "drawingTool": "esriFeatureEditToolPoint" } ] } ], "templates": [], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 8000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "bf3c70823d5043868579ce9ebd00f7d9" } ], "tables": [ { "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 2, "name": "GISEDIT.DBO.Signs", "type": "Table", "description": "", "copyrightText": "", "editFieldsInfo": null, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [ { "id": 0, "name": "Sign_Poles", "relatedTableId": 4, "cardinality": "esriRelCardinalityOneToMany", "role": "esriRelRoleDestination", "keyField": "parentglobalid", "composite": true } ], "isDataVersioned": true, "isDataArchived": false, "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": false, "supportsCalculate": true, "supportsASyncCalculate": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": false, "supportsSqlExpression": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasMetadata": true, "hasAttachments": true, "supportsAttachmentsByUploadId": true, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeNone", "objectIdField": "OBJECTID", "globalIdField": "globalid", "displayField": "Primary_", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "GlobalID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "globalid" }, { "name": "Primary_", "type": "esriFieldTypeString", "alias": "Primary Sign", "domain": { "type": "codedValue", "name": "cvd_Primary", "description": "DESC", "codedValues": [ { "name": "Yes", "code": "YES" }, { "name": "No", "code": "NO" } ], "mergePolicy": "esriMPTDefaultValue", "splitPolicy": "esriSPTDefaultValue" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "Primary_" }, { "name": "PoleID", "type": "esriFieldTypeString", "alias": "Pole ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "PoleID" }, { "name": "SignID", "type": "esriFieldTypeString", "alias": "Sign ID", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignID" }, { "name": "SignDistrict", "type": "esriFieldTypeString", "alias": "Sign District", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignDistrict" }, { "name": "SignType", "type": "esriFieldTypeString", "alias": "Sign Type", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SignType" }, { "name": "SchoolType", "type": "esriFieldTypeString", "alias": "School Type", "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" }, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SchoolType" }, { "name": "SignCode", "type": "esriFieldTypeString", "alias": "MUTCD Code", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignCode" }, { "name": "SheetingType", "type": "esriFieldTypeString", "alias": "Sheeting Type", "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" }, "editable": true, "nullable": true, "length": 3, "defaultValue": null, "modelName": "SheetingType" }, { "name": "Material", "type": "esriFieldTypeString", "alias": "Material", "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" }, "editable": true, "nullable": true, "length": 1, "defaultValue": null, "modelName": "Material" }, { "name": "SignSize", "type": "esriFieldTypeString", "alias": "Sign Size", "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" }, "editable": true, "nullable": true, "length": 9, "defaultValue": null, "modelName": "SignSize" }, { "name": "Orientation", "type": "esriFieldTypeString", "alias": "Sign Direction", "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" }, "editable": true, "nullable": true, "length": 2, "defaultValue": null, "modelName": "Orientation" }, { "name": "SignColor", "type": "esriFieldTypeString", "alias": "Sign Color", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignColor" }, { "name": "Reflectivity", "type": "esriFieldTypeInteger", "alias": "Reflectivity", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "Reflectivity" }, { "name": "Condition", "type": "esriFieldTypeString", "alias": "Sign Condition", "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" }, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "Condition" }, { "name": "SignInstallDate", "type": "esriFieldTypeDate", "alias": "Date Sign Installed", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "SignInstallDate" }, { "name": "SignComment", "type": "esriFieldTypeString", "alias": "Comments", "domain": null, "editable": true, "nullable": true, "length": 255, "defaultValue": null, "modelName": "SignComment" }, { "name": "parentglobalid", "type": "esriFieldTypeGUID", "alias": "ParentGlobalID", "domain": null, "editable": true, "nullable": true, "length": 38, "defaultValue": null, "modelName": "parentglobalid" } ], "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": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "GISEDIT.DBO.Signs", "description": "", "prototype": { "attributes": { "SignComment": null, "SignInstallDate": null, "parentglobalid": null, "Primary_": null, "PoleID": null, "SignID": null, "SignDistrict": null, "SignType": null, "SchoolType": null, "SignCode": null, "SheetingType": null, "Material": null, "SignSize": null, "Orientation": null, "SignColor": null, "Reflectivity": null, "Condition": null } }, "drawingTool": "esriFeatureEditToolNone" } ], "maxRecordCount": 5000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "useStandardizedQueries": true, "attachmentProperties": [ { "name": "id", "fieldName": "ATTACHMENTID", "isEnabled": true }, { "name": "globalId", "fieldName": "GLOBALID", "isEnabled": true }, { "name": "name", "fieldName": "ATT_NAME", "isEnabled": true }, { "name": "size", "fieldName": "DATA_SIZE", "isEnabled": true }, { "name": "contentType", "fieldName": "CONTENT_TYPE", "isEnabled": true }, { "name": "keywords", "fieldName": "KEYWORDS", "isEnabled": false }, { "name": "exifInfo", "fieldName": "EXIFINFO", "isEnabled": false } ], "attachmentFields": [ { "name": "ATTACHMENTID", "type": "esriFieldTypeOID", "alias": "ATTACHMENTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null }, { "name": "ATT_NAME", "type": "esriFieldTypeString", "alias": "ATT_NAME", "domain": null, "editable": true, "nullable": false, "length": 250, "defaultValue": null }, { "name": "DATA_SIZE", "type": "esriFieldTypeInteger", "alias": "DATA_SIZE", "domain": null, "editable": true, "nullable": false, "defaultValue": null }, { "name": "CONTENT_TYPE", "type": "esriFieldTypeString", "alias": "CONTENT_TYPE", "domain": null, "editable": true, "nullable": false, "length": 150, "defaultValue": null } ], "standardMaxRecordCount": 32000, "tileMaxRecordCount": 5000, "maxRecordCountFactor": 1, "serviceItemId": "bf3c70823d5043868579ce9ebd00f7d9" } ] }