{ "layers" : [ { "currentVersion" : 12, "id" : 1, "name" : "Potable Water", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543277239, "schemaLastEditDate" : 1769543277239, "dataLastEditDate" : 1736360189814 }, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "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, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "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" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3955385.3368999995, "ymin" : 880437.50560000166, "xmax" : 7687896.6463999981, "ymax" : 2186043.2792999991, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[165,62,112,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The original source or organization that produced and maintains the specific dataset. \",\"fieldValueType\":\"description\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the record as provided in its original source dataset\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory where the asset is located.\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature provided as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ccpi_class", "type" : "esriFieldTypeString", "alias" : "Canada's Core Public Infrastructure (CCPI) Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Canada's Core Public Infrastructure (CCPI) survey, describes the asset class of a specific infrastructure record. \",\"fieldValueType\":\"description\"}" }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Operational Status", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The operational status of feature provided as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "install_date", "type" : "esriFieldTypeString", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The date the specific infrastructure asset was installed or built. \",\"fieldValueType\":\"dateAndTime\"}" }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Infrastructure Material", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The material of the infrastructure used in the asset’s construction.\",\"fieldValueType\":\"description\"}" }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"\",\"fieldValueType\":\"\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64CF66739F", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_POTABLE_WATER_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" : "Potable Water", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "material" : null, "install_date" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "ccpi_class" : null, "status" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 2, "name" : "Solid Waste", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_solid_waste", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543284740, "schemaLastEditDate" : 1769543284740, "dataLastEditDate" : 1736360190923 }, "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" : 3697435.3863000013, "ymin" : 666617.16820000112, "xmax" : 9002580.7317999974, "ymax" : 5215739.2366999984, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[158,67,122,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"This provides a specific category of solid waste infrastructure (e.g., landfill, recycling facility).\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which the asset is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of feature provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature provided as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ccpi_class", "type" : "esriFieldTypeString", "alias" : "Canada's Core Public Infrastructure (CCPI) Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing according to Canada's Core Public Infrastructure (CCPI) definitions \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Operational Status", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The operational status of feature provided as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "address", "type" : "esriFieldTypeString", "alias" : "Feature Address", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The full address of feature provided as is from original data of the facility \",\"fieldValueType\":\"locationOrPlaceName\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64B6237B3F", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_SOLID_WASTE_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" : "Solid Waste", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "status" : null, "address" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "ccpi_class" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 3, "name" : "Telecommunications", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "csdname", "description" : "main.odi_telecom", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543293043, "schemaLastEditDate" : 1769543293043, "dataLastEditDate" : 1736360191908 }, "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, "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" : true, "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" : "esriGeometryMultipoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3729999.8249999993, "ymin" : 668583.55710000172, "xmax" : 9003811.7676, "ymax" : 5218276.4944999963, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[147,36,73,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing of the facility \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which asset is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "height", "type" : "esriFieldTypeString", "alias" : "Height (metres)", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The height of the feature in metre provided as is from original data \",\"fieldValueType\":\"measurement\"}" }, { "name" : "install_date", "type" : "esriFieldTypeString", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The install date of feature provided as is from original data \",\"fieldValueType\":\"dateAndTime\"}" }, { "name" : "height_unit", "type" : "esriFieldTypeString", "alias" : "Height Unit", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The unit of measurement for feature height \",\"fieldValueType\":\"measurement\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D6433821DDC", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_TELECOMMUNICATIONS_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" : "Telecommunications", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "install_date" : null, "height_unit" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "height" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 4, "name" : "Wastewater and Stormwater", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_wastewater_stormwater", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543300692, "schemaLastEditDate" : 1769543300692, "dataLastEditDate" : 1736360454097 }, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "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, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "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" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3951842.2687, "ymin" : 718444.62420000136, "xmax" : 8580995.3410000037, "ymax" : 3094521.3188000009, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[61,150,85,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing of the facility\",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which asset is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name provided as is from original data. \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature provided as is from original data of the facility \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ccpi_class", "type" : "esriFieldTypeString", "alias" : "Canada's Core Public Infrastructure (CCPI) Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing according to CCPI definitions. \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Operational Status", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The operational status of feature provided as is from original data. \",\"fieldValueType\":\"description\"}" }, { "name" : "ownership", "type" : "esriFieldTypeString", "alias" : "Infrastructure Ownership", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The entity name provided as is from original data. \",\"fieldValueType\":\"description\"}" }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Infrastructure Material", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature status provided as is from original data. \",\"fieldValueType\":\"description\"}" }, { "name" : "diameter", "type" : "esriFieldTypeString", "alias" : "Infrastructure Diameter", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The diameter of the feature as is from original source.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"\",\"fieldValueType\":\"\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D6467EDE8CC", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_WASTEWATER_AND_STORMWATER_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" : "Wastewater and Stormwater", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "diameter" : null, "material" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "ccpi_class" : null, "status" : null, "ownership" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 6, "name" : "Airports", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_airports_20241017", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543307899, "schemaLastEditDate" : 1769543307899, "dataLastEditDate" : 1736360454550 }, "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" : 3727455.9299999974, "ymin" : 670664.27419999754, "xmax" : 8977318.046899993, "ymax" : 5217062.9710999979, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[57,140,36,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique ID for each feature \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Name of data provider \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which asset is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The geographical area covered by a source dataset \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Feature name provided as is from original data of the facility \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature by data provider \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "elevation_ft", "type" : "esriFieldTypeString", "alias" : "Elevation (feet)", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The elevation of the airport in feet as provided by the original data \",\"fieldValueType\":\"measurement\"}" }, { "name" : "icao_code", "type" : "esriFieldTypeString", "alias" : "International Civil Aviation Organization Code", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The International Civil Aviation Organization code as provided by the original data \",\"fieldValueType\":\"description\"}" }, { "name" : "local_code", "type" : "esriFieldTypeString", "alias" : "Local Airport Code", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The local airport code code as provided by the original data \",\"fieldValueType\":\"description\"}" }, { "name" : "municipality", "type" : "esriFieldTypeString", "alias" : "Airport Municipality", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The municipality in which the airport is located \",\"fieldValueType\":\"locationOrPlaceName\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D6466A6C5D1", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_AIRPORTS_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" : "Airports", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "local_code" : null, "municipality" : null, "id" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "elevation_ft" : null, "icao_code" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 7, "name" : "Bridges and Tunnels", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_bridges_tunnels", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543315789, "schemaLastEditDate" : 1769543315789, "dataLastEditDate" : 1736360459285 }, "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, "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" : true, "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" : "esriGeometryMultipoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3949353.7067000009, "ymin" : 703871.94880000129, "xmax" : 8610424.6857, "ymax" : 4438317.3783, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[135,31,102,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which asset is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Feature name provided as is from original data of the facility\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature provided as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ccpi_class", "type" : "esriFieldTypeString", "alias" : "Canada's Core Public Infrastructure (CCPI) Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing according to CCPI definitions \",\"fieldValueType\":\"typeOrCategory\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64DCD943F2", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_BRIDGES_AND_TUNNELS_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" : "Bridges and Tunnels", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "source_class" : null, "ccpi_class" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 8, "name" : "Ports and Marinas", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_ports_marinas_20241017", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543323493, "schemaLastEditDate" : 1769543323493, "dataLastEditDate" : 1736360459707 }, "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" : 3701293.3245999995, "ymin" : 669037.07309999829, "xmax" : 9007486.7041999958, "ymax" : 4231959.3862999966, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[175,61,175,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Province or territory within which feature is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature. \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Feature Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature by data provider \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ownership", "type" : "esriFieldTypeString", "alias" : "Infrastructure Ownership", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The entity name of the owner provided as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "jurisdiction", "type" : "esriFieldTypeString", "alias" : "Infrastructure Jurisdiction", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The locality province region or city that the feature is located in \",\"fieldValueType\":\"description\"}" }, { "name" : "harbour_size", "type" : "esriFieldTypeString", "alias" : "Harbour Size", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The description of harbour size as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "un_locode", "type" : "esriFieldTypeString", "alias" : "Feature location code", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature location code provided as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "channel_depth", "type" : "esriFieldTypeString", "alias" : "Channel Depth", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature depth where applicable provided as is from original data - The measured depth of the primary navigation channel leading to the port or marina. Indicates the maximum vessel draft that can safely transit the approach route under normal tidal conditions.\",\"fieldValueType\":\"measurement\"}" }, { "name" : "anchorage_depth", "type" : "esriFieldTypeString", "alias" : "Anchorage Depth", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature depth where applicable provided as is from original data - Water depth in the designated anchorage area where vessels temporarily anchor before berthing. Used to determine suitability for vessel size and draft. \",\"fieldValueType\":\"measurement\"}" }, { "name" : "cargo_pier_depth", "type" : "esriFieldTypeString", "alias" : "Cargo Pier Depth", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature depth where applicable provided as is from original data - Depth of water adjacent to cargo-handling piers/berths. Determines the maximum draft of cargo vessels that can be safely accommodated during loading/unloading. \",\"fieldValueType\":\"measurement\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64180AEE7A", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_PORTS_AND_MARINAS_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" : "Ports and Marinas", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "anchorage_depth" : null, "cargo_pier_depth" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "ownership" : null, "jurisdiction" : null, "harbour_size" : null, "un_locode" : null, "channel_depth" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 9, "name" : "Railway Stations", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "csdname", "description" : "main.odi_railways_20241105", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543330818, "schemaLastEditDate" : 1769543330818, "dataLastEditDate" : 1736360460207 }, "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, "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" : true, "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" : "esriGeometryMultipoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3882334.9544999995, "ymin" : 705009.00789999822, "xmax" : 8579440.1859999932, "ymax" : 3400540.197799996, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[44,137,97,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature. \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which feature is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "station_name", "type" : "esriFieldTypeString", "alias" : "Station Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name/station name provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "station_type", "type" : "esriFieldTypeString", "alias" : "Station Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature class provided for the station type as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "track_name", "type" : "esriFieldTypeString", "alias" : "Track Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name/track name provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "track_class", "type" : "esriFieldTypeString", "alias" : "Track Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature class provided for the track class as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Operational Status", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature status provided as is from original data \",\"fieldValueType\":\"description\"}" }, { "name" : "use_type", "type" : "esriFieldTypeString", "alias" : "Use Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature usage provided as is from original data \",\"fieldValueType\":\"typeOrCategory\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D6417514510", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_RAILWAY_STATIONS_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" : "Railway Stations", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "status" : null, "use_type" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "station_name" : null, "station_type" : null, "track_name" : null, "track_class" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 11, "name" : "Electric Grid", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_electric_grid", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543338635, "schemaLastEditDate" : 1769543338635, "dataLastEditDate" : 1736360461754 }, "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, "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" : true, "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" : "esriGeometryMultipoint", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3703924.9211999997, "ymin" : 693899.85689999908, "xmax" : 9002156.4842, "ymax" : 4437872.5781, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[61,130,45,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "fid", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which feature is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of the data provider of the feature \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Facility Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name provided as is from original data \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "address", "type" : "esriFieldTypeString", "alias" : "Facility Address", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The full address of the feature provided as is from original data \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "ownership", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The entity name/owner name of the feature/electric asset \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "wattage", "type" : "esriFieldTypeString", "alias" : "Facility Wattage", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature wattage or power output of the feature \",\"fieldValueType\":\"measurement\"}" }, { "name" : "voltage", "type" : "esriFieldTypeString", "alias" : "Facility Voltage", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature operational voltage level of the feature or equipment \",\"fieldValueType\":\"measurement\"}" }, { "name" : "fuel_source", "type" : "esriFieldTypeString", "alias" : "Fuel Source", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The primary fuel/energy source used for electricity generation. \",\"fieldValueType\":\"description\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64A331ABB8", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_ELECTRIC_GRID_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" : "Electric Grid", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "voltage" : null, "fuel_source" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "address" : null, "ownership" : null, "wattage" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 12, "name" : "Low Carbon", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_low_carbon", "copyrightText" : "", "defaultVisibility" : false, "editingInfo" : { "lastEditDate" : 1769543346122, "schemaLastEditDate" : 1769543346122, "dataLastEditDate" : 1736360463364 }, "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" : 3703925.8500000015, "ymin" : 692909.22150000185, "xmax" : 9002159.8579000011, "ymax" : 3980781.4987999983, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[130,92,42,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "fid", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"description\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source that supplied the data.\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which feature is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of data provider of the feature \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Facility Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The official or commonly used name of the feature/facility\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "ev_other_quantity", "type" : "esriFieldTypeString", "alias" : "Electric Vehicle Stations Other Quantity", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The quantity of other or unknown type electric vehicle stations \",\"fieldValueType\":\"measurement\"}" }, { "name" : "capacity_mw", "type" : "esriFieldTypeString", "alias" : "Capacity (Megawatt)", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The Megawatt capacity of feature - Electrical generation or charging capacity of the asset, measured in megawatts (MW), indicating its maximum output or power-handling capability. \",\"fieldValueType\":\"measurement\"}" }, { "name" : "access_type", "type" : "esriFieldTypeString", "alias" : "Access Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The access type for electric vehicle charging station eg public or private \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "ownership", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The entity name/owner name of the feature\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "ev_level2_quantity", "type" : "esriFieldTypeString", "alias" : " Electric Vehicle Stations Level2 Quantity", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The quantity of level 2 electric vehicle charging stations available. \",\"fieldValueType\":\"measurement\"}" }, { "name" : "install_date", "type" : "esriFieldTypeString", "alias" : "Install Date", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The date of feature/low-carbon asset installation \",\"fieldValueType\":\"dateAndTime\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64FDF2A54B", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_LOW_CARBON_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" : "Low Carbon", "description" : "", "drawingTool" : "esriFeatureEditToolPoint", "prototype" : { "attributes" : { "ev_level2_quantity" : null, "install_date" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "ev_other_quantity" : null, "capacity_mw" : null, "access_type" : null, "ownership" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 16000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 8000, "maxRecordCountFactor" : 1, "capabilities" : "Query" }, { "currentVersion" : 12, "id" : 13, "name" : "Oil and Gas", "type" : "Feature Layer", "serviceItemId" : "1edc05b2e59c41b08440111efedda62f", "cacheMaxAge" : 30, "displayField" : "name", "description" : "main.odi_oil_gas", "copyrightText" : "", "defaultVisibility" : true, "editingInfo" : { "lastEditDate" : 1769543353993, "schemaLastEditDate" : 1769543353993, "dataLastEditDate" : 1736360549058 }, "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, "supportsMultiScaleGeometry" : true, "supportsReturningQueryGeometry" : true, "enableNullGeometry" : false, "hasGeometryProperties" : true, "geometryProperties" : { "shapeLengthFieldName" : "Shape__Length" }, "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, "supportsTrueCurve" : true, "supportedSpatialAggregationStatistics" : [ "EnvelopeAggregate", "CentroidAggregate", "ConvexHullAggregate" ], "supportsLod" : true, "supportsQueryWithLodSR" : false, "supportedLodTypes" : [ "geohash" ], "supportsReturningGeometryCentroid" : false, "supportsReturningGeometryEnvelope" : true, "supportsReturningGeometryProperties" : true, "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" : "esriGeometryPolyline", "minScale" : 0, "maxScale" : 0, "extent" : { "xmin" : 3850804.6022999994, "ymin" : 709985.07930000126, "xmax" : 8984664.2862999979, "ymax" : 5216476.7623000015, "spatialReference" : { "wkid" : 3347, "latestWkid" : 3347 } }, "drawingInfo":{"renderer":{"type":"simple","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[137,87,60,255],"width":1}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}, "allowGeometryUpdates" : true, "trueCurveSupportMode" : "OGC", "supportedCurveTypes" : [ "esriGeometryCircularArc" ], "supportedTrueCurvePbfFeatureEncodings" : [ "esriCompressedShapeBuffer", "esriDefault" ], "allowTrueCurvesUpdates" : true, "onlyAllowTrueCurveUpdatesByTrueCurveClients" : false, "hasAttachments" : false, "htmlPopupType" : "esriServerHTMLPopupTypeAsHTMLText", "hasMetadata" : true, "hasM" : false, "hasZ" : false, "objectIdField" : "fid", "uniqueIdField" : { "name" : "fid", "isSystemMaintained" : true }, "globalIdField" : "", "typeIdField" : "", "collation" : { "locale" : "neutral", "caseSensitive" : false, "accentSensitive" : true }, "fields" : [ { "name" : "fid", "type" : "esriFieldTypeOID", "alias" : "fid", "sqlType" : "sqlTypeOther", "length" : 8, "nullable" : false, "editable" : false, "domain" : null, "defaultValue" : null }, { "name" : "id", "type" : "esriFieldTypeString", "alias" : "Feature ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"A unique identifier for each feature.\",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "sub_type", "type" : "esriFieldTypeString", "alias" : "Sub Type", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature assigned during processing \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "provider", "type" : "esriFieldTypeString", "alias" : "Data Provider", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The organization or source name of the data provider\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_id", "type" : "esriFieldTypeString", "alias" : "Source ID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier of feature provided as is from original data \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "prov_terr", "type" : "esriFieldTypeString", "alias" : "Province/Territory", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The province or territory within which feature is geographically located \",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "region", "type" : "esriFieldTypeString", "alias" : "Data Provider Region", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The region of data provider of the feature\",\"fieldValueType\":\"locationOrPlaceName\"}" }, { "name" : "csdname", "type" : "esriFieldTypeString", "alias" : "Census Subdivision Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The name of the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "csduid", "type" : "esriFieldTypeString", "alias" : "Census Subdivision UID", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"Unique identifier for the census subdivision assigned from geographic coordinates using Statistics Canada 2021 Cartographic boundary file \",\"fieldValueType\":\"uniqueIdentifier\"}" }, { "name" : "name", "type" : "esriFieldTypeString", "alias" : "Facility Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The feature name provided as is from original data for the oil and gas asset \",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "source_class", "type" : "esriFieldTypeString", "alias" : "Source Class", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The classification of feature source indicating the type pf origin \",\"fieldValueType\":\"typeOrCategory\"}" }, { "name" : "status", "type" : "esriFieldTypeString", "alias" : "Operational Status", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The operational status of the feature\",\"fieldValueType\":\"description\"}" }, { "name" : "material", "type" : "esriFieldTypeString", "alias" : "Infrastructure Material", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The primary construction material of the facility provided as is from original source \",\"fieldValueType\":\"description\"}" }, { "name" : "ownership", "type" : "esriFieldTypeString", "alias" : "Owner Name", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The entity name/owner name of the asset\",\"fieldValueType\":\"nameOrTitle\"}" }, { "name" : "substance", "type" : "esriFieldTypeString", "alias" : "Substance Handled", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The type of fuel substance handled or transported \",\"fieldValueType\":\"description\"}" }, { "name" : "diameter", "type" : "esriFieldTypeString", "alias" : "Infrastructure Diameter", "sqlType" : "sqlTypeOther", "length" : 2147483647, "nullable" : true, "editable" : true, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"The diameter of the feature/asset provided as is from original source \",\"fieldValueType\":\"measurement\"}" }, { "name" : "Shape__Length", "type" : "esriFieldTypeDouble", "alias" : "Shape__Length", "sqlType" : "sqlTypeDouble", "nullable" : true, "editable" : false, "domain" : null, "defaultValue" : null, "description" : "{\"value\":\"\",\"fieldValueType\":\"\"}" } ], "indexes" : [ { "name" : "PK__OPEN_DAT__D9908D64D477E483", "fields" : "fid", "isAscending" : true, "isUnique" : true, "description" : "", "indexType" : "Attribute" }, { "name" : "Shape__Length_Index", "fields" : "Shape__Length", "isAscending" : true, "isUnique" : false, "description" : "", "indexType" : "Attribute" }, { "name" : "user_755.OPEN_DATABASE_OF_INFRASTRUCTURE_OIL_AND_GAS_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" : "Oil and Gas", "description" : "", "drawingTool" : "esriFeatureEditToolLine", "prototype" : { "attributes" : { "diameter" : null, "substance" : null, "id" : null, "sub_type" : null, "provider" : null, "source_id" : null, "prov_terr" : null, "region" : null, "csdname" : null, "csduid" : null, "name" : null, "source_class" : null, "status" : null, "material" : null, "ownership" : 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" : false, "maxRecordCount" : 2000, "standardMaxRecordCount" : 2000, "standardMaxRecordCountNoGeometry" : 32000, "tileMaxRecordCount" : 4000, "maxRecordCountFactor" : 1, "capabilities" : "Query" } ], "tables" : [] }