superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
23 rows where MNG_AGENCY = 350 sorted by map
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
689 | 689 | 688 | {"type": "Polygon", "coordinates": [[[-117.6363, 33.4373], [-117.63625, 33.43732], [-117.63622, 33.43736], [-117.63622, 33.43744], [-117.63619, 33.43747], [-117.63618, 33.43754], [-117.63611, 33.43758], [-117.6361, 33.43765], [-117.636, 33.43768], [-117.63601, 33.43753], [-117.63591, 33.4373], [-117.63591, 33.43715], [-117.63589, 33.4371], [-117.6358, 33.43706], [-117.6357, 33.43709], [-117.63566, 33.43715], [-117.6357, 33.43723], [-117.63547, 33.43703], [-117.6354, 33.437], [-117.63532, 33.43699], [-117.63532, 33.43695], [-117.63553, 33.43688], [-117.63566, 33.43668], [-117.6357, 33.43666], [-117.63577, 33.43667], [-117.63585, 33.43672], [-117.63594, 33.43687], [-117.63593, 33.43698], [-117.63596, 33.43709], [-117.63593, 33.43725], [-117.63595, 33.43735], [-117.63598, 33.43736], [-117.63604, 33.43735], [-117.6362, 33.43724], [-117.63627, 33.43727], [-117.6363, 33.4373]]]} | Open Access 1 | Vista Del Sol Park | https://www.san-clemente.org/Home/Components/FacilityDirectory/FacilityDirectory/175/2553?npage=2 | 33544 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 0.64 | Vista Del Sol Park | |
9200 | 9200 | 9199 | {"type": "Polygon", "coordinates": [[[-117.64505, 33.45127], [-117.64504, 33.4513], [-117.64413, 33.45228], [-117.64406, 33.45224], [-117.64397, 33.45233], [-117.64367, 33.45216], [-117.64364, 33.45204], [-117.64236, 33.4514], [-117.64038, 33.44959], [-117.63954, 33.44907], [-117.63903, 33.44882], [-117.63922, 33.44872], [-117.63934, 33.44884], [-117.64005, 33.44927], [-117.64022, 33.44935], [-117.64042, 33.44939], [-117.64066, 33.44936], [-117.64081, 33.4493], [-117.64093, 33.44923], [-117.64139, 33.44891], [-117.64202, 33.4486], [-117.64207, 33.44861], [-117.64224, 33.44873], [-117.64237, 33.4488], [-117.64258, 33.44887], [-117.64309, 33.449], [-117.64323, 33.44907], [-117.6438, 33.44949], [-117.64392, 33.44961], [-117.64413, 33.45002], [-117.64467, 33.45091], [-117.64478, 33.45106], [-117.64502, 33.45122], [-117.64505, 33.45127]]]} | Open Access 1 | San Gorgonio Park | 24902 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 22.653 | San Gorgonio Park | ||
7029 | 7029 | 7028 | {"type": "Polygon", "coordinates": [[[-117.65667, 33.45327], [-117.65651, 33.45347], [-117.65636, 33.45339], [-117.65605, 33.45379], [-117.65609, 33.45383], [-117.65543, 33.45468], [-117.655, 33.4544], [-117.65575, 33.45346], [-117.6552, 33.45314], [-117.65544, 33.45275], [-117.6555, 33.45274], [-117.65588, 33.45285], [-117.65605, 33.45296], [-117.65615, 33.45296], [-117.65667, 33.45327]]]} | Open Access 1 | Mira Costa Park | 22272 | 1296 | San Clemente, City of 350 | City 2 | City Agency 2 | http://ci.san-clemente.ca.us/recreation-community | City 2 | 3.308 | Mira Costa 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]);