{ "cells": [ { "cell_type": "markdown", "metadata": { "id": "Y0IPjMQvr_2h" }, "source": [ "## Filtering a Data Observatory dataset using \"Who's On First\" in CARTOFrames" ] }, { "cell_type": "markdown", "metadata": { "id": "VOVRcqXNrnUu" }, "source": [ "This notebook illustrates how to use the admin. region geometries from Who's on First (public data) to filter a dataset from CARTO's [Data Observatory](https://carto.com/spatial-data-catalog/) using [CARTOFrames](https://carto.com/cartoframes/) methods.\n", "\n", "The notebook is organized as follows:\n", "0. Setup account\n", "1. Access a dataset from a Data Observatory subscription to be filtered\n", "2. Who's on First for filtering data in cities\n", "\n", "**Documentation**\n", "- CARTO Spatial Data Catalogue - [link](https://carto.com/spatial-data-catalog/browser/)\n", "- CARTOFrames technical documentation - [link](https://carto.com/developers/cartoframes/)\n", "- \"Who's on First\" GeoJSON data product - [link](https://carto.com/spatial-data-catalog/browser/geography/wof_geojson_4e78587c/data)" ] }, { "cell_type": "markdown", "metadata": { "id": "nN8F02lPsOBU" }, "source": [ "### 0. Setup" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "id": "bZcjZ3X3sUMr" }, "outputs": [], "source": [ "import geopandas as gpd\n", "import pandas as pd\n", "\n", "from cartoframes.auth import set_default_credentials\n", "from cartoframes.data.observatory import *\n", "from cartoframes.viz import *\n", "\n", "pd.set_option('display.max_columns', None)" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "id": "n02GAhWlsXbM" }, "outputs": [], "source": [ "set_default_credentials('creds.json')" ] }, { "cell_type": "markdown", "metadata": { "id": "gdNCauTQtarh" }, "source": [ "### 1. Access a dataset from a Data Observatory subscription to be filtered" ] }, { "cell_type": "markdown", "metadata": { "id": "GRlKWu8xAfGX" }, "source": [ "First, we check our data subscriptions from the Data Observatory to select which dataset we want to filter." ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 1000 }, "id": "JI7RCXrnAsNc", "outputId": "9d409e6c-00c3-48cc-afab-f3afc7563fcd" }, "outputs": [ { "data": { "text/html": [ "
\n", " | slug | \n", "name | \n", "description | \n", "category_id | \n", "country_id | \n", "data_source_id | \n", "provider_id | \n", "geography_name | \n", "geography_description | \n", "temporal_aggregation | \n", "time_coverage | \n", "update_frequency | \n", "is_public_data | \n", "lang | \n", "version | \n", "category_name | \n", "provider_name | \n", "geography_id | \n", "id | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "ags_sociodemogr_a7e14220 | \n", "Sociodemographics - United States of America (... | \n", "Census and ACS sociodemographic data estimated... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "ags | \n", "Census Block Group - United States of America | \n", "None | \n", "yearly | \n", "None | \n", "None | \n", "False | \n", "eng | \n", "2020 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do.ags.geography_usa_blockgroup_2015 | \n", "carto-do.ags.demographics_sociodemographics_us... | \n", "
1 | \n", "ags_retailpoten_aaf25a8c | \n", "Retail Potential - United States of America (C... | \n", "The retail potential database consists of aver... | \n", "demographics | \n", "usa | \n", "retailpotential | \n", "ags | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "yearly | \n", "[2018-01-01, 2019-01-01) | \n", "None | \n", "False | \n", "eng | \n", "2019 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.ags.demographics_retailpotential_usa_... | \n", "
2 | \n", "pb_consumer_po_62cddc04 | \n", "Points Of Interest - Consumer - United States ... | \n", "Consumer Point of interest database per catego... | \n", "points_of_interest | \n", "usa | \n", "consumer_points_of_interest | \n", "pitney_bowes | \n", "Latitude/Longitude - United States of America | \n", "Location of Points of Interest | \n", "monthly | \n", "None | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Points of Interest | \n", "Pitney Bowes | \n", "carto-do.pitney_bowes.geography_usa_latlon_v1 | \n", "carto-do.pitney_bowes.pointsofinterest_consume... | \n", "
3 | \n", "ags_sociodemogr_f510a947 | \n", "Sociodemographics - United States of America (... | \n", "Census and ACS sociodemographic data estimated... | \n", "demographics | \n", "usa | \n", "sociodemographics | \n", "ags | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "yearly | \n", "[2019-01-01, 2020-01-01) | \n", "None | \n", "False | \n", "eng | \n", "2019 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.ags.demographics_sociodemographics_us... | \n", "
4 | \n", "ags_consumer_sp_dbabddfb | \n", "Consumer Spending - United States of America (... | \n", "The Consumer Expenditure database consists of ... | \n", "demographics | \n", "usa | \n", "consumer_spending | \n", "ags | \n", "Census Block Group - United States of America | \n", "None | \n", "yearly | \n", "None | \n", "None | \n", "False | \n", "eng | \n", "2020 | \n", "Demographics | \n", "Applied Geographic Solutions | \n", "carto-do.ags.geography_usa_blockgroup_2015 | \n", "carto-do.ags.demographics_consumerspending_usa... | \n", "
5 | \n", "spa_geosocial_s_d5dc42ae | \n", "Geosocial Segments - United States of America ... | \n", "By analysing feeds from Twitter, Instagram, Me... | \n", "behavioral | \n", "usa | \n", "geosocial_segments | \n", "spatial_ai | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "quarterly | \n", "[2020-01-01, 2020-04-01) | \n", "quarterly | \n", "False | \n", "eng | \n", "v1 | \n", "Behavioral | \n", "Spatial.ai | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.spatial_ai.behavioral_geosocialsegmen... | \n", "
6 | \n", "mc_geographic__7980c5c3 | \n", "Geographic Insights - United States of America... | \n", "Geographic Insights validate, evaluate and ben... | \n", "financial | \n", "usa | \n", "geographic_insights | \n", "mastercard | \n", "Census Block Group - United States of America ... | \n", "Shoreline clipped TIGER/Line boundaries. More ... | \n", "monthly | \n", "[2019-01-01, 2020-01-01) | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Financial | \n", "Mastercard | \n", "carto-do-public-data.carto.geography_usa_block... | \n", "carto-do.mastercard.financial_geographicinsigh... | \n", "
7 | \n", "pb_points_of_i_94bda91b | \n", "Points Of Interest - Spain (Latitude/Longitude) | \n", "Point of interest database per categories | \n", "points_of_interest | \n", "esp | \n", "points_of_interest | \n", "pitney_bowes | \n", "Latitude/Longitude - Spain | \n", "Location of Points of Interest | \n", "monthly | \n", "None | \n", "monthly | \n", "False | \n", "eng | \n", "v1 | \n", "Points of Interest | \n", "Pitney Bowes | \n", "carto-do.pitney_bowes.geography_esp_latlon_v1 | \n", "carto-do.pitney_bowes.pointsofinterest_pointso... | \n", "
8 | \n", "u360_sociodemogr_28e93b81 | \n", "Sociodemographics - Spain (Grid 100m) | \n", "Curation of socio-demographic and socio-econom... | \n", "demographics | \n", "esp | \n", "sociodemographics | \n", "unica360 | \n", "Grid 100m | \n", "100x100m grid | \n", "yearly | \n", "None | \n", "None | \n", "False | \n", "eng | \n", "2019 | \n", "Demographics | \n", "Unica360 | \n", "carto-do.unica360.geography_esp_grid100x100m_2019 | \n", "carto-do.unica360.demographics_sociodemographi... | \n", "
\n", " | male | \n", "geoid | \n", "female | \n", "retail | \n", "leisure | \n", "tourism | \n", "education | \n", "financial | \n", "food_drink | \n", "healthcare | \n", "population | \n", "country_iso | \n", "male_1_to_4 | \n", "male_5_to_9 | \n", "male_under_1 | \n", "female_1_to_4 | \n", "female_5_to_9 | \n", "male_10_to_14 | \n", "male_15_to_19 | \n", "male_20_to_24 | \n", "male_25_to_29 | \n", "male_30_to_34 | \n", "male_35_to_39 | \n", "male_40_to_44 | \n", "male_45_to_49 | \n", "male_50_to_54 | \n", "male_55_to_59 | \n", "male_60_to_64 | \n", "male_65_to_69 | \n", "male_70_to_74 | \n", "male_75_to_79 | \n", "country_iso_a3 | \n", "female_under_1 | \n", "transportation | \n", "female_10_to_14 | \n", "female_15_to_19 | \n", "female_20_to_24 | \n", "female_25_to_29 | \n", "female_30_to_34 | \n", "female_35_to_39 | \n", "female_40_to_44 | \n", "female_45_to_49 | \n", "female_50_to_54 | \n", "female_55_to_59 | \n", "female_60_to_64 | \n", "female_65_to_69 | \n", "female_70_to_74 | \n", "female_75_to_79 | \n", "male_80_and_over | \n", "female_80_and_over | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "3157.484307 | \n", "031332122022031 | \n", "3314.603374 | \n", "202 | \n", "2 | \n", "30 | \n", "3 | \n", "20 | \n", "217 | \n", "17 | \n", "6987.135426 | \n", "Spain | \n", "120.913153 | \n", "163.556262 | \n", "30.859980 | \n", "112.445169 | \n", "152.122509 | \n", "179.977780 | \n", "169.691305 | \n", "162.016885 | \n", "168.189652 | \n", "180.966714 | \n", "220.835550 | \n", "269.261748 | \n", "263.299398 | \n", "248.028995 | \n", "227.292451 | \n", "196.722677 | \n", "161.299894 | \n", "142.868832 | \n", "105.937552 | \n", "ESP | \n", "28.693915 | \n", "62 | \n", "169.153640 | \n", "158.909087 | \n", "153.972406 | \n", "164.477591 | \n", "177.747316 | \n", "219.014149 | \n", "267.756015 | \n", "268.073208 | \n", "256.767236 | \n", "237.604333 | \n", "208.339251 | \n", "177.525427 | \n", "167.336132 | \n", "139.422190 | \n", "145.765479 | \n", "255.243802 | \n", "
1 | \n", "3100.709744 | \n", "031333212123113 | \n", "3112.707666 | \n", "397 | \n", "7 | \n", "18 | \n", "13 | \n", "29 | \n", "227 | \n", "41 | \n", "6213.417445 | \n", "Spain | \n", "116.135321 | \n", "156.329847 | \n", "29.640561 | \n", "107.896359 | \n", "146.732161 | \n", "171.439127 | \n", "162.141215 | \n", "156.255203 | \n", "163.785669 | \n", "177.375590 | \n", "216.347498 | \n", "264.268170 | \n", "258.871424 | \n", "245.878540 | \n", "227.791271 | \n", "199.504164 | \n", "161.553366 | \n", "141.963759 | \n", "104.895240 | \n", "ESP | \n", "27.533142 | \n", "115 | \n", "163.738535 | \n", "153.326000 | \n", "147.104910 | \n", "155.585855 | \n", "167.001699 | \n", "205.922699 | \n", "251.286604 | \n", "251.263774 | \n", "238.742479 | \n", "218.524946 | \n", "189.368642 | \n", "163.730100 | \n", "155.843235 | \n", "130.658199 | \n", "146.533779 | \n", "238.448327 | \n", "
2 | \n", "5563.234994 | \n", "031333330303331 | \n", "5634.263423 | \n", "267 | \n", "5 | \n", "33 | \n", "10 | \n", "32 | \n", "230 | \n", "39 | \n", "11197.498466 | \n", "Spain | \n", "207.438940 | \n", "282.454383 | \n", "52.943473 | \n", "196.299369 | \n", "263.708241 | \n", "310.187053 | \n", "294.944600 | \n", "277.136621 | \n", "291.315402 | \n", "318.226120 | \n", "392.201611 | \n", "481.832879 | \n", "471.522448 | \n", "446.028405 | \n", "404.935209 | \n", "345.842258 | \n", "282.652461 | \n", "251.291441 | \n", "187.960022 | \n", "ESP | \n", "50.091947 | \n", "124 | \n", "293.852755 | \n", "273.574052 | \n", "269.563257 | \n", "284.239360 | \n", "302.392749 | \n", "368.791786 | \n", "447.273132 | \n", "447.816753 | \n", "427.330467 | \n", "399.392763 | \n", "354.964127 | \n", "303.556543 | \n", "285.400862 | \n", "236.542165 | \n", "264.321666 | \n", "429.473098 | \n", "
3 | \n", "5752.487674 | \n", "033121230020013 | \n", "5897.919277 | \n", "392 | \n", "9 | \n", "19 | \n", "22 | \n", "41 | \n", "239 | \n", "46 | \n", "13530.062792 | \n", "Spain | \n", "214.959833 | \n", "292.499451 | \n", "54.862983 | \n", "205.108661 | \n", "275.753969 | \n", "323.571403 | \n", "298.909093 | \n", "289.252283 | \n", "296.326437 | \n", "318.596845 | \n", "400.574748 | \n", "495.122733 | \n", "488.513948 | \n", "459.693972 | \n", "418.807097 | \n", "358.926419 | \n", "296.731579 | \n", "266.983096 | \n", "198.371388 | \n", "ESP | \n", "52.339912 | \n", "54 | \n", "304.900184 | \n", "292.604586 | \n", "279.560116 | \n", "302.507961 | \n", "327.124385 | \n", "391.198812 | \n", "471.563116 | \n", "468.010031 | \n", "448.989864 | \n", "418.053752 | \n", "370.225668 | \n", "313.187995 | \n", "291.416965 | \n", "243.300764 | \n", "279.784366 | \n", "442.072536 | \n", "
4 | \n", "4920.401140 | \n", "033110331211321 | \n", "5101.838268 | \n", "386 | \n", "12 | \n", "24 | \n", "11 | \n", "17 | \n", "240 | \n", "38 | \n", "10022.239175 | \n", "Spain | \n", "185.931533 | \n", "251.828674 | \n", "47.454258 | \n", "175.431490 | \n", "237.010205 | \n", "277.479072 | \n", "262.715527 | \n", "251.839640 | \n", "260.796087 | \n", "279.359516 | \n", "345.971107 | \n", "422.165983 | \n", "413.846829 | \n", "389.538337 | \n", "356.188780 | \n", "306.779508 | \n", "250.842350 | \n", "222.981889 | \n", "164.327410 | \n", "ESP | \n", "44.766853 | \n", "49 | \n", "263.162347 | \n", "246.132949 | \n", "237.480096 | \n", "254.350030 | \n", "276.120897 | \n", "335.150496 | \n", "409.423620 | \n", "409.001029 | \n", "392.155128 | \n", "363.719101 | \n", "320.472125 | \n", "273.839742 | \n", "257.380644 | \n", "215.620176 | \n", "230.354640 | \n", "390.621340 | \n", "
5 | \n", "10488.067253 | \n", "120222233002302 | \n", "10980.102434 | \n", "206 | \n", "5 | \n", "39 | \n", "9 | \n", "19 | \n", "240 | \n", "29 | \n", "21468.169211 | \n", "Spain | \n", "399.577618 | \n", "543.086551 | \n", "101.981938 | \n", "374.481191 | \n", "504.032327 | \n", "597.000008 | \n", "565.179574 | \n", "533.200418 | \n", "543.255342 | \n", "585.150797 | \n", "735.436253 | \n", "911.480321 | \n", "896.233391 | \n", "834.498850 | \n", "751.953428 | \n", "646.956267 | \n", "529.950073 | \n", "474.194427 | \n", "357.228428 | \n", "ESP | \n", "95.560624 | \n", "172 | \n", "561.082684 | \n", "524.800891 | \n", "514.948448 | \n", "560.215039 | \n", "604.717769 | \n", "723.562416 | \n", "869.828768 | \n", "866.350490 | \n", "839.930112 | \n", "790.127512 | \n", "696.650138 | \n", "593.946884 | \n", "554.767677 | \n", "456.639502 | \n", "481.703569 | \n", "848.459962 | \n", "
6 | \n", "10691.776215 | \n", "120222233002303 | \n", "11193.368209 | \n", "144 | \n", "6 | \n", "44 | \n", "13 | \n", "30 | \n", "240 | \n", "40 | \n", "21885.144834 | \n", "Spain | \n", "407.338614 | \n", "553.634872 | \n", "103.962726 | \n", "381.754702 | \n", "513.822090 | \n", "608.595502 | \n", "576.157012 | \n", "543.556738 | \n", "553.806953 | \n", "596.516153 | \n", "749.720600 | \n", "929.183921 | \n", "913.640858 | \n", "850.707247 | \n", "766.558575 | \n", "659.522022 | \n", "540.243248 | \n", "483.404662 | \n", "364.166840 | \n", "ESP | \n", "97.416694 | \n", "193 | \n", "571.980562 | \n", "534.994066 | \n", "524.950252 | \n", "571.096036 | \n", "616.463167 | \n", "737.616141 | \n", "886.723386 | \n", "883.177559 | \n", "856.244038 | \n", "805.474094 | \n", "710.181137 | \n", "605.483075 | \n", "565.542897 | \n", "465.508790 | \n", "491.059674 | \n", "864.939521 | \n", "
7 | \n", "7046.002774 | \n", "033111012101130 | \n", "7718.364580 | \n", "575 | \n", "12 | \n", "81 | \n", "38 | \n", "25 | \n", "501 | \n", "48 | \n", "14764.367519 | \n", "Spain | \n", "273.552370 | \n", "370.482714 | \n", "69.817227 | \n", "258.793396 | \n", "349.655445 | \n", "408.169877 | \n", "384.237815 | \n", "361.315362 | \n", "370.977625 | \n", "400.892505 | \n", "496.398761 | \n", "607.745009 | \n", "596.215580 | \n", "555.359332 | \n", "500.855984 | \n", "426.264436 | \n", "351.705464 | \n", "316.607648 | \n", "235.482475 | \n", "ESP | \n", "66.039259 | \n", "151 | \n", "388.281731 | \n", "365.377672 | \n", "359.531128 | \n", "387.915307 | \n", "417.419276 | \n", "507.002730 | \n", "617.319966 | \n", "615.971377 | \n", "596.200625 | \n", "559.683816 | \n", "497.777880 | \n", "421.235484 | \n", "391.043486 | \n", "324.241345 | \n", "319.922590 | \n", "594.874658 | \n", "
8 | \n", "4880.515167 | \n", "033111230333220 | \n", "5060.481569 | \n", "234 | \n", "5 | \n", "60 | \n", "4 | \n", "17 | \n", "247 | \n", "15 | \n", "9940.996620 | \n", "Spain | \n", "184.424333 | \n", "249.787283 | \n", "47.069582 | \n", "174.009405 | \n", "235.088947 | \n", "275.229765 | \n", "260.585895 | \n", "249.798178 | \n", "258.682006 | \n", "277.094953 | \n", "343.166571 | \n", "418.743808 | \n", "410.492089 | \n", "386.380638 | \n", "353.301415 | \n", "304.292676 | \n", "248.808967 | \n", "221.174350 | \n", "162.995328 | \n", "ESP | \n", "44.403963 | \n", "79 | \n", "261.029094 | \n", "244.137743 | \n", "235.555022 | \n", "252.288204 | \n", "273.882590 | \n", "332.433680 | \n", "406.104742 | \n", "405.685562 | \n", "388.976229 | \n", "360.770708 | \n", "317.874315 | \n", "271.619926 | \n", "255.294256 | \n", "213.872313 | \n", "228.487330 | \n", "387.454870 | \n", "
9 | \n", "6940.973733 | \n", "031333033310323 | \n", "7317.757894 | \n", "320 | \n", "15 | \n", "21 | \n", "1 | \n", "36 | \n", "251 | \n", "33 | \n", "14258.731450 | \n", "Spain | \n", "264.518769 | \n", "357.406697 | \n", "67.511636 | \n", "249.595717 | \n", "338.068831 | \n", "394.396529 | \n", "372.588657 | \n", "354.263577 | \n", "365.453562 | \n", "393.743390 | \n", "489.236870 | \n", "600.947986 | \n", "590.391082 | \n", "546.894724 | \n", "499.339633 | \n", "430.833752 | \n", "355.374173 | \n", "313.106841 | \n", "232.581040 | \n", "ESP | \n", "63.692182 | \n", "110 | \n", "374.778970 | \n", "351.354713 | \n", "341.896086 | \n", "367.449503 | \n", "396.543658 | \n", "479.801048 | \n", "582.162156 | \n", "580.282089 | \n", "565.227739 | \n", "524.879842 | \n", "461.562910 | \n", "391.095832 | \n", "370.309326 | \n", "307.973901 | \n", "312.384817 | \n", "571.083390 | \n", "
\n", " | slug | \n", "name | \n", "description | \n", "country_id | \n", "provider_id | \n", "geom_type | \n", "geom_coverage | \n", "update_frequency | \n", "is_public_data | \n", "lang | \n", "version | \n", "provider_name | \n", "id | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "wof_ancestors_eaaeac75 | \n", "Ancestors - Global | \n", "A normalized view of the hierarchies in 'geojs... | \n", "glo | \n", "whos_on_first | \n", "MULTIPLE | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20190520 | \n", "Who's On First | \n", "carto-do-public-data.whos_on_first.geography_g... | \n", "
1 | \n", "wof_concordance_392f80ad | \n", "Concordances - Global | \n", "Relationship between Who's On First identifier... | \n", "glo | \n", "whos_on_first | \n", "MULTIPLE | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20190520 | \n", "Who's On First | \n", "carto-do-public-data.whos_on_first.geography_g... | \n", "
2 | \n", "wof_geojson_4e78587c | \n", "GeoJSON - Global | \n", "The main table in Who's On First. Holds all th... | \n", "glo | \n", "whos_on_first | \n", "MULTIPLE | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20190520 | \n", "Who's On First | \n", "carto-do-public-data.whos_on_first.geography_g... | \n", "
3 | \n", "wof_names_5a30fa98 | \n", "Names - Global | \n", "What things are called in Who's On First. A no... | \n", "glo | \n", "whos_on_first | \n", "MULTIPLE | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20190520 | \n", "Who's On First | \n", "carto-do-public-data.whos_on_first.geography_g... | \n", "
4 | \n", "wof_spr_850ad7e9 | \n", "Standard Places Response - Global | \n", "The \"Standard Places Response\" (or SPR) is an ... | \n", "glo | \n", "whos_on_first | \n", "MULTIPLE | \n", "None | \n", "None | \n", "True | \n", "eng | \n", "20190520 | \n", "Who's On First | \n", "carto-do-public-data.whos_on_first.geography_g... | \n", "
\n", " | geoid | \n", "id | \n", "body | \n", "name | \n", "country | \n", "parent_id | \n", "is_current | \n", "placetype | \n", "geometry_type | \n", "bbox | \n", "geom | \n", "lastmodified | \n", "lastmodified_timestamp | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "404338863 | \n", "404338863 | \n", "{\"id\": 404338863, \"type\": \"Feature\", \"properti... | \n", "Madrid | \n", "ES | \n", "85682783 | \n", "0 | \n", "localadmin | \n", "Polygon | \n", "POLYGON((-3.51823494 40.31206394, -3.51823494 ... | \n", "POLYGON ((-3.88558 40.57446, -3.88560 40.57442... | \n", "1513267506 | \n", "2017-12-14 16:05:06+00:00 | \n", "
1 | \n", "101748283 | \n", "101748283 | \n", "{\"id\": 101748283, \"type\": \"Feature\", \"properti... | \n", "Madrid | \n", "ES | \n", "85682783 | \n", "1 | \n", "locality | \n", "MultiPolygon | \n", "POLYGON((-3.5180508952556 40.312064309035, -3.... | \n", "POLYGON ((-3.77456 40.40031, -3.77456 40.40026... | \n", "1536881193 | \n", "2018-09-13 23:26:33+00:00 | \n", "
2 | \n", "85682783 | \n", "85682783 | \n", "{\"id\": 85682783, \"type\": \"Feature\", \"propertie... | \n", "Madrid | \n", "ES | \n", "404227387 | \n", "1 | \n", "region | \n", "MultiPolygon | \n", "POLYGON((-3.05298331 39.88471951, -3.05298331 ... | \n", "MULTIPOLYGON (((-4.31951 40.64764, -4.31873 40... | \n", "1553814873 | \n", "2019-03-28 23:14:33+00:00 | \n", "
\n", " | geoid | \n", "do_date | \n", "country_iso | \n", "country_iso_a3 | \n", "population | \n", "female | \n", "male | \n", "female_under_1 | \n", "female_1_to_4 | \n", "female_5_to_9 | \n", "female_10_to_14 | \n", "female_15_to_19 | \n", "female_20_to_24 | \n", "female_25_to_29 | \n", "female_30_to_34 | \n", "female_35_to_39 | \n", "female_40_to_44 | \n", "female_45_to_49 | \n", "female_50_to_54 | \n", "female_55_to_59 | \n", "female_60_to_64 | \n", "female_65_to_69 | \n", "female_70_to_74 | \n", "female_75_to_79 | \n", "female_80_and_over | \n", "male_under_1 | \n", "male_1_to_4 | \n", "male_5_to_9 | \n", "male_10_to_14 | \n", "male_15_to_19 | \n", "male_20_to_24 | \n", "male_25_to_29 | \n", "male_30_to_34 | \n", "male_35_to_39 | \n", "male_40_to_44 | \n", "male_45_to_49 | \n", "male_50_to_54 | \n", "male_55_to_59 | \n", "male_60_to_64 | \n", "male_65_to_69 | \n", "male_70_to_74 | \n", "male_75_to_79 | \n", "male_80_and_over | \n", "retail | \n", "education | \n", "financial | \n", "food_drink | \n", "healthcare | \n", "leisure | \n", "tourism | \n", "transportation | \n", "geom | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "33111012103312 | \n", "2020-01-01 | \n", "Spain | \n", "ESP | \n", "9337.627117 | \n", "4881.428819 | \n", "4456.198031 | \n", "41.766095 | \n", "163.672177 | \n", "221.137283 | \n", "245.566234 | \n", "231.080698 | \n", "227.383101 | \n", "245.334472 | \n", "263.994076 | \n", "320.650538 | \n", "390.419935 | \n", "389.567041 | \n", "377.063165 | \n", "353.968339 | \n", "314.816339 | \n", "266.407605 | \n", "247.312870 | \n", "205.064303 | \n", "376.224547 | \n", "44.155446 | \n", "173.006394 | \n", "234.309353 | \n", "258.144348 | \n", "243.008669 | \n", "228.511522 | \n", "234.622352 | \n", "253.541816 | \n", "313.944129 | \n", "384.364319 | \n", "377.072623 | \n", "351.233350 | \n", "316.763072 | \n", "269.588137 | \n", "222.433800 | \n", "200.236423 | \n", "148.929341 | \n", "202.332936 | \n", "3 | \n", "0 | \n", "0 | \n", "1 | \n", "0 | \n", "0 | \n", "0 | \n", "10 | \n", "POLYGON ((-3.70239 40.32980, -3.70239 40.33817... | \n", "
1 | \n", "33111012112020 | \n", "2020-01-01 | \n", "Spain | \n", "ESP | \n", "12524.983924 | \n", "6547.682718 | \n", "5977.301260 | \n", "56.022764 | \n", "219.540946 | \n", "296.621506 | \n", "329.389162 | \n", "309.959063 | \n", "304.999293 | \n", "329.078293 | \n", "354.107280 | \n", "430.103163 | \n", "523.688038 | \n", "522.544012 | \n", "505.771966 | \n", "474.793871 | \n", "422.277495 | \n", "357.344649 | \n", "331.732017 | \n", "275.062080 | \n", "504.647118 | \n", "59.227708 | \n", "232.061352 | \n", "314.289800 | \n", "346.260753 | \n", "325.958592 | \n", "306.512897 | \n", "314.709633 | \n", "340.087184 | \n", "421.107543 | \n", "515.565376 | \n", "505.784677 | \n", "471.125289 | \n", "424.888722 | \n", "361.610845 | \n", "298.360577 | \n", "268.586231 | \n", "199.765704 | \n", "271.398376 | \n", "4 | \n", "6 | \n", "3 | \n", "10 | \n", "6 | \n", "18 | \n", "0 | \n", "73 | \n", "POLYGON ((-3.68042 40.35492, -3.68042 40.36329... | \n", "
2 | \n", "33111010323312 | \n", "2020-01-01 | \n", "Spain | \n", "ESP | \n", "12421.076833 | \n", "6493.363030 | \n", "5927.713505 | \n", "55.557999 | \n", "217.719627 | \n", "294.160728 | \n", "326.656544 | \n", "307.387631 | \n", "302.469019 | \n", "326.348264 | \n", "351.169585 | \n", "426.535027 | \n", "519.343525 | \n", "518.208965 | \n", "501.576084 | \n", "470.854971 | \n", "418.774260 | \n", "354.380114 | \n", "328.979961 | \n", "272.780164 | \n", "500.460560 | \n", "58.736354 | \n", "230.136176 | \n", "311.682449 | \n", "343.388167 | \n", "323.254432 | \n", "303.970064 | \n", "312.098805 | \n", "337.265824 | \n", "417.614041 | \n", "511.288227 | \n", "501.588670 | \n", "467.216838 | \n", "421.363837 | \n", "358.610911 | \n", "295.885376 | \n", "266.358035 | \n", "198.108446 | \n", "269.146852 | \n", "27 | \n", "2 | \n", "0 | \n", "31 | \n", "8 | \n", "9 | \n", "4 | \n", "36 | \n", "POLYGON ((-3.70239 40.46367, -3.70239 40.47202... | \n", "
3 | \n", "33111010330212 | \n", "2020-01-01 | \n", "Spain | \n", "ESP | \n", "2254.660193 | \n", "1178.668140 | \n", "1075.992060 | \n", "10.084827 | \n", "39.520229 | \n", "53.395733 | \n", "59.294337 | \n", "55.796666 | \n", "54.903846 | \n", "59.238377 | \n", "63.743920 | \n", "77.424168 | \n", "94.270665 | \n", "94.064726 | \n", "91.045543 | \n", "85.469076 | \n", "76.015445 | \n", "64.326690 | \n", "59.716083 | \n", "49.514756 | \n", "90.843051 | \n", "10.661759 | \n", "41.774066 | \n", "56.576256 | \n", "62.331445 | \n", "58.676793 | \n", "55.176313 | \n", "56.651833 | \n", "61.220123 | \n", "75.804843 | \n", "92.808480 | \n", "91.047825 | \n", "84.808686 | \n", "76.485502 | \n", "65.094659 | \n", "53.708791 | \n", "48.349018 | \n", "35.960428 | \n", "48.855241 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "0 | \n", "POLYGON ((-3.65845 40.53050, -3.65845 40.53885... | \n", "
4 | \n", "33111012101110 | \n", "2020-01-01 | \n", "Spain | \n", "ESP | \n", "15010.814752 | \n", "7847.199883 | \n", "7163.615039 | \n", "67.141591 | \n", "263.113193 | \n", "355.491909 | \n", "394.762959 | \n", "371.476565 | \n", "365.532447 | \n", "394.390390 | \n", "424.386867 | \n", "515.465653 | \n", "627.624291 | \n", "626.253203 | \n", "606.152427 | \n", "569.026092 | \n", "506.086817 | \n", "428.266773 | \n", "397.570788 | \n", "329.653602 | \n", "604.804319 | \n", "70.982620 | \n", "278.118529 | \n", "376.666836 | \n", "414.983067 | \n", "390.651518 | \n", "367.346454 | \n", "377.170004 | \n", "407.584217 | \n", "504.684685 | \n", "617.889516 | \n", "606.167654 | \n", "564.629409 | \n", "509.216307 | \n", "433.379674 | \n", "357.576148 | \n", "321.892486 | \n", "239.413157 | \n", "325.262757 | \n", "83 | \n", "7 | \n", "31 | \n", "61 | \n", "26 | \n", "4 | \n", "3 | \n", "97 | \n", "POLYGON ((-3.70239 40.43859, -3.70239 40.44695... | \n", "