units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by rowid descending
This data as json, copyable, CSV (advanced)
DES_TP 9
- Local Park 184
- Local Recreation Area 8
- Local Conservation Area 2
- Local Other or Unknown 1
- None 1
- None 1
- None 1
- None 1
- None 1
PARK_URL 3 ✖
ACCESS_TYP 2
- Open Access 199
- No Public Access 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
11081 | 11081 | 11080 | {"type": "Polygon", "coordinates": [[[-121.4988, 38.63277], [-121.49883, 38.63292], [-121.49884, 38.63318], [-121.49883, 38.63338], [-121.49878, 38.6336], [-121.49867, 38.63386], [-121.49859, 38.63399], [-121.49844, 38.6342], [-121.49831, 38.63433], [-121.49805, 38.63455], [-121.49788, 38.63465], [-121.49544, 38.636], [-121.49481, 38.63503], [-121.49437, 38.63503], [-121.49437, 38.63481], [-121.49491, 38.6348], [-121.4949, 38.63397], [-121.49559, 38.63396], [-121.49559, 38.63277], [-121.4988, 38.63277]]]} | Open Access 1 | 21284 | Natomas Baseball Complex | 22667 | 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 | 20.133 | Natomas Baseball Complex | 0 | Local Recreation Area 3 | 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 | |
11077 | 11077 | 11076 | {"type": "Polygon", "coordinates": [[[-121.50622, 38.50363], [-121.50617, 38.50614], [-121.50582, 38.50614], [-121.50585, 38.50608], [-121.50596, 38.50602], [-121.50599, 38.50596], [-121.50598, 38.50589], [-121.50591, 38.50584], [-121.50581, 38.50584], [-121.50575, 38.50587], [-121.50572, 38.50591], [-121.50558, 38.50591], [-121.50563, 38.50416], [-121.50568, 38.50413], [-121.50591, 38.50363], [-121.50622, 38.50363]]]} | Open Access 1 | 21280 | Charlie Jensen Park | 17146 | 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.128 | Charlie Jensen Park | 0 | Local Park 2 | 4 | |
11076 | 11076 | 11075 | {"type": "Polygon", "coordinates": [[[-121.47081, 38.48702], [-121.47078, 38.48705], [-121.47072, 38.48707], [-121.47052, 38.48708], [-121.47021, 38.48715], [-121.46988, 38.48728], [-121.46965, 38.48732], [-121.46956, 38.48731], [-121.46952, 38.48726], [-121.4695, 38.48712], [-121.46919, 38.48628], [-121.46912, 38.486], [-121.46909, 38.48575], [-121.46909, 38.48545], [-121.46913, 38.4853], [-121.46919, 38.48519], [-121.46927, 38.4851], [-121.46943, 38.48499], [-121.46966, 38.48486], [-121.46981, 38.48475], [-121.46995, 38.48456], [-121.46998, 38.48448], [-121.46999, 38.4844], [-121.4706, 38.48441], [-121.47057, 38.48522], [-121.4697, 38.48523], [-121.46969, 38.48578], [-121.46976, 38.48586], [-121.46981, 38.48586], [-121.46981, 38.48615], [-121.46988, 38.48616], [-121.46988, 38.48622], [-121.46993, 38.48628], [-121.47001, 38.4863], [-121.47006, 38.4863], [-121.47011, 38.48629], [-121.47021, 38.48623], [-121.47033, 38.48622], [-121.47072, 38.48625], [-121.47076, 38.48629], [-121.47081, 38.48655], [-121.47081, 38.48702]]]} | Open Access 1 | 21279 | Hampton Park | 19632 | 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.632 | Hampton Park | 0 | Local Park 2 | 4 | |
11075 | 11075 | 11074 | {"type": "MultiPolygon", "coordinates": [[[[-121.4912, 38.54398], [-121.49146, 38.54403], [-121.49149, 38.54405], [-121.4915, 38.54409], [-121.49131, 38.54436], [-121.49116, 38.54469], [-121.49106, 38.54476], [-121.49097, 38.54478], [-121.49093, 38.54475], [-121.49092, 38.54471], [-121.49115, 38.54402], [-121.4912, 38.54398]]], [[[-121.49146, 38.54318], [-121.49151, 38.54319], [-121.49154, 38.54322], [-121.49159, 38.54335], [-121.49154, 38.54364], [-121.49155, 38.54385], [-121.49153, 38.54389], [-121.49148, 38.5439], [-121.49126, 38.54386], [-121.49122, 38.54381], [-121.49141, 38.54321], [-121.49146, 38.54318]]]]} | Open Access 1 | 21278 | Brockway Park | 16413 | 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.923 | Brockway Park | 0 | Local Park 2 | 4 | |
11074 | 11074 | 11073 | {"type": "Polygon", "coordinates": [[[-121.54694, 38.6659], [-121.54415, 38.66702], [-121.54415, 38.66693], [-121.54407, 38.66681], [-121.54401, 38.66683], [-121.5437, 38.66634], [-121.54462, 38.66597], [-121.54509, 38.66576], [-121.54527, 38.66603], [-121.54537, 38.66599], [-121.54548, 38.66591], [-121.54555, 38.66582], [-121.54559, 38.66571], [-121.54565, 38.66571], [-121.54566, 38.66578], [-121.54573, 38.66585], [-121.5458, 38.66587], [-121.54588, 38.66586], [-121.54632, 38.66568], [-121.54635, 38.66565], [-121.54637, 38.6656], [-121.54635, 38.66552], [-121.54673, 38.66552], [-121.54681, 38.66549], [-121.54683, 38.66554], [-121.5468, 38.66557], [-121.54685, 38.66564], [-121.54689, 38.66578], [-121.54694, 38.6659]]]} | Open Access 1 | 21275 | Egret Park | 18467 | 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.719 | Egret Park | 0 | Local Park 2 | 4 | |
11073 | 11073 | 11072 | {"type": "Polygon", "coordinates": [[[-121.49612, 38.47412], [-121.4957, 38.47412], [-121.49569, 38.47406], [-121.49534, 38.47406], [-121.49534, 38.47373], [-121.49529, 38.47367], [-121.49522, 38.47363], [-121.49445, 38.47365], [-121.4944, 38.47363], [-121.49437, 38.47359], [-121.49437, 38.47308], [-121.49435, 38.47289], [-121.49436, 38.47286], [-121.49441, 38.47283], [-121.49467, 38.47279], [-121.49482, 38.47279], [-121.49491, 38.47272], [-121.49494, 38.47263], [-121.49518, 38.47266], [-121.49612, 38.47412]]]} | Open Access 1 | 21274 | LaVar Burton Park | 33228 | 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/South-Sacramento/LeVar-Burton-Park | Sacramento 41 | 3.151 | LaVar Burton Park | 2019 | Local Park 2 | 4 |
11072 | 11072 | 11071 | {"type": "Polygon", "coordinates": [[[-121.4802, 38.48651], [-121.47926, 38.4865], [-121.47864, 38.48614], [-121.47863, 38.48558], [-121.4802, 38.4856], [-121.4802, 38.48651]]]} | Open Access 1 | 21273 | Manuel E. Silva Park | 21765 | 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.152 | Manuel E. Silva Park | 0 | Local Park 2 | 4 | |
11071 | 11071 | 11070 | {"type": "Polygon", "coordinates": [[[-121.48269, 38.48528], [-121.48244, 38.48529], [-121.48206, 38.48546], [-121.48183, 38.48538], [-121.48151, 38.4855], [-121.481, 38.48554], [-121.48048, 38.48553], [-121.48046, 38.48472], [-121.48058, 38.48472], [-121.48059, 38.48463], [-121.48062, 38.48459], [-121.48097, 38.48455], [-121.48121, 38.48449], [-121.48139, 38.48443], [-121.48174, 38.48427], [-121.4819, 38.48422], [-121.48217, 38.48419], [-121.48268, 38.48419], [-121.48269, 38.48528]]]} | Open Access 1 | 21272 | Steve Jones Park | 25840 | 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.717 | Steve Jones 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]);