superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1 and YR_EST = 2013
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP
MNG_AGENCY 6
MNG_AG_TYP 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
134 | 134 | 133 | {"type": "Polygon", "coordinates": [[[-123.69334, 38.89646], [-123.69092, 38.89742], [-123.68781, 38.89884], [-123.68619, 38.8973], [-123.6853, 38.89648], [-123.68339, 38.89464], [-123.68665, 38.89209], [-123.68675, 38.89243], [-123.687, 38.89272], [-123.68732, 38.89305], [-123.6881, 38.8935], [-123.68935, 38.89412], [-123.68975, 38.89423], [-123.69062, 38.89436], [-123.69119, 38.89451], [-123.69155, 38.89485], [-123.69225, 38.89544], [-123.69266, 38.89574], [-123.69321, 38.89625], [-123.69334, 38.89646]]]} | Open Access 1 | Pelican Bluffs Reserve | https://www.mendocinolandtrust.org/explore/explore-our-lands/pelican-bluffs/ | 31827 | 3128 | Mendocino Land Trust 492 | Non Profit 6 | Non Profit - Land Trust 10 | http://mendocinolandtrust.org/ | Non Governmental Organization 10 | 76.551 | Pelican Bluffs Reserve | 2013 |
900 | 900 | 899 | {"type": "Polygon", "coordinates": [[[-117.10221, 32.74023], [-117.10218, 32.74028], [-117.10205, 32.74034], [-117.10185, 32.74036], [-117.10159, 32.74049], [-117.10145, 32.74039], [-117.10126, 32.74023], [-117.10127, 32.74021], [-117.10155, 32.74023], [-117.10183, 32.74022], [-117.10184, 32.74017], [-117.10194, 32.74014], [-117.10197, 32.74004], [-117.10219, 32.74017], [-117.10221, 32.74023]]]} | Open Access 1 | Manzanita Gathering Place | http://rootedinplace.com/portfolio-items/manzanita-gathering-place/ | 32782 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 0.446 | Manzanita Gathering Place | 2013 |
1242 | 1242 | 1241 | {"type": "Polygon", "coordinates": [[[-121.84658, 37.72388], [-121.84635, 37.72424], [-121.84629, 37.72437], [-121.84627, 37.7245], [-121.84626, 37.72476], [-121.8459, 37.72476], [-121.8456, 37.72478], [-121.84556, 37.72461], [-121.84544, 37.72438], [-121.84532, 37.72424], [-121.84517, 37.72412], [-121.8449, 37.72398], [-121.84424, 37.72377], [-121.8443, 37.72372], [-121.84435, 37.72362], [-121.84446, 37.72362], [-121.84456, 37.72358], [-121.84502, 37.72314], [-121.84505, 37.72315], [-121.84512, 37.72313], [-121.84652, 37.72378], [-121.84656, 37.72381], [-121.84656, 37.72387], [-121.84658, 37.72388]]]} | Open Access 1 | Positano Hills Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Positano-Hills-Park-24 | 32915 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 4.594 | Positano Hills Park | 2013 |
1243 | 1243 | 1242 | {"type": "MultiPolygon", "coordinates": [[[[-121.98239, 37.70443], [-121.98231, 37.70454], [-121.98222, 37.70464], [-121.98188, 37.7049], [-121.9817, 37.7051], [-121.98159, 37.7053], [-121.98154, 37.70544], [-121.98147, 37.70576], [-121.98138, 37.70594], [-121.98038, 37.70543], [-121.98017, 37.70531], [-121.97993, 37.70509], [-121.97982, 37.70493], [-121.97974, 37.70478], [-121.97967, 37.70475], [-121.9794, 37.70481], [-121.97936, 37.70486], [-121.97929, 37.70459], [-121.97936, 37.70463], [-121.97964, 37.7046], [-121.9797, 37.70455], [-121.97969, 37.70442], [-121.97971, 37.70425], [-121.97984, 37.70386], [-121.97947, 37.70375], [-121.97949, 37.70369], [-121.9796, 37.70365], [-121.98037, 37.70377], [-121.98082, 37.70389], [-121.98235, 37.70436], [-121.98239, 37.70443]]], [[[-121.98321, 37.70474], [-121.98311, 37.7049], [-121.98292, 37.70488], [-121.98273, 37.70491], [-121.98249, 37.70501], [-121.98232, 37.70514], [-121.98221, 37.70528], [-121.98217, 37.70541], [-121.98218, 37.70559], [-121.98222, 37.70575], [-121.9816, 37.70585], [-121.98166, 37.70568], [-121.9817, 37.70544], [-121.98181, 37.70521], [-121.98197, 37.705], [-121.98238, 37.70469], [-121.98253, 37.70448], [-121.98263, 37.70445], [-121.98307, 37.7046], [-121.98311, 37.70463], [-121.98315, 37.7047], [-121.98321, 37.70474]]]]} | Open Access 1 | Schaefer Ranch Park | https://www.dublin.ca.gov/Facilities/Facility/Details/Schaefer-Ranch-Park-29 | 32916 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 10.54 | Schaefer Ranch Park | 2013 |
12468 | 12468 | 12467 | {"type": "Polygon", "coordinates": [[[-117.3268, 34.03667], [-117.32672, 34.03697], [-117.32614, 34.03686], [-117.32598, 34.03749], [-117.3255, 34.03739], [-117.32555, 34.03716], [-117.32515, 34.03707], [-117.32533, 34.03633], [-117.32584, 34.03644], [-117.32585, 34.03646], [-117.3268, 34.03667]]]} | Open Access 1 | Grand Terrace Fitness Park | 31080 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 2.504 | Grand Terrace Fitness Park | 2013 | |
13405 | 13405 | 13404 | {"type": "Polygon", "coordinates": [[[-122.19227, 39.92341], [-122.1916, 39.92338], [-122.19063, 39.92338], [-122.19061, 39.9235], [-122.1901, 39.9235], [-122.1901, 39.92247], [-122.19055, 39.92245], [-122.19054, 39.9208], [-122.19226, 39.9208], [-122.19227, 39.92341]]]} | Open Access 1 | Corning Community Park and Skate Park | 32513 | 1440 | Corning, City of 634 | City 2 | City Agency 2 | http://www.corning.org/ | City 2 | 11.575 | Corning Community Park and Skate Park | 2013 | |
14642 | 14642 | 14641 | {"type": "MultiPolygon", "coordinates": [[[[-121.24459, 36.50282], [-121.24435, 36.51005], [-121.23996, 36.51007], [-121.23966, 36.51731], [-121.23062, 36.51721], [-121.22987, 36.53167], [-121.22988, 36.53168], [-121.23887, 36.53184], [-121.23882, 36.53546], [-121.22982, 36.53533], [-121.22979, 36.53894], [-121.23428, 36.53902], [-121.23419, 36.54626], [-121.23868, 36.54632], [-121.23878, 36.53908], [-121.24346, 36.53906], [-121.2434, 36.54632], [-121.23869, 36.54634], [-121.2386, 36.54994], [-121.22957, 36.54981], [-121.22931, 36.55703], [-121.22477, 36.55697], [-121.22462, 36.56058], [-121.22005, 36.56052], [-121.21991, 36.56492], [-121.21537, 36.56499], [-121.21547, 36.56054], [-121.21091, 36.56055], [-121.21129, 36.55329], [-121.20222, 36.5533], [-121.19776, 36.55326], [-121.19794, 36.54963], [-121.19347, 36.5496], [-121.19362, 36.54596], [-121.1937, 36.54233], [-121.19822, 36.54232], [-121.19836, 36.53507], [-121.19386, 36.53505], [-121.19393, 36.53142], [-121.18497, 36.53144], [-121.18468, 36.5423], [-121.1667, 36.54224], [-121.16217, 36.54218], [-121.16229, 36.53493], [-121.15776, 36.53485], [-121.15781, 36.53121], [-121.1533, 36.53115], [-121.15323, 36.53478], [-121.1487, 36.53472], [-121.1487, 36.53447], [-121.14854, 36.53451], [-121.14825, 36.53398], [-121.14765, 36.53372], [-121.14661, 36.53314], [-121.14639, 36.53289], [-121.14618, 36.53262], [-121.14611, 36.53224], [-121.14611, 36.53201], [-121.14566, 36.53124], [-121.14532, 36.53058], [-121.14486, 36.53014], [-121.14443, 36.5297], [-121.1443, 36.52945], [-121.14415, 36.52885], [-121.14423, 36.52789], [-121.14413, 36.52747], [-121.14384, 36.52705], [-121.14305, 36.52627], [-121.14148, 36.52441], [-121.14123, 36.52425], [-121.14066, 36.52402], [-121.14025, 36.52375], [-121.14, 36.52338], [-121.13997, 36.52294], [-121.13989, 36.52271], [-121.13976, 36.52248], [-121.13918, 36.52208], [-121.1389, 36.52156], [-121.13829, 36.52083], [-121.13828, 36.52072], [-121.13886, 36.51763], [-121.13694, 36.5176], [-121.13667, 36.51687], [-121.13639, 36.51636], [-121.13635, 36.51601], [-121.13665, 36.51533], [-121.13705, 36.51499], [-121.13724, 36.51469], [-121.13733, 36.51406], [-121.13749, 36.51224], [-121.13745, 36.51186], [-121.1373, 36.51144], [-121.1373, 36.511], [-121.13748, 36.51048], [-121.13768, 36.51029], [-121.13766, 36.5101], [-121.13781, 36.50977], [-121.13811, 36.50924], [-121.13823, 36.50891], [-121.13952, 36.50801], [-121.1396, 36.5078], [-121.13955, 36.50762], [-121.13933, 36.50635], [-121.13919, 36.50592], [-121.13924, 36.50568], [-121.13933, 36.50537], [-121.13931, 36.50519], [-121.13922, 36.50499], [-121.13939, 36.50415], [-121.13946, 36.50367], [-121.13919, 36.50295], [-121.13933, 36.50248], [-121.13938, 36.5021], [-121.1395, 36.50185], [-121.14, 36.50133], [-121.14012, 36.50113], [-121.14001, 36.50088], [-121.14007, 36.50046], [-121.14042, 36.50013], [-121.14068, 36.50002], [-121.14086, 36.49985], [-121.14086, 36.49942], [-121.14098, 36.49906], [-121.14174, 36.49811], [-121.14227, 36.49726], [-121.1437, 36.49608], [-121.14429, 36.49566], [-121.1452, 36.49536], [-121.14616, 36.49495], [-121.14709, 36.49362], [-121.14765, 36.49318], [-121.14854, 36.4926], [-121.14924, 36.49206], [-121.14949, 36.49134], [-121.14963, 36.4908], [-121.14998, 36.49057], [-121.15095, 36.48985], [-121.15184, 36.48904], [-121.15243, 36.48876], [-121.15335, 36.48815], [-121.15335, 36.48814], [-121.15316, 36.48813], [-121.15235, 36.48867], [-121.15175, 36.48895], [-121.15085, 36.48977], [-121.1499, 36.49048], [-121.14951, 36.49074], [-121.14936, 36.49132], [-121.14912, 36.492], [-121.14845, 36.49252], [-121.14756, 36.49309], [-121.14698, 36.49355], [-121.14606, 36.49487], [-121.14514, 36.49526], [-121.14422, 36.49557], [-121.14361, 36.496], [-121.14216, 36.49719], [-121.14162, 36.49806], [-121.14085, 36.49901], [-121.14073, 36.4994], [-121.14072, 36.49981], [-121.14062, 36.49992], [-121.14033, 36.50004], [-121.13994, 36.50041], [-121.13987, 36.50089], [-121.13997, 36.50112], [-121.13988, 36.50128], [-121.13938, 36.5018], [-121.13925, 36.50207], [-121.1392, 36.50246], [-121.13905, 36.50295], [-121.13933, 36.50368], [-121.13925, 36.50413], [-121.13908, 36.505], [-121.13917, 36.50521], [-121.13919, 36.50536], [-121.1391, 36.50565], [-121.13905, 36.50593], [-121.1392, 36.50637], [-121.13941, 36.50764], [-121.13946, 36.50779], [-121.13941, 36.50794], [-121.13812, 36.50885], [-121.13798, 36.5092], [-121.13768, 36.50973], [-121.13753, 36.51008], [-121.13754, 36.51025], [-121.13736, 36.51043], [-121.13716, 36.51099], [-121.13716, 36.51145], [-121.13732, 36.51188], [-121.13735, 36.51224], [-121.1372, 36.51405], [-121.1371, 36.51466], [-121.13694, 36.51493], [-121.13653, 36.51527], [-121.13621, 36.516], [-121.13626, 36.51639], [-121.13654, 36.51691], [-121.1368, 36.5176], [-121.13597, 36.51759], [-121.1359, 36.51704], [-121.13556, 36.51667], [-121.13524, 36.51683], [-121.13504, 36.51755], [-121.13404, 36.51727], [-121.13254, 36.51702], [-121.13068, 36.51684], [-121.12949, 36.51686], [-121.1285, 36.51708], [-121.1279, 36.51724], [-121.12739, 36.51714], [-121.12592, 36.51678], [-121.12452, 36.51607], [-121.12373, 36.51549], [-121.12325, 36.51517], [-121.12212, 36.51475], [-121.12132, 36.51431], [-121.12026, 36.51355], [-121.11927, 36.51298], [-121.11686, 36.51154], [-121.11611, 36.51124], [-121.11492, 36.51036], [-121.11439, 36.51007], [-121.11325, 36.50935], [-121.1127, 36.50874], [-121.11206, 36.50828], [-121.11105, 36.50773], [-121.11057, 36.50749], [-121.11009, 36.50688], [-121.10989, 36.5066], [-121.10955, 36.50631], [-121.10889, 36.50621], [-121.10824, 36.50621], [-121.1079, 36.50583], [-121.10749, 36.50561], [-121.1067, 36.5051], [-121.10583, 36.50442], [-121.10525, 36.50423], [-121.10472, 36.50395], [-121.10319, 36.50194], [-121.10272, 36.50115], [-121.10155, 36.49996], [-121.10083, 36.49903], [-121.13196, 36.49913], [-121.13216, 36.49546], [-121.13674, 36.49553], [-121.13713, 36.48819], [-121.12991, 36.48818], [-121.12749, 36.48821], [-121.126, 36.48817], [-121.11889, 36.48811], [-121.11885, 36.48839], [-121.11565, 36.48837], [-121.11614, 36.49173], [-121.11405, 36.49171], [-121.11402, 36.49201], [-121.11167, 36.49197], [-121.11117, 36.48828], [-121.10804, 36.4882], [-121.1081, 36.48454], [-121.11254, 36.48463], [-121.11266, 36.47733], [-121.1171, 36.47743], [-121.11717, 36.47378], [-121.12611, 36.47384], [-121.13057, 36.47389], [-121.13068, 36.47022], [-121.13516, 36.47028], [-121.1439, 36.47027], [-121.14405, 36.46306], [-121.14469, 36.46305], [-121.1447, 36.46292], [-121.14478, 36.46268], [-121.1448, 36.46255], [-121.14479, 36.46233], [-121.14481, 36.46199], [-121.14485, 36.46162], [-121.14497, 36.46115], [-121.14497, 36.46089], [-121.14521, 36.45998], [-121.14533, 36.4597], [-121.14561, 36.4592], [-121.14628, 36.45822], [-121.14674, 36.45765], [-121.14718, 36.45721], [-121.1475, 36.45704], [-121.14794, 36.45681], [-121.14848, 36.4566], [-121.14849, 36.45588], [-121.1494, 36.45588], [-121.14948, 36.45567], [-121.1497, 36.45558], [-121.15015, 36.45548], [-121.15062, 36.45545], [-121.15089, 36.4554], [-121.15116, 36.45542], [-121.15139, 36.45537], [-121.1521, 36.45508], [-121.15214, 36.45256], [-121.15283, 36.4526], [-121.1535, 36.45254], [-121.15415, 36.45111], [-121.15387, 36.45053], [-121.15285, 36.45008], [-121.15284, 36.45005], [-121.15265, 36.44993], [-121.15222, 36.44959], [-121.15205, 36.44925], [-121.1521, 36.44899], [-121.15238, 36.44853], [-121.1525, 36.44819], [-121.15255, 36.44795], [-121.15246, 36.44776], [-121.1523, 36.44759], [-121.15196, 36.44695], [-121.15193, 36.44667], [-121.15197, 36.44631], [-121.15212, 36.44602], [-121.15288, 36.44558], [-121.15291, 36.4456], [-121.15377, 36.44515], [-121.15375, 36.4448], [-121.15289, 36.44481], [-121.15303, 36.43052], [-121.15749, 36.43044], [-121.15759, 36.41966], [-121.15758, 36.41964], [-121.15311, 36.41976], [-121.15313, 36.41617], [-121.15591, 36.4161], [-121.16294, 36.42165], [-121.16294, 36.42163], [-121.15598, 36.4161], [-121.17111, 36.41562], [-121.1713, 36.40838], [-121.18915, 36.40841], [-121.18877, 36.4157], [-121.18882, 36.41572], [-121.18916, 36.42284], [-121.19811, 36.42286], [-121.19848, 36.43005], [-121.20745, 36.43012], [-121.20677, 36.44425], [-121.2023, 36.44429], [-121.20196, 36.4553], [-121.20194, 36.45528], [-121.20193, 36.45528], [-121.20182, 36.45907], [-121.20627, 36.45903], [-121.20583, 36.47364], [-121.21484, 36.47358], [-121.22391, 36.47328], [-121.2329, 36.4733], [-121.23434, 36.48834], [-121.23335, 36.48836], [-121.23274, 36.49533], [-121.23178, 36.50273], [-121.24024, 36.50282], [-121.24459, 36.50282]], [[-121.15014, 36.50067], [-121.14994, 36.50217], [-121.15252, 36.50215], [-121.15253, 36.50067], [-121.15014, 36.50067]], [[-121.15753, 36.48814], [-121.15596, 36.48815], [-121.15523, 36.49526], [-121.1599, 36.49537], [-121.1599, 36.49277], [-121.16036, 36.48829], [-121.15753, 36.48814]], [[-121.16964, 36.42698], [-121.16966, 36.42697], [-121.16936, 36.42674], [-121.16936, 36.42676], [-121.16964, 36.42698]], [[-121.19335, 36.44629], [-121.19336, 36.44628], [-121.19152, 36.44434], [-121.19138, 36.44424], [-121.19138, 36.44426], [-121.19335, 36.44629]]], [[[-121.14827, 36.53427], [-121.14507, 36.53528], [-121.14462, 36.53446], [-121.14546, 36.53416], [-121.14611, 36.53403], [-121.14628, 36.53382], [-121.14649, 36.53369], [-121.14704, 36.53351], [-121.14758, 36.53381], [-121.14815, 36.53406], [-121.14827, 36.53427]]]]} | Open Access 1 | Pinnacles National Park | http://www.nps.gov/pinn/index.htm | 14264 | 108 | United States National Park Service 59 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 26532.551 | Pinnacles NP | 2013 |
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]);