superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 1 and MNG_AGENCY = 837
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1467 | 1467 | 1466 | {"type": "Polygon", "coordinates": [[[-118.69926, 34.03173], [-118.69898, 34.03182], [-118.69884, 34.03153], [-118.69917, 34.03149], [-118.69926, 34.03173]]]} | Open Access 1 | Amarillo Beach - Coastal Conservancy | 15439 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 0.228 | Amarillo Beach - Coastal Conservancy | ||
14861 | 14861 | 14860 | {"type": "MultiPolygon", "coordinates": [[[[-118.74099, 34.04655], [-118.741, 34.04664], [-118.74095, 34.04695], [-118.74058, 34.04695], [-118.7406, 34.04596], [-118.74094, 34.04595], [-118.74092, 34.04601], [-118.74087, 34.04606], [-118.7408, 34.04609], [-118.74073, 34.04616], [-118.7407, 34.04627], [-118.74072, 34.04634], [-118.74077, 34.0464], [-118.74093, 34.04649], [-118.74099, 34.04655]]], [[[-118.74099, 34.0474], [-118.741, 34.04748], [-118.74087, 34.04795], [-118.74084, 34.04833], [-118.7406, 34.04833], [-118.74059, 34.04728], [-118.74092, 34.04728], [-118.74099, 34.0474]]], [[[-118.74173, 34.04724], [-118.7416, 34.04767], [-118.7416, 34.04789], [-118.74158, 34.04794], [-118.74127, 34.04789], [-118.74115, 34.04844], [-118.74095, 34.04847], [-118.74093, 34.04843], [-118.74093, 34.04837], [-118.74094, 34.04799], [-118.74108, 34.04745], [-118.74107, 34.04738], [-118.74099, 34.04728], [-118.74098, 34.04723], [-118.74109, 34.04662], [-118.74107, 34.04655], [-118.74103, 34.04648], [-118.74093, 34.0464], [-118.74085, 34.04638], [-118.74079, 34.0463], [-118.7408, 34.0462], [-118.74098, 34.04605], [-118.74124, 34.04611], [-118.74126, 34.04601], [-118.74165, 34.04606], [-118.74153, 34.04679], [-118.74155, 34.04693], [-118.7416, 34.04703], [-118.74169, 34.04713], [-118.74173, 34.04724]]], [[[-118.7413, 34.0486], [-118.74115, 34.04892], [-118.74113, 34.04894], [-118.74108, 34.04894], [-118.74106, 34.04892], [-118.74106, 34.04889], [-118.74109, 34.04882], [-118.74109, 34.04872], [-118.74102, 34.0486], [-118.7413, 34.0486]]], [[[-118.74405, 34.04641], [-118.74385, 34.04636], [-118.74369, 34.04636], [-118.74354, 34.04643], [-118.74347, 34.04649], [-118.74343, 34.04656], [-118.74341, 34.04665], [-118.74343, 34.04734], [-118.74342, 34.04741], [-118.74334, 34.04754], [-118.74326, 34.04759], [-118.74308, 34.04764], [-118.74295, 34.04774], [-118.74283, 34.04797], [-118.74277, 34.04828], [-118.74272, 34.04835], [-118.74259, 34.04846], [-118.74254, 34.04854], [-118.74251, 34.04862], [-118.74252, 34.04868], [-118.74254, 34.04876], [-118.74264, 34.04889], [-118.74265, 34.04896], [-118.74263, 34.04905], [-118.74151, 34.04904], [-118.74163, 34.049], [-118.74173, 34.0489], [-118.74175, 34.04882], [-118.74174, 34.0487], [-118.74184, 34.04824], [-118.74191, 34.04817], [-118.74208, 34.04812], [-118.74217, 34.04804], [-118.74222, 34.04794], [-118.7422, 34.04776], [-118.74227, 34.04765], [-118.7424, 34.04756], [-118.74266, 34.04752], [-118.74277, 34.04745], [-118.7428, 34.0474], [-118.74282, 34.04734], [-118.74282, 34.04727], [-118.74266, 34.04683], [-118.74266, 34.04668], [-118.74272, 34.04653], [-118.74293, 34.04632], [-118.74297, 34.04621], [-118.74298, 34.04613], [-118.74304, 34.04605], [-118.74316, 34.04597], [-118.74334, 34.04596], [-118.74344, 34.046], [-118.74377, 34.04618], [-118.74387, 34.04621], [-118.74402, 34.04619], [-118.74405, 34.04641]]], [[[-118.74346, 34.0455], [-118.74339, 34.04555], [-118.74312, 34.04556], [-118.74261, 34.04588], [-118.74257, 34.04592], [-118.74254, 34.04599], [-118.74254, 34.04608], [-118.7426, 34.04618], [-118.74261, 34.04625], [-118.74259, 34.04629], [-118.7423, 34.04651], [-118.74226, 34.04658], [-118.74224, 34.04664], [-118.74196, 34.04662], [-118.74199, 34.04686], [-118.74227, 34.04678], [-118.74228, 34.04679], [-118.74268, 34.04737], [-118.74268, 34.0474], [-118.74264, 34.04745], [-118.7426, 34.04747], [-118.74241, 34.04748], [-118.74225, 34.04756], [-118.74218, 34.04762], [-118.74213, 34.04771], [-118.74211, 34.0478], [-118.74212, 34.04788], [-118.7417, 34.04787], [-118.74169, 34.04767], [-118.74183, 34.04726], [-118.74181, 34.04714], [-118.74169, 34.047], [-118.74163, 34.04687], [-118.74163, 34.04678], [-118.74174, 34.04608], [-118.74176, 34.04603], [-118.7418, 34.04598], [-118.74191, 34.04594], [-118.74197, 34.04589], [-118.74206, 34.04576], [-118.74231, 34.04584], [-118.74259, 34.04547], [-118.74346, 34.04547], [-118.74346, 34.0455]]], [[[-118.74218, 34.04546], [-118.74197, 34.04576], [-118.74191, 34.04574], [-118.74197, 34.04547], [-118.74218, 34.04546]]], [[[-118.74456, 34.04655], [-118.74451, 34.04662], [-118.74428, 34.04667], [-118.74419, 34.04672], [-118.7441, 34.04682], [-118.74409, 34.04692], [-118.74411, 34.04698], [-118.74427, 34.04729], [-118.74434, 34.04737], [-118.74443, 34.04743], [-118.74443, 34.04746], [-118.74397, 34.04767], [-118.74354, 34.04807], [-118.74347, 34.04815], [-118.7433, 34.0485], [-118.74327, 34.0486], [-118.74326, 34.04875], [-118.74332, 34.04905], [-118.74272, 34.04905], [-118.74274, 34.04896], [-118.74273, 34.04889], [-118.7427, 34.04883], [-118.74261, 34.04872], [-118.7426, 34.04861], [-118.74263, 34.04853], [-118.74278, 34.04841], [-118.74284, 34.04831], [-118.74287, 34.04821], [-118.74289, 34.04804], [-118.74292, 34.04795], [-118.74301, 34.04781], [-118.7431, 34.04772], [-118.74314, 34.0477], [-118.74343, 34.04786], [-118.74384, 34.04743], [-118.74383, 34.04734], [-118.74352, 34.04734], [-118.74349, 34.04663], [-118.74353, 34.04654], [-118.74362, 34.04646], [-118.74369, 34.04643], [-118.74383, 34.04643], [-118.74407, 34.04649], [-118.74418, 34.04649], [-118.74428, 34.04646], [-118.74451, 34.04633], [-118.74455, 34.04633], [-118.74456, 34.04655]]], [[[-118.74446, 34.04548], [-118.74437, 34.04551], [-118.74431, 34.04558], [-118.74421, 34.04596], [-118.74415, 34.04602], [-118.744, 34.04611], [-118.74395, 34.04613], [-118.74382, 34.04613], [-118.74344, 34.04592], [-118.74332, 34.04589], [-118.7432, 34.04589], [-118.74306, 34.04594], [-118.74297, 34.046], [-118.7429, 34.0461], [-118.74286, 34.04628], [-118.74282, 34.04633], [-118.74271, 34.04643], [-118.7427, 34.04644], [-118.74262, 34.04637], [-118.74267, 34.04631], [-118.74269, 34.04624], [-118.74268, 34.04615], [-118.74263, 34.04607], [-118.74263, 34.04597], [-118.74314, 34.04563], [-118.74343, 34.04562], [-118.74352, 34.04555], [-118.74354, 34.04547], [-118.74446, 34.04548]]], [[[-118.74441, 34.04761], [-118.74432, 34.04768], [-118.74426, 34.04776], [-118.74425, 34.04782], [-118.74428, 34.04796], [-118.74426, 34.04805], [-118.74417, 34.04819], [-118.74412, 34.04838], [-118.74413, 34.0485], [-118.74415, 34.04858], [-118.7443, 34.04877], [-118.74435, 34.04888], [-118.74436, 34.04905], [-118.74341, 34.04905], [-118.74335, 34.04875], [-118.74335, 34.04866], [-118.74337, 34.04857], [-118.74344, 34.0484], [-118.74358, 34.04814], [-118.74402, 34.04772], [-118.74437, 34.04757], [-118.74441, 34.04758], [-118.74441, 34.04761]]], [[[-118.74489, 34.04699], [-118.74422, 34.047], [-118.74418, 34.04693], [-118.74419, 34.04683], [-118.74424, 34.04677], [-118.74431, 34.04674], [-118.74452, 34.0467], [-118.74459, 34.04665], [-118.74464, 34.04659], [-118.74465, 34.04655], [-118.74464, 34.04615], [-118.74461, 34.04604], [-118.7446, 34.04592], [-118.74489, 34.04592], [-118.74489, 34.04699]]], [[[-118.74463, 34.04567], [-118.74456, 34.04578], [-118.74452, 34.04592], [-118.74452, 34.04607], [-118.74454, 34.04612], [-118.74453, 34.04622], [-118.74451, 34.04623], [-118.7442, 34.04609], [-118.74426, 34.04603], [-118.74431, 34.04596], [-118.74438, 34.04561], [-118.7444, 34.04558], [-118.74447, 34.04554], [-118.74456, 34.04555], [-118.7446, 34.04557], [-118.74463, 34.04561], [-118.74463, 34.04567]]], [[[-118.74489, 34.04905], [-118.74445, 34.04905], [-118.74445, 34.04894], [-118.7444, 34.04878], [-118.74422, 34.04853], [-118.74421, 34.04845], [-118.74422, 34.04832], [-118.74427, 34.04818], [-118.74433, 34.04809], [-118.74436, 34.048], [-118.74436, 34.04789], [-118.74434, 34.04783], [-118.74435, 34.04777], [-118.74439, 34.04771], [-118.74451, 34.04763], [-118.74454, 34.04759], [-118.74456, 34.04752], [-118.74452, 34.0474], [-118.74446, 34.04735], [-118.74439, 34.04731], [-118.7443, 34.04717], [-118.74489, 34.04717], [-118.74489, 34.04905]]]]} | Open Access 1 | El Nido Open Space Lots | 18520 | 200 | California State Coastal Conservancy 837 | State 5 | State Agency 5 | http://www.scc.ca.gov/ | Other State 5 | 27.406 | El Nido OS Lots |
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]);