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 id 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
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 |
14715 | 14715 | 14714 | {"type": "Polygon", "coordinates": [[[-121.43457, 38.51775], [-121.4334, 38.51776], [-121.4334, 38.51687], [-121.43456, 38.51684], [-121.43457, 38.51775]]]} | Open Access 1 | 45063 | Artivio Guerrero Park | 32031 | 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 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Fruitridge-Broadway/ArtivioGuerreroPark | Sacramento 41 | 2.508 | Artivio Guerrero Park | 0 | Local Park 2 | 4 |
14274 | 14274 | 14273 | {"type": "Polygon", "coordinates": [[[-121.50527, 38.51694], [-121.50526, 38.51771], [-121.50495, 38.51773], [-121.50492, 38.51813], [-121.5048, 38.51819], [-121.50397, 38.51815], [-121.50311, 38.51796], [-121.50321, 38.5176], [-121.50323, 38.51723], [-121.50436, 38.51724], [-121.50438, 38.5169], [-121.50527, 38.51694]]]} | Open Access 1 | 44200 | Argonaut Park | 15582 | 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.779 | Argonaut Park | 0 | Local Park 2 | 4 | |
14212 | 14212 | 14211 | {"type": "Polygon", "coordinates": [[[-121.49653, 38.54876], [-121.49596, 38.55049], [-121.49243, 38.54982], [-121.49273, 38.54884], [-121.493, 38.54889], [-121.4931, 38.54873], [-121.49326, 38.54876], [-121.49334, 38.54854], [-121.49353, 38.54857], [-121.49363, 38.54821], [-121.49653, 38.54876]]]} | Restricted Access 2 | 44078 | McClatchy School Park | 21999 | 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 | 14.624 | McClatchy School Park | 0 | Local Park 2 | 4 | |
14208 | 14208 | 14207 | {"type": "Polygon", "coordinates": [[[-121.51769, 38.52549], [-121.51733, 38.52654], [-121.51561, 38.52607], [-121.51615, 38.52487], [-121.51653, 38.52496], [-121.51707, 38.52504], [-121.51707, 38.52545], [-121.51769, 38.52549]]]} | Restricted Access 2 | 44071 | Cabrillo School Park | 16644 | 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.003 | Cabrillo School 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 | |
13165 | 13165 | 13164 | {"type": "Polygon", "coordinates": [[[-121.51037, 38.57485], [-121.50985, 38.57539], [-121.50935, 38.57602], [-121.50931, 38.57602], [-121.509, 38.57653], [-121.50884, 38.57687], [-121.50862, 38.57681], [-121.5094, 38.57517], [-121.50959, 38.57464], [-121.51037, 38.57485]]]} | Open Access 1 | 48822 | Pioneer Landing Park | 33541 | 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 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Pioneer-Landing | Sacramento 41 | 2.346 | Pioneer Landing Park | 0 | Local Park 2 | 4 |
13121 | 13121 | 13120 | {"type": "Polygon", "coordinates": [[[-121.48561, 38.56902], [-121.48543, 38.56942], [-121.48476, 38.56924], [-121.48504, 38.56859], [-121.48522, 38.56878], [-121.48533, 38.56887], [-121.48561, 38.56902]]]} | Open Access 1 | 48821 | Brooks Truitt Park | 33540 | 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 | https://www.cityofsacramento.org/ParksandRec/Parks/Park-Directory/Central-City/Brooks-Truitt-Park | Sacramento 41 | 0.896 | Brooks Truitt Park | 0 | Local Park 2 | 4 |
11716 | 11716 | 11715 | {"type": "Polygon", "coordinates": [[[-121.51473, 38.52293], [-121.51454, 38.52353], [-121.51389, 38.5234], [-121.51408, 38.5228], [-121.51473, 38.52293]]]} | Open Access 1 | 24012 | Partnere Off Leash Dog Park | 23486 | 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.002 | Partnere Off Leash Dog Park | 0 | Local Park 2 | 4 | |
11708 | 11708 | 11707 | {"type": "MultiPolygon", "coordinates": [[[[-121.44531, 38.55478], [-121.44524, 38.55494], [-121.44395, 38.55458], [-121.44361, 38.55445], [-121.44357, 38.55443], [-121.44355, 38.55439], [-121.44357, 38.55436], [-121.44361, 38.55436], [-121.44391, 38.5544], [-121.44531, 38.55478]]], [[[-121.44712, 38.55534], [-121.44711, 38.55537], [-121.44708, 38.55539], [-121.44675, 38.55535], [-121.4454, 38.55498], [-121.44547, 38.55483], [-121.44679, 38.55519], [-121.44703, 38.55528], [-121.4471, 38.55531], [-121.44712, 38.55534]]]]} | Open Access 1 | 24005 | Sierra Vista Park | 25469 | 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.305 | Sierra Vista Park | 0 | Local Park 2 | 4 | |
11707 | 11707 | 11706 | {"type": "Polygon", "coordinates": [[[-121.45555, 38.55759], [-121.45548, 38.55775], [-121.45419, 38.55739], [-121.45387, 38.55726], [-121.45385, 38.55722], [-121.45386, 38.55719], [-121.4539, 38.55718], [-121.4543, 38.55725], [-121.45555, 38.55759]]]} | Open Access 1 | 24004 | Sunset Park | 26059 | 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.633 | Sunset 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 | |
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 | |
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 | |
11375 | 11375 | 11374 | {"type": "MultiPolygon", "coordinates": [[[[-121.47396, 38.59528], [-121.47304, 38.59734], [-121.47239, 38.5976], [-121.47263, 38.59799], [-121.4714, 38.59854], [-121.47312, 38.59458], [-121.47347, 38.59486], [-121.47374, 38.59514], [-121.47396, 38.59528]]], [[[-121.4752, 38.59647], [-121.4752, 38.59647], [-121.4733, 38.59725], [-121.47409, 38.59542], [-121.47462, 38.59588], [-121.47501, 38.59634], [-121.4752, 38.59647]]]]} | Open Access 1 | 22179 | Ueda Park Site | 26643 | 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.813 | Ueda Park Site | 0 | Local Park 2 | 4 | |
11082 | 11082 | 11081 | {"type": "Polygon", "coordinates": [[[-121.49491, 38.63481], [-121.49437, 38.63481], [-121.49437, 38.63509], [-121.49423, 38.63516], [-121.49415, 38.63523], [-121.49412, 38.63537], [-121.49415, 38.63543], [-121.49412, 38.63551], [-121.49399, 38.63561], [-121.49396, 38.63568], [-121.49397, 38.63576], [-121.49393, 38.63578], [-121.49363, 38.63532], [-121.49367, 38.63523], [-121.49365, 38.63515], [-121.49359, 38.63508], [-121.4935, 38.63503], [-121.49349, 38.63455], [-121.49356, 38.6342], [-121.49356, 38.63397], [-121.4949, 38.63397], [-121.49491, 38.63481]]]} | Open Access 1 | 21285 | Parkebridge Park | 23442 | 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.969 | Parkebridge Park | 0 | Local Park 2 | 4 | |
11080 | 11080 | 11079 | {"type": "Polygon", "coordinates": [[[-121.52421, 38.63228], [-121.52415, 38.63234], [-121.52343, 38.63269], [-121.52336, 38.63271], [-121.52332, 38.63268], [-121.52264, 38.63201], [-121.52263, 38.63196], [-121.52266, 38.63193], [-121.52337, 38.63149], [-121.52343, 38.63147], [-121.52394, 38.63198], [-121.52421, 38.63228]]]} | Open Access 1 | 21283 | Skylark Park Site | 25537 | 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.524 | Skylark Park Site | 0 | Local Park 2 | 4 | |
11079 | 11079 | 11078 | {"type": "Polygon", "coordinates": [[[-121.55006, 38.64762], [-121.5497, 38.64762], [-121.5496, 38.64772], [-121.54954, 38.6477], [-121.54901, 38.64771], [-121.54896, 38.64772], [-121.54886, 38.64763], [-121.54849, 38.64763], [-121.54847, 38.6466], [-121.5485, 38.64646], [-121.54858, 38.64634], [-121.54874, 38.6462], [-121.54891, 38.64608], [-121.54904, 38.64602], [-121.54922, 38.646], [-121.54938, 38.646], [-121.54954, 38.64605], [-121.54965, 38.6461], [-121.54987, 38.64625], [-121.54998, 38.64638], [-121.55002, 38.64645], [-121.55005, 38.64655], [-121.55006, 38.64762]]]} | Open Access 1 | 21282 | Swainson's Hawk Park Site | 26091 | 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.696 | Swainson's Hawk Park Site | 0 | Local Park 2 | 4 | |
11078 | 11078 | 11077 | {"type": "Polygon", "coordinates": [[[-121.49953, 38.65316], [-121.49936, 38.65321], [-121.49909, 38.65324], [-121.4973, 38.65325], [-121.49735, 38.65296], [-121.49747, 38.65264], [-121.4975, 38.65244], [-121.49749, 38.65172], [-121.49735, 38.65104], [-121.49903, 38.65103], [-121.49925, 38.65104], [-121.49943, 38.65108], [-121.49959, 38.65114], [-121.49974, 38.65122], [-121.49987, 38.65132], [-121.50002, 38.6515], [-121.50011, 38.6517], [-121.50013, 38.65186], [-121.50013, 38.65238], [-121.50012, 38.65255], [-121.50004, 38.65276], [-121.49989, 38.65294], [-121.49976, 38.65304], [-121.49953, 38.65316]]]} | Open Access 1 | 21281 | Meadows Community Park Site | 22095 | 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 | 13.294 | Meadows Community Park Site | 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]);