{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "sign_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signs_new", "relatedTableId": 0, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "SignActivityLogs", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "reason": null, "sign_1_cost": null, "comments": null, "activity": null, "sign_id": null, "reused_sign": null, "inspection_date": null, "reflectivity": null, "signid": null, "sign_2_cost": null, "inspector_name": null, "condition": null, "post_cost": null, "missing": null, "sign_3_cost": null, "replacement_advised": null, "stub_cost": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.3, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "SignActivityLogs", "displayField": "inspector_name", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "signid", "domain": null, "name": "signid", "alias": "SignID" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "inspection_date", "domain": null, "name": "inspection_date", "alias": "Inspection Date" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "inspector_name", "domain": null, "name": "inspector_name", "alias": "Inspector Name" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "activity", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Activity", "description": "", "type": "codedValue", "codedValues": [ { "code": "GPS logging", "name": "GPS logging" }, { "code": "Height Adjustment", "name": "Height Adjustment" }, { "code": "Inspected", "name": "Inspected" }, { "code": "Installed", "name": "Installed" }, { "code": "Post replaced", "name": "Post replaced" }, { "code": "Relocation", "name": "Relocation" }, { "code": "Repaired", "name": "Repaired" }, { "code": "Replaced", "name": "Replaced" }, { "code": "Stub replaced", "name": "Stub replaced" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "activity", "alias": "Activity" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "reason", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Reason", "description": "", "type": "codedValue", "codedValues": [ { "code": "Accident", "name": "Accident" }, { "code": "Control sign failure", "name": "Control sign failure" }, { "code": "Correction", "name": "Correction" }, { "code": "Damaged", "name": "Damaged" }, { "code": "Missing", "name": "Missing" }, { "code": "New Installation", "name": "New Installation" }, { "code": "Vandalized", "name": "Vandalized" }, { "code": "Worn out", "name": "Worn out" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "reason", "alias": "Reason" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "condition", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": "Damaged", "name": "Damaged" }, { "code": "Excellent", "name": "Excellent" }, { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "Vandalized", "name": "Vandalized" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "condition", "alias": "Condition" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "reflectivity", "domain": null, "name": "reflectivity", "alias": "Reflectivity" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "comments", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "missing", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "True/False_5", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "FALSE" }, { "code": 1, "name": "TRUE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "missing", "alias": "Missing" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "reused_sign", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "True/False_5", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "FALSE" }, { "code": 1, "name": "TRUE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "reused_sign", "alias": "Reused Sign" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "replacement_advised", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "True/False_5", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "FALSE" }, { "code": 1, "name": "TRUE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "replacement_advised", "alias": "Replacement Advised" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "post_cost", "domain": null, "name": "post_cost", "alias": "Post Cost" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "stub_cost", "domain": null, "name": "stub_cost", "alias": "Stub Cost" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "sign_1_cost", "domain": null, "name": "sign_1_cost", "alias": "Sign 1 Cost" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "sign_2_cost", "domain": null, "name": "sign_2_cost", "alias": "Sign 2 Cost" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "sign_3_cost", "domain": null, "name": "sign_3_cost", "alias": "Sign 3 Cost" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 38, "type": "esriFieldTypeGUID", "modelName": "sign_id", "domain": null, "name": "sign_id", "alias": "Sign_ID" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "supportsTruncate": false, "indexes": [ { "name": "g1241sign_id", "isUnique": false, "description": "", "fields": "sign_id", "isAscending": true }, { "name": "r149_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_149", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeNone", "GUIDFormat": "O", "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": false, "supportsPaginationOnAggregatedQueries": true, "supportsMaxRecordCountFactor": true, "supportsPagination": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsLod": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4cd4e716b3044540a436cb62f49fc21f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 37.475437000000056, "xmin": -97.15332499999994, "ymax": 38.08704130000007, "xmax": -96.52708629999995, "spatialReference": { "falseM": -100000, "xyTolerance": 8.983152841195215E-9, "mUnits": 10000, "zUnits": 10000, "latestWkid": 4326, "zTolerance": 0.001, "wkid": 4326, "xyUnits": 9.999999999999999E8, "mTolerance": 0.001, "falseX": -400, "falseY": -400, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "infoInEstimates": [ "extent", "count" ], "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "relationships": [ { "keyField": "globalid", "role": "esriRelRoleOrigin", "composite": false, "name": "SignActivityLogs", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "2.6.0", "isDataArchived": true, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Signs", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "orientation": null, "last_updated": null, "cross_road": null, "comments": null, "sign_id": null, "legend": null, "latitude": null, "sign_height": null, "third_color": null, "inventory": null, "posts": null, "condition": null, "sign_width": null, "road": null, "back_color": null, "backing": null, "reviewed": 1, "post_type": null, "position": null, "mutcd": null, "legend_color": null, "replacement_advised": null, "longitude": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.3, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Signs", "allowTrueCurvesUpdates": false, "displayField": "sign_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "type": "esriFieldTypeOID", "modelName": "objectid", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "sign_id", "domain": null, "name": "sign_id", "alias": "Sign ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "latitude", "domain": null, "name": "latitude", "alias": "Latitude" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "road", "domain": null, "name": "road", "alias": "Road" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "cross_road", "domain": null, "name": "cross_road", "alias": "Cross Road" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "orientation", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Orientation", "description": "", "type": "codedValue", "codedValues": [ { "code": "E", "name": "E" }, { "code": "E-W", "name": "E-W" }, { "code": "N", "name": "N" }, { "code": "N/S", "name": "N/S" }, { "code": "NE", "name": "NE" }, { "code": "NE/SW", "name": "NW/SW" }, { "code": "NE-SW", "name": "NE-SW" }, { "code": "N-S", "name": "N-S" }, { "code": "NW", "name": "NW" }, { "code": "NW-SE", "name": "NW-SE" }, { "code": "S", "name": "S" }, { "code": "S/N", "name": "S/N" }, { "code": "SE", "name": "SE" }, { "code": "S-N", "name": "S-N" }, { "code": "SW", "name": "SW" }, { "code": "SW-NE", "name": "SW-NE" }, { "code": "W", "name": "W" }, { "code": "W/E", "name": "W/E" }, { "code": "W-E", "name": "W-E" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "orientation", "alias": "Orientation" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "position", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Position", "description": "", "type": "codedValue", "codedValues": [ { "code": "Left", "name": "Left" }, { "code": "Left-Bridge", "name": "Left-Bridge" }, { "code": "Median", "name": "Median" }, { "code": "Right", "name": "Right" }, { "code": "Right-Bridge", "name": "Right-Bridge" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "position", "alias": "Position" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "mutcd", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "MUTCD", "description": "", "type": "codedValue", "codedValues": [ { "code": "D1-1", "name": "D1-1" }, { "code": "D1-1a", "name": "D1-1a" }, { "code": "D1-2", "name": "D1-2" }, { "code": "D1-2a", "name": "D1-2a" }, { "code": "D2-2", "name": "D2-2" }, { "code": "D2-3", "name": "D2-3" }, { "code": "DL-5Y", "name": "DL-5Y" }, { "code": "EBP", "name": "EBP" }, { "code": "EC", "name": "EC" }, { "code": "M3-4/M1-9", "name": "M3-4/M1-9" }, { "code": "OM2-1V", "name": "OM2-1V" }, { "code": "OM3-L", "name": "OM3-L" }, { "code": "OM3-R", "name": "OM3-R" }, { "code": "R1-1", "name": "R1-1" }, { "code": "R1-1 / Custom", "name": "R1-1 / Custom" }, { "code": "R1-1 / OM2-1V", "name": "R1-1 / OM2-1V" }, { "code": "R1-1 / R1-3-4", "name": "R1-1 / R1-3-4" }, { "code": "R1-1 / S1-1", "name": "R1-1 / S1-1" }, { "code": "R1-1 / W4-4P", "name": "R1-1 / W4-4P" }, { "code": "R1-2", "name": "R1-2" }, { "code": "R12-1", "name": "R12-1" }, { "code": "R12-3", "name": "R12-3" }, { "code": "R12-5", "name": "R12-5" }, { "code": "R2-1", "name": "R2-1" }, { "code": "R2-1 / Custom", "name": "R2-1 / Custom" }, { "code": "R2-1 / R2-5d", "name": "R2-1 / R2-5d" }, { "code": "R2-1 / R3-9dP", "name": "R2-1 / R3-9dP" }, { "code": "R2-5a", "name": "R2-5a" }, { "code": "R2-5c", "name": "R2-5c" }, { "code": "R3-7", "name": "R3-7" }, { "code": "R4-7 / R4-7a / OM3-L", "name": "R4-7 / R4-7a / OM3-L" }, { "code": "R5-1", "name": "R5-1" }, { "code": "R5-2a", "name": "R5-2a" }, { "code": "R5-4", "name": "R5-4" }, { "code": "R5-4 / Custom", "name": "R5-4 / Custom" }, { "code": "R8-3", "name": "R8-3" }, { "code": "S1-1", "name": "S1-1" }, { "code": "S3-1", "name": "S3-1" }, { "code": "S3-3", "name": "S3-3" }, { "code": "S4-3 / R2-1 / S4-1P", "name": "S4-3 / R2-1 / S4-1P" }, { "code": "S4-3 / SR2-1 / S4-6P / S4-1P", "name": "S4-3 / R2-1 / S4-6P / S4-1P" }, { "code": "S4-5", "name": "S4-5" }, { "code": "S5-2", "name": "S5-2" }, { "code": "StreetSign", "name": "StreetSign" }, { "code": "W10-1", "name": "W10-1" }, { "code": "W10-3R", "name": "W10-3R" }, { "code": "W11-20-30", "name": "W11-20-30" }, { "code": "W1-1aL", "name": "W1-1aL" }, { "code": "W1-1aR", "name": "W1-1aR" }, { "code": "W1-1L", "name": "W1-1L" }, { "code": "W1-1L / W13-1P", "name": "W1-1L / W13-1P" }, { "code": "W1-1R", "name": "W1-1R" }, { "code": "W1-1R / W13-1P", "name": "W1-1R / W13-1P" }, { "code": "W12-2", "name": "W12-2" }, { "code": "W1-2L", "name": "W1-2L" }, { "code": "W1-2L / W13-1P", "name": "W1-2L / W13-1P" }, { "code": "W1-2L/W13-1P", "name": "W1-2L/W13-1P" }, { "code": "W1-2R", "name": "W1-2R" }, { "code": "W1-2R / W13-1P", "name": "W1-2R / W13-1P" }, { "code": "W1-2R/W13-1P", "name": "W1-2R/W13-1P" }, { "code": "W13-1P", "name": "W13-1P" }, { "code": "W1-3L", "name": "W1-3L" }, { "code": "W1-3R", "name": "W1-3R" }, { "code": "W1-3R / W13-1P", "name": "W1-3R / W13-1P" }, { "code": "W14-1", "name": "W14-1" }, { "code": "W14-2", "name": "W14-2" }, { "code": "W1-4L", "name": "W-4L" }, { "code": "W1-4L / W13-1P", "name": "W1-4L / W13-1P" }, { "code": "W1-4P / W13-1P", "name": "W1-4P / W13-1P" }, { "code": "W1-4R", "name": "W1-4R" }, { "code": "W1-4R / W13-1P", "name": "W1-4R / W13-1P" }, { "code": "W1-5L / W13-1P", "name": "W1-5L / W13-1P" }, { "code": "W1-5R", "name": "W1-5R" }, { "code": "W1-5R / W13-1P", "name": "W1-5R / W13-1P" }, { "code": "W1-6", "name": "W1-6" }, { "code": "W1-6 / R1-1", "name": "W1-6 / R1-1" }, { "code": "W16-5", "name": "W16-5" }, { "code": "W16-6", "name": "W16-6" }, { "code": "W1-7", "name": "W1-7" }, { "code": "W1-8L", "name": "W1-8L" }, { "code": "W1-8L/R", "name": "W1-8L/R" }, { "code": "W1-8R", "name": "W1-8R" }, { "code": "W2-1", "name": "W2-1" }, { "code": "W2-1 / I-5", "name": "W2-1 / I-5" }, { "code": "W2-2", "name": "W2-2" }, { "code": "W2-2L", "name": "W2-2L" }, { "code": "W2-2R", "name": "W2-2R" }, { "code": "W2-3R", "name": "W2-3R" }, { "code": "W3-1", "name": "W3-1" }, { "code": "W3-1a", "name": "W3-1a" }, { "code": "W3-3", "name": "W3-3" }, { "code": "W3-5", "name": "W3-5" }, { "code": "W42-7", "name": "W42-7" }, { "code": "W5-2", "name": "W5-2" }, { "code": "W5-3", "name": "W5-3" }, { "code": "W54-56", "name": "W54-56" }, { "code": "W7-1", "name": "W7-1" }, { "code": "W8-1", "name": "W8-1" }, { "code": "W8-1 / W13-1P", "name": "W8-1 / W13-1P" }, { "code": "W8-13", "name": "W8-13" }, { "code": "W8-3", "name": "W8-3" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "mutcd", "alias": "MUTCD" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "legend", "domain": null, "name": "legend", "alias": "Legend" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "sign_width", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SignWidth", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "0" }, { "code": 6, "name": "6" }, { "code": 9, "name": "9" }, { "code": 12, "name": "12" }, { "code": 18, "name": "18" }, { "code": 24, "name": "24" }, { "code": 30, "name": "30" }, { "code": 36, "name": "36" }, { "code": 48, "name": "48" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sign_width", "alias": "Sign Width" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "sign_height", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SignHeight", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "0" }, { "code": 8, "name": "8" }, { "code": 12, "name": "12" }, { "code": 18, "name": "18" }, { "code": 24, "name": "24" }, { "code": 30, "name": "30" }, { "code": 36, "name": "36" }, { "code": 48, "name": "48" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "sign_height", "alias": "Sign Height" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "back_color", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "BackColor", "description": "", "type": "codedValue", "codedValues": [ { "code": "Blue", "name": "Blue" }, { "code": "Green", "name": "Green" }, { "code": "N/A", "name": "N/A" }, { "code": "Orange", "name": "Orange" }, { "code": "Red", "name": "Red" }, { "code": "White", "name": "White" }, { "code": "Yellow", "name": "Yellow" }, { "code": "YLGreen-FL", "name": "YLGreen-FL" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "back_color", "alias": "Back Color" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "legend_color", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "LegendColor", "description": "", "type": "codedValue", "codedValues": [ { "code": "Black", "name": "Black" }, { "code": "N/A", "name": "N/A" }, { "code": "Orange", "name": "Orange" }, { "code": "Red", "name": "Red" }, { "code": "White", "name": "White" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "legend_color", "alias": "Legend Color" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "third_color", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "ThirdColor", "description": "", "type": "codedValue", "codedValues": [ { "code": "Black", "name": "Black" }, { "code": "Green", "name": "Green" }, { "code": "N/A", "name": "N/A" }, { "code": "Red", "name": "Red" }, { "code": "White", "name": "White" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "third_color", "alias": "Third Color" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "backing", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Backing", "description": "", "type": "codedValue", "codedValues": [ { "code": "Aluminum", "name": "Aluminum" }, { "code": "Wood", "name": "Wood" }, { "code": "Steel", "name": "Steel" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "backing", "alias": "Backing" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "posts", "domain": null, "name": "posts", "alias": "Posts" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "post_type", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PostType", "description": "", "type": "codedValue", "codedValues": [ { "code": "2 x 2 Steel", "name": "2 x 2 Steel" }, { "code": "3 x 3 Steel", "name": "3 x 3 Steel" }, { "code": "4 x 4 Wood", "name": "4 x 4 Wood" }, { "code": "Heavy U-channel", "name": "Heavy U-channel" }, { "code": "Light U-channel", "name": "Light U-channel" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "post_type", "alias": "Post Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "comments", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_updated", "domain": null, "name": "last_updated", "alias": "Last Updated" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeDouble", "modelName": "longitude", "domain": null, "name": "longitude", "alias": "long" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "globalid" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "condition", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Condition", "description": "", "type": "codedValue", "codedValues": [ { "code": "Damaged", "name": "Damaged" }, { "code": "Excellent", "name": "Excellent" }, { "code": "Good", "name": "Good" }, { "code": "Fair", "name": "Fair" }, { "code": "Poor", "name": "Poor" }, { "code": "Vandalized", "name": "Vandalized" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "condition", "alias": "Condition" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeInteger", "modelName": "replacement_advised", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "True/False_5", "description": "", "type": "codedValue", "codedValues": [ { "code": 0, "name": "FALSE" }, { "code": 1, "name": "TRUE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "replacement_advised", "alias": "Replacement Advised" }, { "nullable": true, "editable": true, "defaultValue": 1, "domain": { "name": "Signs_reviewed_9daa21a5-b86b-4f77-8250-1b6f67d85e9b", "type": "codedValue", "codedValues": [ { "code": 0, "name": "Reviewed", "count": "(4879)" }, { "code": 1, "name": "Un-Reviewed", "count": "(1)" } ] }, "name": "reviewed", "alias": "reviewed", "type": "esriFieldTypeInteger" }, { "nullable": true, "editable": true, "defaultValue": null, "domain": "{\"name\":\"Signs_inventory_99916f10-49fe-4404-85e9-974b36c42215\",\"type\":\"codedValue\",\"codedValues\":[{\"code\":0,\"name\":\"Inventory\"},{\"code\":1,\"name\":\"In Use\"},{\"code\":2,\"name\":\"On Truck\"}]}", "name": "inventory", "alias": "Inventory", "type": "esriFieldTypeInteger" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "isView": true, "useStandardizedQueries": true, "globalIdField": "globalid", "description": "", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "isUpdatableView": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "r148_sde_rowid_uk", "isUnique": false, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_148", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a107_ix1", "isUnique": true, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": false, "supportsQueryWithDistance": true, "supportsLod": true, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "4cd4e716b3044540a436cb62f49fc21f", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "shapefile,geojson,csv,featureCollection,excel,jsonl,featureService", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.2.0", "drawingInfo": { "renderer": { "symbol": { "imageData": "iVBORw0KGgoAAAANSUhEUgAAABsAAAAbCAYAAACN1PRVAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABeElEQVRIic3WvW3CQBTA8T8GwkdP4Yzg9tyzgEVDxQKQKhsggdiACljATTooGcFuGcEUDEBAEaQItoztM/ciBeVJlnySz7977z50NZ4Ytf+OqduzAaK/xBQwATxgD7gSUIIpYKIcyxv264xmJxsIJKAplkCTtxe8bhXlWLiDowg0wXIQgHIsAr8lAh9hOWj18ZVgUrAMy0H7w5XR7JR8EG3bIlCHFZZOOypDsAgTQRIwixWWLo4o9V7UfgSmscLFkJ6jbLiD4117PW/idataMIt5w37duHTZiDNVjsVy3Ig3vgesstgG2I9mJzte1sqxRNhrpwJAuLswXZwBwtt/yWIRPykH7uBoB34L5VhE2/bdyNOlC/xWAgDYnQrh7kLv/ZPocA2BHpo504JlmdgprAwqwsSgKaTDxKAJVIZpwfW8SXS4JiU0hR5hhWB6W0ggE0yboRQyxXLgctxgujiLIAl2B95OBhEkxdKgxxNuVzG4+kW/515SvwGgLQDP5Q0mDwAAAABJRU5ErkJggg==", "yoffset": 0, "width": 20, "xoffset": 0, "angle": 0, "type": "esriPMS", "contentType": "image/png", "url": "e3aebfeedc7fa1ca4c1706041364ff8a", "height": 20 }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeDistinct", "nullable": true, "editable": true, "name": "shape", "typeName": "st_point", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "zDefault": 0, "geometryType": "esriGeometryPoint", "supportsLayerOverrides": true } ] }