units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
192 rows where DES_TP = 2 and MNG_AGENCY = 534 sorted by LABEL_NAME descending
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
ACCESS_TYP 2
- Open Access 190
- Restricted Access 2
MNG_AG_TYP 1
- City Agency 192
MNG_AGENCY 1
- Sacramento, City of · 192 ✖
DES_TP 1
- Local Park · 192 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11380 | 11380 | 11379 | {"type": "MultiPolygon", "coordinates": [[[[-121.45543, 38.6061], [-121.45441, 38.6061], [-121.45437, 38.60608], [-121.45435, 38.60605], [-121.45435, 38.60509], [-121.45436, 38.60506], [-121.45441, 38.60504], [-121.45506, 38.60501], [-121.45585, 38.60504], [-121.45589, 38.60506], [-121.45591, 38.60511], [-121.45575, 38.6057], [-121.45565, 38.60585], [-121.45547, 38.60602], [-121.45543, 38.6061]]], [[[-121.45815, 38.60582], [-121.45747, 38.60582], [-121.45746, 38.60593], [-121.45678, 38.60593], [-121.45683, 38.60556], [-121.45681, 38.60551], [-121.45676, 38.60546], [-121.45669, 38.60544], [-121.45625, 38.60546], [-121.45605, 38.60546], [-121.45597, 38.60544], [-121.45606, 38.60508], [-121.45609, 38.60505], [-121.45612, 38.60504], [-121.45659, 38.60506], [-121.4568, 38.6051], [-121.45717, 38.60521], [-121.45732, 38.60523], [-121.45746, 38.60522], [-121.45759, 38.60517], [-121.45764, 38.60517], [-121.45815, 38.60582]]]]} | Open Access 1 | 22181 | Woodlake Park | 27717 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 6.15 | Woodlake Park | 0 | Local Park 2 | 4 | |
11039 | 11039 | 11038 | {"type": "Polygon", "coordinates": [[[-121.48273, 38.50449], [-121.48083, 38.50449], [-121.48083, 38.50303], [-121.48266, 38.503], [-121.48273, 38.50449]]]} | Open Access 1 | 21216 | Woodbine Park | 27681 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 6.594 | Woodbine Park | 0 | Local Park 2 | 4 | |
5600 | 5600 | 5599 | {"type": "Polygon", "coordinates": [[[-121.42295, 38.46754], [-121.4229, 38.46761], [-121.42273, 38.46753], [-121.42272, 38.4675], [-121.42267, 38.46748], [-121.42263, 38.46749], [-121.42248, 38.46742], [-121.42214, 38.46739], [-121.42183, 38.46766], [-121.42172, 38.46741], [-121.42167, 38.46737], [-121.42169, 38.4673], [-121.42164, 38.46723], [-121.42167, 38.46718], [-121.42139, 38.46662], [-121.42132, 38.4666], [-121.42133, 38.46655], [-121.42132, 38.4665], [-121.4211, 38.46601], [-121.42104, 38.46595], [-121.42111, 38.46585], [-121.42086, 38.46535], [-121.42048, 38.46527], [-121.42045, 38.46527], [-121.42037, 38.46515], [-121.42071, 38.46505], [-121.42058, 38.46477], [-121.42115, 38.46459], [-121.42128, 38.46483], [-121.42135, 38.46487], [-121.42132, 38.46493], [-121.42133, 38.465], [-121.4216, 38.4655], [-121.42164, 38.46554], [-121.42171, 38.46558], [-121.42184, 38.46558], [-121.42201, 38.46589], [-121.42218, 38.4661], [-121.42227, 38.46614], [-121.42223, 38.46622], [-121.42225, 38.46676], [-121.42228, 38.46683], [-121.42233, 38.46688], [-121.42224, 38.46697], [-121.42224, 38.4673], [-121.42252, 38.46733], [-121.42295, 38.46754]]]} | Open Access 1 | 21247 | Wood Park | 27678 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.572 | Wood Park | 0 | Local Park 2 | 4 | |
10995 | 10995 | 10994 | {"type": "Polygon", "coordinates": [[[-121.53208, 38.63853], [-121.53194, 38.63857], [-121.5318, 38.63858], [-121.53175, 38.63862], [-121.53171, 38.63865], [-121.53169, 38.63865], [-121.531, 38.63886], [-121.5309, 38.63885], [-121.53077, 38.6389], [-121.53058, 38.63894], [-121.53032, 38.63896], [-121.53027, 38.63895], [-121.53025, 38.63893], [-121.53019, 38.63878], [-121.52943, 38.63721], [-121.52943, 38.63716], [-121.52947, 38.63713], [-121.52997, 38.63699], [-121.53012, 38.63697], [-121.53017, 38.63694], [-121.53021, 38.6369], [-121.53023, 38.63691], [-121.53092, 38.6367], [-121.53104, 38.63671], [-121.53117, 38.63665], [-121.53208, 38.63853]]]} | Open Access 1 | 21061 | Witter Ranch Park | 27664 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 9.032 | Witter Ranch Park | 0 | Local Park 2 | 4 | |
11020 | 11020 | 11019 | {"type": "Polygon", "coordinates": [[[-121.44494, 38.6102], [-121.44398, 38.6102], [-121.44398, 38.60939], [-121.44494, 38.60938], [-121.44494, 38.6102]]]} | Open Access 1 | 21105 | Winner's Circle Park | 27648 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.89 | Winner's Circle Park | 0 | Local Park 2 | 4 | |
10962 | 10962 | 10961 | {"type": "Polygon", "coordinates": [[[-121.51585, 38.68321], [-121.51542, 38.68328], [-121.51542, 38.68332], [-121.51446, 38.68333], [-121.5144, 38.68326], [-121.51447, 38.68323], [-121.51447, 38.68257], [-121.51539, 38.68237], [-121.51546, 38.68238], [-121.51551, 38.68242], [-121.51575, 38.68292], [-121.51585, 38.68321]]]} | Open Access 1 | 21029 | Willow Park | 27584 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.516 | Willow Park | 0 | Local Park 2 | 4 | |
5649 | 5649 | 5648 | {"type": "MultiPolygon", "coordinates": [[[[-121.4595, 38.57645], [-121.45919, 38.57719], [-121.45722, 38.57666], [-121.45758, 38.57593], [-121.4595, 38.57645]]], [[[-121.46367, 38.57597], [-121.46275, 38.57809], [-121.45934, 38.57718], [-121.46062, 38.57419], [-121.46066, 38.57416], [-121.46367, 38.57497], [-121.46378, 38.57509], [-121.46382, 38.57525], [-121.4638, 38.57535], [-121.46363, 38.57576], [-121.46363, 38.57587], [-121.46367, 38.57597]]], [[[-121.46413, 38.57503], [-121.46379, 38.57583], [-121.46377, 38.57583], [-121.46378, 38.57577], [-121.46392, 38.57542], [-121.46395, 38.5753], [-121.46394, 38.57514], [-121.46386, 38.57497], [-121.46389, 38.57497], [-121.46413, 38.57503]]]]} | Open Access 1 | 21133 | William Mckinley Park | 27552 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 31.223 | William Mckinley Park | 0 | Local Park 2 | 4 | |
11379 | 11379 | 11378 | {"type": "MultiPolygon", "coordinates": [[[[-121.50829, 38.5459], [-121.50751, 38.54716], [-121.50043, 38.54564], [-121.50093, 38.54409], [-121.50095, 38.544], [-121.49178, 38.54218], [-121.49175, 38.54214], [-121.49175, 38.54211], [-121.49388, 38.53524], [-121.50267, 38.53705], [-121.5031, 38.53721], [-121.50507, 38.5385], [-121.50524, 38.53859], [-121.50573, 38.53917], [-121.50588, 38.53951], [-121.5053, 38.5402], [-121.50479, 38.54046], [-121.50472, 38.54043], [-121.50322, 38.54454], [-121.50605, 38.54513], [-121.50663, 38.54532], [-121.50827, 38.54569], [-121.50822, 38.54587], [-121.50829, 38.5459]], [[-121.49918, 38.53783], [-121.50052, 38.53847], [-121.50103, 38.53796], [-121.49886, 38.53699], [-121.4949, 38.5357], [-121.49477, 38.53739], [-121.49458, 38.5393], [-121.49378, 38.53918], [-121.49362, 38.54119], [-121.49403, 38.5416], [-121.49458, 38.54138], [-121.49588, 38.54173], [-121.49617, 38.54169], [-121.49715, 38.54132], [-121.4973, 38.54134], [-121.49784, 38.54192], [-121.49803, 38.54218], [-121.49826, 38.54242], [-121.49851, 38.54254], [-121.49882, 38.54275], [-121.49948, 38.54293], [-121.50018, 38.54317], [-121.50106, 38.54351], [-121.50142, 38.5423], [-121.50031, 38.54177], [-121.49991, 38.54147], [-121.49957, 38.54116], [-121.49903, 38.54052], [-121.49876, 38.5401], [-121.49857, 38.53976], [-121.49915, 38.53855], [-121.49895, 38.53849], [-121.49918, 38.53783]]], [[[-121.50005, 38.54738], [-121.49997, 38.54753], [-121.49986, 38.54769], [-121.49983, 38.54772], [-121.49979, 38.54771], [-121.49978, 38.54769], [-121.4999, 38.54732], [-121.50005, 38.54738]]], [[[-121.50018, 38.5466], [-121.50031, 38.54664], [-121.50034, 38.54667], [-121.50035, 38.54671], [-121.50011, 38.54724], [-121.50007, 38.54727], [-121.50001, 38.54727], [-121.49995, 38.54723], [-121.49994, 38.54719], [-121.50011, 38.54664], [-121.50014, 38.54661], [-121.50018, 38.5466]]], [[[-121.50042, 38.54583], [-121.50061, 38.54587], [-121.50065, 38.5459], [-121.50066, 38.54594], [-121.50044, 38.54648], [-121.50041, 38.54652], [-121.50036, 38.54653], [-121.50022, 38.54648], [-121.50019, 38.54645], [-121.50019, 38.54642], [-121.50036, 38.54586], [-121.50042, 38.54583]]]]} | Open Access 1 | 22180 | William Land Park | 27549 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 161.407 | William Land Park | 0 | Local Park 2 | 4 | |
5674 | 5674 | 5673 | {"type": "MultiPolygon", "coordinates": [[[[-121.47899, 38.54805], [-121.47897, 38.5475], [-121.47908, 38.54753], [-121.47922, 38.54764], [-121.47934, 38.54771], [-121.47961, 38.54777], [-121.47966, 38.54781], [-121.47968, 38.54786], [-121.47968, 38.548], [-121.47963, 38.54804], [-121.47899, 38.54805]]], [[[-121.48009, 38.54377], [-121.47905, 38.54378], [-121.479, 38.5406], [-121.48004, 38.54042], [-121.48009, 38.54377]]], [[[-121.48012, 38.5452], [-121.47907, 38.54521], [-121.47905, 38.54394], [-121.4801, 38.54393], [-121.48012, 38.5452]]], [[[-121.48013, 38.54591], [-121.47908, 38.54592], [-121.47907, 38.54537], [-121.48012, 38.54536], [-121.48013, 38.54591]]], [[[-121.48013, 38.54607], [-121.48015, 38.5473], [-121.48011, 38.54743], [-121.48006, 38.54751], [-121.47998, 38.54758], [-121.47988, 38.54764], [-121.47978, 38.54767], [-121.47955, 38.54769], [-121.47944, 38.54767], [-121.47934, 38.54763], [-121.47924, 38.54756], [-121.47918, 38.5475], [-121.47911, 38.54735], [-121.47908, 38.54608], [-121.48013, 38.54607]]], [[[-121.48031, 38.54803], [-121.47996, 38.54804], [-121.47992, 38.54803], [-121.47989, 38.54799], [-121.47989, 38.54777], [-121.47992, 38.54771], [-121.48006, 38.54762], [-121.48015, 38.54753], [-121.48023, 38.5475], [-121.48029, 38.54749], [-121.48031, 38.54803]]]]} | Open Access 1 | 21160 | William Curtis Park | 27542 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 17.577 | William Curtis Park | 0 | Local Park 2 | 4 | |
11043 | 11043 | 11042 | {"type": "Polygon", "coordinates": [[[-121.50124, 38.49928], [-121.49201, 38.49936], [-121.49199, 38.49761], [-121.49235, 38.49761], [-121.49249, 38.49753], [-121.49279, 38.49753], [-121.4929, 38.49756], [-121.49399, 38.49755], [-121.49471, 38.49745], [-121.49488, 38.49784], [-121.49518, 38.49819], [-121.4956, 38.49846], [-121.49609, 38.49863], [-121.49662, 38.49868], [-121.49716, 38.49863], [-121.49766, 38.49845], [-121.49807, 38.49818], [-121.49836, 38.49783], [-121.49851, 38.49745], [-121.4993, 38.49754], [-121.5004, 38.49753], [-121.50049, 38.4975], [-121.50123, 38.4975], [-121.50124, 38.49928]]]} | Open Access 1 | 21221 | William Chorley Park | 27541 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 32.069 | William Chorley Park | 0 | Local Park 2 | 4 | |
10980 | 10980 | 10979 | {"type": "Polygon", "coordinates": [[[-121.52709, 38.66822], [-121.52709, 38.6697], [-121.52707, 38.66974], [-121.52471, 38.66974], [-121.52471, 38.66822], [-121.52709, 38.66822]]]} | Open Access 1 | 21047 | Wild Rose Park Site | 27498 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 8.621 | Wild Rose Park Site | 0 | Local Park 2 | 4 | |
11065 | 11065 | 11064 | {"type": "Polygon", "coordinates": [[[-121.54712, 38.65619], [-121.5467, 38.65619], [-121.54661, 38.65617], [-121.54594, 38.65752], [-121.5455, 38.65742], [-121.5451, 38.65737], [-121.54468, 38.65737], [-121.54412, 38.65744], [-121.54408, 38.65743], [-121.54405, 38.65739], [-121.54394, 38.65712], [-121.54385, 38.6568], [-121.54377, 38.65637], [-121.54375, 38.65586], [-121.54377, 38.65583], [-121.54383, 38.6558], [-121.5468, 38.65578], [-121.54677, 38.65586], [-121.54711, 38.65586], [-121.54712, 38.65619]]]} | Open Access 1 | 21259 | Westlake Community Park | 27401 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 10.226 | Westlake Community Park | 0 | Local Park 2 | 4 | |
10971 | 10971 | 10970 | {"type": "Polygon", "coordinates": [[[-121.53611, 38.67582], [-121.53603, 38.67614], [-121.53603, 38.67671], [-121.53601, 38.6768], [-121.53598, 38.67683], [-121.53431, 38.67655], [-121.53417, 38.67651], [-121.53405, 38.67645], [-121.53405, 38.67643], [-121.5343, 38.67605], [-121.53449, 38.67571], [-121.53461, 38.67554], [-121.53465, 38.67552], [-121.53478, 38.67558], [-121.53493, 38.67563], [-121.53601, 38.67579], [-121.5361, 38.6758], [-121.53611, 38.67582]]]} | Open Access 1 | 21037 | Westhampton Park | 27398 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 4.317 | Westhampton Park | 0 | Local Park 2 | 4 | |
3064 | 3064 | 3063 | {"type": "Polygon", "coordinates": [[[-121.48248, 38.58238], [-121.4821, 38.58326], [-121.48143, 38.58308], [-121.48181, 38.5822], [-121.48248, 38.58238]]]} | Open Access 1 | 21127 | Washington Park | 27279 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 1.583 | Washington Park | 0 | Local Park 2 | 4 | |
10992 | 10992 | 10991 | {"type": "Polygon", "coordinates": [[[-121.54774, 38.6485], [-121.5477, 38.64854], [-121.54769, 38.64858], [-121.5477, 38.64918], [-121.54773, 38.64925], [-121.54759, 38.64935], [-121.5476, 38.6497], [-121.54756, 38.64976], [-121.54748, 38.64975], [-121.54687, 38.64977], [-121.54666, 38.64982], [-121.54646, 38.64992], [-121.54643, 38.64804], [-121.54763, 38.64803], [-121.54764, 38.64837], [-121.54774, 38.6485]]]} | Open Access 1 | 21057 | Warbler Park Site | 27253 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.085 | Warbler Park Site | 0 | Local Park 2 | 4 | |
10993 | 10993 | 10992 | {"type": "Polygon", "coordinates": [[[-121.42536, 38.6435], [-121.42493, 38.64382], [-121.42471, 38.64363], [-121.42514, 38.64332], [-121.42536, 38.6435]]]} | Open Access 1 | 21059 | Verano Creek Park | 26984 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 0.355 | Verano Creek Park | 0 | Local Park 2 | 4 | |
10973 | 10973 | 10972 | {"type": "Polygon", "coordinates": [[[-121.5295, 38.67417], [-121.5292, 38.67444], [-121.52894, 38.67464], [-121.5276, 38.67551], [-121.52658, 38.67386], [-121.52689, 38.67393], [-121.5271, 38.67397], [-121.52771, 38.67398], [-121.52773, 38.67372], [-121.52779, 38.67344], [-121.52787, 38.67331], [-121.52799, 38.67317], [-121.52817, 38.67307], [-121.52869, 38.67285], [-121.52894, 38.67281], [-121.5292, 38.67281], [-121.5295, 38.67289], [-121.52986, 38.67308], [-121.53012, 38.67317], [-121.53014, 38.67319], [-121.53005, 38.6734], [-121.52989, 38.67369], [-121.5297, 38.67394], [-121.5295, 38.67417]]]} | Open Access 1 | 21039 | Valley Oak Park Site | 26795 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 11.185 | Valley Oak Park Site | 0 | Local Park 2 | 4 | |
11059 | 11059 | 11058 | {"type": "Polygon", "coordinates": [[[-121.42972, 38.46125], [-121.429, 38.46148], [-121.42897, 38.46155], [-121.42882, 38.46155], [-121.42821, 38.46176], [-121.42814, 38.4618], [-121.4281, 38.46184], [-121.428, 38.46182], [-121.42733, 38.46204], [-121.42728, 38.46212], [-121.42713, 38.46212], [-121.42651, 38.46232], [-121.42642, 38.4624], [-121.42631, 38.46237], [-121.42595, 38.46248], [-121.42563, 38.46283], [-121.4255, 38.46283], [-121.42487, 38.46305], [-121.4248, 38.46312], [-121.42467, 38.4631], [-121.42399, 38.46332], [-121.42392, 38.46318], [-121.42373, 38.46293], [-121.42349, 38.4627], [-121.42382, 38.46247], [-121.4247, 38.46205], [-121.4258, 38.46165], [-121.4262, 38.46143], [-121.42657, 38.46119], [-121.42721, 38.46063], [-121.42734, 38.46039], [-121.42763, 38.46043], [-121.42792, 38.46044], [-121.42807, 38.46043], [-121.42836, 38.46037], [-121.42904, 38.46015], [-121.42911, 38.46015], [-121.42913, 38.46017], [-121.42972, 38.46125]]]} | Open Access 1 | 21250 | Valley Hi Park | 26790 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 16.236 | Valley Hi Park | 0 | Local Park 2 | 4 | |
5666 | 5666 | 5665 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | 21150 | University Park | 26687 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.716 | University Park | 0 | Local Park 2 | 4 | |
4451 | 4451 | 4450 | {"type": "Polygon", "coordinates": [[[-121.47503, 38.58406], [-121.47465, 38.58494], [-121.47365, 38.58467], [-121.47404, 38.58379], [-121.47503, 38.58406]]]} | Open Access 1 | 21121 | Ulysses S. Grant Park | 26649 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 2.344 | Ulysses S. Grant 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]);