superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
10 rows where ACCESS_TYP = 1 and YR_EST = 2011
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
67 | 67 | 66 | {"type": "Polygon", "coordinates": [[[-121.51495, 38.59762], [-121.51338, 38.59761], [-121.51336, 38.59756], [-121.51327, 38.59756], [-121.51307, 38.59789], [-121.513, 38.59808], [-121.51301, 38.59821], [-121.51313, 38.59845], [-121.51366, 38.59911], [-121.51385, 38.59939], [-121.51418, 38.59934], [-121.51451, 38.59934], [-121.51455, 38.59944], [-121.51467, 38.59956], [-121.5147, 38.5997], [-121.51408, 38.59996], [-121.51356, 38.60048], [-121.51325, 38.60025], [-121.51317, 38.60031], [-121.51294, 38.60017], [-121.51239, 38.59978], [-121.51196, 38.59943], [-121.51181, 38.59953], [-121.5113, 38.59905], [-121.51034, 38.59789], [-121.51021, 38.5977], [-121.50934, 38.5946], [-121.50974, 38.59464], [-121.50975, 38.59462], [-121.50966, 38.59448], [-121.5093, 38.59445], [-121.50925, 38.59427], [-121.50981, 38.5943], [-121.50978, 38.59357], [-121.51193, 38.59338], [-121.51214, 38.59405], [-121.51228, 38.59474], [-121.51242, 38.59519], [-121.51248, 38.59533], [-121.51259, 38.5955], [-121.51262, 38.5955], [-121.51279, 38.59579], [-121.5128, 38.59579], [-121.51281, 38.59575], [-121.51329, 38.59552], [-121.51374, 38.59521], [-121.5138, 38.59521], [-121.51411, 38.59532], [-121.51458, 38.59545], [-121.51459, 38.59549], [-121.51455, 38.59588], [-121.51458, 38.59618], [-121.51466, 38.59649], [-121.51484, 38.59691], [-121.51491, 38.59713], [-121.51495, 38.59734], [-121.51495, 38.59762]]]} | Open Access 1 | California Indian Heritage Center | http://www.parks.ca.gov/?page_id=22628 | 1456 | 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 | 51.979 | California Indian Heritage Ctr. | 2011 |
602 | 602 | 601 | {"type": "Polygon", "coordinates": [[[-118.36519, 34.09549], [-118.36478, 34.09551], [-118.36479, 34.09569], [-118.36502, 34.09571], [-118.36502, 34.09582], [-118.36457, 34.09582], [-118.36457, 34.09538], [-118.36518, 34.09538], [-118.36519, 34.09549]]]} | Open Access 1 | Laurel Park | 32697 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | http://www.weho.org/residents/recreation-services/parks-and-facilities | City 2 | 0.435 | Laurel Park | 2011 | |
1097 | 1097 | 1096 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97591, 33.91182], [-117.97546, 33.91214], [-117.96943, 33.91722], [-117.96887, 33.91721], [-117.97303, 33.91372], [-117.97303, 33.9137], [-117.97384, 33.91309], [-117.9751, 33.91199], [-117.97561, 33.91162], [-117.97741, 33.91054], [-117.97802, 33.91008], [-117.97805, 33.91001], [-117.97841, 33.90968], [-117.9788, 33.90926], [-117.97904, 33.90937], [-117.97916, 33.9094]]]} | Open Access 1 | Coyote Creek Bikeway | http://www.lhcm.org/386/Bikeways | 32861 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.dot.ca.gov/ | Other State 5 | 11.01 | Coyote Creek Bikeway | 2011 |
3071 | 3071 | 3070 | {"type": "Polygon", "coordinates": [[[-118.65872, 34.1181], [-118.65875, 34.11954], [-118.65875, 34.12258], [-118.65825, 34.12362], [-118.65788, 34.12454], [-118.65762, 34.12537], [-118.65719, 34.12711], [-118.65578, 34.12716], [-118.65575, 34.12658], [-118.6557, 34.12636], [-118.65558, 34.12611], [-118.65547, 34.12595], [-118.65536, 34.12584], [-118.65651, 34.12484], [-118.65513, 34.1243], [-118.65576, 34.12316], [-118.65511, 34.12151], [-118.65413, 34.12123], [-118.65451, 34.12027], [-118.6545, 34.12025], [-118.65205, 34.12026], [-118.65206, 34.12208], [-118.65154, 34.12208], [-118.65153, 34.1222], [-118.65159, 34.12225], [-118.65173, 34.12241], [-118.6518, 34.12246], [-118.65205, 34.12249], [-118.65206, 34.12236], [-118.65273, 34.12262], [-118.65218, 34.12362], [-118.65248, 34.12468], [-118.65252, 34.12476], [-118.65226, 34.1249], [-118.65214, 34.125], [-118.65203, 34.12512], [-118.65194, 34.12508], [-118.65088, 34.12498], [-118.65014, 34.12534], [-118.65024, 34.11939], [-118.65025, 34.1181], [-118.65872, 34.1181]]]} | Open Access 1 | Cold Creek - Secret Valley | 17480 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | http://www.mrca.ca.gov/ | Special District 4 | 118.962 | Cold Creek - Secret Valley | 2011 | |
13564 | 13564 | 13563 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09511], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09464], [-117.27011, 33.09307], [-117.2703, 33.09301], [-117.27048, 33.09283], [-117.27071, 33.09282], [-117.27099, 33.09295], [-117.27164, 33.09308], [-117.2715, 33.0933], [-117.27151, 33.09332], [-117.27233, 33.09353], [-117.27312, 33.09348], [-117.27325, 33.09329], [-117.27351, 33.09329], [-117.27355, 33.09311], [-117.27415, 33.09307], [-117.27414, 33.09316], [-117.27439, 33.09324], [-117.27448, 33.09326], [-117.27449, 33.09511]]]} | Open Access 1 | Cholla Point | http://www.batiquitosfoundation.org/category/visit/ | 30996 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 20.825 | Cholla Point | 2011 |
13953 | 13953 | 13952 | {"type": "Polygon", "coordinates": [[[-120.23983, 37.96099], [-120.23982, 37.96122], [-120.23954, 37.96122], [-120.23954, 37.96099], [-120.23983, 37.96099]]]} | Open Access 1 | Bay Street Tot Lot | https://www.tuolumnerecreation.com/TPRD_facilities.html | 32546 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 0.163 | Bay Street Tot Lot | 2011 |
14010 | 14010 | 14009 | {"type": "Polygon", "coordinates": [[[-121.32596, 38.25906], [-121.32594, 38.26184], [-121.32404, 38.26185], [-121.32404, 38.26001], [-121.32402, 38.25959], [-121.32423, 38.25956], [-121.3249, 38.25955], [-121.32492, 38.25909], [-121.32596, 38.25906]]]} | Open Access 1 | Walker Community Park | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/walker-park | 32580 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 11.726 | Walker Community Park | 2011 |
14188 | 14188 | 14187 | {"type": "Polygon", "coordinates": [[[-119.96624, 37.50102], [-119.96556, 37.50341], [-119.96445, 37.50423], [-119.96448, 37.50478], [-119.96518, 37.50519], [-119.96586, 37.50517], [-119.96582, 37.5059], [-119.96583, 37.50609], [-119.96585, 37.50628], [-119.9659, 37.50648], [-119.96598, 37.5067], [-119.96623, 37.50714], [-119.9663, 37.5073], [-119.96636, 37.50761], [-119.96635, 37.50779], [-119.96632, 37.50788], [-119.96625, 37.508], [-119.96616, 37.50811], [-119.96606, 37.50819], [-119.96591, 37.50827], [-119.9654, 37.50848], [-119.96506, 37.50865], [-119.96459, 37.50894], [-119.96442, 37.50912], [-119.96436, 37.50923], [-119.96432, 37.50935], [-119.96429, 37.50974], [-119.96426, 37.50995], [-119.9642, 37.51021], [-119.96409, 37.51056], [-119.96395, 37.5109], [-119.96378, 37.51124], [-119.96364, 37.51148], [-119.96347, 37.51172], [-119.9632, 37.51199], [-119.96288, 37.51221], [-119.96223, 37.51256], [-119.96057, 37.5135], [-119.95902, 37.51434], [-119.95847, 37.51483], [-119.95726, 37.51661], [-119.95646, 37.51732], [-119.95523, 37.51781], [-119.95478, 37.51801], [-119.95444, 37.51819], [-119.95337, 37.51885], [-119.95306, 37.51901], [-119.95264, 37.51921], [-119.95219, 37.51938], [-119.95162, 37.51956], [-119.95114, 37.51968], [-119.95063, 37.51977], [-119.95068, 37.51288], [-119.95404, 37.51291], [-119.95424, 37.50499], [-119.95742, 37.50085], [-119.95628, 37.49975], [-119.95711, 37.49844], [-119.95956, 37.49675], [-119.96146, 37.49852], [-119.9622, 37.49803], [-119.96371, 37.49895], [-119.9644, 37.50016], [-119.96624, 37.50102]]]} | Open Access 1 | Stockton Creek Preserve | 31695 | 2415 | Mariposa Public Utility District 882 | Special District 4 | Water District 13 | http://www.mariposapud.org/ | Special District 4 | 457.268 | Stockton Creek Preserve | 2011 | |
14721 | 14721 | 14720 | {"type": "Polygon", "coordinates": [[[-121.01989, 39.27479], [-121.01983, 39.27487], [-121.01977, 39.2748], [-121.01975, 39.27464], [-121.01928, 39.27479], [-121.01908, 39.27487], [-121.01904, 39.27479], [-121.01644, 39.27477], [-121.01641, 39.27462], [-121.01629, 39.27443], [-121.01618, 39.27431], [-121.01604, 39.27421], [-121.0159, 39.27409], [-121.01579, 39.27395], [-121.01571, 39.2738], [-121.01567, 39.27364], [-121.01565, 39.27347], [-121.01567, 39.27331], [-121.01572, 39.27315], [-121.01586, 39.27292], [-121.01592, 39.27286], [-121.01615, 39.27267], [-121.01627, 39.27252], [-121.01636, 39.27236], [-121.01645, 39.27214], [-121.01657, 39.272], [-121.01673, 39.27189], [-121.01705, 39.27177], [-121.01731, 39.27163], [-121.01746, 39.27151], [-121.01763, 39.2713], [-121.01985, 39.27119], [-121.01989, 39.27479]]]} | Open Access 1 | Sugarloaf Mountain Open Space Preserve | https://www.bylt.org/trail/sugarloaf-mountain-trail/ | 33706 | 1425 | Nevada City, City of 955 | City 2 | City Agency 2 | http://www.nevadacityca.gov/content/parks-recreation | City 2 | 29.945 | Sugarloaf Mtn. OSP | 2011 |
15508 | 15508 | 15507 | {"type": "MultiPolygon", "coordinates": [[[[-122.72176, 39.22676], [-122.71712, 39.22651], [-122.71709, 39.23006], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22984], [-122.71238, 39.22983], [-122.70762, 39.22992], [-122.70761, 39.23359], [-122.70258, 39.23362], [-122.69033, 39.23329], [-122.6873, 39.23318], [-122.68712, 39.22951], [-122.68979, 39.22966], [-122.70275, 39.23006], [-122.70762, 39.22992], [-122.70772, 39.22628], [-122.71247, 39.22624], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489]]]]} | Open Access 1 | Goat Mountain Property | http://tuleyome.org/properties/ | 33329 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 663.35 | Goat Mtn. Property | 2011 |
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]);