{ "currentVersion" : 12, "id" : 0, "name" : "SCR_Data_for_Mapping", "type" : "Feature Layer", "serviceItemId" : "0d81d4f689f84ffcaea7f9d88a285cb3", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1674676869672, "schemaLastEditDate" : 1674676869672, "dataLastEditDate" : 1674676869672 }, "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" : -9389713.2003, "ymin" : 3976791.948299997, "xmax" : -9357980.809, "ymax" : 4024288.6439, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"uniqueValue","field1":"SCRStatus","uniqueValueInfos":[{"value":"Approved","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"6cbbbe56-54d6-4100-ba47-5fbff6131755","imageData":"iVBORw0KGgoAAAANSUhEUgAAAB4AAAAeCAYAAAA7MK6iAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAEnQAABJ0Ad5mH3gAAAAadEVYdFNvZnR3YXJlAFBhaW50Lk5FVCB2My41LjExR/NCNwAAALpJREFUSEvtjUEKwzAMBPvM5GvJoX2He+nPUkTtVNmuLdkpCQEPDBgka27zc1zOsIcP83rhBJt5bAojbMeyOpyD7ZasCluwPzndYS/sL9MVroXdQM1wK+yWthhmzGF4xOfKFIZ7fG5gN5PZ8BTGV/y/IlGZIZ/937jc0De17nCKisj3zza+O6yjIqJnOr4rjFERwXmKN4dZVETYjsSbwiURtmPZwy4RtmPZwy4RtmPZFP6HPXyYJ4XH5Q2rRRk5lOQpuwAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9},"label":"Approved"},{"value":"Pending","symbol":{"angle":0,"xoffset":0,"yoffset":0,"type":"esriPMS","url":"bca499c2-071f-4b98-9774-55487fb3c432","imageData":"iVBORw0KGgoAAAANSUhEUgAAAHkAAAB5CAYAAAAd+o5JAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAA+5JREFUeNrs3b1rFEEYBvCZN34lphAVTZEqENCgmC62RzoRROyEgCnsbO4vsbGzUAikExtJJ9dqF1SiEEhlET+xkESJ8dwJSQzJ7t3e3X7M+7zPA8NyNzMsez9mmJsp1jkGPt7Sw7YWpqaTy/Ok3G7MrSwTGRO4lZQzSfmRlIYVaG8QeC9moL1RYFPQ3jCwGWixBnzq5JFHDvWt3fZE1g48dv64u35tdOdqCdpbAr40Mbz/+cPaplv/umVi6vYWga1Be3TggJsyPe8nIAdsZGhvGdgKtLcObAHaExgf2hMYH9oTGB/aExgf2hMYH9oTGB/aExgf2qMC33zQ7vleLx55SGjhCM6XjP1vFadXQmB8aCEwPrQQGB9aCIwPLQTGhxYC40MLgfGhhcD40EJgfGghMD60EBgfWgiMDy0ExocWAuNDC4HxoYXA+NBCYHxoITA+tBAYH1oIjA8tBMaHFgLjQwuB8aGFwPjQQmB8aCEwPrQQGB9aCIwPLQTGhxYC40MLgfGhhcD40EJgfGghMD60EBgfWgiMDy0ExocWAuND743kI8DjYycIrAg6eKVBH0RuHm6x/mXL/dzY5i+oIMEpeKWkuY/cmFt5mlzmD9b+2W675fcbhFYAHJyC16HM77r+X3gRGhP4yF8oQuMBp26GEBoLOBWZ0FjAmciExgHuiExoDOCuyITWD5wLmdC6gXMjE1ovcE/IhNYJ3DMyofUB94VMaF3AfSMTWg/wQMiE1gE8MDKh4wcuBJnQcQMXhkzoeIFDCn9XY2th6l5yeXLwu2ND3k1fHnGjI0OUrRi4FGRCxwVcGjKh4wEuFZnQcQCXjkzo+oErQSZ0vcCVIdcF/XbVucfP2m7tY3abiXHn7t/x7uokJnClyFVDv3zt3MOF/K+8b855NzuDB1zoZkhMGyZh5PYCHBLadxrxWoErR64KenGpXWm/mIFrQa4C+tWbavvFDFwbcpnQn7/bXUVHh1wW9IWzBI4KucrFmFXgKJC1Q8cOHA2yVmgNwFEha4PWAhwdclHQp4f7u3fefpqAo0QuAvpWo7/d2jz9tAFHizwo9N0brucDh9A+9EMDDvEu8gxyqLG4FA4q2u7Tt+w2F885NzvjYYFVIA8KbW2RpRa5TmjtwKqQ64BGAFaHXCU0CrBK5CqgkYDVIpcJjQasGrkMaERg9chFQqMCQyAXAY0MDIM8CDQ6cIigIGftdb9b3UwD7FYPAwyFnAX96/ff1JG6d9gR6pGBoabrblN3mLLD1B2m8A6nWXDAsMidoK9MDu9M0VaAoZGzoDMCCwyPnBMaGtgEchdoeGAzyBnQJoBNIR+CNgPMGMk/AQYAXmLl/NX6dpAAAAAASUVORK5CYII=","contentType":"image/png","width":9,"height":9},"label":"Pending"}]},"transparency":0}, "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" : "WorkOrderId", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "WorkOrderId", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "SCRStatus", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "SCRStatus", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Start", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Start", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Finish", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Finish", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "Project_Name", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Project Name", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Project_Type", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Project Type", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Type_of_Development", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Type of Development", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Peak_Flow__GPD_", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "Peak Flow (GPD)", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Average_Daily_Flow__GPD_", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Average Daily Flow (GPD)", "sqlType" : "sqlTypeNVarchar", "length" : 256, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Developer_Name", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Developer Name", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Developer_Contact", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Developer Contact", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Developer_Phone__", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Developer Phone #", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Developer_Email_Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Developer Email Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Developer_Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Developer Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Engineer_s_Name", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Engineer's Name", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Engineer_s_Contact", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Engineer's Contact", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Engineer_s_Phone__", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Engineer's Phone #", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Engineer_s_Email_Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Engineer's Email Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Engineer_s_Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Engineer's Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Sewershed", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Sewershed", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Evaluation", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Evaluation", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Approval_Date", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "Approval Date", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "precision" : 1 }, { "name" : "ApprovalYear", "type" : "esriFieldTypeInteger", "actualType" : "int", "alias" : "ApprovalYear", "sqlType" : "sqlTypeInteger", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Estimated_Date_of_Connection", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Estimated Date of Connection", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Actual_Date_of_Connection", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Actual Date of Connection", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Illicit_Connection", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Illicit Connection", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "Essential_Service", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "Essential Service", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "MHID", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "MHID", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "XCoord", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "XCoord", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "YCoord", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "YCoord", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "ObjectId", "type" : "esriFieldTypeOID", "actualType" : "int", "alias" : "ObjectId", "sqlType" : "sqlTypeInteger", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SCR_DATA__9A619291771D64F4", "fields" : "ObjectId", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_36094.SCR_DATA_FOR_MAPPING_SCR_DATA_FOR_MAPPING_Shape_sidx", "fields" : "Shape", "isAscending" : false, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" }, { "name" : "SCRStatus_Index", "fields" : "SCRStatus", "isAscending" : true, "isUnique" : false, "description" : "SCRStatus_Index", "indexType" : "Attribute" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "WorkOrderId" : null, "Address" : null, "SCRStatus" : null, "Start" : null, "Finish" : null, "Project_Name" : null, "Project_Type" : null, "Type_of_Development" : null, "Peak_Flow__GPD_" : null, "Average_Daily_Flow__GPD_" : null, "Developer_Name" : null, "Developer_Contact" : null, "Developer_Phone__" : null, "Developer_Email_Address" : null, "Developer_Address" : null, "Engineer_s_Name" : null, "Engineer_s_Contact" : null, "Engineer_s_Phone__" : null, "Engineer_s_Email_Address" : null, "Engineer_s_Address" : null, "Sewershed" : null, "Evaluation" : null, "Approval_Date" : null, "ApprovalYear" : null, "Estimated_Date_of_Connection" : null, "Actual_Date_of_Connection" : null, "Illicit_Connection" : null, "Essential_Service" : null, "MHID" : null, "XCoord" : null, "YCoord" : 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", "supportedConvertFileFormats" : "JSON,PBF", "supportedConvertContentFormats" : "LayerEditCollection,FeatureCollection", "supportedSpatialRelationships" : [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelDisjoint", "esriSpatialRelRelation" ], "guidFormat" : "", "supportsContingentValues" : true, "supportedContingentValuesFormats" : "JSON, PBF", "supportsFieldGroups" : true, "supportedSyncDataOptions" : 260, "hasStaticData" : true, "maxRecordCount" : 1000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }