{ "currentVersion" : 12, "id" : 5, "name" : "Open Sidewalk Curb Workoders", "type" : "Feature Layer", "serviceItemId" : "a828fd8fad384fab9564461ca25ba8f9", "cacheMaxAge" : 30, "displayField" : "LOGGEDBYNAME", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1776935036439, "schemaLastEditDate" : 1776935036439, "dataLastEditDate" : 1776935036439 }, "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" : 0, "maxScale" : 0, "extent" : { "xmin" : -10555112.577859938, "ymin" : 3411311.5706330389, "xmax" : 3314370.4304939061, "ymax" : 13684049.682924137, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 } }, "spatialReference" : { "wkid" : 102740, "latestWkid" : 2278 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"8e28aa148cdad76282e173d81d835192","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB8AAAAfCAYAAAAfrhY5AAAACXBIWXMAAA7EAAAOxAGVKw4bAAADXklEQVRIidVXPW/TUBS9LzWIboSJeEvDL8BhqQoDEkxJl9IkFrv7M0h/RrOXfJQMKGEBiQEhljqdQEwhm73V3VKpUi46tp9rJ35OCAXEkdxnuc8+736eG43+IbT/irzdbuti43YF98wz3V9JjFjMnJe12ujGyY97PWODNgxispjYYObwPyL6KzhHr7tvXME0IL46NE3T+W3yTq9vzZibTFzQ9QLdy+dJ1+/7q8R0ekmO69J4PCmce55F4pbV7p4cmvX95lrkx72ekZuJJjNXHmwVqVQqJgjj2Ny8QyXs2SrSuefR12/fyXHcV51uv9Ko75V/ifw4JCYhKk92tgkWrwocEO84jkufPn8xOt2+rTqAlvZwXeI48N7zZ0/p/YePRrtzMjAb+9Wl5J1e34KrVyIeDolaLSLLIqr4BbDghUflh3Rqn1Xw3UZtr6Ukh7uRXIjxShaDeDAI7lPIAeTBeDxBLhzhDSU5yglZjeRSkh0cBJYeHQUrIFcFHu9s09vBO5q3XkvsYrJkOSnJ4y6vVomaTaXV8WrANz3vAqdsLZCjc6GBKIldl2gUNjBdD0gBrI4TeCID8OapfWaARzagiBwtE50LDSQVMraAYVyTw+XwiPQKDlJYzJd8/m7EQ6H1C9mutByEuGA1COQzGXt4BgdKIVZ9V5M3gUgEvVpJbtvBfbl8/Sy+Sm9kQIpRgnxlxGMva1ySZwD9X205iZEINyE7lZCxh7tBDi/AI0sOML2cRjy0QC5mDmQR6oTGoARKDESwGJcQgSeWkHveRcRD8+QYBKDHkEUl+e5uYHk882UolgBdTpAYxQeORMwxCECPIYsL2SlbqaKPZwHfw0VMiUlHS+ziq0MMAtBjCEvCMrRVdLQlzSQN+B4TuZybqXu7aZoOJhAMAtDjSFxQu4rm4XtDxluWYgzjHxNf23NCNBtzM542vxmjDyYQDALQ48j9iuaRFQKQntpnKO5ho/4iYbWyzjF5YALBIAA9zsx+BWAxiJFkzFcHaXs01cs4ACYQDALIVMhiZv2HiM1wvsUgVk2yWtaHMPpAgzEIQI8RAqgTREKGA00JDQR1HA4NfnL5MU5x9crkvgcC8W/hENBjyKJqL1yMckJWzyfXWuTzh/jrv1gohjB+me78Y+Q3iZ+b9Mrw8kVm+QAAAABJRU5ErkJggg==","contentType":"image/png","width":23,"height":23,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : true, "enableZDefaults" : true, "zDefault" : 0, "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" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ID", "type" : "esriFieldTypeInteger", "alias" : "ID", "sqlType" : "sqlTypeOther", "nullable" : false, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "WORKORDERID", "type" : "esriFieldTypeString", "alias" : "Work Order ID", "sqlType" : "sqlTypeOther", "length" : 100, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOGGEDBYNAME", "type" : "esriFieldTypeString", "alias" : "LoggedByName", "sqlType" : "sqlTypeOther", "length" : 250, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "BEGINDATE", "type" : "esriFieldTypeDate", "alias" : "Begin Date", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "TYPENAME", "type" : "esriFieldTypeString", "alias" : "Type Name", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ACTIVITYDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "ActivityDescription", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LOCATION", "type" : "esriFieldTypeString", "alias" : "Location", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "DESCRIPTION", "type" : "esriFieldTypeString", "alias" : "Description", "sqlType" : "sqlTypeOther", "length" : 1073741822, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "PRIORITY", "type" : "esriFieldTypeInteger", "alias" : "Priority", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "STATUSNAME", "type" : "esriFieldTypeString", "alias" : "StatusName", "sqlType" : "sqlTypeOther", "length" : 50, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTX", "type" : "esriFieldTypeDouble", "alias" : "PointX", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "POINTY", "type" : "esriFieldTypeDouble", "alias" : "PointY", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LATITUDE", "type" : "esriFieldTypeDouble", "alias" : "Latitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "LONGITUDE", "type" : "esriFieldTypeDouble", "alias" : "Longitude", "sqlType" : "sqlTypeOther", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDEQUIPMENTCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "EstimatedEquipmentCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ESTIMATEDINVENTORYCOSTDESCRIPTION", "type" : "esriFieldTypeString", "alias" : "EstimatedInventoryCostDescription", "sqlType" : "sqlTypeOther", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "user_27698.OPEN_SIDEWALK_CURB_WORKORDERS_OPEN_SIDEWALK_CURB_WORKODERS_Shape_sidx", "fields" : "SHAPE", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Spatial" }, { "name" : "PK__OPEN_SID__F4B70D85DD4E0852", "fields" : "OBJECTID", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "Open Sidewalk Curb Workoders", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ESTIMATEDEQUIPMENTCOSTDESCRIPTION" : null, "ESTIMATEDINVENTORYCOSTDESCRIPTION" : null, "STATUS" : null, "ID" : 0, "WORKORDERID" : null, "LOGGEDBYNAME" : null, "BEGINDATE" : null, "TYPENAME" : null, "ACTIVITYDESCRIPTION" : null, "LOCATION" : null, "DESCRIPTION" : null, "PRIORITY" : null, "STATUSNAME" : null, "POINTX" : null, "POINTY" : null, "LATITUDE" : null, "LONGITUDE" : 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" : 2000, "standardMaxRecordCount" : 16000, "maxIdsCount" : 1000000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query,Extract" }