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 ACRES 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10978 | 10978 | 10977 | {"type": "Polygon", "coordinates": [[[-121.47543, 38.66991], [-121.46604, 38.66983], [-121.46605, 38.66945], [-121.46608, 38.66228], [-121.4661, 38.66], [-121.46631, 38.6599], [-121.4664, 38.65943], [-121.46793, 38.65892], [-121.4686, 38.65854], [-121.47094, 38.65833], [-121.4715, 38.65781], [-121.47227, 38.6578], [-121.47285, 38.65813], [-121.4737, 38.65896], [-121.47466, 38.65919], [-121.47541, 38.66402], [-121.47543, 38.66991]]]} | Open Access 1 | 21045 | Hansen Ranch Park Site | 19651 | 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 | 245.789 | Hansen Ranch Park Site | 0 | Local Park 2 | 4 | |
2707 | 2707 | 2706 | {"type": "Polygon", "coordinates": [[[-121.52471, 38.66639], [-121.52415, 38.6664], [-121.52377, 38.66637], [-121.52105, 38.66592], [-121.52068, 38.66588], [-121.52038, 38.66587], [-121.52008, 38.66587], [-121.51964, 38.66591], [-121.51819, 38.66616], [-121.51766, 38.66622], [-121.51741, 38.66624], [-121.51736, 38.66621], [-121.51734, 38.66617], [-121.51722, 38.66618], [-121.51719, 38.66623], [-121.51713, 38.66625], [-121.51641, 38.66623], [-121.51587, 38.66617], [-121.51534, 38.66608], [-121.5141, 38.66582], [-121.51406, 38.66579], [-121.51404, 38.66573], [-121.51392, 38.66571], [-121.51388, 38.66574], [-121.51382, 38.66576], [-121.5132, 38.66564], [-121.51264, 38.66559], [-121.51005, 38.66559], [-121.50956, 38.66557], [-121.50921, 38.66554], [-121.50876, 38.66546], [-121.50825, 38.66534], [-121.50821, 38.66531], [-121.5082, 38.66528], [-121.50832, 38.66502], [-121.50852, 38.66467], [-121.50914, 38.66401], [-121.51124, 38.66184], [-121.51129, 38.66182], [-121.51135, 38.66183], [-121.51204, 38.6622], [-121.51203, 38.66197], [-121.5115, 38.66167], [-121.51147, 38.66165], [-121.51146, 38.66161], [-121.51175, 38.66121], [-121.51194, 38.66089], [-121.51207, 38.66062], [-121.5122, 38.66028], [-121.51228, 38.65993], [-121.51232, 38.65965], [-121.51234, 38.6593], [-121.51234, 38.65876], [-121.51237, 38.65871], [-121.51242, 38.6587], [-121.51335, 38.65877], [-121.51356, 38.65881], [-121.51386, 38.65889], [-121.51409, 38.65898], [-121.51427, 38.65908], [-121.51539, 38.65983], [-121.51565, 38.65997], [-121.51594, 38.66007], [-121.51618, 38.66013], [-121.51642, 38.66017], [-121.51677, 38.66017], [-121.51702, 38.66015], [-121.51726, 38.6601], [-121.51762, 38.65999], [-121.52123, 38.65832], [-121.52144, 38.65826], [-121.5216, 38.65826], [-121.52173, 38.65827], [-121.52202, 38.65836], [-121.52202, 38.65892], [-121.52197, 38.65932], [-121.52191, 38.65954], [-121.52183, 38.65976], [-121.52165, 38.66014], [-121.52183, 38.66047], [-121.52218, 38.66086], [-121.52241, 38.66106], [-121.52265, 38.66125], [-121.52311, 38.66155], [-121.52375, 38.66189], [-121.52412, 38.66215], [-121.52431, 38.66233], [-121.52449, 38.66256], [-121.52463, 38.66277], [-121.52473, 38.66299], [-121.52483, 38.66333], [-121.52486, 38.66368], [-121.52483, 38.664], [-121.52466, 38.66456], [-121.52462, 38.66488], [-121.52462, 38.66506], [-121.52465, 38.66527], [-121.52477, 38.6657], [-121.52476, 38.66579], [-121.52473, 38.66586], [-121.52475, 38.66613], [-121.52471, 38.66639]]]} | Open Access 1 | 21286 | North Natomas Regional Park | 22834 | 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 | 211.13 | North Natomas RP | 0 | Local Park 2 | 4 | |
16366 | 16366 | 16365 | {"type": "Polygon", "coordinates": [[[-121.39984, 38.54573], [-121.39674, 38.54558], [-121.39674, 38.54595], [-121.3921, 38.54463], [-121.39237, 38.54404], [-121.39241, 38.53989], [-121.39266, 38.53987], [-121.40022, 38.53983], [-121.40183, 38.53972], [-121.40689, 38.53969], [-121.40688, 38.54052], [-121.40667, 38.54054], [-121.40662, 38.54524], [-121.40612, 38.54526], [-121.40609, 38.54695], [-121.40454, 38.54676], [-121.40324, 38.54663], [-121.402, 38.54655], [-121.40091, 38.54651], [-121.40091, 38.54601], [-121.40051, 38.546], [-121.40049, 38.54572], [-121.39984, 38.54573]]]} | Open Access 1 | 21165 | Granite Regional Park | 9807 | 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 | http://www.cityofsacramento.org/parksandrecreation/parks/sites/granite_map.htm | Sacramento 41 | 209.846 | Granite RP | 0 | Local Park 2 | 4 |
16367 | 16367 | 16366 | {"type": "MultiPolygon", "coordinates": [[[[-121.38138, 38.63987], [-121.38132, 38.64069], [-121.38048, 38.64048], [-121.3791, 38.64071], [-121.37843, 38.6411], [-121.37685, 38.64253], [-121.37584, 38.64298], [-121.37292, 38.64406], [-121.37237, 38.6445], [-121.37201, 38.6446], [-121.37165, 38.64452], [-121.37031, 38.64352], [-121.36696, 38.64393], [-121.36672, 38.64436], [-121.36645, 38.64449], [-121.36556, 38.64378], [-121.36557, 38.6436], [-121.36622, 38.64308], [-121.36644, 38.64294], [-121.36673, 38.64278], [-121.36723, 38.64256], [-121.36848, 38.64217], [-121.37178, 38.6412], [-121.37542, 38.64008], [-121.37779, 38.63927], [-121.38036, 38.6383], [-121.38138, 38.63987]]], [[[-121.40097, 38.63756], [-121.39996, 38.63792], [-121.39972, 38.63804], [-121.39941, 38.63824], [-121.39796, 38.63953], [-121.3966, 38.64082], [-121.39624, 38.64114], [-121.39557, 38.64167], [-121.39525, 38.64189], [-121.39447, 38.64233], [-121.39261, 38.64273], [-121.39227, 38.64182], [-121.39188, 38.64199], [-121.38973, 38.64316], [-121.38949, 38.64327], [-121.38921, 38.64338], [-121.38891, 38.64345], [-121.38835, 38.64354], [-121.38809, 38.64356], [-121.38806, 38.64359], [-121.38804, 38.64364], [-121.38779, 38.64362], [-121.38775, 38.6436], [-121.38738, 38.64354], [-121.38634, 38.64328], [-121.3862, 38.64322], [-121.38598, 38.6431], [-121.38591, 38.6431], [-121.38571, 38.64299], [-121.38567, 38.64295], [-121.38518, 38.64265], [-121.38486, 38.64252], [-121.38465, 38.64248], [-121.3842, 38.64244], [-121.3834, 38.64232], [-121.38341, 38.64166], [-121.38358, 38.64163], [-121.38363, 38.64095], [-121.38412, 38.63958], [-121.3842, 38.6394], [-121.38434, 38.63921], [-121.38487, 38.63866], [-121.38657, 38.63709], [-121.38786, 38.63673], [-121.38866, 38.63728], [-121.38859, 38.63753], [-121.38821, 38.6379], [-121.38805, 38.63812], [-121.38811, 38.63825], [-121.38824, 38.63837], [-121.38852, 38.63877], [-121.38849, 38.639], [-121.38839, 38.63929], [-121.388, 38.63972], [-121.38775, 38.63982], [-121.3875, 38.63999], [-121.38746, 38.64011], [-121.38749, 38.64026], [-121.38759, 38.64039], [-121.38784, 38.64051], [-121.38838, 38.64059], [-121.38942, 38.64064], [-121.38974, 38.64072], [-121.39015, 38.64075], [-121.39082, 38.64075], [-121.39146, 38.6407], [-121.39199, 38.64066], [-121.39247, 38.64056], [-121.39308, 38.64054], [-121.39444, 38.64055], [-121.39482, 38.6405], [-121.39524, 38.64033], [-121.39606, 38.64003], [-121.39645, 38.63969], [-121.39689, 38.63946], [-121.39721, 38.63917], [-121.3975, 38.63872], [-121.39804, 38.6384], [-121.39897, 38.63771], [-121.39945, 38.63746], [-121.39986, 38.63736], [-121.4004, 38.63744], [-121.40097, 38.63756]]]]} | Open Access 1 | 21262 | Del Paso Regional Park | 18046 | 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 | 188.665 | Del Paso RP | 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 | |
13644 | 13644 | 13643 | {"type": "MultiPolygon", "coordinates": [[[[-121.44956, 38.5861], [-121.44954, 38.5864], [-121.44955, 38.58802], [-121.44936, 38.58792], [-121.4492, 38.58787], [-121.44913, 38.58782], [-121.44894, 38.58773], [-121.44885, 38.58766], [-121.4487, 38.58762], [-121.44846, 38.58746], [-121.4483, 38.5874], [-121.44784, 38.58717], [-121.4482, 38.58685], [-121.44865, 38.58653], [-121.44913, 38.58628], [-121.44956, 38.5861]]], [[[-121.46355, 38.58344], [-121.46215, 38.58683], [-121.46184, 38.58692], [-121.46141, 38.58712], [-121.46114, 38.58726], [-121.46079, 38.58738], [-121.46041, 38.58758], [-121.46024, 38.58765], [-121.45999, 38.58773], [-121.45976, 38.58783], [-121.45965, 38.5879], [-121.45951, 38.58792], [-121.45935, 38.58799], [-121.45887, 38.58812], [-121.45856, 38.58826], [-121.45831, 38.58832], [-121.45816, 38.58841], [-121.45787, 38.58852], [-121.45762, 38.58859], [-121.45712, 38.58871], [-121.45676, 38.58886], [-121.45656, 38.58889], [-121.45634, 38.58902], [-121.45611, 38.58907], [-121.4558, 38.58918], [-121.45557, 38.58921], [-121.45536, 38.58927], [-121.45514, 38.58926], [-121.45503, 38.58927], [-121.45478, 38.58938], [-121.45421, 38.5894], [-121.45392, 38.58948], [-121.45354, 38.58946], [-121.45327, 38.58955], [-121.45241, 38.58956], [-121.45215, 38.58947], [-121.45183, 38.58944], [-121.45163, 38.58929], [-121.45135, 38.5898], [-121.45077, 38.58953], [-121.45073, 38.58877], [-121.45066, 38.58876], [-121.45063, 38.58827], [-121.45067, 38.5878], [-121.45113, 38.58571], [-121.45191, 38.58557], [-121.45271, 38.58546], [-121.45391, 38.58533], [-121.45575, 38.58518], [-121.45829, 38.58509], [-121.45864, 38.58506], [-121.45907, 38.58501], [-121.45958, 38.5849], [-121.45999, 38.58477], [-121.46046, 38.58459], [-121.46091, 38.58437], [-121.46132, 38.58411], [-121.4617, 38.58382], [-121.46203, 38.5835], [-121.46236, 38.58311], [-121.46355, 38.58344]]]]} | Open Access 1 | 36002 | Sutters Landing Regional Park | 26087 | 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 | 108.631 | Sutters Landing RP | 0 | Local Park 2 | 4 | |
11036 | 11036 | 11035 | {"type": "MultiPolygon", "coordinates": [[[[-121.5303, 38.5013], [-121.53015, 38.50152], [-121.53011, 38.50154], [-121.52972, 38.5014], [-121.52942, 38.50137], [-121.52913, 38.50139], [-121.52852, 38.50152], [-121.52841, 38.50125], [-121.52672, 38.50166], [-121.52642, 38.50206], [-121.5259, 38.50284], [-121.52586, 38.50307], [-121.52622, 38.5031], [-121.52622, 38.5032], [-121.52624, 38.5033], [-121.52643, 38.50376], [-121.52648, 38.50382], [-121.52653, 38.50385], [-121.52651, 38.504], [-121.52659, 38.50421], [-121.52628, 38.50429], [-121.52639, 38.50457], [-121.52634, 38.50463], [-121.52633, 38.50471], [-121.52653, 38.50523], [-121.5266, 38.50531], [-121.52671, 38.50534], [-121.52678, 38.50552], [-121.52728, 38.50591], [-121.52727, 38.506], [-121.52748, 38.50652], [-121.52747, 38.50655], [-121.52744, 38.50658], [-121.52699, 38.50669], [-121.52664, 38.5068], [-121.52659, 38.5068], [-121.52655, 38.50677], [-121.52649, 38.5068], [-121.52635, 38.50658], [-121.5264, 38.50655], [-121.52625, 38.50632], [-121.52617, 38.50581], [-121.52599, 38.50554], [-121.52591, 38.50551], [-121.52592, 38.50546], [-121.52591, 38.50541], [-121.52574, 38.50512], [-121.52558, 38.50492], [-121.52545, 38.50482], [-121.52538, 38.5048], [-121.52529, 38.50481], [-121.52488, 38.50452], [-121.52461, 38.50444], [-121.52425, 38.50446], [-121.52416, 38.50435], [-121.5254, 38.50257], [-121.52539, 38.5025], [-121.52544, 38.50248], [-121.52551, 38.50243], [-121.52583, 38.50199], [-121.52585, 38.50194], [-121.52585, 38.50187], [-121.52594, 38.50184], [-121.52629, 38.50134], [-121.52637, 38.50137], [-121.52647, 38.50138], [-121.52656, 38.50135], [-121.52661, 38.5013], [-121.52707, 38.50067], [-121.52713, 38.50065], [-121.52784, 38.49884], [-121.52796, 38.49857], [-121.52842, 38.49708], [-121.52896, 38.49719], [-121.52839, 38.49897], [-121.52804, 38.49998], [-121.52802, 38.50016], [-121.52802, 38.50034], [-121.52805, 38.50043], [-121.52815, 38.50067], [-121.52822, 38.50075], [-121.52834, 38.50078], [-121.52845, 38.50108], [-121.5293, 38.50092], [-121.52936, 38.50105], [-121.52998, 38.50116], [-121.5303, 38.5013]]], [[[-121.52943, 38.51134], [-121.52941, 38.5114], [-121.52941, 38.51145], [-121.5296, 38.51193], [-121.52959, 38.51197], [-121.52956, 38.51199], [-121.52903, 38.51219], [-121.52896, 38.51218], [-121.52864, 38.51172], [-121.52853, 38.51166], [-121.52855, 38.51159], [-121.52822, 38.51109], [-121.52814, 38.51106], [-121.52815, 38.51101], [-121.52812, 38.51094], [-121.52783, 38.51049], [-121.52778, 38.51045], [-121.52772, 38.51042], [-121.52774, 38.51035], [-121.52741, 38.50986], [-121.52733, 38.50983], [-121.52733, 38.50974], [-121.5272, 38.50954], [-121.52853, 38.50922], [-121.52857, 38.50931], [-121.52865, 38.50938], [-121.52861, 38.50944], [-121.52882, 38.50998], [-121.5289, 38.51002], [-121.52887, 38.51013], [-121.52907, 38.51062], [-121.5291, 38.51066], [-121.52916, 38.5107], [-121.52912, 38.51076], [-121.52935, 38.51131], [-121.52943, 38.51134]]], [[[-121.52995, 38.49414], [-121.52974, 38.49478], [-121.5298, 38.49484], [-121.52972, 38.49493], [-121.52956, 38.49543], [-121.52956, 38.49552], [-121.52947, 38.49555], [-121.52937, 38.49587], [-121.52987, 38.49599], [-121.52952, 38.49671], [-121.52944, 38.49694], [-121.52833, 38.49671], [-121.52852, 38.49609], [-121.52849, 38.49603], [-121.52857, 38.49595], [-121.52874, 38.49544], [-121.52874, 38.49537], [-121.52871, 38.49532], [-121.52879, 38.49527], [-121.52898, 38.49469], [-121.52893, 38.49462], [-121.529, 38.49458], [-121.52904, 38.49452], [-121.5292, 38.49402], [-121.52919, 38.49394], [-121.52913, 38.49387], [-121.52906, 38.49383], [-121.5289, 38.4938], [-121.529, 38.49328], [-121.52899, 38.49234], [-121.52953, 38.49234], [-121.52954, 38.49259], [-121.52965, 38.49327], [-121.52989, 38.49359], [-121.52986, 38.49364], [-121.52986, 38.49369], [-121.52992, 38.49409], [-121.52995, 38.49414]]], [[[-121.53119, 38.51589], [-121.53094, 38.51624], [-121.52935, 38.51644], [-121.52903, 38.51578], [-121.53009, 38.51548], [-121.53, 38.51435], [-121.52993, 38.5141], [-121.5304, 38.51402], [-121.53047, 38.51403], [-121.53051, 38.51407], [-121.53113, 38.5158], [-121.53119, 38.51589]]], [[[-121.53038, 38.51381], [-121.53004, 38.51385], [-121.52906, 38.51233], [-121.52966, 38.5121], [-121.5301, 38.51325], [-121.53038, 38.51381]]], [[[-121.5316, 38.50197], [-121.53124, 38.50215], [-121.53112, 38.50204], [-121.53101, 38.50195], [-121.53036, 38.50166], [-121.53034, 38.50164], [-121.53033, 38.5016], [-121.53049, 38.50138], [-121.53155, 38.50183], [-121.5316, 38.50197]]]]} | Open Access 1 | 21211 | Frank Seymour Park | 19053 | 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 | 49.538 | Frank Seymour Park | 0 | Local Park 2 | 4 | |
10966 | 10966 | 10965 | {"type": "Polygon", "coordinates": [[[-121.50463, 38.68061], [-121.50466, 38.68062], [-121.50497, 38.68094], [-121.50508, 38.68109], [-121.50517, 38.68124], [-121.50526, 38.68148], [-121.50529, 38.68168], [-121.5053, 38.68184], [-121.50525, 38.6819], [-121.5019, 38.6819], [-121.5019, 38.68069], [-121.50087, 38.67955], [-121.50079, 38.67953], [-121.50078, 38.67947], [-121.50075, 38.67942], [-121.5004, 38.67903], [-121.50029, 38.67898], [-121.5003, 38.67889], [-121.49989, 38.67843], [-121.49979, 38.67841], [-121.49979, 38.67835], [-121.49975, 38.67829], [-121.49891, 38.67736], [-121.49884, 38.6773], [-121.49886, 38.67726], [-121.49838, 38.67673], [-121.49843, 38.67667], [-121.49843, 38.67659], [-121.4982, 38.6761], [-121.49821, 38.67603], [-121.49825, 38.676], [-121.49832, 38.67598], [-121.4985, 38.6759], [-121.50349, 38.67332], [-121.50355, 38.67331], [-121.5036, 38.67333], [-121.50376, 38.67347], [-121.50393, 38.67368], [-121.50408, 38.67393], [-121.50416, 38.67417], [-121.50419, 38.67444], [-121.5042, 38.67599], [-121.50418, 38.67602], [-121.50413, 38.67604], [-121.50041, 38.67607], [-121.50016, 38.67611], [-121.50002, 38.67615], [-121.49993, 38.67621], [-121.49989, 38.6763], [-121.49985, 38.6763], [-121.49954, 38.67644], [-121.50094, 38.67846], [-121.50092, 38.67851], [-121.50094, 38.67856], [-121.50098, 38.67859], [-121.50104, 38.67861], [-121.50137, 38.67913], [-121.50148, 38.67917], [-121.50147, 38.67923], [-121.5015, 38.67929], [-121.50209, 38.68015], [-121.50219, 38.68036], [-121.50223, 38.68041], [-121.5023, 38.68044], [-121.50245, 38.68044], [-121.50245, 38.68074], [-121.50422, 38.68071], [-121.50463, 38.68061]]]} | Open Access 1 | 21032 | Regency Community Park | 24270 | 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 | 42.127 | Regency Community Park | 0 | Local Park 2 | 4 | |
5664 | 5664 | 5663 | {"type": "MultiPolygon", "coordinates": [[[[-121.51588, 38.56695], [-121.51435, 38.56594], [-121.51455, 38.5658], [-121.51503, 38.56533], [-121.51537, 38.56503], [-121.51582, 38.56503], [-121.51583, 38.5662], [-121.51588, 38.56695]]], [[[-121.51794, 38.56829], [-121.51699, 38.56765], [-121.51651, 38.5675], [-121.51619, 38.56742], [-121.51621, 38.56716], [-121.51618, 38.56511], [-121.51592, 38.56277], [-121.51554, 38.5607], [-121.51522, 38.55979], [-121.51491, 38.55912], [-121.51467, 38.55864], [-121.51519, 38.55875], [-121.51546, 38.55916], [-121.51619, 38.56001], [-121.51629, 38.55994], [-121.51647, 38.56013], [-121.51638, 38.5602], [-121.51643, 38.56027], [-121.5162, 38.56042], [-121.51609, 38.56054], [-121.51603, 38.5607], [-121.51603, 38.56081], [-121.51621, 38.56234], [-121.51644, 38.56393], [-121.5165, 38.56397], [-121.51663, 38.56399], [-121.51791, 38.56394], [-121.51828, 38.56446], [-121.5183, 38.56454], [-121.51831, 38.56461], [-121.51828, 38.56467], [-121.51824, 38.56472], [-121.51818, 38.56476], [-121.51808, 38.56479], [-121.51684, 38.56488], [-121.5168, 38.5649], [-121.51674, 38.56496], [-121.51672, 38.56504], [-121.51674, 38.56679], [-121.51675, 38.56695], [-121.51677, 38.56699], [-121.51686, 38.56705], [-121.51693, 38.56706], [-121.51763, 38.56706], [-121.51771, 38.56706], [-121.51778, 38.56703], [-121.5179, 38.56693], [-121.51818, 38.56667], [-121.51867, 38.56613], [-121.51888, 38.56584], [-121.51902, 38.56554], [-121.51912, 38.56524], [-121.51913, 38.56493], [-121.51901, 38.5647], [-121.51807, 38.56339], [-121.51725, 38.56252], [-121.51711, 38.56231], [-121.51693, 38.56209], [-121.5169, 38.56184], [-121.51683, 38.5616], [-121.51663, 38.56107], [-121.51663, 38.56099], [-121.51668, 38.56093], [-121.51675, 38.56089], [-121.51687, 38.56086], [-121.51699, 38.56087], [-121.51949, 38.56358], [-121.51994, 38.5645], [-121.51993, 38.56539], [-121.51961, 38.56621], [-121.51895, 38.56737], [-121.51794, 38.56829]]], [[[-121.51582, 38.56364], [-121.51581, 38.56475], [-121.51529, 38.5648], [-121.51511, 38.56439], [-121.51532, 38.56424], [-121.51546, 38.56409], [-121.51557, 38.56392], [-121.51566, 38.56365], [-121.51582, 38.56364]]]]} | Open Access 1 | 21148 | Fredrick Miller Park | 19081 | 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 | 38.795 | Fredrick Miller Park | 0 | Local Park 2 | 4 | |
10985 | 10985 | 10984 | {"type": "Polygon", "coordinates": [[[-121.50201, 38.662], [-121.50189, 38.662], [-121.50175, 38.66197], [-121.50167, 38.66199], [-121.50162, 38.66203], [-121.5016, 38.66208], [-121.50159, 38.66218], [-121.50089, 38.66306], [-121.50086, 38.66311], [-121.50086, 38.66319], [-121.50079, 38.6632], [-121.50039, 38.6637], [-121.50032, 38.6637], [-121.50024, 38.66375], [-121.50023, 38.66382], [-121.50027, 38.66388], [-121.49934, 38.66504], [-121.49959, 38.66517], [-121.49966, 38.66517], [-121.49968, 38.66521], [-121.49972, 38.66526], [-121.49997, 38.6654], [-121.50027, 38.66551], [-121.50056, 38.66557], [-121.50093, 38.66559], [-121.50402, 38.66557], [-121.50408, 38.66559], [-121.5041, 38.66563], [-121.50412, 38.66683], [-121.50411, 38.66706], [-121.50407, 38.66733], [-121.50398, 38.66759], [-121.50383, 38.66788], [-121.50364, 38.66814], [-121.50349, 38.66829], [-121.50346, 38.66831], [-121.50341, 38.66831], [-121.50333, 38.66827], [-121.49851, 38.66569], [-121.49885, 38.66507], [-121.49883, 38.66503], [-121.4989, 38.665], [-121.4992, 38.66445], [-121.49919, 38.66438], [-121.49925, 38.66436], [-121.49955, 38.66381], [-121.49952, 38.66375], [-121.49959, 38.66372], [-121.49964, 38.66367], [-121.50021, 38.66263], [-121.50023, 38.66256], [-121.50021, 38.66249], [-121.50032, 38.66243], [-121.50046, 38.66217], [-121.50046, 38.66182], [-121.50055, 38.66182], [-121.50061, 38.66181], [-121.50066, 38.66178], [-121.50071, 38.66172], [-121.50067, 38.65979], [-121.50067, 38.65973], [-121.50069, 38.6597], [-121.50074, 38.65968], [-121.50198, 38.65967], [-121.50201, 38.662]]]} | Open Access 1 | 21050 | North Natomas Community Park | 22832 | 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 | 35.34 | North Natomas Community Park | 0 | Local Park 2 | 4 | |
3083 | 3083 | 3082 | {"type": "Polygon", "coordinates": [[[-121.53606, 38.63461], [-121.53596, 38.63488], [-121.53508, 38.63486], [-121.53466, 38.63481], [-121.53425, 38.63471], [-121.53391, 38.6346], [-121.53349, 38.63441], [-121.5332, 38.63424], [-121.53245, 38.63373], [-121.5321, 38.63354], [-121.53166, 38.63337], [-121.5312, 38.63325], [-121.53123, 38.63315], [-121.53128, 38.63315], [-121.5329, 38.63256], [-121.53289, 38.62786], [-121.53361, 38.62786], [-121.53367, 38.6278], [-121.53477, 38.62836], [-121.53478, 38.6346], [-121.53606, 38.63461]]]} | Open Access 1 | 21266 | San Juan Reservoir Park | 24921 | 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.901 | San Juan Reservoir 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 | |
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 | |
5682 | 5682 | 5681 | {"type": "Polygon", "coordinates": [[[-121.51894, 38.51107], [-121.51871, 38.51126], [-121.5185, 38.51149], [-121.51835, 38.51173], [-121.51824, 38.512], [-121.51819, 38.51224], [-121.51819, 38.51251], [-121.51839, 38.51344], [-121.5184, 38.51364], [-121.51833, 38.51386], [-121.51792, 38.5146], [-121.51785, 38.51483], [-121.51782, 38.51504], [-121.51782, 38.51523], [-121.51784, 38.51541], [-121.51789, 38.51558], [-121.51796, 38.51576], [-121.51807, 38.51595], [-121.51817, 38.51608], [-121.51855, 38.51647], [-121.51855, 38.51653], [-121.51847, 38.51657], [-121.51823, 38.51664], [-121.51787, 38.51671], [-121.51677, 38.51676], [-121.51664, 38.51676], [-121.51651, 38.51673], [-121.51639, 38.51669], [-121.51568, 38.51631], [-121.51512, 38.51606], [-121.51574, 38.51448], [-121.51599, 38.5133], [-121.51608, 38.5134], [-121.51615, 38.51342], [-121.51629, 38.51343], [-121.51645, 38.5134], [-121.51659, 38.51334], [-121.51691, 38.51331], [-121.51711, 38.51334], [-121.51728, 38.51334], [-121.51741, 38.51329], [-121.51753, 38.51316], [-121.5176, 38.51306], [-121.51778, 38.51255], [-121.51778, 38.51237], [-121.51765, 38.51224], [-121.51766, 38.51207], [-121.51769, 38.51194], [-121.51776, 38.51185], [-121.51782, 38.5118], [-121.51788, 38.51178], [-121.51811, 38.51183], [-121.51817, 38.5118], [-121.5182, 38.51174], [-121.51824, 38.51159], [-121.51805, 38.51131], [-121.51801, 38.51115], [-121.51804, 38.51104], [-121.51797, 38.51087], [-121.51803, 38.51074], [-121.518, 38.51069], [-121.51799, 38.51065], [-121.51807, 38.51059], [-121.51809, 38.51047], [-121.51809, 38.51037], [-121.51806, 38.51027], [-121.51798, 38.51019], [-121.51779, 38.51017], [-121.51781, 38.51006], [-121.51773, 38.50994], [-121.51768, 38.5099], [-121.51763, 38.50978], [-121.51748, 38.50952], [-121.51746, 38.50944], [-121.51807, 38.50984], [-121.51894, 38.51107]]]} | Open Access 1 | 21206 | Joseph Reichmuth Park | 20498 | 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 | 24.631 | Joseph Reichmuth Park | 0 | Local Park 2 | 4 | |
11382 | 11382 | 11381 | {"type": "MultiPolygon", "coordinates": [[[[-121.46586, 38.61877], [-121.46372, 38.61875], [-121.46279, 38.61927], [-121.46144, 38.61925], [-121.46052, 38.61961], [-121.46053, 38.61774], [-121.46198, 38.61776], [-121.46202, 38.61774], [-121.46205, 38.6177], [-121.46205, 38.61711], [-121.46208, 38.61706], [-121.46212, 38.61705], [-121.46329, 38.61704], [-121.46338, 38.61705], [-121.46355, 38.61712], [-121.46382, 38.61736], [-121.46385, 38.6176], [-121.46392, 38.61781], [-121.46401, 38.61794], [-121.46423, 38.61815], [-121.46436, 38.61822], [-121.4645, 38.61828], [-121.46473, 38.61833], [-121.46512, 38.61833], [-121.46554, 38.61827], [-121.46575, 38.61826], [-121.46586, 38.61877]]], [[[-121.46688, 38.61787], [-121.46568, 38.61786], [-121.46573, 38.61814], [-121.46512, 38.61823], [-121.46482, 38.61821], [-121.46465, 38.61817], [-121.46449, 38.61811], [-121.46435, 38.61803], [-121.46422, 38.61793], [-121.46412, 38.61782], [-121.46402, 38.61762], [-121.46397, 38.61732], [-121.46393, 38.61725], [-121.46375, 38.61709], [-121.46375, 38.61695], [-121.46671, 38.61697], [-121.46688, 38.61787]]]]} | Open Access 1 | 22182 | Johnston Park | 20482 | 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 | 24.225 | Johnston Park | 0 | Local Park 2 | 4 | |
11010 | 11010 | 11009 | {"type": "Polygon", "coordinates": [[[-121.50204, 38.62022], [-121.49848, 38.62022], [-121.49847, 38.62001], [-121.49806, 38.62001], [-121.49806, 38.6179], [-121.49808, 38.61787], [-121.49813, 38.61785], [-121.4987, 38.61784], [-121.49919, 38.61778], [-121.49958, 38.61772], [-121.49996, 38.61763], [-121.50033, 38.61753], [-121.50078, 38.61737], [-121.50142, 38.61707], [-121.50158, 38.61727], [-121.50158, 38.61745], [-121.50188, 38.61843], [-121.50201, 38.61891], [-121.50207, 38.61928], [-121.50209, 38.61953], [-121.50209, 38.62], [-121.50204, 38.62022]]]} | Open Access 1 | 21092 | South Natomas Community Park | 25667 | 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 | 24.224 | South Natomas Community Park | 0 | Local Park 2 | 4 | |
3076 | 3076 | 3075 | {"type": "Polygon", "coordinates": [[[-121.43065, 38.44173], [-121.43038, 38.44183], [-121.43018, 38.44193], [-121.42994, 38.44208], [-121.42974, 38.44226], [-121.42779, 38.44444], [-121.42753, 38.44467], [-121.42719, 38.44487], [-121.4268, 38.44501], [-121.42653, 38.44506], [-121.42632, 38.44509], [-121.42605, 38.44509], [-121.42598, 38.44506], [-121.42597, 38.44502], [-121.42595, 38.44305], [-121.42592, 38.44275], [-121.42584, 38.44245], [-121.42573, 38.4422], [-121.42562, 38.44203], [-121.42536, 38.44167], [-121.42713, 38.44181], [-121.42868, 38.44197], [-121.42893, 38.44195], [-121.43014, 38.44175], [-121.43048, 38.44172], [-121.43065, 38.44173]]]} | Open Access 1 | 21255 | North Laguna Creek Park | 22827 | 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 | 21.437 | North Laguna Creek Park | 0 | Local Park 2 | 4 | |
11061 | 11061 | 11060 | {"type": "Polygon", "coordinates": [[[-121.41796, 38.45057], [-121.41795, 38.45252], [-121.41372, 38.45254], [-121.41369, 38.45135], [-121.41404, 38.45134], [-121.41403, 38.45102], [-121.41368, 38.45103], [-121.41367, 38.4506], [-121.41796, 38.45057]]]} | Open Access 1 | 21252 | Shasta Community Park Site | 25368 | 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 | 19.558 | Shasta Community Park Site | 0 | Local Park 2 | 4 | |
2705 | 2705 | 2704 | {"type": "Polygon", "coordinates": [[[-121.39499, 38.51299], [-121.39497, 38.51489], [-121.39072, 38.51491], [-121.39071, 38.51296], [-121.39129, 38.51296], [-121.39136, 38.513], [-121.39499, 38.51299]]]} | Open Access 1 | 21277 | Army Depot Park | 15599 | 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 | 19.501 | Army Depot Park | 0 | Local Park 2 | 4 | |
5659 | 5659 | 5658 | {"type": "Polygon", "coordinates": [[[-121.50345, 38.57057], [-121.50108, 38.56994], [-121.5024, 38.56688], [-121.50243, 38.56686], [-121.50473, 38.56747], [-121.50477, 38.5675], [-121.50345, 38.57057]]]} | Open Access 1 | 21141 | Southside Park | 25699 | 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 | 19.478 | Southside 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]);