{ "currentVersion" : 12, "id" : 1, "name" : "Intersection Control Evaluations", "type" : "Feature Layer", "serviceItemId" : "855bdfac82ab4e08941343553154dc74", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "District", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editFieldsInfo" : { "creationDateField" : "CreationDate", "creatorField" : "Creator", "editDateField" : "EditDate", "editorField" : "Editor" }, "editingInfo" : { "lastEditDate" : 1775062530592, "schemaLastEditDate" : 1750254618281, "dataLastEditDate" : 1775062530592 }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : false, "supportsAttachmentsByUploadId" : true, "supportsAttachmentsResizing" : true, "supportsRollbackOnFailureParameter" : true, "supportsStatistics" : true, "supportsExceedsLimitStatistics" : true, "supportsAdvancedQueries" : true, "supportsValidateSql" : true, "supportsCoordinatesQuantization" : true, "supportsLayerOverrides" : true, "supportsTilesAndBasicQueriesMode" : true, "supportsFieldDescriptionProperty" : true, "supportsQuantizationEditMode" : true, "supportsColumnStoreIndex" : true, "supportsApplyEditsWithGlobalIds" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "advancedQueryCapabilities" : { "supportsPagination" : true, "supportsPaginationOnAggregatedQueries" : true, "supportsQueryRelatedPagination" : true, "supportsQueryWithDistance" : true, "supportsOutDistance" : true, "supportsReturningQueryExtent" : true, "supportsStatistics" : true, "supportsOrderBy" : true, "supportsDistinct" : true, "supportsQueryWithResultType" : true, "supportsSqlExpression" : true, "supportsTimeRelation" : true, "supportsAdvancedQueryRelated" : true, "supportsCountDistinct" : true, "supportsPercentileStatistics" : true, "supportsApproxPercentileStatistics" : true, "supportsSpatialAggregationStatistics" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsQueryAttachments" : true, "supportsQueryAttachmentsCountOnly" : true, "supportsQueryAttachmentOrderByFields" : true, "supportsQueryAttachmentWithTypeWildcard" : true, "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : false, "supportsQueryWithDatumTransformation" : true, "supportsCurrentUserQueries" : true, "supportsHavingClause" : true, "supportsOutFieldSQLExpression" : true, "supportsMaxRecordCountFactor" : true, "supportsTopFeaturesQuery" : true, "supportsDisjointSpatialRel" : true, "supportsQueryWithCacheHint" : true, "supportedOperationsWithCacheHint" : [ "query", "queryTopFilter", "queryAnalytics", "queryAttachments", "queryRelated", "queryBins", "queryPivot" ], "supportsQueryAttachmentsWithReturnUrl" : true, "supportsQueryAnalytic" : true, "supportsQueryPivot" : true, "supportsQueryBins" : true, "supportsDefaultSR" : true, "supportsTranslations" : false, "supportsAggIds" : true, "supportsQueryWithCollation" : true, "supportsISODOW" : true, "supportsISOWeek" : true, "supportsFullTextSearch" : true, "fullTextSearchCapabilities" : { "supportsAccentSensitivity" : true, "supportsStopWords" : true, "supportsSearchOperator" : true, "supportsOperator" : true } }, "advancedQueryAnalyticCapabilities" : { "supportsLinearRegression" : true, "supportsTrendlineRegression" : true, "supportsAsync" : true, "supportsPercentileAnalytic" : true }, "queryBinsCapabilities" : { "supportsAsync" : true, "supportsAutoIntervalBin" : true, "supportsFixedIntervalBin" : true, "supportsFixedBoundariesBin" : true, "supportsDateBin" : true, "supportsClassificationBin" : true, "supportsStackBy" : true, "supportsSplitBy" : true, "supportsFirstDayOfWeek" : true, "supportsSnapToData" : true, "supportsReturnFullIntervalBin" : true, "supportsReturnStackValueRange" : true, "supportsNormalization" : true, "supportedStatisticTypes" : [ "COUNT", "SUM", "AVG", "VAR", "STDDEV", "MIN", "MAX", "PERCENTILE_CONT", "PERCENTILE_DISC", "APPROX_PERCENTILE_CONT", "APPROX_PERCENTILE_DISC", "CentroidAggregate", "EnvelopeAggregate", "ConvexHullAggregate" ], "supportedNormalizationTypes" : [ "boxCox", "field", "inverse", "log", "naturalLog", "percentOfTotal", "squareRoot" ] }, "supportedOperationsWithCollation" : "query,addField,updateField", "advancedEditingCapabilities" : { "supportedSqlFormatsInCalculate" : [ "standard" ], "supportsAsyncApplyEdits" : true, "supportsReturnEditResults" : true, "supportsApplyEditsbyUploadID" : true, "supportedApplyEditsUploadIDFormats" : "JSON,PBF", "supportsTranslation" : false, "supportsMaxTranslations" : 10 }, "infoInEstimates" : [ "extent", "count" ], "useStandardizedQueries" : true, "geometryType" : "esriGeometryPoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : -124967.8355876276, "ymin" : 2715390.6956921848, "xmax" : 596943.08632313, "ymax" : 3446535.4827307076, "spatialReference" : { "wkid" : 26917, "latestWkid" : 26917 } }, "spatialReference" : { "wkid" : 26917, "latestWkid" : 26917 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[153,95,70,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : true, "viewSourceHasAttachments" : true, "attachmentProperties" : [ { "name" : "id", "fieldName" : "ATTACHMENTID", "isEnabled" : true }, { "name" : "globalId", "fieldName" : "AttachmentGlobalID", "isEnabled" : true }, { "name" : "name", "fieldName" : "ATT_NAME", "isEnabled" : true }, { "name" : "size", "fieldName" : "DATA_SIZE", "isEnabled" : true }, { "name" : "contentType", "fieldName" : "CONTENT_TYPE", "isEnabled" : true }, { "name" : "keywords", "fieldName" : "Keywords", "isEnabled" : true }, { "name" : "exifInfo", "fieldName" : "ExifInfo", "isEnabled" : true } ], "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "GlobalID", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "Object ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique object ID corresponding to each row (system default)\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "District", "type" : "esriFieldTypeInteger", "alias" : "District", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "District", "codedValues" : [ { "name" : "1", "code" : 1 }, { "name" : "2", "code" : 2 }, { "name" : "3", "code" : 3 }, { "name" : "4", "code" : 4 }, { "name" : "5", "code" : 5 }, { "name" : "6", "code" : 6 }, { "name" : "7", "code" : 7 } ] }, "defaultValue" : null, "description" : "{\"value\":\"District in which the intersection is located\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "GlobalID", "type" : "esriFieldTypeGlobalID", "alias" : "Global ID", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : false, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : "NEWID() WITH VALUES", "description" : "{\"value\":\"Unique universal identifier (system default)\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "CreationDate", "type" : "esriFieldTypeDate", "alias" : "Creation Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Date when the intersection was first added to the table (system default)\",\"fieldValueType\":\"dateAndTime\"}", "precision" : 1 }, { "name" : "Creator", "type" : "esriFieldTypeString", "alias" : "Creator", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Name of the person/organization who first added the intersection to the table (system default)\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "EditDate", "type" : "esriFieldTypeDate", "alias" : "Edit Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Latest date when the data for an intersection was edited (system default)\",\"fieldValueType\":\"dateAndTime\"}", "precision" : 1 }, { "name" : "Editor", "type" : "esriFieldTypeString", "alias" : "Editor", "sqlType" : "sqlTypeOther", "length" : 128, "nullable" : true, "editable" : false, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Name of the last person/organization who edited the row-data for an intersection (system default)\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "LocationDescription", "type" : "esriFieldTypeString", "alias" : "Location Description", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Major and Minor Roadway Names at the intersection\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "Roadway1", "type" : "esriFieldTypeString", "alias" : "Major Roadway ID", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Roadway ID of the major road on which the Intersection is located\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "Milepoint1", "type" : "esriFieldTypeDouble", "alias" : "Major Roadway Milepoint", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Major road milepoint at the center of the intersection\",\"fieldValueType\":\"measurement\"}" }, { "name" : "Roadway2", "type" : "esriFieldTypeString", "alias" : "Minor Roadway ID", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Roadway ID of the minor road on which the Intersection is located. In case roadway ID is different for two minor roads, select the one that has higher precedence based on road status (whether it is an on-system road), functional classification, and road type or presence of median (divided, undivided).\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "Milepoint2", "type" : "esriFieldTypeDouble", "alias" : "Minor Roadway Milepoint", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Minor road milepoint (corresponding to minor roadway ID) at the center of the intersection\",\"fieldValueType\":\"measurement\"}" }, { "name" : "SelectedControlStrategy", "type" : "esriFieldTypeString", "alias" : "Selected Control Strategy", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "Intersection Control Evaluations_SelectedControlStrategy_c3023bb5-dd18-48ec-8948-f10ede3bf134", "codedValues" : [ { "name" : "Signal", "code" : "Signal" }, { "name" : "RCUT (Signalized)", "code" : "RCUT (Signalized)" }, { "name" : "RCUT (Unsignalized)", "code" : "RCUT (Unsignalized)" }, { "name" : "Median U-Turn", "code" : "Median U-Turn" }, { "name" : "Displaced Left-Turn", "code" : "Displaced Left-Turn" }, { "name" : "Displaced Left-Turn (Full)", "code" : "Displaced Left-Turn (Full)" }, { "name" : "Displaced Left-Turn (Partial)", "code" : "Displaced Left-Turn (Partial)" }, { "name" : "Roundabout", "code" : "Roundabout" }, { "name" : "1-lane Roundabout", "code" : "1-lane Roundabout" }, { "name" : "2-lane Roundabout", "code" : "2-lane Roundabout" }, { "name" : "Continuous Green Tee", "code" : "Continuous Green Tee" }, { "name" : "Bowtie", "code" : "Bowtie" }, { "name" : "Thru-Cut (Signalized)", "code" : "Thru-Cut (Signalized)" }, { "name" : "Thru-Cut (Unsignalized)", "code" : "Thru-Cut (Unsignalized)" }, { "name" : "Quadrant Roadway", "code" : "Quadrant Roadway" }, { "name" : "Jughandle", "code" : "Jughandle" }, { "name" : "Signalized Diamond", "code" : "Signalized Diamond" }, { "name" : "Unsignalized Diamond", "code" : "Unsignalized Diamond" }, { "name" : "Signalized Tight Diamond", "code" : "Signalized Tight Diamond" }, { "name" : "Single-Point Diamond", "code" : "Single-Point Diamond" }, { "name" : "Diverging Diamond", "code" : "Diverging Diamond" }, { "name" : "Half-Diamond (Signalized)", "code" : "Half-Diamond (Signalized)" }, { "name" : "Four-Quadrant Partial Cloverleaf A (Signalized)", "code" : "Four-Quadrant Partial Cloverleaf A (Signalized)" }, { "name" : "Two-Quadrant Partial Cloverleaf A (Signalized)", "code" : "Two-Quadrant Partial Cloverleaf A (Signalized)" }, { "name" : "Four-Quadrant Partial Cloverleaf B (Signalized)", "code" : "Four-Quadrant Partial Cloverleaf B (Signalized)" }, { "name" : "Two-Quadrant Partial Cloverleaf B (Signalized)", "code" : "Two-Quadrant Partial Cloverleaf B (Signalized)" }, { "name" : "N/A", "code" : "N/A" }, { "name" : "Unknown", "code" : "Unknown" } ] }, "defaultValue" : null, "description" : "{\"value\":\"The single intersection control strategy selected at the end of ICE analysis.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "Approved", "type" : "esriFieldTypeString", "alias" : "Year ICE Form Approved", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Year the ICE analysis was complete or the ICE Form with a selected single control strategy was approved, whichever is latest.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "Status", "type" : "esriFieldTypeString", "alias" : "Status", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "Intersection Control Evaluations_Status_b5a90183-794c-43b8-885f-21dd4dd36df9", "codedValues" : [ { "name" : "ICE Analysis Completed", "code" : "ICE Analysis Completed" }, { "name" : "Scoping", "code" : "Scoping" }, { "name" : "In Design", "code" : "In Design" }, { "name" : "Under Construction", "code" : "Under Construction" }, { "name" : "In Service", "code" : "In Service" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Project status\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ItemSegment", "type" : "esriFieldTypeString", "alias" : "Item Segment", "sqlType" : "sqlTypeOther", "length" : 1000, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Work program item segment ID\",\"fieldValueType\":\"description\"}" }, { "name" : "EstimatedCost", "type" : "esriFieldTypeDouble", "alias" : "Estimated Cost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Estimated cost of construction\",\"fieldValueType\":\"currency\"}" }, { "name" : "FinalCost", "type" : "esriFieldTypeDouble", "alias" : "Final Cost", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Final cost of construction\",\"fieldValueType\":\"currency\"}" }, { "name" : "ConstructionStartDate", "type" : "esriFieldTypeDate", "alias" : "Construction Start Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Start date of the construction\",\"fieldValueType\":\"dateAndTime\"}", "precision" : 1 }, { "name" : "ConstructionCompletionDate", "type" : "esriFieldTypeDate", "alias" : "Construction Completion Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"End date of the construction or date the selected intersection control strategy is open to traffic, whichever is latest.\",\"fieldValueType\":\"dateAndTime\"}", "precision" : 1 }, { "name" : "Comments", "type" : "esriFieldTypeString", "alias" : "Comments", "sqlType" : "sqlTypeOther", "length" : 5000, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Add any comments on selected control strategy or project status\",\"fieldValueType\":\"\"}" }, { "name" : "Latitude", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Latitude of the center of the intersection\",\"fieldValueType\":\"coordinate\"}" }, { "name" : "Longitude", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Longitude of the center of the intersection\",\"fieldValueType\":\"coordinate\"}" } ], "indexes" : [ { "name" : "PK__INTERSEC__F4B70D858F288391", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_12203.INTERSECTION_CONTROL_EVALUATION_INTERSECTION_CONTROL_EVALUATIONS_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "GlobalID_Index", "fields" : "GlobalID", "isAscending" : false, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "CreationDateIndex", "fields" : "CreationDate", "isAscending" : true, "isUnique" : false, "description" : "CreationDate Field index", "indexType" : "Attribute" }, { "name" : "CreatorIndex", "fields" : "Creator", "isAscending" : false, "isUnique" : false, "description" : "Creator Field index", "indexType" : "Attribute" }, { "name" : "EditDateIndex", "fields" : "EditDate", "isAscending" : true, "isUnique" : false, "description" : "EditDate Field index", "indexType" : "Attribute" }, { "name" : "EditorIndex", "fields" : "Editor", "isAscending" : false, "isUnique" : false, "description" : "Editor Field index", "indexType" : "Attribute" }, { "name" : "District_Index", "fields" : "District", "isAscending" : true, "isUnique" : false, "description" : "District_Index", "indexType" : "Attribute" }, { "name" : "SelectedControlStrategy_Index", "fields" : "SelectedControlStrategy", "isAscending" : true, "isUnique" : false, "description" : "SelectedControlStrategy_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Intersection Control Evaluations", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ItemSeg" : " ", "FiscalYr" : " ", "District" : 0, "RDWYID" : 0, "MP" : 0, "MajRDWYID" : 0, "MinRDWYID" : 0, "MajMP" : 0, "MinMP" : 0, "MajBMP" : 0, "MinBMP" : 0, "MajEMP" : 0, "MinEMP" : 0, "DateToTra" : " ", "Status" : " ", "Latitude" : 0, "Longitude" : 0, "LocDescp" : " ", "SegStats" : " ", "Type" : " ", "Approval" : " ", "LaneConfg" : " ", "Comments" : null, "TreatSele" : " ", "ICEYr" : 0 } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf,imageCollection", "supportedAppendSourceFilterFormats" : "sqlite,geoPackage,shapefile,filegdb,featureService", "supportedExportFormats" : "csv,shapefile,sqlite,geoPackage,filegdb,featureCollection,geojson,kml,excel,parquet", "supportedConvertFileFormats" : "JSON,PBF,Parquet", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportsEditingContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }