units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
48 rows where MNG_AGENCY = 557 sorted by ACRES
This data as json, copyable, CSV (advanced)
Suggested facets: GAP_STS
DES_TP 8
- Local Park 40
- Local Recreation Area 2
- Local Conservation Area 1
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
MNG_AG_TYP 1
- City Agency 48
MNG_AGENCY 1
- Folsom, City of · 48 ✖
ACCESS_TYP 1
- Open Access 48
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5559 | 5559 | 5558 | {"type": "Polygon", "coordinates": [[[-121.13133, 38.67036], [-121.13127, 38.67052], [-121.13089, 38.67043], [-121.1309, 38.67038], [-121.131, 38.67022], [-121.13133, 38.67036]]]} | Open Access 1 | 48755 | Keller Mini Park | 33482 | 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 | https://www.folsom.ca.us/parks/parks_n_trails/parks/parklist/keller_mini_park.asp | Sacramento 41 | 0.183 | Keller MP | 0 | Local Park 2 | 4 |
3338 | 3338 | 3337 | {"type": "Polygon", "coordinates": [[[-121.12981, 38.6697], [-121.12977, 38.6698], [-121.12975, 38.66993], [-121.12935, 38.66996], [-121.12938, 38.66986], [-121.12937, 38.66974], [-121.12981, 38.6697]]]} | Open Access 1 | 23929 | Wellfleet Park | 27342 | 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.213 | Wellfleet 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 | |
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 | |
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 | |
11613 | 11613 | 11612 | {"type": "Polygon", "coordinates": [[[-121.11447, 38.68345], [-121.11414, 38.68353], [-121.11396, 38.6832], [-121.1143, 38.68307], [-121.11441, 38.68336], [-121.11447, 38.68345]]]} | Open Access 1 | 23907 | Village F Tot Lot | 27110 | 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.322 | Village F Tot Lot | 0 | Local Recreation Area 3 | 4 | |
8015 | 8015 | 8014 | {"type": "Polygon", "coordinates": [[[-121.16735, 38.66105], [-121.16729, 38.66103], [-121.16722, 38.66095], [-121.16713, 38.66092], [-121.16701, 38.66095], [-121.16695, 38.66101], [-121.16677, 38.66081], [-121.16723, 38.66056], [-121.16735, 38.66105]]]} | Open Access 1 | 36032 | Steeplechase Mini Park | 25824 | 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.327 | Steeplechase MP | 0 | Local Park 2 | 4 | |
2974 | 2974 | 2973 | {"type": "Polygon", "coordinates": [[[-121.1801, 38.67178], [-121.17942, 38.67217], [-121.17925, 38.672], [-121.17993, 38.6716], [-121.1801, 38.67178]]]} | Open Access 1 | 23923 | Garden Club Mini-Park | 19196 | 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.45 | Garden Club Mini-Park | 0 | Local Park 2 | 4 | |
11594 | 11594 | 11593 | {"type": "Polygon", "coordinates": [[[-121.15872, 38.6682], [-121.15835, 38.66856], [-121.15794, 38.6684], [-121.15817, 38.66803], [-121.15848, 38.66816], [-121.15859, 38.66812], [-121.15865, 38.66817], [-121.15872, 38.6682]]]} | Open Access 1 | 23933 | The Shores Mini-Park | 26293 | 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.529 | The Shores Mini-Park | 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 | |
11609 | 11609 | 11608 | {"type": "Polygon", "coordinates": [[[-121.17423, 38.70487], [-121.17406, 38.70487], [-121.17307, 38.70486], [-121.17332, 38.7046], [-121.17361, 38.70437], [-121.17423, 38.70487]]]} | Open Access 1 | 23888 | Hannaford Family Park | 19642 | 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.704 | Hannaford Family 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 | |
11610 | 11610 | 11609 | {"type": "Polygon", "coordinates": [[[-121.17683, 38.70288], [-121.17651, 38.70298], [-121.17646, 38.70315], [-121.1763, 38.70328], [-121.17532, 38.70339], [-121.17573, 38.70321], [-121.17622, 38.70278], [-121.17673, 38.70266], [-121.17683, 38.70288]]]} | Open Access 1 | 23890 | Egloff Family Park | 18466 | 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.913 | Egloff Family Park | 0 | Local Park 2 | 4 | |
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 | |
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 | |
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 | |
13666 | 13666 | 13665 | {"type": "Polygon", "coordinates": [[[-121.13747, 38.65905], [-121.13743, 38.65909], [-121.1374, 38.65916], [-121.13744, 38.65929], [-121.13747, 38.65987], [-121.13746, 38.6599], [-121.13741, 38.65992], [-121.1371, 38.65995], [-121.1366, 38.65995], [-121.13661, 38.6598], [-121.13684, 38.65958], [-121.13692, 38.65944], [-121.13695, 38.65929], [-121.13691, 38.65911], [-121.13747, 38.65905]]]} | Open Access 1 | 36031 | Kentfield Park | 20621 | 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.303 | Kentfield 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 | |
8016 | 8016 | 8015 | {"type": "Polygon", "coordinates": [[[-121.14188, 38.66142], [-121.14183, 38.6616], [-121.14174, 38.66177], [-121.14138, 38.66219], [-121.14133, 38.66221], [-121.14101, 38.66216], [-121.14073, 38.66217], [-121.14067, 38.66215], [-121.14066, 38.66211], [-121.14074, 38.66195], [-121.14082, 38.66175], [-121.14087, 38.66144], [-121.14188, 38.66142]]]} | Open Access 1 | 36033 | Windsor Mini Park | 27635 | 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.608 | Windsor MP | 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]);