{ "currentVersion" : 12, "id" : 18, "name" : "Traffic Signals", "type" : "Feature Layer", "serviceItemId" : "fcc59daef8df4158bb17795423534a2b", "cacheMaxAge" : 30, "displayField" : "STATUS", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : null }, "relationships" : [], "isDataVersioned" : false, "hasContingentValuesDefinition" : false, "supportsAppend" : true, "supportsCalculate" : true, "supportsASyncCalculate" : true, "supportsTruncate" : true, "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" : false, "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" ], "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" ], "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" : 2400, "maxScale" : 0, "extent" : { "xmin" : -13615914.942979973, "ymin" : 4538586.56710938, "xmax" : -13597545.867587125, "ymax" : 4559581.7212893739, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"bdadd3d0863141b9e9f76d55b8ed5566","imageData":"iVBORw0KGgoAAAANSUhEUgAAABoAAAAYCAYAAADkgu3FAAAAAXNSR0IB2cksfwAAAAlwSFlzAAAOxAAADsQBlSsOGwAAA7BJREFUSIm9ll1oXFUQgL9tVmZ/rDaX5KG02ZAVsrHGlhAwMQp1xSqipr5opCjU6otiawVbIdGk0hZNE1SQJQgRfx4MUptCQ6WECNqHJn3pBoTYmBo2W9uEJjl5sLntsGHXh9277m6u0Yo6cOCemTPzzTl3ztzr5X8S7606iEiLqi4Ck/8pSFWPicj3qvr2vwYSkUdUdYOILASDwZsAxpj1qrrJsqzm3LwcCAI/ssYu1wKJqn4I1Pf39zM2NkYsFnNsW40xu/v6+lhaWqK9vR0ROayqnX8X5AOqRCSkqs8B9QDhcJh4PE5TJMLetjauLi5yMBYjGo0yODgIgKq+A0xYlpUwxiSBOSDtBpoGanJORXSPx0NdJMKLwSCpE6fYAgx3dzM7O4tt24VLB4wxznNKRHpVtb0IJCJfqmqX27ZTqRR3ZjKkBofyuo0Li1wpSahENBgMHneSzoNU9ZBlWWeWl5efUdV9hTav18tkMkkkXE16egaAFascy7LcAEngGHDSGHM1H6NwhTFmDBgDEsBRYD1AWVkZt1dUMFpXS3NLMymvlw9GRti3fXspJAHsAC6VGv6s6j4G/EA3QDqdRkR4paeHeyLVzCbmMKrs7VxVZE3ANbeAhe+oV1VrgBBQDVQ6NlVlZmaG+ND7WPoZHtnJ8E+bKS8vL433a24kc2MIOF4EUtVG4CG3bPx+P9GWBix7NwAZO8GOba9zYXLV/byNbOXW5OY/rNoR8KyIdKjqU0C40Nu2bX6+OMGWcBAyyzntOioqKtzyygBngQHgUzfQvKruB94ETgCtjiEQCHDFKAt3v0XlyiAeXx2nL9zggSc3uIGeB74qVboVwwqwC/gIeNlR1tbW0rjTmZ4HYLjxiSJHEXlcVc+40fMgy7LuM8aE+KMFbXVstm0zPj7OwSOd+DdX4lvn5ezJbwmFQkXBVHWXiDyoqkngMjABzBSBjDHfAFU5h6IAgUCApvub6UuMcu5S9sK++/RjTE1NlSb+QqGviLzn1oL2qOrnwKZSb9u2mTMLnLtxPa+bv3kdn8/ndkqOfKeqvc6ksLxHyB5bs6oOkL1L+R1dnpqmo6GBo7/EEY+HjWmhqqrKDfA1sJ9s985LaTFkVHXUsqw2Y8wnwDbIdob6+nq6DnVxYM9LzF+bp+PwG9x76i4ymUyh/xfAq4BdEte9BRljzpOtvIcBotHoRVU9ADza03Ukv661tfU14DfgjpwqRvYerZK1vrATueEUx8gaa/9Sbvnn5J/K70iGfDC1eqhYAAAAAElFTkSuQmCC","contentType":"image/png","width":19,"height":18,"angle":0,"xoffset":0,"yoffset":0},"label":"","description":""},"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeNone", "hasM" : false, "hasZ" : false, "objectIdField" : "OBJECTID", "uniqueIdField" : { "name" : "OBJECTID", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "OBJECTID", "type" : "esriFieldTypeOID", "alias" : "OBJECTID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "STATUS", "type" : "esriFieldTypeString", "alias" : "STATUS", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCORE", "type" : "esriFieldTypeSmallInteger", "alias" : "SCORE", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SIDE", "type" : "esriFieldTypeString", "alias" : "SIDE", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "X", "type" : "esriFieldTypeDouble", "alias" : "X", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Y", "type" : "esriFieldTypeDouble", "alias" : "Y", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "INTERSECTI", "type" : "esriFieldTypeDouble", "alias" : "INTERSECTI", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MAJOR_STRE", "type" : "esriFieldTypeString", "alias" : "MAJOR_STRE", "sqlType" : "sqlTypeOther", "length" : 24, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MINOR_STRE", "type" : "esriFieldTypeString", "alias" : "MINOR_STRE", "sqlType" : "sqlTypeOther", "length" : 38, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONCATENAT", "type" : "esriFieldTypeString", "alias" : "CONCATENAT", "sqlType" : "sqlTypeOther", "length" : 63, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "O_M_STATUS", "type" : "esriFieldTypeString", "alias" : "O_M_STATUS", "sqlType" : "sqlTypeOther", "length" : 11, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "NBLT", "type" : "esriFieldTypeSmallInteger", "alias" : "NBLT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SBLT", "type" : "esriFieldTypeSmallInteger", "alias" : "SBLT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "EBLT", "type" : "esriFieldTypeSmallInteger", "alias" : "EBLT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WBLT", "type" : "esriFieldTypeSmallInteger", "alias" : "WBLT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "FACILITYID", "type" : "esriFieldTypeString", "alias" : "FACILITYID", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LEGACYID", "type" : "esriFieldTypeString", "alias" : "LEGACYID", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "LOCATION", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WARRANTYDATE", "type" : "esriFieldTypeDate", "alias" : "WARRANTYDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "INSTALLDATE", "type" : "esriFieldTypeDate", "alias" : "INSTALLDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CONDITION", "type" : "esriFieldTypeString", "alias" : "CONDITION", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "CONDITIONDATE", "type" : "esriFieldTypeDate", "alias" : "CONDITIONDATE", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "CONTROLLER", "type" : "esriFieldTypeSmallInteger", "alias" : "CONTROLLER", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Controllers", "codedValues" : [ { "name" : "170E", "code" : 1 }, { "name" : "LS180", "code" : 2 }, { "name" : "LMD 8000", "code" : 3 }, { "name" : "LC 8000", "code" : 4 }, { "name" : "GAMMATRONIX", "code" : 5 }, { "name" : "CALTRANS", "code" : 6 }, { "name" : "TCT CONTROLLER", "code" : 7 }, { "name" : "2070 L", "code" : 8 } ] }, "defaultValue" : null }, { "name" : "DETECTION", "type" : "esriFieldTypeSmallInteger", "alias" : "DETECTION", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Detection", "codedValues" : [ { "name" : "None", "code" : 1 }, { "name" : "Semi-Loop", "code" : 2 }, { "name" : "Semi-Video", "code" : 3 }, { "name" : "Full-Loop", "code" : 4 }, { "name" : "Full-Video", "code" : 5 }, { "name" : "Combo-Video+Loop", "code" : 7 }, { "name" : "Detection Failure", "code" : 8 }, { "name" : "Semi-Video (+Bike)", "code" : 9 }, { "name" : "Full-Video (+Bike)", "code" : 10 } ] }, "defaultValue" : null }, { "name" : "PEDACTUATION", "type" : "esriFieldTypeSmallInteger", "alias" : "PEDACTUATION", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Ped Actuation", "codedValues" : [ { "name" : "None", "code" : 1 }, { "name" : "Semi", "code" : 2 }, { "name" : "Full", "code" : 3 }, { "name" : "Detection Failure", "code" : 4 } ] }, "defaultValue" : null }, { "name" : "INTERCONNECT", "type" : "esriFieldTypeSmallInteger", "alias" : "INTERCONNECT", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Interconnect", "codedValues" : [ { "name" : "None", "code" : 1 }, { "name" : "Fiber", "code" : 2 }, { "name" : "Copper", "code" : 3 }, { "name" : "Copper but fiber ready", "code" : 4 }, { "name" : "Empty Conduit", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "PEDHEADS", "type" : "esriFieldTypeSmallInteger", "alias" : "PEDHEADS", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Ped Heads", "codedValues" : [ { "name" : "Missing", "code" : 1 }, { "name" : "Non-Countdown", "code" : 2 }, { "name" : "Countdown", "code" : 3 }, { "name" : "Combo", "code" : 4 }, { "name" : "Not Needed", "code" : 5 } ] }, "defaultValue" : null }, { "name" : "AUDIBLES", "type" : "esriFieldTypeSmallInteger", "alias" : "AUDIBLES", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Audibles", "codedValues" : [ { "name" : "None", "code" : 1 }, { "name" : "Audible Only", "code" : 2 }, { "name" : "Polara", "code" : 3 }, { "name" : "Semi Polara", "code" : 4 }, { "name" : "Audible Failure", "code" : 5 }, { "name" : "Semi Audible Only", "code" : 6 } ] }, "defaultValue" : null }, { "name" : "VIDEOFEED", "type" : "esriFieldTypeString", "alias" : "VIDEOFEED", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Video Feed", "codedValues" : [ { "name" : "True", "code" : "T" }, { "name" : "False", "code" : "F" } ] }, "defaultValue" : null }, { "name" : "REMOTEACCESS", "type" : "esriFieldTypeString", "alias" : "REMOTEACCESS", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "Remote Access", "codedValues" : [ { "name" : "True", "code" : "T" }, { "name" : "False", "code" : "F" } ] }, "defaultValue" : null }, { "name" : "GPS_CLOCKS", "type" : "esriFieldTypeString", "alias" : "GPS_CLOCKS", "sqlType" : "sqlTypeOther", "length" : 1, "nullable" : true, "editable" : true, "domain" : { "type" : "codedValue", "name" : "TrafficSignalGPS Clock", "codedValues" : [ { "name" : "True", "code" : "T" }, { "name" : "False", "code" : "F" } ] }, "defaultValue" : null }, { "name" : "MAINTENANCEGROUPNO", "type" : "esriFieldTypeString", "alias" : "MAINTENANCEGROUPNO", "sqlType" : "sqlTypeOther", "length" : 6, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PGE_METERNO", "type" : "esriFieldTypeString", "alias" : "PGE_METERNO", "sqlType" : "sqlTypeOther", "length" : 15, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "RECONCILENOTES", "type" : "esriFieldTypeString", "alias" : "RECONCILENOTES", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__CALLCENT__F4B70D85CD6414B8", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_4148.CALLCENTERSHORTMAP4_TRAFFIC_SIGNALS_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Traffic Signals", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "PGE_METERNO" : null, "RECONCILENOTES" : null, "STATUS" : null, "SCORE" : null, "SIDE" : null, "X" : null, "Y" : null, "INTERSECTI" : null, "MAJOR_STRE" : null, "MINOR_STRE" : null, "CONCATENAT" : null, "O_M_STATUS" : null, "NBLT" : null, "SBLT" : null, "EBLT" : null, "WBLT" : null, "FACILITYID" : null, "LEGACYID" : null, "LOCATION" : null, "WARRANTYDATE" : null, "INSTALLDATE" : null, "CONDITION" : null, "CONDITIONDATE" : null, "CONTROLLER" : null, "DETECTION" : null, "PEDACTUATION" : null, "INTERCONNECT" : null, "PEDHEADS" : null, "AUDIBLES" : null, "VIDEOFEED" : null, "REMOTEACCESS" : null, "GPS_CLOCKS" : null, "MAINTENANCEGROUPNO" : null } } } ], "supportedQueryFormats" : "JSON, geoJSON, PBF", "supportedAppendFormats" : "sqlite,geoPackage,shapefile,filegdb,featureCollection,geojson,csv,excel,jsonl,featureService,pbf", "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" : false, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }