superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
6 rows where ACCESS_TYP = 1 and PARK_NAME = "Wildwood Park"
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
ACCESS_TYP 1
- Open Access · 6 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
453 | 453 | 452 | {"type": "MultiPolygon", "coordinates": [[[[-118.929, 34.2258], [-118.92068, 34.22582], [-118.92067, 34.22762], [-118.91778, 34.22766], [-118.91714, 34.22759], [-118.91755, 34.22693], [-118.91775, 34.22593], [-118.91691, 34.22584], [-118.91635, 34.22599], [-118.91601, 34.22659], [-118.91295, 34.22723], [-118.91214, 34.22692], [-118.91024, 34.22704], [-118.90942, 34.22821], [-118.90946, 34.23106], [-118.91009, 34.23109], [-118.9101, 34.2314], [-118.90102, 34.23438], [-118.8996, 34.23436], [-118.8973, 34.23461], [-118.89527, 34.23626], [-118.89432, 34.23617], [-118.89261, 34.23545], [-118.89218, 34.2367], [-118.89145, 34.2371], [-118.88914, 34.23694], [-118.88864, 34.23828], [-118.88577, 34.2375], [-118.88575, 34.22579], [-118.88679, 34.22561], [-118.88704, 34.22505], [-118.88737, 34.22494], [-118.88854, 34.22471], [-118.8895, 34.22466], [-118.89064, 34.22442], [-118.89135, 34.22457], [-118.89138, 34.22467], [-118.89159, 34.22474], [-118.89252, 34.22455], [-118.89299, 34.22456], [-118.89333, 34.22406], [-118.89354, 34.2244], [-118.89378, 34.22497], [-118.89385, 34.22529], [-118.89391, 34.22571], [-118.89388, 34.22609], [-118.89382, 34.22643], [-118.89367, 34.22706], [-118.89365, 34.22738], [-118.89369, 34.22766], [-118.89376, 34.22785], [-118.89388, 34.22805], [-118.89405, 34.22825], [-118.8937, 34.22844], [-118.893, 34.22859], [-118.89296, 34.22919], [-118.8925, 34.22925], [-118.89221, 34.22923], [-118.89207, 34.22863], [-118.89213, 34.22821], [-118.89181, 34.2276], [-118.89106, 34.22732], [-118.89076, 34.22744], [-118.89026, 34.22795], [-118.88897, 34.22838], [-118.88859, 34.22841], [-118.88831, 34.2286], [-118.88775, 34.22886], [-118.88768, 34.22929], [-118.88796, 34.22975], [-118.88769, 34.23003], [-118.88757, 34.23012], [-118.88705, 34.23044], [-118.8865, 34.23118], [-118.88684, 34.23148], [-118.8871, 34.23142], [-118.8872, 34.23149], [-118.88715, 34.23167], [-118.88738, 34.2321], [-118.88769, 34.23225], [-118.88807, 34.23202], [-118.88827, 34.23178], [-118.88834, 34.23161], [-118.88888, 34.23099], [-118.89028, 34.23043], [-118.89065, 34.23001], [-118.89092, 34.22984], [-118.89124, 34.22975], [-118.89182, 34.22996], [-118.8923, 34.23006], [-118.89324, 34.2299], [-118.89402, 34.23019], [-118.89476, 34.23], [-118.89514, 34.2295], [-118.89555, 34.22936], [-118.89618, 34.22911], [-118.89748, 34.22816], [-118.89732, 34.2277], [-118.8978, 34.22765], [-118.89902, 34.22726], [-118.89917, 34.22722], [-118.89945, 34.22812], [-118.9001, 34.22813], [-118.90038, 34.22822], [-118.90076, 34.22813], [-118.90115, 34.2279], [-118.90139, 34.22803], [-118.90165, 34.2281], [-118.90203, 34.22802], [-118.90246, 34.22749], [-118.90277, 34.22753], [-118.9032, 34.22744], [-118.9033, 34.22731], [-118.90334, 34.22696], [-118.90358, 34.22678], [-118.90361, 34.22645], [-118.90345, 34.2263], [-118.90329, 34.22584], [-118.90291, 34.22585], [-118.90182, 34.22606], [-118.90111, 34.22609], [-118.90059, 34.22635], [-118.90016, 34.22661], [-118.89982, 34.2266], [-118.89882, 34.2267], [-118.89875, 34.22719], [-118.89774, 34.22752], [-118.89753, 34.22755], [-118.89727, 34.22757], [-118.89704, 34.22761], [-118.89684, 34.22768], [-118.89668, 34.22775], [-118.8965, 34.22786], [-118.89631, 34.22802], [-118.89599, 34.22753], [-118.89498, 34.22794], [-118.89482, 34.22829], [-118.89458, 34.2284], [-118.89439, 34.22829], [-118.8942, 34.22815], [-118.89404, 34.22797], [-118.89393, 34.2278], [-118.89477, 34.22767], [-118.89502, 34.22722], [-118.89595, 34.22697], [-118.8962, 34.2268], [-118.89638, 34.22667], [-118.89653, 34.22652], [-118.89664, 34.22623], [-118.89658, 34.22568], [-118.89736, 34.22548], [-118.89906, 34.22494], [-118.89994, 34.22456], [-118.90019, 34.22444], [-118.90042, 34.2243], [-118.90124, 34.22369], [-118.9016, 34.22334], [-118.90192, 34.22275], [-118.90226, 34.22311], [-118.90248, 34.22273], [-118.90255, 34.22275], [-118.90262, 34.22273], [-118.90268, 34.22266], [-118.9043, 34.22269], [-118.90466, 34.22248], [-118.90585, 34.22216], [-118.906, 34.22166], [-118.90598, 34.22111], [-118.90584, 34.22089], [-118.90507, 34.22078], [-118.90462, 34.22081], [-118.90392, 34.22074], [-118.90292, 34.22045], [-118.903, 34.22032], [-118.90299, 34.2203], [-118.89792, 34.21841], [-118.89805, 34.21805], [-118.89851, 34.21771], [-118.89877, 34.21773], [-118.89895, 34.21808], [-118.89956, 34.21808], [-118.89983, 34.21777], [-118.90016, 34.21716], [-118.90094, 34.2165], [-118.90109, 34.21667], [-118.9013, 34.21675], [-118.90164, 34.21676], [-118.9023, 34.21658], [-118.90286, 34.21635], [-118.90319, 34.21614], [-118.90322, 34.21571], [-118.90275, 34.21483], [-118.90229, 34.21464], [-118.90178, 34.21475], [-118.90114, 34.21499], [-118.90086, 34.21525], [-118.90074, 34.21507], [-118.90102, 34.21454], [-118.90124, 34.21422], [-118.90121, 34.21411], [-118.90133, 34.21336], [-118.9011, 34.21293], [-118.90036, 34.21315], [-118.90023, 34.21335], [-118.90032, 34.2135], [-118.90027, 34.2136], [-118.90007, 34.21356], [-118.89992, 34.21385], [-118.8992, 34.21363], [-118.89883, 34.21419], [-118.89915, 34.21511], [-118.8986, 34.21534], [-118.89836, 34.2154], [-118.89806, 34.21541], [-118.89806, 34.21509], [-118.8979, 34.21501], [-118.89763, 34.21503], [-118.89723, 34.21498], [-118.89689, 34.21498], [-118.89642, 34.21416], [-118.89524, 34.21426], [-118.89446, 34.21459], [-118.89465, 34.21486], [-118.89456, 34.2149], [-118.89436, 34.21465], [-118.8932, 34.21474], [-118.8928, 34.21512], [-118.8925, 34.21513], [-118.89204, 34.21538], [-118.89187, 34.21598], [-118.89239, 34.21615], [-118.89262, 34.21624], [-118.89253, 34.21641], [-118.89193, 34.21619], [-118.89148, 34.21609], [-118.89124, 34.21606], [-118.89188, 34.21479], [-118.89044, 34.21448], [-118.88987, 34.21406], [-118.88881, 34.21404], [-118.88878, 34.21419], [-118.88798, 34.21426], [-118.8879, 34.21394], [-118.88776, 34.21356], [-118.88815, 34.21378], [-118.88857, 34.21359], [-118.89028, 34.21371], [-118.89075, 34.21396], [-118.8912, 34.21406], [-118.89124, 34.21369], [-118.89131, 34.21369], [-118.8913, 34.214], [-118.89131, 34.21402], [-118.89212, 34.21401], [-118.89381, 34.21389], [-118.89412, 34.21354], [-118.89404, 34.21307], [-118.89127, 34.2117], [-118.89018, 34.21145], [-118.88991, 34.21147], [-118.88975, 34.21132], [-118.88897, 34.21107], [-118.88824, 34.21101], [-118.88772, 34.21118], [-118.88736, 34.21141], [-118.88713, 34.21162], [-118.88697, 34.21153], [-118.88664, 34.21175], [-118.88637, 34.21134], [-118.886, 34.21067], [-118.88561, 34.20971], [-118.88554, 34.20947], [-118.8855, 34.20914], [-118.88549, 34.20859], [-118.88553, 34.20826], [-118.88558, 34.20796], [-118.8857, 34.20763], [-118.88583, 34.20734], [-118.88618, 34.20668], [-118.88634, 34.20641], [-118.88646, 34.20627], [-118.88654, 34.20625], [-118.88682, 34.20632], [-118.88707, 34.20633], [-118.88732, 34.20629], [-118.88784, 34.20612], [-118.88813, 34.20606], [-118.88851, 34.20603], [-118.88883, 34.20603], [-118.88955, 34.20609], [-118.89014, 34.20711], [-118.89022, 34.20711], [-118.89057, 34.20689], [-118.89071, 34.20711], [-118.89124, 34.20699], [-118.89128, 34.20693], [-118.89152, 34.20696], [-118.89176, 34.20706], [-118.89177, 34.20719], [-118.89209, 34.20718], [-118.89254, 34.20726], [-118.89255, 34.20711], [-118.89276, 34.20709], [-118.89291, 34.20697], [-118.89326, 34.20687], [-118.89351, 34.20667], [-118.89359, 34.20679], [-118.89365, 34.20682], [-118.89375, 34.20682], [-118.89382, 34.20677], [-118.89412, 34.20695], [-118.89509, 34.20583], [-118.89542, 34.20596], [-118.89508, 34.20682], [-118.89486, 34.20699], [-118.89479, 34.20726], [-118.8952, 34.20739], [-118.89534, 34.20727], [-118.89539, 34.2073], [-118.89547, 34.20731], [-118.89557, 34.20727], [-118.89561, 34.20719], [-118.89558, 34.20708], [-118.89558, 34.20695], [-118.89562, 34.20685], [-118.89582, 34.20653], [-118.89597, 34.20615], [-118.89604, 34.20613], [-118.8963, 34.20612], [-118.89641, 34.2061], [-118.89675, 34.20598], [-118.89679, 34.20599], [-118.89683, 34.20604], [-118.89684, 34.20611], [-118.89632, 34.20633], [-118.89654, 34.20692], [-118.89764, 34.20679], [-118.8978, 34.20658], [-118.89765, 34.20607], [-118.89792, 34.20601], [-118.89809, 34.20572], [-118.89772, 34.20533], [-118.89792, 34.20518], [-118.89844, 34.20462], [-118.89848, 34.2046], [-118.89852, 34.2046], [-118.89856, 34.20461], [-118.89876, 34.20478], [-118.89895, 34.20497], [-118.89914, 34.2052], [-118.89944, 34.20577], [-118.89968, 34.20609], [-118.89992, 34.20635], [-118.89896, 34.20732], [-118.89893, 34.20773], [-118.89899, 34.20815], [-118.89962, 34.20868], [-118.89998, 34.2087], [-118.90026, 34.20858], [-118.90038, 34.20814], [-118.90052, 34.2079], [-118.90106, 34.20737], [-118.90127, 34.20792], [-118.90115, 34.20839], [-118.90097, 34.20862], [-118.90096, 34.20892], [-118.90112, 34.20938], [-118.90124, 34.20954], [-118.9015, 34.20964], [-118.90182, 34.20964], [-118.90214, 34.20948], [-118.90232, 34.20933], [-118.90266, 34.20876], [-118.90291, 34.20875], [-118.90359, 34.20903], [-118.90339, 34.20944], [-118.90344, 34.2097], [-118.90362, 34.20999], [-118.90386, 34.2101], [-118.90414, 34.21017], [-118.90442, 34.21009], [-118.9046, 34.2101], [-118.90456, 34.21041], [-118.90467, 34.21095], [-118.90507, 34.21097], [-118.9051, 34.21132], [-118.90523, 34.21146], [-118.90567, 34.21162], [-118.90612, 34.21154], [-118.90648, 34.21109], [-118.90671, 34.21094], [-118.90699, 34.21085], [-118.90771, 34.21086], [-118.90793, 34.21092], [-118.90817, 34.21132], [-118.90903, 34.21164], [-118.90981, 34.21196], [-118.90998, 34.21193], [-118.91042, 34.21195], [-118.91069, 34.21204], [-118.91093, 34.21209], [-118.91139, 34.21196], [-118.91161, 34.21196], [-118.91181, 34.21202], [-118.91197, 34.21204], [-118.91209, 34.21202], [-118.91219, 34.21196], [-118.91229, 34.21183], [-118.91246, 34.21144], [-118.91268, 34.21103], [-118.91286, 34.21073], [-118.91308, 34.21046], [-118.91358, 34.2101], [-118.91362, 34.20992], [-118.91354, 34.20975], [-118.91173, 34.20879], [-118.91201, 34.20816], [-118.91211, 34.20805], [-118.91242, 34.20779], [-118.91251, 34.20753], [-118.91253, 34.20734], [-118.91251, 34.20707], [-118.91236, 34.2068], [-118.91211, 34.2068], [-118.91217, 34.20627], [-118.91193, 34.20579], [-118.91151, 34.20608], [-118.91145, 34.20594], [-118.9117, 34.20575], [-118.91477, 34.20571], [-118.91435, 34.20701], [-118.91571, 34.20739], [-118.91857, 34.20854], [-118.92022, 34.20901], [-118.92196, 34.21056], [-118.92148, 34.21104], [-118.92068, 34.21071], [-118.92067, 34.21071], [-118.92068, 34.21146], [-118.92126, 34.21166], [-118.92017, 34.21358], [-118.91979, 34.21488], [-118.91992, 34.21489], [-118.92105, 34.21513], [-118.92157, 34.214], [-118.92315, 34.21151], [-118.92348, 34.21177], [-118.92379, 34.21443], [-118.92331, 34.21766], [-118.92454, 34.21958], [-118.92665, 34.22497], [-118.92829, 34.22498], [-118.929, 34.2258]], [[-118.88925, 34.20829], [-118.88927, 34.20827], [-118.88915, 34.20693], [-118.88749, 34.207], [-118.8876, 34.20837], [-118.88925, 34.20829]], [[-118.90318, 34.22572], [-118.90319, 34.22574], [-118.9036, 34.22591], [-118.90381, 34.22558], [-118.9034, 34.22539], [-118.90318, 34.22572]]], [[[-118.89674, 34.22032], [-118.8964, 34.22051], [-118.89655, 34.22071], [-118.89649, 34.22074], [-118.89632, 34.22055], [-118.89605, 34.22071], [-118.8962, 34.22103], [-118.89609, 34.22114], [-118.89591, 34.22102], [-118.89575, 34.22106], [-118.89541, 34.2212], [-118.89534, 34.22135], [-118.89551, 34.22201], [-118.89583, 34.22198], [-118.89584, 34.22208], [-118.89553, 34.2221], [-118.89358, 34.22214], [-118.89264, 34.22258], [-118.89254, 34.22244], [-118.89371, 34.22194], [-118.89415, 34.2218], [-118.89493, 34.22129], [-118.89529, 34.22103], [-118.89628, 34.22042], [-118.89651, 34.22037], [-118.89669, 34.22026], [-118.89674, 34.22032]]]]} | Open Access 1 | Wildwood Park | http://www.crpd.org/parkfac/parks/wildwood.asp | 2635 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 1705.345 | Wildwood Park | |
11220 | 11220 | 11219 | {"type": "Polygon", "coordinates": [[[-121.80608, 39.76755], [-121.80419, 39.76528], [-121.80279, 39.76367], [-121.80358, 39.76323], [-121.80417, 39.76268], [-121.80426, 39.76274], [-121.80495, 39.76259], [-121.80525, 39.76249], [-121.80535, 39.76249], [-121.80539, 39.76252], [-121.80554, 39.76278], [-121.80578, 39.7633], [-121.80587, 39.76356], [-121.80597, 39.76392], [-121.80605, 39.76446], [-121.80608, 39.76755]]]} | Open Access 1 | Wildwood Park | 27520 | 1052 | Chico, City of 424 | City 2 | City Agency 2 | http://www.chico.ca.us/general_services_department/park_division/home_page.asp | City 2 | 19.794 | Wildwood Park | ||
11221 | 11221 | 11220 | {"type": "Polygon", "coordinates": [[[-117.27856, 34.17011], [-117.27837, 34.16963], [-117.27812, 34.16909], [-117.27778, 34.16851], [-117.27754, 34.16817], [-117.27728, 34.16784], [-117.27701, 34.16753], [-117.27661, 34.16713], [-117.27629, 34.16684], [-117.27584, 34.16649], [-117.27549, 34.16623], [-117.27511, 34.166], [-117.27473, 34.16578], [-117.27419, 34.16551], [-117.27364, 34.16527], [-117.27321, 34.16511], [-117.27854, 34.16512], [-117.27856, 34.17011]]]} | Open Access 1 | Wildwood Park | 27521 | 1293 | San Bernardino, City of 163 | City 2 | City Agency 2 | http://www.ci.san-bernardino.ca.us/cityhall/parks/default.asp | City 2 | 23.111 | Wildwood Park | ||
11222 | 11222 | 11221 | {"type": "Polygon", "coordinates": [[[-122.03638, 37.25821], [-122.03593, 37.25874], [-122.03597, 37.25918], [-122.03594, 37.25923], [-122.03589, 37.25925], [-122.03554, 37.25925], [-122.03493, 37.25809], [-122.03453, 37.25824], [-122.03447, 37.25816], [-122.03424, 37.25825], [-122.03421, 37.25833], [-122.03411, 37.25826], [-122.03489, 37.25761], [-122.03528, 37.2575], [-122.03535, 37.25755], [-122.03535, 37.25758], [-122.03543, 37.25755], [-122.03563, 37.25759], [-122.03569, 37.25752], [-122.03636, 37.25777], [-122.03625, 37.25777], [-122.03609, 37.25782], [-122.0361, 37.25788], [-122.0362, 37.2581], [-122.03638, 37.25821]]]} | Open Access 1 | Wildwood Park | 27522 | 1326 | Saratoga, City of 513 | City 2 | City Agency 2 | http://www.saratoga.ca.us/cityhall/pw/parks/default.asp | City 2 | 4.494 | Wildwood Park | 1968 | |
11223 | 11223 | 11222 | {"type": "Polygon", "coordinates": [[[-117.2368, 33.20483], [-117.23693, 33.20506], [-117.23694, 33.20515], [-117.23692, 33.20532], [-117.23689, 33.20539], [-117.2366, 33.20577], [-117.2364, 33.20609], [-117.23565, 33.20588], [-117.2361, 33.20519], [-117.2368, 33.20483]]]} | Open Access 1 | Wildwood Park | http://www.cityofvista.com/services/parks-and-facilities | 27523 | 1369 | Vista, City of 155 | City 2 | City Agency 2 | http://www.cityofvista.com/departments/parks/parks_and_facilities.cfm | City 2 | 2.221 | Wildwood Park | |
11224 | 11224 | 11223 | {"type": "MultiPolygon", "coordinates": [[[[-117.00876, 34.01403], [-117.00847, 34.01408], [-117.00827, 34.01415], [-117.00803, 34.01428], [-117.00786, 34.01441], [-117.00773, 34.01456], [-117.00763, 34.01473], [-117.00757, 34.01491], [-117.00755, 34.01512], [-117.00748, 34.01517], [-117.00748, 34.01529], [-117.0042, 34.01527], [-117.00417, 34.01412], [-117.00484, 34.01389], [-117.00517, 34.01359], [-117.0064, 34.01388], [-117.008, 34.01403], [-117.00876, 34.01403]]], [[[-117.01091, 34.01525], [-117.00967, 34.01531], [-117.0079, 34.0153], [-117.00791, 34.01517], [-117.00785, 34.01513], [-117.00784, 34.01506], [-117.00786, 34.01493], [-117.0079, 34.01482], [-117.00798, 34.01467], [-117.00806, 34.01456], [-117.00817, 34.01446], [-117.00827, 34.01438], [-117.00852, 34.01428], [-117.00956, 34.01406], [-117.01027, 34.01412], [-117.0109, 34.01408], [-117.01091, 34.01525]]]]} | Open Access 1 | Wildwood Park | 27524 | 1387 | Yucaipa, City of 81 | City 2 | City Agency 2 | http://yucaipa.org/recreation/parks/ | City 2 | 21.305 | Wildwood Park |
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]);