units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where MNG_AGENCY = 512 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP 15
MNG_AG_TYP 1
- City Agency 20
MNG_AGENCY 1
- Los Banos, City of · 20 ✖
ACCESS_TYP 1
- Open Access 20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
14289 | 14289 | 14288 | {"type": "Polygon", "coordinates": [[[-120.84755, 37.05584], [-120.84754, 37.0567], [-120.84745, 37.05677], [-120.84466, 37.05678], [-120.84467, 37.05621], [-120.84469, 37.05594], [-120.84521, 37.05593], [-120.84522, 37.05601], [-120.84568, 37.05601], [-120.8457, 37.05603], [-120.84585, 37.05603], [-120.84586, 37.056], [-120.84662, 37.05599], [-120.84662, 37.05586], [-120.84755, 37.05584]]]} | Open Access 1 | 44223 | Pacheco Park | 23291 | 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 | 5.82 | Pacheco 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 | |
2370 | 2370 | 2369 | {"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 | 17169 | Ag Sports Complex | 15283 | 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 | 9.306 | Ag Sports Complex | 0 | Local Recreation Area 3 | 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 | |
7454 | 7454 | 7453 | {"type": "MultiPolygon", "coordinates": [[[[-120.83719, 37.05776], [-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.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.84676, 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.84793, 37.06249], [-120.84838, 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.85217, 37.06491], [-120.85116, 37.06458], [-120.84972, 37.06395], [-120.85, 37.06354], [-120.85245, 37.06462], [-120.85267, 37.06441], [-120.8528, 37.06447]]]]} | Open Access 1 | 48445 | Rail Trail | 33150 | 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 | 19.027 | Rail Trail | 0 | Local Recreation Area 3 | 4 | |
12316 | 12316 | 12315 | {"type": "Polygon", "coordinates": [[[-120.8676, 37.06527], [-120.86648, 37.06525], [-120.86653, 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.06451], [-120.86744, 37.06472], [-120.86757, 37.06493], [-120.8676, 37.06527]]]} | Open Access 1 | 25977 | Colorado Ball Park | 17541 | 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 | 7.357 | Colorado Ball Park | 0 | Local Recreation Area 3 | 4 | |
4267 | 4267 | 4266 | {"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 | 48326 | Regency Park D | 32888 | 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 | 4.562 | Regency Park D | None 371 | |||
5620 | 5620 | 5619 | {"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.08053], [-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 | 48325 | Vinyard 14 Basin C | 32887 | 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 | 8.527 | Vinyard 14 Basin C | 0 | None 453 | ||
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 | |||
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 | |||
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 | |||
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 | |||
11947 | 11947 | 11946 | {"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.0525], [-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.05038], [-120.86198, 37.05065], [-120.86226, 37.05108], [-120.86248, 37.05149], [-120.86265, 37.05191], [-120.86277, 37.05234], [-120.8634, 37.05223], [-120.86434, 37.05547]]]} | Open Access 1 | 24563 | Gardens Park V | 19208 | 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 | 17.006 | Gardens Park V | None 1053 | |||
11948 | 11948 | 11947 | {"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.81047, 37.05938], [-120.81052, 37.05943]]]} | Open Access 1 | 24564 | Meadowlands Park II | 22088 | 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 | 4.114 | Meadowlands Park II | None 1054 | |||
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 | |||
11954 | 11954 | 11953 | {"type": "Polygon", "coordinates": [[[-120.85005, 37.07911], [-120.85002, 37.0805], [-120.84822, 37.0805], [-120.84824, 37.07911], [-120.85005, 37.07911]]]} | Open Access 1 | 24570 | Vineyards Basin Park A | 27141 | 1183 | Lompoc, City of 39 | City 2 | City Agency 2 | http://www.cityoflompoc.com/parks_rec/ | City 2 | 1189 | Los Banos, City of 512 | City 2 | City Agency 2 | Merced 37 | 6.119 | Vineyards Basin Park A | None 1056 | |||
12313 | 12313 | 12312 | {"type": "Polygon", "coordinates": [[[-120.84651, 37.08288], [-120.84651, 37.08435], [-120.84397, 37.08439], [-120.84396, 37.08294], [-120.84405, 37.08287], [-120.84651, 37.08288]]]} | Open Access 1 | 25974 | Vineyard Basin Park B | 27134 | 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 | 9.288 | Vineyard Basin Park B | None 1073 | |||
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 | |||
12629 | 12629 | 12628 | {"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.06221], [-120.80923, 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 | 48793 | Meadowlands III Basin | 33514 | 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 | 24.133 | Meadowlands III Basin | None 1094 |
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]);