units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
67 rows where DES_TP = 2 and MNG_AGENCY = 533 sorted by UNIT_NAME descending
This data as json, copyable, CSV (advanced)
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 67
MNG_AGENCY 1
- Roseville, City of · 67 ✖
DES_TP 1
- Local Park · 67 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10910 | 10910 | 10909 | {"type": "Polygon", "coordinates": [[[-121.28143, 38.75753], [-121.28031, 38.7582], [-121.27963, 38.7575], [-121.28075, 38.75684], [-121.28143, 38.75753]]]} | Open Access 1 | 20899 | Woodbridge Park | 27687 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.938 | Woodbridge Park | 0 | Local Park 2 | 4 | |
12640 | 12640 | 12639 | {"type": "Polygon", "coordinates": [[[-121.27515, 38.75394], [-121.27379, 38.75397], [-121.27323, 38.75423], [-121.27256, 38.75336], [-121.27242, 38.75326], [-121.27147, 38.75324], [-121.27081, 38.75361], [-121.27047, 38.75404], [-121.27048, 38.75274], [-121.27131, 38.7524], [-121.27181, 38.75204], [-121.27232, 38.75203], [-121.27233, 38.75259], [-121.27515, 38.75257], [-121.27515, 38.75394]]]} | Open Access 1 | 29466 | William L. Taylor Park | 27548 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 13.609 | William L. Taylor Park | 0 | Local Park 2 | 4 | |
2640 | 2640 | 2639 | {"type": "Polygon", "coordinates": [[[-121.33746, 38.80162], [-121.33738, 38.8016], [-121.33727, 38.80178], [-121.33701, 38.80169], [-121.33682, 38.80167], [-121.33667, 38.8017], [-121.33646, 38.80179], [-121.33611, 38.80189], [-121.33569, 38.80158], [-121.33557, 38.80162], [-121.33532, 38.80198], [-121.33521, 38.8022], [-121.33504, 38.80276], [-121.33491, 38.80291], [-121.33476, 38.80304], [-121.3346, 38.80308], [-121.3345, 38.80316], [-121.33439, 38.80316], [-121.33403, 38.80308], [-121.33371, 38.8032], [-121.33356, 38.80327], [-121.3333, 38.8033], [-121.33319, 38.80335], [-121.33319, 38.80336], [-121.33327, 38.8034], [-121.33342, 38.80353], [-121.33327, 38.80373], [-121.33341, 38.80391], [-121.33373, 38.80471], [-121.33429, 38.80553], [-121.33418, 38.80554], [-121.33364, 38.80475], [-121.33336, 38.8042], [-121.33317, 38.80392], [-121.33319, 38.80381], [-121.33317, 38.80369], [-121.333, 38.80339], [-121.333, 38.80329], [-121.33291, 38.80317], [-121.33277, 38.80312], [-121.33252, 38.8032], [-121.3322, 38.8032], [-121.33214, 38.80307], [-121.33211, 38.80285], [-121.33204, 38.80268], [-121.33186, 38.80262], [-121.3318, 38.80252], [-121.33154, 38.80243], [-121.33135, 38.80239], [-121.33112, 38.80246], [-121.3307, 38.80269], [-121.3306, 38.80269], [-121.33038, 38.80264], [-121.33002, 38.80262], [-121.32972, 38.80215], [-121.33008, 38.80202], [-121.33031, 38.80215], [-121.33057, 38.80222], [-121.33078, 38.80224], [-121.33111, 38.8022], [-121.33128, 38.8022], [-121.33193, 38.8023], [-121.33194, 38.80232], [-121.33213, 38.80231], [-121.33239, 38.80227], [-121.33265, 38.80219], [-121.33299, 38.80201], [-121.33313, 38.80191], [-121.33326, 38.80175], [-121.33334, 38.80158], [-121.33336, 38.80138], [-121.33332, 38.80121], [-121.33325, 38.80108], [-121.33315, 38.80096], [-121.33271, 38.80058], [-121.33251, 38.80045], [-121.33298, 38.80021], [-121.3329, 38.79994], [-121.33309, 38.79935], [-121.33297, 38.79919], [-121.33319, 38.79911], [-121.33374, 38.79925], [-121.3338, 38.79908], [-121.33396, 38.79895], [-121.33426, 38.79902], [-121.33435, 38.7988], [-121.33426, 38.79856], [-121.33422, 38.79829], [-121.33428, 38.798], [-121.33453, 38.79801], [-121.33476, 38.79804], [-121.33495, 38.79809], [-121.33516, 38.79817], [-121.33688, 38.79907], [-121.3371, 38.79922], [-121.33729, 38.7994], [-121.33738, 38.79952], [-121.33747, 38.79968], [-121.33754, 38.79988], [-121.33757, 38.80005], [-121.33759, 38.80119], [-121.33755, 38.80141], [-121.33746, 38.80162]]]} | Open Access 1 | 20852 | William "Bill" Hughes Park | 27535 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 44.252 | William "Bill" Hughes Park | 0 | Local Park 2 | 4 | |
10924 | 10924 | 10923 | {"type": "Polygon", "coordinates": [[[-121.24017, 38.72845], [-121.24012, 38.72857], [-121.2401, 38.72873], [-121.24009, 38.7297], [-121.24007, 38.72973], [-121.24001, 38.72975], [-121.23919, 38.72965], [-121.23917, 38.72832], [-121.23896, 38.72831], [-121.23894, 38.72817], [-121.23808, 38.72816], [-121.23807, 38.72824], [-121.23775, 38.72824], [-121.23774, 38.72771], [-121.2397, 38.7277], [-121.24017, 38.72845]]]} | Open Access 1 | 20936 | Willard Dietrich Park | 27530 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 5.806 | Willard Dietrich Park | 0 | Local Park 2 | 4 | |
3598 | 3598 | 3597 | {"type": "Polygon", "coordinates": [[[-121.29155, 38.75104], [-121.29139, 38.75143], [-121.29139, 38.75183], [-121.29041, 38.75183], [-121.29043, 38.75127], [-121.29053, 38.75131], [-121.29097, 38.75085], [-121.29122, 38.75095], [-121.29155, 38.75104]]]} | Open Access 1 | 29457 | Weber Park | 27325 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 1.903 | Weber Park | 0 | Local Park 2 | 4 | |
12464 | 12464 | 12463 | {"type": "Polygon", "coordinates": [[[-121.23271, 38.75219], [-121.23154, 38.75352], [-121.23154, 38.75353], [-121.23185, 38.75369], [-121.23132, 38.75434], [-121.23097, 38.75418], [-121.23058, 38.75403], [-121.23016, 38.75392], [-121.22977, 38.75386], [-121.22993, 38.75339], [-121.23034, 38.75346], [-121.2304, 38.75322], [-121.23049, 38.75273], [-121.23058, 38.75271], [-121.23064, 38.75264], [-121.23064, 38.75259], [-121.23062, 38.75254], [-121.23053, 38.7525], [-121.2306, 38.75219], [-121.23271, 38.75219]]]} | Open Access 1 | 48763 | Waltrip Park | 33490 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | https://www.roseville.ca.us/cms/One.aspx?portalId=7964922&pageId=10993299 | Placer 35 | 7.777 | Waltrip Park | 0 | Local Park 2 | 4 |
12462 | 12462 | 12461 | {"type": "Polygon", "coordinates": [[[-121.32842, 38.79859], [-121.32841, 38.7991], [-121.32835, 38.79916], [-121.32623, 38.79916], [-121.32624, 38.79857], [-121.32842, 38.79859]]]} | Open Access 1 | 48761 | Walter and Doris Rickey Park | 33488 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 3.029 | Walter and Doris Rickey Park | 0 | Local Park 2 | 4 | |
3043 | 3043 | 3042 | {"type": "Polygon", "coordinates": [[[-121.34941, 38.79537], [-121.34941, 38.79566], [-121.34879, 38.79586], [-121.34862, 38.796], [-121.34851, 38.79618], [-121.34824, 38.79633], [-121.34805, 38.79653], [-121.348, 38.79653], [-121.34794, 38.79683], [-121.34798, 38.79701], [-121.3479, 38.79713], [-121.34749, 38.79719], [-121.34744, 38.79725], [-121.34706, 38.79734], [-121.34683, 38.79753], [-121.34656, 38.79754], [-121.34599, 38.79788], [-121.34581, 38.79771], [-121.34565, 38.7976], [-121.34545, 38.79749], [-121.34529, 38.79741], [-121.34533, 38.79735], [-121.34552, 38.7966], [-121.34538, 38.79642], [-121.34553, 38.79633], [-121.34575, 38.79591], [-121.34598, 38.79589], [-121.34636, 38.79581], [-121.34659, 38.79572], [-121.34689, 38.7957], [-121.34717, 38.79574], [-121.34798, 38.79538], [-121.34941, 38.79537]]]} | Open Access 1 | 20854 | Veterans Memorial Park | 27032 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 12.582 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
3664 | 3664 | 3663 | {"type": "Polygon", "coordinates": [[[-121.3465, 38.79539], [-121.3411, 38.79543], [-121.3411, 38.79542], [-121.34159, 38.79537], [-121.34265, 38.79521], [-121.34315, 38.7951], [-121.34381, 38.79492], [-121.34428, 38.79475], [-121.34485, 38.79451], [-121.34613, 38.79383], [-121.34649, 38.79424], [-121.3465, 38.79539]]]} | Open Access 1 | 29635 | Veterans Memorial Park | 27032 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 7.926 | Veterans Memorial Park | 0 | Local Park 2 | 4 | |
11372 | 11372 | 11371 | {"type": "Polygon", "coordinates": [[[-121.29551, 38.78167], [-121.29399, 38.78218], [-121.2939, 38.78219], [-121.2938, 38.78217], [-121.29372, 38.78211], [-121.29348, 38.78175], [-121.29328, 38.7815], [-121.29269, 38.78093], [-121.29235, 38.78064], [-121.29208, 38.78043], [-121.2917, 38.78018], [-121.28996, 38.77911], [-121.29048, 38.77858], [-121.29246, 38.77784], [-121.29247, 38.77782], [-121.29243, 38.77779], [-121.29266, 38.7777], [-121.29297, 38.7782], [-121.29304, 38.77839], [-121.29274, 38.77854], [-121.29295, 38.77936], [-121.29331, 38.77931], [-121.2934, 38.77942], [-121.29352, 38.77952], [-121.29366, 38.77961], [-121.29383, 38.77969], [-121.29399, 38.77975], [-121.29416, 38.77978], [-121.29437, 38.7798], [-121.29452, 38.7798], [-121.29456, 38.78], [-121.29467, 38.78], [-121.29551, 38.78167]]]} | Open Access 1 | 22175 | Vencil Brown Park | 26845 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 23.786 | Vencil Brown Park | 0 | Local Park 2 | 4 | |
3044 | 3044 | 3043 | {"type": "Polygon", "coordinates": [[[-121.28919, 38.77703], [-121.28863, 38.77744], [-121.28813, 38.77795], [-121.28803, 38.778], [-121.28791, 38.778], [-121.28718, 38.77778], [-121.28651, 38.77763], [-121.28655, 38.77743], [-121.28663, 38.7774], [-121.28669, 38.77746], [-121.28679, 38.77747], [-121.28692, 38.77744], [-121.28769, 38.7774], [-121.2879, 38.77737], [-121.28811, 38.77731], [-121.28847, 38.77715], [-121.28875, 38.77697], [-121.28886, 38.77692], [-121.28892, 38.77686], [-121.289, 38.77688], [-121.28919, 38.77703]]]} | Open Access 1 | 20876 | Twinwood Park | 26624 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.59 | Twinwood Park | 0 | Local Park 2 | 4 | |
3047 | 3047 | 3046 | {"type": "Polygon", "coordinates": [[[-121.28534, 38.77566], [-121.2842, 38.77584], [-121.28385, 38.7743], [-121.2848, 38.77407], [-121.28497, 38.77405], [-121.28534, 38.77566]]]} | Open Access 1 | 20880 | Sylvia Besana Park | 26154 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 4.479 | Sylvia Besana Park | 0 | Local Park 2 | 4 | |
10921 | 10921 | 10920 | {"type": "Polygon", "coordinates": [[[-121.27193, 38.72703], [-121.2719, 38.72707], [-121.27185, 38.72708], [-121.27094, 38.72708], [-121.2707, 38.72705], [-121.27051, 38.72697], [-121.27035, 38.72685], [-121.27024, 38.72671], [-121.27019, 38.72654], [-121.27018, 38.72645], [-121.27021, 38.72612], [-121.2707, 38.72615], [-121.27071, 38.72557], [-121.27122, 38.72527], [-121.27144, 38.72505], [-121.27154, 38.72489], [-121.27192, 38.72489], [-121.27193, 38.72703]]]} | Open Access 1 | 20926 | Sun Tree Park | 25979 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.473 | Sun Tree Park | 0 | Local Park 2 | 4 | |
3637 | 3637 | 3636 | {"type": "Polygon", "coordinates": [[[-121.29798, 38.79045], [-121.29787, 38.79056], [-121.29647, 38.78955], [-121.29697, 38.78912], [-121.2972, 38.78923], [-121.29802, 38.78946], [-121.29805, 38.78949], [-121.29803, 38.78966], [-121.29802, 38.79021], [-121.298, 38.79026], [-121.29795, 38.79031], [-121.29793, 38.79036], [-121.29795, 38.79041], [-121.29798, 38.79045]]]} | Open Access 1 | 29462 | Summerhill Park | 25959 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 2.889 | Summerhill Park | 0 | Local Park 2 | 4 | |
11373 | 11373 | 11372 | {"type": "Polygon", "coordinates": [[[-121.3201, 38.76275], [-121.31989, 38.76277], [-121.31891, 38.76248], [-121.3187, 38.76226], [-121.31798, 38.76226], [-121.318, 38.76076], [-121.31821, 38.76078], [-121.31846, 38.76086], [-121.31866, 38.76099], [-121.31873, 38.76112], [-121.31887, 38.76119], [-121.31903, 38.7612], [-121.31929, 38.76125], [-121.31942, 38.76125], [-121.31962, 38.76123], [-121.31967, 38.76125], [-121.31975, 38.76153], [-121.31989, 38.76182], [-121.32, 38.76211], [-121.32005, 38.76231], [-121.32001, 38.76243], [-121.32003, 38.76256], [-121.32009, 38.76267], [-121.3201, 38.76275]]]} | Open Access 1 | 22176 | Silverado Oaks Park | 25497 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 6.354 | Silverado Oaks Park | 0 | Local Park 2 | 4 | |
10912 | 10912 | 10911 | {"type": "Polygon", "coordinates": [[[-121.29644, 38.75001], [-121.29609, 38.75022], [-121.29585, 38.74981], [-121.29616, 38.74994], [-121.29644, 38.75001]]]} | Open Access 1 | 20913 | Shirley Ferretti Park | 25415 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.216 | Shirley Ferretti Park | 0 | Local Park 2 | 4 | |
12642 | 12642 | 12641 | {"type": "Polygon", "coordinates": [[[-121.23375, 38.76677], [-121.23373, 38.76704], [-121.2333, 38.76698], [-121.23292, 38.76735], [-121.23232, 38.76763], [-121.2317, 38.76788], [-121.23105, 38.76811], [-121.22949, 38.76852], [-121.22919, 38.76864], [-121.22843, 38.7688], [-121.22828, 38.76894], [-121.22805, 38.76934], [-121.22789, 38.7695], [-121.2274, 38.76968], [-121.22692, 38.76968], [-121.22675, 38.76998], [-121.22677, 38.77033], [-121.22568, 38.77034], [-121.22612, 38.76974], [-121.2261, 38.76952], [-121.22446, 38.76905], [-121.22456, 38.76889], [-121.2247, 38.76876], [-121.22482, 38.76862], [-121.22494, 38.76845], [-121.22497, 38.76835], [-121.22497, 38.76821], [-121.22493, 38.76808], [-121.22472, 38.76779], [-121.22505, 38.76765], [-121.22532, 38.76804], [-121.22568, 38.76821], [-121.22575, 38.76826], [-121.22585, 38.76841], [-121.22598, 38.76882], [-121.22593, 38.76886], [-121.22621, 38.76924], [-121.22715, 38.76899], [-121.2277, 38.76851], [-121.22791, 38.76837], [-121.22838, 38.76813], [-121.22865, 38.76804], [-121.22891, 38.76798], [-121.23007, 38.7678], [-121.23105, 38.76724], [-121.23083, 38.76692], [-121.23118, 38.76679], [-121.23147, 38.76718], [-121.23193, 38.76712], [-121.23215, 38.76691], [-121.23228, 38.76661], [-121.23231, 38.7665], [-121.23236, 38.76643], [-121.23263, 38.76653], [-121.23299, 38.76663], [-121.23335, 38.76671], [-121.23375, 38.76677]]]} | Open Access 1 | 29469 | Secret Ravine Park | 25281 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 18.508 | Secret Ravine Park | 0 | Local Park 2 | 4 | |
12626 | 12626 | 12625 | {"type": "Polygon", "coordinates": [[[-121.26237, 38.75515], [-121.26208, 38.75534], [-121.26154, 38.75545], [-121.26146, 38.75549], [-121.26132, 38.75524], [-121.26189, 38.75488], [-121.26206, 38.75493], [-121.26237, 38.75515]]]} | Open Access 1 | 29477 | Sculpture Park | 25220 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 0.815 | Sculpture Park | 0 | Local Park 2 | 4 | |
14290 | 14290 | 14289 | {"type": "Polygon", "coordinates": [[[-121.35845, 38.79005], [-121.35832, 38.79005], [-121.35801, 38.78987], [-121.35768, 38.78982], [-121.35753, 38.78978], [-121.35739, 38.78972], [-121.35714, 38.78957], [-121.35687, 38.78944], [-121.35657, 38.78937], [-121.3568, 38.78856], [-121.35699, 38.78751], [-121.35759, 38.78756], [-121.35844, 38.78756], [-121.35845, 38.79005]]]} | Restricted Access 2 | 44224 | School House Park | 31647 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 8.706 | School House Park | 0 | Local Park 2 | 4 | |
12646 | 12646 | 12645 | {"type": "MultiPolygon", "coordinates": [[[[-121.28756, 38.7378], [-121.28714, 38.7382], [-121.28686, 38.73842], [-121.28655, 38.73872], [-121.28634, 38.7391], [-121.28621, 38.73939], [-121.2859, 38.73951], [-121.2857, 38.73966], [-121.28558, 38.73989], [-121.28541, 38.73989], [-121.2852, 38.74024], [-121.2851, 38.74025], [-121.2851, 38.74041], [-121.28509, 38.74041], [-121.28465, 38.74133], [-121.28396, 38.74288], [-121.28397, 38.74289], [-121.28403, 38.7429], [-121.28403, 38.74386], [-121.28266, 38.74384], [-121.2826, 38.74382], [-121.28258, 38.74378], [-121.28259, 38.74216], [-121.28252, 38.74214], [-121.28253, 38.7407], [-121.2834, 38.74074], [-121.28341, 38.74], [-121.28348, 38.7399], [-121.28406, 38.7399], [-121.28419, 38.7398], [-121.28419, 38.73974], [-121.28477, 38.73949], [-121.28494, 38.73905], [-121.28513, 38.73878], [-121.28578, 38.73851], [-121.28643, 38.73781], [-121.28756, 38.7378]]], [[[-121.28933, 38.73623], [-121.28922, 38.73665], [-121.28846, 38.73666], [-121.28846, 38.73686], [-121.28862, 38.73686], [-121.28856, 38.737], [-121.28856, 38.73713], [-121.28846, 38.73714], [-121.28829, 38.73733], [-121.28805, 38.73725], [-121.28753, 38.73769], [-121.28694, 38.7377], [-121.28738, 38.73735], [-121.28776, 38.73714], [-121.28804, 38.73687], [-121.2883, 38.73666], [-121.2884, 38.73666], [-121.28865, 38.73635], [-121.28875, 38.7362], [-121.28931, 38.73527], [-121.28927, 38.73609], [-121.28933, 38.73623]]]]} | Open Access 1 | 29481 | Saugstad Park | 25169 | 1285 | Roseville, City of 540 | City 2 | City Agency 2 | http://www.roseville.ca.us/parks/default.asp | City 2 | 1285 | Roseville, City of 533 | City 2 | City Agency 2 | Placer 35 | 25.464 | Saugstad 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]);