units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where YR_EST = 2011
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
DES_TP 8
ACCESS_TYP 2
Link | rowid ▼ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4152 | 4152 | 4151 | {"type": "Polygon", "coordinates": [[[-117.97658, 33.91104], [-117.97658, 33.91143], [-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.97658, 33.91104]]]} | Open Access 1 | 48288 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Orange 3 | 8.381 | Coyote Creek Bikeway | 2011 | None 358 | |
5236 | 5236 | 5235 | {"type": "Polygon", "coordinates": [[[-121.32596, 38.25906], [-121.32595, 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 | 48078 | Walker Community Park | 32580 | 1407 | Galt, City of 623 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/index.aspx?page=71 | City 2 | 1407 | Galt, City of 612 | City 2 | City Agency 2 | http://www.ci.galt.ca.us/city-departments/parks-recreation/parks-buildings/parks/walker-park | Sacramento 41 | 11.723 | Walker Community Park | 2011 | Local Park 2 | 4 |
6036 | 6036 | 6035 | {"type": "Polygon", "coordinates": [[[-122.55459, 38.44131], [-122.55309, 38.44393], [-122.54848, 38.44397], [-122.54843, 38.43733], [-122.55269, 38.43912], [-122.5535, 38.43944], [-122.55459, 38.44131]]]} | No Public Access 3 | 47347 | Auberge Ceanothus Preserve | 31063 | 2155 | Sonoma County Agricultural Preservation and Open Space District 387 | Special District 4 | Recreation/Parks District 4 | http://www.sonomaopenspace.org/ | Special District 4 | 2155 | Sonoma County Agricultural Preservation and Open Space District 383 | Special District 4 | Recreation/Parks District 4 | Sonoma 16 | 71.713 | Auberge Ceanothus Preserve | 2011 | Local Conservation Area 4 | 2 | |
9405 | 9405 | 9404 | {"type": "Polygon", "coordinates": [[[-119.96624, 37.50102], [-119.96556, 37.50341], [-119.96444, 37.50422], [-119.96448, 37.50478], [-119.96518, 37.50519], [-119.96586, 37.50517], [-119.96582, 37.50589], [-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.50895], [-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.51884], [-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.51292], [-119.95424, 37.50499], [-119.95743, 37.50084], [-119.95628, 37.49975], [-119.95711, 37.49844], [-119.95956, 37.49675], [-119.96147, 37.49852], [-119.9622, 37.49803], [-119.96371, 37.49895], [-119.9644, 37.50016], [-119.96624, 37.50102]]]} | Open Access 1 | 47813 | Stockton Creek Preserve | 31695 | 2415 | Mariposa Public Utility District 909 | Special District 4 | Water District 13 | http://www.mariposapud.org/ | Special District 4 | 2415 | Mariposa Public Utility District 882 | Special District 4 | Water District 13 | Mariposa 31 | 457.205 | Stockton Creek Preserve | 2011 | Local Conservation Area 4 | 2 | |
10539 | 10539 | 10538 | {"type": "MultiPolygon", "coordinates": [[[[-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.72176, 39.22676], [-122.71711, 39.22651], [-122.71709, 39.23007], [-122.72173, 39.23039], [-122.72174, 39.23412], [-122.71241, 39.23361], [-122.71239, 39.22983], [-122.70762, 39.22992], [-122.70772, 39.22628], [-122.71247, 39.22625], [-122.71253, 39.21919], [-122.72176, 39.21953], [-122.72176, 39.22676]]], [[[-122.70289, 39.24409], [-122.70288, 39.24064], [-122.71237, 39.24126], [-122.71233, 39.24508], [-122.7125, 39.2489], [-122.7031, 39.2481], [-122.70289, 39.24409]]]]} | Open Access 1 | 48615 | Goat Mountain Property | 33329 | 3095 | Tuleyome 558 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.tuleyome.org/ | Non Governmental Organization 10 | 3095 | Tuleyome 551 | Non Profit 6 | Non Profit - Land Trust 10 | http://tuleyome.org/properties/ | Lake 40 | 663.188 | Goat Mtn. Property | 2011 | Private Conservation 16 | 2 |
11316 | 11316 | 11315 | {"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 | 48052 | Bay Street Tot Lot | 32546 | 2169 | Tuolumne Park and Recreation District 741 | Special District 4 | Recreation/Parks District 4 | http://www.tuolumnerecreation.com/ | Special District 4 | 2169 | Tuolumne Park and Recreation District 726 | Special District 4 | Recreation/Parks District 4 | https://www.tuolumnerecreation.com/TPRD_facilities.html | Tuolumne 21 | 0.163 | Bay Street Tot Lot | 2011 | Local Recreation Area 3 | 4 |
11459 | 11459 | 11458 | {"type": "Polygon", "coordinates": [[[-118.36519, 34.09549], [-118.36478, 34.0955], [-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 | 48159 | Laurel Park | 32697 | 1375 | West Hollywood, City of 334 | City 2 | City Agency 2 | http://www.weho.org/residents/recreation-services/parks-and-facilities | City 2 | 1375 | West Hollywood, City of 331 | City 2 | City Agency 2 | Los Angeles 6 | 0.43 | Laurel Park | 2011 | Local Park 2 | 4 | |
13071 | 13071 | 13070 | {"type": "Polygon", "coordinates": [[[-121.51495, 38.59762], [-121.51338, 38.59761], [-121.51337, 38.59756], [-121.51327, 38.59756], [-121.51335, 38.59742], [-121.5134, 38.59709], [-121.51347, 38.59696], [-121.51345, 38.5969], [-121.51336, 38.5968], [-121.51323, 38.59681], [-121.51311, 38.59635], [-121.51304, 38.59621], [-121.5128, 38.59581], [-121.51281, 38.59575], [-121.51329, 38.59552], [-121.51374, 38.59521], [-121.5138, 38.59521], [-121.5141, 38.59532], [-121.51458, 38.59545], [-121.51459, 38.59549], [-121.51455, 38.59587], [-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 | 34942 | California Indian Heritage Center | 1456 | 204 | California Department of Parks and Recreation 48 | State 5 | State Agency 5 | http://www.parks.ca.gov/ | California Department of Parks and Recreation 9 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=22628 | Yolo 33 | 8.333 | California Indian Heritage Ctr. | 2011 | State Historic or Cultural Area 132 | 4 |
14342 | 14342 | 14341 | {"type": "Polygon", "coordinates": [[[-118.65872, 34.1181], [-118.65875, 34.11954], [-118.65875, 34.12258], [-118.65825, 34.12363], [-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.12317], [-118.65511, 34.12151], [-118.65413, 34.12123], [-118.65451, 34.12026], [-118.65451, 34.12025], [-118.65205, 34.12026], [-118.65206, 34.12208], [-118.65153, 34.12208], [-118.65153, 34.1222], [-118.65159, 34.12225], [-118.65173, 34.12241], [-118.6518, 34.12246], [-118.65206, 34.12249], [-118.65206, 34.12236], [-118.65273, 34.12262], [-118.65218, 34.12362], [-118.65248, 34.12469], [-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 | 44383 | 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 | 2088 | Mountains Recreation and Conservation Authority 27 | Special District 4 | Open Space District 6 | Los Angeles 6 | 118.916 | Cold Creek - Secret Valley | 2011 | None 1211 | ||
14544 | 14544 | 14543 | {"type": "Polygon", "coordinates": [[[-117.97916, 33.9094], [-117.97859, 33.91001], [-117.97804, 33.91048], [-117.9775, 33.91087], [-117.97658, 33.91143], [-117.97658, 33.91103], [-117.97694, 33.91084], [-117.97741, 33.91054], [-117.97784, 33.91022], [-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 | 48309 | Coyote Creek Bikeway | 32861 | 312 | Orange, County of 142 | County 3 | County Agency 3 | http://ocparks.com/ | County 3 | 205 | California Department of Transportation 279 | State 5 | State Agency 5 | http://www.lhcm.org/386/Bikeways | Los Angeles 6 | 2.63 | Coyote Creek Bikeway | 2011 | None 1239 | |
14766 | 14766 | 14765 | {"type": "Polygon", "coordinates": [[[-119.31436, 34.38706], [-119.31235, 34.38703], [-119.31157, 34.38578], [-119.31128, 34.38522], [-119.31067, 34.38449], [-119.31045, 34.38389], [-119.3099, 34.38348], [-119.30887, 34.38284], [-119.30853, 34.3822], [-119.3089, 34.38079], [-119.30861, 34.38016], [-119.30753, 34.38024], [-119.30733, 34.37894], [-119.30725, 34.37807], [-119.3073, 34.37757], [-119.30747, 34.37645], [-119.30797, 34.37472], [-119.3125, 34.37439], [-119.31247, 34.37483], [-119.31198, 34.37483], [-119.31169, 34.37557], [-119.31082, 34.37622], [-119.31017, 34.37678], [-119.30997, 34.37738], [-119.30959, 34.37875], [-119.3091, 34.37858], [-119.30874, 34.37861], [-119.30877, 34.3796], [-119.30897, 34.38013], [-119.30919, 34.38061], [-119.30958, 34.38079], [-119.31036, 34.38172], [-119.31062, 34.38219], [-119.31092, 34.3826], [-119.31144, 34.38354], [-119.31191, 34.38413], [-119.31303, 34.38463], [-119.31361, 34.3853], [-119.314, 34.38583], [-119.31421, 34.38639], [-119.31433, 34.38682], [-119.31436, 34.38706]]]} | No Public Access 3 | 48317 | Ventura River Steelhead Preserve | 32881 | 3296 | Ojai Valley Land Conservancy 1112 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.ovlc.org/ | Non Governmental Organization 10 | 3296 | Ojai Valley Land Conservancy 1066 | Non Profit 6 | Non Profit - Land Trust 10 | https://ovlc.org/preserves/ventura-river-steelhead-preserve/ | Ventura 8 | 68.904 | Ventura River Steelhead Preserve | 2011 | Private Conservation 16 | 2 |
15167 | 15167 | 15166 | {"type": "Polygon", "coordinates": [[[-117.27449, 33.09512], [-117.27025, 33.09505], [-117.27019, 33.09492], [-117.27019, 33.09488], [-117.27023, 33.09483], [-117.27016, 33.09464], [-117.27011, 33.09465], [-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.09331], [-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.27413, 33.09316], [-117.27439, 33.09325], [-117.27448, 33.09326], [-117.27449, 33.09512]]]} | Open Access 1 | 47291 | Cholla Point | 30996 | 3220 | Batiquitos Lagoon Foundation 1138 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/about/ | Non Governmental Organization 10 | 3220 | Batiquitos Lagoon Foundation 1093 | Non Profit 6 | Non Profit - Conservation 12 | http://www.batiquitosfoundation.org/category/visit/ | San Diego 4 | 20.824 | Cholla Point | 2011 | Private Conservation 16 | 2 |
16257 | 16257 | 16256 | {"type": "Polygon", "coordinates": [[[-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.59463], [-121.50967, 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.5126, 38.5955], [-121.51262, 38.5955], [-121.51306, 38.59626], [-121.51314, 38.59644], [-121.51323, 38.5968], [-121.51336, 38.5968], [-121.51345, 38.5969], [-121.51347, 38.59697], [-121.5134, 38.59709], [-121.51335, 38.59742], [-121.51323, 38.59762], [-121.51307, 38.59788], [-121.513, 38.59808], [-121.51301, 38.5982], [-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]]]} | Open Access 1 | 45014 | California Indian Heritage Center | 1456 | 1376 | West Sacramento, City of 548 | City 2 | City Agency 2 | http://www.cityofwestsacramento.org/city/depts/pcs/default.asp | City 2 | 204 | California Department of Parks and Recreation 47 | State 5 | State Agency 5 | http://www.parks.ca.gov/?page_id=22628 | Yolo 33 | 43.64 | California Indian Heritage Ctr. | 2011 | State Historic or Cultural Area 132 | 4 |
16941 | 16941 | 16940 | {"type": "Polygon", "coordinates": [[[-121.01989, 39.27479], [-121.01983, 39.27487], [-121.01977, 39.2748], [-121.01976, 39.27463], [-121.01928, 39.27479], [-121.01908, 39.27487], [-121.01905, 39.27479], [-121.01644, 39.27477], [-121.01641, 39.27463], [-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.01706, 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 | 49010 | Sugarloaf Mountain Open Space Preserve | 33706 | 1425 | Nevada City, City of 991 | City 2 | City Agency 2 | http://www.nevadacityca.gov/content/parks-recreation | City 2 | 1425 | Nevada City, City of 955 | City 2 | City Agency 2 | https://www.bylt.org/trail/sugarloaf-mountain-trail/ | Nevada 30 | 29.943 | Sugarloaf Mtn. OSP | 2011 | Local Conservation Area 4 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);