units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
59 rows where ACCESS_TYP = 2 and MNG_AG_TYP = 3 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_NAME, AGNCY_TYP, LAYER, COUNTY, GAP_STS
DES_TP 18
- Local Recreation Area 21
- Local Conservation Area 12
- Local Park 6
- Local Other or Unknown 6
- National Recreation Area 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
MNG_AGENCY 15
- Sacramento, County of 23
- Los Angeles, County of 14
- Orange, County of 5
- San Diego, County of 3
- Santa Cruz, County of 2
- San Luis Obispo, County of 2
- Ventura, County of 2
- Monterey, County of 1
- Tulare, County of 1
- Riverside, County of 1
- Placer, County of 1
- Fresno, County of 1
- Kern, County of 1
- Humboldt, County of 1
- Shasta, County of 1
MNG_AG_TYP 1
- County Agency · 59 ✖
ACCESS_TYP 1
- Restricted Access · 59 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11141 | 11141 | 11140 | {"type": "Polygon", "coordinates": [[[-121.2683, 38.7177], [-121.26769, 38.71781], [-121.26746, 38.71783], [-121.26736, 38.71789], [-121.26714, 38.71792], [-121.26714, 38.71772], [-121.26729, 38.71769], [-121.26752, 38.71753], [-121.2683, 38.71752], [-121.2683, 38.7177]]]} | Restricted Access 2 | 21443 | Nevinshire | 22705 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.662 | Nevinshire | None 973 | |||
11418 | 11418 | 11417 | {"type": "Polygon", "coordinates": [[[-121.20133, 38.43685], [-121.20134, 38.43694], [-121.20132, 38.43704], [-121.20014, 38.43829], [-121.20013, 38.4383], [-121.20006, 38.4383], [-121.20003, 38.43827], [-121.20001, 38.43824], [-121.20036, 38.4379], [-121.20048, 38.43773], [-121.20071, 38.43749], [-121.20119, 38.43684], [-121.20129, 38.43682], [-121.20133, 38.43685]]]} | Restricted Access 2 | 22230 | John H Friend | 20444 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 0.684 | John H Friend | None 1010 | |||
4057 | 4057 | 4056 | {"type": "Polygon", "coordinates": [[[-122.40231, 40.58043], [-122.40172, 40.58057], [-122.40131, 40.57969], [-122.40194, 40.57953], [-122.40231, 40.58043]]]} | Restricted Access 2 | 44420 | Magnolia Park | 21676 | 343 | Shasta, County of 717 | County 3 | County Agency 3 | http://www.co.shasta.ca.us/index.aspx | County 3 | 343 | Shasta, County of 700 | County 3 | County Agency 3 | Shasta 27 | 1.399 | Magnolia Park | 0 | Local Park 2 | 4 | |
4679 | 4679 | 4678 | {"type": "Polygon", "coordinates": [[[-121.3533, 38.45594], [-121.35327, 38.45595], [-121.35327, 38.45636], [-121.35226, 38.45636], [-121.35227, 38.45624], [-121.3523, 38.45613], [-121.35236, 38.456], [-121.35243, 38.45591], [-121.35251, 38.45582], [-121.35281, 38.45567], [-121.35311, 38.4556], [-121.35318, 38.45561], [-121.35321, 38.45564], [-121.3533, 38.45594]]]} | Restricted Access 2 | 43001 | Unnamed site - Sacramento, County of | 28659 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 1.452 | 0 | Local Other or Unknown 14 | 4 | ||
3224 | 3224 | 3223 | {"type": "Polygon", "coordinates": [[[-121.45044, 38.37471], [-121.44978, 38.3747], [-121.44966, 38.37342], [-121.45028, 38.37338], [-121.45044, 38.37471]]]} | Restricted Access 2 | 22246 | Hood-Franklin Drainage | 20071 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.025 | Hood-Franklin Drainage | None 266 | |||
6056 | 6056 | 6055 | {"type": "Polygon", "coordinates": [[[-118.65875, 34.07333], [-118.65821, 34.07334], [-118.6582, 34.07327], [-118.65765, 34.07327], [-118.65765, 34.07272], [-118.65786, 34.07272], [-118.65786, 34.0725], [-118.65875, 34.07256], [-118.65875, 34.07333]]]} | Restricted Access 2 | 12780 | Santa Monica Mountains National Recreation Area | 29657 | 108 | United States National Park Service 102 | Federal 1 | Federal Agency 1 | http://www.nps.gov/ | National Park Service 12 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://www.nps.gov/samo/index.htm | Los Angeles 6 | 2.045 | Santa Monica Mtns. NRA | 0 | National Recreation Area 54 | 3 |
11398 | 11398 | 11397 | {"type": "MultiPolygon", "coordinates": [[[[-121.24893, 38.67172], [-121.2489, 38.67173], [-121.24889, 38.67164], [-121.24884, 38.67156], [-121.2486, 38.67133], [-121.24893, 38.67133], [-121.24893, 38.67172]]], [[[-121.25125, 38.67334], [-121.25049, 38.67337], [-121.25043, 38.67336], [-121.24934, 38.67255], [-121.24894, 38.67232], [-121.24893, 38.67184], [-121.24905, 38.67183], [-121.24903, 38.67201], [-121.24906, 38.67206], [-121.24937, 38.67222], [-121.24962, 38.67238], [-121.25057, 38.67308], [-121.25063, 38.67309], [-121.25112, 38.67306], [-121.25117, 38.67304], [-121.25125, 38.67298], [-121.25125, 38.67334]]]]} | Restricted Access 2 | 22206 | Sunrise Recreation/parks District | 26038 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 2.065 | Sunrise Rec./parks District | 0 | Local Recreation Area 3 | 4 | |
14245 | 14245 | 14244 | {"type": "Polygon", "coordinates": [[[-118.03024, 34.15973], [-118.02975, 34.15977], [-118.0297, 34.1602], [-118.02916, 34.16008], [-118.02882, 34.16003], [-118.02852, 34.16], [-118.02806, 34.16001], [-118.02952, 34.15919], [-118.03012, 34.15918], [-118.03024, 34.15973]]]} | Restricted Access 2 | 44142 | Highland Oaks Park | 19930 | 2315 | Arcadia Unified School District 762 | Special District 4 | School District 14 | http://site.ausd.net/ | Special District 4 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 2.851 | Highland Oaks Park | 0 | Local Park 2 | 4 | |
11376 | 11376 | 11375 | {"type": "Polygon", "coordinates": [[[-121.39798, 38.71663], [-121.39679, 38.71662], [-121.39676, 38.71656], [-121.39668, 38.71625], [-121.39666, 38.71594], [-121.39669, 38.71563], [-121.39678, 38.71532], [-121.39678, 38.71519], [-121.39741, 38.71519], [-121.39736, 38.71531], [-121.39736, 38.71543], [-121.39743, 38.71553], [-121.39768, 38.71574], [-121.39785, 38.71583], [-121.39795, 38.71602], [-121.39798, 38.71663]]]} | Restricted Access 2 | 22186 | Atreule Et Al Community Plan | 15676 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 3.539 | Atreule Et Al Community Plan | None 1000 | |||
4372 | 4372 | 4371 | {"type": "Polygon", "coordinates": [[[-118.22505, 33.96758], [-118.22454, 33.96753], [-118.22448, 33.9675], [-118.22431, 33.96734], [-118.22437, 33.96694], [-118.22436, 33.96693], [-118.22415, 33.96711], [-118.22327, 33.96702], [-118.22323, 33.96723], [-118.22254, 33.96715], [-118.22254, 33.96649], [-118.22474, 33.96672], [-118.22469, 33.96704], [-118.22505, 33.96708], [-118.22505, 33.96758]]]} | Restricted Access 2 | 45864 | Walnut Nature Park | 28911 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | http://parks.lacounty.gov | County 3 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | Los Angeles 6 | 3.587 | Walnut Nature Park | 0 | Local Park 2 | 4 | |
11411 | 11411 | 11410 | {"type": "Polygon", "coordinates": [[[-121.44882, 38.38398], [-121.44574, 38.38469], [-121.44561, 38.38473], [-121.44549, 38.38479], [-121.44535, 38.38492], [-121.44535, 38.38427], [-121.44879, 38.38348], [-121.44879, 38.38397], [-121.44882, 38.38398]]]} | Restricted Access 2 | 22248 | Lotus Pond Drainage | 21545 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.291 | Lotus Pond Drainage | 0 | Local Other or Unknown 14 | 4 | |
11174 | 11174 | 11173 | {"type": "Polygon", "coordinates": [[[-121.20529, 38.35592], [-121.20528, 38.35682], [-121.20307, 38.35681], [-121.20308, 38.3559], [-121.20529, 38.35592]]]} | Restricted Access 2 | 22245 | Terry Parker Et Al | 26269 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 4.819 | Terry Parker Et Al | None 975 | |||
15700 | 15700 | 15699 | {"type": "MultiPolygon", "coordinates": [[[[-121.39794, 38.718], [-121.39794, 38.71803], [-121.39732, 38.718], [-121.39658, 38.71802], [-121.39577, 38.71793], [-121.39554, 38.71792], [-121.39551, 38.71787], [-121.39552, 38.71785], [-121.39555, 38.71784], [-121.39583, 38.71783], [-121.39606, 38.71779], [-121.39641, 38.71779], [-121.39656, 38.7178], [-121.39671, 38.71785], [-121.39676, 38.7179], [-121.39686, 38.71795], [-121.39728, 38.71796], [-121.39737, 38.71794], [-121.39749, 38.71784], [-121.39758, 38.71779], [-121.3976, 38.71781], [-121.39758, 38.71783], [-121.39748, 38.71789], [-121.39744, 38.71795], [-121.39783, 38.71794], [-121.39783, 38.71791], [-121.39779, 38.71786], [-121.39778, 38.71783], [-121.39781, 38.71782], [-121.39785, 38.71784], [-121.39789, 38.71788], [-121.39794, 38.718]]], [[[-121.39618, 38.71991], [-121.39616, 38.72016], [-121.39605, 38.72016], [-121.39597, 38.72018], [-121.39591, 38.72022], [-121.39584, 38.72035], [-121.3958, 38.72036], [-121.39565, 38.72036], [-121.39555, 38.7204], [-121.39556, 38.72018], [-121.39566, 38.72015], [-121.39571, 38.72], [-121.39583, 38.71988], [-121.39595, 38.71984], [-121.39608, 38.71986], [-121.39618, 38.71991]]], [[[-121.39818, 38.72268], [-121.39814, 38.72274], [-121.39806, 38.72275], [-121.39799, 38.72272], [-121.39741, 38.72221], [-121.39721, 38.72206], [-121.39692, 38.72206], [-121.39681, 38.72208], [-121.39667, 38.72208], [-121.39636, 38.72209], [-121.3963, 38.72213], [-121.39624, 38.72223], [-121.39618, 38.72225], [-121.39614, 38.72225], [-121.39614, 38.72214], [-121.39627, 38.72204], [-121.39642, 38.722], [-121.39678, 38.72199], [-121.397, 38.72193], [-121.39712, 38.72193], [-121.39716, 38.7219], [-121.39732, 38.72192], [-121.39736, 38.72188], [-121.39735, 38.7218], [-121.3974, 38.7218], [-121.39766, 38.72198], [-121.39765, 38.72205], [-121.39772, 38.72225], [-121.39781, 38.72236], [-121.39793, 38.72246], [-121.39806, 38.72253], [-121.39815, 38.72262], [-121.39818, 38.72268]]], [[[-121.39707, 38.71962], [-121.39706, 38.71979], [-121.39699, 38.71992], [-121.39686, 38.72003], [-121.3967, 38.7201], [-121.39652, 38.72011], [-121.39623, 38.7201], [-121.39627, 38.71989], [-121.39643, 38.71978], [-121.39654, 38.71961], [-121.39661, 38.71955], [-121.39665, 38.71954], [-121.39669, 38.71956], [-121.3967, 38.71969], [-121.39676, 38.71971], [-121.39683, 38.71966], [-121.39686, 38.71961], [-121.3969, 38.7196], [-121.39707, 38.71962]]], [[[-121.39714, 38.72282], [-121.39707, 38.72291], [-121.39709, 38.72297], [-121.39705, 38.72298], [-121.39697, 38.72297], [-121.39696, 38.72294], [-121.39698, 38.72291], [-121.39703, 38.72287], [-121.39705, 38.7228], [-121.39711, 38.72278], [-121.39714, 38.72282]]], [[[-121.39748, 38.71779], [-121.39746, 38.71783], [-121.39735, 38.71791], [-121.39728, 38.71789], [-121.39722, 38.7178], [-121.3973, 38.71778], [-121.39748, 38.71779]]], [[[-121.39777, 38.72167], [-121.39772, 38.72182], [-121.39774, 38.72194], [-121.39773, 38.72196], [-121.39751, 38.72182], [-121.39744, 38.72169], [-121.39747, 38.72165], [-121.39749, 38.72157], [-121.39747, 38.72152], [-121.39743, 38.72147], [-121.39759, 38.72147], [-121.39758, 38.72153], [-121.39763, 38.72157], [-121.39766, 38.72157], [-121.3977, 38.7215], [-121.39772, 38.72151], [-121.39777, 38.72167]]], [[[-121.39838, 38.7181], [-121.39828, 38.71814], [-121.39808, 38.71811], [-121.39802, 38.71806], [-121.39799, 38.71795], [-121.39803, 38.71791], [-121.3982, 38.71785], [-121.39827, 38.71781], [-121.39836, 38.71786], [-121.39833, 38.71791], [-121.39838, 38.7181]], [[-121.39827, 38.71793], [-121.39823, 38.71793], [-121.3981, 38.71799], [-121.39807, 38.71801], [-121.39808, 38.71804], [-121.39814, 38.71808], [-121.39829, 38.71808], [-121.3983, 38.71806], [-121.3983, 38.71802], [-121.39827, 38.71793]]], [[[-121.39856, 38.71876], [-121.39851, 38.71878], [-121.39844, 38.71876], [-121.39837, 38.71876], [-121.39836, 38.71877], [-121.39837, 38.71878], [-121.39847, 38.71879], [-121.39849, 38.7188], [-121.39849, 38.71882], [-121.39834, 38.71882], [-121.39826, 38.71884], [-121.39821, 38.71882], [-121.39814, 38.71876], [-121.39799, 38.71874], [-121.39799, 38.71871], [-121.39807, 38.71868], [-121.39808, 38.71864], [-121.39807, 38.71857], [-121.3981, 38.71854], [-121.39828, 38.71856], [-121.39835, 38.71854], [-121.39841, 38.71868], [-121.39856, 38.71873], [-121.39856, 38.71876]]], [[[-121.39831, 38.71842], [-121.3983, 38.71845], [-121.39827, 38.71847], [-121.39812, 38.71846], [-121.39806, 38.71841], [-121.39809, 38.71835], [-121.39812, 38.71833], [-121.39817, 38.71832], [-121.39825, 38.71834], [-121.39831, 38.71842]]], [[[-121.39929, 38.71634], [-121.3993, 38.7164], [-121.39929, 38.7165], [-121.39912, 38.71679], [-121.39902, 38.7169], [-121.39895, 38.71708], [-121.39891, 38.71713], [-121.39875, 38.71725], [-121.3987, 38.7173], [-121.39851, 38.71762], [-121.3985, 38.71769], [-121.39844, 38.71774], [-121.3984, 38.7178], [-121.39832, 38.71779], [-121.39832, 38.71776], [-121.3984, 38.7176], [-121.39865, 38.71724], [-121.39869, 38.71712], [-121.39881, 38.71706], [-121.39899, 38.71683], [-121.39904, 38.7168], [-121.39918, 38.71658], [-121.39922, 38.71649], [-121.39924, 38.71633], [-121.39929, 38.71634]]], [[[-121.39855, 38.71891], [-121.39854, 38.71895], [-121.39849, 38.71897], [-121.39844, 38.71895], [-121.39837, 38.71895], [-121.39834, 38.71892], [-121.39836, 38.71889], [-121.3985, 38.71887], [-121.39852, 38.71887], [-121.39855, 38.71891]]], [[[-121.399, 38.71916], [-121.39899, 38.7193], [-121.39893, 38.71943], [-121.39888, 38.71974], [-121.39877, 38.72018], [-121.39878, 38.72047], [-121.39876, 38.72053], [-121.39867, 38.72068], [-121.39863, 38.72089], [-121.39857, 38.72103], [-121.39855, 38.72112], [-121.3985, 38.72116], [-121.39845, 38.72114], [-121.39842, 38.72111], [-121.39842, 38.72097], [-121.39847, 38.72082], [-121.3985, 38.72065], [-121.39847, 38.7206], [-121.39853, 38.72028], [-121.39864, 38.71992], [-121.39871, 38.71981], [-121.3988, 38.71951], [-121.39879, 38.71916], [-121.39885, 38.71911], [-121.39894, 38.71911], [-121.399, 38.71916]]], [[[-121.40081, 38.71464], [-121.40058, 38.71479], [-121.40051, 38.71481], [-121.40037, 38.71487], [-121.40032, 38.71491], [-121.40027, 38.71504], [-121.4002, 38.71514], [-121.39991, 38.71531], [-121.3999, 38.71535], [-121.40001, 38.71548], [-121.39996, 38.71553], [-121.39964, 38.71561], [-121.39948, 38.71568], [-121.39943, 38.71572], [-121.39939, 38.71579], [-121.39938, 38.71583], [-121.39939, 38.71588], [-121.39952, 38.71594], [-121.39954, 38.71599], [-121.39951, 38.71607], [-121.39939, 38.71624], [-121.39933, 38.71628], [-121.39928, 38.71625], [-121.39927, 38.71623], [-121.39943, 38.71603], [-121.3994, 38.71598], [-121.39927, 38.71596], [-121.39924, 38.71594], [-121.39922, 38.7159], [-121.39923, 38.7158], [-121.39939, 38.71563], [-121.3995, 38.71556], [-121.39981, 38.7155], [-121.39985, 38.71546], [-121.39972, 38.71525], [-121.39962, 38.71525], [-121.39965, 38.71522], [-121.3997, 38.71521], [-121.39969, 38.71515], [-121.39971, 38.71513], [-121.39977, 38.71509], [-121.40009, 38.71507], [-121.40012, 38.71504], [-121.40018, 38.7149], [-121.40026, 38.71479], [-121.40037, 38.71472], [-121.40055, 38.71466], [-121.40071, 38.71457], [-121.4008, 38.71462], [-121.40081, 38.71464]]], [[[-121.40096, 38.71443], [-121.4009, 38.71456], [-121.40083, 38.71459], [-121.40079, 38.71456], [-121.40079, 38.71453], [-121.40085, 38.71449], [-121.40086, 38.71443], [-121.40096, 38.71443]]]]} | Restricted Access 2 | 21434 | Antelope Greens Golf Course | 28301 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 5.742 | Antelope Greens GC | 0 | Local Recreation Area 3 | 4 | |
11410 | 11410 | 11409 | {"type": "Polygon", "coordinates": [[[-121.45132, 38.38301], [-121.45064, 38.38333], [-121.45063, 38.38332], [-121.45032, 38.38293], [-121.44997, 38.38258], [-121.44967, 38.38233], [-121.44924, 38.38204], [-121.44983, 38.3814], [-121.45112, 38.3813], [-121.45132, 38.38301]]]} | Restricted Access 2 | 22247 | Kenneth Way Drainage | 20610 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.273 | Kenneth Way Drainage | None 1008 | |||
2877 | 2877 | 2876 | {"type": "Polygon", "coordinates": [[[-121.2872, 38.42303], [-121.28685, 38.42315], [-121.28643, 38.42337], [-121.28619, 38.42353], [-121.2858, 38.42385], [-121.28542, 38.42359], [-121.28471, 38.42421], [-121.28261, 38.42406], [-121.28154, 38.42496], [-121.28143, 38.42489], [-121.28175, 38.42462], [-121.28187, 38.42447], [-121.28205, 38.42431], [-121.28253, 38.42403], [-121.28272, 38.42397], [-121.28303, 38.42393], [-121.28323, 38.42385], [-121.28393, 38.42367], [-121.28429, 38.4236], [-121.28452, 38.42349], [-121.28487, 38.42338], [-121.28505, 38.42325], [-121.28543, 38.42302], [-121.286, 38.42263], [-121.28628, 38.42252], [-121.28663, 38.42231], [-121.2872, 38.42303]]]} | Restricted Access 2 | 22244 | Preston Hanford | 23996 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 6.909 | Preston Hanford | None 241 | |||
11202 | 11202 | 11201 | {"type": "Polygon", "coordinates": [[[-121.48774, 38.4088], [-121.48772, 38.40888], [-121.48765, 38.40901], [-121.48756, 38.4091], [-121.48745, 38.40917], [-121.48727, 38.40925], [-121.48678, 38.40939], [-121.48637, 38.40956], [-121.48599, 38.40978], [-121.48562, 38.41006], [-121.48533, 38.41036], [-121.48511, 38.41068], [-121.48492, 38.41107], [-121.48483, 38.4114], [-121.48435, 38.4089], [-121.48598, 38.40887], [-121.48656, 38.40882], [-121.48774, 38.4088]]]} | Restricted Access 2 | 21496 | Stone Lakes | 25873 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 7.901 | Stone Lakes | None 977 | |||
11134 | 11134 | 11133 | {"type": "MultiPolygon", "coordinates": [[[[-121.35455, 38.51709], [-121.3545, 38.51715], [-121.35442, 38.51718], [-121.35373, 38.5172], [-121.35298, 38.51727], [-121.35225, 38.5174], [-121.35179, 38.51751], [-121.3517, 38.51748], [-121.35166, 38.51743], [-121.35166, 38.51736], [-121.35171, 38.51731], [-121.35187, 38.51726], [-121.35204, 38.51726], [-121.35228, 38.51719], [-121.35251, 38.5171], [-121.35272, 38.51697], [-121.35284, 38.51691], [-121.35299, 38.5169], [-121.35312, 38.51694], [-121.35328, 38.517], [-121.35345, 38.51702], [-121.35362, 38.51698], [-121.35365, 38.51696], [-121.35399, 38.51694], [-121.35409, 38.51692], [-121.35441, 38.51693], [-121.3545, 38.51696], [-121.35455, 38.51702], [-121.35455, 38.51709]]], [[[-121.35432, 38.51553], [-121.35427, 38.5156], [-121.3541, 38.51566], [-121.35309, 38.51629], [-121.35292, 38.51649], [-121.35269, 38.51664], [-121.3522, 38.51683], [-121.35209, 38.51683], [-121.35195, 38.51683], [-121.35186, 38.51678], [-121.35182, 38.5167], [-121.35182, 38.51662], [-121.35187, 38.51655], [-121.35249, 38.51617], [-121.35256, 38.51606], [-121.35255, 38.51596], [-121.35248, 38.51586], [-121.35236, 38.5158], [-121.35222, 38.51579], [-121.35213, 38.51583], [-121.35197, 38.51584], [-121.35189, 38.51584], [-121.35181, 38.5158], [-121.35177, 38.51574], [-121.35178, 38.51566], [-121.35183, 38.5156], [-121.35279, 38.51544], [-121.35358, 38.51537], [-121.35418, 38.51535], [-121.35427, 38.51538], [-121.35432, 38.51545], [-121.35432, 38.51553]]], [[[-121.35456, 38.51613], [-121.35451, 38.51619], [-121.35443, 38.51622], [-121.35412, 38.51626], [-121.35381, 38.51634], [-121.35353, 38.51646], [-121.3535, 38.51646], [-121.35367, 38.51628], [-121.35388, 38.51614], [-121.35413, 38.51605], [-121.3544, 38.51601], [-121.35449, 38.51602], [-121.35455, 38.51607], [-121.35456, 38.51613]]], [[[-121.35835, 38.5161], [-121.35832, 38.51617], [-121.35824, 38.51623], [-121.35814, 38.51625], [-121.35804, 38.51623], [-121.35786, 38.51611], [-121.35774, 38.51607], [-121.35751, 38.51606], [-121.35743, 38.5161], [-121.35739, 38.51617], [-121.35749, 38.51636], [-121.35747, 38.51643], [-121.3574, 38.51646], [-121.35734, 38.51646], [-121.35719, 38.51634], [-121.35708, 38.51618], [-121.3567, 38.51597], [-121.35641, 38.51587], [-121.35611, 38.5158], [-121.35601, 38.51579], [-121.35592, 38.51574], [-121.35587, 38.51567], [-121.35588, 38.51558], [-121.35594, 38.51551], [-121.35603, 38.51547], [-121.35614, 38.51548], [-121.35672, 38.51557], [-121.35748, 38.51574], [-121.3582, 38.51595], [-121.35828, 38.51601], [-121.35835, 38.5161]]], [[[-121.35658, 38.51631], [-121.35641, 38.51634], [-121.35628, 38.51633], [-121.35605, 38.51625], [-121.35599, 38.51617], [-121.35599, 38.51608], [-121.35617, 38.51607], [-121.35634, 38.5161], [-121.35649, 38.51619], [-121.35658, 38.51631]]], [[[-121.35831, 38.51766], [-121.35829, 38.51774], [-121.35821, 38.5178], [-121.35813, 38.5178], [-121.35742, 38.51758], [-121.3567, 38.5174], [-121.35624, 38.51732], [-121.35615, 38.51727], [-121.35611, 38.51719], [-121.35613, 38.51711], [-121.35621, 38.51705], [-121.35632, 38.51704], [-121.35648, 38.51708], [-121.35658, 38.51714], [-121.35674, 38.5172], [-121.35709, 38.51725], [-121.35718, 38.51723], [-121.35723, 38.51718], [-121.35723, 38.5171], [-121.35688, 38.51665], [-121.35686, 38.51659], [-121.35686, 38.51657], [-121.35689, 38.51655], [-121.35702, 38.51655], [-121.35718, 38.51665], [-121.35723, 38.51679], [-121.35737, 38.51698], [-121.35747, 38.51717], [-121.35798, 38.51748], [-121.35826, 38.51759], [-121.35831, 38.51766]]]]} | Restricted Access 2 | 21428 | Morrison Creek Mining | 22496 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 10.801 | Morrison Creek Mining | None 972 | |||
7368 | 7368 | 7367 | {"type": "Polygon", "coordinates": [[[-118.05801, 33.90814], [-118.05748, 33.90772], [-118.0555, 33.90773], [-118.05549, 33.906], [-118.05799, 33.90598], [-118.05801, 33.90814]]]} | Restricted Access 2 | 6773 | Don Knabe Golf Center and Junior Academy | 32519 | 1225 | Norwalk, City of 239 | City 2 | City Agency 2 | http://www.ci.norwalk.ca.us/city-hall/departments/recreation-park-services | City 2 | 305 | Los Angeles, County of 16 | County 3 | County Agency 3 | https://www.playknabegolf.com/ | Los Angeles 6 | 11.277 | Don Knabe Golf Ctr. and Junior Academy | None 610 | ||
11194 | 11194 | 11193 | {"type": "Polygon", "coordinates": [[[-121.35327, 38.45636], [-121.35322, 38.45992], [-121.35131, 38.45992], [-121.3513, 38.45977], [-121.35097, 38.45977], [-121.35102, 38.45972], [-121.35104, 38.45966], [-121.35101, 38.45955], [-121.35101, 38.45909], [-121.35105, 38.45881], [-121.35101, 38.45853], [-121.35101, 38.45828], [-121.35103, 38.45815], [-121.35115, 38.45772], [-121.35118, 38.45754], [-121.35122, 38.45751], [-121.35151, 38.45747], [-121.35171, 38.4574], [-121.3519, 38.45729], [-121.35207, 38.45714], [-121.35219, 38.45698], [-121.35227, 38.45677], [-121.35228, 38.45663], [-121.35226, 38.45636], [-121.35327, 38.45636]]]} | Restricted Access 2 | 21470 | D R Horton Inc Sacramento | 17889 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.774 | D R Horton Inc Sacramento | None 976 | |||
3118 | 3118 | 3117 | {"type": "Polygon", "coordinates": [[[-121.45011, 38.40646], [-121.45004, 38.40688], [-121.4499, 38.40688], [-121.44976, 38.40685], [-121.44963, 38.40679], [-121.44953, 38.40671], [-121.44945, 38.40661], [-121.44942, 38.40654], [-121.44941, 38.40643], [-121.44944, 38.40612], [-121.44612, 38.40611], [-121.44612, 38.40534], [-121.44083, 38.40532], [-121.44083, 38.405], [-121.44983, 38.40499], [-121.44995, 38.40507], [-121.45002, 38.40514], [-121.4501, 38.40525], [-121.45014, 38.40538], [-121.45014, 38.40551], [-121.45, 38.40639], [-121.45004, 38.40645], [-121.45011, 38.40646]]]} | Restricted Access 2 | 21488 | Laguna Lake Drainage | 20858 | 316 | Sacramento, County of 550 | County 3 | County Agency 3 | http://www.saccounty.net/live-visit/Pages/ParksRecreation.aspx | County 3 | 316 | Sacramento, County of 543 | County 3 | County Agency 3 | Sacramento 41 | 15.913 | Laguna Lake Drainage | None 255 |
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]);