superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where ACCESS_TYP = 1, MNG_AGENCY = 601 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 16 ✖
MNG_AGENCY 1
- La Quinta, City of · 16 ✖
ACCESS_TYP 1
- Open Access · 16 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
407 | 407 | 406 | {"type": "Polygon", "coordinates": [[[-116.28792, 33.72583], [-116.28784, 33.7259], [-116.2878, 33.72599], [-116.28783, 33.72619], [-116.28783, 33.7267], [-116.28778, 33.72675], [-116.28649, 33.72675], [-116.28641, 33.72668], [-116.2864, 33.72548], [-116.28771, 33.72547], [-116.28792, 33.72583]]]} | Open Access 1 | Adams Park | 15261 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 4.604 | Adams Park | ||
1865 | 1865 | 1864 | {"type": "Polygon", "coordinates": [[[-116.31944, 33.65617], [-116.31918, 33.65617], [-116.3185, 33.65418], [-116.31837, 33.65365], [-116.3183, 33.65322], [-116.31823, 33.65242], [-116.31819, 33.65218], [-116.31798, 33.64925], [-116.31902, 33.64959], [-116.3191, 33.64989], [-116.31863, 33.6518], [-116.31858, 33.65226], [-116.31858, 33.65271], [-116.31862, 33.65302], [-116.31868, 33.65332], [-116.31944, 33.65617]]]} | Open Access 1 | Bear Creek Park | 15922 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 8.931 | Bear Creek Park | ||
2999 | 2999 | 2998 | {"type": "Polygon", "coordinates": [[[-116.2991, 33.67725], [-116.29848, 33.67726], [-116.29819, 33.67781], [-116.29846, 33.67792], [-116.29847, 33.67807], [-116.29667, 33.67807], [-116.29668, 33.67762], [-116.29641, 33.67711], [-116.29615, 33.67709], [-116.29614, 33.67642], [-116.29865, 33.67642], [-116.29897, 33.6765], [-116.2991, 33.67651], [-116.2991, 33.67725]]]} | Open Access 1 | Civic Center Campus | 17349 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 9.694 | Civic Ctr. Campus | ||
3026 | 3026 | 3025 | {"type": "Polygon", "coordinates": [[[-116.30786, 33.66029], [-116.30786, 33.66042], [-116.30753, 33.66042], [-116.30753, 33.65987], [-116.30781, 33.65987], [-116.30786, 33.65989], [-116.30786, 33.66029]]]} | Open Access 1 | Eisenhower Park | 18473 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 0.461 | Eisenhower Park | ||
3253 | 3253 | 3252 | {"type": "Polygon", "coordinates": [[[-116.31853, 33.64496], [-116.31761, 33.6462], [-116.31758, 33.6485], [-116.3173, 33.64876], [-116.3173, 33.64883], [-116.31172, 33.64883], [-116.31254, 33.64649], [-116.3122, 33.64593], [-116.31077, 33.64554], [-116.31032, 33.64357], [-116.30908, 33.64376], [-116.30861, 33.64167], [-116.30861, 33.6416], [-116.30865, 33.64154], [-116.30869, 33.64151], [-116.30905, 33.64131], [-116.30976, 33.64143], [-116.31242, 33.64199], [-116.31269, 33.64202], [-116.31365, 33.64201], [-116.3139, 33.64205], [-116.31418, 33.64212], [-116.31449, 33.64226], [-116.31586, 33.64307], [-116.31605, 33.64317], [-116.31795, 33.64383], [-116.31789, 33.64404], [-116.31853, 33.64496]]]} | Open Access 1 | Cove Oasis Trailhead | 17722 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 114.396 | Cove Oasis Trailhead | ||
3584 | 3584 | 3583 | {"type": "Polygon", "coordinates": [[[-116.28859, 33.71998], [-116.28844, 33.72003], [-116.28827, 33.72003], [-116.2881, 33.71999], [-116.28795, 33.7199], [-116.28785, 33.71979], [-116.2878, 33.71967], [-116.28778, 33.71958], [-116.28778, 33.71935], [-116.28783, 33.7193], [-116.28805, 33.7193], [-116.28815, 33.71932], [-116.28833, 33.7194], [-116.2884, 33.71941], [-116.28844, 33.71973], [-116.28859, 33.71998]]]} | Open Access 1 | Desert Pride Park | 18113 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 1.052 | Desert Pride Park | ||
4388 | 4388 | 4387 | {"type": "Polygon", "coordinates": [[[-116.31953, 33.65617], [-116.32016, 33.6585], [-116.3202, 33.6588], [-116.32022, 33.6591], [-116.32022, 33.65941], [-116.32019, 33.65971], [-116.32012, 33.66008], [-116.32001, 33.66045], [-116.31986, 33.66081], [-116.31967, 33.66116], [-116.31951, 33.6614], [-116.31829, 33.66299], [-116.31802, 33.66341], [-116.31803, 33.66343], [-116.31811, 33.66343], [-116.31796, 33.66386], [-116.31783, 33.66438], [-116.31776, 33.6649], [-116.31774, 33.66544], [-116.31777, 33.66597], [-116.31786, 33.6665], [-116.31807, 33.66701], [-116.31724, 33.66614], [-116.31706, 33.6659], [-116.31692, 33.66566], [-116.31681, 33.6654], [-116.31671, 33.66501], [-116.31668, 33.66465], [-116.3167, 33.66433], [-116.31675, 33.66411], [-116.31682, 33.66389], [-116.31691, 33.66367], [-116.31704, 33.66343], [-116.31735, 33.66303], [-116.31797, 33.66244], [-116.31817, 33.66222], [-116.31838, 33.6619], [-116.31856, 33.6615], [-116.31863, 33.66127], [-116.31942, 33.65795], [-116.31946, 33.65772], [-116.31948, 33.65736], [-116.31944, 33.65703], [-116.31937, 33.65676], [-116.31918, 33.65617], [-116.31953, 33.65617]]]} | Open Access 1 | Fred Wolff Nature Preserve | 19077 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 22.527 | Fred Wolff Nature Preserve | ||
4433 | 4433 | 4432 | {"type": "Polygon", "coordinates": [[[-116.30351, 33.67104], [-116.30351, 33.67248], [-116.30234, 33.67247], [-116.30196, 33.67252], [-116.30178, 33.67256], [-116.3018, 33.67191], [-116.30183, 33.67187], [-116.30195, 33.67188], [-116.302, 33.67183], [-116.30199, 33.67117], [-116.3024, 33.67115], [-116.3024, 33.67097], [-116.30338, 33.67096], [-116.30351, 33.67104]]]} | Open Access 1 | Fritz Burns Park | 19127 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 5.977 | Fritz Burns Park | ||
5842 | 5842 | 5841 | {"type": "Polygon", "coordinates": [[[-116.28611, 33.71638], [-116.28603, 33.71638], [-116.28603, 33.71592], [-116.28556, 33.71592], [-116.28554, 33.71639], [-116.28186, 33.71641], [-116.28184, 33.71468], [-116.2861, 33.71466], [-116.28611, 33.71638]]]} | Open Access 1 | La Quinta Park | 20802 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 18.123 | La Quinta Park | ||
5843 | 5843 | 5842 | {"type": "Polygon", "coordinates": [[[-116.29081, 33.68568], [-116.28908, 33.68808], [-116.28876, 33.68847], [-116.28849, 33.68876], [-116.28801, 33.6892], [-116.28737, 33.68968], [-116.28667, 33.69011], [-116.28604, 33.69042], [-116.28603, 33.68854], [-116.28736, 33.68853], [-116.28749, 33.68851], [-116.28756, 33.68844], [-116.28755, 33.68734], [-116.28848, 33.68734], [-116.28857, 33.68729], [-116.28858, 33.68715], [-116.28858, 33.68686], [-116.28853, 33.68679], [-116.28841, 33.68678], [-116.28839, 33.68553], [-116.2904, 33.68553], [-116.29041, 33.68561], [-116.29081, 33.68568]]]} | Open Access 1 | La Quinta Sports Complex | 20803 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 20.425 | La Quinta Sports Complex | ||
7166 | 7166 | 7165 | {"type": "Polygon", "coordinates": [[[-116.27203, 33.72897], [-116.27196, 33.72903], [-116.2714, 33.72904], [-116.27139, 33.72858], [-116.2709, 33.72857], [-116.27089, 33.72682], [-116.27164, 33.72682], [-116.27164, 33.72754], [-116.27166, 33.72766], [-116.27174, 33.72789], [-116.27194, 33.72816], [-116.272, 33.72832], [-116.27203, 33.72847], [-116.27203, 33.72897]]]} | Open Access 1 | Monticello Park | 22439 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 4.627 | Monticello Park | ||
8183 | 8183 | 8182 | {"type": "Polygon", "coordinates": [[[-116.2919, 33.72053], [-116.29174, 33.72073], [-116.29161, 33.72096], [-116.29155, 33.72125], [-116.29155, 33.72158], [-116.29147, 33.72165], [-116.29073, 33.72165], [-116.29073, 33.7216], [-116.29122, 33.72158], [-116.29121, 33.72119], [-116.29072, 33.72119], [-116.29072, 33.72029], [-116.29158, 33.7203], [-116.29168, 33.72034], [-116.2919, 33.72053]]]} | Open Access 1 | Pioneer Park | 23723 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 2.697 | Pioneer Park | ||
9099 | 9099 | 9098 | {"type": "Polygon", "coordinates": [[[-116.29466, 33.68892], [-116.29462, 33.68895], [-116.29449, 33.68896], [-116.29449, 33.6884], [-116.2944, 33.68838], [-116.29436, 33.68835], [-116.2946, 33.68835], [-116.29465, 33.68839], [-116.29466, 33.68892]]]} | Open Access 1 | Saguaro Park | 24784 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 0.259 | Saguaro Park | ||
9468 | 9468 | 9467 | {"type": "Polygon", "coordinates": [[[-116.30097, 33.68143], [-116.30036, 33.68198], [-116.3002, 33.6821], [-116.29947, 33.68258], [-116.29933, 33.68264], [-116.29917, 33.68266], [-116.29895, 33.68263], [-116.29771, 33.68223], [-116.29677, 33.68185], [-116.29669, 33.6818], [-116.29655, 33.68165], [-116.2965, 33.68162], [-116.29643, 33.68163], [-116.29642, 33.68159], [-116.29694, 33.68146], [-116.29745, 33.68136], [-116.29748, 33.68138], [-116.29743, 33.68146], [-116.29742, 33.68151], [-116.29744, 33.68156], [-116.29758, 33.68172], [-116.29777, 33.682], [-116.29785, 33.68207], [-116.29793, 33.68211], [-116.29812, 33.68214], [-116.29901, 33.68208], [-116.29932, 33.68201], [-116.29959, 33.68193], [-116.29973, 33.68185], [-116.29985, 33.68173], [-116.29993, 33.68158], [-116.29996, 33.68143], [-116.30097, 33.68143]]]} | Open Access 1 | Seasons Park | 25270 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 5.136 | Seasons Park | ||
10667 | 10667 | 10666 | {"type": "Polygon", "coordinates": [[[-116.30936, 33.6529], [-116.30904, 33.6529], [-116.30905, 33.65265], [-116.3091, 33.65262], [-116.30936, 33.65263], [-116.30936, 33.6529]]]} | Open Access 1 | Velasco Park | 26843 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 0.218 | Velasco Park | ||
15343 | 15343 | 15342 | {"type": "MultiPolygon", "coordinates": [[[[-116.29417, 33.63475], [-116.28536, 33.6349], [-116.28539, 33.63048], [-116.28628, 33.63084], [-116.28641, 33.63086], [-116.28663, 33.63084], [-116.28665, 33.63125], [-116.287, 33.6318], [-116.28734, 33.63194], [-116.28757, 33.63265], [-116.28749, 33.63325], [-116.28763, 33.63324], [-116.28777, 33.63302], [-116.2879, 33.63307], [-116.28798, 33.63302], [-116.28825, 33.6329], [-116.28847, 33.63297], [-116.28858, 33.63282], [-116.28992, 33.63292], [-116.2908, 33.63331], [-116.29086, 33.63325], [-116.29062, 33.6329], [-116.2906, 33.6326], [-116.29091, 33.63264], [-116.29154, 33.63335], [-116.29173, 33.6334], [-116.29174, 33.63339], [-116.2917, 33.63327], [-116.29156, 33.6332], [-116.29145, 33.63265], [-116.29161, 33.63256], [-116.29177, 33.63273], [-116.29182, 33.63294], [-116.29198, 33.6328], [-116.29229, 33.63274], [-116.29303, 33.63303], [-116.29374, 33.63312], [-116.29414, 33.63314], [-116.29417, 33.63475]]], [[[-116.29398, 33.63067], [-116.29318, 33.62999], [-116.29319, 33.62982], [-116.29306, 33.62973], [-116.29256, 33.62926], [-116.29256, 33.62916], [-116.29315, 33.62898], [-116.29324, 33.6286], [-116.29374, 33.62867], [-116.29369, 33.62858], [-116.29344, 33.62838], [-116.29306, 33.62825], [-116.29306, 33.62806], [-116.29324, 33.62779], [-116.29385, 33.62784], [-116.29384, 33.62779], [-116.29358, 33.62755], [-116.29396, 33.62754], [-116.29398, 33.63067]]]]} | Open Access 1 | Santa Rosa and San Jacinto Mountains National Monument | 25130 | 1161 | La Quinta, City of 601 | City 2 | City Agency 2 | http://www.la-quinta.org/your-government/community-services/city-parks | City 2 | 57.481 | Santa Rosa and San Jacinto Mtns. NM | 2000 |
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]);