units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1 and YR_EST = 2006
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9688 | 9688 | 9687 | {"type": "Polygon", "coordinates": [[[-122.25145, 38.17329], [-122.25132, 38.17587], [-122.24971, 38.17597], [-122.24975, 38.17328], [-122.25145, 38.17329]]]} | Open Access 1 | 16361 | Main Street Park | 21690 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 10.509 | Main Street Park | 2006 | Local Park 2 | 4 | |
10121 | 10121 | 10120 | {"type": "Polygon", "coordinates": [[[-122.25007, 38.16579], [-122.25006, 38.16611], [-122.24926, 38.16618], [-122.24901, 38.16619], [-122.24855, 38.16624], [-122.24795, 38.16628], [-122.24767, 38.16632], [-122.24714, 38.16636], [-122.24707, 38.16634], [-122.24676, 38.16635], [-122.24673, 38.16638], [-122.24666, 38.16636], [-122.2466, 38.16636], [-122.24648, 38.16624], [-122.24617, 38.16623], [-122.24613, 38.16637], [-122.2461, 38.16692], [-122.24607, 38.16705], [-122.24567, 38.16833], [-122.24481, 38.16833], [-122.24437, 38.16835], [-122.24436, 38.16612], [-122.24297, 38.1657], [-122.24259, 38.16565], [-122.2424, 38.16566], [-122.24223, 38.16562], [-122.24167, 38.16545], [-122.24143, 38.16543], [-122.24137, 38.16545], [-122.24127, 38.16537], [-122.24113, 38.16538], [-122.24109, 38.16533], [-122.24066, 38.16533], [-122.24065, 38.16534], [-122.24096, 38.16671], [-122.24044, 38.16609], [-122.24015, 38.16562], [-122.24004, 38.16511], [-122.24004, 38.16489], [-122.24005, 38.16481], [-122.24015, 38.16476], [-122.24066, 38.16488], [-122.24128, 38.16496], [-122.24386, 38.16536], [-122.24448, 38.16579], [-122.24464, 38.16579], [-122.2447, 38.16598], [-122.24471, 38.16623], [-122.24684, 38.16591], [-122.2472, 38.16605], [-122.24759, 38.16583], [-122.24809, 38.16587], [-122.24906, 38.16569], [-122.24923, 38.16559], [-122.24923, 38.16557], [-122.24991, 38.16564], [-122.25007, 38.16579]]]} | Open Access 1 | 17590 | Silver Oak Park | 25492 | 1005 | American Canyon, City of 434 | City 2 | City Agency 2 | http://cityofamericancanyon.org/city-departments/parks-recreation | City 2 | 1005 | American Canyon, City of 428 | City 2 | City Agency 2 | Napa 11 | 19.202 | Silver Oak Park | 2006 | Local Park 2 | 4 | |
10363 | 10363 | 10362 | {"type": "Polygon", "coordinates": [[[-122.23717, 40.56026], [-122.2369, 40.56056], [-122.23549, 40.56201], [-122.23102, 40.56204], [-122.2313, 40.56082], [-122.23339, 40.56082], [-122.23339, 40.56028], [-122.23717, 40.56026]]]} | Open Access 1 | 48567 | Palo Cedro Community Park | 33316 | 3394 | Palo Cerdo Community Park Association 950 | Non Profit 6 | Non Profit - Conservation 12 | https://pcpark.org/ | Non Governmental Organization 10 | 3394 | Palo Cerdo Community Park Association 922 | Non Profit 6 | Non Profit - Conservation 12 | Shasta 27 | 18.256 | Palo Cedro Community Park | 2006 | Private Recreation or Education 65 | 4 | |
12922 | 12922 | 12921 | {"type": "Polygon", "coordinates": [[[-117.31395, 34.03037], [-117.31395, 34.03064], [-117.31376, 34.03064], [-117.31376, 34.03043], [-117.31383, 34.03037], [-117.31395, 34.03037]]]} | Open Access 1 | 30376 | Gwen Karger Park | 19578 | 1123 | Grand Terrace, City of 165 | City 2 | City Agency 2 | http://www.cityofgrandterrace.org/index.aspx?nid=25 | City 2 | 1123 | Grand Terrace, City of 161 | City 2 | City Agency 2 | http://www.grandterrace-ca.gov/gwen-karger-park.html | San Bernardino 22 | 0.128 | Gwen Karger Park | 2006 | Local Park 2 | 4 |
15868 | 15868 | 15867 | {"type": "MultiPolygon", "coordinates": [[[[-122.1074, 37.25755], [-122.10725, 37.25764], [-122.10719, 37.2577], [-122.1067, 37.2583], [-122.10656, 37.25845], [-122.10638, 37.25859], [-122.10618, 37.25869], [-122.10587, 37.25883], [-122.10568, 37.25889], [-122.10479, 37.25891], [-122.10456, 37.25896], [-122.10436, 37.25907], [-122.10338, 37.25976], [-122.10328, 37.25752], [-122.1074, 37.25755]]], [[[-122.11989, 37.26453], [-122.11783, 37.26453], [-122.11775, 37.26433], [-122.1169, 37.26452], [-122.11691, 37.26466], [-122.11282, 37.2656], [-122.11282, 37.26502], [-122.11281, 37.26501], [-122.11279, 37.26451], [-122.10751, 37.26456], [-122.10747, 37.26592], [-122.10403, 37.26591], [-122.10404, 37.26461], [-122.10365, 37.2646], [-122.10339, 37.25995], [-122.10359, 37.25983], [-122.1045, 37.25919], [-122.10464, 37.25911], [-122.10482, 37.25908], [-122.10572, 37.25905], [-122.10597, 37.25897], [-122.10646, 37.25875], [-122.10662, 37.25864], [-122.10676, 37.25852], [-122.10736, 37.25779], [-122.10749, 37.2577], [-122.10785, 37.25755], [-122.10844, 37.25755], [-122.10847, 37.25883], [-122.10953, 37.25882], [-122.10965, 37.25911], [-122.10966, 37.25921], [-122.10962, 37.25931], [-122.10955, 37.2594], [-122.1094, 37.2595], [-122.10926, 37.25963], [-122.10918, 37.25978], [-122.10916, 37.25986], [-122.10918, 37.26025], [-122.10921, 37.26034], [-122.10925, 37.26042], [-122.10939, 37.26056], [-122.10957, 37.26065], [-122.10967, 37.26068], [-122.10988, 37.2607], [-122.10999, 37.26068], [-122.1101, 37.26066], [-122.11095, 37.26023], [-122.1112, 37.26015], [-122.11133, 37.26014], [-122.1116, 37.26016], [-122.11244, 37.26049], [-122.11253, 37.26051], [-122.11263, 37.26051], [-122.11272, 37.26048], [-122.1128, 37.26044], [-122.11287, 37.26034], [-122.11288, 37.26026], [-122.11285, 37.26015], [-122.11257, 37.25989], [-122.11242, 37.25967], [-122.11242, 37.25961], [-122.11247, 37.25948], [-122.11256, 37.25937], [-122.113, 37.25911], [-122.11379, 37.259], [-122.11391, 37.25896], [-122.11402, 37.25889], [-122.1141, 37.25882], [-122.11434, 37.25845], [-122.11444, 37.25836], [-122.11453, 37.25832], [-122.11501, 37.25818], [-122.1153, 37.25802], [-122.11544, 37.25802], [-122.11723, 37.26288], [-122.11725, 37.26301], [-122.1172, 37.26315], [-122.11722, 37.26323], [-122.11727, 37.2633], [-122.11739, 37.26337], [-122.11749, 37.26339], [-122.11834, 37.26332], [-122.11841, 37.26326], [-122.11849, 37.2631], [-122.11853, 37.26306], [-122.11939, 37.26269], [-122.11979, 37.26239], [-122.11986, 37.26236], [-122.12033, 37.26232], [-122.12055, 37.26242], [-122.1206, 37.26246], [-122.12062, 37.26253], [-122.12059, 37.26262], [-122.12052, 37.2627], [-122.12035, 37.26275], [-122.12028, 37.2628], [-122.11998, 37.26333], [-122.11994, 37.26337], [-122.11992, 37.26344], [-122.11993, 37.26349], [-122.11997, 37.26355], [-122.12045, 37.26383], [-122.1205, 37.26391], [-122.12049, 37.26399], [-122.12044, 37.26407], [-122.11989, 37.26453]]], [[[-122.13449, 37.27921], [-122.12327, 37.27902], [-122.12325, 37.27177], [-122.12328, 37.27176], [-122.11989, 37.25762], [-122.11586, 37.25759], [-122.11594, 37.25742], [-122.11594, 37.25724], [-122.11587, 37.25707], [-122.11573, 37.25686], [-122.11571, 37.25672], [-122.11574, 37.25658], [-122.11577, 37.25651], [-122.11589, 37.25639], [-122.11599, 37.25632], [-122.11624, 37.25624], [-122.1165, 37.25622], [-122.11664, 37.25624], [-122.11676, 37.25627], [-122.11745, 37.25658], [-122.11804, 37.25687], [-122.11842, 37.25709], [-122.11863, 37.25714], [-122.1191, 37.25717], [-122.11921, 37.25719], [-122.12019, 37.25764], [-122.12034, 37.25774], [-122.12045, 37.25787], [-122.12056, 37.25818], [-122.12061, 37.25828], [-122.12067, 37.25838], [-122.12121, 37.25865], [-122.12134, 37.25866], [-122.12132, 37.25869], [-122.12133, 37.2587], [-122.12161, 37.25868], [-122.12177, 37.2587], [-122.12192, 37.25874], [-122.12206, 37.2588], [-122.12324, 37.25961], [-122.12342, 37.25971], [-122.12362, 37.25979], [-122.12383, 37.25984], [-122.12405, 37.25986], [-122.12427, 37.25986], [-122.12448, 37.25982], [-122.12469, 37.25976], [-122.12517, 37.25958], [-122.12536, 37.25951], [-122.12557, 37.25948], [-122.12578, 37.25947], [-122.12599, 37.25948], [-122.12646, 37.25953], [-122.12671, 37.25955], [-122.12696, 37.25952], [-122.12768, 37.25934], [-122.12789, 37.25932], [-122.12809, 37.25932], [-122.12829, 37.25936], [-122.12848, 37.25942], [-122.12866, 37.2595], [-122.1297, 37.26009], [-122.13077, 37.26059], [-122.13112, 37.26079], [-122.13211, 37.26145], [-122.13223, 37.26155], [-122.13262, 37.26207], [-122.13281, 37.26225], [-122.13304, 37.2624], [-122.13329, 37.26252], [-122.13365, 37.26267], [-122.1343, 37.27166], [-122.13449, 37.27921]]]]} | Open Access 1 | 563 | Saratoga Gap Open Space Preserve | 31466 | 2079 | Midpeninsula Regional Open Space District 366 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org | Special District 4 | 2079 | Midpeninsula Regional Open Space District 631 | Special District 4 | Recreation/Parks District 4 | http://www.openspace.org/preserves/pr_saratoga_gap.asp | Santa Clara 19 | 770.098 | Saratoga Gap OSP | 2006 | Local Conservation Area 4 | 2 |
16379 | 16379 | 16378 | {"type": "MultiPolygon", "coordinates": [[[[-122.22214, 38.01075], [-122.22214, 38.01075], [-122.22189, 38.0414], [-122.21985, 38.03985], [-122.21743, 38.03824], [-122.21573, 38.03546], [-122.21572, 38.03488], [-122.21505, 38.03426], [-122.21389, 38.0342], [-122.21325, 38.03321], [-122.21205, 38.03281], [-122.2123, 38.03259], [-122.2123, 38.03257], [-122.21199, 38.03238], [-122.21158, 38.03216], [-122.21088, 38.03149], [-122.2104, 38.03111], [-122.20991, 38.03053], [-122.20943, 38.03014], [-122.20876, 38.02969], [-122.20749, 38.02873], [-122.20687, 38.02836], [-122.20728, 38.02784], [-122.20728, 38.02783], [-122.20659, 38.02826], [-122.20614, 38.02808], [-122.20621, 38.02419], [-122.20638, 38.0175], [-122.20398, 38.01753], [-122.20198, 38.01669], [-122.20191, 38.01472], [-122.20192, 38.01217], [-122.20369, 38.01147], [-122.20439, 38.01063], [-122.20779, 38.00949], [-122.20884, 38.01012], [-122.2093, 38.01008], [-122.21085, 38.00964], [-122.21133, 38.00874], [-122.2127, 38.0089], [-122.21413, 38.00921], [-122.21419, 38.00908], [-122.21456, 38.00914], [-122.21492, 38.00918], [-122.21538, 38.00921], [-122.21598, 38.00919], [-122.21598, 38.01072], [-122.22214, 38.01075]]], [[[-122.22191, 38.04246], [-122.22189, 38.04847], [-122.22144, 38.04852], [-122.22131, 38.04857], [-122.22036, 38.04704], [-122.22014, 38.04658], [-122.22062, 38.04658], [-122.22062, 38.04712], [-122.22083, 38.04713], [-122.22083, 38.04609], [-122.22056, 38.04565], [-122.21975, 38.04596], [-122.21956, 38.04559], [-122.21975, 38.04552], [-122.21945, 38.04502], [-122.21823, 38.04363], [-122.21677, 38.04258], [-122.21597, 38.04189], [-122.21494, 38.04029], [-122.21451, 38.03991], [-122.21429, 38.03984], [-122.21377, 38.03979], [-122.21191, 38.03886], [-122.21161, 38.03895], [-122.21052, 38.03865], [-122.21011, 38.0385], [-122.20992, 38.0384], [-122.2097, 38.03825], [-122.20879, 38.03671], [-122.20876, 38.0365], [-122.2088, 38.03624], [-122.20888, 38.03598], [-122.209, 38.03575], [-122.20918, 38.03553], [-122.2094, 38.03533], [-122.20966, 38.03517], [-122.20995, 38.03504], [-122.21025, 38.03495], [-122.21049, 38.0349], [-122.2117, 38.03501], [-122.21187, 38.03507], [-122.21216, 38.03519], [-122.21241, 38.03534], [-122.2129, 38.03568], [-122.21296, 38.03584], [-122.21344, 38.03605], [-122.21538, 38.03737], [-122.21614, 38.03702], [-122.21657, 38.03774], [-122.21669, 38.03829], [-122.21714, 38.03858], [-122.21801, 38.03944], [-122.21934, 38.04012], [-122.21957, 38.04034], [-122.21995, 38.04095], [-122.22146, 38.04224], [-122.22191, 38.04246]]]]} | Open Access 1 | 22284 | Crockett Hills Regional Park | 3246 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/parks/crockett_hills | Contra Costa 12 | 1127.007 | Crockett Hills RP | 2006 | Local Park 2 | 4 |
16420 | 16420 | 16419 | {"type": "MultiPolygon", "coordinates": [[[[-121.18213, 38.97105], [-121.1726, 38.97098], [-121.16305, 38.97055], [-121.16315, 38.9633], [-121.16337, 38.95628], [-121.16418, 38.95627], [-121.16436, 38.95648], [-121.16487, 38.95686], [-121.16513, 38.95721], [-121.16527, 38.95736], [-121.16559, 38.95748], [-121.16589, 38.95782], [-121.16614, 38.95819], [-121.16611, 38.96087], [-121.16915, 38.96346], [-121.17248, 38.96354], [-121.18199, 38.96348], [-121.19112, 38.96335], [-121.2006, 38.96332], [-121.20992, 38.96332], [-121.20989, 38.96696], [-121.20985, 38.96762], [-121.20985, 38.97062], [-121.20974, 38.97424], [-121.20966, 38.97782], [-121.20022, 38.97793], [-121.19116, 38.978], [-121.19131, 38.97085], [-121.18213, 38.97105]]], [[[-121.21912, 38.97648], [-121.21872, 38.97647], [-121.2185, 38.97649], [-121.21802, 38.97633], [-121.21801, 38.97634], [-121.21816, 38.97662], [-121.21813, 38.97665], [-121.2181, 38.97674], [-121.2181, 38.97683], [-121.21815, 38.97692], [-121.21826, 38.97706], [-121.21895, 38.97778], [-121.21443, 38.97778], [-121.21449, 38.97418], [-121.21911, 38.97416], [-121.21912, 38.97648]]]]} | Open Access 1 | 44942 | Hidden Falls Regional Park | 8647 | 314 | Placer, County of 210 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks | County 3 | 314 | Placer, County of 206 | County 3 | County Agency 3 | http://www.placer.ca.gov/departments/facility/parks/parks-content/parks/hidden-falls | Placer 35 | 1234.21 | Hidden Falls RP | 2006 | Local Park 2 | 4 |
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]);