superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 479 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5311 | 5311 | 5310 | {"type": "MultiPolygon", "coordinates": [[[[-121.28002, 38.13239], [-121.27962, 38.13241], [-121.27964, 38.13266], [-121.27969, 38.13285], [-121.27979, 38.13296], [-121.27991, 38.13302], [-121.2799, 38.13313], [-121.27925, 38.13313], [-121.27921, 38.13141], [-121.28, 38.13141], [-121.28002, 38.13239]]], [[[-121.28167, 38.13314], [-121.28085, 38.13314], [-121.28083, 38.13194], [-121.28164, 38.13193], [-121.28167, 38.13314]]]]} | Open Access 1 | Hutchins Street Square | 20162 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 5.089 | Hutchins Street Square | ||
7196 | 7196 | 7195 | {"type": "Polygon", "coordinates": [[[-121.25153, 38.03604], [-121.24923, 38.03607], [-121.24921, 38.03448], [-121.2512, 38.03445], [-121.25123, 38.03443], [-121.25152, 38.03443], [-121.25153, 38.03604]]]} | Open Access 1 | Morada Park | 22467 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 8.879 | Morada 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 | ||
6062 | 6062 | 6061 | {"type": "Polygon", "coordinates": [[[-121.26756, 38.13822], [-121.26754, 38.1385], [-121.26695, 38.13848], [-121.26691, 38.13898], [-121.26692, 38.13899], [-121.2675, 38.13902], [-121.2674, 38.14026], [-121.26555, 38.14022], [-121.26561, 38.14012], [-121.26566, 38.14002], [-121.26569, 38.13985], [-121.26564, 38.13829], [-121.26566, 38.13825], [-121.2657, 38.13823], [-121.2675, 38.13817], [-121.26754, 38.13818], [-121.26756, 38.13822]]]} | Open Access 1 | Lawrence Park | 21116 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 8.192 | Lawrence Park | ||
2157 | 2157 | 2156 | {"type": "Polygon", "coordinates": [[[-121.26771, 38.10396], [-121.26713, 38.10397], [-121.26712, 38.10319], [-121.26771, 38.10317], [-121.26771, 38.10396]]]} | Open Access 1 | Borchardt Park | 16278 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 1.102 | Borchardt Park | ||
2840 | 2840 | 2839 | {"type": "Polygon", "coordinates": [[[-121.26892, 38.13865], [-121.26891, 38.13878], [-121.2684, 38.13876], [-121.26838, 38.13877], [-121.26839, 38.13889], [-121.26889, 38.13892], [-121.26883, 38.14012], [-121.26876, 38.14019], [-121.26769, 38.14014], [-121.26781, 38.1386], [-121.26892, 38.13865]]]} | Open Access 1 | Chapman Field / Armory Park | 17132 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 3.988 | Chapman Field / Armory Park | ||
4840 | 4840 | 4839 | {"type": "Polygon", "coordinates": [[[-121.26919, 38.1353], [-121.26912, 38.13629], [-121.26801, 38.13624], [-121.26808, 38.13525], [-121.26919, 38.1353]]]} | Open Access 1 | Hale Park | 19602 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 2.645 | Hale Park | ||
2057 | 2057 | 2056 | {"type": "Polygon", "coordinates": [[[-121.26954, 38.12096], [-121.26951, 38.12101], [-121.26944, 38.12104], [-121.26755, 38.12114], [-121.2675, 38.12112], [-121.26748, 38.12109], [-121.26748, 38.11955], [-121.2675, 38.11952], [-121.26754, 38.1195], [-121.26939, 38.1194], [-121.26945, 38.1194], [-121.2695, 38.11944], [-121.26952, 38.11948], [-121.26954, 38.12096]]]} | Open Access 1 | Blakely Park | 16153 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 8.071 | Blakely Park | ||
5238 | 5238 | 5237 | {"type": "Polygon", "coordinates": [[[-121.27079, 38.14011], [-121.27066, 38.14193], [-121.26896, 38.14194], [-121.2691, 38.14025], [-121.26916, 38.1402], [-121.27041, 38.14019], [-121.27043, 38.1401], [-121.27079, 38.14011]]]} | Open Access 1 | Lodi Softball Complex | 21399 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 7.175 | Lodi Softball Complex | ||
6613 | 6613 | 6612 | {"type": "Polygon", "coordinates": [[[-121.27255, 38.12988], [-121.27252, 38.13025], [-121.27197, 38.13028], [-121.272, 38.12986], [-121.27255, 38.12988]]]} | Open Access 1 | Maple Square | 21783 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 0.523 | Maple Square | ||
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 | ||
2798 | 2798 | 2797 | {"type": "Polygon", "coordinates": [[[-121.27603, 38.10736], [-121.276, 38.1076], [-121.27399, 38.10768], [-121.27362, 38.10771], [-121.27364, 38.10719], [-121.27416, 38.10715], [-121.27486, 38.10719], [-121.27558, 38.10727], [-121.27603, 38.10736]]]} | Open Access 1 | Century Park | 17079 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 2.487 | Century 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 | ||
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 | ||
6084 | 6084 | 6083 | {"type": "Polygon", "coordinates": [[[-121.28061, 38.1243], [-121.27916, 38.1243], [-121.27915, 38.1226], [-121.27923, 38.12255], [-121.27943, 38.12259], [-121.27986, 38.12273], [-121.28014, 38.12277], [-121.2806, 38.12278], [-121.28061, 38.1243]]]} | Open Access 1 | Legion Park | 21141 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 5.583 | Legion Park | ||
4033 | 4033 | 4032 | {"type": "Polygon", "coordinates": [[[-121.28501, 38.10685], [-121.28445, 38.10686], [-121.28433, 38.1068], [-121.28356, 38.1068], [-121.2835, 38.10653], [-121.28339, 38.10629], [-121.28326, 38.10609], [-121.28361, 38.10592], [-121.28346, 38.10569], [-121.28331, 38.10558], [-121.28317, 38.10552], [-121.28316, 38.10536], [-121.28333, 38.10543], [-121.2837, 38.10552], [-121.28457, 38.10553], [-121.28457, 38.10582], [-121.28463, 38.10586], [-121.2846, 38.10591], [-121.28458, 38.10598], [-121.28458, 38.10638], [-121.28463, 38.10648], [-121.2846, 38.10651], [-121.2846, 38.10679], [-121.28501, 38.1068], [-121.28501, 38.10685]]]} | Open Access 1 | English Oaks Common | 18677 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 3.697 | English Oaks Common | ||
2583 | 2583 | 2582 | {"type": "Polygon", "coordinates": [[[-121.29007, 38.14173], [-121.29003, 38.14177], [-121.28995, 38.14192], [-121.2899, 38.14195], [-121.28943, 38.1418], [-121.2894, 38.14175], [-121.28941, 38.14173], [-121.29007, 38.14173]]]} | Open Access 1 | Candy Cane Park | 16801 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 0.212 | Candy Cane Park | ||
1887 | 1887 | 1886 | {"type": "Polygon", "coordinates": [[[-121.29053, 38.10816], [-121.28925, 38.10816], [-121.28872, 38.10812], [-121.28828, 38.10812], [-121.28822, 38.1081], [-121.2882, 38.10806], [-121.28819, 38.10742], [-121.28812, 38.10692], [-121.28795, 38.10643], [-121.28759, 38.10582], [-121.28759, 38.10578], [-121.28763, 38.10575], [-121.28782, 38.10569], [-121.28839, 38.10557], [-121.28897, 38.10552], [-121.28911, 38.10553], [-121.28928, 38.10558], [-121.28944, 38.10567], [-121.28956, 38.10568], [-121.28976, 38.10608], [-121.29045, 38.10607], [-121.29053, 38.10816]]]} | Open Access 1 | Beckman Park | 15946 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 14.26 | Beckman Park | ||
5770 | 5770 | 5769 | {"type": "Polygon", "coordinates": [[[-121.29088, 38.11928], [-121.29088, 38.11966], [-121.28831, 38.11967], [-121.28831, 38.1172], [-121.28934, 38.11719], [-121.28945, 38.1182], [-121.29071, 38.11819], [-121.29071, 38.11927], [-121.29088, 38.11928]]]} | Open Access 1 | Kofu Park | 20713 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 11.251 | Kofu Park | ||
2786 | 2786 | 2785 | {"type": "Polygon", "coordinates": [[[-121.29482, 38.10429], [-121.29393, 38.10425], [-121.29392, 38.103], [-121.2948, 38.10303], [-121.29482, 38.10429]]]} | Open Access 1 | Century Meadows Park | 17075 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 2.673 | Century Meadows 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]);