units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
7 rows where ACCESS_TYP = 1, DES_TP = 2 and YR_EST = 1990
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1807 | 1807 | 1806 | {"type": "Polygon", "coordinates": [[[-121.90114, 37.3155], [-121.90116, 37.31561], [-121.90116, 37.31572], [-121.90114, 37.31582], [-121.9011, 37.31592], [-121.90019, 37.31569], [-121.90017, 37.31567], [-121.90019, 37.31565], [-121.90111, 37.31549], [-121.90114, 37.3155]]]} | Open Access 1 | 13708 | Palm Haven Plaza | 23339 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 0.563 | Palm Haven Plaza | 1990 | Local Park 2 | 4 | |
2548 | 2548 | 2547 | {"type": "Polygon", "coordinates": [[[-121.8958, 37.33096], [-121.89562, 37.33105], [-121.89566, 37.3311], [-121.89464, 37.33158], [-121.89428, 37.33112], [-121.89503, 37.33075], [-121.8948, 37.33045], [-121.89469, 37.33046], [-121.89439, 37.33005], [-121.8946, 37.32996], [-121.89524, 37.33065], [-121.89524, 37.33066], [-121.89578, 37.33083], [-121.89576, 37.33089], [-121.8958, 37.33096]]]} | Open Access 1 | 17797 | McEnery Park | 22028 | 1303 | San Jose, City of 33 | City 2 | City Agency 2 | http://www.sanjoseca.gov/index.aspx?NID=204 | City 2 | 1303 | San Jose, City of 32 | City 2 | City Agency 2 | Santa Clara 19 | 2.284 | McEnery Park | 1990 | Local Park 2 | 4 | |
2626 | 2626 | 2625 | {"type": "Polygon", "coordinates": [[[-122.51197, 38.34219], [-122.51196, 38.34225], [-122.51196, 38.34231], [-122.51135, 38.34242], [-122.51119, 38.34185], [-122.51136, 38.34182], [-122.51197, 38.34219]]]} | Open Access 1 | 18036 | Moran Goodman Park | 22470 | 328 | Sonoma County Regional Parks Dept., County of 193 | County 3 | County Agency - Parks 7 | http://parks.sonomacounty.ca.gov/ | County 3 | 328 | Sonoma County Regional Parks Dept., County of 189 | County 3 | County Agency - Parks 7 | Sonoma 16 | 0.652 | Moran Goodman Park | 1990 | Local Park 2 | 4 | |
6723 | 6723 | 6722 | {"type": "Polygon", "coordinates": [[[-121.94839, 37.80697], [-121.94726, 37.80857], [-121.94826, 37.80902], [-121.94773, 37.80924], [-121.94754, 37.80949], [-121.94725, 37.80958], [-121.94687, 37.80964], [-121.94661, 37.8095], [-121.94631, 37.80916], [-121.94594, 37.80897], [-121.94559, 37.80886], [-121.94517, 37.80893], [-121.94466, 37.80909], [-121.94434, 37.80913], [-121.94383, 37.80895], [-121.9439, 37.80869], [-121.94437, 37.80802], [-121.94444, 37.80804], [-121.94523, 37.80686], [-121.94514, 37.80604], [-121.94551, 37.80552], [-121.94684, 37.80612], [-121.94687, 37.8061], [-121.94839, 37.80697]]]} | Open Access 1 | 5039 | Sycamore Valley Park | 26143 | 1080 | Danville, Town of 473 | City 2 | City Agency 2 | http://www.danville.ca.gov/Things-To-Do/Parks/ | City 2 | 1080 | Danville, Town of 466 | City 2 | City Agency 2 | Contra Costa 12 | 24.657 | Sycamore Valley Park | 1990 | Local Park 2 | 4 | |
8877 | 8877 | 8876 | {"type": "Polygon", "coordinates": [[[-122.01681, 37.31623], [-122.0168, 37.31644], [-122.0164, 37.31668], [-122.01607, 37.31674], [-122.01577, 37.31726], [-122.01557, 37.31775], [-122.01363, 37.31777], [-122.01363, 37.31733], [-122.0137, 37.31732], [-122.01369, 37.31704], [-122.01379, 37.31703], [-122.01383, 37.31624], [-122.01498, 37.31627], [-122.01507, 37.31468], [-122.01624, 37.31472], [-122.0162, 37.31475], [-122.01625, 37.31503], [-122.01613, 37.31534], [-122.01612, 37.316], [-122.01639, 37.31618], [-122.01681, 37.31623]]]} | Open Access 1 | 14523 | Creekside Park | 17772 | 1076 | Cupertino, City of 195 | City 2 | City Agency 2 | http://www.cupertino.org/index.aspx?page=591 | City 2 | 1076 | Cupertino, City of 191 | City 2 | City Agency 2 | Santa Clara 19 | 12.968 | Creekside Park | 1990 | Local Park 2 | 4 | |
9039 | 9039 | 9038 | {"type": "Polygon", "coordinates": [[[-121.91743, 37.45308], [-121.91537, 37.4538], [-121.91434, 37.45191], [-121.91435, 37.45184], [-121.91443, 37.4518], [-121.91475, 37.45173], [-121.91489, 37.45166], [-121.91619, 37.45126], [-121.91627, 37.45129], [-121.9172, 37.45266], [-121.91743, 37.45308]]]} | Open Access 1 | 14959 | Dixon Landing Park | 18173 | 1206 | Milpitas, City of 417 | City 2 | City Agency 2 | http://www.ci.milpitas.ca.gov/ | City 2 | 1206 | Milpitas, City of 411 | City 2 | City Agency 2 | Santa Clara 19 | 11.085 | Dixon Landing Park | 1990 | Local Park 2 | 4 | |
16378 | 16378 | 16377 | {"type": "MultiPolygon", "coordinates": [[[[-121.91383, 37.63008], [-121.91366, 37.63042], [-121.9137, 37.63075], [-121.91379, 37.63098], [-121.91354, 37.63112], [-121.91333, 37.63143], [-121.91313, 37.63158], [-121.91304, 37.63163], [-121.91294, 37.63159], [-121.91284, 37.63159], [-121.91266, 37.63155], [-121.91251, 37.63183], [-121.91276, 37.63193], [-121.91279, 37.63249], [-121.90568, 37.63243], [-121.90561, 37.62965], [-121.90531, 37.62963], [-121.90463, 37.6289], [-121.90392, 37.62843], [-121.90318, 37.62834], [-121.90243, 37.62743], [-121.90203, 37.62725], [-121.90183, 37.62663], [-121.9018, 37.62627], [-121.90135, 37.62547], [-121.89168, 37.62759], [-121.88994, 37.62573], [-121.88976, 37.62267], [-121.88866, 37.62193], [-121.88474, 37.62325], [-121.88297, 37.6233], [-121.88309, 37.62218], [-121.88323, 37.61949], [-121.88308, 37.61864], [-121.88301, 37.6184], [-121.88241, 37.61696], [-121.88235, 37.61678], [-121.88231, 37.61651], [-121.8823, 37.61598], [-121.88224, 37.61568], [-121.88213, 37.61542], [-121.88085, 37.61318], [-121.88074, 37.61302], [-121.88059, 37.61285], [-121.88042, 37.61269], [-121.87958, 37.61211], [-121.87947, 37.61199], [-121.87937, 37.61186], [-121.8793, 37.61172], [-121.87926, 37.61157], [-121.87926, 37.61133], [-121.87922, 37.6111], [-121.87869, 37.60977], [-121.88339, 37.61082], [-121.88733, 37.61082], [-121.88803, 37.61151], [-121.88841, 37.61133], [-121.8879, 37.61081], [-121.88788, 37.61034], [-121.88723, 37.61044], [-121.88713, 37.61021], [-121.88682, 37.60978], [-121.88658, 37.60954], [-121.88612, 37.60925], [-121.88595, 37.60906], [-121.88577, 37.60931], [-121.88579, 37.60899], [-121.88598, 37.60855], [-121.88595, 37.60807], [-121.88498, 37.60717], [-121.88427, 37.60686], [-121.88352, 37.60614], [-121.88346, 37.60451], [-121.88265, 37.60411], [-121.88146, 37.60322], [-121.88146, 37.60279], [-121.88149, 37.60252], [-121.88206, 37.6025], [-121.88227, 37.60227], [-121.88271, 37.60213], [-121.88277, 37.60227], [-121.88295, 37.60239], [-121.88297, 37.60278], [-121.88361, 37.60309], [-121.88385, 37.60307], [-121.88423, 37.60286], [-121.88443, 37.60243], [-121.88552, 37.60242], [-121.88618, 37.60099], [-121.88623, 37.60001], [-121.88638, 37.6], [-121.88646, 37.59975], [-121.8866, 37.59937], [-121.88674, 37.59851], [-121.88674, 37.59797], [-121.88731, 37.59796], [-121.88727, 37.59707], [-121.88865, 37.59703], [-121.88868, 37.59693], [-121.88856, 37.5966], [-121.88822, 37.59613], [-121.88793, 37.59588], [-121.88788, 37.59574], [-121.88796, 37.59559], [-121.88811, 37.59515], [-121.88789, 37.59484], [-121.88825, 37.59466], [-121.88817, 37.59478], [-121.88818, 37.59497], [-121.88825, 37.59506], [-121.88828, 37.59514], [-121.88826, 37.59524], [-121.88821, 37.59531], [-121.88823, 37.59554], [-121.88871, 37.59575], [-121.88909, 37.59615], [-121.88917, 37.59643], [-121.88939, 37.59669], [-121.8895, 37.59691], [-121.88947, 37.59702], [-121.88963, 37.5974], [-121.8896, 37.59752], [-121.88945, 37.59762], [-121.88938, 37.59778], [-121.8891, 37.59801], [-121.88904, 37.59841], [-121.88906, 37.59873], [-121.88886, 37.59925], [-121.88894, 37.59987], [-121.88893, 37.60001], [-121.88805, 37.60002], [-121.88792, 37.60026], [-121.88801, 37.60143], [-121.88782, 37.60154], [-121.88733, 37.60196], [-121.88706, 37.60259], [-121.88683, 37.60285], [-121.88684, 37.60337], [-121.88686, 37.60338], [-121.88817, 37.60337], [-121.88849, 37.60335], [-121.88878, 37.60322], [-121.88878, 37.60342], [-121.88871, 37.60346], [-121.88863, 37.6036], [-121.88865, 37.60375], [-121.88836, 37.60404], [-121.88817, 37.60457], [-121.88822, 37.60521], [-121.88832, 37.60538], [-121.88908, 37.6055], [-121.88925, 37.60557], [-121.88939, 37.60572], [-121.88972, 37.60599], [-121.88978, 37.60623], [-121.88986, 37.60631], [-121.89064, 37.60636], [-121.89078, 37.60648], [-121.8909, 37.60719], [-121.89086, 37.60736], [-121.89216, 37.60711], [-121.89232, 37.60728], [-121.89235, 37.60792], [-121.89266, 37.60846], [-121.89328, 37.60924], [-121.89355, 37.60971], [-121.89431, 37.61067], [-121.89597, 37.61317], [-121.89641, 37.61386], [-121.89658, 37.61425], [-121.8966, 37.61462], [-121.89654, 37.61531], [-121.89615, 37.61549], [-121.89617, 37.61556], [-121.89609, 37.6157], [-121.89608, 37.61582], [-121.89597, 37.61594], [-121.89618, 37.61619], [-121.89704, 37.61665], [-121.89817, 37.61714], [-121.89928, 37.61778], [-121.89952, 37.61808], [-121.89981, 37.6185], [-121.90054, 37.61926], [-121.90163, 37.62097], [-121.90187, 37.62142], [-121.90232, 37.62188], [-121.90326, 37.62261], [-121.905, 37.6241], [-121.9073, 37.62567], [-121.90947, 37.62619], [-121.90914, 37.62464], [-121.90956, 37.6251], [-121.90991, 37.62545], [-121.91017, 37.62588], [-121.91053, 37.62605], [-121.91069, 37.62626], [-121.91091, 37.62666], [-121.91116, 37.62731], [-121.91155, 37.62782], [-121.91169, 37.62812], [-121.91197, 37.62848], [-121.91253, 37.62878], [-121.91301, 37.62889], [-121.91329, 37.62917], [-121.91342, 37.62947], [-121.91378, 37.63008], [-121.91383, 37.63008]], [[-121.89071, 37.61004], [-121.89071, 37.61003], [-121.89034, 37.60956], [-121.8897, 37.60988], [-121.88914, 37.60917], [-121.88834, 37.6093], [-121.88865, 37.61092], [-121.88968, 37.61078], [-121.89014, 37.61051], [-121.89002, 37.61034], [-121.89036, 37.61016], [-121.89071, 37.61004]], [[-121.88862, 37.59581], [-121.88822, 37.59564], [-121.88804, 37.59572], [-121.8882, 37.59595], [-121.8885, 37.59629], [-121.88889, 37.59612], [-121.88862, 37.59581]]], [[[-121.98818, 37.66549], [-121.98777, 37.66571], [-121.98777, 37.67304], [-121.97868, 37.67325], [-121.97868, 37.67619], [-121.96889, 37.67627], [-121.96896, 37.68033], [-121.95945, 37.68039], [-121.95945, 37.6798], [-121.95944, 37.67979], [-121.95128, 37.68015], [-121.95002, 37.6729], [-121.93614, 37.673], [-121.93598, 37.66196], [-121.93179, 37.66198], [-121.93177, 37.66107], [-121.92747, 37.66105], [-121.92748, 37.65743], [-121.92498, 37.65741], [-121.92486, 37.65726], [-121.92434, 37.65676], [-121.92422, 37.65662], [-121.92357, 37.65532], [-121.92352, 37.65517], [-121.92349, 37.655], [-121.92343, 37.65423], [-121.92338, 37.65406], [-121.92329, 37.65388], [-121.92749, 37.65387], [-121.92749, 37.65025], [-121.91472, 37.65025], [-121.91478, 37.64353], [-121.91483, 37.63603], [-121.92155, 37.63602], [-121.931, 37.63583], [-121.93119, 37.642], [-121.94045, 37.64189], [-121.94046, 37.64188], [-121.94035, 37.63646], [-121.94946, 37.63636], [-121.9501, 37.63465], [-121.95125, 37.63447], [-121.95208, 37.63445], [-121.95248, 37.63458], [-121.9531, 37.63553], [-121.95432, 37.63554], [-121.95438, 37.63567], [-121.9545, 37.63583], [-121.95463, 37.63593], [-121.95484, 37.63603], [-121.95492, 37.63605], [-121.95623, 37.63613], [-121.94947, 37.63636], [-121.94964, 37.64359], [-121.9405, 37.6437], [-121.94049, 37.65094], [-121.94982, 37.65085], [-121.9498, 37.65305], [-121.95038, 37.65531], [-121.95271, 37.65649], [-121.9549, 37.65835], [-121.95545, 37.65983], [-121.95777, 37.65947], [-121.95923, 37.66043], [-121.96318, 37.66293], [-121.96736, 37.66484], [-121.9672, 37.6657], [-121.96866, 37.66571], [-121.98818, 37.66549]], [[-121.93349, 37.6583], [-121.9332, 37.65804], [-121.93176, 37.65904], [-121.93176, 37.65947], [-121.93296, 37.66056], [-121.93464, 37.65938], [-121.93349, 37.6583]], [[-121.94493, 37.63821], [-121.94275, 37.63824], [-121.94278, 37.64006], [-121.94497, 37.64004], [-121.94493, 37.63821]]]]} | Open Access 1 | 18778 | Pleasanton Ridge Regional Park | 3301 | 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/pleasanton | Alameda 17 | 4114.243 | Pleasanton Ridge RP | 1990 | 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]);