units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1 and YR_EST = 1935
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3626 | 3626 | 3625 | {"type": "Polygon", "coordinates": [[[-122.3468, 37.58139], [-122.34466, 37.58278], [-122.34314, 37.58149], [-122.34459, 37.58052], [-122.34494, 37.58081], [-122.34519, 37.58063], [-122.3468, 37.58139]]]} | Open Access 1 | 13520 | Washington Park | 27273 | 1039 | Burlingame, City of 390 | City 2 | City Agency 2 | http://www.burlingame.org/index.aspx?page=33 | City 2 | 1039 | Burlingame, City of 384 | City 2 | City Agency 2 | San Mateo 15 | 10.223 | Washington Park | 1935 | Local Park 2 | 4 | |
6137 | 6137 | 6136 | {"type": "Polygon", "coordinates": [[[-122.23198, 37.47215], [-122.23113, 37.47282], [-122.23092, 37.4728], [-122.23031, 37.47231], [-122.23032, 37.47228], [-122.23124, 37.47156], [-122.23198, 37.47215]]]} | Open Access 1 | 13957 | Hawes Park | 19743 | 1271 | Redwood City, City of 397 | City 2 | City Agency 2 | http://www.redwoodcity.org/parks/ | City 2 | 1271 | Redwood City, City of 391 | City 2 | City Agency 2 | San Mateo 15 | 2.67 | Hawes Park | 1935 | Local Park 2 | 4 | |
16482 | 16482 | 16481 | {"type": "MultiPolygon", "coordinates": [[[[-120.64219, 35.13564], [-120.64136, 35.13627], [-120.64138, 35.13632], [-120.64124, 35.13643], [-120.64121, 35.13638], [-120.64117, 35.13641], [-120.6411, 35.13638], [-120.64082, 35.13659], [-120.64071, 35.13648], [-120.64063, 35.13652], [-120.64044, 35.13639], [-120.64028, 35.13645], [-120.64002, 35.13632], [-120.64068, 35.13588], [-120.6402, 35.13533], [-120.63894, 35.13431], [-120.63866, 35.13386], [-120.63813, 35.1329], [-120.63777, 35.1322], [-120.63767, 35.13191], [-120.63761, 35.13159], [-120.63514, 35.13336], [-120.63258, 35.13106], [-120.63215, 35.13009], [-120.63202, 35.12851], [-120.63377, 35.1286], [-120.63378, 35.12858], [-120.63366, 35.12827], [-120.63343, 35.12794], [-120.63297, 35.12755], [-120.63286, 35.12742], [-120.63276, 35.12718], [-120.6327, 35.12698], [-120.63265, 35.12649], [-120.63259, 35.12616], [-120.63241, 35.12552], [-120.6323, 35.12519], [-120.63216, 35.12486], [-120.63181, 35.12411], [-120.63179, 35.12396], [-120.63166, 35.1237], [-120.63159, 35.12371], [-120.63156, 35.12365], [-120.63162, 35.12362], [-120.63149, 35.12339], [-120.63141, 35.12326], [-120.63106, 35.12282], [-120.63098, 35.12268], [-120.63092, 35.12255], [-120.63083, 35.12214], [-120.63268, 35.12223], [-120.6327, 35.12196], [-120.63009, 35.12183], [-120.63001, 35.12178], [-120.62996, 35.12128], [-120.62986, 35.12092], [-120.62732, 35.11543], [-120.62599, 35.11265], [-120.62668, 35.11244], [-120.62668, 35.11243], [-120.62661, 35.11229], [-120.62592, 35.1125], [-120.6254, 35.11137], [-120.62608, 35.11116], [-120.62603, 35.11101], [-120.62533, 35.11121], [-120.62482, 35.1101], [-120.6257, 35.10982], [-120.62495, 35.1082], [-120.62475, 35.10701], [-120.62764, 35.10612], [-120.62777, 35.10611], [-120.62791, 35.10675], [-120.63011, 35.10643], [-120.63017, 35.10669], [-120.63023, 35.10667], [-120.63017, 35.10642], [-120.63057, 35.10637], [-120.63062, 35.1066], [-120.63081, 35.10657], [-120.63062, 35.10569], [-120.63123, 35.1056], [-120.63123, 35.10559], [-120.63119, 35.10538], [-120.63058, 35.10547], [-120.63008, 35.10051], [-120.62832, 35.10063], [-120.6286, 35.10346], [-120.62804, 35.1035], [-120.62744, 35.10403], [-120.6274, 35.10387], [-120.62734, 35.10377], [-120.62741, 35.10018], [-120.62348, 35.09977], [-120.62327, 35.09366], [-120.62133, 35.09365], [-120.61762, 35.09371], [-120.61764, 35.09083], [-120.61435, 35.09082], [-120.61434, 35.09064], [-120.61373, 35.09064], [-120.61198, 35.08916], [-120.61192, 35.08856], [-120.6111, 35.08704], [-120.61102, 35.08587], [-120.60947, 35.08461], [-120.60902, 35.08441], [-120.60789, 35.08398], [-120.60651, 35.08336], [-120.60528, 35.08232], [-120.60463, 35.082], [-120.60462, 35.08151], [-120.60193, 35.08029], [-120.60234, 35.08034], [-120.60251, 35.08004], [-120.60186, 35.07992], [-120.60207, 35.07896], [-120.60561, 35.07919], [-120.60999, 35.07916], [-120.61292, 35.07963], [-120.61933, 35.08203], [-120.61932, 35.08098], [-120.62864, 35.08087], [-120.62837, 35.07497], [-120.62825, 35.06616], [-120.62807, 35.06267], [-120.62793, 35.06078], [-120.6279, 35.05684], [-120.62808, 35.05592], [-120.62861, 35.05129], [-120.63018, 35.04128], [-120.63275, 35.04134], [-120.63312, 35.04236], [-120.633, 35.04255], [-120.6329, 35.04283], [-120.63288, 35.0432], [-120.63289, 35.04378], [-120.63286, 35.04401], [-120.63282, 35.04412], [-120.63271, 35.04427], [-120.63258, 35.04454], [-120.63251, 35.04473], [-120.6325, 35.04508], [-120.63242, 35.04532], [-120.63206, 35.04662], [-120.63206, 35.04716], [-120.6321, 35.04791], [-120.63205, 35.04814], [-120.632, 35.04873], [-120.63183, 35.0493], [-120.6317, 35.04968], [-120.63163, 35.05028], [-120.63158, 35.05233], [-120.63153, 35.05203], [-120.63123, 35.05291], [-120.6312, 35.05324], [-120.63121, 35.05365], [-120.63121, 35.05465], [-120.63119, 35.05482], [-120.63099, 35.05537], [-120.6309, 35.05567], [-120.63086, 35.05596], [-120.63101, 35.05668], [-120.63101, 35.05682], [-120.63027, 35.05683], [-120.62962, 35.06827], [-120.62988, 35.08648], [-120.63004, 35.08703], [-120.63034, 35.08865], [-120.63044, 35.09202], [-120.63076, 35.09403], [-120.63067, 35.09618], [-120.63075, 35.09895], [-120.6309, 35.10003], [-120.63115, 35.10213], [-120.63158, 35.10427], [-120.63174, 35.10472], [-120.63179, 35.10581], [-120.63205, 35.10756], [-120.63212, 35.10851], [-120.63217, 35.10986], [-120.63317, 35.11331], [-120.63347, 35.11513], [-120.63369, 35.11599], [-120.63401, 35.11748], [-120.63442, 35.11873], [-120.63483, 35.12005], [-120.63531, 35.12144], [-120.63593, 35.12374], [-120.63717, 35.1263], [-120.63852, 35.12885], [-120.64027, 35.13223], [-120.64144, 35.13437], [-120.64185, 35.13484], [-120.64219, 35.13564]]], [[[-120.62208, 35.132], [-120.62202, 35.13213], [-120.62196, 35.13244], [-120.62207, 35.13388], [-120.6192, 35.13331], [-120.61911, 35.13301], [-120.61906, 35.133], [-120.61948, 35.13212], [-120.62208, 35.132]]], [[[-120.63201, 35.13518], [-120.63107, 35.13566], [-120.63102, 35.13559], [-120.63181, 35.13519], [-120.63172, 35.13417], [-120.63119, 35.13348], [-120.62974, 35.13299], [-120.62787, 35.13396], [-120.62678, 35.13374], [-120.62647, 35.13478], [-120.62592, 35.13467], [-120.62586, 35.13484], [-120.62509, 35.13469], [-120.62441, 35.13472], [-120.62336, 35.13482], [-120.62244, 35.13469], [-120.62242, 35.13444], [-120.62292, 35.13441], [-120.62286, 35.13362], [-120.62236, 35.13364], [-120.62227, 35.13252], [-120.62246, 35.13211], [-120.62258, 35.13198], [-120.62294, 35.13196], [-120.62497, 35.13158], [-120.62561, 35.13136], [-120.62615, 35.13128], [-120.62708, 35.13151], [-120.62742, 35.13174], [-120.62811, 35.1315], [-120.62995, 35.13159], [-120.63078, 35.13172], [-120.63152, 35.13097], [-120.63165, 35.13096], [-120.63201, 35.13518]]], [[[-120.62623, 35.10638], [-120.62597, 35.10646], [-120.62594, 35.10634], [-120.62574, 35.10626], [-120.6255, 35.10593], [-120.62551, 35.10565], [-120.62595, 35.10521], [-120.62616, 35.10532], [-120.62596, 35.10558], [-120.62623, 35.10638]]], [[[-120.62747, 35.10476], [-120.62656, 35.10498], [-120.62633, 35.10515], [-120.62597, 35.10496], [-120.62642, 35.1044], [-120.62668, 35.10453], [-120.62737, 35.10427], [-120.62747, 35.10476]]], [[[-120.62842, 35.10627], [-120.62826, 35.10629], [-120.62821, 35.10604], [-120.62837, 35.10602], [-120.62842, 35.10627]]], [[[-120.62872, 35.10622], [-120.62862, 35.10624], [-120.62857, 35.10599], [-120.62867, 35.10598], [-120.62872, 35.10622]]], [[[-120.62987, 35.10636], [-120.62967, 35.10638], [-120.62962, 35.10614], [-120.62981, 35.10611], [-120.62987, 35.10636]]], [[[-120.65007, 35.14646], [-120.64977, 35.14693], [-120.64947, 35.1467], [-120.64898, 35.14667], [-120.64824, 35.14593], [-120.64784, 35.14532], [-120.64709, 35.14499], [-120.6465, 35.14465], [-120.64594, 35.14402], [-120.64543, 35.14302], [-120.64429, 35.14179], [-120.64435, 35.14158], [-120.64408, 35.14116], [-120.64343, 35.14047], [-120.64372, 35.14033], [-120.6436, 35.14], [-120.64376, 35.13978], [-120.6434, 35.13923], [-120.64307, 35.13928], [-120.64275, 35.1394], [-120.64212, 35.13882], [-120.64266, 35.13845], [-120.64188, 35.13713], [-120.64199, 35.13697], [-120.64182, 35.13684], [-120.64228, 35.13652], [-120.64262, 35.13623], [-120.64283, 35.13647], [-120.64323, 35.13748], [-120.64348, 35.13799], [-120.6438, 35.1385], [-120.64661, 35.13768], [-120.64669, 35.13779], [-120.64394, 35.13872], [-120.64393, 35.13873], [-120.64414, 35.13908], [-120.64499, 35.14036], [-120.64529, 35.14089], [-120.64538, 35.1412], [-120.64561, 35.14146], [-120.6459, 35.14187], [-120.64611, 35.14211], [-120.64692, 35.14319], [-120.64741, 35.14393], [-120.64793, 35.14446], [-120.6483, 35.14479], [-120.6486, 35.14513], [-120.64888, 35.14535], [-120.64912, 35.14563], [-120.64964, 35.14606], [-120.65007, 35.14646]]]]} | Open Access 1 | 18615 | Pismo State Beach | 1682 | 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=595 | San Luis Obispo 1 | 1512.609 | Pismo SB | 1935 | State Park 15 | 4 |
16498 | 16498 | 16497 | {"type": "MultiPolygon", "coordinates": [[[[-120.43403, 34.69057], [-120.43389, 34.6907], [-120.43303, 34.69033], [-120.43223, 34.68949], [-120.43118, 34.68789], [-120.43138, 34.68778], [-120.43349, 34.69047], [-120.43371, 34.69037], [-120.43403, 34.69057]]], [[[-120.44035, 34.67588], [-120.43968, 34.67611], [-120.43891, 34.67685], [-120.43845, 34.67726], [-120.43791, 34.67758], [-120.4376, 34.67796], [-120.43718, 34.67867], [-120.4368, 34.68001], [-120.43655, 34.68095], [-120.4366, 34.68267], [-120.43757, 34.68492], [-120.43115, 34.68491], [-120.43113, 34.68499], [-120.42936, 34.68499], [-120.42957, 34.68513], [-120.42631, 34.68519], [-120.42668, 34.68592], [-120.42874, 34.68767], [-120.42996, 34.68929], [-120.42983, 34.68933], [-120.42984, 34.68952], [-120.43034, 34.69026], [-120.4307, 34.69023], [-120.43044, 34.69043], [-120.43049, 34.69052], [-120.43138, 34.69041], [-120.43103, 34.69049], [-120.43075, 34.69061], [-120.43064, 34.69067], [-120.43091, 34.69104], [-120.43106, 34.69134], [-120.43118, 34.69181], [-120.43179, 34.69478], [-120.4319, 34.69507], [-120.4322, 34.69558], [-120.43229, 34.69589], [-120.43232, 34.69635], [-120.4323, 34.69649], [-120.43225, 34.69669], [-120.43217, 34.69687], [-120.43205, 34.69704], [-120.43191, 34.69718], [-120.43174, 34.6973], [-120.43096, 34.69768], [-120.43069, 34.69778], [-120.43055, 34.69781], [-120.42979, 34.69794], [-120.42958, 34.69796], [-120.42895, 34.69796], [-120.42859, 34.69798], [-120.42752, 34.69818], [-120.42726, 34.69825], [-120.42713, 34.6983], [-120.42686, 34.69845], [-120.4258, 34.6993], [-120.42564, 34.69946], [-120.42502, 34.69946], [-120.42406, 34.69965], [-120.42405, 34.69991], [-120.42396, 34.6999], [-120.42392, 34.69992], [-120.42388, 34.69995], [-120.42382, 34.69993], [-120.42272, 34.69994], [-120.42272, 34.70038], [-120.39921, 34.70039], [-120.40251, 34.69568], [-120.40399, 34.69363], [-120.40691, 34.68941], [-120.40782, 34.68806], [-120.40995, 34.68499], [-120.41023, 34.68478], [-120.41029, 34.6716], [-120.41454, 34.67164], [-120.4176, 34.66757], [-120.42104, 34.66887], [-120.42115, 34.66928], [-120.4214, 34.6694], [-120.42178, 34.66918], [-120.42782, 34.67136], [-120.42967, 34.67194], [-120.4314, 34.67223], [-120.43332, 34.67269], [-120.4347, 34.67312], [-120.43659, 34.67399], [-120.4403, 34.67524], [-120.44021, 34.67541], [-120.44035, 34.67588]], [[-120.42396, 34.69792], [-120.42396, 34.6979], [-120.42311, 34.69733], [-120.42278, 34.69769], [-120.42365, 34.69823], [-120.42396, 34.69792]]]]} | Open Access 1 | 17161 | La Purísima Mission State Historic Park | 28033 | 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=598 | Santa Barbara 7 | 1928.511 | La Purísima Mission SHP | 1935 | State Historic or Cultural Area 132 | 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]);