superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 512 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
643 | 643 | 642 | {"type": "Polygon", "coordinates": [[[-120.83479, 37.08983], [-120.83269, 37.08984], [-120.83279, 37.08797], [-120.83477, 37.08796], [-120.83479, 37.08983]]]} | Open Access 1 | Ag Sports Complex | 15283 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 9.304 | Ag Sports Complex | ||
1423 | 1423 | 1422 | {"type": "Polygon", "coordinates": [[[-120.86852, 37.05834], [-120.8685, 37.05835], [-120.86824, 37.05832], [-120.86805, 37.05827], [-120.8679, 37.05819], [-120.86778, 37.05804], [-120.86758, 37.05772], [-120.86761, 37.05771], [-120.86852, 37.05834]]]} | Open Access 1 | Airport Park | 15303 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.388 | Airport Park | ||
2004 | 2004 | 2003 | {"type": "Polygon", "coordinates": [[[-120.86345, 37.06099], [-120.86343, 37.06202], [-120.86271, 37.06203], [-120.86293, 37.06176], [-120.86305, 37.06159], [-120.86338, 37.06099], [-120.86345, 37.06099]]]} | Open Access 1 | Big Page Park | 16084 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.92 | Big Page Park | ||
2711 | 2711 | 2710 | {"type": "Polygon", "coordinates": [[[-120.85118, 37.05874], [-120.85101, 37.05897], [-120.85058, 37.05878], [-120.85048, 37.05889], [-120.85003, 37.05869], [-120.85107, 37.05869], [-120.85118, 37.05874]]]} | Open Access 1 | Catholic Park | 16978 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.409 | Catholic Park | ||
2961 | 2961 | 2960 | {"type": "Polygon", "coordinates": [[[-120.84921, 37.07125], [-120.84921, 37.07145], [-120.84882, 37.07145], [-120.84882, 37.07131], [-120.84901, 37.0713], [-120.84921, 37.07125]]]} | Open Access 1 | Citrus Terrace Park I | 17286 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.154 | Citrus Terrace Park I | ||
2962 | 2962 | 2961 | {"type": "Polygon", "coordinates": [[[-120.8521, 37.07214], [-120.85209, 37.0729], [-120.85185, 37.0729], [-120.85119, 37.07263], [-120.85117, 37.07269], [-120.85052, 37.07269], [-120.85053, 37.07214], [-120.8521, 37.07214]]]} | Open Access 1 | Citrus Terrace Park II | 17287 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 2.352 | Citrus Terrace Park II | ||
9244 | 9244 | 9243 | {"type": "Polygon", "coordinates": [[[-120.84063, 37.06299], [-120.84063, 37.06299], [-120.84003, 37.06386], [-120.84005, 37.06273], [-120.84063, 37.06299]]]} | Open Access 1 | City Park | 33695 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.805 | City Park | ||
3090 | 3090 | 3089 | {"type": "Polygon", "coordinates": [[[-120.83251, 37.0478], [-120.8325, 37.04919], [-120.83102, 37.0492], [-120.83096, 37.04915], [-120.83095, 37.04844], [-120.83092, 37.04831], [-120.83088, 37.04825], [-120.83085, 37.04816], [-120.8313, 37.04813], [-120.83133, 37.04778], [-120.83251, 37.0478]]]} | Open Access 1 | College Green Park | 17503 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 5.009 | College Green Park | ||
3114 | 3114 | 3113 | {"type": "Polygon", "coordinates": [[[-120.8676, 37.06527], [-120.86648, 37.06525], [-120.86652, 37.06449], [-120.86575, 37.06447], [-120.8658, 37.06262], [-120.86597, 37.06263], [-120.86669, 37.0628], [-120.86684, 37.06288], [-120.86699, 37.06321], [-120.86707, 37.06356], [-120.86716, 37.06357], [-120.86716, 37.0645], [-120.86744, 37.06472], [-120.86757, 37.06493], [-120.8676, 37.06527]]]} | Open Access 1 | Colorado Ball Park | 17541 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 7.363 | Colorado Ball Park | ||
3323 | 3323 | 3322 | {"type": "Polygon", "coordinates": [[[-120.84713, 37.04245], [-120.84713, 37.04345], [-120.84567, 37.04345], [-120.84567, 37.04249], [-120.84573, 37.04244], [-120.84713, 37.04245]]]} | Open Access 1 | Cresthills Park | 17807 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 3.568 | Cresthills Park | ||
3460 | 3460 | 3459 | {"type": "Polygon", "coordinates": [[[-120.83791, 37.07101], [-120.8379, 37.0712], [-120.83756, 37.07144], [-120.83712, 37.07102], [-120.8372, 37.07098], [-120.83724, 37.0709], [-120.83757, 37.07092], [-120.83791, 37.07101]]]} | Open Access 1 | Davis Park | 17952 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.618 | Davis Park | ||
4492 | 4492 | 4491 | {"type": "Polygon", "coordinates": [[[-120.86689, 37.05334], [-120.8667, 37.05372], [-120.86651, 37.05366], [-120.86618, 37.05375], [-120.86598, 37.0537], [-120.86624, 37.05316], [-120.86655, 37.05326], [-120.86657, 37.05324], [-120.86689, 37.05334]]]} | Open Access 1 | Gardens Park I | 19206 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.817 | Gardens Park I | ||
4493 | 4493 | 4492 | {"type": "Polygon", "coordinates": [[[-120.86874, 37.05209], [-120.86844, 37.05234], [-120.86842, 37.05229], [-120.86827, 37.05216], [-120.8681, 37.05227], [-120.86796, 37.05215], [-120.86814, 37.05202], [-120.86814, 37.05168], [-120.8685, 37.05176], [-120.86848, 37.05186], [-120.86852, 37.05196], [-120.8686, 37.05203], [-120.86874, 37.05209]]]} | Open Access 1 | Gardens Park III | 19207 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.603 | Gardens Park III | ||
4494 | 4494 | 4493 | {"type": "Polygon", "coordinates": [[[-120.86434, 37.05547], [-120.86298, 37.0554], [-120.86298, 37.05515], [-120.86305, 37.05514], [-120.86311, 37.05509], [-120.86314, 37.05503], [-120.86312, 37.05497], [-120.86142, 37.05281], [-120.86144, 37.05275], [-120.86219, 37.05249], [-120.86201, 37.05197], [-120.86178, 37.05147], [-120.86136, 37.0508], [-120.86102, 37.05034], [-120.86092, 37.05016], [-120.8608, 37.04986], [-120.86075, 37.04956], [-120.86161, 37.04955], [-120.86176, 37.0498], [-120.86179, 37.0501], [-120.86186, 37.05039], [-120.86199, 37.05065], [-120.86226, 37.05108], [-120.86248, 37.05149], [-120.86265, 37.05191], [-120.86277, 37.05233], [-120.8634, 37.05223], [-120.86434, 37.05547]]]} | Open Access 1 | Gardens Park V | 19208 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 17.019 | Gardens Park V | ||
13887 | 13887 | 13886 | {"type": "Polygon", "coordinates": [[[-120.84796, 37.06232], [-120.84785, 37.06248], [-120.84775, 37.06256], [-120.84764, 37.06262], [-120.84752, 37.06266], [-120.84727, 37.06269], [-120.84715, 37.06267], [-120.84697, 37.06263], [-120.84676, 37.06256], [-120.84659, 37.06246], [-120.84645, 37.06237], [-120.84632, 37.06225], [-120.84626, 37.06214], [-120.84624, 37.06204], [-120.84624, 37.0619], [-120.84627, 37.06181], [-120.84634, 37.06169], [-120.84641, 37.06162], [-120.84796, 37.06232]]]} | Open Access 1 | Henry Miller Plaza | 33148 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 2.492 | Henry Miller Plaza | ||
5535 | 5535 | 5534 | {"type": "Polygon", "coordinates": [[[-120.81962, 37.06595], [-120.81952, 37.06616], [-120.81949, 37.06634], [-120.81768, 37.06633], [-120.81768, 37.06535], [-120.81776, 37.0653], [-120.81793, 37.0653], [-120.81825, 37.06533], [-120.81846, 37.06537], [-120.81867, 37.06545], [-120.81888, 37.06555], [-120.81917, 37.06575], [-120.81931, 37.06583], [-120.81962, 37.06595]]]} | Open Access 1 | Jo Lin Park | 20416 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 3.746 | Jo Lin Park | ||
6276 | 6276 | 6275 | {"type": "Polygon", "coordinates": [[[-120.84517, 37.06501], [-120.84392, 37.06683], [-120.84248, 37.0662], [-120.84374, 37.06437], [-120.84517, 37.06501]]]} | Open Access 1 | Little League Park | 21349 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 8.358 | Little League Park | ||
6278 | 6278 | 6277 | {"type": "Polygon", "coordinates": [[[-120.8508, 37.05224], [-120.8508, 37.05236], [-120.85041, 37.05236], [-120.85041, 37.05213], [-120.8508, 37.05224]]]} | Open Access 1 | Little Page Park | 21351 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.165 | Little Page Park | ||
502 | 502 | 501 | {"type": "Polygon", "coordinates": [[[-120.81459, 37.06623], [-120.81092, 37.06787], [-120.80651, 37.06239], [-120.80833, 37.06136], [-120.80844, 37.06144], [-120.80879, 37.06158], [-120.80923, 37.06165], [-120.80948, 37.06163], [-120.80998, 37.06145], [-120.81015, 37.06174], [-120.81, 37.06182], [-120.80952, 37.0622], [-120.80924, 37.06258], [-120.80908, 37.06288], [-120.80882, 37.06348], [-120.80885, 37.06432], [-120.80889, 37.06465], [-120.80909, 37.06503], [-120.80962, 37.06559], [-120.80985, 37.06582], [-120.81016, 37.06605], [-120.81055, 37.06627], [-120.81136, 37.06658], [-120.81166, 37.0666], [-120.81196, 37.0666], [-120.8127, 37.06653], [-120.81317, 37.06646], [-120.81437, 37.066], [-120.81459, 37.06623]]]} | Open Access 1 | Meadowlands III Basin | http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf | 33514 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 24.134 | Meadowlands III Basin | |
6876 | 6876 | 6875 | {"type": "Polygon", "coordinates": [[[-120.81029, 37.05756], [-120.81027, 37.05786], [-120.80944, 37.05784], [-120.80945, 37.05754], [-120.81029, 37.05756]]]} | Open Access 1 | Meadowlands Park I | 22087 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.621 | Meadowlands Park I |
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]);