superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 512 and MNG_AG_TYP = 2 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14100 | 14100 | 14099 | {"type": "MultiPolygon", "coordinates": [[[[-120.8411, 37.05961], [-120.84094, 37.05985], [-120.83719, 37.05808], [-120.8356, 37.05737], [-120.8356, 37.05723], [-120.83576, 37.05713], [-120.83719, 37.05776], [-120.8411, 37.05961]]], [[[-120.84549, 37.06143], [-120.84515, 37.06193], [-120.84227, 37.06065], [-120.84113, 37.06003], [-120.84134, 37.05972], [-120.84254, 37.06023], [-120.84259, 37.06017], [-120.84549, 37.06143]]], [[[-120.84976, 37.06343], [-120.84948, 37.06384], [-120.8454, 37.06203], [-120.84585, 37.06137], [-120.84641, 37.06162], [-120.84634, 37.06169], [-120.84626, 37.06181], [-120.84624, 37.0619], [-120.84624, 37.06204], [-120.84626, 37.06214], [-120.84632, 37.06225], [-120.84645, 37.06237], [-120.84675, 37.06256], [-120.84715, 37.06267], [-120.84735, 37.06269], [-120.84752, 37.06266], [-120.84764, 37.06262], [-120.84776, 37.06256], [-120.84785, 37.06248], [-120.84796, 37.06232], [-120.84802, 37.06234], [-120.84794, 37.06249], [-120.84837, 37.06269], [-120.84849, 37.06255], [-120.84947, 37.06299], [-120.84932, 37.06323], [-120.84976, 37.06343]]], [[[-120.8528, 37.06447], [-120.85219, 37.06535], [-120.85197, 37.06526], [-120.85218, 37.06507], [-120.85216, 37.06491], [-120.85116, 37.06458], [-120.84972, 37.06395], [-120.85, 37.06354], [-120.85244, 37.06462], [-120.85267, 37.06441], [-120.8528, 37.06447]]]]} | Open Access 1 | Rail Trail | 33150 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 19.036 | Rail Trail | ||
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 | ||
6878 | 6878 | 6877 | {"type": "Polygon", "coordinates": [[[-120.81052, 37.05943], [-120.81051, 37.05977], [-120.81052, 37.05995], [-120.81021, 37.06006], [-120.80999, 37.06017], [-120.80924, 37.06057], [-120.80881, 37.06056], [-120.80837, 37.05981], [-120.80936, 37.05947], [-120.80962, 37.0594], [-120.80991, 37.05937], [-120.81046, 37.05938], [-120.81052, 37.05943]]]} | Open Access 1 | Meadowlands Park II | 22088 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 4.114 | Meadowlands Park II | ||
6880 | 6880 | 6879 | {"type": "Polygon", "coordinates": [[[-120.81302, 37.06411], [-120.81242, 37.06442], [-120.81216, 37.06448], [-120.81198, 37.06446], [-120.81168, 37.06435], [-120.81145, 37.06413], [-120.81138, 37.06384], [-120.81145, 37.06362], [-120.81156, 37.06347], [-120.81227, 37.06311], [-120.81302, 37.06411]]]} | Open Access 1 | Meadowlands Park III | 22089 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 3.421 | Meadowlands Park III | ||
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 | |
8515 | 8515 | 8514 | {"type": "Polygon", "coordinates": [[[-120.81874, 37.06099], [-120.81873, 37.06123], [-120.81853, 37.06124], [-120.81852, 37.06151], [-120.8182, 37.0615], [-120.81821, 37.0609], [-120.81853, 37.06082], [-120.81856, 37.06088], [-120.81862, 37.06093], [-120.81874, 37.06099]]]} | Open Access 1 | Rancho Dos Amigos Park | 24142 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.667 | Rancho Dos Amigos Park | ||
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 | ||
10262 | 10262 | 10261 | {"type": "Polygon", "coordinates": [[[-120.82205, 37.06929], [-120.82203, 37.0704], [-120.8194, 37.07034], [-120.81944, 37.06924], [-120.82205, 37.06929]]]} | Open Access 1 | Verona Park | 27005 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 7.099 | Verona Park | ||
1198 | 1198 | 1197 | {"type": "Polygon", "coordinates": [[[-120.82975, 37.07849], [-120.8297, 37.07853], [-120.82881, 37.07853], [-120.82862, 37.07851], [-120.82843, 37.07848], [-120.82825, 37.07842], [-120.82801, 37.07829], [-120.82776, 37.07809], [-120.82777, 37.07803], [-120.82915, 37.07712], [-120.82921, 37.07712], [-120.8296, 37.0775], [-120.82971, 37.07768], [-120.82976, 37.07787], [-120.82975, 37.07849]]]} | Open Access 1 | Regency Park D | 32888 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 4.561 | Regency Park D | ||
10214 | 10214 | 10213 | {"type": "Polygon", "coordinates": [[[-120.83167, 37.06186], [-120.83167, 37.06285], [-120.83164, 37.06345], [-120.8315, 37.06346], [-120.83099, 37.06346], [-120.82896, 37.06343], [-120.82894, 37.06181], [-120.83167, 37.06186]]]} | Open Access 1 | Talbott Park | 26173 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 10.697 | Talbott Park | ||
9717 | 9717 | 9716 | {"type": "Polygon", "coordinates": [[[-120.83199, 37.08099], [-120.83182, 37.08135], [-120.8317, 37.08146], [-120.83194, 37.08167], [-120.83168, 37.08187], [-120.83138, 37.08166], [-120.83116, 37.08181], [-120.83116, 37.08263], [-120.82995, 37.08262], [-120.82989, 37.08257], [-120.82991, 37.08075], [-120.82996, 37.08071], [-120.83118, 37.08072], [-120.83118, 37.08099], [-120.83199, 37.08099]]]} | Open Access 1 | Skylark Park | 25536 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 7.208 | Skylark 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 | ||
1199 | 1199 | 1198 | {"type": "Polygon", "coordinates": [[[-120.83477, 37.08028], [-120.83422, 37.08027], [-120.83417, 37.08005], [-120.83425, 37.08002], [-120.83433, 37.07998], [-120.8344, 37.07988], [-120.83477, 37.07997], [-120.83477, 37.08028]]]} | Open Access 1 | Regency Tot Lot | 32889 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.457 | Regency Tot Lot | ||
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 | ||
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 | ||
1196 | 1196 | 1195 | {"type": "Polygon", "coordinates": [[[-120.84016, 37.08053], [-120.84011, 37.0806], [-120.84009, 37.08068], [-120.8401, 37.08076], [-120.84015, 37.08085], [-120.84015, 37.08118], [-120.83981, 37.08118], [-120.8398, 37.08128], [-120.83792, 37.08128], [-120.83796, 37.08102], [-120.83796, 37.08054], [-120.83802, 37.08052], [-120.838, 37.07954], [-120.83958, 37.07956], [-120.83955, 37.07964], [-120.83956, 37.07971], [-120.83963, 37.07983], [-120.83968, 37.07986], [-120.83978, 37.0799], [-120.83988, 37.0799], [-120.84005, 37.07986], [-120.84014, 37.07986], [-120.84013, 37.08043], [-120.84016, 37.08053]]]} | Open Access 1 | Vinyard 14 Basin C | 32887 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 8.529 | Vinyard 14 Basin C | ||
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 | ||
8396 | 8396 | 8395 | {"type": "Polygon", "coordinates": [[[-120.84144, 37.04562], [-120.84101, 37.04582], [-120.84084, 37.04572], [-120.84096, 37.04555], [-120.84092, 37.04526], [-120.84126, 37.04521], [-120.84129, 37.04531], [-120.84144, 37.04562]]]} | Open Access 1 | Presidential Park | 23989 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 0.542 | Presidential Park | ||
8548 | 8548 | 8547 | {"type": "Polygon", "coordinates": [[[-120.84485, 37.07714], [-120.84483, 37.07869], [-120.84364, 37.07869], [-120.84367, 37.07737], [-120.84365, 37.07719], [-120.84371, 37.07714], [-120.84485, 37.07714]]]} | Open Access 1 | Ranchwood Park | 24183 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 4.493 | Ranchwood 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 |
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]);