superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 479
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8117 | 8117 | 8116 | {"type": "Polygon", "coordinates": [[[-121.31533, 38.1379], [-121.31453, 38.1379], [-121.31265, 38.13818], [-121.3118, 38.13818], [-121.3118, 38.13751], [-121.31172, 38.13691], [-121.31177, 38.13599], [-121.31174, 38.13545], [-121.31457, 38.13547], [-121.3149, 38.1357], [-121.3149, 38.13648], [-121.31532, 38.13649], [-121.31533, 38.1379]]]} | Open Access 1 | Peterson Park | 23634 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 20.992 | Peterson Park | ||
8889 | 8889 | 8888 | {"type": "Polygon", "coordinates": [[[-121.30242, 38.11911], [-121.30079, 38.11911], [-121.30077, 38.11707], [-121.3024, 38.1171], [-121.30242, 38.11911]]]} | Open Access 1 | Roget Park | 24563 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 7.924 | Roget Park | ||
9114 | 9114 | 9113 | {"type": "Polygon", "coordinates": [[[-121.27344, 38.10513], [-121.27328, 38.10722], [-121.27288, 38.10726], [-121.2721, 38.10742], [-121.27084, 38.10783], [-121.27025, 38.1079], [-121.26982, 38.10791], [-121.26976, 38.10786], [-121.2697, 38.10529], [-121.27344, 38.10513]]]} | Open Access 1 | Salas Park | 24793 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 20.789 | Salas Park | ||
10652 | 10652 | 10651 | {"type": "Polygon", "coordinates": [[[-121.27613, 38.14185], [-121.27582, 38.14186], [-121.27581, 38.14159], [-121.27561, 38.14145], [-121.27548, 38.14145], [-121.27547, 38.14104], [-121.27611, 38.14104], [-121.27613, 38.14185]]]} | Open Access 1 | Van Buskirk Park | 26823 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 0.98 | Van Buskirk Park | ||
10909 | 10909 | 10908 | {"type": "Polygon", "coordinates": [[[-121.29649, 38.12358], [-121.2965, 38.12379], [-121.29643, 38.12454], [-121.29644, 38.12491], [-121.2965, 38.12549], [-121.29648, 38.12584], [-121.29648, 38.12639], [-121.29536, 38.12638], [-121.29536, 38.126], [-121.29505, 38.12598], [-121.29506, 38.12422], [-121.29412, 38.12421], [-121.2941, 38.12452], [-121.29361, 38.12452], [-121.29353, 38.1241], [-121.29358, 38.12389], [-121.29364, 38.12379], [-121.29372, 38.1237], [-121.29392, 38.12357], [-121.29405, 38.12352], [-121.29418, 38.1235], [-121.29431, 38.12349], [-121.29485, 38.12349], [-121.29587, 38.12358], [-121.29649, 38.12358]]]} | Open Access 1 | Vinewood Park | 27132 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 12.073 | Vinewood Park | ||
13990 | 13990 | 13989 | {"type": "Polygon", "coordinates": [[[-121.25662, 38.12344], [-121.25174, 38.12328], [-121.25168, 38.12153], [-121.25165, 38.11979], [-121.25318, 38.11982], [-121.25354, 38.11987], [-121.25503, 38.12018], [-121.25497, 38.1228], [-121.25662, 38.12286], [-121.25662, 38.12344]]]} | No Public Access 3 | Pixley Park Basin | 32575 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 29.59 | Pixley Park Basin | ||
14248 | 14248 | 14247 | {"type": "Polygon", "coordinates": [[[-121.28039, 38.13556], [-121.2793, 38.13556], [-121.27928, 38.13486], [-121.28038, 38.13486], [-121.28039, 38.13556]]]} | Open Access 1 | Emerson Park | 18622 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1.841 | Emerson Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([MNG_AGENCY]) REFERENCES [MNG_AGENCY]([id]), FOREIGN KEY([MNG_AG_LEV]) REFERENCES [MNG_AG_LEV]([id]), FOREIGN KEY([MNG_AG_TYP]) REFERENCES [MNG_AG_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);