superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 474 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2001 | 2001 | 2000 | {"type": "Polygon", "coordinates": [[[-117.81414, 35.18511], [-117.8133, 35.18514], [-117.81245, 35.18517], [-117.81249, 35.18479], [-117.8133, 35.18474], [-117.81414, 35.18472], [-117.81414, 35.18511]]]} | Open Access 1 | California City holding 9 | 16713 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1.631 | California City holding 9 | ||
2500 | 2500 | 2499 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18507], [-117.81414, 35.18511], [-117.81414, 35.18472], [-117.81583, 35.18469], [-117.81584, 35.18507]]]} | Open Access 1 | California City holding 4 | 16708 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1.64 | California City holding 4 | ||
2501 | 2501 | 2500 | {"type": "Polygon", "coordinates": [[[-117.65941, 35.24431], [-117.65836, 35.24432], [-117.65836, 35.24364], [-117.65828, 35.24315], [-117.65816, 35.24293], [-117.65919, 35.24387], [-117.65941, 35.24431]]]} | Open Access 1 | California City holding 5 | 16709 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 1.923 | California City holding 5 | ||
2492 | 2492 | 2491 | {"type": "Polygon", "coordinates": [[[-117.81414, 35.18511], [-117.81411, 35.18564], [-117.81244, 35.18568], [-117.81245, 35.18517], [-117.81414, 35.18511]]]} | Open Access 1 | California City holding 24 | 16705 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.2 | California City holding 24 | ||
2502 | 2502 | 2501 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18507], [-117.81584, 35.18562], [-117.81412, 35.18564], [-117.81414, 35.18511], [-117.81584, 35.18507]]]} | Open Access 1 | California City holding 6 | 16710 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.314 | California City holding 6 | ||
1775 | 1775 | 1774 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18562], [-117.81582, 35.18618], [-117.8141, 35.18621], [-117.81412, 35.18564], [-117.81584, 35.18562]]]} | Open Access 1 | California City holding 16 | 16696 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.424 | California City holding 16 | ||
2488 | 2488 | 2487 | {"type": "Polygon", "coordinates": [[[-117.81411, 35.18564], [-117.8141, 35.18621], [-117.81221, 35.18625], [-117.8123, 35.18612], [-117.81239, 35.18589], [-117.81244, 35.18568], [-117.81411, 35.18564]]]} | Open Access 1 | California City holding 21 | 16702 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.484 | California City holding 21 | ||
2515 | 2515 | 2514 | {"type": "Polygon", "coordinates": [[[-117.81267, 35.18624], [-117.81266, 35.18731], [-117.81188, 35.18733], [-117.81167, 35.1873], [-117.8115, 35.18723], [-117.81141, 35.18718], [-117.81134, 35.1871], [-117.81197, 35.18652], [-117.8121, 35.1864], [-117.81221, 35.18625], [-117.81267, 35.18624]]]} | Open Access 1 | California City holding 2 | 16700 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.492 | California City holding 2 | ||
2511 | 2511 | 2510 | {"type": "Polygon", "coordinates": [[[-117.81361, 35.18622], [-117.81361, 35.18722], [-117.81319, 35.1873], [-117.81266, 35.18731], [-117.81267, 35.18624], [-117.81361, 35.18622]]]} | Open Access 1 | California City holding 18 | 16698 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.509 | California City holding 18 | ||
2503 | 2503 | 2502 | {"type": "Polygon", "coordinates": [[[-117.82688, 35.25347], [-117.82591, 35.25347], [-117.8261, 35.25307], [-117.82615, 35.25189], [-117.82627, 35.25163], [-117.82674, 35.25113], [-117.82685, 35.25106], [-117.82688, 35.25347]]]} | Open Access 1 | California City holding 1 | 16689 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 3.93 | California City holding 1 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.66564, 35.18745], [-117.66446, 35.18721], [-117.66334, 35.1867], [-117.66264, 35.18668], [-117.66149, 35.18644], [-117.66562, 35.18641], [-117.66564, 35.18745]]]} | Open Access 1 | California City holding 12 | 16692 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 4.986 | California City holding 12 | ||
2453 | 2453 | 2452 | {"type": "Polygon", "coordinates": [[[-117.81583, 35.18705], [-117.81579, 35.18708], [-117.8141, 35.18711], [-117.81361, 35.18722], [-117.81362, 35.18622], [-117.81582, 35.18618], [-117.81583, 35.18705]]]} | Open Access 1 | California City holding 8 | 16712 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 5.053 | California City holding 8 | ||
2512 | 2512 | 2511 | {"type": "Polygon", "coordinates": [[[-117.66562, 35.18641], [-117.66149, 35.18644], [-117.65978, 35.18627], [-117.65981, 35.18583], [-117.66561, 35.18594], [-117.66562, 35.18641]]]} | Open Access 1 | California City holding 19 | 16699 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 7.556 | California City holding 19 | ||
2518 | 2518 | 2517 | {"type": "Polygon", "coordinates": [[[-117.92768, 35.13802], [-117.92733, 35.1383], [-117.92725, 35.13823], [-117.92712, 35.13817], [-117.92695, 35.13813], [-117.92678, 35.13814], [-117.92677, 35.13795], [-117.92672, 35.13781], [-117.92654, 35.13763], [-117.92649, 35.1376], [-117.92638, 35.13756], [-117.92629, 35.13755], [-117.92619, 35.13756], [-117.92606, 35.13764], [-117.92596, 35.13774], [-117.92597, 35.1378], [-117.92601, 35.13782], [-117.92609, 35.13779], [-117.92611, 35.13772], [-117.92625, 35.13764], [-117.92635, 35.13764], [-117.92645, 35.13768], [-117.9266, 35.13781], [-117.92668, 35.13796], [-117.92668, 35.13803], [-117.92664, 35.13816], [-117.92653, 35.13827], [-117.92658, 35.13834], [-117.92669, 35.13826], [-117.92681, 35.13822], [-117.92694, 35.13822], [-117.92702, 35.13822], [-117.92711, 35.13826], [-117.92719, 35.1383], [-117.92725, 35.13837], [-117.92592, 35.13947], [-117.92459, 35.13832], [-117.92635, 35.13688], [-117.92768, 35.13802]]]} | Open Access 1 | California City Memorial Park | 16714 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 9.382 | California City Memorial Park | ||
2491 | 2491 | 2490 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25105], [-117.8258, 35.25117], [-117.82507, 35.25133], [-117.82381, 35.25191], [-117.82367, 35.25201], [-117.82363, 35.25017], [-117.82683, 35.25021], [-117.82685, 35.25105]]]} | Open Access 1 | California City holding 23 | 16704 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 9.537 | California City holding 23 | ||
2499 | 2499 | 2498 | {"type": "Polygon", "coordinates": [[[-117.81407, 35.17705], [-117.81403, 35.17719], [-117.81401, 35.17749], [-117.8139, 35.17769], [-117.81378, 35.1778], [-117.81366, 35.17787], [-117.81152, 35.17873], [-117.81123, 35.17822], [-117.81103, 35.17804], [-117.81085, 35.17757], [-117.81119, 35.17745], [-117.81157, 35.17728], [-117.81204, 35.17699], [-117.81239, 35.17673], [-117.8128, 35.1763], [-117.81407, 35.17705]]]} | Open Access 1 | California City holding 3 | 16707 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 10.295 | California City holding 3 | ||
2498 | 2498 | 2497 | {"type": "Polygon", "coordinates": [[[-117.81556, 35.1739], [-117.81451, 35.17651], [-117.81437, 35.17662], [-117.81426, 35.17673], [-117.8141, 35.17698], [-117.81407, 35.17705], [-117.8128, 35.1763], [-117.81303, 35.176], [-117.81314, 35.17583], [-117.81333, 35.17545], [-117.81389, 35.17413], [-117.8141, 35.17383], [-117.81423, 35.17373], [-117.81444, 35.1736], [-117.81469, 35.17352], [-117.81494, 35.17348], [-117.81529, 35.17347], [-117.8153, 35.1739], [-117.81556, 35.1739]]]} | Open Access 1 | California City holding 25 | 16706 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 12.328 | California City holding 25 | ||
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25106], [-117.82674, 35.25113], [-117.82627, 35.25162], [-117.82616, 35.25189], [-117.8261, 35.25307], [-117.82591, 35.25347], [-117.82372, 35.25348], [-117.82367, 35.25201], [-117.82381, 35.25191], [-117.82507, 35.25133], [-117.82579, 35.25117], [-117.82685, 35.25106]]]} | Open Access 1 | California City holding 22 | 16703 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 12.684 | California City holding 22 | ||
1739 | 1739 | 1738 | {"type": "Polygon", "coordinates": [[[-118.00113, 35.13116], [-118.00109, 35.13151], [-118.00065, 35.13151], [-118.00029, 35.13147], [-117.99982, 35.13137], [-117.99964, 35.13132], [-117.9993, 35.13118], [-117.99892, 35.13098], [-117.9979, 35.1303], [-117.9976, 35.13013], [-117.99721, 35.12997], [-117.99715, 35.12993], [-117.99671, 35.12983], [-117.99674, 35.1294], [-117.99688, 35.12935], [-117.99695, 35.12927], [-117.99699, 35.12919], [-117.99699, 35.12904], [-117.9971, 35.12863], [-117.99725, 35.12864], [-117.99772, 35.12875], [-117.99799, 35.12884], [-117.9985, 35.12905], [-117.99884, 35.12924], [-118.00029, 35.13017], [-118.00048, 35.13025], [-118.00093, 35.13035], [-118.00096, 35.13084], [-118.00094, 35.13094], [-118.00095, 35.13102], [-118.00106, 35.13113], [-118.00113, 35.13116]]]} | Open Access 1 | Balsitis Park | 15791 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 15.002 | Balsitis Park | ||
2508 | 2508 | 2507 | {"type": "Polygon", "coordinates": [[[-117.80335, 35.17567], [-117.80287, 35.17721], [-117.80288, 35.17729], [-117.80266, 35.17732], [-117.80235, 35.17739], [-117.79993, 35.17807], [-117.79977, 35.17642], [-117.79942, 35.17626], [-117.79986, 35.1756], [-117.80077, 35.176], [-117.80113, 35.17576], [-117.80117, 35.17569], [-117.80335, 35.17567]]]} | Open Access 1 | California City holding 14 | 16694 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 15.96 | California City holding 14 |
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]);