units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 512 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB
DES_TP 15
MNG_AG_TYP 1
- City Agency 40
MNG_AGENCY 1
- Los Banos, City of · 40 ✖
ACCESS_TYP 1
- Open Access 40
Link | rowid | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES ▼ | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12315 | 12315 | 12314 | {"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 | 25976 | Citrus Terrace Park I | 17286 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.154 | Citrus Terrace Park I | None 1074 | |||
3507 | 3507 | 3506 | {"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 | 25980 | Little Page Park | 21351 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.165 | Little Page Park | 0 | Local Park 2 | 4 | |
2366 | 2366 | 2365 | {"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 | 17156 | Airport Park | 15303 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.388 | Airport Park | 0 | Local Park 2 | 4 | |
12314 | 12314 | 12313 | {"type": "Polygon", "coordinates": [[[-120.85118, 37.05874], [-120.85101, 37.05897], [-120.85057, 37.05878], [-120.85048, 37.05889], [-120.85003, 37.05869], [-120.85107, 37.05869], [-120.85118, 37.05874]]]} | Open Access 1 | 25975 | Catholic Park | 16978 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.408 | Catholic Park | 0 | Local Park 2 | 4 | |
4328 | 4328 | 4327 | {"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 | 48327 | Regency Tot Lot | 32889 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.458 | Regency Tot Lot | 0 | Local Recreation Area 3 | 4 | |
13313 | 13313 | 13312 | {"type": "Polygon", "coordinates": [[[-120.87486, 37.05002], [-120.87486, 37.05031], [-120.87472, 37.05043], [-120.87464, 37.0504], [-120.87454, 37.05043], [-120.8745, 37.05038], [-120.87432, 37.05028], [-120.87433, 37.04996], [-120.87486, 37.05002]]]} | Open Access 1 | 35378 | Village Park | 33696 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.507 | Village Park | 0 | Local Park 2 | 4 | |
12274 | 12274 | 12273 | {"type": "Polygon", "coordinates": [[[-120.88074, 37.0513], [-120.88052, 37.05153], [-120.88038, 37.05151], [-120.88026, 37.05154], [-120.8802, 37.05146], [-120.8801, 37.05143], [-120.88012, 37.05135], [-120.88008, 37.05123], [-120.88029, 37.05101], [-120.88074, 37.0513]]]} | Open Access 1 | 48789 | Neighborhood Park | 33512 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | http://www.losbanos.org/wp-content/uploads/2013/09/rec_parks_list_2017.pdf | Merced 37 | 0.508 | Neighborhood Park | 0 | Local Park 2 | 4 |
12321 | 12321 | 12320 | {"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 | 25983 | Presidential Park | 23989 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.542 | Presidential Park | 0 | Local Park 2 | 4 | |
11945 | 11945 | 11944 | {"type": "Polygon", "coordinates": [[[-120.86874, 37.05209], [-120.86844, 37.05234], [-120.86842, 37.05229], [-120.86826, 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.05204], [-120.86874, 37.05209]]]} | Open Access 1 | 24562 | Gardens Park III | 19207 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.601 | Gardens Park III | None 1052 | |||
12317 | 12317 | 12316 | {"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 | 25978 | Davis Park | 17952 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.618 | Davis Park | 0 | Local Park 2 | 4 | |
6382 | 6382 | 6381 | {"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 | 25981 | Meadowlands Park I | 22087 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.621 | Meadowlands Park I | None 519 | |||
11943 | 11943 | 11942 | {"type": "Polygon", "coordinates": [[[-120.86657, 37.05677], [-120.86547, 37.0568], [-120.86547, 37.0568], [-120.86569, 37.05635], [-120.86618, 37.05655], [-120.86657, 37.05677]]]} | Open Access 1 | 24560 | Wolfsen Park | 33697 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.633 | Wolfsen Park | 0 | Local Park 2 | 4 | |
11950 | 11950 | 11949 | {"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 | 24566 | Rancho Dos Amigos Park | 24142 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.665 | Rancho Dos Amigos Park | 0 | Local Park 2 | 4 | |
13980 | 13980 | 13979 | {"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 | 36649 | City Park | 33695 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.806 | City Park | 0 | Local Park 2 | 4 | |
11944 | 11944 | 11943 | {"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 | 24561 | Gardens Park I | 19206 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.817 | Gardens Park I | None 1051 | |||
9976 | 9976 | 9975 | {"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 | 17162 | Big Page Park | 16084 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 0.921 | Big Page Park | 0 | Local Park 2 | 4 | |
14776 | 14776 | 14775 | {"type": "Polygon", "coordinates": [[[-120.85495, 37.07113], [-120.85494, 37.07164], [-120.85416, 37.07164], [-120.85417, 37.0712], [-120.85421, 37.07116], [-120.85472, 37.07109], [-120.8549, 37.07109], [-120.85495, 37.07113]]]} | Open Access 1 | 48322 | Orchard Terrace Park | 32886 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 1.0 | Orchard Terrace Park | 0 | Local Park 2 | 4 | |
11941 | 11941 | 11940 | {"type": "Polygon", "coordinates": [[[-120.8521, 37.07214], [-120.85209, 37.0729], [-120.85185, 37.0729], [-120.85118, 37.07263], [-120.85117, 37.07269], [-120.85052, 37.07269], [-120.85053, 37.07214], [-120.8521, 37.07214]]]} | Open Access 1 | 24557 | Citrus Terrace Park II | 17287 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 2.351 | Citrus Terrace Park II | None 1050 | |||
7451 | 7451 | 7450 | {"type": "Polygon", "coordinates": [[[-120.84796, 37.06232], [-120.84785, 37.06248], [-120.84776, 37.06256], [-120.84764, 37.06262], [-120.84752, 37.06266], [-120.84726, 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 | 48443 | Henry Miller Plaza | 33148 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 2.492 | Henry Miller Plaza | 0 | Local Park 2 | 4 | |
11949 | 11949 | 11948 | {"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 | 24565 | Meadowlands Park III | 22089 | 1189 | Los Banos, City of 519 | City 2 | City Agency 2 | http://www.losbanos.org/city-government/departments/public-works/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 3.422 | Meadowlands Park III | None 1055 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);