superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where MNG_AGENCY = 466 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2237 | 2237 | 2236 | {"type": "Polygon", "coordinates": [[[-121.98834, 37.82338], [-121.98797, 37.82358], [-121.98781, 37.82371], [-121.98767, 37.82384], [-121.98754, 37.82399], [-121.98744, 37.82414], [-121.98744, 37.82312], [-121.98772, 37.82326], [-121.98788, 37.82331], [-121.98804, 37.82335], [-121.98834, 37.82338]]]} | Open Access 1 | Bret Harte Park | 16365 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 0.87 | Bret Harte Park | 1988 | |
3437 | 3437 | 3436 | {"type": "Polygon", "coordinates": [[[-121.97946, 37.78878], [-121.97921, 37.78892], [-121.97907, 37.78894], [-121.97886, 37.78879], [-121.97875, 37.7888], [-121.97857, 37.78871], [-121.97847, 37.78851], [-121.97846, 37.78837], [-121.97883, 37.78806], [-121.97946, 37.78878]]]} | Open Access 1 | Danville South Park | 17923 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1.13 | Danville South Park | 1992 | |
3599 | 3599 | 3598 | {"type": "Polygon", "coordinates": [[[-121.92375, 37.78824], [-121.92371, 37.79157], [-121.92282, 37.79279], [-121.92257, 37.79317], [-121.92246, 37.79338], [-121.92238, 37.79339], [-121.92136, 37.79311], [-121.92102, 37.79304], [-121.92085, 37.79303], [-121.92051, 37.79305], [-121.92034, 37.79308], [-121.92004, 37.79317], [-121.91971, 37.79243], [-121.92063, 37.79058], [-121.92103, 37.79031], [-121.92183, 37.78958], [-121.92185, 37.78914], [-121.92215, 37.78874], [-121.92211, 37.78833], [-121.92375, 37.78824]]]} | Open Access 1 | Diablo Vista Park | 18136 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 31.88 | Diablo Vista Park | 1988 | |
4887 | 4887 | 4886 | {"type": "Polygon", "coordinates": [[[-122.02134, 37.84108], [-122.02082, 37.84183], [-122.02025, 37.8414], [-122.01901, 37.84036], [-122.0171, 37.83916], [-122.01664, 37.83898], [-122.01706, 37.83825], [-122.01706, 37.83823], [-122.01709, 37.83816], [-122.01709, 37.83805], [-122.01708, 37.83798], [-122.01692, 37.83774], [-122.01737, 37.83776], [-122.01798, 37.83769], [-122.01814, 37.83773], [-122.01834, 37.83784], [-122.01784, 37.83855], [-122.01828, 37.83875], [-122.01895, 37.83828], [-122.01909, 37.83843], [-122.01934, 37.83881], [-122.01908, 37.83933], [-122.01871, 37.83953], [-122.01879, 37.83988], [-122.01927, 37.8399], [-122.01984, 37.83961], [-122.02006, 37.83962], [-122.02022, 37.83958], [-122.02041, 37.83971], [-122.02067, 37.84021], [-122.0205, 37.84039], [-122.02047, 37.84071], [-122.02063, 37.8409], [-122.0208, 37.84101], [-122.02126, 37.84108], [-122.02134, 37.84108]]]} | Open Access 1 | Hap Magee Ranch | 19654 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 14.072 | Hap Magee Ranch | ||
7560 | 7560 | 7559 | {"type": "Polygon", "coordinates": [[[-121.98702, 37.84243], [-121.98682, 37.8427], [-121.98682, 37.84458], [-121.98515, 37.84459], [-121.98438, 37.84461], [-121.98427, 37.84188], [-121.98417, 37.83749], [-121.9868, 37.83743], [-121.98681, 37.84188], [-121.98674, 37.8419], [-121.98676, 37.84226], [-121.98682, 37.84239], [-121.98682, 37.84245], [-121.98702, 37.84243]]]} | Open Access 1 | Oak Hill Park | 22979 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 43.827 | Oak Hill Park | 1988 | |
7776 | 7776 | 7775 | {"type": "Polygon", "coordinates": [[[-121.98155, 37.80527], [-121.97896, 37.80538], [-121.9786, 37.80534], [-121.97827, 37.80535], [-121.97806, 37.80538], [-121.9774, 37.80533], [-121.97689, 37.80511], [-121.97665, 37.80346], [-121.97707, 37.80344], [-121.97708, 37.80338], [-121.97718, 37.80319], [-121.97732, 37.80305], [-121.97747, 37.80302], [-121.97789, 37.80301], [-121.97818, 37.80304], [-121.97876, 37.80274], [-121.97934, 37.8027], [-121.97927, 37.80133], [-121.98122, 37.80125], [-121.98133, 37.80333], [-121.98155, 37.80527]]]} | Open Access 1 | Osage Station Park | 23232 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 34.241 | Osage Station Park | 1988 | |
10192 | 10192 | 10191 | {"type": "Polygon", "coordinates": [[[-121.94839, 37.80697], [-121.94726, 37.80856], [-121.94826, 37.80902], [-121.94773, 37.80924], [-121.94754, 37.80949], [-121.94725, 37.80958], [-121.94687, 37.80964], [-121.94661, 37.8095], [-121.94631, 37.80916], [-121.94594, 37.80897], [-121.94559, 37.80886], [-121.94517, 37.80893], [-121.94466, 37.80909], [-121.94434, 37.80913], [-121.94383, 37.80895], [-121.9439, 37.80869], [-121.94437, 37.80802], [-121.94444, 37.80803], [-121.94523, 37.80687], [-121.94514, 37.80604], [-121.94551, 37.80552], [-121.94683, 37.80612], [-121.94687, 37.8061], [-121.94839, 37.80697]]]} | Open Access 1 | Sycamore Valley Park | 26143 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 24.674 | Sycamore Valley Park | 1990 |
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]);