units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 467 sorted by PARK_URL
This data as json, copyable, CSV (advanced)
Suggested facets: UNIT_NAME, SUID_NMA, PARK_URL, LABEL_NAME
DES_TP 2
MNG_AG_TYP 1
- City Agency 34
MNG_AGENCY 1
- Merced, City of · 34 ✖
ACCESS_TYP 1
- Open Access 34
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2060 | 2060 | 2059 | {"type": "Polygon", "coordinates": [[[-120.5026, 37.32463], [-120.50255, 37.32632], [-120.49733, 37.32619], [-120.49733, 37.32628], [-120.49619, 37.32625], [-120.49612, 37.32633], [-120.49608, 37.32681], [-120.49667, 37.32683], [-120.49656, 37.32703], [-120.49646, 37.32775], [-120.49506, 37.32776], [-120.49478, 37.32773], [-120.49448, 37.32767], [-120.49415, 37.32753], [-120.49257, 37.32679], [-120.49224, 37.32671], [-120.49198, 37.32668], [-120.49227, 37.32645], [-120.4925, 37.32639], [-120.4938, 37.32607], [-120.49499, 37.32599], [-120.49551, 37.3258], [-120.4955, 37.32517], [-120.49477, 37.32497], [-120.49422, 37.32489], [-120.49382, 37.32488], [-120.48924, 37.32491], [-120.48822, 37.32573], [-120.48823, 37.32621], [-120.48701, 37.32619], [-120.48707, 37.325], [-120.4871, 37.32472], [-120.5026, 37.32463]]]} | Open Access 1 | 17183 | Fahrens Park | 18783 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 49.713 | Fahrens Park | 0 | Local Park 2 | 4 | |
2061 | 2061 | 2060 | {"type": "Polygon", "coordinates": [[[-120.48346, 37.28095], [-120.48345, 37.28231], [-120.48218, 37.28228], [-120.48217, 37.28092], [-120.48346, 37.28095]]]} | Open Access 1 | 17190 | Flanagan Park | 18939 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.228 | Flanagan Park | 0 | Local Park 2 | 4 | |
2069 | 2069 | 2068 | {"type": "Polygon", "coordinates": [[[-120.45486, 37.32488], [-120.45107, 37.32489], [-120.45114, 37.32226], [-120.45128, 37.32237], [-120.45151, 37.32264], [-120.45184, 37.32277], [-120.45213, 37.32281], [-120.4523, 37.32277], [-120.45322, 37.32263], [-120.45421, 37.32265], [-120.4544, 37.32276], [-120.45458, 37.3229], [-120.45448, 37.32309], [-120.45444, 37.32341], [-120.45433, 37.32358], [-120.45409, 37.32381], [-120.45384, 37.32413], [-120.45368, 37.3244], [-120.45359, 37.32461], [-120.45356, 37.32471], [-120.45367, 37.32477], [-120.45419, 37.32473], [-120.45458, 37.32476], [-120.45486, 37.32488]]]} | Open Access 1 | 17208 | Rahilly Park | 24073 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 16.515 | Rahilly Park | 0 | Local Park 2 | 4 | |
2372 | 2372 | 2371 | {"type": "Polygon", "coordinates": [[[-120.48762, 37.31278], [-120.48744, 37.31322], [-120.48708, 37.31318], [-120.48628, 37.31314], [-120.4856, 37.31321], [-120.48531, 37.31326], [-120.48449, 37.31331], [-120.48401, 37.3133], [-120.48373, 37.31327], [-120.48279, 37.31304], [-120.48243, 37.313], [-120.48224, 37.313], [-120.48161, 37.31306], [-120.4806, 37.31328], [-120.48031, 37.31333], [-120.48017, 37.31333], [-120.47897, 37.31315], [-120.4788, 37.31311], [-120.47863, 37.31304], [-120.4795, 37.31153], [-120.48011, 37.31176], [-120.48037, 37.31133], [-120.48279, 37.31222], [-120.48314, 37.31166], [-120.48462, 37.3122], [-120.48488, 37.31179], [-120.48762, 37.31278]]]} | Open Access 1 | 17174 | Applegate Park | 15542 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 25.808 | Applegate Park | 0 | Local Park 2 | 4 | |
2373 | 2373 | 2372 | {"type": "Polygon", "coordinates": [[[-120.45084, 37.32863], [-120.45083, 37.32986], [-120.4489, 37.32986], [-120.4489, 37.32887], [-120.44895, 37.32866], [-120.44899, 37.32859], [-120.45079, 37.32859], [-120.45084, 37.32863]]]} | Open Access 1 | 17177 | Bob Carpenter Park | 16207 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 5.954 | Bob Carpenter Park | 0 | Local Park 2 | 4 | |
2374 | 2374 | 2373 | {"type": "Polygon", "coordinates": [[[-120.46587, 37.3165], [-120.46587, 37.31737], [-120.46537, 37.31766], [-120.46535, 37.31792], [-120.46535, 37.31835], [-120.46479, 37.31836], [-120.46481, 37.31765], [-120.46481, 37.3165], [-120.46587, 37.3165]]]} | Open Access 1 | 17180 | Burbank Park | 16509 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 3.754 | Burbank Park | 0 | Local Park 2 | 4 | |
2378 | 2378 | 2377 | {"type": "Polygon", "coordinates": [[[-120.48172, 37.28829], [-120.4811, 37.28936], [-120.478, 37.28823], [-120.48172, 37.28829], [-120.48172, 37.28829]]]} | Open Access 1 | 17196 | Macias Park | 21633 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.912 | Macias Park | 0 | Local Park 2 | 4 | |
2381 | 2381 | 2380 | {"type": "Polygon", "coordinates": [[[-120.48826, 37.29263], [-120.4869, 37.29499], [-120.48565, 37.29453], [-120.48701, 37.29217], [-120.48826, 37.29263]]]} | Open Access 1 | 17202 | McNamara Park | 22059 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 8.697 | McNamara Park | 0 | Local Park 2 | 4 | |
2383 | 2383 | 2382 | {"type": "Polygon", "coordinates": [[[-120.50168, 37.29469], [-120.50126, 37.29543], [-120.50001, 37.29497], [-120.50043, 37.29424], [-120.50168, 37.29469]]]} | Open Access 1 | 17213 | Stephen Leonard Park | 25831 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 2.699 | Stephen Leonard Park | 0 | Local Park 2 | 4 | |
3124 | 3124 | 3123 | {"type": "Polygon", "coordinates": [[[-120.49375, 37.29584], [-120.49364, 37.29603], [-120.49319, 37.29587], [-120.4933, 37.29568], [-120.49375, 37.29584]]]} | Open Access 1 | 25452 | Diego Rivera Park | 18153 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.253 | Diego Rivera Park | 0 | Local Park 2 | 4 | |
3125 | 3125 | 3124 | {"type": "Polygon", "coordinates": [[[-120.49486, 37.28895], [-120.49462, 37.28936], [-120.49421, 37.28921], [-120.49439, 37.2889], [-120.49457, 37.28897], [-120.49463, 37.28887], [-120.49486, 37.28895]]]} | Open Access 1 | 25453 | Harriet Tubman Park | 19693 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.447 | Harriet Tubman Park | 0 | Local Park 2 | 4 | |
3469 | 3469 | 3468 | {"type": "Polygon", "coordinates": [[[-120.48998, 37.28962], [-120.48977, 37.29], [-120.48961, 37.28994], [-120.48982, 37.28957], [-120.48998, 37.28962]]]} | Open Access 1 | 25449 | The Love Veasley Family Park | 26287 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.171 | The Love Veasley Family Park | 0 | Local Park 2 | 4 | |
3470 | 3470 | 3469 | {"type": "Polygon", "coordinates": [[[-120.50555, 37.29161], [-120.50555, 37.29165], [-120.50529, 37.29156], [-120.50523, 37.29164], [-120.50399, 37.29119], [-120.50379, 37.29152], [-120.50367, 37.29147], [-120.50412, 37.29068], [-120.50444, 37.29079], [-120.50425, 37.29113], [-120.50468, 37.29129], [-120.50468, 37.29131], [-120.5049, 37.29138], [-120.50492, 37.29138], [-120.50555, 37.29161]]]} | Open Access 1 | 25454 | Benjamin Banneker Memorial Park | 16013 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 0.968 | Benjamin Banneker Memorial Park | 0 | Local Park 2 | 4 | |
5004 | 5004 | 5003 | {"type": "Polygon", "coordinates": [[[-120.48291, 37.32505], [-120.48255, 37.32505], [-120.48249, 37.32529], [-120.48243, 37.32524], [-120.48239, 37.32506], [-120.48168, 37.32507], [-120.48162, 37.32522], [-120.48153, 37.32506], [-120.48117, 37.32506], [-120.48116, 37.326], [-120.48111, 37.32627], [-120.48086, 37.32635], [-120.48072, 37.3262], [-120.48075, 37.32506], [-120.48039, 37.32506], [-120.4803, 37.32523], [-120.48021, 37.32507], [-120.47965, 37.32507], [-120.47945, 37.32511], [-120.4794, 37.32527], [-120.47928, 37.32514], [-120.47898, 37.32519], [-120.47864, 37.32527], [-120.47865, 37.32539], [-120.47856, 37.32544], [-120.47852, 37.3253], [-120.47852, 37.32498], [-120.47961, 37.3248], [-120.48291, 37.32478], [-120.48291, 37.32505]]]} | Open Access 1 | 17210 | Santa Fe Park | 25086 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.44 | Santa Fe Park | 0 | Local Park 2 | 4 | |
7221 | 7221 | 7220 | {"type": "Polygon", "coordinates": [[[-120.43929, 37.329], [-120.43929, 37.32952], [-120.43925, 37.32958], [-120.4392, 37.3296], [-120.43809, 37.3296], [-120.43785, 37.32954], [-120.4377, 37.32947], [-120.43758, 37.32938], [-120.43748, 37.32927], [-120.43739, 37.32908], [-120.43738, 37.32895], [-120.43738, 37.32783], [-120.43739, 37.32779], [-120.43743, 37.32776], [-120.43749, 37.32774], [-120.4389, 37.32774], [-120.4389, 37.329], [-120.43929, 37.329]]]} | Open Access 1 | 48908 | Richard Bernasconi Neighborhood Park | 33625 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 7.14 | Richard Bernasconi Neighborhood Park | 0 | Local Park 2 | 4 | |
9979 | 9979 | 9978 | {"type": "Polygon", "coordinates": [[[-120.45419, 37.30635], [-120.45368, 37.30715], [-120.45136, 37.30715], [-120.45137, 37.30635], [-120.45419, 37.30635]]]} | Open Access 1 | 17171 | Ada Givens Park | 15254 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 4.995 | Ada Givens Park | 0 | Local Park 2 | 4 | |
9991 | 9991 | 9990 | {"type": "MultiPolygon", "coordinates": [[[[-120.44838, 37.29502], [-120.44834, 37.29505], [-120.44707, 37.29505], [-120.44707, 37.29497], [-120.44796, 37.29497], [-120.4481, 37.29492], [-120.44827, 37.29478], [-120.44837, 37.29478], [-120.44838, 37.29479], [-120.44838, 37.29502]]], [[[-120.45142, 37.29149], [-120.45142, 37.29155], [-120.4512, 37.29155], [-120.45119, 37.2917], [-120.45142, 37.29171], [-120.45141, 37.29303], [-120.45129, 37.29303], [-120.45129, 37.29328], [-120.45141, 37.29329], [-120.45141, 37.29332], [-120.44934, 37.29332], [-120.44933, 37.29374], [-120.44865, 37.29375], [-120.44864, 37.29502], [-120.44855, 37.29501], [-120.44855, 37.29456], [-120.44839, 37.29456], [-120.44838, 37.29461], [-120.44835, 37.29464], [-120.44819, 37.29466], [-120.448, 37.29481], [-120.44793, 37.29483], [-120.44707, 37.29483], [-120.44709, 37.29149], [-120.45142, 37.29149]]]]} | Open Access 1 | 17193 | Joe Herb Park | 20419 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 25.726 | Joe Herb Park | 0 | Local Park 2 | 4 | |
9999 | 9999 | 9998 | {"type": "Polygon", "coordinates": [[[-120.51484, 37.28903], [-120.51501, 37.28906], [-120.51515, 37.28915], [-120.51521, 37.28923], [-120.51524, 37.28932], [-120.51522, 37.28946], [-120.51434, 37.29158], [-120.51391, 37.29154], [-120.5146, 37.28986], [-120.51461, 37.28976], [-120.51459, 37.28967], [-120.51448, 37.28949], [-120.51444, 37.28941], [-120.51445, 37.28927], [-120.51453, 37.28915], [-120.51462, 37.28909], [-120.51472, 37.28905], [-120.51484, 37.28903]]]} | Open Access 1 | 17199 | Macready Park | 21639 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 3.102 | Macready Park | 0 | Local Park 2 | 4 | |
10008 | 10008 | 10007 | {"type": "Polygon", "coordinates": [[[-120.50888, 37.29553], [-120.50884, 37.29726], [-120.50588, 37.29724], [-120.50594, 37.29553], [-120.50888, 37.29553]]]} | Open Access 1 | 17205 | Merced Youth Sports Complex | 22167 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 12.336 | Merced Youth Sports Complex | 0 | Local Recreation Area 3 | 4 | |
10009 | 10009 | 10008 | {"type": "Polygon", "coordinates": [[[-120.46054, 37.32302], [-120.46054, 37.32321], [-120.46018, 37.32312], [-120.46017, 37.32343], [-120.45982, 37.32331], [-120.459, 37.32281], [-120.45818, 37.32281], [-120.45792, 37.32288], [-120.45702, 37.3236], [-120.45696, 37.32392], [-120.45695, 37.32489], [-120.45622, 37.3249], [-120.45536, 37.32489], [-120.45561, 37.32475], [-120.45603, 37.32447], [-120.45638, 37.32445], [-120.45654, 37.32426], [-120.45655, 37.32356], [-120.45789, 37.32249], [-120.45886, 37.32159], [-120.45902, 37.32149], [-120.4592, 37.32142], [-120.45937, 37.32137], [-120.45957, 37.32137], [-120.45964, 37.32144], [-120.45973, 37.32146], [-120.45977, 37.32173], [-120.46019, 37.32174], [-120.46017, 37.32301], [-120.46054, 37.32302]]]} | Open Access 1 | 17216 | Strip Park | 25927 | 1203 | Merced, City of 474 | City 2 | City Agency 2 | http://www.cityofmerced.org/depts/parks_n_community_services/default.asp | City 2 | 1203 | Merced, City of 467 | City 2 | City Agency 2 | Merced 37 | 10.443 | Strip Park | 0 | Local Park 2 | 4 |
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]);