{ "currentVersion" : 12, "id" : 0, "name" : "Soil_Relocation_Source_Sites", "type" : "Feature Layer", "serviceItemId" : "aea64fd79d3a4ea8851a74e8d00ce757", "cacheMaxAge" : 30, "displayField" : "", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1778400046435, "schemaLastEditDate" : 1778400046435, "dataLastEditDate" : 1778400040545 }, "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" : -14452176.580559848, "ymin" : 6172137.5993314022, "xmax" : -13097782.639717245, "ymax" : 8110614.38165131, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 } }, "spatialReference" : { "wkid" : 102100, "latestWkid" : 3857 }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"RedSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAAB3VJREFUeF7tmPlTlEcexnve94U5mANQbgQSbgiHXHINlxpRIBpRI6wHorLERUmIisKCQWM8cqigESVQS1Kx1piNi4mW2YpbcZONrilE140RCTcy3DDAcL/zbJP8CYPDL+9Ufau7uqb7eZ7P+/a8PS8hwkcgIBAQCAgEBAICAYGAQEAgIBAQCAgEBAICAYGAQEAgIBAQCDx/AoowKXFMUhD3lQrioZaQRVRS+fxl51eBTZUTdZ41U1Rox13/0JF9csGJ05Qv4jSz/YPWohtvLmSKN5iTGGqTm1+rc6weICOBRbZs1UVnrv87T1PUeovxyNsUP9P6n5cpHtCxu24cbrmwKLdj+osWiqrVKhI0xzbmZ7m1SpJ+1pFpvE2DPvGTomOxAoNLLKGLscZYvB10cbYYjrJCb7A5mrxleOBqim+cWJRakZY0JfnD/LieI9V1MrKtwokbrAtU4Vm0A3TJnphJD4B+RxD0u0LA7w7FTE4oprOCMbklEGNrfdGf4IqnQTb4wc0MFTYibZqM7JgjO8ZdJkpMln/sKu16pHZGb7IfptIWg389DPp9kcChWODoMuDdBOhL1JgpisbUvghM7AqFbtNiaFP80RLnhbuBdqi0N+1dbUpWGde9gWpuhFi95yL7sS7BA93JAb+Fn8mh4QujgPeTgb9kAZf3Apd2A+fXQ38yHjOHozB1IAJjOSEY2RSIwVUv4dd4X9wJccGHNrJ7CYQ4GGjLeNNfM+dyvgpzQstKf3pbB2A6m97uBRE0/Ergcxr8hyqg7hrwn0vAtRIKIRX6Y2pMl0RhIj8co9nBGFrvh55l3ngU7YObng7IVnFvGS+BYUpmHziY/Ls2zgP9SX50by/G9N5w6I+ogYvpwK1SoOlHQNsGfWcd9Peqof88B/rTyzF9hAIopAByQzC0JQB9ST5oVnvhnt+LOGsprvUhxNIwa0aY7cGR6Cp7tr8+whkjawIxkRWC6YJI6N+lAKq3Qf/Tx+B77oGfaQc/8hB8w2Xwtw9Bf3kzZspXY/JIDEbfpAB2BKLvVV90Jvjgoac9vpRxE8kciTVCBMMkNirJ7k/tRHyjtxwjKV4Yp3t/6s+R4E+/DH3N6+BrS8E314Dvvg2+/Sb4hxfBf5sP/up2TF3ZhonK1zD6dhwGdwail26DzqgX8MRKiq9ZBpkSkmeYOyPM3m9Jjl+1Z9D8AgNtlAq6bZ70qsZi+q+bwV/7I/hbB8D/dAr8Axq89iz474p/G5++koHJy1sx/lkGdBc2YjA3HF0rHNHuboomuQj/5DgclIvOGCGCYRKFFuTMV7YUAD3VDQaLMfyqBcZORGPy01QKYSNm/rYV/Nd/Av9NHvgbueBrsjDzRQamKKDxT9Kgq1iLkbIUDOSHoiNcgnYHgnYZi+9ZExSbiSoMc2eE2flKcuJLa4KGRQz6/U0wlGaP0feiMH4uFpMXEjBVlYjp6lWY+SSZtim0kulYMiYuJEJXuhTDJ9UYPByOvoIwdCxfgE4bAo0Jh39xLAoVpMwIEQyTyFCQvGpLon9sJ0K3J4OBDDcMH1dj9FQsxkrjMPFRPCbOx2GyfLal9VEcxstioTulxjAFNfROJPqLl6Bnfyg6V7ugz5yBhuHwrZjBdiU5YJg7I8wOpifAKoVIW7uQ3rpOBH2b3ekVjYT2WCRG3o+mIGKgO0OrlIaebU/HYOQDNbQnojB4NJyGD0NPfjA0bwTRE6Q7hsUcWhkWN8yZqSQlWWGECAZLmJfJmbrvVSI8taK37xpbdB/wQW8xPee/8xIGjvlj8IQ/hk4G0JbWcX8MHPVDX4kveoq8ocn3xLM33NCZRcPHOGJYZIKfpQyq7JjHS6yJjcHujLHADgkpuC7h8F8zEVqXSNC2awE69lqhs8AamkO26HrbDt2H7dBVQov2NcW26CiwQtu+BWjdY4n2nZboTbfCmKcCnRyDO/YmyLPnDlHvjDH8G6zhS9/wlEnYR7X00fWrFYuWdVI0ZpuhcbcczW/R2qdAcz6t/bRov4mONeaaoYl+p22rHF0bVNAmKtBvweIXGxNcfFH8eNlC4m6wMWMusEnKpn5hyo48pj9gLe4SNG9QoGGLAk8z5XiaJUd99u8122/IpBA2K9BGg2vWWKAvRYVeLzEa7E1R422m2+MsSTem97nSYnfKyN6/mzATv7AUgqcMrUnmaFlLX3ysM0fj+t/b5lQLtK22QEfyAmiSLKFZpUJ7kBRPXKW4HqCYynWVHKSG2LkyZex1uO1mZM9lKem9Tx9jjY5iNEYo0bKMhn7ZAu0r6H5PpLXCAq0rKJClSjSGynE/QIkrQYqBPe6S2X+AJsY2Ped6iWZk6RlL0c2r5szofRsO9R5S1IfQLRCpQL1aifoYFerpsbkuTImaUJXuXIDiH6/Ys8vm3Mg8L2i20YqsO7fItKLcSXyn0kXccclVqv3MS6at9JU/Ox+ouns+SF6Z4cSupz7l8+z1ucs7LF1AQjOdxfGZzmx8Iu1TRcfnrioICAQEAgIBgYBAQCAgEBAICAQEAgIBgYBAQCAgEBAICAQEAv8H44b/6ZiGvGAAAAAASUVORK5CYII=","contentType":"image/png","width":15,"height":15}}}, "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" : "confirmationId", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "confirmationId", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The confirmation ID is a number generated by the CHEFS form each time a soil relocation notification form is submitted. The number is used by submitters, First Nations, municipalities, members of the public and ministry staff to track individual submissions. The confirmation ID can also be used to request additional information from the soil relocation team. \",\"fieldValueType\":\"\"}" }, { "name" : "ownerCompany", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "ownerCompany", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the name of the company associated with the property owner of the source site involved in the soil relocation. An example entry might be 'South Coast British Columbia Transportation Authority, TransLink.' The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "owner2Company", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "owner2Company", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the name of an additional company associated with the property owner of the source site involved in the soil relocation, if applicable. An example entry might be '359719 B.C. LTD.' The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "contactCompany", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "contactCompany", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the name of the company associated with the contact person for the source site involved in the soil relocation. An example entry might be 'Summit Earthworks Inc.' The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "SID", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "SID", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field displays the Site registry number which users enter into the soil relocation submission form if their property has a Site registry site ID. The site ID is a numerical value and can be a single digit or up to 5 digits in length. \",\"fieldValueType\":\"\"}" }, { "name" : "latitude", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "latitude", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the latitude of the source site involved in the soil relocation. An example entry might be '49.2687277777777.' The data is in a nullable Double format.\",\"fieldValueType\":\"\"}" }, { "name" : "longitude", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "longitude", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the longitude of the source site involved in the soil relocation. An example entry might be '-123.002644444444.' The data is in a nullable Double format.\",\"fieldValueType\":\"\"}" }, { "name" : "landOwnership", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "landOwnership", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field indicates the type of land ownership for the source site involved in the soil relocation. The data is in text format, with the complete list of options being 'Legally titled, registered property', 'Untitled Crown land', 'Untitled municipal land', or 'Reserve land.'\",\"fieldValueType\":\"\"}" }, { "name" : "legallyTitledSiteAddress", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "legallyTitledSiteAddress", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the site street address for a legally titled, registered property of the receiving site involved in the soil relocation. If an address is not assigned, the nearest street name or intersection should be provided. The data is in nullable text format, and an example entry might be '4567 Lougheed Highway.'\",\"fieldValueType\":\"\"}" }, { "name" : "legallyTitledSiteCity", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "legallyTitledSiteCity", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the site city for a legally titled, registered property of the receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be 'Burnaby.'\",\"fieldValueType\":\"\"}" }, { "name" : "legallyTitledSitePostalCode", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "legallyTitledSitePostalCode", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the site postal code for a legally titled, registered property of the receiving site. The data is in nullable text format, and an example entry might be 'V5C 3Z6.'\",\"fieldValueType\":\"\"}" }, { "name" : "regionalDistrict", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "regionalDistrict", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the regional district of the source site involved in the soil relocation. The data is a non-nullable text type. For example, 'Metro Vancouver Regional District.' is one of selections.\",\"fieldValueType\":\"\"}" }, { "name" : "PID", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "PID", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the Parcel Identifier (PID) for each parcel at the source site where a Schedule 2 use has occurred. PIDs can be found on BC Assessment or the BC Land Title and Survey Authority (LTSA). The data format is 'XXX-XXX-XXX,' where each 'X' is a digit. If the site has multiple PIDs, they will be represented as a comma-separated list. An example entry might be '013-206-222,008-238-057,011-263-873,013-038-796,009-324-532' or '032-275-161.' The data is in a nullable String format.\",\"fieldValueType\":\"\"}" }, { "name" : "PIN", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "PIN", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the Parcel Identification Number (PIN) for untitled Crown land of the source site involved in the soil relocation. The data is in a nullable text format, and an example entry might be '7126700.'\",\"fieldValueType\":\"\"}" }, { "name" : "legalLandDescription", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "legalLandDescription", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field lists the crown land file number, a unique seven digit number, regionally based, to identify an application or tenure on crown land. The crown land registry is a record of crown land ownership, rights, interests and encumbrances according to the Land Act.\",\"fieldValueType\":\"\"}" }, { "name" : "crownLandFileNumbers", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "crownLandFileNumbers", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the file number(s) for untitled Crown land of the source site involved in the soil relocation. The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "reserveNameAndNumber", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "reserveNameAndNumber", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the name and number for reserve land of the source site involved in the soil relocation. The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "sourceSiteLandUse", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "sourceSiteLandUse", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field displays the applicable primary land use for the receiving site as per the Contaminated Sites Regulations Section 12. The data is in a nullable text format. \",\"fieldValueType\":\"\"}" }, { "name" : "highVolumeSite", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "highVolumeSite", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records whether the receiving site qualifies as a high volume site, defined as having more than 20,000 cubic metres of material deposited over its lifetime. The data is stored as 'Yes' or 'No', ensuring accurate classification of the site's volume status for tracking and regulatory purposes.\",\"fieldValueType\":\"\"}" }, { "name" : "soilRelocationPurpose", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "soilRelocationPurpose", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field describes the purpose of the soil excavation and relocation at the source site. For example, the purpose might be 'Site redevelopment and landfill closure' or 'Treated soil disposal.' The data is a non-null text format.\",\"fieldValueType\":\"\"}" }, { "name" : "soilStorageType", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "soilStorageType", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field captures the current type of soil storage at the source site. Typical values include 'stockpiled' or 'in situ'. This entry is essential and describes the condition and handling of the soil as part of the overall project details. The data is a non-null text format.\",\"fieldValueType\":\"\"}" }, { "name" : "protocol19Exemptions", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "protocol19Exemptions", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records whether exemptions from Protocol 19 apply to the source site. The data is stored as 'Yes' or 'No'.\",\"fieldValueType\":\"\"}" }, { "name" : "industrialSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "industrialSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the industrial (IL) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "commercialSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "commercialSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the commercial (CL) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "residentHighDensitySoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "residentHighDensitySoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the residential (RLHD) high density soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "residentLowDensitySoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "residentLowDensitySoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the residential (RLLD) low density soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "urbanParkSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "urbanParkSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the urban park (PL) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "agriculturalSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "agriculturalSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the agricultural (AL) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "wildlandsNaturalSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "wildlandsNaturalSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the wildlands natural (WLN) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "wildlandsRevertedSoilVol", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "wildlandsRevertedSoilVol", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the soil volume to be relocated (in cubic metres) for the wildlands reverted (WLR) soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "totalSoilVolume", "type" : "esriFieldTypeDouble", "actualType" : "float", "alias" : "totalSoilVolume", "sqlType" : "sqlTypeFloat", "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the total soil volume to be relocated (in cubic metres) for all types of soil quality. The data is a numerical value, and an example entry might be '13579'.\",\"fieldValueType\":\"\"}" }, { "name" : "mlardYesNo", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "mlardYesNo", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records whether the soil is composed of quarried material produced through the mining and crushing of bedrock. The data is stored as 'Yes' or 'No'.\",\"fieldValueType\":\"\"}" }, { "name" : "vapourExemption", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "vapourExemption", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records whether exemptions from analyzing vapour under the Contaminated Site Regulation or Protocol 19 apply to the source site. The data is stored as 'Yes' or 'No'.\",\"fieldValueType\":\"\"}" }, { "name" : "vapourExemptionDesc", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "vapourExemptionDesc", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the vapour characterization method used if exemptions from analyzing vapour under the Contaminated Site Regulation or Protocol 19 do not apply to the source site. The data is in a nullable text format.\",\"fieldValueType\":\"\"}" }, { "name" : "soilRelocationStartDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "soilRelocationStartDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the estimated start date for soil relocation at the source site. The data is in DATE format and includes a fixed time of 12:00 a.m. to ensure proper recognition by dashboards, which may not detect the field if only the date is provided. An example entry would be '8/26/2024, 12:00 a.m.' This format ensures that the date is accurately captured and displayed across various platforms.\",\"fieldValueType\":\"\"}", "precision" : 1 }, { "name" : "soilRelocationCompletionDate", "type" : "esriFieldTypeDate", "actualType" : "datetime2", "alias" : "soilRelocationCompletionDate", "sqlType" : "sqlTypeTimestamp2", "length" : 8, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the estimated completion date for soil relocation at the source site. The data is in DATE format and includes a fixed time of 12:00 a.m. to ensure proper recognition by dashboards, which may not detect the field if only the date is provided. An example entry would be '8/26/2024, 12:00 a.m.' This format ensures that the date is accurately captured and displayed across various platforms.\",\"fieldValueType\":\"\"}", "precision" : 1 }, { "name" : "relocationMethod", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "relocationMethod", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field describes the method used for soil relocation at the source site. Examples include 'truck', 'barge', or 'train'. The data is a non-null text format.\",\"fieldValueType\":\"\"}" }, { "name" : "qualifiedProfessionalOrganization", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "qualifiedProfessionalOrganization", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null }, { "name" : "receivingSite1Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite1Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the street address of the receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be '4567 Lougheed Highway.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite1City", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite1City", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the city of the receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be 'Burnaby.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite1RegionalDistrict", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite1RegionalDistrict", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the regional district of the receiving site involved in the soil relocation. The data is a non-nullable text type. For example, 'Metro Vancouver Regional District.' is one of selections.\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite2Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite2Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the street address of the first additional receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be '4567 Lougheed Highway.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite2City", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite2City", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the city of the first additional receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be 'Burnaby.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite2RegionalDistrict", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite2RegionalDistrict", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the regional district of the first additional receiving site involved in the soil relocation. The data is a non-nullable text type. For example, 'Metro Vancouver Regional District.' is one of selections.\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite3Address", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite3Address", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the street address of the secondadditional receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be '4567 Lougheed Highway.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite3City", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite3City", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the city of the second additional receiving site involved in the soil relocation. The data is in nullable text format, and an example entry might be 'Burnaby.'\",\"fieldValueType\":\"\"}" }, { "name" : "receivingSite3RegionalDistrict", "type" : "esriFieldTypeString", "actualType" : "nvarchar", "alias" : "receivingSite3RegionalDistrict", "sqlType" : "sqlTypeNVarchar", "length" : 4000, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The field records the regional district of the second additional receiving site involved in the soil relocation. The data is a non-nullable text type. For example, 'Metro Vancouver Regional District.' is one of selections.\",\"fieldValueType\":\"\"}" }, { "name" : "ObjectId", "type" : "esriFieldTypeOID", "actualType" : "int", "alias" : "ObjectId", "sqlType" : "sqlTypeInteger", "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null } ], "indexes" : [ { "name" : "PK__SOIL_REL__9A6192917004B7DF", "fields" : "ObjectId", "isAscending" : true, "isUnique" : true, "description" : "clustered, unique, primary key", "indexType" : "Attribute" }, { "name" : "user_37701.SOIL_RELOCATION_SOURCE_SITES_SOIL_RELOCATION_SOURCE_SITES_Shape_sidx", "fields" : "Shape", "isAscending" : true, "isUnique" : false, "description" : "Shape Index", "indexType" : "Spatial" } ], "dateFieldsTimeReference" : { "timeZone" : "UTC", "timeZoneIANA" : "Etc/UTC", "respectsDaylightSaving" : false }, "preferredTimeReference" : null, "types" : [], "templates" : [ { "name" : "New Feature", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "confirmationId" : null, "ownerCompany" : null, "owner2Company" : null, "contactCompany" : null, "SID" : null, "latitude" : null, "longitude" : null, "landOwnership" : null, "legallyTitledSiteAddress" : null, "legallyTitledSiteCity" : null, "legallyTitledSitePostalCode" : null, "regionalDistrict" : null, "PID" : null, "PIN" : null, "legalLandDescription" : null, "crownLandFileNumbers" : null, "reserveNameAndNumber" : null, "sourceSiteLandUse" : null, "highVolumeSite" : null, "soilRelocationPurpose" : null, "soilStorageType" : null, "protocol19Exemptions" : null, "industrialSoilVol" : null, "commercialSoilVol" : null, "residentHighDensitySoilVol" : null, "residentLowDensitySoilVol" : null, "urbanParkSoilVol" : null, "agriculturalSoilVol" : null, "wildlandsNaturalSoilVol" : null, "wildlandsRevertedSoilVol" : null, "totalSoilVolume" : null, "mlardYesNo" : null, "vapourExemption" : null, "vapourExemptionDesc" : null, "soilRelocationStartDate" : null, "soilRelocationCompletionDate" : null, "relocationMethod" : null, "qualifiedProfessionalOrganization" : null, "receivingSite1Address" : null, "receivingSite1City" : null, "receivingSite1RegionalDistrict" : null, "receivingSite2Address" : null, "receivingSite2City" : null, "receivingSite2RegionalDistrict" : null, "receivingSite3Address" : null, "receivingSite3City" : null, "receivingSite3RegionalDistrict" : 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" }