superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
31 rows where MNG_AGENCY = 197 sorted by ACRES
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
901 | 901 | 900 | {"type": "Polygon", "coordinates": [[[-117.1632, 33.14385], [-117.16316, 33.14408], [-117.16282, 33.14405], [-117.16279, 33.144], [-117.16284, 33.1438], [-117.16288, 33.14375], [-117.16304, 33.14365], [-117.1632, 33.14385]]]} | Open Access 1 | Mark J. Noy Jr. Adult Fitness Zone | https://www.san-marcos.net/Home/Components/Calendar/Event/9174/5349 | 32784 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 0.308 | Mark J. Noy Jr. Adult Fitness Zone | 2019 |
13946 | 13946 | 13945 | {"type": "Polygon", "coordinates": [[[-117.12984, 33.15135], [-117.1298, 33.15206], [-117.12954, 33.15205], [-117.12957, 33.15153], [-117.12974, 33.15147], [-117.12984, 33.15135]]]} | Open Access 1 | Fulton Community Garden | 31432 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 0.391 | Fulton Community Garden | ||
15512 | 15512 | 15511 | {"type": "Polygon", "coordinates": [[[-117.15886, 33.14153], [-117.15831, 33.14154], [-117.1577, 33.14159], [-117.15768, 33.14153], [-117.1584, 33.14106], [-117.15849, 33.1412], [-117.15861, 33.14133], [-117.15886, 33.14153]]]} | Open Access 1 | Civic Center Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/150/1081 | 29119 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 0.729 | Civic Ctr. Park | |
14303 | 14303 | 14302 | {"type": "MultiPolygon", "coordinates": [[[[-117.14137, 33.15374], [-117.14114, 33.15399], [-117.1411, 33.154], [-117.14106, 33.154], [-117.14103, 33.15398], [-117.14101, 33.15395], [-117.14087, 33.15347], [-117.14094, 33.15346], [-117.14137, 33.15374]]], [[[-117.18544, 33.1626], [-117.18544, 33.16267], [-117.18537, 33.16299], [-117.18467, 33.1629], [-117.18466, 33.16288], [-117.18471, 33.16253], [-117.18544, 33.1626]]]]} | Open Access 1 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1.074 | |||
5013 | 5013 | 5012 | {"type": "Polygon", "coordinates": [[[-117.13036, 33.15701], [-117.13001, 33.15705], [-117.12965, 33.15704], [-117.1293, 33.15698], [-117.12927, 33.15689], [-117.12937, 33.15681], [-117.12953, 33.15667], [-117.12969, 33.15649], [-117.12985, 33.15627], [-117.12994, 33.15612], [-117.13015, 33.15566], [-117.13019, 33.15562], [-117.13025, 33.15561], [-117.13005, 33.15609], [-117.1299, 33.15632], [-117.13022, 33.15634], [-117.13023, 33.15639], [-117.13027, 33.15643], [-117.13019, 33.15653], [-117.13036, 33.15701]]]} | Open Access 1 | Helen Bougher Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/149/1081 | 19796 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1.491 | Helen Bougher Park | |
14083 | 14083 | 14082 | {"type": "Polygon", "coordinates": [[[-117.12865, 33.15166], [-117.12863, 33.15202], [-117.12765, 33.15199], [-117.12767, 33.15133], [-117.12844, 33.15134], [-117.12843, 33.15165], [-117.12865, 33.15166]]]} | Open Access 1 | Woodland Park Tennis Courts | 31531 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1.519 | Woodland Park Tennis Courts | ||
14356 | 14356 | 14355 | {"type": "Polygon", "coordinates": [[[-117.17371, 33.15351], [-117.16952, 33.15353], [-117.16952, 33.15346], [-117.16955, 33.15327], [-117.16964, 33.15308], [-117.16977, 33.15295], [-117.1699, 33.15285], [-117.16995, 33.15283], [-117.16999, 33.15285], [-117.17031, 33.15306], [-117.17058, 33.1532], [-117.17095, 33.15333], [-117.17128, 33.15342], [-117.1718, 33.15347], [-117.17371, 33.15348], [-117.17371, 33.15351]]]} | Open Access 1 | Unnamed San Marcos City Park 1 | 31361 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 2.048 | |||
3680 | 3680 | 3679 | {"type": "Polygon", "coordinates": [[[-117.17805, 33.1092], [-117.17803, 33.10952], [-117.17778, 33.10946], [-117.17768, 33.10954], [-117.17754, 33.10957], [-117.17679, 33.10943], [-117.17642, 33.10946], [-117.17636, 33.10944], [-117.17632, 33.10939], [-117.17617, 33.10932], [-117.17589, 33.10929], [-117.17584, 33.10925], [-117.17582, 33.10921], [-117.17584, 33.10918], [-117.17607, 33.10913], [-117.17616, 33.10914], [-117.17627, 33.10918], [-117.17629, 33.10915], [-117.17639, 33.10914], [-117.17663, 33.10904], [-117.17679, 33.109], [-117.17695, 33.10889], [-117.17707, 33.10903], [-117.17704, 33.10907], [-117.177, 33.10909], [-117.177, 33.10917], [-117.17703, 33.10918], [-117.17734, 33.10907], [-117.17732, 33.10899], [-117.17726, 33.10896], [-117.17734, 33.10887], [-117.17738, 33.10891], [-117.17766, 33.10892], [-117.17785, 33.10902], [-117.178, 33.10913], [-117.17805, 33.1092]]]} | Open Access 1 | Double Peak Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/154/1081 | 18238 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 2.26 | Double Peak Park | |
13869 | 13869 | 13868 | {"type": "Polygon", "coordinates": [[[-117.1647, 33.14436], [-117.16462, 33.14506], [-117.16459, 33.14509], [-117.16454, 33.14511], [-117.16434, 33.14509], [-117.16425, 33.14503], [-117.16417, 33.14501], [-117.16416, 33.1448], [-117.1627, 33.14464], [-117.16275, 33.14424], [-117.16278, 33.14421], [-117.16282, 33.14419], [-117.16332, 33.14424], [-117.16381, 33.14422], [-117.16464, 33.14431], [-117.16468, 33.14433], [-117.1647, 33.14436]]]} | Open Access 1 | Richmar Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/406/1126 | 31423 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 2.82 | Richmar Park | |
5762 | 5762 | 5761 | {"type": "Polygon", "coordinates": [[[-117.1208, 33.13775], [-117.11972, 33.13958], [-117.11943, 33.13945], [-117.11998, 33.13852], [-117.11943, 33.13827], [-117.11986, 33.13753], [-117.12047, 33.13778], [-117.12056, 33.13765], [-117.1208, 33.13775]]]} | Open Access 1 | Knob Hill Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/161/1081 | 20695 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 3.022 | Knob Hill Park | |
7272 | 7272 | 7271 | {"type": "Polygon", "coordinates": [[[-117.14918, 33.15175], [-117.14917, 33.15273], [-117.14914, 33.15277], [-117.14909, 33.15279], [-117.14808, 33.15278], [-117.14808, 33.1524], [-117.148, 33.15233], [-117.14787, 33.15233], [-117.14787, 33.15184], [-117.14769, 33.15183], [-117.14764, 33.1518], [-117.14723, 33.1518], [-117.14721, 33.15187], [-117.14712, 33.15187], [-117.14712, 33.15163], [-117.14783, 33.15164], [-117.14786, 33.1517], [-117.14793, 33.15174], [-117.148, 33.15172], [-117.14806, 33.15166], [-117.14811, 33.15164], [-117.14911, 33.15164], [-117.14912, 33.15169], [-117.14916, 33.15172], [-117.14918, 33.15175]]]} | Open Access 1 | Mulberry Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/157/1081 | 22586 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 3.881 | Mulberry Park | |
12148 | 12148 | 12147 | {"type": "Polygon", "coordinates": [[[-117.17078, 33.14419], [-117.17069, 33.14454], [-117.16617, 33.14341], [-117.16616, 33.14323], [-117.16611, 33.14305], [-117.17078, 33.14419]]]} | Open Access 1 | Buelow Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/153/1081 | 29118 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 4.24 | Buelow Park | |
12708 | 12708 | 12707 | {"type": "Polygon", "coordinates": [[[-117.17031, 33.14175], [-117.1696, 33.14194], [-117.16948, 33.14144], [-117.1694, 33.14144], [-117.16914, 33.14076], [-117.16876, 33.14084], [-117.16851, 33.14017], [-117.16966, 33.13987], [-117.17001, 33.14078], [-117.16995, 33.14082], [-117.17031, 33.14175]]]} | Open Access 1 | Connors Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/151/1081 | 31392 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 4.594 | Connors Park | 2014 |
12150 | 12150 | 12149 | {"type": "Polygon", "coordinates": [[[-117.22521, 33.12266], [-117.22464, 33.12337], [-117.2252, 33.12429], [-117.22484, 33.12462], [-117.2246, 33.12477], [-117.22338, 33.12367], [-117.2235, 33.12358], [-117.22433, 33.12266], [-117.2249, 33.12218], [-117.22521, 33.12266]]]} | Open Access 1 | Simmons Family Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/158/1081?npage=2 | 29122 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 5.9 | Simmons Family Park | |
7167 | 7167 | 7166 | {"type": "Polygon", "coordinates": [[[-117.11464, 33.13111], [-117.11268, 33.13434], [-117.11264, 33.13434], [-117.11231, 33.13488], [-117.11223, 33.13485], [-117.11205, 33.13414], [-117.11209, 33.13397], [-117.11184, 33.13395], [-117.11177, 33.13396], [-117.11373, 33.13073], [-117.11464, 33.13111]]]} | Open Access 1 | Montiel Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/159/1081 | 22440 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 9.963 | Montiel Park | |
14931 | 14931 | 14930 | {"type": "MultiPolygon", "coordinates": [[[[-117.16091, 33.13937], [-117.15846, 33.14101], [-117.15824, 33.14041], [-117.15823, 33.1404], [-117.15831, 33.14084], [-117.1584, 33.14105], [-117.15769, 33.14153], [-117.1577, 33.14159], [-117.15715, 33.14168], [-117.15661, 33.14181], [-117.15656, 33.14167], [-117.15663, 33.14161], [-117.15665, 33.14152], [-117.15663, 33.14145], [-117.15659, 33.14141], [-117.15691, 33.14112], [-117.15709, 33.14098], [-117.15796, 33.14043], [-117.16037, 33.13882], [-117.16091, 33.13937]]], [[[-117.16212, 33.13866], [-117.16175, 33.13905], [-117.16107, 33.13923], [-117.1605, 33.13865], [-117.16073, 33.13856], [-117.1615, 33.13836], [-117.16206, 33.1385], [-117.16212, 33.13866]]]]} | No Public Access 3 | San Marcos City Open Space | 24944 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 10.998 | San Marcos City OS | ||
2803 | 2803 | 2802 | {"type": "Polygon", "coordinates": [[[-117.18875, 33.16063], [-117.18871, 33.16066], [-117.18683, 33.16069], [-117.18645, 33.16068], [-117.18644, 33.15846], [-117.18701, 33.15859], [-117.1875, 33.15866], [-117.18752, 33.15879], [-117.18796, 33.1588], [-117.18818, 33.15884], [-117.18874, 33.15885], [-117.18875, 33.16063]]]} | Open Access 1 | Cerro De Las Posas Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/165/1081 | 17090 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 11.598 | Cerro De Las Posas Park | |
11393 | 11393 | 11392 | {"type": "Polygon", "coordinates": [[[-117.13342, 33.14761], [-117.13288, 33.14884], [-117.13241, 33.14999], [-117.13211, 33.15068], [-117.12988, 33.15061], [-117.1299, 33.15021], [-117.13084, 33.15022], [-117.13094, 33.14816], [-117.13176, 33.14817], [-117.13179, 33.14755], [-117.13342, 33.14761]]]} | Open Access 1 | Woodland Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/167/1081?npage=2 | 27724 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 14.521 | Woodland Park | |
7061 | 7061 | 7060 | {"type": "Polygon", "coordinates": [[[-117.18329, 33.14634], [-117.1828, 33.14626], [-117.17872, 33.14576], [-117.1788, 33.14537], [-117.17884, 33.14494], [-117.1789, 33.1446], [-117.17915, 33.1445], [-117.17921, 33.1445], [-117.17956, 33.14463], [-117.17994, 33.14406], [-117.18015, 33.14392], [-117.18033, 33.1437], [-117.18045, 33.1436], [-117.18329, 33.14634]]]} | Open Access 1 | Mission Sports Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/163/1081 | 22312 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 15.177 | Mission Sports Park | |
9190 | 9190 | 9189 | {"type": "Polygon", "coordinates": [[[-117.2022, 33.09994], [-117.20212, 33.10008], [-117.20213, 33.10011], [-117.20206, 33.10021], [-117.20207, 33.10026], [-117.20194, 33.10042], [-117.20195, 33.10047], [-117.20181, 33.10065], [-117.20182, 33.1007], [-117.20178, 33.10091], [-117.20181, 33.10096], [-117.20168, 33.10119], [-117.20133, 33.10121], [-117.20118, 33.10129], [-117.20071, 33.1013], [-117.20138, 33.10215], [-117.20053, 33.10254], [-117.20042, 33.10245], [-117.20021, 33.10233], [-117.19979, 33.10224], [-117.19961, 33.10217], [-117.19949, 33.10209], [-117.1993, 33.10191], [-117.19931, 33.10044], [-117.19901, 33.10011], [-117.19899, 33.10012], [-117.19897, 33.10169], [-117.19878, 33.10164], [-117.19829, 33.10163], [-117.19812, 33.1016], [-117.19786, 33.1015], [-117.19764, 33.10133], [-117.19756, 33.10121], [-117.19743, 33.10096], [-117.19745, 33.10092], [-117.19764, 33.10084], [-117.1983, 33.10054], [-117.19885, 33.10021], [-117.19928, 33.0999], [-117.19968, 33.09957], [-117.20004, 33.09919], [-117.20015, 33.09919], [-117.20067, 33.0995], [-117.20104, 33.09967], [-117.20153, 33.09982], [-117.2022, 33.09994]]]} | Open Access 1 | San Elijo Park | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/160/1081?npage=2 | 24882 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 19.897 | San Elijo 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]);