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_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12676 | 12676 | 12675 | {"type": "Polygon", "coordinates": [[[-121.27698, 38.82744], [-121.27696, 38.82745], [-121.27693, 38.82751], [-121.27651, 38.82772], [-121.27619, 38.82793], [-121.27561, 38.8274], [-121.27582, 38.82706], [-121.2758, 38.82685], [-121.2759, 38.82669], [-121.27619, 38.82637], [-121.27646, 38.82631], [-121.27679, 38.82713], [-121.27698, 38.82744]]]} | Open Access 1 | 29573 | Bolton Park | 16250 | 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.008 | Bolton 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 | |
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 | |
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 | |
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 | |
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 | |
3661 | 3661 | 3660 | {"type": "Polygon", "coordinates": [[[-121.24385, 38.81066], [-121.24348, 38.81184], [-121.24341, 38.81205], [-121.2433, 38.81226], [-121.24299, 38.81279], [-121.24256, 38.81348], [-121.24111, 38.81281], [-121.2418, 38.81213], [-121.24265, 38.81212], [-121.24265, 38.81049], [-121.24303, 38.81049], [-121.24385, 38.81066]]]} | Open Access 1 | 29633 | Clarke Dominguez Park | 17390 | 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 | 8.027 | Clarke Dominguez 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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
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 | |
12660 | 12660 | 12659 | {"type": "Polygon", "coordinates": [[[-121.28715, 38.82119], [-121.28691, 38.82204], [-121.28636, 38.82241], [-121.2852, 38.82134], [-121.2836, 38.82285], [-121.28314, 38.823], [-121.28295, 38.82262], [-121.2826, 38.82184], [-121.28328, 38.82172], [-121.2833, 38.82005], [-121.28426, 38.8194], [-121.28696, 38.81941], [-121.28686, 38.82106], [-121.28715, 38.82119]]]} | Open Access 1 | 29537 | Margaret Azavedo Park | 21801 | 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 | 24.123 | Margaret Azavedo 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 | |
12656 | 12656 | 12655 | {"type": "Polygon", "coordinates": [[[-121.21492, 38.78493], [-121.21492, 38.78686], [-121.2123, 38.78695], [-121.21229, 38.78497], [-121.21492, 38.78493]]]} | Open Access 1 | 29508 | Monte Verde Park | 22393 | 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 | 12.255 | Monte Verde 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 | |
3287 | 3287 | 3286 | {"type": "Polygon", "coordinates": [[[-121.27391, 38.79872], [-121.2739, 38.79876], [-121.27383, 38.79877], [-121.27377, 38.7988], [-121.27374, 38.79883], [-121.27373, 38.79889], [-121.27375, 38.79894], [-121.27386, 38.79901], [-121.2739, 38.79907], [-121.27399, 38.7996], [-121.27397, 38.79965], [-121.27393, 38.79966], [-121.27243, 38.79981], [-121.27216, 38.79856], [-121.27261, 38.79871], [-121.27295, 38.79868], [-121.2734, 38.79868], [-121.27381, 38.79874], [-121.27391, 38.79872]]]} | Open Access 1 | 29535 | Night Ridge Park | 22756 | 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.008 | Night Ridge 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]);