units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where DES_TP = 2 and MNG_AGENCY = 494
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Southgate Recreation and Park District · 14 ✖
DES_TP 1
- Local Park · 14 ✖
ACCESS_TYP 1
- Open Access 14
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11734 | 11734 | 11733 | {"type": "Polygon", "coordinates": [[[-121.38473, 38.47813], [-121.38438, 38.47832], [-121.38416, 38.47851], [-121.38395, 38.47878], [-121.38388, 38.47893], [-121.38382, 38.47911], [-121.3834, 38.47904], [-121.3834, 38.4783], [-121.38308, 38.47836], [-121.38305, 38.47832], [-121.38301, 38.47828], [-121.38288, 38.47826], [-121.38288, 38.47802], [-121.38233, 38.47802], [-121.38227, 38.47773], [-121.38243, 38.47769], [-121.38257, 38.47764], [-121.38282, 38.47751], [-121.38303, 38.47758], [-121.38289, 38.47787], [-121.38289, 38.47789], [-121.38339, 38.47794], [-121.3834, 38.4779], [-121.38455, 38.47791], [-121.38473, 38.47813]]]} | Open Access 1 | 24029 | Southwoods Park | 25705 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 3.493 | Southwoods Park | 0 | Local Park 2 | 4 | |
11738 | 11738 | 11737 | {"type": "Polygon", "coordinates": [[[-121.3995, 38.47407], [-121.39941, 38.47407], [-121.39939, 38.47307], [-121.39876, 38.47307], [-121.39876, 38.47407], [-121.39739, 38.47408], [-121.39733, 38.47406], [-121.3973, 38.47402], [-121.39729, 38.47356], [-121.39727, 38.47329], [-121.39726, 38.47286], [-121.39727, 38.47283], [-121.39733, 38.4728], [-121.3981, 38.47278], [-121.39887, 38.47267], [-121.39902, 38.47268], [-121.39912, 38.47263], [-121.39916, 38.47256], [-121.39949, 38.47256], [-121.3995, 38.47407]]]} | Open Access 1 | 24030 | Norman Waters Park | 22799 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.661 | Norman Waters Park | 0 | Local Park 2 | 4 | |
11739 | 11739 | 11738 | {"type": "Polygon", "coordinates": [[[-121.40509, 38.47026], [-121.40506, 38.4703], [-121.40501, 38.47032], [-121.4039, 38.47032], [-121.40385, 38.47031], [-121.40383, 38.47028], [-121.40382, 38.47003], [-121.40418, 38.47002], [-121.40418, 38.46973], [-121.40509, 38.46972], [-121.40509, 38.47026]]]} | Open Access 1 | 24031 | Willowood Park | 27593 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.53 | Willowood Park | 0 | Local Park 2 | 4 | |
11740 | 11740 | 11739 | {"type": "Polygon", "coordinates": [[[-121.36573, 38.47003], [-121.36487, 38.47003], [-121.36487, 38.46908], [-121.36488, 38.46905], [-121.36492, 38.46903], [-121.36572, 38.46903], [-121.36573, 38.47003]]]} | Open Access 1 | 24032 | Carlisle Woods Park | 16857 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 2.053 | Carlisle Woods Park | 0 | Local Park 2 | 4 | |
11741 | 11741 | 11740 | {"type": "Polygon", "coordinates": [[[-121.38663, 38.46532], [-121.38661, 38.46533], [-121.38661, 38.46559], [-121.38657, 38.46562], [-121.38653, 38.46568], [-121.38654, 38.46574], [-121.38658, 38.46578], [-121.38641, 38.46592], [-121.38585, 38.46606], [-121.38558, 38.46532], [-121.3859, 38.46532], [-121.38648, 38.46505], [-121.38654, 38.46507], [-121.38662, 38.46507], [-121.38663, 38.46532]]]} | Open Access 1 | 24033 | Cottonwood Park | 17692 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.648 | Cottonwood Park | 0 | Local Park 2 | 4 | |
11742 | 11742 | 11741 | {"type": "Polygon", "coordinates": [[[-121.38097, 38.46416], [-121.38097, 38.46466], [-121.38093, 38.46494], [-121.38088, 38.46509], [-121.38078, 38.46526], [-121.38066, 38.46542], [-121.38057, 38.46551], [-121.38045, 38.46561], [-121.38027, 38.46573], [-121.38009, 38.46581], [-121.37988, 38.46589], [-121.37948, 38.46596], [-121.37922, 38.46597], [-121.37909, 38.46595], [-121.37907, 38.46592], [-121.37907, 38.46456], [-121.37911, 38.46445], [-121.37909, 38.46439], [-121.3792, 38.46433], [-121.37929, 38.46416], [-121.38097, 38.46416]]]} | Open Access 1 | 24034 | Vintage Park | 27150 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.991 | Vintage Park | 0 | Local Park 2 | 4 | |
11743 | 11743 | 11742 | {"type": "Polygon", "coordinates": [[[-121.39967, 38.46301], [-121.39954, 38.46311], [-121.39947, 38.46347], [-121.39762, 38.46348], [-121.39765, 38.46193], [-121.39833, 38.46206], [-121.39877, 38.46208], [-121.39889, 38.46224], [-121.39911, 38.46246], [-121.39936, 38.46276], [-121.39967, 38.46301]]]} | Open Access 1 | 24035 | Toby Johnson Park | 26382 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 5.704 | Toby Johnson Park | 0 | Local Park 2 | 4 | |
11744 | 11744 | 11743 | {"type": "Polygon", "coordinates": [[[-121.40565, 38.45943], [-121.40393, 38.45988], [-121.4039, 38.45984], [-121.40385, 38.45943], [-121.40346, 38.45942], [-121.40344, 38.45854], [-121.40239, 38.45852], [-121.40238, 38.4582], [-121.40236, 38.45803], [-121.40231, 38.45783], [-121.40222, 38.45762], [-121.40223, 38.45758], [-121.40227, 38.45755], [-121.40258, 38.45749], [-121.40277, 38.45747], [-121.40306, 38.45748], [-121.40345, 38.45755], [-121.40409, 38.45774], [-121.40427, 38.45778], [-121.40452, 38.45781], [-121.40499, 38.45781], [-121.40503, 38.45783], [-121.40507, 38.45787], [-121.40515, 38.45827], [-121.4053, 38.45873], [-121.40543, 38.45904], [-121.40565, 38.45943]]]} | Open Access 1 | 24037 | Countryside Comm. Park | 17707 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 11.163 | Countryside Comm. Park | 0 | Local Park 2 | 4 | |
11745 | 11745 | 11744 | {"type": "Polygon", "coordinates": [[[-121.3844, 38.45687], [-121.38428, 38.45693], [-121.38383, 38.45695], [-121.38348, 38.45707], [-121.38347, 38.45965], [-121.38194, 38.45553], [-121.38217, 38.45547], [-121.38219, 38.45568], [-121.38225, 38.4559], [-121.38258, 38.45677], [-121.38259, 38.45689], [-121.38265, 38.45695], [-121.38275, 38.45697], [-121.38285, 38.45694], [-121.38287, 38.45694], [-121.38291, 38.45691], [-121.38313, 38.45685], [-121.384, 38.45652], [-121.38405, 38.45651], [-121.38409, 38.45653], [-121.3844, 38.45687]]]} | Open Access 1 | 24038 | Hardester Park | 19674 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 4.804 | Hardester Park | 0 | Local Park 2 | 4 | |
11747 | 11747 | 11746 | {"type": "MultiPolygon", "coordinates": [[[[-121.32598, 38.45603], [-121.32593, 38.45607], [-121.32592, 38.45613], [-121.32599, 38.45629], [-121.32599, 38.45681], [-121.32597, 38.45684], [-121.32593, 38.45686], [-121.32555, 38.4569], [-121.32531, 38.45695], [-121.32508, 38.45702], [-121.32483, 38.45713], [-121.32478, 38.45712], [-121.32474, 38.4571], [-121.32435, 38.45667], [-121.32427, 38.45652], [-121.3242, 38.45629], [-121.32419, 38.45585], [-121.32572, 38.45585], [-121.32572, 38.45599], [-121.32587, 38.45599], [-121.32598, 38.45603]]], [[[-121.38888, 38.45574], [-121.38855, 38.45574], [-121.38854, 38.45632], [-121.38821, 38.45632], [-121.38824, 38.45615], [-121.38823, 38.4561], [-121.38818, 38.45605], [-121.38807, 38.45602], [-121.38795, 38.45605], [-121.3878, 38.45605], [-121.38776, 38.45603], [-121.38773, 38.456], [-121.38774, 38.4555], [-121.38778, 38.45545], [-121.3883, 38.45546], [-121.38838, 38.45541], [-121.38839, 38.45534], [-121.38846, 38.45534], [-121.38887, 38.45523], [-121.38888, 38.45574]]]]} | Open Access 1 | 24040 | Calvine Station Park | 31996 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.167 | Calvine Station Park | 0 | Local Park 2 | 4 | |
11748 | 11748 | 11747 | {"type": "Polygon", "coordinates": [[[-121.38097, 38.45391], [-121.3804, 38.45392], [-121.3804, 38.45423], [-121.38019, 38.45451], [-121.38019, 38.45463], [-121.38041, 38.45474], [-121.38041, 38.4549], [-121.38034, 38.45494], [-121.38031, 38.455], [-121.38032, 38.4551], [-121.38031, 38.45516], [-121.38022, 38.45531], [-121.38011, 38.45541], [-121.37966, 38.45577], [-121.37962, 38.45578], [-121.37958, 38.45578], [-121.37905, 38.45537], [-121.37879, 38.45513], [-121.37858, 38.45486], [-121.3784, 38.45454], [-121.37829, 38.45424], [-121.37824, 38.45392], [-121.37826, 38.45279], [-121.37832, 38.45274], [-121.37857, 38.45277], [-121.379, 38.45277], [-121.37923, 38.45274], [-121.38054, 38.45275], [-121.38097, 38.45391]]]} | Open Access 1 | 24041 | Illa Collin Park | 20176 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 13.842 | Illa Collin Park | 0 | Local Park 2 | 4 | |
11749 | 11749 | 11748 | {"type": "Polygon", "coordinates": [[[-121.36203, 38.45362], [-121.36203, 38.45434], [-121.362, 38.45438], [-121.36174, 38.45448], [-121.36168, 38.45444], [-121.36088, 38.45376], [-121.36073, 38.4536], [-121.36203, 38.45362]]]} | Open Access 1 | 24042 | Vineyard Park | 27139 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 1.66 | Vineyard Park | 0 | Local Park 2 | 4 | |
14266 | 14266 | 14265 | {"type": "Polygon", "coordinates": [[[-121.35779, 38.45983], [-121.35779, 38.4599], [-121.35724, 38.45991], [-121.35723, 38.46], [-121.35685, 38.46011], [-121.3564, 38.46016], [-121.3562, 38.46001], [-121.35594, 38.46023], [-121.35562, 38.4601], [-121.35525, 38.46002], [-121.355, 38.46], [-121.35432, 38.45999], [-121.35428, 38.45996], [-121.35426, 38.45993], [-121.35428, 38.45884], [-121.35554, 38.45884], [-121.35555, 38.45888], [-121.35588, 38.45889], [-121.35588, 38.45896], [-121.35585, 38.45902], [-121.35585, 38.45907], [-121.35587, 38.45912], [-121.35591, 38.45917], [-121.35602, 38.4592], [-121.35614, 38.45918], [-121.35638, 38.45919], [-121.35638, 38.45934], [-121.3563, 38.45971], [-121.35631, 38.45983], [-121.35664, 38.45983], [-121.35667, 38.45982], [-121.35672, 38.45985], [-121.3568, 38.45987], [-121.35685, 38.45985], [-121.35691, 38.45982], [-121.35693, 38.45983], [-121.35755, 38.45983], [-121.35757, 38.45982], [-121.35762, 38.45985], [-121.35768, 38.45986], [-121.35779, 38.45983]]]} | Open Access 1 | 44186 | Cochran Park | 17471 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 6.249 | Cochran Park | 0 | Local Park 2 | 4 | |
14267 | 14267 | 14266 | {"type": "Polygon", "coordinates": [[[-121.35398, 38.45993], [-121.35397, 38.46027], [-121.35228, 38.46041], [-121.35222, 38.46381], [-121.35161, 38.46378], [-121.35101, 38.46378], [-121.35101, 38.46338], [-121.351, 38.46337], [-121.35101, 38.46333], [-121.35102, 38.4618], [-121.35105, 38.46135], [-121.35105, 38.45992], [-121.35398, 38.45993]]]} | Open Access 1 | 44187 | Churchill Downs Community Park | 17250 | 2160 | Southgate Recreation and Park District 502 | Special District 4 | Recreation/Parks District 4 | http://www.southgaterecandpark.net/ | Special District 4 | 2160 | Southgate Recreation and Park District 494 | Special District 4 | Recreation/Parks District 4 | Sacramento 41 | 12.989 | Churchill Downs 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]);