units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 569 sorted by UNIT_ID
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15648 | 15648 | 15647 | {"type": "Polygon", "coordinates": [[[-121.24386, 38.82628], [-121.24338, 38.82653], [-121.24316, 38.82678], [-121.24269, 38.82757], [-121.2426, 38.82819], [-121.24261, 38.82837], [-121.24276, 38.8288], [-121.24279, 38.82901], [-121.24259, 38.82921], [-121.24234, 38.82955], [-121.24214, 38.82972], [-121.24193, 38.82984], [-121.24176, 38.8299], [-121.2412, 38.83006], [-121.24087, 38.83021], [-121.24074, 38.8303], [-121.24061, 38.83041], [-121.24031, 38.83079], [-121.24, 38.83065], [-121.23921, 38.8312], [-121.23844, 38.83177], [-121.23802, 38.83236], [-121.2377, 38.83295], [-121.23717, 38.83334], [-121.23707, 38.83352], [-121.23724, 38.83378], [-121.237, 38.83387], [-121.23689, 38.83389], [-121.23676, 38.83388], [-121.23661, 38.83384], [-121.23616, 38.83363], [-121.23625, 38.83326], [-121.2365, 38.83304], [-121.23661, 38.83289], [-121.23668, 38.83256], [-121.23696, 38.83233], [-121.23697, 38.83231], [-121.23655, 38.83224], [-121.23609, 38.83253], [-121.23603, 38.83253], [-121.23596, 38.83255], [-121.2359, 38.83231], [-121.23563, 38.83231], [-121.23541, 38.8322], [-121.23533, 38.8322], [-121.23527, 38.83223], [-121.23521, 38.83228], [-121.23511, 38.83249], [-121.23495, 38.8326], [-121.23491, 38.83267], [-121.23488, 38.83279], [-121.23481, 38.83289], [-121.23455, 38.83364], [-121.23458, 38.83372], [-121.23484, 38.83381], [-121.23462, 38.83412], [-121.2345, 38.83421], [-121.23325, 38.83502], [-121.23312, 38.83505], [-121.23298, 38.83504], [-121.23286, 38.835], [-121.23274, 38.8349], [-121.2327, 38.83482], [-121.23269, 38.83473], [-121.2327, 38.83467], [-121.23275, 38.83459], [-121.23316, 38.83423], [-121.23331, 38.83406], [-121.23335, 38.83407], [-121.2334, 38.83399], [-121.23347, 38.83383], [-121.2335, 38.8337], [-121.23345, 38.83369], [-121.23346, 38.83356], [-121.2335, 38.83344], [-121.23355, 38.83336], [-121.23377, 38.83337], [-121.23403, 38.83351], [-121.2341, 38.83344], [-121.23416, 38.83309], [-121.23391, 38.83279], [-121.23382, 38.83239], [-121.23383, 38.8323], [-121.23432, 38.83137], [-121.23448, 38.83114], [-121.23552, 38.83011], [-121.23588, 38.83006], [-121.23637, 38.82985], [-121.23661, 38.82979], [-121.23686, 38.82976], [-121.23739, 38.82976], [-121.2377, 38.82974], [-121.23799, 38.82966], [-121.23827, 38.82953], [-121.23887, 38.82911], [-121.23874, 38.82898], [-121.23879, 38.82893], [-121.2387, 38.82884], [-121.23864, 38.82873], [-121.23857, 38.82865], [-121.23868, 38.82857], [-121.23851, 38.82842], [-121.23847, 38.82836], [-121.23747, 38.82747], [-121.23738, 38.82745], [-121.23745, 38.82737], [-121.23721, 38.82713], [-121.23788, 38.82657], [-121.23814, 38.82643], [-121.23824, 38.82636], [-121.23982, 38.82494], [-121.24003, 38.82478], [-121.2403, 38.82463], [-121.2405, 38.82453], [-121.24081, 38.82441], [-121.24087, 38.82451], [-121.24081, 38.82454], [-121.24052, 38.82512], [-121.24106, 38.82544], [-121.24183, 38.82536], [-121.24209, 38.82551], [-121.24235, 38.82551], [-121.24333, 38.82605], [-121.24361, 38.82597], [-121.24386, 38.82628]]]} | Restricted Access 2 | 20825 | City of Rocklin Golf Courses | 33073 | 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 | 89.934 | City of Rocklin GC | 0 | Local Recreation Area 3 | 4 | |
5031 | 5031 | 5030 | {"type": "Polygon", "coordinates": [[[-121.22404, 38.79398], [-121.2241, 38.79461], [-121.22386, 38.79562], [-121.22379, 38.79568], [-121.22352, 38.79566], [-121.22328, 38.79577], [-121.22288, 38.79523], [-121.22277, 38.79498], [-121.22272, 38.79473], [-121.22273, 38.79397], [-121.22404, 38.79398]]]} | Open Access 1 | 20831 | Sierra Meadows Park | 33739 | 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.822 | Sierra Meadows Park | 0 | Local Park 2 | 4 | |
5032 | 5032 | 5031 | {"type": "Polygon", "coordinates": [[[-121.22313, 38.77883], [-121.22314, 38.77916], [-121.22309, 38.77938], [-121.22302, 38.77959], [-121.22281, 38.77996], [-121.22272, 38.78016], [-121.22267, 38.78018], [-121.22244, 38.78016], [-121.22213, 38.78017], [-121.22192, 38.78021], [-121.22151, 38.78033], [-121.22134, 38.78035], [-121.22129, 38.78033], [-121.22128, 38.78029], [-121.2213, 38.78013], [-121.22146, 38.77976], [-121.22149, 38.77953], [-121.22147, 38.77931], [-121.22144, 38.77917], [-121.22133, 38.77897], [-121.22122, 38.77883], [-121.22313, 38.77883]]]} | Open Access 1 | 20834 | Corral-Alva Park | 33737 | 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 | 5.279 | Corral-Alva Park | 0 | Local Park 2 | 4 | |
10886 | 10886 | 10885 | {"type": "Polygon", "coordinates": [[[-121.24285, 38.7747], [-121.24256, 38.77498], [-121.24217, 38.77545], [-121.242, 38.77559], [-121.24188, 38.77564], [-121.24183, 38.77573], [-121.24146, 38.77569], [-121.24119, 38.77586], [-121.24113, 38.77582], [-121.24105, 38.77582], [-121.24102, 38.77557], [-121.24076, 38.77531], [-121.24238, 38.77431], [-121.24285, 38.7747]]]} | Open Access 1 | 20835 | Woodside Park | 33744 | 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 | 3.563 | Woodside Park | 0 | Local Park 2 | 4 | |
10892 | 10892 | 10891 | {"type": "Polygon", "coordinates": [[[-121.25141, 38.78795], [-121.25144, 38.78819], [-121.25137, 38.7884], [-121.25046, 38.79038], [-121.25037, 38.79061], [-121.25018, 38.7913], [-121.24906, 38.79117], [-121.24881, 38.79116], [-121.24856, 38.79119], [-121.24821, 38.79126], [-121.24793, 38.79138], [-121.24766, 38.79153], [-121.24744, 38.79172], [-121.24745, 38.79199], [-121.24768, 38.79175], [-121.24791, 38.79159], [-121.2482, 38.79145], [-121.2485, 38.79136], [-121.24876, 38.79133], [-121.24901, 38.79133], [-121.25014, 38.79146], [-121.25007, 38.79169], [-121.2497, 38.79372], [-121.24994, 38.79465], [-121.25014, 38.79526], [-121.24892, 38.79477], [-121.24789, 38.79543], [-121.24727, 38.79541], [-121.2465, 38.79517], [-121.24634, 38.79473], [-121.24602, 38.79445], [-121.24482, 38.79531], [-121.24183, 38.79406], [-121.24217, 38.79358], [-121.24208, 38.79343], [-121.24142, 38.79314], [-121.24145, 38.79309], [-121.24244, 38.79351], [-121.24318, 38.79245], [-121.24221, 38.79203], [-121.24474, 38.78846], [-121.24474, 38.78828], [-121.24465, 38.78813], [-121.24449, 38.78801], [-121.24425, 38.78789], [-121.24698, 38.78582], [-121.24742, 38.78608], [-121.24743, 38.78728], [-121.24745, 38.78752], [-121.24854, 38.78775], [-121.24852, 38.78767], [-121.2488, 38.78691], [-121.24932, 38.78625], [-121.2506, 38.78684], [-121.2506, 38.78687], [-121.25099, 38.78706], [-121.2513, 38.78777], [-121.25099, 38.78776], [-121.25061, 38.7878], [-121.25054, 38.7875], [-121.25033, 38.7872], [-121.25008, 38.787], [-121.24982, 38.78694], [-121.24954, 38.78704], [-121.24939, 38.78742], [-121.2494, 38.78761], [-121.24968, 38.78788], [-121.24972, 38.78825], [-121.24968, 38.7885], [-121.25003, 38.78879], [-121.25054, 38.78873], [-121.25076, 38.78842], [-121.25065, 38.78795], [-121.25101, 38.78791], [-121.25121, 38.78792], [-121.25141, 38.78795]]]} | Open Access 1 | 20839 | Johnson-Springview Community Park | 20475 | 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 | 133.0 | Johnson-Springview Community Park | 0 | Local Park 2 | 4 | |
3041 | 3041 | 3040 | {"type": "Polygon", "coordinates": [[[-121.23462, 38.78913], [-121.23412, 38.78977], [-121.23355, 38.78951], [-121.23407, 38.78888], [-121.23462, 38.78913]]]} | Open Access 1 | 20841 | Memorial Park | 22130 | 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.143 | Memorial Park | 0 | Local Park 2 | 4 | |
3042 | 3042 | 3041 | {"type": "Polygon", "coordinates": [[[-121.24331, 38.80602], [-121.2432, 38.80631], [-121.24303, 38.80634], [-121.24295, 38.80653], [-121.24276, 38.80664], [-121.24263, 38.80694], [-121.2429, 38.8072], [-121.24268, 38.80733], [-121.24243, 38.8071], [-121.24221, 38.80711], [-121.24204, 38.80721], [-121.24158, 38.80677], [-121.2422, 38.80622], [-121.24189, 38.80598], [-121.24214, 38.8058], [-121.24244, 38.80565], [-121.24265, 38.80556], [-121.24271, 38.80556], [-121.24287, 38.80573], [-121.24303, 38.80586], [-121.24331, 38.80602]]]} | Open Access 1 | 20842 | Clover Valley Park | 17439 | 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 | 3.722 | Clover Valley Park | 0 | Local Park 2 | 4 | |
10893 | 10893 | 10892 | {"type": "Polygon", "coordinates": [[[-121.24829, 38.82446], [-121.24818, 38.82451], [-121.24812, 38.82496], [-121.24734, 38.82533], [-121.24665, 38.82556], [-121.24639, 38.82547], [-121.24622, 38.82516], [-121.24625, 38.82514], [-121.24578, 38.8243], [-121.24783, 38.8236], [-121.24788, 38.82361], [-121.24791, 38.82364], [-121.24826, 38.8243], [-121.24827, 38.8244], [-121.24829, 38.82446]]]} | Open Access 1 | 20843 | Monument Park | 22446 | 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 | 7.262 | Monument Park | 0 | Local Park 2 | 4 | |
10894 | 10894 | 10893 | {"type": "Polygon", "coordinates": [[[-121.25907, 38.81949], [-121.25836, 38.81993], [-121.25829, 38.81993], [-121.25793, 38.81966], [-121.25761, 38.81946], [-121.25661, 38.81896], [-121.25867, 38.81786], [-121.25886, 38.81924], [-121.25907, 38.81949]]]} | Open Access 1 | 20846 | Breen Park | 16345 | 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 | 5.897 | Breen Park | 0 | Local Park 2 | 4 | |
10895 | 10895 | 10894 | {"type": "Polygon", "coordinates": [[[-121.26504, 38.81124], [-121.26473, 38.81127], [-121.2645, 38.81149], [-121.2637, 38.81155], [-121.26227, 38.81134], [-121.26097, 38.81209], [-121.25895, 38.81171], [-121.25897, 38.81164], [-121.25894, 38.81164], [-121.25889, 38.81157], [-121.25903, 38.81127], [-121.25922, 38.81099], [-121.25945, 38.81072], [-121.25976, 38.81045], [-121.26223, 38.80884], [-121.26232, 38.80884], [-121.26234, 38.80886], [-121.26247, 38.80878], [-121.26245, 38.80873], [-121.26298, 38.80838], [-121.26312, 38.80825], [-121.26387, 38.80779], [-121.26418, 38.8081], [-121.26422, 38.80819], [-121.26434, 38.80826], [-121.2648, 38.80873], [-121.26339, 38.80968], [-121.26504, 38.81124]]]} | Open Access 1 | 20849 | Twin Oaks Park | 33733 | 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 | 30.273 | Twin Oaks Park | 0 | Local Park 2 | 4 | |
10896 | 10896 | 10895 | {"type": "Polygon", "coordinates": [[[-121.26656, 38.80341], [-121.26584, 38.80386], [-121.26423, 38.80405], [-121.26401, 38.80357], [-121.26389, 38.80342], [-121.26375, 38.8033], [-121.26583, 38.80296], [-121.26616, 38.80286], [-121.26633, 38.80314], [-121.26656, 38.80341]]]} | Open Access 1 | 20850 | Pebble Creek Park | 23553 | 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.68 | Pebble Creek Park | 0 | Local Park 2 | 4 | |
10909 | 10909 | 10908 | {"type": "Polygon", "coordinates": [[[-121.25393, 38.78071], [-121.25378, 38.78075], [-121.25354, 38.7812], [-121.25332, 38.78152], [-121.25253, 38.78125], [-121.25248, 38.78099], [-121.2523, 38.78062], [-121.25194, 38.78034], [-121.25182, 38.77988], [-121.25143, 38.77943], [-121.25156, 38.77935], [-121.25167, 38.77925], [-121.2519, 38.77938], [-121.2524, 38.77939], [-121.25269, 38.77907], [-121.25253, 38.77872], [-121.25246, 38.77866], [-121.25303, 38.77856], [-121.25315, 38.77891], [-121.25284, 38.77967], [-121.25335, 38.78053], [-121.25363, 38.78053], [-121.25393, 38.78071]]]} | Open Access 1 | 20897 | Sunset East Park | 33740 | 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 | 6.944 | Sunset East Park | 0 | Local Park 2 | 4 | |
12645 | 12645 | 12644 | {"type": "Polygon", "coordinates": [[[-121.23155, 38.77166], [-121.23143, 38.77235], [-121.23137, 38.77242], [-121.23108, 38.7723], [-121.23087, 38.77225], [-121.23066, 38.77222], [-121.23015, 38.77223], [-121.22978, 38.7723], [-121.22973, 38.77227], [-121.22965, 38.77205], [-121.22965, 38.77182], [-121.22971, 38.77162], [-121.22977, 38.7715], [-121.22999, 38.77123], [-121.23008, 38.77107], [-121.23027, 38.77115], [-121.23083, 38.77166], [-121.23155, 38.77166]]]} | Open Access 1 | 29480 | Joe Hernandez Park | 20420 | 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 | 3.527 | Joe Hernandez Park | 0 | Local Park 2 | 4 | |
12651 | 12651 | 12650 | {"type": "Polygon", "coordinates": [[[-121.28015, 38.83781], [-121.28015, 38.83843], [-121.27996, 38.83843], [-121.27885, 38.83889], [-121.2786, 38.83882], [-121.27847, 38.83858], [-121.27813, 38.83849], [-121.27865, 38.83818], [-121.27857, 38.838], [-121.27853, 38.83798], [-121.2789, 38.83759], [-121.27921, 38.83773], [-121.27944, 38.83779], [-121.27979, 38.83783], [-121.28015, 38.83781]]]} | Open Access 1 | 29493 | Brigham & Hawes Park | 16391 | 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 | 3.582 | Brigham & Hawes Park | 0 | Local Park 2 | 4 | |
3639 | 3639 | 3638 | {"type": "Polygon", "coordinates": [[[-121.23289, 38.83923], [-121.23166, 38.83923], [-121.23148, 38.83918], [-121.23116, 38.83917], [-121.22968, 38.83909], [-121.22968, 38.83892], [-121.22943, 38.83761], [-121.23048, 38.83762], [-121.2305, 38.83696], [-121.2312, 38.83751], [-121.23166, 38.83783], [-121.23216, 38.83813], [-121.23242, 38.83825], [-121.2327, 38.83836], [-121.23267, 38.83845], [-121.23268, 38.83854], [-121.23288, 38.83891], [-121.23289, 38.83923]]]} | Open Access 1 | 29497 | Boulder Ridge Park | 16297 | 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 | 11.15 | Boulder Ridge Park | 0 | Local Park 2 | 4 | |
3640 | 3640 | 3639 | {"type": "Polygon", "coordinates": [[[-121.25516, 38.82911], [-121.25484, 38.82931], [-121.25459, 38.82956], [-121.25447, 38.82976], [-121.25421, 38.8303], [-121.25411, 38.83044], [-121.25317, 38.82964], [-121.25338, 38.82941], [-121.25345, 38.82929], [-121.2535, 38.82917], [-121.25354, 38.82903], [-121.25355, 38.82889], [-121.25354, 38.82875], [-121.25351, 38.8286], [-121.25392, 38.82844], [-121.25515, 38.82835], [-121.25517, 38.82877], [-121.25511, 38.82902], [-121.25516, 38.82911]]]} | No Public Access 3 | 29498 | Mansion Oaks Park | 21761 | 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 | 5.751 | Mansion Oaks Park | 0 | Local Park 2 | 4 | |
12652 | 12652 | 12651 | {"type": "Polygon", "coordinates": [[[-121.22788, 38.80669], [-121.22749, 38.80797], [-121.22717, 38.80791], [-121.22719, 38.80786], [-121.22718, 38.8078], [-121.22715, 38.80777], [-121.22709, 38.80774], [-121.22698, 38.80775], [-121.22687, 38.80783], [-121.22679, 38.80782], [-121.22678, 38.80778], [-121.22678, 38.80717], [-121.2267, 38.80681], [-121.2267, 38.80668], [-121.22788, 38.80669]]]} | Open Access 1 | 29499 | Gayaldo Park | 19244 | 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.626 | Gayaldo Park | 0 | Local Park 2 | 4 | |
12653 | 12653 | 12652 | {"type": "Polygon", "coordinates": [[[-121.21328, 38.78029], [-121.21327, 38.78079], [-121.21324, 38.78083], [-121.21206, 38.78087], [-121.21202, 38.78086], [-121.212, 38.78083], [-121.21198, 38.78064], [-121.212, 38.78052], [-121.21203, 38.78041], [-121.2121, 38.7803], [-121.21328, 38.78029]]]} | Open Access 1 | 29500 | Sasaki Park | 25163 | 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.67 | Sasaki Park | 0 | Local Park 2 | 4 | |
12654 | 12654 | 12653 | {"type": "Polygon", "coordinates": [[[-121.2623, 38.78409], [-121.26167, 38.78534], [-121.26162, 38.78548], [-121.2616, 38.78562], [-121.2616, 38.78577], [-121.26165, 38.78597], [-121.2617, 38.78603], [-121.26138, 38.78633], [-121.26087, 38.78606], [-121.26088, 38.786], [-121.26084, 38.78593], [-121.26075, 38.7859], [-121.26041, 38.78567], [-121.26047, 38.78561], [-121.26074, 38.78524], [-121.26093, 38.78484], [-121.26103, 38.78442], [-121.26103, 38.78397], [-121.26094, 38.78358], [-121.26123, 38.78357], [-121.26182, 38.7837], [-121.26188, 38.78396], [-121.2623, 38.78409]]]} | Open Access 1 | 29502 | Vista Grande Park | 27174 | 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 | 6.16 | Vista Grande Park | 0 | Local Park 2 | 4 | |
12655 | 12655 | 12654 | {"type": "Polygon", "coordinates": [[[-121.29272, 38.80693], [-121.29258, 38.8075], [-121.29252, 38.80788], [-121.2925, 38.80826], [-121.29249, 38.80896], [-121.29163, 38.80896], [-121.29108, 38.80939], [-121.29107, 38.81002], [-121.28931, 38.81005], [-121.28718, 38.81006], [-121.28717, 38.80949], [-121.28658, 38.80949], [-121.287, 38.80895], [-121.28937, 38.80728], [-121.29038, 38.80701], [-121.29272, 38.80693]]]} | Open Access 1 | 29505 | Kathy Lund Community Park | 33732 | 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 | 30.262 | Kathy Lund Community Park | 0 | 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]);