Skip to content

Instantly share code, notes, and snippets.

@ThomasG77

ThomasG77/README.md

Last active September 28, 2021 19:14
Show Gist options
  • Save ThomasG77/fd07ef0a2d384e024bd06675ca0615cc to your computer and use it in GitHub Desktop.
Save ThomasG77/fd07ef0a2d384e024bd06675ca0615cc to your computer and use it in GitHub Desktop.
Download ZIP
VRT Demo. Derived corners from building to get a CSV with xmin, xmax, ymin and ymax. The goal: create a polygon from these 4 coordinates using a VRT
Raw
README.md

VRT recipe for CSV

Goal

Show how to display from a VRT file, the bounding box using a CSV as an input. A reaction as a dynamic alternative to https://twitter.com/spatialthoughts/status/1442905558521053184

PS: No approach is better. It depends of requirements.

How to test

You can open in QGIS the file demo-sql-csv.vrt as a vector layer to see CSV layer with a polygon geometry created from xmin, xmax, ymin and ymax

You can also do with GDAL command line

ogrinfo -so -al demo-sql-csv.vrt

Comparison is possible with original buildings source building_before_bounding_box.geojson (CSV was created only for demo purpose)

Feel free to inspect the demo-sql-csv.vrt file content

Display the source blob
Display the rendered blob
Raw
building_before_bounding_box.geojson
{
"type": "FeatureCollection",
"generator": "overpass-ide",
"copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL.",
"timestamp": "2021-09-28T18:02:44Z",
"features": [
{
"type": "Feature",
"properties": {
"@id": "way/89766261",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419749,
47.1717733
],
[
-1.6418251,
47.1717577
],
[
-1.6418013,
47.1718465
],
[
-1.6417409,
47.1718385
],
[
-1.6417319,
47.1718654
],
[
-1.6419155,
47.171888
],
[
-1.6419309,
47.1718246
],
[
-1.6419228,
47.1718243
],
[
-1.6419306,
47.1717934
],
[
-1.6419486,
47.171796
],
[
-1.6419666,
47.1717987
],
[
-1.6419749,
47.1717733
]
]
]
},
"id": "way/89766261"
},
{
"type": "Feature",
"properties": {
"@id": "way/89766397",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6426088,
47.1721299
],
[
-1.642612,
47.1721301
],
[
-1.6427156,
47.1721426
],
[
-1.6427224,
47.1721191
],
[
-1.6427236,
47.1721144
],
[
-1.6426192,
47.172101
],
[
-1.6426088,
47.1721299
]
]
]
},
"id": "way/89766397"
},
{
"type": "Feature",
"properties": {
"@id": "way/89767283",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419507,
47.1719499
],
[
-1.6419425,
47.1719763
],
[
-1.6419621,
47.1719792
],
[
-1.6419703,
47.1719526
],
[
-1.6419507,
47.1719499
]
]
]
},
"id": "way/89767283"
},
{
"type": "Feature",
"properties": {
"@id": "way/89767436",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6425767,
47.1722252
],
[
-1.6425489,
47.1722214
],
[
-1.6424673,
47.1722111
],
[
-1.6424587,
47.1722414
],
[
-1.6424456,
47.1722395
],
[
-1.6424289,
47.1722977
],
[
-1.6424836,
47.172305
],
[
-1.6425522,
47.1723143
],
[
-1.6425767,
47.1722252
]
]
]
},
"id": "way/89767436"
},
{
"type": "Feature",
"properties": {
"@id": "way/89767802",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6414827,
47.1724426
],
[
-1.6414613,
47.1724933
],
[
-1.6414761,
47.1724964
],
[
-1.6414992,
47.1724463
],
[
-1.6414827,
47.1724426
]
]
]
},
"id": "way/89767802"
},
{
"type": "Feature",
"properties": {
"@id": "way/89768147",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6415499,
47.1716838
],
[
-1.6415279,
47.1716816
],
[
-1.6414879,
47.1716767
],
[
-1.6414817,
47.1717067
],
[
-1.6415428,
47.1717135
],
[
-1.6415499,
47.1716838
]
]
]
},
"id": "way/89768147"
},
{
"type": "Feature",
"properties": {
"@id": "way/89768294",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6423353,
47.1718156
],
[
-1.6424428,
47.1718274
],
[
-1.6424595,
47.17175
],
[
-1.6424665,
47.1717191
],
[
-1.6424811,
47.1717198
],
[
-1.642485,
47.1716998
],
[
-1.6423782,
47.171688
],
[
-1.6423653,
47.1716873
],
[
-1.6423564,
47.171688
],
[
-1.6423503,
47.171691
],
[
-1.6423482,
47.1716951
],
[
-1.6423375,
47.1717392
],
[
-1.642349,
47.1717412
],
[
-1.6423453,
47.1717549
],
[
-1.6423494,
47.1717554
],
[
-1.6423353,
47.1718156
]
]
]
},
"id": "way/89768294"
},
{
"type": "Feature",
"properties": {
"@id": "way/89769106",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6427117,
47.1718564
],
[
-1.6427768,
47.1718636
],
[
-1.6427942,
47.1717946
],
[
-1.6427852,
47.1717925
],
[
-1.6427924,
47.1717647
],
[
-1.6427084,
47.1717545
],
[
-1.6427007,
47.171786
],
[
-1.6427308,
47.1717894
],
[
-1.6427117,
47.1718564
]
]
]
},
"id": "way/89769106"
},
{
"type": "Feature",
"properties": {
"@id": "way/89769469",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6418251,
47.1717577
],
[
-1.6419749,
47.1717733
],
[
-1.6419788,
47.1717528
],
[
-1.6418309,
47.1717325
],
[
-1.6418251,
47.1717577
]
]
]
},
"id": "way/89769469"
},
{
"type": "Feature",
"properties": {
"@id": "way/89769603",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.642516,
47.17201
],
[
-1.6425152,
47.17201
],
[
-1.6424793,
47.1720054
],
[
-1.642405,
47.1719959
],
[
-1.6423765,
47.1720951
],
[
-1.6424876,
47.1721104
],
[
-1.642516,
47.17201
]
]
]
},
"id": "way/89769603"
},
{
"type": "Feature",
"properties": {
"@id": "way/89770277",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6413812,
47.171665
],
[
-1.6414097,
47.1716682
],
[
-1.6414725,
47.1716752
],
[
-1.6414855,
47.1716209
],
[
-1.6415553,
47.1716066
],
[
-1.6415251,
47.1715191
],
[
-1.6415346,
47.1715175
],
[
-1.6415173,
47.1714674
],
[
-1.6413956,
47.1714875
],
[
-1.6414398,
47.171615
],
[
-1.6413941,
47.1716097
],
[
-1.6413812,
47.171665
]
]
]
},
"id": "way/89770277"
},
{
"type": "Feature",
"properties": {
"@id": "way/89770416",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6425489,
47.1722214
],
[
-1.642568,
47.1721535
],
[
-1.6424391,
47.1721368
],
[
-1.6424305,
47.172168
],
[
-1.6424648,
47.1721728
],
[
-1.6424542,
47.1722091
],
[
-1.6424673,
47.1722111
],
[
-1.6425489,
47.1722214
]
]
]
},
"id": "way/89770416"
},
{
"type": "Feature",
"properties": {
"@id": "way/89770778",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6406462,
47.1724656
],
[
-1.6406408,
47.1725147
],
[
-1.6406904,
47.1725183
],
[
-1.6406973,
47.1724685
],
[
-1.6406462,
47.1724656
]
]
]
},
"id": "way/89770778"
},
{
"type": "Feature",
"properties": {
"@id": "way/89771085",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6414879,
47.1716767
],
[
-1.6414725,
47.1716752
],
[
-1.6414097,
47.1716682
],
[
-1.6414026,
47.1716978
],
[
-1.6414817,
47.1717067
],
[
-1.6414879,
47.1716767
]
]
]
},
"id": "way/89771085"
},
{
"type": "Feature",
"properties": {
"@id": "way/89771224",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6427176,
47.1716746
],
[
-1.6427304,
47.1716169
],
[
-1.6426579,
47.1716093
],
[
-1.6426461,
47.1716682
],
[
-1.6427176,
47.1716746
]
]
]
},
"id": "way/89771224"
},
{
"type": "Feature",
"properties": {
"@id": "way/89771275",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6424638,
47.1716141
],
[
-1.6424343,
47.1715157
],
[
-1.6423545,
47.1715263
],
[
-1.6423662,
47.171559
],
[
-1.642359,
47.1715602
],
[
-1.6423711,
47.1715965
],
[
-1.6423439,
47.1715994
],
[
-1.6423514,
47.1716304
],
[
-1.6424638,
47.1716141
]
]
]
},
"id": "way/89771275"
},
{
"type": "Feature",
"properties": {
"@id": "way/89771410",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6428073,
47.1725563
],
[
-1.6428319,
47.1725609
],
[
-1.6428867,
47.1725701
],
[
-1.6428839,
47.1725842
],
[
-1.6429584,
47.1725966
],
[
-1.6429644,
47.1725815
],
[
-1.6430305,
47.1726085
],
[
-1.643086,
47.1725321
],
[
-1.6430642,
47.1725231
],
[
-1.6430554,
47.1725333
],
[
-1.6430044,
47.1725125
],
[
-1.6429896,
47.1725282
],
[
-1.6429468,
47.1725096
],
[
-1.6429313,
47.1725074
],
[
-1.6429053,
47.1725054
],
[
-1.6428929,
47.1725019
],
[
-1.642856,
47.1724956
],
[
-1.6428457,
47.1725254
],
[
-1.6428189,
47.1725228
],
[
-1.6428073,
47.1725563
]
]
]
},
"id": "way/89771410"
},
{
"type": "Feature",
"properties": {
"@id": "way/89772447",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419615,
47.1724542
],
[
-1.6419772,
47.1723561
],
[
-1.6418797,
47.172349
],
[
-1.6418639,
47.1724461
],
[
-1.6419615,
47.1724542
]
]
]
},
"id": "way/89772447"
},
{
"type": "Feature",
"properties": {
"@id": "way/89772623",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.642841,
47.1720262
],
[
-1.6428534,
47.1719827
],
[
-1.6426925,
47.1719604
],
[
-1.6426794,
47.1720055
],
[
-1.642841,
47.1720262
]
]
]
},
"id": "way/89772623"
},
{
"type": "Feature",
"properties": {
"@id": "way/89773353",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6415611,
47.1713676
],
[
-1.6416004,
47.1713645
],
[
-1.6415953,
47.1713335
],
[
-1.641556,
47.1713363
],
[
-1.6415611,
47.1713676
]
]
]
},
"id": "way/89773353"
},
{
"type": "Feature",
"properties": {
"@id": "way/89773497",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6427224,
47.1721191
],
[
-1.6427156,
47.1721426
],
[
-1.6427694,
47.1721491
],
[
-1.6427747,
47.172126
],
[
-1.6427224,
47.1721191
]
]
]
},
"id": "way/89773497"
},
{
"type": "Feature",
"properties": {
"@id": "way/89773873",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6413267,
47.1725689
],
[
-1.6414228,
47.1725885
],
[
-1.6414277,
47.1725896
],
[
-1.6414371,
47.1725672
],
[
-1.6414435,
47.172567
],
[
-1.6414761,
47.1724964
],
[
-1.6414613,
47.1724933
],
[
-1.6414827,
47.1724426
],
[
-1.6413858,
47.1724227
],
[
-1.6413356,
47.1724121
],
[
-1.6413106,
47.1724678
],
[
-1.6413162,
47.172476
],
[
-1.6413581,
47.1724845
],
[
-1.6413309,
47.1725431
],
[
-1.6413384,
47.1725456
],
[
-1.6413267,
47.1725689
]
]
]
},
"id": "way/89773873"
},
{
"type": "Feature",
"properties": {
"@id": "way/89774190",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6414026,
47.1716978
],
[
-1.6414097,
47.1716682
],
[
-1.6413812,
47.171665
],
[
-1.6413839,
47.1716955
],
[
-1.6414026,
47.1716978
]
]
]
},
"id": "way/89774190"
},
{
"type": "Feature",
"properties": {
"@id": "way/89774328",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6423705,
47.1719605
],
[
-1.6423812,
47.1719168
],
[
-1.6423865,
47.171894
],
[
-1.6423694,
47.1718928
],
[
-1.6423633,
47.1719147
],
[
-1.6423517,
47.1719582
],
[
-1.6423705,
47.1719605
]
]
]
},
"id": "way/89774328"
},
{
"type": "Feature",
"properties": {
"@id": "way/89774380",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6426871,
47.1714718
],
[
-1.642793,
47.1714836
],
[
-1.6428008,
47.1714526
],
[
-1.6427217,
47.1714438
],
[
-1.6426949,
47.1714408
],
[
-1.6426871,
47.1714718
]
]
]
},
"id": "way/89774380"
},
{
"type": "Feature",
"properties": {
"@id": "way/89774525",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.642452,
47.1726378
],
[
-1.6425009,
47.1725691
],
[
-1.6424319,
47.1725456
],
[
-1.6424369,
47.1725379
],
[
-1.6423929,
47.1725246
],
[
-1.6423992,
47.1725129
],
[
-1.6423635,
47.1725016
],
[
-1.6423348,
47.1725433
],
[
-1.6423688,
47.1725534
],
[
-1.6423582,
47.1725711
],
[
-1.6423986,
47.1725896
],
[
-1.6423901,
47.1726038
],
[
-1.6423902,
47.1726041
],
[
-1.642452,
47.1726378
]
]
]
},
"id": "way/89774525"
},
{
"type": "Feature",
"properties": {
"@id": "way/89774703",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419602,
47.1719199
],
[
-1.6418552,
47.171909
],
[
-1.6418415,
47.1719556
],
[
-1.641808,
47.1719511
],
[
-1.6417875,
47.1720221
],
[
-1.6419239,
47.172041
],
[
-1.6419339,
47.1720072
],
[
-1.6419535,
47.1720098
],
[
-1.6419621,
47.1719792
],
[
-1.6419425,
47.1719763
],
[
-1.6419507,
47.1719499
],
[
-1.6419602,
47.1719199
]
]
]
},
"id": "way/89774703"
},
{
"type": "Feature",
"properties": {
"@id": "way/89775507",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6415909,
47.1724246
],
[
-1.6416112,
47.1723793
],
[
-1.6414936,
47.1723544
],
[
-1.6414717,
47.1723989
],
[
-1.6415909,
47.1724246
]
]
]
},
"id": "way/89775507"
},
{
"type": "Feature",
"properties": {
"@id": "way/89775641",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6427084,
47.1719586
],
[
-1.642839,
47.1719752
],
[
-1.6428455,
47.1719484
],
[
-1.6427164,
47.1719295
],
[
-1.6427084,
47.1719586
]
]
]
},
"id": "way/89775641"
},
{
"type": "Feature",
"properties": {
"@id": "way/89776730",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6424595,
47.17175
],
[
-1.6424428,
47.1718274
],
[
-1.6424909,
47.1718325
],
[
-1.6425044,
47.171793
],
[
-1.6425124,
47.171755
],
[
-1.6424595,
47.17175
]
]
]
},
"id": "way/89776730"
},
{
"type": "Feature",
"properties": {
"@id": "way/89777248",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6426674,
47.1725076
],
[
-1.6426788,
47.1724898
],
[
-1.642528,
47.1724542
],
[
-1.6425191,
47.1724724
],
[
-1.6426674,
47.1725076
]
]
]
},
"id": "way/89777248"
},
{
"type": "Feature",
"properties": {
"@id": "way/89777424",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419108,
47.1714815
],
[
-1.6418138,
47.1714703
],
[
-1.6417986,
47.1715284
],
[
-1.6417285,
47.1715198
],
[
-1.6417118,
47.1715876
],
[
-1.6418912,
47.1716085
],
[
-1.6418982,
47.1715779
],
[
-1.6418876,
47.1715768
],
[
-1.6419108,
47.1714815
]
]
]
},
"id": "way/89777424"
},
{
"type": "Feature",
"properties": {
"@id": "way/89777560",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6425153,
47.1718714
],
[
-1.642379,
47.1718541
],
[
-1.6423694,
47.1718928
],
[
-1.6423865,
47.171894
],
[
-1.6423812,
47.1719168
],
[
-1.6423705,
47.1719605
],
[
-1.6423517,
47.1719582
],
[
-1.642343,
47.1719876
],
[
-1.642405,
47.1719959
],
[
-1.6424793,
47.1720054
],
[
-1.6424995,
47.1719318
],
[
-1.6425153,
47.1718714
]
]
]
},
"id": "way/89777560"
},
{
"type": "Feature",
"properties": {
"@id": "way/89777610",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6425677,
47.1714265
],
[
-1.6424683,
47.1714154
],
[
-1.6424605,
47.1714463
],
[
-1.6425599,
47.1714574
],
[
-1.6425677,
47.1714265
]
]
]
},
"id": "way/89777610"
},
{
"type": "Feature",
"properties": {
"@id": "way/89777917",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419486,
47.171796
],
[
-1.6419306,
47.1717934
],
[
-1.6419228,
47.1718243
],
[
-1.6419309,
47.1718246
],
[
-1.6419424,
47.1718269
],
[
-1.6419486,
47.171796
]
]
]
},
"id": "way/89777917"
},
{
"type": "Feature",
"properties": {
"@id": "way/89778742",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6419273,
47.1722651
],
[
-1.6419381,
47.1722322
],
[
-1.6419194,
47.1722295
],
[
-1.6419525,
47.172119
],
[
-1.6418978,
47.172112
],
[
-1.6419078,
47.1720779
],
[
-1.6417951,
47.1720632
],
[
-1.6417935,
47.172063
],
[
-1.6417911,
47.1720631
],
[
-1.6417887,
47.1720635
],
[
-1.6417855,
47.1720642
],
[
-1.641784,
47.1720649
],
[
-1.6417824,
47.1720656
],
[
-1.6417809,
47.1720669
],
[
-1.6417787,
47.1720685
],
[
-1.641778,
47.1720698
],
[
-1.6417773,
47.1720717
],
[
-1.6417699,
47.1720983
],
[
-1.6418337,
47.1721078
],
[
-1.6418082,
47.1721858
],
[
-1.6417632,
47.1721789
],
[
-1.6417449,
47.1722375
],
[
-1.6419273,
47.1722651
]
]
]
},
"id": "way/89778742"
},
{
"type": "Feature",
"properties": {
"@id": "way/89778881",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6424836,
47.172305
],
[
-1.6424289,
47.1722977
],
[
-1.6423309,
47.1722843
],
[
-1.6423207,
47.1723166
],
[
-1.6423314,
47.172318
],
[
-1.6423493,
47.1723204
],
[
-1.6423432,
47.1723429
],
[
-1.6423244,
47.1723405
],
[
-1.6423003,
47.1724247
],
[
-1.6423959,
47.1724474
],
[
-1.6424003,
47.172433
],
[
-1.6424436,
47.172439
],
[
-1.6424836,
47.172305
]
]
]
},
"id": "way/89778881"
},
{
"type": "Feature",
"properties": {
"@id": "way/89779609",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6420043,
47.1725106
],
[
-1.6420781,
47.172533
],
[
-1.6420797,
47.1725332
],
[
-1.6420884,
47.1725035
],
[
-1.6420597,
47.1724972
],
[
-1.6420651,
47.1724853
],
[
-1.6420239,
47.1724755
],
[
-1.6420043,
47.1725106
]
]
]
},
"id": "way/89779609"
},
{
"type": "Feature",
"properties": {
"@id": "way/89780059",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6423453,
47.1717549
],
[
-1.642349,
47.1717412
],
[
-1.6423375,
47.1717392
],
[
-1.6423339,
47.1717529
],
[
-1.6423453,
47.1717549
]
]
]
},
"id": "way/89780059"
},
{
"type": "Feature",
"properties": {
"@id": "way/89780574",
"building": "yes",
"source": "extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010",
"wall": "no"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6423314,
47.172318
],
[
-1.6423244,
47.1723405
],
[
-1.6423432,
47.1723429
],
[
-1.6423493,
47.1723204
],
[
-1.6423314,
47.172318
]
]
]
},
"id": "way/89780574"
},
{
"type": "Feature",
"properties": {
"@id": "way/89780910",
"building": "yes",
"source": "cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6424909,
47.1718325
],
[
-1.6425894,
47.1718431
],
[
-1.6426013,
47.1718033
],
[
-1.6425044,
47.171793
],
[
-1.6424909,
47.1718325
]
]
]
},
"id": "way/89780910"
},
{
"type": "Feature",
"properties": {
"@id": "way/966720842",
"building": "house"
},
"geometry": {
"type": "Polygon",
"coordinates": [
[
[
-1.6429409,
47.1716729
],
[
-1.6429721,
47.1715535
],
[
-1.6428546,
47.1715393
],
[
-1.6428474,
47.1715667
],
[
-1.6428339,
47.1715651
],
[
-1.6428099,
47.1716571
],
[
-1.6429409,
47.1716729
]
]
]
},
"id": "way/966720842"
}
]
}
Raw
demo-sql-csv.vrt
<OGRVRTDataSource>
<OGRVRTLayer name="bbox_from_csv_coords">
<SrcDataSource relativeToVRT="1">demo_bounding_box_vrt.csv</SrcDataSource>
<SrcSQL dialect="SQlite">SELECT *, ST_PolygonFromText('POLYGON((' || xmin || ' ' || ymin || ',' || xmin || ' ' || ymax ||',' || xmax || ' ' || ymax || ',' || xmax || ' ' || ymin || ',' || xmin || ' ' || ymin || '))', 4326) AS geometry FROM demo_bounding_box_vrt</SrcSQL>
</OGRVRTLayer>
</OGRVRTDataSource>
Raw
demo_bounding_box_vrt.csv
id @id building source wall xmin ymin xmax ymax
way/89766261 way/89766261 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419749 47.1717577 -1.6417319 47.171888
way/89766397 way/89766397 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6427236 47.172101 -1.6426088 47.1721426
way/89767283 way/89767283 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6419703 47.1719499 -1.6419425 47.1719792
way/89767436 way/89767436 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6425767 47.1722111 -1.6424289 47.1723143
way/89767802 way/89767802 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6414992 47.1724426 -1.6414613 47.1724964
way/89768147 way/89768147 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6415499 47.1716767 -1.6414817 47.1717135
way/89768294 way/89768294 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.642485 47.1716873 -1.6423353 47.1718274
way/89769106 way/89769106 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6427942 47.1717545 -1.6427007 47.1718636
way/89769469 way/89769469 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419788 47.1717325 -1.6418251 47.1717733
way/89769603 way/89769603 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.642516 47.1719959 -1.6423765 47.1721104
way/89770277 way/89770277 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6415553 47.1714674 -1.6413812 47.1716752
way/89770416 way/89770416 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.642568 47.1721368 -1.6424305 47.1722214
way/89770778 way/89770778 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6406973 47.1724656 -1.6406408 47.1725183
way/89771085 way/89771085 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6414879 47.1716682 -1.6414026 47.1717067
way/89771224 way/89771224 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6427304 47.1716093 -1.6426461 47.1716746
way/89771275 way/89771275 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6424638 47.1715157 -1.6423439 47.1716304
way/89771410 way/89771410 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.643086 47.1724956 -1.6428073 47.1726085
way/89772447 way/89772447 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419772 47.172349 -1.6418639 47.1724542
way/89772623 way/89772623 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6428534 47.1719604 -1.6426794 47.1720262
way/89773353 way/89773353 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6416004 47.1713335 -1.641556 47.1713676
way/89773497 way/89773497 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6427747 47.1721191 -1.6427156 47.1721491
way/89773873 way/89773873 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6414827 47.1724121 -1.6413106 47.1725896
way/89774190 way/89774190 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6414097 47.171665 -1.6413812 47.1716978
way/89774328 way/89774328 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6423865 47.1718928 -1.6423517 47.1719605
way/89774380 way/89774380 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6428008 47.1714408 -1.6426871 47.1714836
way/89774525 way/89774525 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6425009 47.1725016 -1.6423348 47.1726378
way/89774703 way/89774703 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419621 47.171909 -1.6417875 47.172041
way/89775507 way/89775507 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6416112 47.1723544 -1.6414717 47.1724246
way/89775641 way/89775641 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6428455 47.1719295 -1.6427084 47.1719752
way/89776730 way/89776730 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6425124 47.17175 -1.6424428 47.1718325
way/89777248 way/89777248 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6426788 47.1724542 -1.6425191 47.1725076
way/89777424 way/89777424 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419108 47.1714703 -1.6417118 47.1716085
way/89777560 way/89777560 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6425153 47.1718541 -1.642343 47.1720054
way/89777610 way/89777610 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6425677 47.1714154 -1.6424605 47.1714574
way/89777917 way/89777917 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6419486 47.1717934 -1.6419228 47.1718269
way/89778742 way/89778742 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6419525 47.172063 -1.6417449 47.1722651
way/89778881 way/89778881 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6424836 47.1722843 -1.6423003 47.1724474
way/89779609 way/89779609 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6420884 47.1724755 -1.6420043 47.1725332
way/89780059 way/89780059 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.642349 47.1717392 -1.6423339 47.1717549
way/89780574 way/89780574 yes extraction vectorielle v1 cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 no -1.6423493 47.172318 -1.6423244 47.1723429
way/89780910 way/89780910 yes cadastre-dgi-fr source : Direction Générale des Impôts - Cadas. Mise à jour : 2010 -1.6426013 47.171793 -1.6424909 47.1718431
way/966720842 way/966720842 house -1.6429721 47.1715393 -1.6428099 47.1716729
Raw
demo_bounding_box_vrt.csvt
String,String,String,String,String,Real,Real,Real,Real
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment