units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
16 rows where DES_TP = 2, MNG_AGENCY = 160 and MNG_AG_LEV = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
MNG_AG_TYP 1
- City Agency 16
MNG_AGENCY 1
- Dublin, City of · 16 ✖
DES_TP 1
- Local Park · 16 ✖
ACCESS_TYP 1
- Open Access 16
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
409 | 409 | 408 | {"type": "Polygon", "coordinates": [[[-121.84613, 37.71921], [-121.8461, 37.71922], [-121.84608, 37.71928], [-121.84603, 37.71931], [-121.84534, 37.71946], [-121.84486, 37.71953], [-121.84439, 37.71957], [-121.84435, 37.71956], [-121.84433, 37.71954], [-121.8443, 37.71954], [-121.84428, 37.71905], [-121.84432, 37.71882], [-121.84438, 37.7186], [-121.84448, 37.71838], [-121.84461, 37.71818], [-121.84485, 37.7179], [-121.84492, 37.71786], [-121.84498, 37.71786], [-121.84503, 37.71789], [-121.84529, 37.7181], [-121.84554, 37.71833], [-121.84584, 37.71871], [-121.84599, 37.71894], [-121.84613, 37.71921]]]} | Open Access 1 | 48353 | Sean Diamond Park | 32917 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Sean-Diamond-Park-33 | Alameda 17 | 4.986 | Sean Diamond Park | 2018 | Local Park 2 | 4 |
4334 | 4334 | 4333 | {"type": "Polygon", "coordinates": [[[-121.86081, 37.71062], [-121.86088, 37.71077], [-121.86094, 37.71101], [-121.86113, 37.71243], [-121.86113, 37.71247], [-121.8611, 37.7125], [-121.86104, 37.71252], [-121.86002, 37.71261], [-121.85976, 37.71089], [-121.86027, 37.71075], [-121.86054, 37.71074], [-121.86081, 37.71062]]]} | Open Access 1 | 48349 | Passatempo Park | 32913 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Passatempo-Park-26 | Alameda 17 | 5.009 | Passatempo Park | 2014 | Local Park 2 | 4 |
4950 | 4950 | 4949 | {"type": "Polygon", "coordinates": [[[-121.91933, 37.72006], [-121.91912, 37.72042], [-121.91902, 37.7204], [-121.91864, 37.7204], [-121.9186, 37.72038], [-121.91857, 37.72035], [-121.9185, 37.72003], [-121.91854, 37.71997], [-121.91894, 37.7199], [-121.91902, 37.71972], [-121.91933, 37.72006]]]} | Open Access 1 | 14772 | Stagecoach Park | 25779 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 0.874 | Stagecoach Park | 1987 | Local Park 2 | 4 | |
6153 | 6153 | 6152 | {"type": "Polygon", "coordinates": [[[-121.86676, 37.70743], [-121.86653, 37.7078], [-121.8664, 37.70811], [-121.86632, 37.70815], [-121.86593, 37.70808], [-121.86559, 37.708], [-121.86596, 37.70704], [-121.86674, 37.70736], [-121.86676, 37.70743]]]} | Open Access 1 | 48343 | Devany Square | 32908 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Devany-Square-5 | Alameda 17 | 1.909 | Devany Square | 0 | Local Park 2 | 4 |
6163 | 6163 | 6162 | {"type": "Polygon", "coordinates": [[[-121.91583, 37.71712], [-121.91583, 37.71717], [-121.91558, 37.71739], [-121.91553, 37.71748], [-121.91554, 37.7176], [-121.91524, 37.71776], [-121.91516, 37.71766], [-121.91505, 37.71765], [-121.91499, 37.71767], [-121.91457, 37.71782], [-121.9139, 37.71815], [-121.9137, 37.71795], [-121.91534, 37.717], [-121.91553, 37.71722], [-121.9158, 37.71708], [-121.91583, 37.71712]]]} | Open Access 1 | 48345 | Dougherty Hills Dog Park | 32909 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Dougherty-Hills-Dog-Park-1 | Alameda 17 | 1.936 | Dougherty Hills Dog Park | 0 | Local Park 2 | 4 |
6187 | 6187 | 6186 | {"type": "Polygon", "coordinates": [[[-121.84712, 37.7135], [-121.84714, 37.71357], [-121.8472, 37.71362], [-121.84726, 37.71372], [-121.84732, 37.71388], [-121.84734, 37.71403], [-121.84733, 37.71419], [-121.84728, 37.71435], [-121.8472, 37.71449], [-121.84701, 37.71468], [-121.84686, 37.71478], [-121.84668, 37.71486], [-121.84649, 37.71491], [-121.84569, 37.71507], [-121.84554, 37.71508], [-121.84533, 37.71505], [-121.8452, 37.71499], [-121.84505, 37.71487], [-121.84496, 37.71472], [-121.84487, 37.71469], [-121.84546, 37.71433], [-121.84589, 37.71411], [-121.84639, 37.7139], [-121.8468, 37.71366], [-121.84707, 37.71355], [-121.84712, 37.7135]]]} | Open Access 1 | 48348 | Jordan Ranch Park | 32912 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://ca-dublin2.civicplus.com/Facilities/Facility/Details/Jordan-Ranch-Park-31 | Alameda 17 | 4.982 | Jordan Ranch Park | 2018 | Local Park 2 | 4 |
6203 | 6203 | 6202 | {"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.7053], [-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.70501], [-121.98238, 37.70468], [-121.98253, 37.70448], [-121.98263, 37.70445], [-121.98307, 37.7046], [-121.98312, 37.70463], [-121.98315, 37.7047], [-121.98321, 37.70474]]]]} | Open Access 1 | 48352 | Schaefer Ranch Park | 32916 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Schaefer-Ranch-Park-29 | Alameda 17 | 10.535 | Schaefer Ranch Park | 2013 | Local Park 2 | 4 |
6498 | 6498 | 6497 | {"type": "Polygon", "coordinates": [[[-121.91244, 37.72476], [-121.91228, 37.72487], [-121.91216, 37.725], [-121.91208, 37.72511], [-121.91207, 37.72511], [-121.91204, 37.72515], [-121.91199, 37.72517], [-121.91154, 37.72512], [-121.91121, 37.72513], [-121.91087, 37.72517], [-121.90977, 37.72536], [-121.90971, 37.72531], [-121.90964, 37.72491], [-121.90963, 37.72473], [-121.90964, 37.72424], [-121.90969, 37.72396], [-121.90972, 37.72393], [-121.90977, 37.72391], [-121.91003, 37.72393], [-121.91017, 37.72391], [-121.91081, 37.72373], [-121.91134, 37.72367], [-121.91145, 37.72364], [-121.91155, 37.72359], [-121.91245, 37.72467], [-121.91246, 37.72471], [-121.91244, 37.72476]]]} | Open Access 1 | 2370 | Alamo Creek Park | 32907 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Alamo-Creek-Park-2 | Alameda 17 | 8.535 | Alamo Creek Park | 2000 | Local Park 2 | 4 |
8331 | 8331 | 8330 | {"type": "Polygon", "coordinates": [[[-121.94729, 37.71388], [-121.9468, 37.71415], [-121.94663, 37.71434], [-121.94632, 37.71456], [-121.94606, 37.7144], [-121.94573, 37.71423], [-121.9455, 37.71414], [-121.94608, 37.71266], [-121.94656, 37.71266], [-121.9468, 37.71261], [-121.94691, 37.71283], [-121.94696, 37.71336], [-121.94711, 37.71367], [-121.94729, 37.71388]]]} | Open Access 1 | 14763 | Dolan Park | 18189 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 5.045 | Dolan Park | 1991 | Local Park 2 | 4 | |
8953 | 8953 | 8952 | {"type": "Polygon", "coordinates": [[[-121.86537, 37.71837], [-121.86517, 37.71877], [-121.86507, 37.71907], [-121.86504, 37.71928], [-121.86503, 37.71946], [-121.86506, 37.71965], [-121.86511, 37.71986], [-121.86506, 37.71994], [-121.86481, 37.72], [-121.86443, 37.72003], [-121.86361, 37.72017], [-121.8634, 37.72016], [-121.8632, 37.72009], [-121.8634, 37.71986], [-121.86372, 37.71907], [-121.86399, 37.718], [-121.86455, 37.71809], [-121.86499, 37.71819], [-121.86534, 37.7183], [-121.86537, 37.71837]]]} | Open Access 1 | 14750 | Ted Fairfield Park | 26213 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 6.963 | Ted Fairfield Park | 2001 | Local Park 2 | 4 | |
8959 | 8959 | 8958 | {"type": "Polygon", "coordinates": [[[-121.87932, 37.71033], [-121.87889, 37.71066], [-121.87865, 37.71097], [-121.8787, 37.71169], [-121.87816, 37.7125], [-121.87229, 37.71242], [-121.87235, 37.70994], [-121.87327, 37.70992], [-121.87444, 37.7098], [-121.87538, 37.70957], [-121.87712, 37.70894], [-121.87827, 37.70876], [-121.87927, 37.70879], [-121.87941, 37.70991], [-121.87932, 37.71033]]]} | Open Access 1 | 14758 | Emerald Glen Park | 18614 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 49.118 | Emerald Glen Park | 1998 | Local Park 2 | 4 | |
8960 | 8960 | 8959 | {"type": "Polygon", "coordinates": [[[-121.94067, 37.70622], [-121.94044, 37.70636], [-121.94035, 37.70633], [-121.94028, 37.70635], [-121.94023, 37.70639], [-121.94018, 37.70647], [-121.93972, 37.70674], [-121.93963, 37.70675], [-121.93956, 37.70678], [-121.93952, 37.70683], [-121.93952, 37.70689], [-121.93956, 37.70694], [-121.93962, 37.70697], [-121.93934, 37.70714], [-121.93868, 37.70659], [-121.93886, 37.70636], [-121.93929, 37.70629], [-121.93966, 37.70613], [-121.94005, 37.70574], [-121.94032, 37.70592], [-121.94067, 37.70622]]]} | Open Access 1 | 14761 | Mape Memorial Park | 21771 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 2.689 | Mape Memorial Park | 1989 | Local Park 2 | 4 | |
8961 | 8961 | 8960 | {"type": "Polygon", "coordinates": [[[-121.94244, 37.71367], [-121.94238, 37.71516], [-121.94234, 37.7153], [-121.94227, 37.7154], [-121.94044, 37.71574], [-121.93989, 37.71397], [-121.93993, 37.71391], [-121.93999, 37.71389], [-121.94021, 37.71386], [-121.94088, 37.7139], [-121.94126, 37.71387], [-121.94204, 37.71368], [-121.94244, 37.71367]]]} | Open Access 1 | 14766 | Shannon Park | 25359 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 9.623 | Shannon Park | 1989 | Local Park 2 | 4 | |
8962 | 8962 | 8961 | {"type": "Polygon", "coordinates": [[[-121.93035, 37.71917], [-121.92902, 37.71877], [-121.92908, 37.71833], [-121.92945, 37.71835], [-121.92962, 37.71701], [-121.92978, 37.717], [-121.93053, 37.71779], [-121.93059, 37.71795], [-121.93052, 37.71871], [-121.93035, 37.71917]]]} | Open Access 1 | 14769 | Kolb Park | 20715 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 4.793 | Kolb Park | 1989 | Local Park 2 | 4 | |
14276 | 14276 | 14275 | {"type": "Polygon", "coordinates": [[[-121.8621, 37.70646], [-121.86208, 37.70653], [-121.86183, 37.70671], [-121.86144, 37.70709], [-121.86133, 37.70717], [-121.86114, 37.70727], [-121.86087, 37.70735], [-121.86059, 37.70738], [-121.86024, 37.70734], [-121.86018, 37.70728], [-121.8602, 37.70708], [-121.86021, 37.70671], [-121.86019, 37.70645], [-121.86014, 37.7062], [-121.86019, 37.70614], [-121.86096, 37.706], [-121.86117, 37.70599], [-121.86136, 37.70601], [-121.8616, 37.70608], [-121.86177, 37.70616], [-121.86196, 37.7063], [-121.8621, 37.70646]]]} | Open Access 1 | 44202 | Bray Commons Park | 16337 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | Alameda 17 | 4.762 | Bray Commons Park | 0 | Local Park 2 | 4 | |
14923 | 14923 | 14922 | {"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.84491, 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 | 48351 | Positano Hills Park | 32915 | 1090 | Dublin, City of 164 | City 2 | City Agency 2 | http://www.ci.dublin.ca.us/index.aspx?nid=1458 | City 2 | 1090 | Dublin, City of 160 | City 2 | City Agency 2 | https://www.dublin.ca.gov/Facilities/Facility/Details/Positano-Hills-Park-24 | Alameda 17 | 4.593 | Positano Hills Park | 2013 | 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]);