superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where MNG_AG_TYP = 5 and PARK_URL = "https://fsp.sdsu.edu/about-us/"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13006 | 13006 | 13005 | {"type": "Polygon", "coordinates": [[[-117.15937, 33.4648], [-117.15693, 33.46596], [-117.15547, 33.46627], [-117.1551, 33.46876], [-117.15582, 33.4699], [-117.15547, 33.4701], [-117.15359, 33.47159], [-117.15293, 33.47188], [-117.14836, 33.47303], [-117.14752, 33.4732], [-117.14553, 33.47346], [-117.1454, 33.4735], [-117.1452, 33.47361], [-117.14441, 33.47424], [-117.14428, 33.4744], [-117.14423, 33.47451], [-117.14422, 33.47465], [-117.14428, 33.47512], [-117.14445, 33.47524], [-117.14434, 33.47534], [-117.14243, 33.47398], [-117.14117, 33.47457], [-117.1392, 33.47439], [-117.13887, 33.4735], [-117.14494, 33.46886], [-117.14521, 33.46914], [-117.14522, 33.46914], [-117.14519, 33.46582], [-117.15408, 33.46502], [-117.15937, 33.4648]]]} | No Public Access 3 | Santa Margarita Ecological Reserve | https://fsp.sdsu.edu/about-us/ | 33343 | 221 | San Diego State University 378 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 243.201 | Santa Margarita ER | 1962 |
14536 | 14536 | 14535 | {"type": "MultiPolygon", "coordinates": [[[[-117.20651, 33.43216], [-117.20644, 33.44303], [-117.19757, 33.44297], [-117.1975, 33.44656], [-117.19751, 33.44657], [-117.20642, 33.44665], [-117.20637, 33.45054], [-117.16741, 33.4645], [-117.16732, 33.46177], [-117.16524, 33.46316], [-117.16477, 33.46349], [-117.16432, 33.46385], [-117.1639, 33.46423], [-117.16319, 33.46492], [-117.16317, 33.46482], [-117.16297, 33.46465], [-117.15938, 33.4648], [-117.15931, 33.46482], [-117.15421, 33.46507], [-117.14525, 33.46588], [-117.14538, 33.46928], [-117.14494, 33.46886], [-117.14213, 33.46585], [-117.13783, 33.46151], [-117.1408, 33.46152], [-117.14069, 33.45435], [-117.13656, 33.45432], [-117.13646, 33.45406], [-117.13637, 33.45348], [-117.1363, 33.45254], [-117.13632, 33.44932], [-117.13637, 33.4487], [-117.13646, 33.448], [-117.13653, 33.44776], [-117.13676, 33.44716], [-117.15344, 33.4472], [-117.15378, 33.43266], [-117.15812, 33.43261], [-117.15812, 33.43977], [-117.15813, 33.43978], [-117.16663, 33.43969], [-117.16672, 33.43254], [-117.17132, 33.43242], [-117.17338, 33.43238], [-117.17327, 33.42847], [-117.1779, 33.42839], [-117.1779, 33.43232], [-117.18245, 33.43226], [-117.18253, 33.4283], [-117.19167, 33.42815], [-117.19556, 33.42806], [-117.19537, 33.42845], [-117.19525, 33.42931], [-117.19526, 33.42932], [-117.19685, 33.429], [-117.19721, 33.42851], [-117.19932, 33.42801], [-117.20077, 33.42797], [-117.20291, 33.42795], [-117.20281, 33.43006], [-117.19914, 33.43009], [-117.199, 33.43159], [-117.19592, 33.4316], [-117.19589, 33.43216], [-117.20651, 33.43216]], [[-117.17573, 33.43756], [-117.17571, 33.43677], [-117.17535, 33.43751], [-117.17514, 33.43806], [-117.17463, 33.43969], [-117.17359, 33.44318], [-117.17439, 33.44316], [-117.17551, 33.43984], [-117.17588, 33.43855], [-117.17623, 33.43758], [-117.17573, 33.43756]]], [[[-117.21972, 33.42999], [-117.21971, 33.43008], [-117.21941, 33.43087], [-117.21888, 33.43101], [-117.21852, 33.43096], [-117.21805, 33.43108], [-117.21795, 33.43113], [-117.21774, 33.43153], [-117.21722, 33.43152], [-117.21407, 33.43154], [-117.21414, 33.42781], [-117.21857, 33.4278], [-117.21851, 33.42935], [-117.21925, 33.42978], [-117.21965, 33.42988], [-117.2197, 33.42993], [-117.21972, 33.42999]]]]} | Restricted Access 2 | Santa Margarita Ecological Reserve | https://fsp.sdsu.edu/about-us/ | 33342 | 221 | San Diego State University 378 | State 5 | State Agency 5 | http://www.sdsu.edu/ | Other State 5 | 4355.304 | Santa Margarita ER | 1962 |
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]);