superunits_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_NAME
This data as json, copyable, CSV (advanced)
Link | rowid | id | map | ACCESS_TYP | PARK_NAME ▼ | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13378 | 13378 | 13377 | {"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.86048], [-119.6405, 36.86041], [-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.64013, 36.86016], [-119.64004, 36.86025], [-119.64004, 36.86027], [-119.63998, 36.86031], [-119.63993, 36.86029], [-119.63989, 36.86029], [-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.64142, 36.85936], [-119.64144, 36.85937], [-119.64146, 36.86082]]]} | Open Access 1 | Harlan Ranch Community Park | https://www.visitclovis.com/clovis-parks/ | 33431 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 3.577 | Harlan Ranch Community Park | |
13556 | 13556 | 13555 | {"type": "Polygon", "coordinates": [[[-119.7115, 36.79474], [-119.71149, 36.79491], [-119.70923, 36.79495], [-119.70923, 36.79464], [-119.70928, 36.79459], [-119.70973, 36.79456], [-119.71014, 36.7945], [-119.71114, 36.79423], [-119.71146, 36.79416], [-119.71146, 36.79424], [-119.71143, 36.79428], [-119.71144, 36.79468], [-119.7115, 36.79474]]]} | Open Access 1 | Helm Ranch Community Park | 30988 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.785 | Helm Ranch Community Park | ||
5506 | 5506 | 5505 | {"type": "Polygon", "coordinates": [[[-119.6864, 36.80973], [-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.68363, 36.81035], [-119.68365, 36.81022], [-119.68383, 36.81021], [-119.68383, 36.80955], [-119.68326, 36.80953], [-119.6832, 36.80945], [-119.68322, 36.80916], [-119.68326, 36.80914], [-119.68327, 36.809], [-119.68334, 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]]]} | Open Access 1 | Jefferson Park | 20380 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 11.314 | Jefferson Park | ||
3616 | 3616 | 3615 | {"type": "MultiPolygon", "coordinates": [[[[-119.64659, 36.80783], [-119.64648, 36.80788], [-119.64648, 36.80818], [-119.64618, 36.80818], [-119.64619, 36.80776], [-119.64638, 36.80776], [-119.64655, 36.80769], [-119.64655, 36.80777], [-119.64659, 36.80783]]], [[[-119.64922, 36.80536], [-119.64902, 36.80567], [-119.64892, 36.80597], [-119.64893, 36.80601], [-119.64884, 36.80608], [-119.64882, 36.80613], [-119.64883, 36.80618], [-119.64879, 36.80619], [-119.6484, 36.80678], [-119.6484, 36.80681], [-119.64835, 36.80684], [-119.6483, 36.8069], [-119.64828, 36.80695], [-119.6483, 36.80702], [-119.64826, 36.80704], [-119.64816, 36.8074], [-119.64753, 36.8074], [-119.64698, 36.80742], [-119.64697, 36.80771], [-119.64682, 36.80771], [-119.64678, 36.80768], [-119.64678, 36.80729], [-119.64802, 36.80725], [-119.64811, 36.80697], [-119.64809, 36.80694], [-119.64815, 36.80687], [-119.64815, 36.8068], [-119.6482, 36.80678], [-119.6486, 36.80619], [-119.64859, 36.80615], [-119.64864, 36.80612], [-119.64869, 36.80607], [-119.6487, 36.80602], [-119.64868, 36.80595], [-119.64872, 36.80593], [-119.64889, 36.80557], [-119.64896, 36.80532], [-119.64922, 36.80536]]], [[[-119.65483, 36.80511], [-119.65483, 36.80522], [-119.65164, 36.80522], [-119.65161, 36.80508], [-119.65219, 36.80513], [-119.65228, 36.80511], [-119.65308, 36.80511], [-119.65312, 36.80508], [-119.65324, 36.80512], [-119.65336, 36.80509], [-119.65339, 36.80511], [-119.65415, 36.80511], [-119.65418, 36.80509], [-119.6543, 36.80512], [-119.65441, 36.80509], [-119.65444, 36.80511], [-119.65483, 36.80511]]]]} | Open Access 1 | Jefferson Trail | 33291 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.764 | Jefferson Trail | ||
742 | 742 | 741 | {"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 | Kiwanis Pocket Park | 20684 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.196 | Kiwanis PP | ||
13989 | 13989 | 13988 | {"type": "MultiPolygon", "coordinates": [[[[-119.70632, 36.86297], [-119.7063, 36.86309], [-119.70618, 36.86318], [-119.70604, 36.86324], [-119.70605, 36.86297], [-119.70632, 36.86297]]], [[[-119.70745, 36.86319], [-119.70703, 36.86364], [-119.70606, 36.86364], [-119.70606, 36.86342], [-119.70611, 36.86337], [-119.70621, 36.86333], [-119.7063, 36.86328], [-119.70643, 36.86318], [-119.70672, 36.86311], [-119.70733, 36.86312], [-119.70743, 36.86313], [-119.70745, 36.86319]]]]} | Open Access 1 | Lennar Park | 33284 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.494 | Lennar Park | ||
6125 | 6125 | 6124 | {"type": "Polygon", "coordinates": [[[-119.71617, 36.81755], [-119.71573, 36.81793], [-119.71532, 36.81861], [-119.71505, 36.81937], [-119.71501, 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 | Letterman Park | 21185 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 11.27 | Letterman Park | ||
6170 | 6170 | 6169 | {"type": "Polygon", "coordinates": [[[-119.72301, 36.79798], [-119.72278, 36.79798], [-119.72278, 36.79769], [-119.723, 36.7977], [-119.72301, 36.79798]]]} | Open Access 1 | Lift Station Pocket Park | 21229 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.154 | Lift Station PP | ||
6230 | 6230 | 6229 | {"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 | Linear Park | 21305 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 5.953 | Linear Park | ||
9512 | 9512 | 9511 | {"type": "Polygon", "coordinates": [[[-119.65164, 36.80532], [-119.65136, 36.8054], [-119.65113, 36.80545], [-119.65079, 36.80547], [-119.65055, 36.80544], [-119.64925, 36.8052], [-119.64921, 36.80516], [-119.64923, 36.80495], [-119.64927, 36.80492], [-119.65057, 36.80492], [-119.65085, 36.80494], [-119.65161, 36.80508], [-119.65164, 36.80522], [-119.65164, 36.80532]]]} | Open Access 1 | Los Arbolitos Park | 33290 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 2.464 | Los Arbolitos Park | ||
7129 | 7129 | 7128 | {"type": "Polygon", "coordinates": [[[-119.67123, 36.81353], [-119.67122, 36.81411], [-119.67067, 36.8141], [-119.67047, 36.81407], [-119.6705, 36.81386], [-119.67056, 36.81369], [-119.67057, 36.81361], [-119.67062, 36.81351], [-119.67123, 36.81353]]]} | Open Access 1 | Monte Vista 10 Park | 22395 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.995 | Monte Vista 10 Park | ||
7130 | 7130 | 7129 | {"type": "Polygon", "coordinates": [[[-119.66797, 36.81743], [-119.66784, 36.818], [-119.66759, 36.81799], [-119.66734, 36.81801], [-119.6673, 36.81799], [-119.66719, 36.81776], [-119.66704, 36.8175], [-119.66706, 36.81747], [-119.66709, 36.81747], [-119.66743, 36.81742], [-119.66771, 36.81741], [-119.66797, 36.81743]]]} | Open Access 1 | Monte Vista 21 Park | 22396 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.034 | Monte Vista 21 Park | ||
7131 | 7131 | 7130 | {"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 | Monte Vista 26 Park | 22397 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.279 | Monte Vista 26 Park | ||
7132 | 7132 | 7131 | {"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 | Monte Vista 31 Park | 22398 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.451 | Monte Vista 31 Park | ||
13991 | 13991 | 13990 | {"type": "Polygon", "coordinates": [[[-119.69353, 36.82035], [-119.69353, 36.82052], [-119.69309, 36.82052], [-119.69312, 36.82035], [-119.69353, 36.82035]]]} | Open Access 1 | Music Avenue Park | 33298 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.174 | Music Avenue Park | ||
7496 | 7496 | 7495 | {"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 | Northwood Park | 22901 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 0.444 | Northwood Park | ||
10544 | 10544 | 10543 | {"type": "Polygon", "coordinates": [[[-119.65069, 36.81251], [-119.65065, 36.81255], [-119.65012, 36.81255], [-119.65007, 36.81251], [-119.65007, 36.81151], [-119.65059, 36.81151], [-119.65069, 36.81159], [-119.65069, 36.81251]]]} | Open Access 1 | Palmina Park | 33289 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.561 | Palmina Park | ||
10519 | 10519 | 10518 | {"type": "Polygon", "coordinates": [[[-119.64776, 36.81683], [-119.6474, 36.81712], [-119.64603, 36.81712], [-119.64603, 36.81573], [-119.64776, 36.81573], [-119.64776, 36.81683]]]} | Open Access 1 | Pasa Tiempo Park | 33288 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 5.778 | Pasa Tiempo Park | ||
8039 | 8039 | 8038 | {"type": "Polygon", "coordinates": [[[-119.72006, 36.8449], [-119.72006, 36.84705], [-119.71751, 36.84488], [-119.71751, 36.84488], [-119.72006, 36.8449]]]} | Open Access 1 | Peach/Alluvial Park | 23541 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 6.733 | Peach/Alluvial Park | ||
10500 | 10500 | 10499 | {"type": "Polygon", "coordinates": [[[-119.71553, 36.86337], [-119.71552, 36.86421], [-119.71506, 36.86414], [-119.71502, 36.8641], [-119.71503, 36.8633], [-119.71507, 36.86328], [-119.71553, 36.86337]]]} | Open Access 1 | Pinnacles Park | 33286 | 1060 | Clovis, City of 462 | City 2 | City Agency 2 | http://www.ci.clovis.ca.us/Departments-and-Services/Public-Utilities/Parks | City 2 | 1.026 | Pinnacles Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);