superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
24 rows where MNG_AGENCY = 28 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9243 | 9243 | 9242 | {"type": "Polygon", "coordinates": [[[-122.49515, 37.58657], [-122.49386, 37.58803], [-122.49373, 37.58789], [-122.49356, 37.58775], [-122.49138, 37.58627], [-122.49111, 37.58614], [-122.49084, 37.58606], [-122.49175, 37.58498], [-122.49198, 37.58497], [-122.49232, 37.5852], [-122.49249, 37.58522], [-122.49283, 37.58504], [-122.49319, 37.5854], [-122.49394, 37.58538], [-122.49413, 37.58585], [-122.49424, 37.58593], [-122.4943, 37.58589], [-122.49442, 37.58597], [-122.49458, 37.58628], [-122.49515, 37.58657]]]} | Open Access 1 | Sanchez Adobe County Park | 25006 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 15.789 | Sanchez Adobe County Park | ||
8139 | 8139 | 8138 | {"type": "Polygon", "coordinates": [[[-122.51046, 37.51201], [-122.51023, 37.51234], [-122.50987, 37.51294], [-122.50982, 37.51293], [-122.50706, 37.51697], [-122.50076, 37.5116], [-122.50136, 37.51061], [-122.50087, 37.51021], [-122.50163, 37.50897], [-122.50091, 37.50795], [-122.50104, 37.50784], [-122.50039, 37.50696], [-122.50001, 37.50719], [-122.49898, 37.50631], [-122.49883, 37.50653], [-122.49817, 37.50681], [-122.49557, 37.50574], [-122.4949, 37.50607], [-122.49505, 37.50583], [-122.49492, 37.50576], [-122.4946, 37.5047], [-122.494, 37.5042], [-122.49436, 37.5036], [-122.49452, 37.50365], [-122.49471, 37.50331], [-122.49457, 37.50324], [-122.49472, 37.50299], [-122.49465, 37.50191], [-122.49398, 37.50143], [-122.49432, 37.50124], [-122.49578, 37.50023], [-122.49585, 37.50038], [-122.49593, 37.50051], [-122.49634, 37.50095], [-122.49652, 37.50132], [-122.49654, 37.50142], [-122.49664, 37.50204], [-122.49673, 37.50251], [-122.49673, 37.50345], [-122.49666, 37.50368], [-122.49674, 37.50378], [-122.4984, 37.50457], [-122.49871, 37.50239], [-122.49742, 37.50097], [-122.4972, 37.49987], [-122.4983, 37.49966], [-122.49979, 37.49844], [-122.49984, 37.49849], [-122.49978, 37.49862], [-122.49996, 37.49876], [-122.50002, 37.49897], [-122.49996, 37.49897], [-122.49914, 37.49951], [-122.49909, 37.4997], [-122.49903, 37.50002], [-122.49892, 37.50017], [-122.49884, 37.50042], [-122.49887, 37.50076], [-122.49902, 37.50115], [-122.49912, 37.50132], [-122.49953, 37.50173], [-122.49966, 37.50174], [-122.49981, 37.50193], [-122.49974, 37.50205], [-122.49974, 37.50223], [-122.49983, 37.50247], [-122.50002, 37.50288], [-122.50028, 37.50332], [-122.50044, 37.50343], [-122.50067, 37.50356], [-122.5011, 37.50398], [-122.50167, 37.50469], [-122.5019, 37.50487], [-122.50202, 37.50501], [-122.50209, 37.50507], [-122.50218, 37.50512], [-122.50229, 37.50513], [-122.50238, 37.50519], [-122.50258, 37.50522], [-122.50271, 37.50536], [-122.5029, 37.50543], [-122.50306, 37.50554], [-122.50325, 37.50562], [-122.50351, 37.50578], [-122.50374, 37.50596], [-122.50383, 37.506], [-122.50403, 37.50606], [-122.50419, 37.50617], [-122.5043, 37.50616], [-122.50462, 37.5062], [-122.50481, 37.50628], [-122.50487, 37.50634], [-122.50492, 37.50641], [-122.50516, 37.5066], [-122.50542, 37.50688], [-122.5056, 37.50697], [-122.50566, 37.50705], [-122.50581, 37.50716], [-122.50591, 37.50731], [-122.50598, 37.50738], [-122.5061, 37.50752], [-122.50625, 37.50776], [-122.50632, 37.50783], [-122.50638, 37.508], [-122.50646, 37.50806], [-122.50657, 37.5082], [-122.50664, 37.50827], [-122.50674, 37.50843], [-122.50687, 37.50857], [-122.507, 37.50881], [-122.50738, 37.50922], [-122.50761, 37.5094], [-122.5077, 37.50956], [-122.50781, 37.50964], [-122.50804, 37.50923], [-122.50827, 37.50949], [-122.5092, 37.51101], [-122.51046, 37.51201]], [[-122.49896, 37.5063], [-122.49911, 37.50606], [-122.49883, 37.50595], [-122.49869, 37.50619], [-122.49896, 37.5063]]]} | Open Access 1 | Pillar Point Bluff | 23670 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 226.521 | Pillar Point Bluff | ||
13112 | 13112 | 13111 | {"type": "Polygon", "coordinates": [[[-122.51225, 37.52751], [-122.51195, 37.52795], [-122.51135, 37.52763], [-122.512, 37.5274], [-122.51225, 37.52751]]]} | Open Access 1 | Moss Beach Park | 30389 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 0.6 | Moss Beach Park | ||
13110 | 13110 | 13109 | {"type": "Polygon", "coordinates": [[[-122.52068, 37.57395], [-122.5207, 37.57409], [-122.52068, 37.57423], [-122.52049, 37.57446], [-122.52045, 37.5746], [-122.52045, 37.57474], [-122.52041, 37.57488], [-122.52041, 37.57516], [-122.52039, 37.57534], [-122.52036, 37.57543], [-122.52028, 37.57555], [-122.52011, 37.5756], [-122.51993, 37.57562], [-122.51977, 37.57568], [-122.51954, 37.57583], [-122.51938, 37.57596], [-122.51928, 37.57608], [-122.51913, 37.57616], [-122.51896, 37.57617], [-122.51879, 37.57615], [-122.51857, 37.57594], [-122.5184, 37.57591], [-122.51827, 37.576], [-122.51823, 37.57613], [-122.51813, 37.57625], [-122.51807, 37.57638], [-122.51807, 37.57665], [-122.51792, 37.57705], [-122.51791, 37.57719], [-122.51796, 37.57749], [-122.5179, 37.57762], [-122.51782, 37.57797], [-122.51776, 37.57816], [-122.5177, 37.57843], [-122.51745, 37.579], [-122.51746, 37.57937], [-122.51754, 37.57964], [-122.51755, 37.57985], [-122.51739, 37.58021], [-122.51736, 37.58083], [-122.51732, 37.58094], [-122.51718, 37.58118], [-122.51792, 37.58123], [-122.5179, 37.58134], [-122.51788, 37.58139], [-122.51781, 37.58143], [-122.51776, 37.58149], [-122.51763, 37.58155], [-122.51756, 37.58159], [-122.51742, 37.58163], [-122.51707, 37.58186], [-122.51697, 37.58198], [-122.5169, 37.58202], [-122.51679, 37.58224], [-122.51678, 37.58229], [-122.51679, 37.58251], [-122.51686, 37.58256], [-122.51689, 37.58262], [-122.51688, 37.58273], [-122.51683, 37.58286], [-122.51683, 37.58292], [-122.51681, 37.58309], [-122.51685, 37.58315], [-122.51683, 37.58321], [-122.51688, 37.58343], [-122.51699, 37.58362], [-122.51714, 37.58378], [-122.51722, 37.58394], [-122.51722, 37.58401], [-122.51732, 37.58413], [-122.51736, 37.58426], [-122.51738, 37.5845], [-122.51734, 37.58463], [-122.51735, 37.58474], [-122.51733, 37.58489], [-122.51728, 37.58502], [-122.51721, 37.58515], [-122.51649, 37.58524], [-122.51604, 37.58525], [-122.51123, 37.58564], [-122.51071, 37.58567], [-122.51024, 37.58562], [-122.50897, 37.58527], [-122.50853, 37.58519], [-122.50822, 37.58515], [-122.5083, 37.58473], [-122.50945, 37.58484], [-122.50993, 37.58514], [-122.5102, 37.58521], [-122.51044, 37.58524], [-122.51072, 37.58526], [-122.51099, 37.58498], [-122.51181, 37.5849], [-122.5124, 37.58521], [-122.51398, 37.58507], [-122.5145, 37.58471], [-122.51438, 37.58321], [-122.51384, 37.58307], [-122.51344, 37.58178], [-122.5137, 37.58153], [-122.51392, 37.58135], [-122.51579, 37.57957], [-122.51601, 37.57904], [-122.51579, 37.57652], [-122.51668, 37.57545], [-122.51754, 37.57485], [-122.51768, 37.57465], [-122.51773, 37.57453], [-122.51776, 37.57432], [-122.51774, 37.57417], [-122.5177, 37.57405], [-122.51761, 37.57389], [-122.51747, 37.57374], [-122.51676, 37.57321], [-122.51655, 37.57299], [-122.51597, 37.57218], [-122.51591, 37.57184], [-122.51591, 37.5715], [-122.51594, 37.57139], [-122.516, 37.57076], [-122.51611, 37.57074], [-122.51612, 37.57058], [-122.5161, 37.57038], [-122.51606, 37.57026], [-122.51596, 37.57005], [-122.5159, 37.56996], [-122.51539, 37.56936], [-122.51636, 37.56913], [-122.51627, 37.56924], [-122.5163, 37.56937], [-122.5164, 37.56949], [-122.51656, 37.56953], [-122.51691, 37.56956], [-122.51709, 37.56956], [-122.51724, 37.56962], [-122.51736, 37.56972], [-122.51737, 37.56987], [-122.51732, 37.57], [-122.51706, 37.57037], [-122.51696, 37.57048], [-122.51694, 37.57062], [-122.51689, 37.57076], [-122.51699, 37.57087], [-122.51713, 37.57095], [-122.51728, 37.57101], [-122.51762, 37.57096], [-122.51778, 37.57101], [-122.51793, 37.57094], [-122.51808, 37.57102], [-122.51824, 37.57107], [-122.51837, 37.57117], [-122.51845, 37.57129], [-122.51831, 37.57154], [-122.51805, 37.57171], [-122.51818, 37.57178], [-122.51825, 37.57191], [-122.5184, 37.57198], [-122.51851, 37.57209], [-122.51865, 37.57216], [-122.51874, 37.57228], [-122.51852, 37.5725], [-122.51835, 37.57253], [-122.51817, 37.57255], [-122.51771, 37.57273], [-122.51764, 37.57286], [-122.5178, 37.5731], [-122.51798, 37.57314], [-122.51813, 37.57321], [-122.51829, 37.57323], [-122.51845, 37.57316], [-122.51854, 37.57328], [-122.51856, 37.57342], [-122.51852, 37.57354], [-122.51852, 37.57356], [-122.51868, 37.57356], [-122.51876, 37.57344], [-122.51886, 37.57333], [-122.51902, 37.5734], [-122.51905, 37.57354], [-122.51898, 37.57364], [-122.51898, 37.57366], [-122.51914, 37.57371], [-122.51929, 37.57366], [-122.51938, 37.57354], [-122.51955, 37.57354], [-122.51971, 37.57361], [-122.51987, 37.57356], [-122.52004, 37.57357], [-122.5202, 37.57364], [-122.52025, 37.57377], [-122.52024, 37.5739], [-122.52057, 37.57384], [-122.52068, 37.57395]]]} | Open Access 1 | Devil's Slide Trail | http://parks.smcgov.org/devils-slide-trail | 30387 | 324 | San Mateo County Parks and Recreation Dept., County of 28 | County 3 | County Agency - Parks 7 | http://www.co.sanmateo.ca.us/portal/site/parks/ | County 3 | 99.186 | Devil's Slide Trail |
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]);