superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where PARK_NAME = "South Hills Wilderness Area"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AG_TYP 1
MNG_AGENCY 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12643 | 12643 | 12642 | {"type": "MultiPolygon", "coordinates": [[[[-117.86416, 34.12052], [-117.86393, 34.12105], [-117.86387, 34.12129], [-117.86319, 34.12127], [-117.86313, 34.12125], [-117.86304, 34.12111], [-117.86271, 34.12087], [-117.86253, 34.12058], [-117.86096, 34.12118], [-117.86093, 34.12265], [-117.86151, 34.12266], [-117.8623, 34.12244], [-117.86109, 34.12289], [-117.85981, 34.12326], [-117.85933, 34.12343], [-117.85897, 34.12357], [-117.85852, 34.12379], [-117.85722, 34.12446], [-117.85683, 34.12469], [-117.85653, 34.12489], [-117.85629, 34.12494], [-117.85621, 34.12506], [-117.85513, 34.12507], [-117.85511, 34.12592], [-117.855, 34.12598], [-117.8549, 34.12594], [-117.85453, 34.12613], [-117.85386, 34.1264], [-117.85413, 34.12642], [-117.85355, 34.12662], [-117.85305, 34.12676], [-117.85253, 34.12685], [-117.85061, 34.12712], [-117.85058, 34.12692], [-117.85051, 34.12672], [-117.85042, 34.12651], [-117.85031, 34.12631], [-117.85019, 34.12614], [-117.84997, 34.12589], [-117.84997, 34.1252], [-117.84779, 34.12519], [-117.84781, 34.12115], [-117.84412, 34.12116], [-117.84418, 34.11838], [-117.84445, 34.11832], [-117.84496, 34.11826], [-117.84521, 34.11825], [-117.84662, 34.11829], [-117.847, 34.1184], [-117.84737, 34.11841], [-117.84802, 34.11875], [-117.84839, 34.11881], [-117.84876, 34.1187], [-117.84897, 34.11839], [-117.84897, 34.11813], [-117.84926, 34.11799], [-117.84972, 34.11807], [-117.85006, 34.11798], [-117.85024, 34.11847], [-117.85099, 34.11872], [-117.85156, 34.11937], [-117.85206, 34.11952], [-117.85223, 34.1194], [-117.85251, 34.11885], [-117.85318, 34.11838], [-117.85408, 34.11796], [-117.85508, 34.11797], [-117.8556, 34.11788], [-117.85578, 34.11837], [-117.85605, 34.11866], [-117.85637, 34.11893], [-117.85674, 34.11894], [-117.85726, 34.11849], [-117.85805, 34.1176], [-117.85846, 34.1176], [-117.85869, 34.11755], [-117.86035, 34.11756], [-117.86039, 34.11761], [-117.86114, 34.11795], [-117.86163, 34.11809], [-117.86164, 34.11934], [-117.86303, 34.11886], [-117.8628, 34.11943], [-117.86278, 34.11957], [-117.86279, 34.1197], [-117.86277, 34.11984], [-117.86272, 34.11993], [-117.86263, 34.11998], [-117.86251, 34.11996], [-117.86226, 34.11988], [-117.86164, 34.11985], [-117.86162, 34.11987], [-117.86164, 34.11998], [-117.86192, 34.11998], [-117.86224, 34.12002], [-117.86246, 34.12009], [-117.86266, 34.12012], [-117.86284, 34.12002], [-117.86292, 34.11987], [-117.86295, 34.1197], [-117.86296, 34.11947], [-117.86315, 34.11897], [-117.86325, 34.11878], [-117.86393, 34.11854], [-117.86404, 34.11887], [-117.86393, 34.11897], [-117.86387, 34.11911], [-117.86385, 34.12016], [-117.86386, 34.12021], [-117.8639, 34.12029], [-117.8641, 34.12044], [-117.86416, 34.12052]]], [[[-117.86442, 34.1196], [-117.8644, 34.11983], [-117.86432, 34.12014], [-117.86422, 34.12038], [-117.86414, 34.12032], [-117.86403, 34.12027], [-117.86398, 34.12012], [-117.864, 34.11913], [-117.86403, 34.11905], [-117.86408, 34.11899], [-117.86425, 34.11948], [-117.86432, 34.11955], [-117.86442, 34.1196]]], [[[-117.8644, 34.11849], [-117.86428, 34.11869], [-117.86416, 34.11877], [-117.86401, 34.11835], [-117.86439, 34.11827], [-117.8644, 34.11849]]], [[[-117.86442, 34.11947], [-117.86439, 34.11945], [-117.8642, 34.1189], [-117.86432, 34.11881], [-117.86442, 34.1187], [-117.86442, 34.11947]]]]} | Open Access 1 | South Hills Wilderness Area | 29755 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 276.151 | South Hills Wilderness Area | ||
14128 | 14128 | 14127 | {"type": "MultiPolygon", "coordinates": [[[[-117.84124, 34.12117], [-117.84054, 34.12118], [-117.84023, 34.12153], [-117.83983, 34.12152], [-117.83911, 34.12117], [-117.83764, 34.12117], [-117.83763, 34.12145], [-117.83677, 34.12145], [-117.83666, 34.12126], [-117.83634, 34.12126], [-117.83592, 34.12145], [-117.8342, 34.12145], [-117.83431, 34.12136], [-117.83509, 34.12132], [-117.83554, 34.12118], [-117.83761, 34.12117], [-117.83763, 34.12112], [-117.8384, 34.12088], [-117.8391, 34.12112], [-117.83912, 34.12094], [-117.83982, 34.12059], [-117.8403, 34.12058], [-117.84046, 34.12015], [-117.84058, 34.11995], [-117.84123, 34.11967], [-117.84124, 34.12117]]], [[[-117.84291, 34.12337], [-117.84251, 34.12387], [-117.8422, 34.12469], [-117.84139, 34.12461], [-117.84124, 34.12468], [-117.84123, 34.12321], [-117.84124, 34.12207], [-117.84207, 34.12207], [-117.84208, 34.12238], [-117.84291, 34.12337]]], [[[-117.84336, 34.11907], [-117.84316, 34.11904], [-117.84312, 34.11902], [-117.84303, 34.11903], [-117.84285, 34.11899], [-117.84275, 34.11899], [-117.84267, 34.11902], [-117.84264, 34.11899], [-117.84243, 34.11892], [-117.84247, 34.11891], [-117.84267, 34.11876], [-117.84278, 34.11871], [-117.84336, 34.11907]]]]} | Restricted Access 2 | South Hills Wilderness Area | 32652 | 1120 | Glendora, City of 74 | City 2 | City Agency 2 | http://www.ci.glendora.ca.us/departments-services/parks-recreation-senior-services | City 2 | 15.752 | South Hills Wilderness Area |
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]);