{ "tables": [], "layers": [ { "isCoGoEnabled": false, "extent": { "ymin": 48.117898000000025, "xmin": 16.18182300000001, "ymax": 48.322659999999985, "xmax": 16.577503999999976, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 0, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Austria_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Austria_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "SND_CEDM_DB.PANORAMA_WORKSPACE.ERIX_AVGRENT_GEOM", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5589_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6446_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 14, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 14, "label": "14.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 15, "label": "14.000001 - 15.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 17, "label": "15.000001 - 17.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 18, "label": "17.000001 - 18.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 20, "label": "18.000001 - 20.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 50.54328400000003, "xmin": 4.134103999999979, "ymax": 50.95938799999999, "xmax": 4.668717000000015, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 1, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Belgium_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Belgium_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Belgium_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5590_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6447_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 128, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 128, "label": "128.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 140, "label": "128.000001 - 140.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 195, "label": "140.000001 - 195.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 207, "label": "195.000001 - 207.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 227, "label": "207.000001 - 227.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 55.614265999999986, "xmin": 12.451701000000014, "ymax": 55.729543999999976, "xmax": 12.648639000000003, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 2, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Denmark_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Denmark_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "SND_CEDM_DB.PANORAMA_WORKSPACE.ERIX_AVGRENT_GEOM", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5591_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6448_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 900, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 1050, "label": "900.000000 - 1050.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 1200, "label": "1050.000001 - 1200.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 1450, "label": "1200.000001 - 1450.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 1600, "label": "1450.000001 - 1600.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 2100, "label": "1600.000001 - 2100.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 60.16028299999999, "xmin": 24.802858000000015, "ymax": 60.32013599999999, "xmax": 24.984418000000005, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 3, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Finalnd_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Finalnd_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Finalnd_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5592_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6449_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 195, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 195, "label": "195.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 240, "label": "195.000001 - 240.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 258, "label": "240.000001 - 258.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 272, "label": "258.000001 - 272.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 315, "label": "272.000001 - 315.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 48.12007699999998, "xmin": 1.446300000000008, "ymax": 49.241488000000004, "xmax": 3.5590270000000146, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 4, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "France_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "France_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "France_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5593_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6450_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 113, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 136, "label": "113.000000 - 136.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 208, "label": "136.000001 - 208.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 346, "label": "208.000001 - 346.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 535, "label": "346.000001 - 535.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 822, "label": "535.000001 - 822.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 47.92065100000002, "xmin": 6.614820000000009, "ymax": 53.73941000000002, "xmax": 13.761340000000018, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 5, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Germany_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Germany_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Germany_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5594_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6451_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 10, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 14, "label": "10.000000 - 14.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 19, "label": "14.000001 - 19.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 26, "label": "19.000001 - 26.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 33, "label": "26.000001 - 33.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 58, "label": "33.000001 - 58.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 41.791650000000004, "xmin": 8.706096000000002, "ymax": 45.74273299999999, "xmax": 12.615715000000023, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 6, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Italy_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Italy_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Italy_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5595_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6452_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 183, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 183, "label": "183.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 220, "label": "183.000001 - 220.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 294, "label": "220.000001 - 294.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 409, "label": "294.000001 - 409.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 510, "label": "409.000001 - 510.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 51.429328, "xmin": 4.255528000000027, "ymax": 52.43106399999999, "xmax": 5.502882, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 7, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Netherlands_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Netherlands_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Netherlands_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5596_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6453_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 120, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 150, "label": "120.000000 - 150.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 200, "label": "150.000001 - 200.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 235, "label": "200.000001 - 235.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 330, "label": "235.000001 - 330.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 425, "label": "330.000001 - 425.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 59.815920000000006, "xmin": 10.396036999999978, "ymax": 59.957133, "xmax": 10.84939300000002, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 8, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Norway_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Norway_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Norway_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5597_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6454_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 1755, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 1775, "label": "1755.000000 - 1775.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 2003, "label": "1775.000001 - 2003.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 2793, "label": "2003.000001 - 2793.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 3200, "label": "2793.000001 - 3200.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 5078, "label": "3200.000001 - 5078.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 52.097849999999994, "xmin": 20.851688000000024, "ymax": 52.368154000000004, "xmax": 21.271150999999975, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 9, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Poland_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Poland_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Poland_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5598_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6455_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 58, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 247, 252, 245, 255 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 58, "label": "58.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 0, 68, 27, 255 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 92, "label": "58.000001 - 92.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 38.67315100000002, "xmin": -9.44205199999999, "ymax": 41.265243999999996, "xmax": -8.541553000000022, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 10, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Portugal_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Portugal_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Portugal_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5599_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6456_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 16, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 16, "label": "16.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 18, "label": "16.000001 - 18.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 20, "label": "18.000001 - 20.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 22, "label": "20.000001 - 22.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 25, "label": "22.000001 - 25.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 39.88460199999997, "xmin": -4.579075999999986, "ymax": 42.09783199999998, "xmax": 2.9751380000000154, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 11, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Spain_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Spain_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Spain_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5600_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6457_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 7, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 7, "label": "7.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 12, "label": "7.000001 - 12.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 15, "label": "12.000001 - 15.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 21, "label": "15.000001 - 21.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 28, "label": "21.000001 - 28.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 55.54874699999999, "xmin": 11.924769000000026, "ymax": 59.41932300000002, "xmax": 18.152507000000014, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 12, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Sweden_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Sweden_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Sweden_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5601_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6458_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "minValue": 2000, "field": "average_rent", "authoringInfo": { "colorRamp": { "colorRamps": [ { "toColor": [ 228, 245, 223, 255 ], "fromColor": [ 247, 252, 245, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 197, 232, 190, 255 ], "fromColor": [ 228, 245, 223, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 160, 217, 154, 255 ], "fromColor": [ 197, 232, 190, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 116, 196, 119, 255 ], "fromColor": [ 160, 217, 154, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 65, 171, 93, 255 ], "fromColor": [ 116, 196, 119, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 35, 140, 70, 255 ], "fromColor": [ 65, 171, 93, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 110, 44, 255 ], "fromColor": [ 35, 140, 70, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" }, { "toColor": [ 0, 69, 28, 255 ], "fromColor": [ 0, 110, 44, 255 ], "type": "algorithmic", "algorithm": "esriCIELabAlgorithm" } ], "type": "multipart" }, "type": "classedColor", "classificationMethod": "esriClassifyNaturalBreaks" }, "legendOptions": {"order": "ascendingValues"}, "classBreakInfos": [ { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 222, 234, 218, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 2100, "label": "2000.000000 - 2100.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 156, 191, 153, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 2500, "label": "2100.000001 - 2500.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 84, 130, 84, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 3600, "label": "2500.000001 - 3600.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 153 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 4900, "label": "3600.000001 - 4900.000000" }, { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 28, 81, 29, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "classMaxValue": 7400, "label": "4900.000001 - 7400.000000" } ], "type": "classBreaks", "classificationMethod": "esriClassifyNaturalBreaks" }, "scaleSymbols": true, "transparency": 0, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true }, { "isCoGoEnabled": false, "extent": { "ymin": 46.177648999999974, "xmin": 6.110324999999989, "ymax": 47.600911999999994, "xmax": 8.65286900000001, "spatialReference": { "latestWkid": 4326, "wkid": 4326 } }, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": false, "maxRecordCount": 2000, "infoInEstimates": [ "extent", "count" ], "datesInUnknownTimezone": false, "type": "Feature Layer", "onlyAllowTrueCurveUpdatesByTrueCurveClients": false, "supportsAttachmentsByUploadId": true, "editingInfo": {}, "relationships": [], "supportsAttachmentsResizing": true, "cimVersion": "3.1.0", "isDataArchived": false, "id": 13, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson", "standardMaxRecordCount": 2000, "isDataVersioned": false, "templates": [ { "name": "Switzerland_Average_Rent", "description": "", "drawingTool": "esriFeatureEditToolPolygon", "prototype": { "attributes": { "date": null, "country": null, "average_rent": null, "gid": null, "average_rent_euro_per_year": null, "city": null, "currency_iso": null, "submarket": null, "currency_frequency": null, "currency_valutasign": null, "average_rent_yoy": null } } } ], "hasGeometryProperties": true, "supportsAdvancedQueries": true, "parentLayer": null, "currentVersion": 11.4, "canScaleSymbols": false, "hasZ": false, "advancedEditingCapabilities": { "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsReturnEditResults": true, "supportedSqlFormatsInCalculate": [ "standard" ], "supportedApplyEditsUploadIDFormats": "JSON,PBF" }, "objectIdField": "esri_oid", "supportsQuantizationEditMode": true, "name": "Switzerland_Average_Rent", "allowTrueCurvesUpdates": false, "displayField": "country", "supportsCalculate": true, "fields": [ { "nullable": true, "editable": true, "defaultValue": null, "name": "gid", "alias": "gid", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "country", "length": 255, "alias": "country", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "city", "length": 255, "alias": "city", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "submarket", "length": 255, "alias": "submarket", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "precision": 1, "name": "date", "length": 29, "alias": "date", "type": "esriFieldTypeDate" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent", "alias": "average_rent", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_euro_per_year", "alias": "average_rent_euro_per_year", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "average_rent_yoy", "alias": "average_rent_yoy", "type": "esriFieldTypeDouble" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_valutasign", "length": 4, "alias": "currency_valutasign", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_iso", "length": 3, "alias": "currency_iso", "type": "esriFieldTypeString" }, { "nullable": true, "editable": true, "defaultValue": null, "name": "currency_frequency", "length": 7, "alias": "currency_frequency", "type": "esriFieldTypeString" }, { "nullable": false, "editable": false, "defaultValue": null, "name": "esri_oid", "length": 4, "alias": "esri_oid", "type": "esriFieldTypeOID" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Length", "alias": "SHAPE__Length", "type": "esriFieldTypeDouble" }, { "virtual": true, "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "SHAPE__Area", "alias": "SHAPE__Area", "type": "esriFieldTypeDouble" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" }, "supportsFieldDescriptionProperty": true, "hasM": false, "allowGeometryUpdates": true, "useStandardizedQueries": true, "globalIdField": null, "description": "Switzerland_Average_Rent", "syncCanReturnChanges": true, "supportsAsyncDelete": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin" ], "geometryProperties": { "shapeAreaFieldName": "SHAPE__Area", "shapeLengthFieldName": "SHAPE__Length", "units": "esriDecimalDegrees" }, "supportsRollbackOnFailureParameter": true, "isDataReplicaTracked": false, "standardMaxRecordCountNoGeometry": 16000, "supportsTruncate": true, "indexes": [ { "name": "a5602_ix1", "isUnique": false, "description": "", "fields": "geom", "isAscending": true }, { "name": "r6459_sde_rowid_uk", "isUnique": true, "description": "", "fields": "esri_oid", "isAscending": true } ], "supportedAppendSourceFilterFormats": "featureService", "editFieldsInfo": null, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "GUIDFormat": "O", "minScale": 0, "hasAttachments": false, "queryBinsCapabilities": { "supportedStatisticTypes": [ "count", "sum", "min", "max", "avg", "stddev", "var", "percentile_cont", "percentile_disc" ], "supportsFixedIntervalBin": true, "supportsAutoIntervalBin": true, "supportsFixedBoundariesBin": true, "supportsDateBin": true }, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsQueryWithDatumTransformation": true, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "supportsDefaultSR": true, "supportsQueryDateBins": false, "supportsQueryWithLodSR": true, "supportsPaginationOnAggregatedQueries": true, "supportsPagination": true, "supportsMaxRecordCountFactor": true, "supportsStatistics": true, "supportsOrderBy": true, "supportsReturningGeometryProperties": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsLod": true, "supportsSpatialAggregationStatistics": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsQueryAttachmentsCountOnly": true, "supportsOrderByOnlyOnLayerFields": false, "supportsOutFieldSqlExpression": true, "supportsTopFeaturesQuery": true, "supportsReturningGeometryEnvelope": true, "supportsDistinct": true, "supportsReturningGeometryCentroid": true, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "supportsValidateSQL": true, "serviceItemId": "a80db01a4c564cfab861fe46b4fb76ca", "allowUpdateWithoutMValues": true, "supportsCoordinatesQuantization": true, "types": [], "capabilities": "Query", "maxScale": 0, "supportsAppend": true, "supportsExceedsLimitStatistics": true, "defaultVisibility": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": false }, "hasMetadata": true, "supportedAppendFormats": "csv,excel,featureCollection,featureService,geojson,jsonl,pbf,shapefile", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "sqlParserVersion": "PG_11.4.0", "drawingInfo": { "renderer": { "symbol": { "symbol": { "angleAlignment": "Map", "symbolLayers": [ { "lineStyle3D": "Strip", "joinStyle": "Round", "color": [ 110, 110, 110, 255 ], "enable": true, "capStyle": "Round", "width": 0.7, "miterLimit": 10, "type": "CIMSolidStroke" }, { "color": [ 204, 204, 204, 179 ], "enable": true, "type": "CIMSolidFill" } ], "type": "CIMPolygonSymbol" }, "type": "CIMSymbolReference" }, "type": "simple" }, "scaleSymbols": true, "transparency": 0, "symbolLayerDrawing": {"type": "CIMSymbolLayerDrawing"}, "labelingInfo": null }, "geometryField": { "sqlType": "sqlTypeOther", "nullable": true, "editable": true, "name": "geom", "typeName": "st_geometry", "length": 2147483647, "type": "esriFieldTypeGeometry" }, "copyrightText": "", "geometryType": "esriGeometryPolygon", "supportsLayerOverrides": true } ] }