{ "tables": [ { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1749066010942}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 0, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 4, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Signals", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "features": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Signals", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_TYPE", "description": "Signal Type", "type": "codedValue", "codedValues": [ { "code": "T11", "name": "T11" }, { "code": "T12", "name": "T12" }, { "code": "T21", "name": "T21" }, { "code": "T22", "name": "T22" }, { "code": "T31-TS-1", "name": "T31-TS-1" }, { "code": "T32F-TS-1LF", "name": "T32F-TS-1LF" }, { "code": "T32-TS-1L", "name": "T32-TS-1L" }, { "code": "T34A-TS-1R", "name": "T34A-TS-1R" }, { "code": "T34FA-TS-1RF", "name": "T34FA-TS-1RF" }, { "code": "T34F-TS-1RF", "name": "T34F-TS-1RF" }, { "code": "T34-TS-1R", "name": "T34-TS-1R" }, { "code": "T35L", "name": "T35L" }, { "code": "T35R", "name": "T35R" }, { "code": "T35S", "name": "T35S" }, { "code": "T41-TS-1LB", "name": "T41-TS-1LB" }, { "code": "T42-TS-1RB", "name": "T42-TS-1RB" }, { "code": "T43F-TS-1LFF", "name": "T43F-TS-1LFF" }, { "code": "T44FA-TS-1RFF", "name": "T44FA-TS-1RFF" }, { "code": "T44F-TS-1RFF", "name": "T44F-TS-1RFF" }, { "code": "T51A-TS-1LL", "name": "T51A-TS-1LL" }, { "code": "T51-TS-1LL", "name": "T51-TS-1LL" }, { "code": "T52A-TS-1RR", "name": "T52A-TS-1RR" }, { "code": "T52-TS-1RR", "name": "T52-TS-1RR" }, { "code": "T53A-TS-1LR", "name": "T53A-TS-1LR" }, { "code": "T54A-TS-1LFR", "name": "T54A-TS-1LFR" }, { "code": "T55A-TS-1LRFF", "name": "T55A-TS-1LRFF" }, { "code": "T15-LS-1A", "name": "T15-LS-1A" }, { "code": "T16-LS-1B", "name": "T16-LS-1B" }, { "code": "T25-LS-1C", "name": "T25-LS-1C" }, { "code": "SB-SPEED BOARD", "name": "SB-SPEED BOARD" }, { "code": "PED HYBRID BEACON", "name": "PED HYBRID BEACON" }, { "code": "TS-1 LANE INDICATOR", "name": "TS-1 LANE INDICATOR" }, { "code": "T23-PS-1", "name": "T23-PS-1" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": null, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "SPECIAL_FEATURES", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_FEATURES", "description": "Signal Special Features", "type": "codedValue", "codedValues": [ { "code": "LOUVER & REFLECTIVE BORDER", "name": "Louver & Reflective Border" }, { "code": "LOUVERS", "name": "Louvers" }, { "code": "OPTICAL", "name": "Optical" }, { "code": "OPTICAL & REFLECTIVE BORDER", "name": "Optical & Reflective Border" }, { "code": "REFLECTIVE BORDER", "name": "Reflective Border" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6007signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3019_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3019", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1748374160129}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 1, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 5, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Radios", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "features": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Radios", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "RADIO_TYPE", "description": "Radio Type", "type": "codedValue", "codedValues": [ { "code": "2.4 GHZ IP", "name": "2.4 GHZ IP" }, { "code": "5.8 GHZ IP", "name": "5.8 GHZ IP" }, { "code": "900 MHZ", "name": "900 MHZ" }, { "code": "OTHER", "name": "Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": null, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "SPECIAL_FEATURES", "domain": null, "name": "features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6008signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3020_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3020", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1748628851721}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 2, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 6, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Push_Buttons", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "features": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Push_Buttons", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PUSH_BUTTON_TYPE", "description": "Push Button Type", "type": "codedValue", "codedValues": [ { "code": "PPB", "name": "PPB" }, { "code": "PIEZO", "name": "PIEZO" }, { "code": "AUDIBLE", "name": "AUDIBLE" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PUSH_BUTTON_MANUFACTURER", "description": "Push Button Manufacturer", "type": "codedValue", "codedValues": [ { "code": "GUARDIAN", "name": "GUARDIAN" }, { "code": "NOVAX", "name": "NOVAX" }, { "code": "PIEZO", "name": "PIEZO" }, { "code": "POLERA", "name": "POLERA" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FEATURES", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PUSH_BUTTON_FEATURES", "description": "Push Button Features", "type": "codedValue", "codedValues": [ { "code": "TACTILE", "name": "Tactile" }, { "code": "LIGHT", "name": "Light" }, { "code": "ARROW", "name": "Arrow" }, { "code": "OTHER", "name": "Other" }, { "code": "MULTIPLE", "name": "Multiple Features" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6009signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3021_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3021", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1748628851721}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 4, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 7, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Pedestrian_Heads", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "special_features": null, "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Pedestrian_Heads", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "PED_HEAD_TYPE", "description": "Pedestrian Head Type", "type": "codedValue", "codedValues": [ { "code": "PS-1 AUDIBLE COUNTDOWN", "name": "PS-1 AUDIBLE COUNTDOWN" }, { "code": "PS-1 AUDIBLE COUNTDOWN CHIRP", "name": "PS-1 AUDIBLE COUNTDOWN CHIRP" }, { "code": "PS-1 AUDIBLE COUNTDOWN TWEET", "name": "PS-1 AUDIBLE COUNTDOWN TWEET" }, { "code": "PS-1 COUNTDOWN", "name": "PS-1 COUNTDOWN" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": null, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "SPECIAL_FEATURES", "domain": null, "name": "special_features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6011signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3023_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3023", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1749472997562}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 8, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Detection", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "detection_direction": null, "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "features": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Detection", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DETECTION_TYPE", "description": "Signal Detection Type", "type": "codedValue", "codedValues": [ { "code": "CAMERA", "name": "CAMERA" }, { "code": "LOOP", "name": "LOOP" }, { "code": "MICROWAVE", "name": "MICROWAVE" }, { "code": "OPTICAL PREEMPTION", "name": "OPTICAL PREEMPTION" }, { "code": "OTHER", "name": "OTHER" }, { "code": "PTZ CAMERA", "name": "PTZ CAMERA" }, { "code": "RADAR", "name": "RADAR" }, { "code": "THERMAL", "name": "THERMAL" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DETECTION_MANUFACTURER", "description": "Signal Detection Manufacturer", "type": "codedValue", "codedValues": [ { "code": "AUTOSCOPE", "name": "Camera AUTOSCOPE" }, { "code": "ITERIS", "name": "Camera ITERIS" }, { "code": "OPTICOM", "name": "Opticom" }, { "code": "PEEK", "name": "Camera PEEK" }, { "code": "SEDCO", "name": "Radar SEDCO" }, { "code": "SENSYS", "name": "Other SENSYS" }, { "code": "TRAFICON", "name": "Camera TRAFICON" }, { "code": "WAVETRONIX", "name": "Radar WAVETRONIX" }, { "code": "AVIGILON", "name": "PTZ Camera AVIGILON" }, { "code": "GRIDSMART", "name": "Camera GRIDSMART" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "FEATURES", "domain": null, "name": "features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "DETECTION_DIRECTION", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "DETECTION_DIRECTION", "description": "Signal Detection Direction", "type": "codedValue", "codedValues": [ { "code": "East/West", "name": "East/West" }, { "code": "North/South", "name": "North/South" }, { "code": "All", "name": "All" }, { "code": "East", "name": "East" }, { "code": "West", "name": "West" }, { "code": "North", "name": "North" }, { "code": "South", "name": "South" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "detection_direction", "alias": "Detection Direction" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6012signal_id", "isUnique": false, "description": "", "fields": "signal_id", "isAscending": true }, { "name": "i6012signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3024_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3024", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Table", "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1748461019458}, "relationships": [ { "keyField": "signal_structure_id", "role": "esriRelRoleDestination", "composite": false, "name": "Signal_Structures", "relatedTableId": 1, "id": 3, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 9, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Blank_Out_Signs", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": { "attributes": { "comments": null, "maintained_by": null, "owned_by": null, "signal_id": null, "asset_id": null, "type": null, "manufacturer": null, "features": null, "signal_district": null, "mtce_area": null, "signal_structure_id": null, "intersectionid": null, "model": null, "location": null, "comments2": null, "comments1": null, "status": null } } } ], "supportsAdvancedQueries": true, "currentVersion": 11.4, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Blank_Out_Signs", "displayField": "signal_structure_id", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "SIGNAL_STRUCTURE_ID", "domain": null, "name": "signal_structure_id", "alias": "Signal Structure ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNAL_ID", "domain": null, "name": "signal_id", "alias": "Signal ID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "ASSET_ID", "domain": null, "name": "asset_id", "alias": "Asset ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 35, "type": "esriFieldTypeString", "modelName": "TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "BLANK_OUT_SIGN_TYPE", "description": "BLANK_OUT_SIGN_TYPE", "type": "codedValue", "codedValues": [ { "code": "R10-8 USE LANE WITH GREEN ARROW", "name": "R10-8 USE LANE WITH GREEN ARROW" }, { "code": "R3-1-2 NRT COPY", "name": "R3-1-2 NRT COPY" }, { "code": "R3-1-99 OTHER", "name": "R3-1-99 OTHER" }, { "code": "R3-2-2 NLT COPY", "name": "R3-2-2 NLT COPY" }, { "code": "R3-5-1 LT ONLY", "name": "R3-5-1 LT ONLY" }, { "code": "R3-5-2 RT ONLY", "name": "R3-5-2 RT ONLY" }, { "code": "R3-5-3 ST ONLY", "name": "R3-5-3 ST ONLY" }, { "code": "R3-6-1 LT OPT", "name": "R3-6-1 LT OPT" }, { "code": "R3-6-2 RT OPT", "name": "R3-6-2 RT OPT" }, { "code": "R3-9-1 TWLT/OH", "name": "R3-9-1 TWLT/OH" }, { "code": "R5-1-1 DO NOT ENTER", "name": "R5-1-1 DO NOT ENTER" }, { "code": "R5-1-5 DO NOT ENTER NO ARROW", "name": "R5-1-5 DO NOT ENTER THIS LANE NO ARROW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "type", "alias": "Type" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MANUFACTURER", "domain": null, "name": "manufacturer", "alias": "Manufacturer" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "MODEL", "domain": null, "name": "model", "alias": "Model" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "SPECIAL_FEATURES", "domain": null, "name": "features", "alias": "Special Features" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "Status" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "Location" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "Signal District" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "Owned By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "Maintained By" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "Comments" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "Comments1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "Comments2" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": false, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": false, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "globalid", "domain": null, "name": "globalid", "alias": "GlobalID" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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": "i6010signal_stru", "isUnique": false, "description": "", "fields": "signal_structure_id", "isAscending": true }, { "name": "r3022_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3022", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsLod": false, "supportsSpatialAggregationStatistics": false, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsQueryAttachmentsCountOnly": true, "supportsReturningQueryExtent": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsDistinct": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "copyrightText": "", "zDefault": 0, "supportsLayerOverrides": true } ], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 517113.69662073255, "xmin": 2669717.270781383, "ymax": 581244.5738623887, "xmax": 2765878.5817724317, "spatialReference": { "falseM": -100000, "xyTolerance": 0.003280833333333333, "mUnits": 10000, "zUnits": 10000, "latestWkid": 26852, "zTolerance": 0.001, "wkid": 102704, "xyUnits": 3048.004337495778, "mTolerance": 0.001, "falseX": -119097700, "falseY": -96454900, "falseZ": -100000 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 1000, "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "syncEnabled": false, "supportsAttachmentsByUploadId": true, "editingInfo": {"lastEditDate": 1749497679858}, "relationships": [ { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Signals", "relatedTableId": 4, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Radios", "relatedTableId": 5, "id": 1, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Push_Buttons", "relatedTableId": 6, "id": 2, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Blank_Out_Signs", "relatedTableId": 9, "id": 3, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Pedestrian_Head", "relatedTableId": 7, "id": 4, "cardinality": "esriRelCardinalityOneToMany" }, { "keyField": "facilityid", "role": "esriRelRoleOrigin", "composite": false, "name": "Detection", "relatedTableId": 8, "id": 5, "cardinality": "esriRelCardinalityOneToMany" } ], "supportsAttachmentsResizing": true, "cimVersion": "3.2.0", "isDataArchived": false, "id": 1, "supportsSubtypeEditing": true, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 16000, "isDataVersioned": false, "templates": [ { "name": "Traffic_Signal_Structures", "description": "", "drawingTool": "esriFeatureEditToolPoint", "prototype": { "attributes": { "contractor": null, "facilityid": null, "structure_type": null, "inspection_date": null, "locate_811": null, "pole_class": null, "number_of_signals": null, "signal_district": null, "base_type": null, "signalid": null, "intersectionid": null, "comments3": null, "comments2": null, "comments1": null, "structure_comments": null, "number_of_signs": null, "inspect_method": null, "comments5": null, "comments": null, "comments4": null, "maintained_by": null, "owned_by": null, "build_date": null, "luminaire_mount": null, "mtce_area": null, "location": null, "status": null } } } ], "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "objectid", "supportsQuantizationEditMode": true, "viewSourceHasAttachments": false, "name": "Traffic_Signal_Structures", "allowTrueCurvesUpdates": false, "displayField": "facilityid", "supportsCalculate": true, "fields": [ { "nullable": false, "defaultValue": null, "editable": false, "length": 4, "type": "esriFieldTypeOID", "modelName": "OBJECTID", "domain": null, "name": "objectid", "alias": "OBJECTID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "SIGNALID", "domain": null, "name": "signalid", "alias": "SIGNAL ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 15, "type": "esriFieldTypeString", "modelName": "FACILITYID", "domain": null, "name": "facilityid", "alias": "FACILITY ID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "LOCATION", "domain": null, "name": "location", "alias": "LOCATION" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "Mtce_Area", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_MTCE_AREA", "description": "Traffic Mtce Areas", "range": [ 1, 50 ], "type": "range", "mergePolicy": "esriMPTDefaultValue" }, "name": "mtce_area", "alias": "Mtce_Area" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "SIGNAL_DISTRICT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "SIGNAL_DISTRICT", "description": "SIGNAL MAINTENANCE DISTRICT", "type": "codedValue", "codedValues": [ { "code": "EAST", "name": "EAST" }, { "code": "NORTHWEST", "name": "NORTHWEST" }, { "code": "SOUTHWEST", "name": "SOUTHWEST" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "signal_district", "alias": "SIGNAL DISTRICT" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "IntersectionID", "domain": null, "name": "intersectionid", "alias": "IntersectionID" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 30, "type": "esriFieldTypeString", "modelName": "STATUS", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "lifecycleStatus_42", "description": "Current status of the communication asset.", "type": "codedValue", "codedValues": [ { "code": "Active", "name": "Active" }, { "code": "Inactive", "name": "Inactive" }, { "code": "Removed", "name": "Removed" }, { "code": "ProposedST", "name": "Proposed (short term)" }, { "code": "ProposedLT", "name": "Proposed (long term)" }, { "code": "Cancelled", "name": "Cancelled" }, { "code": "FlashDark", "name": "Flash/Dark" }, { "code": "Temporary", "name": "Temporary" }, { "code": "Unused", "name": "Unused" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "status", "alias": "STATUS" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "INSPECT_METHOD", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "INSPECT_METHOD", "description": "INSPECTION METHOD", "type": "codedValue", "codedValues": [ { "code": "ASBUILT", "name": "ASBUILT" }, { "code": "CONTRACTOR", "name": "CONTRACTOR SURVEY" }, { "code": "GPS", "name": "GPS FIELD LOCATE" }, { "code": "OTHER", "name": "OTHER" }, { "code": "STREETVIEW", "name": "STREETVIEW" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "inspect_method", "alias": "INSPECTION METHOD" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "OWNED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "owned_by", "alias": "OWNED_BY" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "MAINTAINED_BY", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "TR_ASSET_OWN", "description": "Asset Ownership", "type": "codedValue", "codedValues": [ { "code": "CITY OF OMAHA", "name": "City Of Omaha" }, { "code": "DOUGLAS COUNTY", "name": "Douglas County" }, { "code": "RALSTON", "name": "Ralston" }, { "code": "PAPILLION", "name": "Papillion" }, { "code": "LA VISTA", "name": "La Vista" }, { "code": "BELLEVUE", "name": "Bellevue" }, { "code": "SARPY COUNTY", "name": "Sarpy County" }, { "code": "BOYS TOWN", "name": "Boys Town" }, { "code": "VALLEY", "name": "Valley" }, { "code": "WATERLOO", "name": "Waterloo" }, { "code": "CARTER LAKE", "name": "Carter Lake" }, { "code": "LA VISTA_DOUGLAS CO", "name": "La Vista Douglas County" }, { "code": "NDOR", "name": "NDOR" }, { "code": "Private_Other", "name": "Private/Other" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "maintained_by", "alias": "MAINTAINED_BY" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "STRUCTURE_TYPE", "domain": { "name": "Signal_Structures_SIGNAL_STRUCTURE_TYPE", "type": "codedValue", "codedValues": [ { "code": "TRUSS", "name": "TRUSS" }, { "code": "PEDESTAL POLE", "name": "PEDESTAL POLE" }, { "code": "SPAN WIRE", "name": "SPAN WIRE" }, { "code": "WOOD POLE", "name": "WOOD POLE" }, { "code": "OTHER", "name": "OTHER" }, { "code": "MP", "name": "MP" }, { "code": "CMP", "name": "CMP" }, { "code": "SLP", "name": "SLP" }, { "code": "BEACON", "name": "BEACON" }, { "code": "STEEL POLE", "name": "STEEL POLE" } ] }, "name": "structure_type", "alias": "STRUCTURE_TYPE" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 20, "type": "esriFieldTypeString", "modelName": "POLE_CLASS", "domain": { "name": "Signal_Structures_POLE_CLASS", "type": "codedValue", "codedValues": [ { "code": "CLASS 1 20'-30'", "name": "CLASS 1 20'-30'" }, { "code": "CLASS 2 35'-40'", "name": "CLASS 2 35'-40'" }, { "code": "CLASS 3 45'-60'", "name": "CLASS 3 45'-60'" }, { "code": "CLASS 4 61'-75'", "name": "CLASS 4 61'-75'" }, { "code": "SPAN WIRE", "name": "SPAN WIRE" } ] }, "name": "pole_class", "alias": "POLE CLASS" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 100, "type": "esriFieldTypeString", "modelName": "STRUCTURE_COMMENTS", "domain": null, "name": "structure_comments", "alias": "STRUCTURE_COMMENTS" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 10, "type": "esriFieldTypeString", "modelName": "BASE_TYPE", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "BASE_TYPE", "description": "SIGNAL STRUCTURE BASE TYPE", "type": "codedValue", "codedValues": [ { "code": "TYPE 1", "name": "TYPE 1" }, { "code": "TYPE 2", "name": "TYPE 2" }, { "code": "TYPE 3", "name": "TYPE 3" }, { "code": "TYPE 4", "name": "TYPE 4" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "base_type", "alias": "BASE_TYPE" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 25, "type": "esriFieldTypeString", "modelName": "CONTRACTOR", "domain": null, "name": "contractor", "alias": "CONTRACTOR" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 4, "type": "esriFieldTypeString", "modelName": "LUMINAIRE_MOUNT", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes-No_40", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "luminaire_mount", "alias": "Luminaire Mount" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 5, "type": "esriFieldTypeString", "modelName": "LOCATE_811", "domain": { "splitPolicy": "esriSPTDefaultValue", "name": "Yes-No_40", "description": "Yes or No", "type": "codedValue", "codedValues": [ { "code": "Yes", "name": "Yes" }, { "code": "No", "name": "No" } ], "mergePolicy": "esriMPTDefaultValue" }, "name": "locate_811", "alias": "811 LOCATE" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 200, "type": "esriFieldTypeString", "modelName": "COMMENTS", "domain": null, "name": "comments", "alias": "COMMENTS" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS1", "domain": null, "name": "comments1", "alias": "COMMENTS1" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS2", "domain": null, "name": "comments2", "alias": "COMMENTS2" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS3", "domain": null, "name": "comments3", "alias": "COMMENTS3" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS4", "domain": null, "name": "comments4", "alias": "COMMENTS4" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 50, "type": "esriFieldTypeString", "modelName": "COMMENTS5", "domain": null, "name": "comments5", "alias": "COMMENTS5" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "created_user", "domain": null, "name": "created_user", "alias": "created_user" }, { "nullable": true, "editable": true, "defaultValue": null, "length": 255, "type": "esriFieldTypeString", "modelName": "last_edited_user", "domain": null, "name": "last_edited_user", "alias": "last_edited_user" }, { "nullable": false, "editable": false, "defaultValue": null, "length": 38, "type": "esriFieldTypeGlobalID", "modelName": "GlobalID", "domain": null, "name": "globalid", "alias": "GlobalID" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "number_of_signs", "domain": null, "name": "number_of_signs", "alias": "Number Of Signs" }, { "nullable": true, "editable": true, "defaultValue": null, "type": "esriFieldTypeSmallInteger", "modelName": "number_of_signals", "domain": null, "name": "number_of_signals", "alias": "Number Of Signals" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "last_edited_date", "domain": null, "name": "last_edited_date", "alias": "last_edited_date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "created_date", "domain": null, "name": "created_date", "alias": "created_date" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "inspection_date", "domain": null, "name": "inspection_date", "alias": "DATE INSPECTED" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "length": 29, "type": "esriFieldTypeDate", "modelName": "build_date", "domain": null, "name": "build_date", "alias": "BUILD_DATE" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "year_built", "alias": "Year Built", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "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, "viewDefinitionQuery": null, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": false, "indexes": [ { "name": "i6004facilityid", "isUnique": false, "description": "", "fields": "facilityid", "isAscending": true }, { "name": "r3016_sde_rowid_uk", "isUnique": true, "description": "", "fields": "objectid", "isAscending": true }, { "name": "uuid_3016", "isUnique": true, "description": "", "fields": "globalid", "isAscending": true }, { "name": "a2168_ix1", "isUnique": false, "description": "", "fields": "shape", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user" }, "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": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "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 }, "subtypeField": "", "supportsValidateSQL": true, "enableZDefaults": true, "serviceItemId": "89ff2e068e7d4b758d121d5b9c6ec447", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query,Extract", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "sourceSchemaChangesAllowed": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 4000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "outline": { "color": [ 0, 0, 0, 255 ], "width": 0.7 }, "color": [ 86, 119, 175, 255 ], "size": 4, "yoffset": 0, "xoffset": 0, "angle": 0, "style": "esriSMSCircle", "type": "esriSMS" }, "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 } ] }