units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
9,084 rows where ACCESS_TYP = 1 and DES_TP = 2 sorted by UNIT_ID descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5409 | 5409 | 5408 | {"type": "Polygon", "coordinates": [[[-122.70929, 38.32421], [-122.70932, 38.32439], [-122.70925, 38.32488], [-122.70801, 38.32535], [-122.70789, 38.32522], [-122.70819, 38.32474], [-122.70777, 38.32462], [-122.70797, 38.32381], [-122.70929, 38.32421]]]} | Open Access 1 | 49080 | Falleti Ranch | 33781 | 1072 | Cotati, City of 356 | City 2 | City Agency 2 | http://www.ci.cotati.ca.us/ | City 2 | 1072 | Cotati, City of 353 | City 2 | City Agency 2 | Sonoma 16 | 3.618 | Falleti Ranch | 0 | Local Park 2 | 4 | |
10074 | 10074 | 10073 | {"type": "Polygon", "coordinates": [[[-121.26493, 38.83074], [-121.26429, 38.83085], [-121.26318, 38.83041], [-121.26364, 38.82968], [-121.26371, 38.82953], [-121.26376, 38.8292], [-121.26378, 38.82917], [-121.26384, 38.82915], [-121.26484, 38.82927], [-121.2648, 38.82959], [-121.2648, 38.83], [-121.26485, 38.8304], [-121.26493, 38.83074]]]} | Open Access 1 | 49036 | Willard Park | 33743 | 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 | 4.813 | Willard Park | 2019 | Local Park 2 | 4 | |
10073 | 10073 | 10072 | {"type": "Polygon", "coordinates": [[[-121.28222, 38.81572], [-121.28171, 38.81595], [-121.28168, 38.81588], [-121.28158, 38.8158], [-121.28132, 38.81542], [-121.28105, 38.81507], [-121.28097, 38.81499], [-121.28084, 38.81488], [-121.2808, 38.81481], [-121.28072, 38.81477], [-121.28065, 38.81477], [-121.28057, 38.81481], [-121.28053, 38.81488], [-121.28047, 38.81488], [-121.28041, 38.8148], [-121.28124, 38.81442], [-121.28222, 38.81572]]]} | Open Access 1 | 49035 | Wickman Park | 33742 | 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 | 2.226 | Wickman Park | 2017 | 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 | |
10053 | 10053 | 10052 | {"type": "Polygon", "coordinates": [[[-121.23986, 38.78689], [-121.23937, 38.78755], [-121.23887, 38.78744], [-121.23925, 38.78697], [-121.23913, 38.7869], [-121.23934, 38.78663], [-121.23986, 38.78689]]]} | Open Access 1 | 49028 | Deer Creek Park | 33729 | 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.051 | Deer Creek Park | 0 | Local Park 2 | 4 | |
10048 | 10048 | 10047 | {"type": "Polygon", "coordinates": [[[-121.2703, 38.83454], [-121.26942, 38.8347], [-121.26937, 38.83469], [-121.26934, 38.83466], [-121.26929, 38.83449], [-121.26927, 38.83431], [-121.26928, 38.83413], [-121.26933, 38.83395], [-121.26946, 38.83369], [-121.26958, 38.83354], [-121.26973, 38.8334], [-121.26991, 38.83353], [-121.27003, 38.83373], [-121.26979, 38.8341], [-121.26993, 38.83424], [-121.26995, 38.83444], [-121.27029, 38.8345], [-121.2703, 38.83454]]]} | Open Access 1 | 49026 | Pernu Park | 33727 | 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.676 | Pernu Park | 0 | Local Park 2 | 4 | |
10047 | 10047 | 10046 | {"type": "Polygon", "coordinates": [[[-120.81909, 39.02277], [-120.81495, 39.02381], [-120.81432, 39.02209], [-120.81557, 39.02184], [-120.81585, 39.02263], [-120.81674, 39.02246], [-120.81675, 39.02244], [-120.81647, 39.02165], [-120.81844, 39.02125], [-120.81899, 39.02269], [-120.81909, 39.02277]]]} | Open Access 1 | 49024 | Foresthill Leroy E. Botts Memorial Park | 33725 | 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 | https://www.placer.ca.gov/6000/Foresthill-Leroy-E-Botts-Memorial-Park | Placer 35 | 15.352 | Foresthill Leroy E. Botts Memorial Park | 0 | Local Park 2 | 4 |
10043 | 10043 | 10042 | {"type": "Polygon", "coordinates": [[[-121.09452, 38.93839], [-121.09416, 38.93839], [-121.09416, 38.93785], [-121.09452, 38.93839], [-121.09452, 38.93839]]]} | Open Access 1 | 49023 | Auburn Plaza Park | 33724 | 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 | https://www.placer.ca.gov/6005/Plaza-Park | Placer 35 | 0.231 | Auburn Plaza Park | 0 | Local Park 2 | 4 |
9402 | 9402 | 9401 | {"type": "Polygon", "coordinates": [[[-123.4405, 39.05938], [-123.44049, 39.05965], [-123.44041, 39.05975], [-123.44021, 39.05983], [-123.43997, 39.0601], [-123.43987, 39.06018], [-123.43962, 39.06044], [-123.4395, 39.06053], [-123.43949, 39.06058], [-123.4393, 39.06079], [-123.43906, 39.06087], [-123.43892, 39.06095], [-123.43876, 39.06095], [-123.43795, 39.06072], [-123.43766, 39.0607], [-123.4375, 39.06076], [-123.43727, 39.06098], [-123.43715, 39.06109], [-123.43686, 39.06123], [-123.43655, 39.06093], [-123.43605, 39.06052], [-123.43589, 39.0604], [-123.43528, 39.06002], [-123.43639, 39.05958], [-123.43805, 39.05866], [-123.4405, 39.05938]]]} | Open Access 1 | 49017 | Indian Creek County Park | 33715 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/indian-creek | Mendocino 24 | 17.437 | Indian Creek County Park | 1973 | Local Park 2 | 4 |
15380 | 15380 | 15379 | {"type": "Polygon", "coordinates": [[[-123.4074, 39.00408], [-123.40742, 39.00624], [-123.40739, 39.00777], [-123.40276, 39.00769], [-123.40285, 39.004], [-123.4074, 39.00408]]]} | Open Access 1 | 49011 | Faulkner Park | 33709 | 352 | Mendocino, County of 620 | County 3 | County Agency 3 | http://www.co.mendocino.ca.us/gs/parks/ | County 3 | 352 | Mendocino, County of 609 | County 3 | County Agency 3 | https://www.mendocinocounty.org/government/cultural-services-agency/parks/faulkner-park | Mendocino 24 | 40.36 | Faulkner Park | 1930 | Local Park 2 | 4 |
9247 | 9247 | 9246 | {"type": "Polygon", "coordinates": [[[-121.11612, 38.79796], [-121.116, 38.79929], [-121.11489, 38.79929], [-121.11488, 38.79914], [-121.11491, 38.79901], [-121.11497, 38.79887], [-121.11506, 38.79875], [-121.11524, 38.7986], [-121.11568, 38.79837], [-121.11582, 38.79828], [-121.11599, 38.79813], [-121.11612, 38.79796]]]} | Open Access 1 | 49009 | Sterling Pointe Park | 33705 | 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 | Placer 35 | 2.222 | Sterling Pointe Park | 0 | Local Park 2 | 4 | |
4905 | 4905 | 4904 | {"type": "Polygon", "coordinates": [[[-118.93429, 34.23097], [-118.93156, 34.2316], [-118.93117, 34.23166], [-118.93075, 34.23168], [-118.93077, 34.2258], [-118.93428, 34.22579], [-118.93429, 34.23097]]]} | Open Access 1 | 49004 | Santa Rosa Valley Park | 33703 | 331 | Ventura, County of 202 | County 3 | County Agency 3 | http://www.ventura.org/general-services-agency/parks-department | County 3 | 331 | Ventura, County of 198 | County 3 | County Agency 3 | Ventura 8 | 49.627 | Santa Rosa Valley Park | 0 | Local Park 2 | 4 | |
1725 | 1725 | 1724 | {"type": "Polygon", "coordinates": [[[-121.19542, 38.82059], [-121.19429, 38.82183], [-121.19403, 38.82168], [-121.19516, 38.82045], [-121.19542, 38.82059]]]} | Open Access 1 | 49001 | Blue Anchor Park | 33700 | 1354 | Loomis, Town of 415 | City 2 | City Agency 2 | http://www.loomis.ca.gov/ | City 2 | 1354 | Loomis, Town of 409 | City 2 | City Agency 2 | https://loomis.ca.gov/how-do-i/find-2/parks-recreation/ | Placer 35 | 1.147 | Blue Anchor Park | 0 | Local Park 2 | 4 |
4449 | 4449 | 4448 | {"type": "Polygon", "coordinates": [[[-121.17178, 38.78981], [-121.1705, 38.79009], [-121.17044, 38.79009], [-121.17038, 38.79007], [-121.17033, 38.79002], [-121.1699, 38.7888], [-121.17148, 38.78877], [-121.17178, 38.78981]]]} | Open Access 1 | 49000 | Franklin Community School Park | 33699 | 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 | https://www.placer.ca.gov/6045/Franklin-Community-School-Park | Placer 35 | 4.349 | Franklin Community School Park | 0 | Local Park 2 | 4 |
9097 | 9097 | 9096 | {"type": "Polygon", "coordinates": [[[-121.03287, 38.97744], [-121.03214, 38.97744], [-121.03101, 38.97718], [-121.03108, 38.97711], [-121.03122, 38.97706], [-121.03127, 38.977], [-121.03128, 38.97694], [-121.03126, 38.97689], [-121.03121, 38.97685], [-121.03115, 38.97682], [-121.03105, 38.97682], [-121.03096, 38.97687], [-121.03093, 38.97693], [-121.03092, 38.97703], [-121.03083, 38.97715], [-121.03012, 38.97682], [-121.03039, 38.9766], [-121.03059, 38.97629], [-121.03071, 38.97617], [-121.03115, 38.97583], [-121.03148, 38.97573], [-121.03189, 38.97565], [-121.03249, 38.97552], [-121.03272, 38.97551], [-121.03268, 38.97718], [-121.03287, 38.97718], [-121.03287, 38.97744]]]} | Open Access 1 | 48994 | Sugarpine Ridge Park | 33690 | 2004 | Auburn Area Recreation and Park District 700 | Special District 4 | Recreation/Parks District 4 | http://auburnrec.com/ | Special District 4 | 2004 | Auburn Area Recreation and Park District 447 | Special District 4 | Recreation/Parks District 4 | http://www.auburnrec.com/parks_sugarpine.php | Placer 35 | 8.053 | Sugarpine Ridge Park | 0 | Local Park 2 | 4 |
1432 | 1432 | 1431 | {"type": "Polygon", "coordinates": [[[-121.88594, 37.31445], [-121.88536, 37.31483], [-121.88518, 37.31455], [-121.88449, 37.31485], [-121.88433, 37.31463], [-121.88552, 37.31397], [-121.88594, 37.31445]]]} | Open Access 1 | 48980 | Tamien Park | 33676 | 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 | https://www.mercurynews.com/2017/06/21/tamien-park-opens-after-22-years-of-planning/ | Santa Clara 19 | 1.588 | Tamien Park | 2017 | Local Park 2 | 4 |
16331 | 16331 | 16330 | {"type": "MultiPolygon", "coordinates": [[[[-119.24297, 36.33127], [-119.24195, 36.33139], [-119.23951, 36.33153], [-119.23811, 36.33164], [-119.2372, 36.33193], [-119.23691, 36.33215], [-119.2366, 36.33228], [-119.23591, 36.33246], [-119.23541, 36.33252], [-119.23479, 36.3325], [-119.23421, 36.33281], [-119.23394, 36.33292], [-119.23392, 36.33213], [-119.23394, 36.33086], [-119.23399, 36.33085], [-119.23391, 36.32725], [-119.23517, 36.32722], [-119.23546, 36.32724], [-119.23575, 36.32727], [-119.23603, 36.32734], [-119.2363, 36.32742], [-119.23655, 36.32753], [-119.2369, 36.32772], [-119.23721, 36.32796], [-119.23841, 36.32919], [-119.23856, 36.32932], [-119.23893, 36.3293], [-119.23936, 36.32919], [-119.23997, 36.32911], [-119.24016, 36.32898], [-119.24006, 36.3285], [-119.24069, 36.32807], [-119.24185, 36.32775], [-119.24203, 36.3275], [-119.24227, 36.32731], [-119.24259, 36.32726], [-119.24262, 36.32724], [-119.24291, 36.32724], [-119.24297, 36.33127]]], [[[-119.24313, 36.34277], [-119.24142, 36.3433], [-119.24141, 36.34287], [-119.24097, 36.34288], [-119.24096, 36.34188], [-119.23752, 36.34188], [-119.23746, 36.33925], [-119.23575, 36.33923], [-119.23565, 36.33449], [-119.23398, 36.33447], [-119.23394, 36.33295], [-119.23423, 36.33284], [-119.2348, 36.33253], [-119.23541, 36.33254], [-119.23591, 36.33249], [-119.23661, 36.33231], [-119.23693, 36.33217], [-119.23723, 36.33195], [-119.23812, 36.33167], [-119.23952, 36.33156], [-119.24297, 36.33135], [-119.24313, 36.34277]]]]} | Open Access 1 | 48973 | East Side Regional Park | 33670 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | https://docs.google.com/document/d/1oNuJp2ZETkV9htPzVHlYhz1D7kD7tlzxGEYdJEtsDPg/edit | Tulare 29 | 271.524 | East Side RP | 0 | Local Park 2 | 4 |
15329 | 15329 | 15328 | {"type": "Polygon", "coordinates": [[[-117.03611, 33.78835], [-117.03606, 33.78836], [-117.03603, 33.78814], [-117.03599, 33.78803], [-117.0359, 33.78786], [-117.03583, 33.78777], [-117.03574, 33.78768], [-117.03558, 33.78755], [-117.03537, 33.78743], [-117.03604, 33.78743], [-117.03599, 33.78773], [-117.03606, 33.7878], [-117.03603, 33.78785], [-117.03602, 33.78791], [-117.03605, 33.78798], [-117.03604, 33.788], [-117.03611, 33.78835]]]} | Open Access 1 | 48972 | Pocket Park at the Cove #2 | 33669 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.446 | PP at the Cove #2 | 0 | Local Park 2 | 4 |
15540 | 15540 | 15539 | {"type": "Polygon", "coordinates": [[[-117.03786, 33.79012], [-117.03745, 33.79026], [-117.03733, 33.79002], [-117.03774, 33.78988], [-117.03786, 33.79012]]]} | Open Access 1 | 48971 | Pocket Park at the Cove #1 | 33668 | 7029 | KB Home Coastal Inc 785 | Private 7 | Commercial 20 | https://www.kbhome.com/ | Private 14 | 1416 | San Jacinto, City of 218 | City 2 | City Agency 2 | http://sanjacintoca.hosted.civiclive.com/cms/one.aspx?portalId=10384430&pageId=13304580 | Riverside 10 | 0.295 | PP at the Cove #1 | 0 | Local Park 2 | 4 |
7642 | 7642 | 7641 | {"type": "Polygon", "coordinates": [[[-121.91965, 37.40115], [-121.91878, 37.40193], [-121.91857, 37.40145], [-121.91833, 37.40099], [-121.91804, 37.40054], [-121.91838, 37.40024], [-121.9184, 37.40032], [-121.91845, 37.40039], [-121.91922, 37.40091], [-121.91923, 37.40098], [-121.91927, 37.40103], [-121.91937, 37.40106], [-121.91947, 37.40102], [-121.91965, 37.40115]]]} | Open Access 1 | 48967 | Iris Chang Park | 33665 | 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 | https://www.sanjoseca.gov/Home/Components/News/News/402/5103 | Santa Clara 19 | 2.664 | Iris Chang Park | 2019 | 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]);