units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
62 rows where MNG_AGENCY = 462 and MNG_AG_TYP = 2 sorted by PARK_URL descending
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11453 | 11453 | 11452 | {"type": "Polygon", "coordinates": [[[-119.64146, 36.86082], [-119.64061, 36.86083], [-119.64054, 36.86081], [-119.64033, 36.86071], [-119.64039, 36.86063], [-119.64038, 36.86058], [-119.64034, 36.86054], [-119.64039, 36.86048], [-119.64043, 36.86049], [-119.64051, 36.8604], [-119.64048, 36.86038], [-119.64055, 36.86031], [-119.64068, 36.86025], [-119.64076, 36.86015], [-119.64076, 36.86006], [-119.64074, 36.85999], [-119.64069, 36.85994], [-119.6406, 36.85989], [-119.64045, 36.85988], [-119.64032, 36.85992], [-119.64025, 36.86], [-119.64022, 36.8601], [-119.64016, 36.86016], [-119.64014, 36.86015], [-119.64003, 36.86026], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86028], [-119.63977, 36.86035], [-119.63963, 36.86019], [-119.63964, 36.86015], [-119.64081, 36.85949], [-119.64109, 36.85938], [-119.64137, 36.85932], [-119.64141, 36.85934], [-119.64141, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | 48696 | Harlan Ranch Community Park | 33431 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | https://www.visitclovis.com/clovis-parks/ | Fresno 9 | 3.576 | Harlan Ranch Community Park | 0 | Local Park 2 | 4 |
14469 | 14469 | 14468 | {"type": "Polygon", "coordinates": [[[-119.74078, 36.76666], [-119.74078, 36.76756], [-119.73882, 36.76755], [-119.73863, 36.76741], [-119.73864, 36.76569], [-119.73984, 36.7657], [-119.73982, 36.76611], [-119.73979, 36.76627], [-119.73981, 36.76632], [-119.73994, 36.76646], [-119.74007, 36.76659], [-119.7402, 36.76665], [-119.74078, 36.76666]]]} | Open Access 1 | 47100 | Basin V Park | 30759 | 2036 | Fresno Metropolitan Flood Control District 29 | Special District 4 | Flood District 8 | http://www.fresnofloodcontrol.org/ | Special District 4 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.fresnofloodcontrol.org/wp-content/uploads/2015/01/Map-of-parks.pdf | Fresno 9 | 7.59 | Basin V Park | 0 | Local Park 2 | 4 |
15020 | 15020 | 15019 | {"type": "Polygon", "coordinates": [[[-119.65948, 36.80526], [-119.65948, 36.80591], [-119.65943, 36.80595], [-119.65932, 36.80594], [-119.65899, 36.80589], [-119.65869, 36.80578], [-119.65817, 36.80552], [-119.6581, 36.80542], [-119.65802, 36.80537], [-119.65792, 36.80535], [-119.65781, 36.80537], [-119.65758, 36.80531], [-119.65724, 36.80527], [-119.65717, 36.80524], [-119.65717, 36.80511], [-119.65756, 36.80478], [-119.65764, 36.80478], [-119.6577, 36.80477], [-119.65774, 36.80474], [-119.6578, 36.80467], [-119.65787, 36.80464], [-119.65816, 36.80464], [-119.65822, 36.80466], [-119.65832, 36.80475], [-119.6584, 36.80477], [-119.65852, 36.80474], [-119.65858, 36.80465], [-119.65864, 36.80465], [-119.65864, 36.80506], [-119.65899, 36.80507], [-119.65901, 36.80515], [-119.65909, 36.8052], [-119.65916, 36.80522], [-119.65943, 36.80522], [-119.65948, 36.80526]]]} | Open Access 1 | 45667 | Thorburn Park | 28484 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | Fresno 9 | 3.907 | Thorburn Park | 0 | Local Park 2 | 4 |
2005 | 2005 | 2004 | {"type": "Polygon", "coordinates": [[[-119.68907, 36.79478], [-119.68907, 36.79478], [-119.6883, 36.79422], [-119.68889, 36.79423], [-119.68907, 36.79478]]]} | Open Access 1 | 16909 | Basin IE Park | 15850 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.401 | Basin IE Park | 0 | Local Park 2 | 4 | |
2023 | 2023 | 2022 | {"type": "Polygon", "coordinates": [[[-119.66019, 36.83627], [-119.65963, 36.83626], [-119.6595, 36.83624], [-119.65749, 36.83624], [-119.65748, 36.83579], [-119.6595, 36.83579], [-119.65995, 36.83582], [-119.66001, 36.83603], [-119.66019, 36.83627]]]} | Open Access 1 | 17012 | Cedarwood Park | 17003 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 2.832 | Cedarwood Park | 0 | Local Park 2 | 4 | |
2168 | 2168 | 2167 | {"type": "Polygon", "coordinates": [[[-119.67094, 36.84746], [-119.67055, 36.84751], [-119.67054, 36.84701], [-119.67091, 36.84701], [-119.67094, 36.84746]]]} | Open Access 1 | 17643 | Northwood Park | 22901 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.444 | Northwood Park | 0 | Local Park 2 | 4 | |
2223 | 2223 | 2222 | {"type": "Polygon", "coordinates": [[[-119.66782, 36.7926], [-119.66782, 36.79282], [-119.66779, 36.79318], [-119.66729, 36.79318], [-119.66729, 36.79286], [-119.66733, 36.79255], [-119.66772, 36.79257], [-119.66782, 36.7926]]]} | Open Access 1 | 17929 | Seville II Park | 25328 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.767 | Seville II Park | 0 | Local Park 2 | 4 | |
2302 | 2302 | 2301 | {"type": "Polygon", "coordinates": [[[-119.72538, 36.84211], [-119.72536, 36.84239], [-119.72493, 36.84241], [-119.72462, 36.84237], [-119.72461, 36.84214], [-119.72494, 36.8421], [-119.72538, 36.84211]]]} | Open Access 1 | 16941 | Birchwood Park | 16120 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.53 | Birchwood Park | 0 | Local Park 2 | 4 | |
2314 | 2314 | 2313 | {"type": "Polygon", "coordinates": [[[-119.69752, 36.84242], [-119.697, 36.84242], [-119.69698, 36.84194], [-119.69719, 36.84192], [-119.6975, 36.84192], [-119.69752, 36.84242]]]} | Open Access 1 | 16974 | Blackhorse II Park | 16143 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.623 | Blackhorse II Park | 0 | Local Park 2 | 4 | |
2413 | 2413 | 2412 | {"type": "Polygon", "coordinates": [[[-119.67634, 36.79757], [-119.67634, 36.7984], [-119.67531, 36.79843], [-119.67412, 36.79843], [-119.67412, 36.79823], [-119.67405, 36.79822], [-119.67406, 36.79755], [-119.67595, 36.79757], [-119.67634, 36.79757]]]} | Open Access 1 | 17254 | Gettysburg Park | 19281 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 4.762 | Gettysburg Park | 0 | Local Park 2 | 4 | |
2422 | 2422 | 2421 | {"type": "Polygon", "coordinates": [[[-119.6864, 36.80987], [-119.68636, 36.81025], [-119.68636, 36.81069], [-119.68477, 36.8107], [-119.68461, 36.81066], [-119.68453, 36.81068], [-119.68448, 36.81072], [-119.68445, 36.81078], [-119.68445, 36.81084], [-119.68256, 36.81084], [-119.68258, 36.81056], [-119.68273, 36.81054], [-119.68279, 36.8105], [-119.68317, 36.81047], [-119.68319, 36.81037], [-119.68364, 36.81035], [-119.68365, 36.81022], [-119.68383, 36.81021], [-119.68384, 36.80955], [-119.68326, 36.80953], [-119.6832, 36.80945], [-119.68322, 36.80916], [-119.68326, 36.80914], [-119.68327, 36.809], [-119.68335, 36.80899], [-119.68335, 36.80891], [-119.68345, 36.80887], [-119.6835, 36.80877], [-119.685, 36.80877], [-119.685, 36.80973], [-119.6864, 36.80973], [-119.6864, 36.80987]]]} | Open Access 1 | 17286 | Jefferson Park | 20380 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 11.303 | Jefferson Park | 0 | Local Park 2 | 4 | |
2437 | 2437 | 2436 | {"type": "Polygon", "coordinates": [[[-119.70433, 36.81802], [-119.70414, 36.81802], [-119.70414, 36.8176], [-119.70433, 36.8176], [-119.70433, 36.81802]]]} | Open Access 1 | 17319 | Kiwanis Pocket Park | 20684 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.196 | Kiwanis PP | 0 | Local Park 2 | 4 | |
2443 | 2443 | 2442 | {"type": "Polygon", "coordinates": [[[-119.71617, 36.81755], [-119.71573, 36.81793], [-119.71532, 36.81861], [-119.71505, 36.81937], [-119.71502, 36.81938], [-119.71474, 36.81969], [-119.71464, 36.81984], [-119.71429, 36.82022], [-119.71413, 36.82034], [-119.71359, 36.82067], [-119.71352, 36.82067], [-119.71358, 36.81756], [-119.71617, 36.81755]]]} | Open Access 1 | 17352 | Letterman Park | 21185 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 11.27 | Letterman Park | 0 | Local Park 2 | 4 | |
2466 | 2466 | 2465 | {"type": "MultiPolygon", "coordinates": [[[[-119.66748, 36.82655], [-119.66743, 36.82659], [-119.66445, 36.82655], [-119.66409, 36.82656], [-119.66413, 36.82635], [-119.66427, 36.82638], [-119.6648, 36.82638], [-119.66523, 36.82635], [-119.66698, 36.82636], [-119.66746, 36.82639], [-119.66748, 36.82655]]], [[[-119.66833, 36.8264], [-119.66833, 36.82657], [-119.6677, 36.82659], [-119.66766, 36.82655], [-119.66765, 36.8264], [-119.66833, 36.8264]]], [[[-119.67176, 36.82639], [-119.67176, 36.82661], [-119.66854, 36.82659], [-119.66856, 36.82651], [-119.67025, 36.82651], [-119.67041, 36.82647], [-119.67068, 36.82639], [-119.67176, 36.82639]]], [[[-119.67278, 36.82662], [-119.67195, 36.82662], [-119.67196, 36.8265], [-119.67277, 36.82651], [-119.67278, 36.82662]]], [[[-119.67733, 36.82651], [-119.67724, 36.82653], [-119.67708, 36.8265], [-119.67473, 36.82648], [-119.67452, 36.82651], [-119.67427, 36.82657], [-119.67407, 36.82659], [-119.67382, 36.82658], [-119.67365, 36.82654], [-119.67354, 36.82657], [-119.67311, 36.82658], [-119.6731, 36.8264], [-119.67733, 36.82644], [-119.67733, 36.82651]]], [[[-119.67925, 36.82664], [-119.67921, 36.82667], [-119.67768, 36.82665], [-119.6776, 36.82664], [-119.67751, 36.82658], [-119.67751, 36.82644], [-119.67924, 36.82646], [-119.67925, 36.82664]]], [[[-119.68064, 36.82669], [-119.67943, 36.82668], [-119.67943, 36.82645], [-119.68063, 36.82647], [-119.68064, 36.82669]]]]} | Open Access 1 | 17415 | Linear Park | 21305 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 5.959 | Linear Park | 0 | Local Park 2 | 4 | |
2494 | 2494 | 2493 | {"type": "Polygon", "coordinates": [[[-119.68921, 36.83919], [-119.68885, 36.83919], [-119.6885, 36.83919], [-119.68853, 36.83903], [-119.68919, 36.83902], [-119.68921, 36.83919]]]} | Open Access 1 | 17523 | Monte Vista 26 Park | 22397 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.279 | Monte Vista 26 Park | 0 | Local Park 2 | 4 | |
2509 | 2509 | 2508 | {"type": "Polygon", "coordinates": [[[-119.6895, 36.8419], [-119.6895, 36.84242], [-119.68915, 36.84242], [-119.68915, 36.8419], [-119.6895, 36.8419]]]} | Open Access 1 | 17563 | Monte Vista 31 Park | 22398 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.451 | Monte Vista 31 Park | 0 | Local Park 2 | 4 | |
2536 | 2536 | 2535 | {"type": "Polygon", "coordinates": [[[-119.72006, 36.8449], [-119.72006, 36.84705], [-119.71751, 36.84488], [-119.72006, 36.84489], [-119.72006, 36.8449]]]} | Open Access 1 | 17760 | Peach/Alluvial Park | 23541 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 6.735 | Peach/Alluvial Park | 0 | Local Park 2 | 4 | |
2542 | 2542 | 2541 | {"type": "Polygon", "coordinates": [[[-119.69326, 36.83383], [-119.69114, 36.83381], [-119.69112, 36.83115], [-119.69109, 36.83041], [-119.69323, 36.83041], [-119.69326, 36.83383]]]} | Open Access 1 | 17971 | Sierra Bicentennial Park | 25447 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 17.659 | Sierra Bicentennial Park | 0 | Local Park 2 | 4 | |
2561 | 2561 | 2560 | {"type": "Polygon", "coordinates": [[[-119.71344, 36.81389], [-119.71341, 36.8156], [-119.71337, 36.81563], [-119.71008, 36.81563], [-119.71009, 36.81479], [-119.71047, 36.81478], [-119.71048, 36.81389], [-119.71344, 36.81389]]]} | Open Access 1 | 17848 | Rotary Park | 24688 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 13.352 | Rotary Park | 0 | Local Park 2 | 4 | |
2602 | 2602 | 2601 | {"type": "Polygon", "coordinates": [[[-119.67123, 36.81353], [-119.67122, 36.81411], [-119.67066, 36.8141], [-119.67047, 36.81407], [-119.6705, 36.81387], [-119.67056, 36.81369], [-119.67057, 36.81361], [-119.67062, 36.81351], [-119.67123, 36.81353]]]} | Open Access 1 | 17444 | Monte Vista 10 Park | 22395 | 1060 | Clovis, City of 469 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | Fresno 9 | 0.996 | Monte Vista 10 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]);