units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
95 rows where MNG_AGENCY = 14 sorted by SUID_NMA descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7281 | 7281 | 7280 | {"type": "Polygon", "coordinates": [[[-119.85946, 36.77405], [-119.85882, 36.77405], [-119.85878, 36.77397], [-119.85869, 36.77392], [-119.85806, 36.77392], [-119.858, 36.77393], [-119.85794, 36.77396], [-119.85791, 36.774], [-119.85789, 36.77406], [-119.85725, 36.77406], [-119.85727, 36.77397], [-119.85732, 36.7739], [-119.85734, 36.77374], [-119.85734, 36.77366], [-119.85729, 36.77359], [-119.85721, 36.77327], [-119.8572, 36.77314], [-119.85724, 36.77311], [-119.85724, 36.77327], [-119.85731, 36.77351], [-119.85762, 36.77351], [-119.8577, 36.77345], [-119.85786, 36.77349], [-119.85801, 36.77349], [-119.85816, 36.77344], [-119.85816, 36.77322], [-119.85813, 36.77319], [-119.85816, 36.77314], [-119.85817, 36.77309], [-119.85814, 36.77303], [-119.85809, 36.77299], [-119.85809, 36.77244], [-119.85794, 36.77232], [-119.85794, 36.77225], [-119.85788, 36.77218], [-119.85788, 36.77204], [-119.85791, 36.77202], [-119.85823, 36.77202], [-119.85828, 36.77199], [-119.85837, 36.77199], [-119.85837, 36.77221], [-119.85829, 36.77217], [-119.85819, 36.77217], [-119.85811, 36.77222], [-119.85809, 36.7723], [-119.8581, 36.77235], [-119.85815, 36.77239], [-119.85821, 36.77242], [-119.85829, 36.77242], [-119.85829, 36.77297], [-119.85841, 36.77306], [-119.85841, 36.77313], [-119.85845, 36.77319], [-119.85841, 36.77322], [-119.85842, 36.77343], [-119.85857, 36.77348], [-119.85865, 36.77348], [-119.85888, 36.77338], [-119.85903, 36.77338], [-119.85911, 36.7735], [-119.85946, 36.7735], [-119.85943, 36.77359], [-119.85939, 36.77365], [-119.85938, 36.77374], [-119.8594, 36.77391], [-119.85945, 36.77397], [-119.85946, 36.77405]]]} | Open Access 1 | 48940 | Westwood Park | 33656 | 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 | 3.656 | Westwood Park | 0 | Local Park 2 | 4 | |
4807 | 4807 | 4806 | {"type": "MultiPolygon", "coordinates": [[[[-119.67174, 36.72576], [-119.66919, 36.72576], [-119.66915, 36.72573], [-119.66915, 36.72558], [-119.67174, 36.72558], [-119.67174, 36.72576]]], [[[-119.82535, 36.71988], [-119.82534, 36.72036], [-119.82506, 36.72036], [-119.82504, 36.72034], [-119.82504, 36.7199], [-119.82507, 36.71989], [-119.82535, 36.71988]]]]} | Open Access 1 | 48591 | Unknown park - Fresno, City of | 33300 | 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 | 1.496 | 0 | Local Other or Unknown 14 | 4 | ||
15707 | 15707 | 15706 | {"type": "Polygon", "coordinates": [[[-119.71112, 36.77661], [-119.71034, 36.77693], [-119.71087, 36.77789], [-119.7109, 36.77817], [-119.71106, 36.77893], [-119.71107, 36.77916], [-119.71098, 36.77922], [-119.71095, 36.7793], [-119.70509, 36.77924], [-119.70404, 36.77885], [-119.70354, 36.77875], [-119.70312, 36.77872], [-119.70259, 36.77873], [-119.70203, 36.77891], [-119.70122, 36.77919], [-119.70095, 36.77921], [-119.7011, 36.77741], [-119.70133, 36.77645], [-119.70172, 36.77585], [-119.7019, 36.7757], [-119.70334, 36.77575], [-119.70395, 36.77575], [-119.70417, 36.77573], [-119.7044, 36.77567], [-119.7046, 36.77557], [-119.70476, 36.77545], [-119.70509, 36.77507], [-119.70515, 36.77506], [-119.70642, 36.77578], [-119.70767, 36.77435], [-119.70773, 36.77432], [-119.7078, 36.77432], [-119.70787, 36.77434], [-119.70931, 36.77518], [-119.71086, 36.77614], [-119.71112, 36.77661]]]} | Restricted Access 2 | 25456 | Airways Municipal Golf Course | 33086 | 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 | 88.161 | Airways Municipal GC | 0 | Local Recreation Area 3 | 4 | |
3892 | 3892 | 3891 | {"type": "Polygon", "coordinates": [[[-119.89564, 36.80259], [-119.8936, 36.8026], [-119.89359, 36.80089], [-119.89393, 36.80088], [-119.89394, 36.80093], [-119.89471, 36.8009], [-119.89537, 36.80089], [-119.8954, 36.80092], [-119.89541, 36.80141], [-119.89563, 36.80212], [-119.89564, 36.80259]]]} | Open Access 1 | 46815 | Inspiration Park | 32570 | 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.973 | Inspiration Park | 2015 | 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 | |
209 | 209 | 208 | {"type": "Polygon", "coordinates": [[[-119.80506, 36.72867], [-119.80285, 36.72866], [-119.80276, 36.7286], [-119.80374, 36.72791], [-119.80416, 36.72827], [-119.80436, 36.7284], [-119.80469, 36.72856], [-119.80505, 36.72866], [-119.80506, 36.72867]]]} | Open Access 1 | 47327 | Kearney and Fresno Pocket Park | 31034 | 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 | 1.936 | Kearney and Fresno PP | 0 | Local Park 2 | 4 | |
5973 | 5973 | 5972 | {"type": "Polygon", "coordinates": [[[-119.79755, 36.72125], [-119.79751, 36.72155], [-119.79706, 36.72174], [-119.79668, 36.72196], [-119.79665, 36.72195], [-119.79658, 36.72188], [-119.79655, 36.7218], [-119.79655, 36.72146], [-119.79697, 36.72146], [-119.79702, 36.72143], [-119.79706, 36.72138], [-119.79706, 36.72125], [-119.79755, 36.72125]]]} | Open Access 1 | 47326 | Tupman Pocket Park | 31033 | 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.96 | Tupman PP | 0 | Local Park 2 | 4 | |
198 | 198 | 197 | {"type": "MultiPolygon", "coordinates": [[[[-119.79639, 36.72267], [-119.796, 36.72295], [-119.79592, 36.72287], [-119.7963, 36.7226], [-119.79639, 36.72267]]], [[[-119.79685, 36.72239], [-119.79647, 36.72266], [-119.79635, 36.72256], [-119.79673, 36.72229], [-119.79685, 36.72239]]], [[[-119.79744, 36.72197], [-119.79706, 36.72225], [-119.79699, 36.72218], [-119.79699, 36.72216], [-119.79707, 36.72211], [-119.79736, 36.72197], [-119.79741, 36.72194], [-119.79744, 36.72197]]]]} | Open Access 1 | 47324 | California and Mayor Pocket Park | 31028 | 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.396 | California and Mayor PP | 0 | Local Park 2 | 4 | |
8192 | 8192 | 8191 | {"type": "Polygon", "coordinates": [[[-119.8023, 36.74348], [-119.80198, 36.74349], [-119.80205, 36.74325], [-119.80206, 36.74326], [-119.8023, 36.74348]]]} | Open Access 1 | 47321 | Broadway Pocket Park | 31027 | 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.09 | Broadway PP | 0 | Local Park 2 | 4 | |
4115 | 4115 | 4114 | {"type": "Polygon", "coordinates": [[[-119.8102, 36.72512], [-119.81019, 36.72533], [-119.8099, 36.72533], [-119.8102, 36.72512], [-119.8102, 36.72512]]]} | Open Access 1 | 47320 | Merced and Modoc Pocket Park | 31026 | 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.075 | Merced and Modoc PP | 0 | Local Park 2 | 4 | |
5027 | 5027 | 5026 | {"type": "Polygon", "coordinates": [[[-119.80571, 36.72831], [-119.8057, 36.72842], [-119.80555, 36.72842], [-119.80571, 36.72831], [-119.80571, 36.72831]]]} | Open Access 1 | 47319 | Merced and Pickford Pocket Park | 31025 | 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.022 | Merced and Pickford PP | 0 | Local Park 2 | 4 | |
5944 | 5944 | 5943 | {"type": "Polygon", "coordinates": [[[-119.74575, 36.73906], [-119.74575, 36.73914], [-119.74558, 36.73914], [-119.74558, 36.73906], [-119.74575, 36.73906]]]} | Open Access 1 | 47318 | Maple and Blach Pocket Park | 31024 | 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.032 | Maple and Blach PP | 0 | Local Park 2 | 4 | |
179 | 179 | 178 | {"type": "Polygon", "coordinates": [[[-119.81169, 36.72405], [-119.81168, 36.72428], [-119.81137, 36.72428], [-119.81169, 36.72405], [-119.81169, 36.72405]]]} | Open Access 1 | 47316 | Merced and Plumas Pocket Park | 31023 | 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.087 | Merced and Plumas PP | 0 | Local Park 2 | 4 | |
178 | 178 | 177 | {"type": "Polygon", "coordinates": [[[-119.87918, 36.84588], [-119.87897, 36.84588], [-119.87868, 36.84562], [-119.87868, 36.84536], [-119.87885, 36.84521], [-119.87913, 36.84521], [-119.87916, 36.84522], [-119.87918, 36.84588]]]} | Open Access 1 | 47315 | Milburn Overlook Pocket Park | 31022 | 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.682 | Milburn Overlook PP | 0 | Local Park 2 | 4 | |
5935 | 5935 | 5934 | {"type": "Polygon", "coordinates": [[[-119.79717, 36.7505], [-119.79716, 36.75054], [-119.79712, 36.75055], [-119.79669, 36.7507], [-119.79669, 36.75072], [-119.79608, 36.75095], [-119.79521, 36.75121], [-119.79516, 36.7512], [-119.79512, 36.75115], [-119.79511, 36.75056], [-119.79515, 36.75052], [-119.79644, 36.75054], [-119.79717, 36.7505]]]} | Open Access 1 | 47314 | San Pablo Pocket Park | 31021 | 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 | 1.9 | San Pablo PP | 0 | Local Park 2 | 4 | |
3769 | 3769 | 3768 | {"type": "Polygon", "coordinates": [[[-119.85853, 36.83271], [-119.85849, 36.83274], [-119.85745, 36.83274], [-119.8574, 36.83271], [-119.85741, 36.83201], [-119.85745, 36.83197], [-119.85754, 36.83198], [-119.8576, 36.832], [-119.85848, 36.83263], [-119.85853, 36.83271]]]} | Open Access 1 | 47313 | Emerald Pocket Park | 31020 | 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 | 1.276 | Emerald PP | 0 | Local Park 2 | 4 | |
3622 | 3622 | 3621 | {"type": "Polygon", "coordinates": [[[-119.79574, 36.86151], [-119.79571, 36.86193], [-119.79566, 36.86217], [-119.79552, 36.86243], [-119.79533, 36.86264], [-119.79448, 36.86334], [-119.79445, 36.86334], [-119.79405, 36.86302], [-119.79425, 36.86289], [-119.79478, 36.86239], [-119.79531, 36.86194], [-119.79547, 36.86178], [-119.79564, 36.86155], [-119.79574, 36.86151]]]} | Open Access 1 | 47312 | Audubon Pocket Park | 31019 | 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 | 2.439 | Audubon PP | 0 | Local Park 2 | 4 | |
3614 | 3614 | 3613 | {"type": "Polygon", "coordinates": [[[-119.69873, 36.71265], [-119.69869, 36.71268], [-119.69834, 36.7127], [-119.69828, 36.71268], [-119.6982, 36.71257], [-119.6981, 36.71246], [-119.69839, 36.71238], [-119.69873, 36.71238], [-119.69873, 36.71265]]]} | Open Access 1 | 47311 | Centex Pocket Park | 31018 | 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.393 | Centex PP | 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 | |
3609 | 3609 | 3608 | {"type": "Polygon", "coordinates": [[[-119.70709, 36.71049], [-119.70709, 36.71064], [-119.70641, 36.71063], [-119.70641, 36.71049], [-119.70643, 36.71047], [-119.70707, 36.71047], [-119.70709, 36.71049]]]} | Open Access 1 | 47306 | Rabe Pocket Park | 31013 | 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.268 | Rabe PP | 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]);