units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 and MNG_AG_TYP = 2 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 3
- Local Park 66
- Local Recreation Area 8
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency · 75 ✖
MNG_AGENCY 1
- Fresno, City of · 75 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11833 | 11833 | 11832 | {"type": "Polygon", "coordinates": [[[-119.7477, 36.86655], [-119.74555, 36.86657], [-119.74555, 36.86479], [-119.7477, 36.86477], [-119.7477, 36.86655]]]} | Open Access 1 | 24159 | Selma Layne Park | 25291 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 9.348 | Selma Layne Park | 0 | Local Park 2 | 4 | |
3613 | 3613 | 3612 | {"type": "Polygon", "coordinates": [[[-119.74954, 36.87775], [-119.74952, 36.87906], [-119.74763, 36.87907], [-119.74752, 36.87875], [-119.7474, 36.87848], [-119.74723, 36.87819], [-119.74707, 36.87796], [-119.7471, 36.87785], [-119.74718, 36.87783], [-119.74738, 36.87779], [-119.74766, 36.87779], [-119.74779, 36.87776], [-119.74954, 36.87775]]]} | Open Access 1 | 47310 | Beamer Neighborhood Park | 31017 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.928 | Beamer Neighborhood Park | 0 | Local Park 2 | 4 | |
1393 | 1393 | 1392 | {"type": "Polygon", "coordinates": [[[-119.75015, 36.71483], [-119.75014, 36.7177], [-119.74792, 36.71771], [-119.74793, 36.71426], [-119.74995, 36.71425], [-119.74995, 36.71483], [-119.75015, 36.71483]]]} | Open Access 1 | 12202 | Calwa Park | 16743 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 18.484 | Calwa Park | 0 | Local Park 2 | 4 | |
174 | 174 | 173 | {"type": "Polygon", "coordinates": [[[-119.75401, 36.83145], [-119.75399, 36.83147], [-119.7525, 36.83155], [-119.75249, 36.83068], [-119.75238, 36.83067], [-119.75238, 36.83038], [-119.75399, 36.83038], [-119.754, 36.83039], [-119.75401, 36.83145]]]} | Open Access 1 | 473 | Rotary Park East | 24702 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.268 | Rotary Park East | 0 | Local Park 2 | 4 | |
11830 | 11830 | 11829 | {"type": "Polygon", "coordinates": [[[-119.75449, 36.7259], [-119.75449, 36.72681], [-119.75239, 36.72681], [-119.75238, 36.72591], [-119.75449, 36.7259]]]} | Open Access 1 | 24155 | East Fresno Boys Club | 18368 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.671 | East Fresno Boys Club | 0 | Local Recreation Area 3 | 4 | |
4351 | 4351 | 4350 | {"type": "Polygon", "coordinates": [[[-119.75892, 36.7433], [-119.75892, 36.74334], [-119.75857, 36.74341], [-119.75823, 36.74349], [-119.75823, 36.7433], [-119.75892, 36.7433]]]} | Open Access 1 | 45675 | Ninth and Tulare Pocket Park | 28489 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.182 | Ninth and Tulare PP | 0 | Local Park 2 | 4 | |
5246 | 5246 | 5245 | {"type": "Polygon", "coordinates": [[[-119.76314, 36.79821], [-119.76314, 36.79947], [-119.76112, 36.79948], [-119.76112, 36.79821], [-119.76314, 36.79821]]]} | Open Access 1 | 1342 | Large Park | 21025 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.238 | Large Park | 0 | Local Park 2 | 4 | |
214 | 214 | 213 | {"type": "Polygon", "coordinates": [[[-119.76535, 36.81453], [-119.76535, 36.8157], [-119.76314, 36.81569], [-119.76317, 36.81453], [-119.76535, 36.81453]]]} | Open Access 1 | 584 | El Dorado Park | 18504 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.297 | El Dorado Park | 0 | Local Park 2 | 4 | |
193 | 193 | 192 | {"type": "Polygon", "coordinates": [[[-119.76796, 36.7851], [-119.76795, 36.78577], [-119.76709, 36.78578], [-119.76707, 36.78673], [-119.76453, 36.78674], [-119.76455, 36.78559], [-119.76459, 36.78548], [-119.76458, 36.78543], [-119.76455, 36.78538], [-119.76467, 36.78503], [-119.76736, 36.78502], [-119.7674, 36.78511], [-119.7675, 36.78515], [-119.76759, 36.78515], [-119.76771, 36.7851], [-119.76796, 36.7851]]]} | Open Access 1 | 535 | Einstein Park | 18471 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 12.015 | Einstein Park | 0 | Local Park 2 | 4 | |
6198 | 6198 | 6197 | {"type": "Polygon", "coordinates": [[[-119.76803, 36.8627], [-119.76737, 36.86271], [-119.76643, 36.86282], [-119.76598, 36.86283], [-119.76593, 36.86279], [-119.76593, 36.86197], [-119.76803, 36.86196], [-119.76803, 36.8627]]]} | Open Access 1 | 1238 | Keith Tice Park | 20574 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.07 | Keith Tice Park | 0 | Local Park 2 | 4 | |
14434 | 14434 | 14433 | {"type": "Polygon", "coordinates": [[[-119.76952, 36.82039], [-119.76941, 36.82058], [-119.76874, 36.82111], [-119.76873, 36.82129], [-119.76932, 36.82178], [-119.76823, 36.82264], [-119.76813, 36.82282], [-119.76773, 36.82282], [-119.76774, 36.8215], [-119.76936, 36.82023], [-119.76952, 36.82039]]]} | Open Access 1 | 47091 | First & Bullard Park | 30752 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 5.08 | First & Bullard Park | 0 | Local Park 2 | 4 | |
517 | 517 | 516 | {"type": "Polygon", "coordinates": [[[-119.77001, 36.80122], [-119.76779, 36.80122], [-119.76779, 36.79947], [-119.76789, 36.79945], [-119.76789, 36.79825], [-119.76891, 36.79825], [-119.76891, 36.79772], [-119.77, 36.79772], [-119.77001, 36.80122]]]} | Open Access 1 | 2141 | Rotary Park West | 24703 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 17.219 | Rotary Park West | 0 | Local Park 2 | 4 | |
14975 | 14975 | 14974 | {"type": "Polygon", "coordinates": [[[-119.77345, 36.74584], [-119.77272, 36.74583], [-119.7727, 36.74581], [-119.77269, 36.74549], [-119.77345, 36.74549], [-119.77345, 36.74584]]]} | Open Access 1 | 45614 | First and Nevada Pocket Park | 28443 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 0.629 | First and Nevada PP | 0 | Local Park 2 | 4 | |
466 | 466 | 465 | {"type": "Polygon", "coordinates": [[[-119.77435, 36.73962], [-119.77432, 36.74122], [-119.7726, 36.74123], [-119.77267, 36.73961], [-119.77435, 36.73962]]]} | Open Access 1 | 922 | Holmes Playground | 20056 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 6.725 | Holmes Playground | 0 | Local Recreation Area 3 | 4 | |
508 | 508 | 507 | {"type": "Polygon", "coordinates": [[[-119.77465, 36.75361], [-119.77461, 36.75365], [-119.77404, 36.75398], [-119.77404, 36.75406], [-119.7726, 36.75407], [-119.7726, 36.75242], [-119.77465, 36.75241], [-119.77465, 36.75361]]]} | Open Access 1 | 2073 | Romain Playground | 24586 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 7.876 | Romain Playground | 0 | Local Recreation Area 3 | 4 | |
5727 | 5727 | 5726 | {"type": "Polygon", "coordinates": [[[-119.7747, 36.77217], [-119.77322, 36.77217], [-119.77321, 36.7718], [-119.77272, 36.7718], [-119.77272, 36.77056], [-119.77274, 36.77054], [-119.7747, 36.77054], [-119.7747, 36.77217]]]} | Open Access 1 | 1896 | Radio Park | 24069 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 7.461 | Radio Park | 0 | Local Park 2 | 4 | |
635 | 635 | 634 | {"type": "Polygon", "coordinates": [[[-119.77627, 36.79171], [-119.77626, 36.7921], [-119.77622, 36.79217], [-119.77614, 36.79222], [-119.77607, 36.79223], [-119.77477, 36.79223], [-119.77479, 36.79156], [-119.7761, 36.79158], [-119.77621, 36.79162], [-119.77627, 36.79171]]]} | Open Access 1 | 2573 | University Park | 26686 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 2.376 | University Park | 0 | Local Park 2 | 4 | |
6374 | 6374 | 6373 | {"type": "Polygon", "coordinates": [[[-119.77927, 36.84098], [-119.77927, 36.84288], [-119.77707, 36.84288], [-119.77708, 36.84133], [-119.77769, 36.84134], [-119.77794, 36.84127], [-119.77843, 36.84127], [-119.77869, 36.84135], [-119.77899, 36.84134], [-119.77918, 36.84111], [-119.77919, 36.84097], [-119.77927, 36.84098]]]} | Restricted Access 2 | 1738 | Harry Goorabian Park | 31253 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.566 | Harry Goorabian Park | 0 | Local Park 2 | 4 | |
397 | 397 | 396 | {"type": "Polygon", "coordinates": [[[-119.77928, 36.8429], [-119.77926, 36.84455], [-119.77813, 36.84457], [-119.77814, 36.84285], [-119.77928, 36.8429]]]} | Open Access 1 | 1179 | Kaiser Park | 20544 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 4.696 | Kaiser Park | 0 | Local Park 2 | 4 | |
6435 | 6435 | 6434 | {"type": "Polygon", "coordinates": [[[-119.78116, 36.81757], [-119.78115, 36.81926], [-119.77913, 36.81924], [-119.77909, 36.81757], [-119.78116, 36.81757]]]} | Open Access 1 | 1991 | Robinson Park | 24502 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | Fresno 9 | 8.389 | Robinson 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]);