units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 467 sorted by UNIT_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3612 | 3612 | 3611 | {"type": "Polygon", "coordinates": [[[-120.4815, 37.29325], [-120.48128, 37.29362], [-120.48113, 37.29357], [-120.48134, 37.29319], [-120.4815, 37.29325]]]} | Open Access 1 | 47309 | 11th Street Neighborhood Park | 31016 | 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 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.172 | 11th Street 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 | |
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 | |
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 | |
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 | |
14922 | 14922 | 14921 | {"type": "Polygon", "coordinates": [[[-120.50302, 37.31525], [-120.50296, 37.317], [-120.50148, 37.31639], [-120.50151, 37.31494], [-120.5017, 37.31495], [-120.50192, 37.31498], [-120.50302, 37.31525]]]} | Open Access 1 | 45495 | Carolo Gabriault Park | 28324 | 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 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/neighborhood.asp | Merced 37 | 5.966 | Carolo Gabriault Park | 0 | Local Park 2 | 4 |
11956 | 11956 | 11955 | {"type": "Polygon", "coordinates": [[[-120.4915, 37.2933], [-120.49129, 37.29367], [-120.49082, 37.2935], [-120.49103, 37.29312], [-120.4915, 37.2933]]]} | Open Access 1 | 24573 | Charles Richard Drew Park | 17141 | 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.516 | Charles Richard Drew Park | 0 | Local Park 2 | 4 | |
11957 | 11957 | 11956 | {"type": "Polygon", "coordinates": [[[-120.46488, 37.30196], [-120.46508, 37.30203], [-120.46511, 37.30208], [-120.46498, 37.30229], [-120.46491, 37.30233], [-120.46484, 37.30233], [-120.46474, 37.30229], [-120.46471, 37.30225], [-120.4647, 37.30219], [-120.46481, 37.30199], [-120.46488, 37.30196]]]} | Open Access 1 | 24574 | Circle Drive Park | 17262 | 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.245 | Circle Drive Park | 0 | Local Park 2 | 4 | |
11955 | 11955 | 11954 | {"type": "Polygon", "coordinates": [[[-120.45683, 37.33995], [-120.45636, 37.33993], [-120.45612, 37.33986], [-120.45579, 37.3397], [-120.45557, 37.33956], [-120.45533, 37.33946], [-120.45505, 37.33936], [-120.45469, 37.33931], [-120.45401, 37.33931], [-120.45403, 37.33859], [-120.45464, 37.33855], [-120.45505, 37.33842], [-120.45638, 37.33845], [-120.45647, 37.33853], [-120.45669, 37.33865], [-120.45678, 37.33875], [-120.45683, 37.33995]]]} | Open Access 1 | 24571 | Davenport Park | 17940 | 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.283 | Davenport Park | 0 | Local Park 2 | 4 | |
12325 | 12325 | 12324 | {"type": "MultiPolygon", "coordinates": [[[[-120.50386, 37.30145], [-120.50368, 37.30177], [-120.5034, 37.30167], [-120.50358, 37.30135], [-120.50386, 37.30145]]], [[[-120.50419, 37.30157], [-120.50401, 37.30189], [-120.50371, 37.30178], [-120.50389, 37.30146], [-120.50419, 37.30157]]]]} | Open Access 1 | 25988 | Dennis Chavez Park | 18088 | 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.543 | Dennis Chavez 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 | |
14615 | 14615 | 14614 | {"type": "Polygon", "coordinates": [[[-120.52536, 37.32598], [-120.52391, 37.32599], [-120.52384, 37.32593], [-120.52386, 37.32508], [-120.52383, 37.32494], [-120.52374, 37.32475], [-120.52371, 37.32464], [-120.52375, 37.32459], [-120.52445, 37.32459], [-120.52445, 37.32503], [-120.52536, 37.32503], [-120.52536, 37.32598]]]} | Open Access 1 | 48865 | Drake Avenue Park | 33589 | 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.221 | Drake Avenue Park | 0 | Local Park 2 | 4 | |
3611 | 3611 | 3610 | {"type": "Polygon", "coordinates": [[[-120.47782, 37.29312], [-120.47757, 37.29354], [-120.47726, 37.29343], [-120.47751, 37.293], [-120.47782, 37.29312]]]} | Open Access 1 | 47308 | E. 12th Street Neighborhood Park | 31015 | 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 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.39 | E. 12th Street Neighborhood Park | 0 | Local Park 2 | 4 |
14607 | 14607 | 14606 | {"type": "Polygon", "coordinates": [[[-120.47399, 37.35291], [-120.47387, 37.35298], [-120.4733, 37.35322], [-120.47277, 37.35349], [-120.47297, 37.35373], [-120.47251, 37.35401], [-120.47241, 37.35399], [-120.47215, 37.35365], [-120.47194, 37.35328], [-120.47178, 37.35289], [-120.47184, 37.35283], [-120.47241, 37.35276], [-120.47399, 37.35275], [-120.47399, 37.35291]]]} | Open Access 1 | 48303 | Elmer Murchie Park | 32871 | 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.538 | Elmer Murchie Park | 0 | Local Park 2 | 4 | |
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 | |
14271 | 14271 | 14270 | {"type": "Polygon", "coordinates": [[[-120.47664, 37.28434], [-120.47574, 37.28433], [-120.47574, 37.28253], [-120.47664, 37.28254], [-120.47664, 37.28434]]]} | Open Access 1 | 44194 | 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 | 3.957 | Flanagan Park | 0 | Local Park 2 | 4 | |
3571 | 3571 | 3570 | {"type": "Polygon", "coordinates": [[[-120.50508, 37.29722], [-120.5047, 37.29789], [-120.5044, 37.29778], [-120.50459, 37.29745], [-120.50461, 37.29727], [-120.50487, 37.29683], [-120.50447, 37.29668], [-120.50449, 37.29664], [-120.50499, 37.29683], [-120.50508, 37.29722]]]} | Open Access 1 | 47307 | Fredrick Douglas Park | 31014 | 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 | https://www.cityofmerced.org/depts/parks_n_community_services/parks_n_facilities/parks/mini.asp | Merced 37 | 0.898 | Fredrick Douglas 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 |
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]);