units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by map
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 175
- Local Recreation Area 15
- Local Conservation Area 3
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- City Agency 200
MNG_AGENCY 1
- Sacramento, City of · 200 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2677 | 2677 | 2676 | {"type": "MultiPolygon", "coordinates": [[[[-121.50733, 38.59675], [-121.50729, 38.59681], [-121.50738, 38.5972], [-121.5074, 38.59761], [-121.50734, 38.59781], [-121.50723, 38.59811], [-121.50701, 38.59849], [-121.50643, 38.59867], [-121.50581, 38.59925], [-121.50554, 38.59901], [-121.50556, 38.59898], [-121.50513, 38.59848], [-121.5052, 38.59849], [-121.50527, 38.59847], [-121.50562, 38.59814], [-121.50573, 38.59807], [-121.50586, 38.59795], [-121.50595, 38.59773], [-121.50603, 38.59761], [-121.50614, 38.59752], [-121.50621, 38.5974], [-121.50633, 38.59728], [-121.5065, 38.59703], [-121.5066, 38.59676], [-121.50669, 38.59664], [-121.5069, 38.59658], [-121.50696, 38.59655], [-121.50697, 38.59646], [-121.50718, 38.59646], [-121.50733, 38.59675]]], [[[-121.50573, 38.59935], [-121.50523, 38.5996], [-121.50524, 38.59896], [-121.50539, 38.59909], [-121.50543, 38.59908], [-121.50573, 38.59935]]]]} | Open Access 1 | 21114 | Tiscornia Park | 26374 | 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 | 7.43 | Tiscornia 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 | |
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 | |
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 | |
11033 | 11033 | 11032 | {"type": "MultiPolygon", "coordinates": [[[[-121.53472, 38.49076], [-121.5343, 38.491], [-121.53429, 38.49107], [-121.53384, 38.49145], [-121.53384, 38.4914], [-121.53381, 38.49133], [-121.53356, 38.49116], [-121.53347, 38.49106], [-121.5334, 38.49096], [-121.53334, 38.49078], [-121.53335, 38.49041], [-121.53374, 38.49041], [-121.53416, 38.49048], [-121.53454, 38.49062], [-121.53461, 38.49073], [-121.53466, 38.49075], [-121.53472, 38.49076]]], [[[-121.53464, 38.4912], [-121.53458, 38.4914], [-121.53455, 38.49162], [-121.53454, 38.49285], [-121.53451, 38.4928], [-121.53446, 38.49278], [-121.53446, 38.49218], [-121.53428, 38.49206], [-121.53432, 38.49199], [-121.53431, 38.49195], [-121.53429, 38.49192], [-121.53424, 38.49189], [-121.53418, 38.49188], [-121.53408, 38.49191], [-121.53404, 38.49197], [-121.53404, 38.49204], [-121.53399, 38.49211], [-121.53367, 38.49205], [-121.53397, 38.49168], [-121.5342, 38.49145], [-121.53457, 38.49118], [-121.53464, 38.4912]]]]} | Open Access 1 | 21224 | Portuguese Community Park | 23916 | 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.156 | Portuguese Community Park | 0 | Local Park 2 | 4 | |
4796 | 4796 | 4795 | {"type": "Polygon", "coordinates": [[[-121.38313, 38.64166], [-121.38312, 38.64229], [-121.38237, 38.64219], [-121.38248, 38.64206], [-121.38216, 38.64167], [-121.38223, 38.64159], [-121.38189, 38.64137], [-121.38288, 38.64043], [-121.38306, 38.64097], [-121.38306, 38.64164], [-121.38313, 38.64166]]]} | No Public Access 3 | 48339 | Unnamed Site - Sacramento, City of | 32902 | 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.149 | 0 | Local Other or Unknown 14 | 4 | ||
5667 | 5667 | 5666 | {"type": "Polygon", "coordinates": [[[-121.39164, 38.55995], [-121.3911, 38.55993], [-121.39004, 38.55998], [-121.38947, 38.56007], [-121.38911, 38.56017], [-121.38888, 38.56026], [-121.38882, 38.56025], [-121.38841, 38.55986], [-121.38834, 38.55976], [-121.3883, 38.55966], [-121.38821, 38.55925], [-121.38817, 38.55916], [-121.3881, 38.55904], [-121.38785, 38.5588], [-121.38778, 38.55871], [-121.38776, 38.55867], [-121.38775, 38.55857], [-121.38769, 38.55851], [-121.3877, 38.5585], [-121.38762, 38.55817], [-121.38966, 38.55791], [-121.3915, 38.55772], [-121.39164, 38.55995]]]} | Open Access 1 | 21152 | Glenbrook Park | 19327 | 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.877 | Glenbrook Park | 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 | |
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 |
3077 | 3077 | 3076 | {"type": "Polygon", "coordinates": [[[-121.40888, 38.44576], [-121.4061, 38.44611], [-121.406, 38.44602], [-121.40602, 38.44602], [-121.40603, 38.44601], [-121.4057, 38.44561], [-121.40562, 38.44542], [-121.40567, 38.44537], [-121.40622, 38.44522], [-121.40717, 38.44514], [-121.40731, 38.44516], [-121.40741, 38.44512], [-121.40745, 38.44507], [-121.40746, 38.44502], [-121.40741, 38.4449], [-121.40736, 38.44452], [-121.40738, 38.44446], [-121.4073, 38.44379], [-121.40735, 38.44376], [-121.40786, 38.44372], [-121.408, 38.44374], [-121.40811, 38.4437], [-121.40815, 38.44365], [-121.40816, 38.44359], [-121.4081, 38.44347], [-121.40799, 38.44284], [-121.40804, 38.4428], [-121.40865, 38.44276], [-121.4087, 38.44278], [-121.40872, 38.44281], [-121.40873, 38.4453], [-121.40888, 38.4453], [-121.40888, 38.44576]]]} | Open Access 1 | 21256 | Jacinto Creek Park | 20298 | 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.72 | Jacinto Creek Park | 0 | Local Park 2 | 4 | |
11030 | 11030 | 11029 | {"type": "Polygon", "coordinates": [[[-121.41187, 38.52141], [-121.41191, 38.52138], [-121.41431, 38.52138], [-121.41435, 38.52142], [-121.41435, 38.52203], [-121.41431, 38.52207], [-121.4119, 38.52207], [-121.41187, 38.52203], [-121.41187, 38.52141]]]} | Open Access 1 | 21203 | Max Baer Park | 21964 | 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.087 | Max Baer Park | 0 | Local Park 2 | 4 | |
11040 | 11040 | 11039 | {"type": "Polygon", "coordinates": [[[-121.41239, 38.50369], [-121.4122, 38.50367], [-121.41192, 38.5036], [-121.41174, 38.50359], [-121.40933, 38.5036], [-121.40928, 38.50358], [-121.40925, 38.50354], [-121.4092, 38.50164], [-121.41003, 38.50165], [-121.41004, 38.50189], [-121.41194, 38.50188], [-121.41194, 38.50279], [-121.41192, 38.50288], [-121.41195, 38.50295], [-121.41196, 38.50331], [-121.41239, 38.50331], [-121.41239, 38.50369]]]} | Open Access 1 | 21217 | Danny Nunn Park | 17922 | 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.95 | Danny Nunn Park | 0 | Local Park 2 | 4 | |
3066 | 3066 | 3065 | {"type": "Polygon", "coordinates": [[[-121.41515, 38.51494], [-121.41466, 38.51496], [-121.41407, 38.51503], [-121.41356, 38.51513], [-121.41332, 38.51521], [-121.41296, 38.51529], [-121.41284, 38.5153], [-121.41283, 38.51274], [-121.41469, 38.51273], [-121.4147, 38.51291], [-121.41515, 38.51292], [-121.41515, 38.51494]]]} | Open Access 1 | 21208 | George Sim Park | 19273 | 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 | 12.774 | George Sim 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 | |
5679 | 5679 | 5678 | {"type": "Polygon", "coordinates": [[[-121.41842, 38.53594], [-121.41841, 38.53668], [-121.41809, 38.53668], [-121.41811, 38.53715], [-121.41717, 38.53715], [-121.41717, 38.53667], [-121.41657, 38.53666], [-121.41657, 38.53593], [-121.41842, 38.53594]]]} | Open Access 1 | 21181 | Bill Bean Jr. Memorial Park | 16101 | 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.334 | Bill Bean Jr. Memorial Park | 0 | Local Park 2 | 4 | |
11028 | 11028 | 11027 | {"type": "Polygon", "coordinates": [[[-121.41887, 38.52701], [-121.41887, 38.52784], [-121.41639, 38.52784], [-121.4164, 38.52697], [-121.41887, 38.52701]]]} | Open Access 1 | 21200 | Earl Warren Park | 18354 | 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.008 | Earl Warren Park | 0 | Local Park 2 | 4 | |
3067 | 3067 | 3066 | {"type": "Polygon", "coordinates": [[[-121.41932, 38.54467], [-121.41929, 38.54649], [-121.41847, 38.54648], [-121.41702, 38.54466], [-121.41932, 38.54467]]]} | Open Access 1 | 21168 | Tahoe Tallac Park | 26168 | 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.775 | Tahoe Tallac Park | 0 | Local Park 2 | 4 | |
11038 | 11038 | 11037 | {"type": "Polygon", "coordinates": [[[-121.41952, 38.50592], [-121.41951, 38.5072], [-121.41886, 38.5072], [-121.41886, 38.50592], [-121.41952, 38.50592]]]} | Open Access 1 | 21214 | Camellia Park | 16757 | 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.007 | Camellia Park | 0 | Local Park 2 | 4 | |
15715 | 15715 | 15714 | {"type": "Polygon", "coordinates": [[[-121.41975, 38.62346], [-121.4198, 38.62372], [-121.41981, 38.62399], [-121.41977, 38.62426], [-121.41968, 38.62453], [-121.41958, 38.62472], [-121.41944, 38.62492], [-121.41881, 38.62563], [-121.40843, 38.63518], [-121.40815, 38.63532], [-121.40714, 38.63543], [-121.40592, 38.63611], [-121.40545, 38.6363], [-121.40506, 38.63644], [-121.40444, 38.63661], [-121.40337, 38.63678], [-121.40288, 38.6369], [-121.40098, 38.63755], [-121.4004, 38.63744], [-121.39986, 38.63736], [-121.39945, 38.63746], [-121.39897, 38.63771], [-121.39804, 38.6384], [-121.3975, 38.63872], [-121.39721, 38.63917], [-121.39689, 38.63946], [-121.39644, 38.63969], [-121.39606, 38.64003], [-121.39524, 38.64033], [-121.39482, 38.6405], [-121.39444, 38.64055], [-121.39308, 38.64054], [-121.39247, 38.64056], [-121.39199, 38.64066], [-121.39146, 38.6407], [-121.39082, 38.64075], [-121.39015, 38.64075], [-121.38974, 38.64072], [-121.38942, 38.64064], [-121.38838, 38.64059], [-121.38784, 38.64051], [-121.38759, 38.64039], [-121.38749, 38.64026], [-121.38746, 38.64011], [-121.3875, 38.63999], [-121.38775, 38.63982], [-121.388, 38.63972], [-121.38839, 38.63929], [-121.38849, 38.639], [-121.38852, 38.63878], [-121.38824, 38.63837], [-121.38811, 38.63825], [-121.38805, 38.63812], [-121.38821, 38.6379], [-121.38859, 38.63753], [-121.38866, 38.63728], [-121.38786, 38.63673], [-121.38864, 38.63583], [-121.38938, 38.63532], [-121.39025, 38.63492], [-121.39709, 38.6323], [-121.39865, 38.63406], [-121.39906, 38.63434], [-121.39973, 38.63413], [-121.40058, 38.63399], [-121.40101, 38.63387], [-121.40159, 38.6336], [-121.4014, 38.63335], [-121.4013, 38.63319], [-121.40123, 38.633], [-121.4012, 38.63276], [-121.40121, 38.63258], [-121.40125, 38.6324], [-121.4015, 38.63185], [-121.40152, 38.63171], [-121.40153, 38.63152], [-121.40182, 38.63153], [-121.40428, 38.62982], [-121.40454, 38.62967], [-121.40525, 38.6293], [-121.40598, 38.62895], [-121.4106, 38.62717], [-121.41287, 38.62613], [-121.41367, 38.6258], [-121.4179, 38.62414], [-121.41858, 38.62384], [-121.41921, 38.62353], [-121.41975, 38.62346]]]} | Restricted Access 2 | 34932 | Haggin Oaks Golf Course | 33101 | 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 | 407.841 | Haggin Oaks GC | 0 | Local Recreation Area 3 | 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 |
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]);