units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where DES_TP = 2, MNG_AG_TYP = 2 and YR_EST = 2018
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, LAYER, MNG_AG_ID
MNG_AGENCY 13
MNG_AG_TYP 1
- City Agency · 14 ✖
DES_TP 1
- Local Park · 14 ✖
ACCESS_TYP 1
- Open Access 14
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 |
497 | 497 | 496 | {"type": "Polygon", "coordinates": [[[-117.31082, 33.65409], [-117.31079, 33.65427], [-117.30502, 33.65344], [-117.30504, 33.65336], [-117.30568, 33.65345], [-117.30583, 33.65264], [-117.30709, 33.65186], [-117.30779, 33.65154], [-117.30788, 33.65166], [-117.30804, 33.65157], [-117.30845, 33.65132], [-117.30899, 33.65089], [-117.31082, 33.65409]]]} | Open Access 1 | 48360 | Summerly Community Park | 32925 | 1389 | Lake Elsinore, City of 187 | City 2 | City Agency 2 | http://www.lake-elsinore.org/index.aspx?page=202 | City 2 | 1389 | Lake Elsinore, City of 183 | City 2 | City Agency 2 | http://www.lake-elsinore.org/city-hall/community-services/parks-and-facilities/parks/summerly-park-2232#ad-image-3 | Riverside 10 | 24.134 | Summerly Community Park | 2018 | Local Park 2 | 4 |
1691 | 1691 | 1690 | {"type": "Polygon", "coordinates": [[[-118.80576, 34.14426], [-118.8047, 34.14528], [-118.80453, 34.14521], [-118.80449, 34.14517], [-118.80449, 34.14512], [-118.80453, 34.14505], [-118.80458, 34.14491], [-118.8046, 34.14475], [-118.80459, 34.14458], [-118.80453, 34.14442], [-118.80447, 34.14433], [-118.80433, 34.14417], [-118.80363, 34.14356], [-118.80351, 34.14348], [-118.80339, 34.14343], [-118.8035, 34.1432], [-118.80331, 34.14264], [-118.80264, 34.14255], [-118.80005, 34.14275], [-118.79893, 34.14304], [-118.79865, 34.14331], [-118.7987, 34.14355], [-118.7982, 34.14363], [-118.79819, 34.14374], [-118.79827, 34.14399], [-118.79828, 34.1443], [-118.79819, 34.14431], [-118.7982, 34.14496], [-118.79803, 34.14496], [-118.79803, 34.14247], [-118.7992, 34.14145], [-118.80462, 34.14143], [-118.8045, 34.14253], [-118.8046, 34.14314], [-118.80376, 34.14324], [-118.80375, 34.14354], [-118.80397, 34.14383], [-118.80444, 34.14425], [-118.80498, 34.14465], [-118.80511, 34.14463], [-118.80562, 34.14413], [-118.80567, 34.14419], [-118.80576, 34.14426]]]} | Open Access 1 | 12745 | Westlake Village City Parkland | 27404 | 1377 | Westlake Village, City of 321 | City 2 | City Agency 2 | http://www.wlv.org/index.aspx?nid=194 | City 2 | 1377 | Westlake Village, City of 318 | City 2 | City Agency 2 | Los Angeles 6 | 24.679 | Westlake Village City Parkland | 2018 | Local Park 2 | 4 | |
3100 | 3100 | 3099 | {"type": "Polygon", "coordinates": [[[-121.7493, 38.65674], [-121.7482, 38.65674], [-121.74816, 38.65671], [-121.74818, 38.65582], [-121.74873, 38.65584], [-121.7493, 38.65631], [-121.7493, 38.65674]]]} | Open Access 1 | 48688 | Spring Lake Park | 33427 | 1383 | Woodlake, City of 175 | City 2 | City Agency 2 | http://www.cityofwoodlake.com/ | City 2 | 1383 | Woodlake, City of 171 | City 2 | City Agency 2 | https://www.cityofwoodland.org/Facilities/Facility/Details/Spring-Lake-Park-23 | Yolo 33 | 2.116 | Spring Lake Park | 2018 | Local Park 2 | 4 |
4303 | 4303 | 4302 | {"type": "Polygon", "coordinates": [[[-117.74684, 34.02858], [-117.74645, 34.02859], [-117.74644, 34.02843], [-117.74684, 34.02842], [-117.74684, 34.02858]]]} | Open Access 1 | 48156 | Esperanza y Alegria Park | 32693 | 1258 | Pomona, City of 128 | City 2 | City Agency 2 | http://ci.pomona.ca.us/index.php/visitors/park-directory | City 2 | 1258 | Pomona, City of 125 | City 2 | City Agency 2 | Los Angeles 6 | 0.165 | Esperanza y Alegria Park | 2018 | Local Park 2 | 4 | |
5476 | 5476 | 5475 | {"type": "MultiPolygon", "coordinates": [[[[-121.20025, 38.80451], [-121.20011, 38.80463], [-121.19978, 38.80457], [-121.19988, 38.80436], [-121.19994, 38.80433], [-121.19999, 38.80435], [-121.20025, 38.80451]]], [[[-121.20098, 38.80218], [-121.20095, 38.80387], [-121.20031, 38.80445], [-121.20003, 38.80428], [-121.20002, 38.80423], [-121.2001, 38.80415], [-121.20041, 38.80395], [-121.20055, 38.80383], [-121.20068, 38.80368], [-121.20079, 38.80349], [-121.20086, 38.8033], [-121.2009, 38.8031], [-121.20093, 38.80218], [-121.20098, 38.80218]]]]} | Open Access 1 | 49032 | Christine Anderson Park | 33734 | 1280 | Rocklin, City of 577 | City 2 | City Agency 2 | http://www.rocklin.ca.us/depts/parksnrec/default.asp | City 2 | 1280 | Rocklin, City of 569 | City 2 | City Agency 2 | Placer 35 | 1.247 | Christine Anderson Park | 2018 | 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 |
7173 | 7173 | 7172 | {"type": "Polygon", "coordinates": [[[-121.68319, 37.99308], [-121.68317, 37.99514], [-121.6831, 37.99517], [-121.68169, 37.99516], [-121.68154, 37.99513], [-121.68139, 37.99508], [-121.68127, 37.99501], [-121.68116, 37.99491], [-121.68105, 37.99475], [-121.68102, 37.99462], [-121.68104, 37.99363], [-121.68108, 37.99345], [-121.68114, 37.99333], [-121.68123, 37.99324], [-121.68141, 37.99312], [-121.68156, 37.99307], [-121.68171, 37.99305], [-121.68312, 37.99305], [-121.68319, 37.99308]]]} | Open Access 1 | 48432 | Emerson Ranch Park | 33133 | 1229 | Oakley, City of 255 | City 2 | City Agency 2 | http://www.ci.oakley.ca.us/subpage.cfm?id=441408 | City 2 | 1229 | Oakley, City of 251 | City 2 | City Agency 2 | https://www.ci.oakley.ca.us/parks-and-landscape/park-and-landscape-capital-projects/ | Contra Costa 12 | 10.497 | Emerson Ranch Park | 2018 | Local Park 2 | 4 |
7300 | 7300 | 7299 | {"type": "Polygon", "coordinates": [[[-118.19815, 33.85938], [-118.19488, 33.86461], [-118.19471, 33.86483], [-118.19365, 33.86651], [-118.19195, 33.86924], [-118.1908, 33.86927], [-118.19254, 33.86619], [-118.19511, 33.86194], [-118.19574, 33.86094], [-118.19576, 33.86083], [-118.19594, 33.86053], [-118.1961, 33.86064], [-118.19622, 33.86063], [-118.19765, 33.85861], [-118.19767, 33.85857], [-118.19766, 33.85851], [-118.19785, 33.85833], [-118.19815, 33.85938]]]} | Open Access 1 | 6600 | DeForest Park | 18015 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 1184 | Long Beach, City of 294 | City 2 | City Agency 2 | Los Angeles 6 | 34.12 | DeForest Park | 2018 | Local Park 2 | 4 | |
7555 | 7555 | 7554 | {"type": "Polygon", "coordinates": [[[-117.02716, 32.57161], [-117.02625, 32.5719], [-117.02589, 32.5711], [-117.02577, 32.57094], [-117.02564, 32.57082], [-117.02547, 32.57071], [-117.02522, 32.5706], [-117.02501, 32.57054], [-117.02477, 32.57052], [-117.02459, 32.57053], [-117.02427, 32.5706], [-117.02399, 32.57074], [-117.02375, 32.57093], [-117.02269, 32.57021], [-117.02263, 32.56916], [-117.02312, 32.56929], [-117.0232, 32.5694], [-117.02325, 32.56944], [-117.02381, 32.56969], [-117.02395, 32.56992], [-117.02418, 32.56988], [-117.02471, 32.56986], [-117.02489, 32.56983], [-117.02503, 32.56978], [-117.02526, 32.56966], [-117.0254, 32.56956], [-117.02554, 32.56942], [-117.02626, 32.56929], [-117.02631, 32.56932], [-117.02656, 32.56937], [-117.02697, 32.56951], [-117.02698, 32.57062], [-117.02715, 32.57064], [-117.02716, 32.57161]]]} | Open Access 1 | 47618 | Cesar Solis Park | 31542 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | http://www.sandiego.gov/park-and-recreation/ | City 2 | 1297 | San Diego, City of 4 | City 2 | City Agency 2 | San Diego 4 | 15.465 | Cesar Solis Park | 2018 | Local Park 2 | 4 | |
9417 | 9417 | 9416 | {"type": "Polygon", "coordinates": [[[-118.18057, 33.81348], [-118.18057, 33.81362], [-118.18053, 33.8138], [-118.18, 33.81378], [-118.17999, 33.81348], [-118.18057, 33.81348]]]} | Open Access 1 | 47825 | Signal Hill Dog Park | 31767 | 1334 | Signal Hill, City of 371 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/index.aspx?nid=26 | City 2 | 1334 | Signal Hill, City of 366 | City 2 | City Agency 2 | http://www.cityofsignalhill.org/Facilities/Facility/Details/Signal-Hill-Dog-Park-27 | Los Angeles 6 | 0.441 | Signal Hill Dog Park | 2018 | Local Park 2 | 4 |
9634 | 9634 | 9633 | {"type": "Polygon", "coordinates": [[[-117.85212, 33.98947], [-117.85196, 33.98955], [-117.85182, 33.9896], [-117.85171, 33.98973], [-117.8516, 33.9899], [-117.85166, 33.99], [-117.85177, 33.99025], [-117.85212, 33.99036], [-117.85201, 33.99068], [-117.85197, 33.99071], [-117.85185, 33.99073], [-117.8518, 33.99078], [-117.85179, 33.99085], [-117.85186, 33.99093], [-117.85186, 33.99097], [-117.85184, 33.99102], [-117.8518, 33.99105], [-117.85106, 33.99068], [-117.85088, 33.99061], [-117.8507, 33.99056], [-117.85041, 33.99053], [-117.8496, 33.99057], [-117.84933, 33.99061], [-117.84932, 33.99034], [-117.84955, 33.99025], [-117.8496, 33.99], [-117.84997, 33.98961], [-117.85022, 33.98963], [-117.85052, 33.98959], [-117.85071, 33.9896], [-117.85108, 33.98948], [-117.85119, 33.98952], [-117.85127, 33.98953], [-117.85144, 33.98945], [-117.85182, 33.98949], [-117.85208, 33.98939], [-117.85212, 33.98947]]]} | Open Access 1 | 47852 | Larkstone Park | 31798 | 1085 | Diamond Bar, City of 315 | City 2 | City Agency 2 | http://www.ci.diamond-bar.ca.us/Index.aspx?page=939 | City 2 | 1085 | Diamond Bar, City of 312 | City 2 | City Agency 2 | https://www.diamondbarca.gov/Facilities/Facility/Details/Larkstone-Park-38 | Los Angeles 6 | 6.431 | Larkstone Park | 2018 | Local Park 2 | 4 |
11409 | 11409 | 11408 | {"type": "Polygon", "coordinates": [[[-122.35609, 37.93146], [-122.35606, 37.93145], [-122.35473, 37.93145], [-122.35472, 37.93152], [-122.35051, 37.93153], [-122.35051, 37.93113], [-122.35376, 37.93111], [-122.35377, 37.93086], [-122.35455, 37.93086], [-122.35456, 37.93111], [-122.35605, 37.93111], [-122.35609, 37.93146]]]} | Open Access 1 | 48093 | Unity Park | 32596 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/index.aspx?NID=2075 | City 2 | 1274 | Richmond, City of 20 | City 2 | City Agency 2 | http://www.ci.richmond.ca.us/3591/Unity-Park | Contra Costa 12 | 5.718 | Unity Park | 2018 | Local Park 2 | 4 |
11445 | 11445 | 11444 | {"type": "Polygon", "coordinates": [[[-118.70524, 34.03269], [-118.7051, 34.03271], [-118.705, 34.03281], [-118.70477, 34.03297], [-118.7047, 34.03306], [-118.70468, 34.03313], [-118.70472, 34.03338], [-118.70461, 34.03363], [-118.70448, 34.03372], [-118.70442, 34.03379], [-118.70438, 34.03389], [-118.70431, 34.03394], [-118.70414, 34.03411], [-118.70403, 34.03416], [-118.70399, 34.0342], [-118.70393, 34.0343], [-118.70398, 34.03454], [-118.70318, 34.03461], [-118.70322, 34.03458], [-118.70324, 34.03453], [-118.7032, 34.03412], [-118.70318, 34.03409], [-118.70314, 34.03406], [-118.70196, 34.03413], [-118.70185, 34.0341], [-118.70174, 34.03404], [-118.70166, 34.03395], [-118.70162, 34.03385], [-118.70158, 34.03349], [-118.70147, 34.03323], [-118.70161, 34.03318], [-118.70168, 34.03309], [-118.70175, 34.03306], [-118.70212, 34.03299], [-118.70313, 34.03263], [-118.70331, 34.03259], [-118.70355, 34.0327], [-118.70387, 34.0326], [-118.70399, 34.03258], [-118.70407, 34.03252], [-118.70413, 34.0325], [-118.70422, 34.03252], [-118.70428, 34.03261], [-118.70519, 34.03253], [-118.70524, 34.03269]]]} | Open Access 1 | 48112 | Malibu Bluffs Park | 32624 | 1193 | Malibu, City of 906 | City 2 | City Agency 2 | http://www.malibucity.org/Index.aspx?NID=335 | City 2 | 1193 | Malibu, City of 928 | City 2 | City Agency 2 | https://www.malibucity.org | Los Angeles 6 | 11.487 | Malibu Bluffs Park | 2018 | 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]);