superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Sunset Cliffs Natural Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10119 | 10119 | 10118 | {"type": "MultiPolygon", "coordinates": [[[[-117.25835, 32.72538], [-117.2583, 32.72545], [-117.25817, 32.72548], [-117.25809, 32.72559], [-117.25802, 32.72564], [-117.25795, 32.72568], [-117.2576, 32.72572], [-117.25745, 32.72576], [-117.25726, 32.72585], [-117.25719, 32.72589], [-117.25683, 32.72582], [-117.2572, 32.72535], [-117.25728, 32.72522], [-117.25736, 32.72498], [-117.25737, 32.72473], [-117.25735, 32.72372], [-117.25729, 32.72357], [-117.25695, 32.72304], [-117.25692, 32.72293], [-117.25706, 32.72131], [-117.25707, 32.72076], [-117.25704, 32.72049], [-117.25696, 32.72015], [-117.25689, 32.71985], [-117.25681, 32.71961], [-117.25216, 32.71872], [-117.25198, 32.71945], [-117.25224, 32.7195], [-117.25207, 32.72015], [-117.25279, 32.7203], [-117.25272, 32.7206], [-117.25267, 32.72072], [-117.25203, 32.72059], [-117.2517, 32.72072], [-117.25179, 32.72035], [-117.25151, 32.72027], [-117.25157, 32.71998], [-117.25037, 32.71975], [-117.25064, 32.71952], [-117.25086, 32.71916], [-117.25121, 32.71888], [-117.25137, 32.7188], [-117.25172, 32.71776], [-117.25177, 32.71768], [-117.25189, 32.71759], [-117.25199, 32.71756], [-117.25262, 32.71755], [-117.25295, 32.71676], [-117.25301, 32.71618], [-117.25308, 32.71597], [-117.25308, 32.71579], [-117.25345, 32.71446], [-117.25393, 32.71466], [-117.25414, 32.71469], [-117.25425, 32.71468], [-117.25544, 32.71444], [-117.25528, 32.71392], [-117.25506, 32.71353], [-117.25492, 32.71341], [-117.25473, 32.71291], [-117.25616, 32.71288], [-117.25617, 32.7129], [-117.25618, 32.71309], [-117.25626, 32.71323], [-117.2563, 32.7134], [-117.2563, 32.71348], [-117.25628, 32.71353], [-117.25631, 32.71361], [-117.25627, 32.71376], [-117.25635, 32.71379], [-117.25637, 32.71426], [-117.25642, 32.71436], [-117.25642, 32.71446], [-117.25639, 32.7146], [-117.25644, 32.71468], [-117.25655, 32.71479], [-117.25647, 32.7149], [-117.25646, 32.71495], [-117.25651, 32.71504], [-117.25656, 32.71509], [-117.25656, 32.71511], [-117.25653, 32.71517], [-117.25593, 32.71555], [-117.25583, 32.71567], [-117.2558, 32.71576], [-117.25579, 32.71585], [-117.25581, 32.71595], [-117.25579, 32.716], [-117.2558, 32.71616], [-117.25578, 32.71622], [-117.25582, 32.71632], [-117.25579, 32.71646], [-117.25579, 32.71666], [-117.25593, 32.71711], [-117.25596, 32.71727], [-117.2561, 32.71764], [-117.25622, 32.71784], [-117.25626, 32.71794], [-117.25632, 32.71819], [-117.25643, 32.71843], [-117.25648, 32.7185], [-117.2565, 32.71866], [-117.25655, 32.7187], [-117.25663, 32.71873], [-117.2568, 32.71873], [-117.25684, 32.71875], [-117.25685, 32.71878], [-117.25683, 32.71886], [-117.25674, 32.71891], [-117.25678, 32.71905], [-117.25678, 32.71932], [-117.2568, 32.71939], [-117.25683, 32.71943], [-117.25688, 32.71946], [-117.25693, 32.71946], [-117.25704, 32.71942], [-117.25706, 32.71947], [-117.25706, 32.71957], [-117.25708, 32.71961], [-117.25723, 32.71974], [-117.25727, 32.71981], [-117.25726, 32.71995], [-117.2572, 32.72007], [-117.25719, 32.72014], [-117.2572, 32.72035], [-117.25724, 32.72048], [-117.25727, 32.72067], [-117.25729, 32.72089], [-117.25725, 32.72128], [-117.25716, 32.72152], [-117.25714, 32.7217], [-117.2571, 32.72187], [-117.2571, 32.72203], [-117.25713, 32.72218], [-117.2571, 32.72293], [-117.25716, 32.7231], [-117.25724, 32.72313], [-117.25737, 32.72314], [-117.25745, 32.7232], [-117.25748, 32.72325], [-117.25752, 32.72336], [-117.2575, 32.72347], [-117.25751, 32.72359], [-117.25755, 32.72367], [-117.25765, 32.72375], [-117.25769, 32.72388], [-117.25771, 32.724], [-117.25767, 32.724], [-117.25758, 32.72403], [-117.25759, 32.72409], [-117.25773, 32.7243], [-117.25775, 32.72444], [-117.2577, 32.7245], [-117.2576, 32.72456], [-117.25756, 32.72462], [-117.25755, 32.7247], [-117.25763, 32.72479], [-117.25781, 32.72483], [-117.2579, 32.72498], [-117.25807, 32.72511], [-117.25823, 32.7252], [-117.2583, 32.72527], [-117.25835, 32.72538]]], [[[-117.25729, 32.73063], [-117.25725, 32.7307], [-117.25719, 32.73071], [-117.25706, 32.73066], [-117.25694, 32.73058], [-117.25688, 32.73056], [-117.25678, 32.73057], [-117.25673, 32.73062], [-117.25674, 32.7307], [-117.2568, 32.73076], [-117.25686, 32.73088], [-117.25687, 32.73096], [-117.25684, 32.73122], [-117.25689, 32.73128], [-117.25693, 32.73137], [-117.2569, 32.73142], [-117.25679, 32.73144], [-117.25671, 32.7315], [-117.25668, 32.73157], [-117.25668, 32.73161], [-117.25671, 32.73169], [-117.25679, 32.73177], [-117.25682, 32.73183], [-117.25682, 32.73189], [-117.25685, 32.73197], [-117.2569, 32.73204], [-117.2569, 32.7321], [-117.25681, 32.73229], [-117.2566, 32.73249], [-117.25657, 32.73257], [-117.25657, 32.73269], [-117.25661, 32.73278], [-117.25664, 32.73282], [-117.25679, 32.73285], [-117.25691, 32.73295], [-117.25703, 32.73336], [-117.25689, 32.73336], [-117.2568, 32.73345], [-117.25681, 32.73351], [-117.25688, 32.73358], [-117.2569, 32.73361], [-117.25688, 32.73364], [-117.25681, 32.73368], [-117.25667, 32.73369], [-117.2566, 32.73371], [-117.25654, 32.73379], [-117.25652, 32.73394], [-117.25644, 32.73411], [-117.25645, 32.73422], [-117.25652, 32.73439], [-117.25651, 32.73452], [-117.25649, 32.73456], [-117.25643, 32.73454], [-117.25634, 32.73448], [-117.25631, 32.73448], [-117.25628, 32.73451], [-117.25632, 32.73467], [-117.25631, 32.73471], [-117.25626, 32.73477], [-117.25611, 32.73479], [-117.25605, 32.73484], [-117.25598, 32.73494], [-117.25591, 32.73515], [-117.2559, 32.73534], [-117.25593, 32.73547], [-117.256, 32.73565], [-117.25602, 32.73572], [-117.25597, 32.73577], [-117.25579, 32.73578], [-117.25574, 32.73584], [-117.25572, 32.73589], [-117.25547, 32.73573], [-117.25559, 32.73558], [-117.25566, 32.73543], [-117.25572, 32.73527], [-117.25576, 32.73496], [-117.25585, 32.73456], [-117.25596, 32.73433], [-117.25614, 32.73404], [-117.25618, 32.73391], [-117.25621, 32.73367], [-117.2562, 32.73352], [-117.25603, 32.73276], [-117.25603, 32.73265], [-117.25607, 32.73251], [-117.25616, 32.73237], [-117.25632, 32.73217], [-117.25639, 32.73207], [-117.25645, 32.73195], [-117.25651, 32.73179], [-117.25653, 32.73168], [-117.2566, 32.73077], [-117.2566, 32.73059], [-117.25657, 32.73045], [-117.25647, 32.73024], [-117.25634, 32.73005], [-117.25625, 32.72995], [-117.25615, 32.72976], [-117.25547, 32.72733], [-117.25549, 32.72727], [-117.25556, 32.72717], [-117.25606, 32.72658], [-117.25632, 32.7264], [-117.25654, 32.7263], [-117.25663, 32.72624], [-117.2567, 32.72612], [-117.25674, 32.72597], [-117.25699, 32.72602], [-117.25676, 32.7262], [-117.25676, 32.72623], [-117.25667, 32.72631], [-117.25649, 32.72657], [-117.25639, 32.72668], [-117.25628, 32.72689], [-117.25619, 32.72701], [-117.25574, 32.72751], [-117.25569, 32.7276], [-117.25575, 32.72781], [-117.25577, 32.72808], [-117.25583, 32.72818], [-117.2559, 32.72834], [-117.25598, 32.72847], [-117.2561, 32.72877], [-117.25615, 32.72903], [-117.25614, 32.72933], [-117.25619, 32.72958], [-117.25628, 32.72982], [-117.25631, 32.72987], [-117.25638, 32.72992], [-117.25649, 32.72993], [-117.25664, 32.72998], [-117.25683, 32.73009], [-117.25694, 32.73018], [-117.25699, 32.73026], [-117.25709, 32.73045], [-117.25715, 32.73051], [-117.25725, 32.73056], [-117.25729, 32.73063]]]]} | Open Access 1 | Sunset Cliffs Natural Park | https://www.sandiego.gov/park-and-recreation/parks/regional/shoreline/sunset | 26042 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 67.223 | Sunset Cliffs Natural Park |
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]);