superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where MNG_AG_TYP = 5 and PARK_URL = "http://www.parks.ca.gov/?page_id=517"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
218 | 218 | 217 | {"type": "MultiPolygon", "coordinates": [[[[-121.99022, 37.88255], [-121.98134, 37.8845], [-121.97997, 37.88479], [-121.97916, 37.885], [-121.97876, 37.88507], [-121.9629, 37.88821], [-121.94845, 37.88824], [-121.95068, 37.89844], [-121.96276, 37.89871], [-121.96292, 37.89242], [-121.9636, 37.89241], [-121.96361, 37.89202], [-121.9637, 37.89199], [-121.96419, 37.89211], [-121.96439, 37.89227], [-121.96458, 37.89238], [-121.96519, 37.89251], [-121.96557, 37.89263], [-121.96577, 37.8927], [-121.96619, 37.89291], [-121.96662, 37.89305], [-121.96725, 37.89299], [-121.96794, 37.8932], [-121.9683, 37.89344], [-121.96883, 37.89355], [-121.96937, 37.89324], [-121.96986, 37.89303], [-121.97007, 37.8929], [-121.9703, 37.89282], [-121.97114, 37.89308], [-121.97163, 37.89311], [-121.97185, 37.89318], [-121.97235, 37.89318], [-121.97275, 37.89343], [-121.97297, 37.89353], [-121.97425, 37.89412], [-121.97502, 37.89405], [-121.97491, 37.9014], [-121.9741, 37.90141], [-121.97411, 37.90195], [-121.9749, 37.90197], [-121.97484, 37.90624], [-121.97342, 37.90624], [-121.97339, 37.90569], [-121.97277, 37.90569], [-121.97276, 37.90624], [-121.96959, 37.90624], [-121.96461, 37.90614], [-121.96458, 37.90553], [-121.96399, 37.90555], [-121.964, 37.90613], [-121.9626, 37.9061], [-121.96272, 37.916], [-121.96018, 37.916], [-121.96004, 37.91406], [-121.95506, 37.91476], [-121.95081, 37.91612], [-121.94755, 37.91706], [-121.94502, 37.91928], [-121.94365, 37.92021], [-121.94196, 37.92213], [-121.94194, 37.92114], [-121.94205, 37.92069], [-121.94195, 37.92024], [-121.94192, 37.9198], [-121.94177, 37.91979], [-121.9418, 37.92025], [-121.9419, 37.92072], [-121.94179, 37.92114], [-121.94182, 37.9248], [-121.94154, 37.92666], [-121.93273, 37.92667], [-121.93265, 37.9218], [-121.92913, 37.9218], [-121.92735, 37.92188], [-121.92691, 37.92086], [-121.91901, 37.92085], [-121.91901, 37.9235], [-121.9187, 37.92344], [-121.91864, 37.92341], [-121.91848, 37.92323], [-121.9184, 37.92316], [-121.9183, 37.92312], [-121.91793, 37.923], [-121.91768, 37.92297], [-121.91682, 37.92297], [-121.91664, 37.92296], [-121.91648, 37.92289], [-121.9161, 37.92263], [-121.91583, 37.9225], [-121.91563, 37.92246], [-121.91523, 37.92243], [-121.91507, 37.92246], [-121.91493, 37.92253], [-121.91471, 37.92235], [-121.91437, 37.92234], [-121.91437, 37.92196], [-121.91587, 37.92212], [-121.91588, 37.92087], [-121.91436, 37.92085], [-121.91431, 37.9166], [-121.9143, 37.91207], [-121.91433, 37.90708], [-121.91428, 37.90488], [-121.91188, 37.90492], [-121.91191, 37.90708], [-121.90842, 37.90708], [-121.90893, 37.90653], [-121.90909, 37.90658], [-121.91029, 37.90546], [-121.90974, 37.90498], [-121.90941, 37.90544], [-121.90829, 37.90623], [-121.90829, 37.90625], [-121.90832, 37.90627], [-121.90683, 37.90708], [-121.89519, 37.90707], [-121.89516, 37.9085], [-121.89551, 37.90851], [-121.89548, 37.91071], [-121.89513, 37.91073], [-121.89505, 37.91746], [-121.89399, 37.91678], [-121.89403, 37.9163], [-121.89395, 37.91624], [-121.89345, 37.91626], [-121.89332, 37.91617], [-121.893, 37.91613], [-121.89222, 37.91564], [-121.89186, 37.91547], [-121.8919, 37.91542], [-121.89189, 37.9154], [-121.89127, 37.91516], [-121.89083, 37.91502], [-121.89075, 37.91509], [-121.88979, 37.91478], [-121.88959, 37.91463], [-121.88899, 37.91434], [-121.8886, 37.91421], [-121.8882, 37.91416], [-121.88782, 37.91402], [-121.8876, 37.91382], [-121.88735, 37.91386], [-121.88697, 37.91363], [-121.8866, 37.91335], [-121.88588, 37.91276], [-121.88586, 37.91276], [-121.88586, 37.9128], [-121.88552, 37.91253], [-121.88535, 37.91243], [-121.88516, 37.91234], [-121.88496, 37.91226], [-121.88455, 37.91217], [-121.88412, 37.91214], [-121.88259, 37.91217], [-121.88238, 37.91213], [-121.88209, 37.91202], [-121.88166, 37.9117], [-121.88147, 37.91159], [-121.88076, 37.91127], [-121.88046, 37.91111], [-121.87997, 37.91071], [-121.87927, 37.91011], [-121.8786, 37.90938], [-121.87809, 37.90908], [-121.87778, 37.90895], [-121.87677, 37.90862], [-121.87676, 37.90718], [-121.8758, 37.90717], [-121.87477, 37.90663], [-121.87465, 37.90654], [-121.87445, 37.90635], [-121.87437, 37.90624], [-121.87425, 37.90602], [-121.87433, 37.90575], [-121.87368, 37.9001], [-121.87311, 37.89902], [-121.87237, 37.89679], [-121.87234, 37.89663], [-121.87235, 37.89647], [-121.87238, 37.89633], [-121.87254, 37.89603], [-121.87271, 37.89566], [-121.8733, 37.89385], [-121.87338, 37.89357], [-121.87341, 37.89332], [-121.8735, 37.89225], [-121.87348, 37.89206], [-121.87342, 37.89188], [-121.87331, 37.89172], [-121.8732, 37.89161], [-121.87245, 37.89095], [-121.87228, 37.89083], [-121.87177, 37.8906], [-121.8712, 37.89018], [-121.87104, 37.89009], [-121.87053, 37.88987], [-121.87043, 37.8898], [-121.87024, 37.88965], [-121.87017, 37.88957], [-121.87006, 37.8894], [-121.86993, 37.88917], [-121.8806, 37.88925], [-121.8859, 37.88922], [-121.88591, 37.88547], [-121.89521, 37.88546], [-121.89522, 37.88178], [-121.89988, 37.88175], [-121.90006, 37.87495], [-121.89545, 37.87493], [-121.89568, 37.86751], [-121.88655, 37.86747], [-121.88663, 37.8497], [-121.89577, 37.84968], [-121.8958, 37.84565], [-121.8962, 37.83937], [-121.87813, 37.83958], [-121.87823, 37.84584], [-121.87788, 37.84586], [-121.87755, 37.85319], [-121.85932, 37.853], [-121.85092, 37.85301], [-121.8509, 37.85247], [-121.84961, 37.85247], [-121.8496, 37.85269], [-121.84801, 37.85271], [-121.848, 37.85256], [-121.84808, 37.85215], [-121.84763, 37.85179], [-121.84716, 37.85132], [-121.84629, 37.85085], [-121.84566, 37.8508], [-121.84547, 37.85029], [-121.84526, 37.85019], [-121.84469, 37.84972], [-121.8445, 37.84959], [-121.84414, 37.84926], [-121.84404, 37.84923], [-121.84407, 37.84584], [-121.84105, 37.84584], [-121.84109, 37.83887], [-121.85028, 37.83882], [-121.85033, 37.83527], [-121.85955, 37.83521], [-121.85955, 37.82449], [-121.86869, 37.82471], [-121.86858, 37.81748], [-121.87804, 37.81747], [-121.87806, 37.81681], [-121.87932, 37.8168], [-121.88123, 37.81757], [-121.88228, 37.81889], [-121.8873, 37.81837], [-121.88789, 37.8189], [-121.88797, 37.82277], [-121.89025, 37.82461], [-121.89028, 37.8257], [-121.8932, 37.82662], [-121.89596, 37.82658], [-121.89591, 37.82365], [-121.89854, 37.82361], [-121.90008, 37.8211], [-121.89793, 37.8193], [-121.89931, 37.81826], [-121.90161, 37.82017], [-121.90067, 37.82322], [-121.90327, 37.82523], [-121.90691, 37.82227], [-121.91209, 37.82222], [-121.9121, 37.82276], [-121.90908, 37.82523], [-121.90913, 37.82755], [-121.91224, 37.82753], [-121.91229, 37.83027], [-121.91127, 37.83172], [-121.91162, 37.83197], [-121.9113, 37.83231], [-121.91165, 37.83287], [-121.91267, 37.8325], [-121.91324, 37.8319], [-121.91355, 37.83136], [-121.91397, 37.83144], [-121.9146, 37.83229], [-121.91471, 37.83293], [-121.91497, 37.83329], [-121.91572, 37.83343], [-121.91553, 37.83414], [-121.91547, 37.83501], [-121.9159, 37.83546], [-121.91689, 37.83529], [-121.91719, 37.83475], [-121.91708, 37.83421], [-121.91752, 37.83409], [-121.91832, 37.83307], [-121.91836, 37.83278], [-121.91745, 37.83201], [-121.91823, 37.83067], [-121.91921, 37.83018], [-121.91919, 37.82867], [-121.92361, 37.82862], [-121.92549, 37.82919], [-121.9255, 37.83], [-121.92733, 37.83003], [-121.92742, 37.83415], [-121.92845, 37.83415], [-121.93155, 37.83331], [-121.9329, 37.835], [-121.93463, 37.835], [-121.93463, 37.83638], [-121.93428, 37.838], [-121.93751, 37.83898], [-121.93885, 37.83923], [-121.94144, 37.8393], [-121.94387, 37.83733], [-121.94394, 37.83734], [-121.94392, 37.83741], [-121.94512, 37.83954], [-121.94605, 37.84138], [-121.94754, 37.84103], [-121.94755, 37.8422], [-121.94793, 37.84235], [-121.94799, 37.84242], [-121.94818, 37.84274], [-121.94817, 37.84279], [-121.94815, 37.84282], [-121.94773, 37.84317], [-121.94771, 37.84326], [-121.94775, 37.84333], [-121.9478, 37.84338], [-121.94791, 37.84343], [-121.94821, 37.84353], [-121.94828, 37.84357], [-121.94883, 37.84391], [-121.94981, 37.84436], [-121.94971, 37.84477], [-121.94912, 37.84497], [-121.94923, 37.84553], [-121.94985, 37.84652], [-121.95006, 37.84682], [-121.95085, 37.8512], [-121.95146, 37.8512], [-121.95155, 37.85291], [-121.96052, 37.85274], [-121.96053, 37.85297], [-121.96054, 37.85706], [-121.96358, 37.858], [-121.96363, 37.85984], [-121.9651, 37.85982], [-121.96949, 37.86243], [-121.97839, 37.86217], [-121.9785, 37.86273], [-121.97922, 37.8634], [-121.97965, 37.86336], [-121.97962, 37.86296], [-121.97932, 37.86269], [-121.97932, 37.86215], [-121.98918, 37.86186], [-121.99006, 37.86839], [-121.98335, 37.8775], [-121.98347, 37.87753], [-121.98417, 37.87786], [-121.98519, 37.87806], [-121.98586, 37.87859], [-121.9874, 37.87893], [-121.98849, 37.87961], [-121.98941, 37.87965], [-121.98972, 37.88041], [-121.98966, 37.88152], [-121.99019, 37.88221], [-121.99022, 37.88255]], [[-121.88526, 37.90008], [-121.87383, 37.89999], [-121.87422, 37.90355], [-121.87449, 37.90357], [-121.87449, 37.90535], [-121.88593, 37.90547], [-121.88592, 37.90361], [-121.88526, 37.90008]], [[-121.88887, 37.90718], [-121.8889, 37.90565], [-121.88835, 37.90565], [-121.88833, 37.90546], [-121.88781, 37.90549], [-121.88762, 37.90543], [-121.88745, 37.9055], [-121.88746, 37.90585], [-121.88757, 37.90606], [-121.88752, 37.90645], [-121.88733, 37.90649], [-121.88712, 37.90672], [-121.88723, 37.90698], [-121.88744, 37.9072], [-121.88887, 37.90718]], [[-121.89173, 37.90713], [-121.89177, 37.90533], [-121.89064, 37.90534], [-121.89061, 37.90714], [-121.89173, 37.90713]], [[-121.89574, 37.85331], [-121.89576, 37.8515], [-121.89348, 37.85151], [-121.89348, 37.85329], [-121.89574, 37.85331]], [[-121.94239, 37.87166], [-121.9424, 37.87164], [-121.94176, 37.87117], [-121.94138, 37.87099], [-121.94099, 37.87069], [-121.94083, 37.87044], [-121.94071, 37.8703], [-121.94062, 37.87026], [-121.94038, 37.87028], [-121.94013, 37.87027], [-121.94007, 37.87023], [-121.93994, 37.86997], [-121.93961, 37.86975], [-121.93958, 37.8697], [-121.93959, 37.86951], [-121.93964, 37.86946], [-121.93986, 37.86938], [-121.94048, 37.86938], [-121.94082, 37.86946], [-121.94093, 37.86942], [-121.94096, 37.86923], [-121.94091, 37.86907], [-121.94079, 37.86896], [-121.94056, 37.86884], [-121.94053, 37.8688], [-121.94048, 37.86861], [-121.94038, 37.86854], [-121.94029, 37.86836], [-121.9402, 37.86825], [-121.93994, 37.86853], [-121.93938, 37.86859], [-121.93885, 37.86889], [-121.93852, 37.86945], [-121.93841, 37.87001], [-121.93821, 37.87048], [-121.93811, 37.87076], [-121.93804, 37.87092], [-121.93806, 37.87093], [-121.93838, 37.87091], [-121.93884, 37.87094], [-121.93932, 37.87104], [-121.9401, 37.87129], [-121.94052, 37.87122], [-121.94084, 37.87126], [-121.94178, 37.87143], [-121.94239, 37.87166]], [[-121.94854, 37.86264], [-121.94552, 37.86267], [-121.94519, 37.86252], [-121.94492, 37.86252], [-121.94477, 37.86262], [-121.94488, 37.86281], [-121.94502, 37.86295], [-121.94482, 37.86327], [-121.94485, 37.86338], [-121.94502, 37.86351], [-121.94502, 37.86364], [-121.94491, 37.86387], [-121.94511, 37.86417], [-121.94557, 37.86496], [-121.9452, 37.86605], [-121.94477, 37.86605], [-121.94434, 37.86627], [-121.94467, 37.86651], [-121.94482, 37.86677], [-121.94486, 37.86716], [-121.94528, 37.86732], [-121.94599, 37.86821], [-121.94642, 37.86845], [-121.94664, 37.86885], [-121.94663, 37.86914], [-121.94669, 37.86921], [-121.94678, 37.86928], [-121.94818, 37.86838], [-121.94924, 37.86837], [-121.95021, 37.86721], [-121.94849, 37.86604], [-121.94963, 37.86517], [-121.94854, 37.86264]]], [[[-121.84786, 37.85221], [-121.84779, 37.85255], [-121.84783, 37.85303], [-121.84402, 37.85305], [-121.84405, 37.84944], [-121.8453, 37.8504], [-121.8455, 37.85095], [-121.84622, 37.85101], [-121.84706, 37.85147], [-121.84746, 37.85189], [-121.84786, 37.85221]]]]} | Open Access 1 | Mount Diablo State Park | http://www.parks.ca.gov/?page_id=517 | 1650 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 18847.604 | Mount Diablo SP | 1931 |
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]);