units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 557
This data as json, copyable, CSV (advanced)
DES_TP 4
MNG_AG_TYP 1
- City Agency 28
MNG_AGENCY 1
- Folsom, City of · 28 ✖
ACCESS_TYP 1
- Open Access 28
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11627 | 11627 | 11626 | {"type": "Polygon", "coordinates": [[[-121.12359, 38.68019], [-121.12356, 38.68021], [-121.12351, 38.68016], [-121.12345, 38.68015], [-121.12335, 38.68015], [-121.12329, 38.68019], [-121.12319, 38.68028], [-121.12297, 38.68035], [-121.12292, 38.68032], [-121.1228, 38.68016], [-121.12265, 38.68001], [-121.12263, 38.67996], [-121.12291, 38.6797], [-121.12305, 38.67961], [-121.12318, 38.67954], [-121.12328, 38.67978], [-121.12359, 38.68019]]]} | Open Access 1 | 23910 | Village D Tot Lot | 27109 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.921 | Village D Tot Lot | 0 | Local Recreation Area 3 | 4 | |
11629 | 11629 | 11628 | {"type": "Polygon", "coordinates": [[[-121.15031, 38.67504], [-121.15026, 38.6766], [-121.15029, 38.67661], [-121.15029, 38.67829], [-121.14833, 38.67827], [-121.14833, 38.67783], [-121.14832, 38.67773], [-121.14825, 38.67755], [-121.14811, 38.67737], [-121.14855, 38.6771], [-121.14855, 38.67707], [-121.14857, 38.67705], [-121.14834, 38.67661], [-121.14442, 38.6766], [-121.14442, 38.67481], [-121.14733, 38.67377], [-121.14777, 38.67356], [-121.14817, 38.67332], [-121.14919, 38.67436], [-121.14985, 38.67401], [-121.15031, 38.67389], [-121.15031, 38.67504]]]} | Open Access 1 | 23913 | Ed Mitchell Park | 18423 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 43.35 | Ed Mitchell Park | 0 | Local Park 2 | 4 | |
11631 | 11631 | 11630 | {"type": "Polygon", "coordinates": [[[-121.12584, 38.67598], [-121.12581, 38.67603], [-121.12575, 38.67598], [-121.12555, 38.67594], [-121.12528, 38.67597], [-121.12501, 38.67604], [-121.12495, 38.67602], [-121.12419, 38.67487], [-121.12414, 38.67482], [-121.12407, 38.67479], [-121.12395, 38.67479], [-121.12352, 38.67496], [-121.12365, 38.6747], [-121.1237, 38.67451], [-121.1237, 38.67432], [-121.1231, 38.67432], [-121.12334, 38.67337], [-121.12471, 38.67234], [-121.12503, 38.67222], [-121.12556, 38.67343], [-121.12568, 38.67381], [-121.12572, 38.67418], [-121.12573, 38.67545], [-121.12584, 38.67546], [-121.12584, 38.67598]]]} | Open Access 1 | 23915 | Phillip C Cohn Park | 23642 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 14.64 | Phillip C Cohn Park | 0 | Local Park 2 | 4 | |
11632 | 11632 | 11631 | {"type": "Polygon", "coordinates": [[[-121.13896, 38.67427], [-121.13636, 38.67427], [-121.13586, 38.67265], [-121.13831, 38.67219], [-121.13896, 38.67427]]]} | Open Access 1 | 23916 | Cummings Family Park | 17858 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 11.458 | Cummings Family Park | 0 | Local Park 2 | 4 | |
11634 | 11634 | 11633 | {"type": "Polygon", "coordinates": [[[-121.12635, 38.67233], [-121.12635, 38.67346], [-121.12583, 38.67357], [-121.12574, 38.67331], [-121.12541, 38.67258], [-121.12635, 38.67233]]]} | Open Access 1 | 23920 | Folsom Kids Play | 18968 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 1.907 | Folsom Kids Play | None 1036 | |||
11635 | 11635 | 11634 | {"type": "Polygon", "coordinates": [[[-121.17999, 38.67309], [-121.17886, 38.67374], [-121.17857, 38.67343], [-121.1797, 38.67278], [-121.17999, 38.67309]]]} | Open Access 1 | 23921 | Granite Mini-Park | 19430 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 1.281 | Granite Mini-Park | 0 | Local Park 2 | 4 | |
11638 | 11638 | 11637 | {"type": "Polygon", "coordinates": [[[-121.13005, 38.67106], [-121.12971, 38.67103], [-121.12961, 38.67088], [-121.12975, 38.67083], [-121.13, 38.67084], [-121.13, 38.67096], [-121.13005, 38.67106]]]} | Open Access 1 | 23926 | Chadwick Mini-Park | 17110 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.173 | Chadwick Mini-Park | 0 | Local Park 2 | 4 | |
11639 | 11639 | 11638 | {"type": "Polygon", "coordinates": [[[-121.12504, 38.67044], [-121.12501, 38.67055], [-121.12478, 38.67063], [-121.12441, 38.67053], [-121.12449, 38.67034], [-121.12504, 38.67044]]]} | Open Access 1 | 23927 | Prewett Mini-Park | 23998 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.275 | Prewett Mini-Park | 0 | Local Park 2 | 4 | |
11640 | 11640 | 11639 | {"type": "Polygon", "coordinates": [[[-121.12715, 38.66977], [-121.12702, 38.67006], [-121.12671, 38.67012], [-121.12685, 38.6697], [-121.12715, 38.66977]]]} | Open Access 1 | 23928 | Cambridge Place Mini-Park | 16753 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.257 | Cambridge Place Mini-Park | 0 | Local Park 2 | 4 | |
11641 | 11641 | 11640 | {"type": "Polygon", "coordinates": [[[-121.13071, 38.66933], [-121.1307, 38.66962], [-121.13044, 38.66966], [-121.13031, 38.66965], [-121.13047, 38.66934], [-121.13071, 38.66933]]]} | Open Access 1 | 23930 | Thorndike Mini-Park | 26319 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.237 | Thorndike Mini-Park | 0 | Local Park 2 | 4 | |
11642 | 11642 | 11641 | {"type": "Polygon", "coordinates": [[[-121.16329, 38.66558], [-121.16312, 38.66576], [-121.16291, 38.66628], [-121.16272, 38.66723], [-121.16248, 38.66887], [-121.16232, 38.66971], [-121.16164, 38.66947], [-121.16133, 38.66934], [-121.16099, 38.66916], [-121.16063, 38.66892], [-121.1604, 38.66872], [-121.16023, 38.66853], [-121.16005, 38.66829], [-121.15992, 38.66809], [-121.15982, 38.66787], [-121.15974, 38.66765], [-121.15969, 38.66742], [-121.15967, 38.66715], [-121.15968, 38.66678], [-121.15978, 38.66637], [-121.15987, 38.66615], [-121.16032, 38.66526], [-121.16041, 38.66503], [-121.16233, 38.66505], [-121.16329, 38.66558]]]} | Open Access 1 | 23931 | Lembi Park | 21149 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 27.912 | Lembi Park | 0 | Local Park 2 | 4 | |
11643 | 11643 | 11642 | {"type": "Polygon", "coordinates": [[[-121.16982, 38.66883], [-121.16978, 38.6691], [-121.16976, 38.66913], [-121.16934, 38.66897], [-121.16882, 38.6688], [-121.16893, 38.66858], [-121.16861, 38.66809], [-121.1666, 38.66744], [-121.1668, 38.66731], [-121.16688, 38.6673], [-121.16692, 38.66732], [-121.16702, 38.66744], [-121.16712, 38.66752], [-121.16736, 38.66764], [-121.1675, 38.66768], [-121.16808, 38.6678], [-121.16837, 38.6679], [-121.16859, 38.66802], [-121.16874, 38.66813], [-121.16891, 38.66828], [-121.1691, 38.66851], [-121.16929, 38.66866], [-121.16951, 38.66877], [-121.16982, 38.66883]]]} | Open Access 1 | 23932 | Reflections Mini-Park | 24267 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 1.332 | Reflections Mini-Park | 0 | Local Park 2 | 4 | |
11644 | 11644 | 11643 | {"type": "Polygon", "coordinates": [[[-121.17184, 38.66778], [-121.1718, 38.66784], [-121.17181, 38.66791], [-121.17153, 38.66807], [-121.17146, 38.66801], [-121.17126, 38.66813], [-121.17122, 38.66822], [-121.17117, 38.66822], [-121.17117, 38.66808], [-121.17094, 38.66783], [-121.17065, 38.66775], [-121.17069, 38.66771], [-121.17086, 38.66776], [-121.17121, 38.66764], [-121.17141, 38.66753], [-121.17143, 38.66746], [-121.17149, 38.66746], [-121.17151, 38.66752], [-121.17165, 38.66764], [-121.17184, 38.66778]]]} | Open Access 1 | 23934 | Cobble Hills Mini-Park | 17469 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.874 | Cobble Hills Mini-Park | 0 | Local Park 2 | 4 | |
11645 | 11645 | 11644 | {"type": "Polygon", "coordinates": [[[-121.11828, 38.66715], [-121.1183, 38.66717], [-121.11853, 38.66793], [-121.11854, 38.66805], [-121.11853, 38.6682], [-121.11845, 38.66839], [-121.11838, 38.66851], [-121.11828, 38.66861], [-121.11805, 38.66876], [-121.11791, 38.66882], [-121.11786, 38.66882], [-121.11782, 38.66879], [-121.11777, 38.66867], [-121.1177, 38.66854], [-121.11759, 38.66841], [-121.11746, 38.6683], [-121.11739, 38.66815], [-121.11731, 38.6681], [-121.11722, 38.66808], [-121.11724, 38.66769], [-121.1173, 38.66768], [-121.11719, 38.66724], [-121.11726, 38.6672], [-121.11735, 38.66719], [-121.11771, 38.66719], [-121.11822, 38.66714], [-121.11828, 38.66715]]]} | Open Access 1 | 23935 | Beacon Hill Park | 15912 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 3.921 | Beacon Hill Park | 0 | Local Park 2 | 4 | |
11651 | 11651 | 11650 | {"type": "Polygon", "coordinates": [[[-121.16447, 38.66015], [-121.16396, 38.66034], [-121.16375, 38.6604], [-121.1637, 38.66036], [-121.16362, 38.6602], [-121.1636, 38.66011], [-121.16354, 38.66005], [-121.16347, 38.66003], [-121.16341, 38.66002], [-121.16329, 38.66007], [-121.16282, 38.66017], [-121.16275, 38.65989], [-121.16298, 38.65993], [-121.16299, 38.65991], [-121.1631, 38.65991], [-121.16319, 38.65985], [-121.16339, 38.65984], [-121.16339, 38.65981], [-121.16333, 38.6598], [-121.16334, 38.65973], [-121.16343, 38.65974], [-121.16342, 38.65982], [-121.16345, 38.65984], [-121.16355, 38.65975], [-121.16363, 38.65974], [-121.1637, 38.65975], [-121.16372, 38.65973], [-121.16363, 38.65963], [-121.16363, 38.65959], [-121.16366, 38.65956], [-121.16378, 38.65949], [-121.16399, 38.65949], [-121.16414, 38.65964], [-121.16447, 38.66015]]]} | Open Access 1 | 23943 | Levy Park | 21189 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 1.727 | Levy Park | 0 | Local Park 2 | 4 | |
11653 | 11653 | 11652 | {"type": "Polygon", "coordinates": [[[-121.13351, 38.65401], [-121.13239, 38.65577], [-121.13183, 38.65569], [-121.13133, 38.65529], [-121.13072, 38.65542], [-121.13002, 38.65532], [-121.13, 38.65538], [-121.12965, 38.65538], [-121.12934, 38.65542], [-121.12926, 38.65525], [-121.12914, 38.65503], [-121.1287, 38.6544], [-121.12872, 38.65439], [-121.12872, 38.65434], [-121.12875, 38.65431], [-121.12874, 38.65429], [-121.1289, 38.65419], [-121.12966, 38.65385], [-121.1299, 38.65372], [-121.13013, 38.65354], [-121.13039, 38.65328], [-121.13066, 38.6531], [-121.13088, 38.653], [-121.13105, 38.65294], [-121.13125, 38.65289], [-121.13148, 38.65287], [-121.13183, 38.65287], [-121.13231, 38.65295], [-121.13265, 38.65297], [-121.13266, 38.65338], [-121.1329, 38.65345], [-121.13307, 38.65355], [-121.13319, 38.65367], [-121.13327, 38.65383], [-121.13351, 38.65401]]]} | Open Access 1 | 23945 | John Kemp Park | 20449 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 21.237 | John Kemp Park | 0 | Local Park 2 | 4 | |
11656 | 11656 | 11655 | {"type": "Polygon", "coordinates": [[[-121.11773, 38.65248], [-121.11711, 38.65274], [-121.11703, 38.65268], [-121.11692, 38.65267], [-121.11685, 38.6527], [-121.11677, 38.65277], [-121.1167, 38.6528], [-121.11505, 38.65312], [-121.115, 38.6531], [-121.11486, 38.65258], [-121.11474, 38.65237], [-121.11459, 38.6522], [-121.11424, 38.65195], [-121.11421, 38.65191], [-121.11422, 38.65188], [-121.11442, 38.65168], [-121.11463, 38.65141], [-121.11475, 38.65129], [-121.11498, 38.65112], [-121.11508, 38.65106], [-121.11514, 38.65105], [-121.11549, 38.65128], [-121.11576, 38.65142], [-121.11606, 38.65151], [-121.11674, 38.65166], [-121.11697, 38.65175], [-121.11714, 38.65184], [-121.1173, 38.65194], [-121.11749, 38.65211], [-121.11761, 38.65226], [-121.11773, 38.65248]]]} | Open Access 1 | 23947 | Handy Family Park | 19636 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 9.699 | Handy Family Park | 0 | Local Park 2 | 4 | |
11658 | 11658 | 11657 | {"type": "Polygon", "coordinates": [[[-121.17151, 38.65191], [-121.17131, 38.65238], [-121.17125, 38.65242], [-121.1709, 38.65236], [-121.17078, 38.65228], [-121.17061, 38.65211], [-121.17083, 38.65198], [-121.17109, 38.65165], [-121.17148, 38.65186], [-121.17151, 38.65191]]]} | Open Access 1 | 23949 | Natoma Station Mini-Park A | 22665 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.955 | Natoma Station Mini-Park A | 0 | Local Park 2 | 4 | |
11660 | 11660 | 11659 | {"type": "Polygon", "coordinates": [[[-121.17553, 38.64735], [-121.17484, 38.64761], [-121.17467, 38.64727], [-121.17537, 38.64706], [-121.17553, 38.64735]]]} | Open Access 1 | 23951 | Natoma Station Mini-Park B | 22666 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 0.623 | Natoma Station Mini-Park B | 0 | Local Park 2 | 4 | |
11698 | 11698 | 11697 | {"type": "Polygon", "coordinates": [[[-121.17143, 38.6819], [-121.16923, 38.68317], [-121.16786, 38.68172], [-121.1685, 38.68135], [-121.16871, 38.68109], [-121.16871, 38.68107], [-121.16892, 38.68082], [-121.1699, 38.68026], [-121.17143, 38.6819]]]} | Open Access 1 | 23995 | Rodeo Park | 24550 | 1108 | Folsom, City of 565 | City 2 | City Agency 2 | http://www.folsom.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1108 | Folsom, City of 557 | City 2 | City Agency 2 | Sacramento 41 | 12.723 | Rodeo 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]);