units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9 rows where ACCESS_TYP = 1 and LABEL_NAME = "City of San Marcos OS"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
9938 | 9938 | 9937 | {"type": "Polygon", "coordinates": [[[-117.18229, 33.16732], [-117.1818, 33.16767], [-117.18177, 33.16834], [-117.1747, 33.16811], [-117.17439, 33.1632], [-117.17425, 33.16054], [-117.17772, 33.16053], [-117.17791, 33.16137], [-117.17776, 33.16141], [-117.17785, 33.1618], [-117.17729, 33.16189], [-117.17689, 33.16205], [-117.17657, 33.16226], [-117.17624, 33.16257], [-117.17602, 33.1629], [-117.17589, 33.16318], [-117.17582, 33.16346], [-117.17585, 33.16381], [-117.17592, 33.16398], [-117.17601, 33.16414], [-117.17623, 33.16441], [-117.17651, 33.16424], [-117.17653, 33.16426], [-117.17626, 33.16444], [-117.17667, 33.16491], [-117.17696, 33.16515], [-117.17714, 33.16526], [-117.1774, 33.16535], [-117.17761, 33.1654], [-117.1778, 33.1654], [-117.17807, 33.16539], [-117.1786, 33.16531], [-117.17894, 33.1653], [-117.17912, 33.16533], [-117.17944, 33.16545], [-117.17959, 33.16553], [-117.18049, 33.16633], [-117.18066, 33.16645], [-117.18119, 33.16674], [-117.1816, 33.16709], [-117.18185, 33.16691], [-117.18229, 33.16732]], [[-117.1756, 33.16062], [-117.17556, 33.1606], [-117.17549, 33.16061], [-117.1751, 33.1608], [-117.17468, 33.16093], [-117.17464, 33.16099], [-117.1746, 33.16107], [-117.17459, 33.16119], [-117.17473, 33.16128], [-117.17497, 33.16138], [-117.17517, 33.16139], [-117.17528, 33.16137], [-117.1755, 33.16119], [-117.17567, 33.16088], [-117.1756, 33.16062]]]} | Open Access 1 | 1949 | 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 | 74.648 | City of San Marcos OS | 0 | Local Recreation Area 3 | 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 | |
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 | |
15996 | 15996 | 15995 | {"type": "Polygon", "coordinates": [[[-117.18616, 33.15609], [-117.18576, 33.1561], [-117.18562, 33.15604], [-117.18475, 33.1554], [-117.18447, 33.15531], [-117.18401, 33.15525], [-117.18391, 33.15517], [-117.1837, 33.15513], [-117.18323, 33.15512], [-117.18287, 33.15522], [-117.1826, 33.15547], [-117.18259, 33.1555], [-117.18257, 33.15551], [-117.18253, 33.15575], [-117.1827, 33.15598], [-117.18286, 33.15616], [-117.18303, 33.1562], [-117.18373, 33.15615], [-117.18397, 33.15615], [-117.18417, 33.15612], [-117.18496, 33.15664], [-117.18507, 33.15691], [-117.18249, 33.15695], [-117.18232, 33.15339], [-117.18371, 33.15336], [-117.18316, 33.15377], [-117.18294, 33.15382], [-117.18291, 33.15398], [-117.18325, 33.15416], [-117.18335, 33.15417], [-117.18335, 33.15425], [-117.18344, 33.15432], [-117.18336, 33.15442], [-117.18349, 33.15463], [-117.18373, 33.15463], [-117.18397, 33.15449], [-117.18395, 33.15447], [-117.18425, 33.15432], [-117.1845, 33.1543], [-117.18472, 33.15435], [-117.18499, 33.15457], [-117.18522, 33.15457], [-117.18527, 33.15469], [-117.18535, 33.15472], [-117.18531, 33.1548], [-117.18541, 33.15504], [-117.18539, 33.15522], [-117.18557, 33.15543], [-117.18566, 33.15558], [-117.18569, 33.15575], [-117.18612, 33.15574], [-117.18616, 33.15609]]]} | Open Access 1 | 1799 | 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 | 14.769 | 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 | |
16004 | 16004 | 16003 | {"type": "Polygon", "coordinates": [[[-117.17371, 33.14974], [-117.17371, 33.15282], [-117.17358, 33.15257], [-117.17322, 33.15261], [-117.1731, 33.15265], [-117.17302, 33.1526], [-117.17293, 33.1526], [-117.17285, 33.15265], [-117.1727, 33.15242], [-117.17178, 33.15243], [-117.17139, 33.15238], [-117.17083, 33.15211], [-117.17017, 33.15147], [-117.17021, 33.15144], [-117.17031, 33.15143], [-117.17076, 33.15108], [-117.17086, 33.15092], [-117.1703, 33.15076], [-117.17031, 33.15072], [-117.17029, 33.15067], [-117.17026, 33.15062], [-117.17022, 33.1506], [-117.1704, 33.15027], [-117.17056, 33.15017], [-117.17045, 33.14997], [-117.17039, 33.14975], [-117.17371, 33.14974]]]} | Open Access 1 | 1819 | 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 | 22.056 | City of San Marcos OS | 0 | Local Recreation Area 3 | 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 | |
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 |
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]);