superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
27 rows where MNG_AGENCY = 479 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
5664 | 5664 | 5663 | {"type": "Polygon", "coordinates": [[[-121.3102, 38.14663], [-121.31017, 38.14668], [-121.30987, 38.14672], [-121.30872, 38.14672], [-121.30864, 38.14674], [-121.30858, 38.14677], [-121.30851, 38.14672], [-121.30813, 38.14672], [-121.30812, 38.14569], [-121.30826, 38.14571], [-121.30987, 38.14573], [-121.30988, 38.14576], [-121.30991, 38.14576], [-121.30996, 38.14581], [-121.30998, 38.14581], [-121.31005, 38.14627], [-121.31011, 38.14644], [-121.3102, 38.14663]]]} | Open Access 1 | Katzakian Park | 20560 | 1180 | Lodi, City of 479 | City 2 | City Agency 2 | http://www.lodi.gov/PRCS/index.html | City 2 | 4.67 | Katzakian Park | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 |
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]);