{ "layers" : [ { "currentVersion" : 12, "id" : 0, "name" : "Sign", "type" : "Feature Layer", "serviceItemId" : "0695abed518f4ce99f150a9cee965960", "cacheMaxAge" : 30, "isView" : true, "isUpdatableView" : true, "sourceSchemaChangesAllowed" : true, "displayField" : "sapobjectid", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1783188022001, "schemaLastEditDate" : 1783187975569, "dataLastEditDate" : 1783188022001 }, "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" : 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" : 0, "maxScale" : 0, "extent" : { "xmin" : 517616.70004766615, "ymin" : 6874088.1662180033, "xmax" : 554148.97808298294, "ymax" : 6936687.0872334875, "spatialReference" : { "wkid" : 28356, "latestWkid" : 28356 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"8bd545f1bb0c656b4d43e08036eae793","imageData":"iVBORw0KGgoAAAANSUhEUgAAABIAAAASCAYAAABWzo5XAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAAYUlEQVQ4jWNhoBJgGdwGOegwHDBWYvxGjMYz9/7/P3iFwRurQR6GjMph1gwyxBi0+ADjlYNX/mN3ESVg1KBRg6hu0Lm7/zk52RmJ0njt8X9enAatOsYgsurYfwZywOALIwBMhBfbRK6y7wAAAABJRU5ErkJggg==","contentType":"image/png","width":13,"height":13,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "viewSourceHasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "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" : "SAPOBJECTID", "type" : "esriFieldTypeString", "alias" : "SAP Object ID", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier from the SAP system for each sign asset.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "CLASS", "type" : "esriFieldTypeString", "alias" : "Class", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : "SIGN", "description" : "{\"value\":\"Class category of the feature, typically 'SIGN' for this dataset.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "GIS_USER_STATUS", "type" : "esriFieldTypeString", "alias" : "GIS User Status", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"User-defined status of the GIS feature indicating installation and maintenance conditions.\",\"fieldValueType\":\"orderedOrRanked\"}" }, { "name" : "OBJECT_TYPE", "type" : "esriFieldTypeString", "alias" : "Object Type", "sqlType" : "sqlTypeOther", "length" : 10, "nullable" : false, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : "SIGN", "description" : "{\"value\":\"Type classification of the object, generally 'SIGN' for the features in this layer.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "GIS_SYSTEM_STATUS", "type" : "esriFieldTypeString", "alias" : "GIS System Status", "sqlType" : "sqlTypeOther", "length" : 60, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"System-generated status indicating the GIS lifecycle stage of the feature, such as installed or deleted.\",\"fieldValueType\":\"orderedOrRanked\"}" }, { "name" : "SIGN_TYPE", "type" : "esriFieldTypeString", "alias" : "Sign Type", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "SIGN_TYPE", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "TBA", "code" : "TBA" }, { "name" : "Warning", "code" : "WARNING" }, { "name" : "Naming", "code" : "NAMING" }, { "name" : "Direction", "code" : "DIRECTION" }, { "name" : "Regulatory", "code" : "REGULATORY" }, { "name" : "Traffic Management", "code" : "TRAFFIC MANAGEMENT" }, { "name" : "Information", "code" : "INFORMATION" }, { "name" : "Traffic Control", "code" : "TRAFFIC CONTROL" }, { "name" : "Flooded Road Wig Wag", "code" : "FLOODED ROAD WIG WAG" }, { "name" : "Electronic School Zone", "code" : "ELECTRONIC SCHOOL ZONE" }, { "name" : "Variable Message (VMS)", "code" : "VARIABLE MESSAGE" }, { "name" : "Road Condition (RCS)", "code" : "ROAD CONDITION" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Type or category of the sign, such as regulatory, warning, directional, or information.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "SIGN_MATERIAL", "type" : "esriFieldTypeString", "alias" : "Sign Material", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "SIGN_MATERIAL", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Aluminium", "code" : "ALUMINIUM" }, { "name" : "Brass", "code" : "BRASS" }, { "name" : "Glass", "code" : "GLASS" }, { "name" : "Masonry", "code" : "MASONRY" }, { "name" : "Other", "code" : "OTHER" }, { "name" : "Plastic", "code" : "PLASTIC" }, { "name" : "Stainless Steel", "code" : "STAINLESS STEEL" }, { "name" : "Steel", "code" : "STEEL" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Timber", "code" : "TIMBER" }, { "name" : "Timber/Steel", "code" : "TIMBER/STEEL" }, { "name" : "Recycled Plastic", "code" : "RECYCLED PLASTIC" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Material composition of the sign, for example aluminium, steel, plastic, or timber.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "SIGN_TEXT", "type" : "esriFieldTypeString", "alias" : "Sign Text", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Text content displayed on the sign, if applicable.\",\"fieldValueType\":\"description\"}" }, { "name" : "FINISH", "type" : "esriFieldTypeString", "alias" : "Finish", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Surface finish of the sign, such as printed, painted, or powder-coated.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ILLUMINATED", "type" : "esriFieldTypeString", "alias" : "Illuminated", "sqlType" : "sqlTypeOther", "length" : 3, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "ILLUMINATED", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : "N" }, { "name" : "TBA", "code" : "TBA" }, { "name" : "Yes", "code" : "Y" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Indicates whether the sign is illuminated (Yes or No).\",\"fieldValueType\":\"binary\"}" }, { "name" : "ROTATION", "type" : "esriFieldTypeString", "alias" : "Rotation", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Rotation angle or orientation of the sign in degrees, if specified.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "FUNCTIONAL_LOC", "type" : "esriFieldTypeString", "alias" : "Functional Location", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Functional location code representing the asset’s assigned location or area within the city.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "SUPERORD_EQUIP", "type" : "esriFieldTypeString", "alias" : "Superordinate Equipment", "sqlType" : "sqlTypeOther", "length" : 18, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Identifier of the superior or parent equipment asset associated with this sign.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "ITS", "type" : "esriFieldTypeString", "alias" : "Intelligent Transport System (ITS)", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "ITS", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "No", "code" : "NO" }, { "name" : "Yes", "code" : "YES" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Indicates if the sign is part of the Intelligent Transport System (Yes or No).\",\"fieldValueType\":\"binary\"}" }, { "name" : "SIGN_POWER_SUPPLY", "type" : "esriFieldTypeString", "alias" : "Sign Power Supply", "sqlType" : "sqlTypeOther", "length" : 30, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : { "type" : "codedValue", "name" : "SIGN_POWER_SUPPLY", "mergePolicy" : "esriMPTDefaultValue", "splitPolicy" : "esriSPTDefaultValue", "codedValues" : [ { "name" : "Main", "code" : "MAIN" }, { "name" : "Solar", "code" : "SOLAR" }, { "name" : "Unpowered", "code" : "UNPOWERED" } ] }, "defaultValue" : null, "description" : "{\"value\":\"Type of power supply for the sign, e.g., main power, solar, or unpowered.\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "GIS_DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "GIS Description", "sqlType" : "sqlTypeOther", "length" : 40, "nullable" : true, "editable" : true, "isViewOverride" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"General description of the GIS feature, often including sign type and text.\",\"fieldValueType\":\"description\"}" } ], "indexes" : [ { "name" : "PK__SIGN_SIG__F4B70D8549DB2EA5", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_935.SIGN_SIGN_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "I16SAPOBJECTID", "fields" : "SAPOBJECTID", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "SIGN_TYPE_Index", "fields" : "SIGN_TYPE", "isAscending" : true, "isUnique" : false, "description" : "SIGN_TYPE_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Sign", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "SAPOBJECTID" : null, "GIS_USER_STATUS" : null, "SYNCDATE" : null, "LAST_EDITED_DATE" : null, "CLASS" : "SIGN", "OBJECT_TYPE" : "SIGN", "GIS_SYSTEM_STATUS" : null, "SIGN_TYPE" : null, "SIGN_MATERIAL" : null, "SIGN_TEXT" : null, "FINISH" : null, "ILLUMINATED" : null, "ROTATION" : null, "ASSET_LEVEL_ACCURACY" : null, "ASSET_POSITIONAL_ACCURACY" : null, "FUNCTIONAL_LOC" : null, "SUPERORD_EQUIP" : null, "ITS" : null, "SIGN_POWER_SUPPLY" : null, "DATA_SOURCE" : null, "GIS_MANUFACTURER" : null, "GIS_MANUSERIALNO" : null, "GIS_MODEL_NUMBER" : null, "GIS_PROJECT_DEVELOPER_APPL_ID" : null, "GIS_DRAWING_NUMBER" : null, "PHOTO_LINK" : null, "PHOTO_LEGACY" : null, "GIS_ACQUISITION_METHOD" : null, "GIS_STARTUP_DATE" : null, "GIS_ASSET_FUNDING_BASIS" : null, "GIS_CUSTODIAN" : null, "GIS_DESCRIPTION" : null, "SORT_FIELD" : null, "RE_ENRICH" : null, "GIS_OWNER" : null, "SYNCSTATUS" : null, "SYNCERRORDESC" : null, "GIS_EQUIPMENT_CATEGORY" : "I", "CREATED_USER" : null, "CREATED_DATE" : null, "LAST_EDITED_USER" : null, "GIS_ACQUISITION_PROJECT" : 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" : true, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" } ], "tables" : [] }