units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
40 rows where COUNTY = 4 and MNG_AGENCY = 197 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_TYP, AGNCY_WEB, LAYER, LABEL_NAME, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15991 | 15991 | 15990 | {"type": "Polygon", "coordinates": [[[-117.1688, 33.15147], [-117.16874, 33.15146], [-117.16824, 33.15127], [-117.16804, 33.15122], [-117.16773, 33.15117], [-117.16777, 33.15112], [-117.16796, 33.15118], [-117.168, 33.15117], [-117.16818, 33.15124], [-117.16821, 33.15121], [-117.16838, 33.1513], [-117.16843, 33.15128], [-117.16859, 33.15137], [-117.16863, 33.15136], [-117.1688, 33.15147]]]} | Open Access 1 | 1808 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.109 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
16002 | 16002 | 16001 | {"type": "Polygon", "coordinates": [[[-117.17026, 33.15271], [-117.17005, 33.15254], [-117.16937, 33.15188], [-117.16919, 33.15172], [-117.16898, 33.15158], [-117.16899, 33.15154], [-117.16912, 33.15166], [-117.16917, 33.15165], [-117.16928, 33.15177], [-117.16932, 33.15177], [-117.16943, 33.1519], [-117.16947, 33.1519], [-117.16959, 33.15205], [-117.16963, 33.15205], [-117.16975, 33.15221], [-117.16979, 33.15221], [-117.1699, 33.15236], [-117.16995, 33.15237], [-117.17007, 33.15252], [-117.17012, 33.15253], [-117.17026, 33.15271]]]} | Open Access 1 | 1818 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.155 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
16011 | 16011 | 16010 | {"type": "Polygon", "coordinates": [[[-117.17372, 33.15323], [-117.17372, 33.15323], [-117.1724, 33.15322], [-117.17351, 33.15316], [-117.17363, 33.15296], [-117.17372, 33.15286], [-117.17372, 33.15323]]]} | Open Access 1 | 1820 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.221 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
11518 | 11518 | 11517 | {"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 | 48229 | Mark J. Noy Jr. Adult Fitness Zone | 32784 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | https://www.san-marcos.net/Home/Components/Calendar/Event/9174/5349 | San Diego 4 | 0.309 | Mark J. Noy Jr. Adult Fitness Zone | 2019 | None 1025 | |
4614 | 4614 | 4613 | {"type": "Polygon", "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]]]} | Open Access 1 | 35852 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.339 | 0 | Local Other or Unknown 14 | 4 | ||
1430 | 1430 | 1429 | {"type": "Polygon", "coordinates": [[[-117.12984, 33.15135], [-117.1298, 33.15206], [-117.12954, 33.15205], [-117.12957, 33.15153], [-117.12968, 33.1515], [-117.12974, 33.15147], [-117.12984, 33.15135]]]} | Open Access 1 | 47696 | Fulton Community Garden | 31432 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.389 | Fulton Community Garden | 0 | Local Park 2 | 4 | |
17045 | 17045 | 17044 | {"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 | 45970 | Civic Center Park | 29119 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/150/1081 | San Diego 4 | 0.729 | Civic Ctr. Park | 0 | Local Park 2 | 4 |
4597 | 4597 | 4596 | {"type": "Polygon", "coordinates": [[[-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 | 35551 | Unknown park - San Marcos, City of | 28686 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 0.736 | 0 | Local Other or Unknown 14 | 4 | ||
15971 | 15971 | 15970 | {"type": "Polygon", "coordinates": [[[-117.16978, 33.1527], [-117.16956, 33.15253], [-117.16955, 33.15249], [-117.1694, 33.15236], [-117.16939, 33.15232], [-117.16922, 33.15221], [-117.16922, 33.15216], [-117.16903, 33.15204], [-117.16902, 33.15199], [-117.16878, 33.15188], [-117.16857, 33.15213], [-117.16834, 33.15202], [-117.16849, 33.15174], [-117.16848, 33.1517], [-117.16818, 33.15162], [-117.16788, 33.15157], [-117.16761, 33.15156], [-117.16758, 33.15155], [-117.1673, 33.15158], [-117.16711, 33.15157], [-117.16698, 33.15159], [-117.16685, 33.15178], [-117.16653, 33.15211], [-117.16631, 33.15221], [-117.1671, 33.15139], [-117.16753, 33.15139], [-117.16812, 33.1515], [-117.1685, 33.15163], [-117.16879, 33.15179], [-117.16905, 33.15196], [-117.16917, 33.15206], [-117.16976, 33.15264], [-117.16978, 33.1527]]]} | Open Access 1 | 1817 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 1.188 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
6395 | 6395 | 6394 | {"type": "Polygon", "coordinates": [[[-117.13036, 33.15701], [-117.13, 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.12989, 33.15633], [-117.13022, 33.15634], [-117.13023, 33.15639], [-117.13027, 33.15643], [-117.13019, 33.15653], [-117.13036, 33.15701]]]} | Open Access 1 | 1826 | Helen Bougher Park | 19796 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/149/1081 | San Diego 4 | 1.486 | Helen Bougher Park | 0 | Local Park 2 | 4 |
1524 | 1524 | 1523 | {"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 | 47730 | Woodland Park Tennis Courts | 31531 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 1.518 | Woodland Park Tennis Courts | 0 | Local Recreation Area 3 | 4 | |
4784 | 4784 | 4783 | {"type": "Polygon", "coordinates": [[[-117.17371, 33.15352], [-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.1703, 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.15352]]]} | Open Access 1 | 47624 | Unnamed San Marcos City Park 1 | 31361 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 2.05 | 0 | Local Other or Unknown 14 | 4 | ||
16005 | 16005 | 16004 | {"type": "Polygon", "coordinates": [[[-117.16735, 33.15265], [-117.16713, 33.1529], [-117.1672, 33.15355], [-117.16624, 33.15355], [-117.1663, 33.15317], [-117.16642, 33.15291], [-117.16654, 33.15276], [-117.16692, 33.15237], [-117.16703, 33.15229], [-117.16735, 33.15265]]]} | Open Access 1 | 1821 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 2.223 | City of San Marcos OS | 0 | Local Recreation Area 3 | 4 | |
14730 | 14730 | 14729 | {"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.17735, 33.10907], [-117.17732, 33.10899], [-117.17728, 33.10898], [-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 | 45082 | Double Peak Park | 18238 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/154/1081 | San Diego 4 | 2.257 | Double Peak Park | 0 | Local Park 2 | 4 |
4197 | 4197 | 4196 | {"type": "Polygon", "coordinates": [[[-117.16467, 33.14461], [-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.16417, 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], [-117.16467, 33.14461]]]} | Open Access 1 | 47686 | Richmar Park | 31423 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/406/1126 | San Diego 4 | 2.819 | Richmar Park | 0 | Local Park 2 | 4 |
541 | 541 | 540 | {"type": "Polygon", "coordinates": [[[-117.1208, 33.13775], [-117.11972, 33.13958], [-117.11943, 33.13945], [-117.11998, 33.13851], [-117.11943, 33.13827], [-117.11986, 33.13753], [-117.12047, 33.13779], [-117.12056, 33.13765], [-117.1208, 33.13775]]]} | Open Access 1 | 1805 | Knob Hill Park | 20695 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/161/1081 | San Diego 4 | 3.015 | Knob Hill Park | 0 | Local Park 2 | 4 |
14729 | 14729 | 14728 | {"type": "Polygon", "coordinates": [[[-117.14918, 33.15175], [-117.14917, 33.15273], [-117.14914, 33.15277], [-117.1491, 33.15279], [-117.14808, 33.15278], [-117.14808, 33.1524], [-117.148, 33.15233], [-117.14787, 33.15233], [-117.14787, 33.15183], [-117.14769, 33.15183], [-117.14765, 33.1518], [-117.14722, 33.1518], [-117.14721, 33.15187], [-117.14712, 33.15187], [-117.14712, 33.15163], [-117.14783, 33.15164], [-117.14786, 33.15171], [-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 | 45081 | Mulberry Park | 22586 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/157/1081 | San Diego 4 | 3.877 | Mulberry Park | 0 | Local Park 2 | 4 |
4387 | 4387 | 4386 | {"type": "Polygon", "coordinates": [[[-117.17078, 33.14419], [-117.17069, 33.14454], [-117.16617, 33.14341], [-117.16616, 33.14322], [-117.16611, 33.14305], [-117.17078, 33.14419]]]} | Open Access 1 | 45969 | Buelow Park | 29118 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/153/1081 | San Diego 4 | 4.241 | Buelow Park | 0 | Local Park 2 | 4 |
7630 | 7630 | 7629 | {"type": "Polygon", "coordinates": [[[-117.17031, 33.14175], [-117.1696, 33.14194], [-117.16948, 33.14143], [-117.1694, 33.14144], [-117.16913, 33.14075], [-117.16876, 33.14084], [-117.16851, 33.14017], [-117.16966, 33.13987], [-117.17001, 33.14078], [-117.16995, 33.14081], [-117.17031, 33.14175]]]} | Open Access 1 | 47648 | Connors Park | 31392 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | http://www.san-marcos.net/Home/Components/FacilityDirectory/FacilityDirectory/151/1081 | San Diego 4 | 4.59 | Connors Park | 2014 | Local Park 2 | 4 |
559 | 559 | 558 | {"type": "Polygon", "coordinates": [[[-117.14812, 33.12447], [-117.14555, 33.12477], [-117.14553, 33.12381], [-117.1481, 33.12381], [-117.14812, 33.12447]]]} | Open Access 1 | 1866 | City of San Marcos Open Space | 17333 | 1308 | San Marcos, City of 201 | City 2 | City Agency 2 | http://www.ci.san-marcos.ca.us/index.aspx?page=42 | City 2 | 1308 | San Marcos, City of 197 | City 2 | City Agency 2 | San Diego 4 | 5.376 | City of San Marcos OS | 0 | Local Recreation Area 3 | 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]);