superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where LABEL_NAME = "Juniper Canyon" and MNG_AGENCY = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5635 | 5635 | 5634 | {"type": "MultiPolygon", "coordinates": [[[[-117.11576, 32.72532], [-117.11524, 32.72532], [-117.11511, 32.72495], [-117.11511, 32.72467], [-117.11521, 32.7245], [-117.11576, 32.7245], [-117.11576, 32.72532]]], [[[-117.11576, 32.72642], [-117.11564, 32.72642], [-117.11563, 32.72641], [-117.11532, 32.72554], [-117.11576, 32.72554], [-117.11576, 32.72642]]], [[[-117.11576, 32.72371], [-117.11576, 32.72428], [-117.11537, 32.72428], [-117.11537, 32.72428], [-117.11576, 32.72371]]], [[[-117.11774, 32.72291], [-117.11658, 32.7244], [-117.11656, 32.72428], [-117.11601, 32.72428], [-117.11602, 32.72345], [-117.11657, 32.72343], [-117.11655, 32.72323], [-117.11608, 32.72323], [-117.11666, 32.72242], [-117.11668, 32.72242], [-117.11669, 32.7229], [-117.11694, 32.7229], [-117.11695, 32.72242], [-117.11753, 32.72244], [-117.11756, 32.72247], [-117.11756, 32.72286], [-117.1176, 32.72287], [-117.11761, 32.72291], [-117.11774, 32.72291]]], [[[-117.11669, 32.72195], [-117.11669, 32.7222], [-117.11652, 32.72219], [-117.11652, 32.72219], [-117.11669, 32.72195]]], [[[-117.11764, 32.72136], [-117.11762, 32.72221], [-117.11695, 32.7222], [-117.11695, 32.72207], [-117.11729, 32.72157], [-117.11729, 32.72136], [-117.11764, 32.72136]]], [[[-117.11765, 32.72032], [-117.11764, 32.72114], [-117.11729, 32.72115], [-117.11728, 32.72032], [-117.11765, 32.72032]]], [[[-117.11944, 32.7216], [-117.11944, 32.72224], [-117.11913, 32.72226], [-117.11913, 32.72245], [-117.11944, 32.72246], [-117.11944, 32.72296], [-117.11875, 32.72295], [-117.11874, 32.7229], [-117.11868, 32.72289], [-117.11868, 32.72277], [-117.11875, 32.72275], [-117.11875, 32.72248], [-117.11868, 32.72247], [-117.11868, 32.72239], [-117.11878, 32.72239], [-117.1188, 32.72232], [-117.11878, 32.7223], [-117.11834, 32.72229], [-117.11816, 32.72231], [-117.11784, 32.72281], [-117.11774, 32.72281], [-117.11775, 32.72233], [-117.11785, 32.7222], [-117.11789, 32.72208], [-117.11788, 32.72199], [-117.11791, 32.72034], [-117.11793, 32.72032], [-117.11821, 32.72031], [-117.11823, 32.72025], [-117.11826, 32.72025], [-117.11853, 32.72032], [-117.11871, 32.72042], [-117.11878, 32.7205], [-117.11887, 32.72063], [-117.11889, 32.72071], [-117.11893, 32.72125], [-117.11896, 32.72131], [-117.11904, 32.7214], [-117.11911, 32.72142], [-117.11944, 32.72144], [-117.11944, 32.7216]]], [[[-117.11958, 32.72025], [-117.11958, 32.72052], [-117.11944, 32.72053], [-117.11943, 32.7212], [-117.11911, 32.72119], [-117.11907, 32.72069], [-117.11903, 32.72055], [-117.11893, 32.7204], [-117.11882, 32.72031], [-117.11872, 32.72025], [-117.11958, 32.72025]]], [[[-117.12036, 32.72145], [-117.12036, 32.72224], [-117.11969, 32.72224], [-117.11971, 32.72144], [-117.12036, 32.72145]]], [[[-117.12049, 32.72093], [-117.12048, 32.72117], [-117.12002, 32.7212], [-117.1197, 32.7212], [-117.1197, 32.72079], [-117.12003, 32.72079], [-117.12005, 32.72093], [-117.12049, 32.72093]]], [[[-117.12035, 32.72247], [-117.12035, 32.72293], [-117.1197, 32.72291], [-117.1197, 32.72246], [-117.12035, 32.72247]]], [[[-117.12165, 32.72222], [-117.12093, 32.72223], [-117.12091, 32.72226], [-117.12062, 32.72225], [-117.12062, 32.72145], [-117.12085, 32.72144], [-117.12086, 32.72138], [-117.12111, 32.72138], [-117.12112, 32.72178], [-117.12132, 32.72179], [-117.12135, 32.72193], [-117.12165, 32.72193], [-117.12165, 32.72222]]], [[[-117.12078, 32.72249], [-117.12077, 32.72294], [-117.12062, 32.72293], [-117.12062, 32.72248], [-117.12078, 32.72249]]], [[[-117.12155, 32.72972], [-117.12152, 32.73053], [-117.12093, 32.73053], [-117.12094, 32.72972], [-117.12155, 32.72972]]], [[[-117.12271, 32.72407], [-117.12135, 32.72408], [-117.12134, 32.72394], [-117.12096, 32.72394], [-117.12094, 32.72349], [-117.1227, 32.7235], [-117.12271, 32.72407]]], [[[-117.1216, 32.72868], [-117.12156, 32.7295], [-117.12095, 32.72949], [-117.12096, 32.72868], [-117.1216, 32.72868]]], [[[-117.12165, 32.72764], [-117.12161, 32.72846], [-117.12096, 32.72846], [-117.121, 32.72764], [-117.12165, 32.72764]]], [[[-117.12137, 32.72539], [-117.12101, 32.72539], [-117.121, 32.72498], [-117.12137, 32.72497], [-117.12137, 32.72539]]], [[[-117.1217, 32.72665], [-117.12166, 32.72742], [-117.121, 32.72742], [-117.12105, 32.72666], [-117.1217, 32.72665]]], [[[-117.12129, 32.7201], [-117.1211, 32.7201], [-117.12111, 32.71931], [-117.12129, 32.7193], [-117.12129, 32.7201]]], [[[-117.12166, 32.7227], [-117.12134, 32.7227], [-117.12134, 32.72284], [-117.12113, 32.72284], [-117.12113, 32.72242], [-117.12165, 32.72242], [-117.12166, 32.7227]]], [[[-117.12162, 32.72045], [-117.12129, 32.72045], [-117.12129, 32.72032], [-117.12162, 32.72031], [-117.12162, 32.72045]]], [[[-117.1217, 32.72628], [-117.12138, 32.72628], [-117.12137, 32.72561], [-117.12169, 32.72562], [-117.1217, 32.72628]]], [[[-117.12236, 32.73181], [-117.12232, 32.73262], [-117.12167, 32.73263], [-117.1217, 32.73181], [-117.12236, 32.73181]]], [[[-117.12209, 32.73076], [-117.12205, 32.73159], [-117.12172, 32.73159], [-117.12176, 32.73075], [-117.12209, 32.73076]]], [[[-117.12247, 32.72973], [-117.12243, 32.73025], [-117.12213, 32.73026], [-117.1221, 32.73053], [-117.12177, 32.73053], [-117.12182, 32.72972], [-117.12247, 32.72973]]], [[[-117.12251, 32.72868], [-117.1225, 32.72895], [-117.12218, 32.72894], [-117.12217, 32.72881], [-117.12186, 32.72881], [-117.12186, 32.72868], [-117.12251, 32.72868]]], [[[-117.12252, 32.72831], [-117.12251, 32.72847], [-117.12187, 32.72847], [-117.1219, 32.7279], [-117.12223, 32.7279], [-117.12221, 32.7283], [-117.12252, 32.72831]]], [[[-117.12221, 32.72059], [-117.12221, 32.72073], [-117.12189, 32.72073], [-117.12188, 32.72031], [-117.12204, 32.72032], [-117.12205, 32.72058], [-117.12221, 32.72059]]], [[[-117.1226, 32.72206], [-117.1226, 32.72224], [-117.12223, 32.72224], [-117.12221, 32.72222], [-117.12191, 32.72222], [-117.12192, 32.72194], [-117.12259, 32.72193], [-117.1226, 32.72206]]], [[[-117.12235, 32.73288], [-117.12232, 32.73354], [-117.12193, 32.73354], [-117.12196, 32.73326], [-117.12195, 32.73312], [-117.12197, 32.73284], [-117.12231, 32.73285], [-117.12235, 32.73288]]], [[[-117.12262, 32.72643], [-117.12197, 32.72644], [-117.12195, 32.7255], [-117.12229, 32.7255], [-117.1223, 32.72587], [-117.12262, 32.72588], [-117.12262, 32.72643]]], [[[-117.12262, 32.72665], [-117.1226, 32.7269], [-117.12228, 32.7269], [-117.1223, 32.72665], [-117.12262, 32.72665]]], [[[-117.12334, 32.73041], [-117.12334, 32.73055], [-117.12268, 32.73054], [-117.1227, 32.73013], [-117.12303, 32.73013], [-117.12303, 32.73039], [-117.12334, 32.73041]]], [[[-117.1235, 32.72433], [-117.12285, 32.72435], [-117.12284, 32.72401], [-117.12316, 32.724], [-117.12318, 32.72413], [-117.1235, 32.72413], [-117.1235, 32.72433]]], [[[-117.12351, 32.72665], [-117.12349, 32.72702], [-117.12318, 32.72703], [-117.12317, 32.7269], [-117.12286, 32.7269], [-117.12288, 32.72665], [-117.12351, 32.72665]]], [[[-117.12352, 32.72481], [-117.12352, 32.72496], [-117.12319, 32.72497], [-117.12317, 32.72482], [-117.12344, 32.72481], [-117.12345, 32.72468], [-117.12351, 32.72468], [-117.12352, 32.72481]]], [[[-117.12468, 32.72741], [-117.12372, 32.72742], [-117.12375, 32.72684], [-117.12396, 32.72705], [-117.12406, 32.72713], [-117.1242, 32.72718], [-117.1245, 32.72724], [-117.12458, 32.72729], [-117.12468, 32.72741]]], [[[-117.12411, 32.72529], [-117.12378, 32.72529], [-117.12377, 32.72455], [-117.1241, 32.72454], [-117.12411, 32.72529]]], [[[-117.12527, 32.7279], [-117.12525, 32.72818], [-117.12493, 32.72818], [-117.12492, 32.72805], [-117.12462, 32.72805], [-117.12463, 32.72763], [-117.12495, 32.72763], [-117.12495, 32.72789], [-117.12527, 32.7279]]], [[[-117.12589, 32.72848], [-117.12541, 32.72847], [-117.12541, 32.72809], [-117.12588, 32.72808], [-117.12589, 32.72848]]]]} | Open Access 1 | Juniper Canyon | 20525 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 42.798 | Juniper Canyon |
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]);