units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534
This data as json, copyable, CSV (advanced)
DES_TP 8
- Local Park 158
- Local Recreation Area 15
- Local Conservation Area 2
- None 1
- None 1
- None 1
- None 1
- None 1
ACCESS_TYP 2
- Open Access 177
- Restricted Access 3
MNG_AG_TYP 1
- City Agency 180
MNG_AGENCY 1
- Sacramento, City of · 180 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4853 | 4853 | 4852 | {"type": "Polygon", "coordinates": [[[-121.46925, 38.47035], [-121.46923, 38.47237], [-121.46889, 38.47237], [-121.46888, 38.47244], [-121.46842, 38.47244], [-121.46844, 38.4715], [-121.46663, 38.47146], [-121.46663, 38.47066], [-121.46925, 38.47035]]]} | Open Access 1 | 21246 | Anthony Park | 15517 | 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.874 | Anthony Park | 0 | Local Park 2 | 4 | |
5133 | 5133 | 5132 | {"type": "Polygon", "coordinates": [[[-121.45225, 38.61393], [-121.45152, 38.61433], [-121.45093, 38.61471], [-121.45092, 38.61393], [-121.45225, 38.61393]]]} | Open Access 1 | 21098 | Triangle Park | 26532 | 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.212 | Triangle Park | 0 | Local Park 2 | 4 | |
5600 | 5600 | 5599 | {"type": "Polygon", "coordinates": [[[-121.42295, 38.46754], [-121.4229, 38.46761], [-121.42273, 38.46753], [-121.42272, 38.4675], [-121.42267, 38.46748], [-121.42263, 38.46749], [-121.42248, 38.46742], [-121.42214, 38.46739], [-121.42183, 38.46766], [-121.42172, 38.46741], [-121.42167, 38.46737], [-121.42169, 38.4673], [-121.42164, 38.46723], [-121.42167, 38.46718], [-121.42139, 38.46662], [-121.42132, 38.4666], [-121.42133, 38.46655], [-121.42132, 38.4665], [-121.4211, 38.46601], [-121.42104, 38.46595], [-121.42111, 38.46585], [-121.42086, 38.46535], [-121.42048, 38.46527], [-121.42045, 38.46527], [-121.42037, 38.46515], [-121.42071, 38.46505], [-121.42058, 38.46477], [-121.42115, 38.46459], [-121.42128, 38.46483], [-121.42135, 38.46487], [-121.42132, 38.46493], [-121.42133, 38.465], [-121.4216, 38.4655], [-121.42164, 38.46554], [-121.42171, 38.46558], [-121.42184, 38.46558], [-121.42201, 38.46589], [-121.42218, 38.4661], [-121.42227, 38.46614], [-121.42223, 38.46622], [-121.42225, 38.46676], [-121.42228, 38.46683], [-121.42233, 38.46688], [-121.42224, 38.46697], [-121.42224, 38.4673], [-121.42252, 38.46733], [-121.42295, 38.46754]]]} | Open Access 1 | 21247 | Wood Park | 27678 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 5.572 | Wood Park | 0 | Local Park 2 | 4 | |
5601 | 5601 | 5600 | {"type": "Polygon", "coordinates": [[[-121.43874, 38.46569], [-121.43819, 38.46739], [-121.43747, 38.46762], [-121.43731, 38.46733], [-121.43733, 38.46729], [-121.43736, 38.46728], [-121.43753, 38.46726], [-121.43749, 38.46696], [-121.43743, 38.46676], [-121.43722, 38.46628], [-121.43718, 38.46613], [-121.43718, 38.46587], [-121.43722, 38.46565], [-121.43727, 38.46551], [-121.43742, 38.46554], [-121.43747, 38.46543], [-121.43874, 38.46569]]]} | Open Access 1 | 21248 | Hite Park | 20009 | 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.378 | Hite Park | 0 | Local Park 2 | 4 | |
5624 | 5624 | 5623 | {"type": "Polygon", "coordinates": [[[-121.42547, 38.54528], [-121.42544, 38.54602], [-121.42545, 38.54693], [-121.42317, 38.54694], [-121.42318, 38.54602], [-121.42372, 38.54602], [-121.42373, 38.54547], [-121.42318, 38.54545], [-121.42318, 38.54528], [-121.42547, 38.54528]]]} | Open Access 1 | 45320 | Mae Fong Park | 21666 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 8.276 | Mae Fong Park | 0 | Local Park 2 | 4 | |
5645 | 5645 | 5644 | {"type": "Polygon", "coordinates": [[[-121.49463, 38.58074], [-121.49425, 38.58162], [-121.49317, 38.58133], [-121.49355, 38.58045], [-121.49463, 38.58074]]]} | Open Access 1 | 21129 | Cesar E. Chavez Plaza | 17105 | 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.537 | Cesar E. Chavez Plaza | 0 | Local Park 2 | 4 | |
5646 | 5646 | 5645 | {"type": "Polygon", "coordinates": [[[-121.42737, 38.57959], [-121.42638, 38.58052], [-121.42618, 38.5804], [-121.42616, 38.5804], [-121.42426, 38.57908], [-121.42522, 38.57816], [-121.42737, 38.57959]]]} | Open Access 1 | 21130 | Glen Hall Park | 19321 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 8.141 | Glen Hall Park | 0 | Local Park 2 | 4 | |
5647 | 5647 | 5646 | {"type": "Polygon", "coordinates": [[[-121.49775, 38.58034], [-121.4976, 38.5807], [-121.49713, 38.58058], [-121.49729, 38.58021], [-121.49775, 38.58034]]]} | Open Access 1 | 21131 | Saint Rose Of Lima Park | 24792 | 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.455 | Saint Rose Of Lima Park | 0 | Local Park 2 | 4 | |
5648 | 5648 | 5647 | {"type": "MultiPolygon", "coordinates": [[[[-121.50611, 38.57814], [-121.50593, 38.57856], [-121.50485, 38.57827], [-121.50503, 38.57785], [-121.50611, 38.57814]]], [[[-121.50632, 38.57767], [-121.50614, 38.57809], [-121.50505, 38.5778], [-121.50523, 38.57738], [-121.50632, 38.57767]]]]} | Open Access 1 | 21132 | Crocker Park | 17825 | 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.429 | Crocker 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 | |
5658 | 5658 | 5657 | {"type": "Polygon", "coordinates": [[[-121.48973, 38.5708], [-121.48934, 38.57169], [-121.48827, 38.5714], [-121.48865, 38.57051], [-121.48973, 38.5708]]]} | Open Access 1 | 21140 | John Fremont Park | 20442 | 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.561 | John Fremont 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 | |
5660 | 5660 | 5659 | {"type": "Polygon", "coordinates": [[[-121.47373, 38.56654], [-121.47334, 38.56743], [-121.47227, 38.56714], [-121.47265, 38.56625], [-121.47373, 38.56654]]]} | Open Access 1 | 21143 | Albert Winn Park | 15339 | 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.556 | Albert Winn Park | 0 | Local Park 2 | 4 | |
5661 | 5661 | 5660 | {"type": "Polygon", "coordinates": [[[-121.46115, 38.56625], [-121.46113, 38.56629], [-121.46094, 38.5663], [-121.46078, 38.56628], [-121.46062, 38.56624], [-121.46046, 38.56617], [-121.46033, 38.56608], [-121.46035, 38.56603], [-121.46115, 38.56625]]]} | Open Access 1 | 21145 | Crescent Park | 17796 | 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.208 | Crescent Park | 0 | Local Park 2 | 4 | |
5662 | 5662 | 5661 | {"type": "Polygon", "coordinates": [[[-121.43833, 38.45244], [-121.43643, 38.45242], [-121.43642, 38.45213], [-121.43738, 38.45213], [-121.43772, 38.45216], [-121.43826, 38.45217], [-121.4383, 38.45218], [-121.43832, 38.45221], [-121.43833, 38.45244]]]} | Open Access 1 | 21253 | John Reith Park | 20465 | 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.298 | John Reith Park | 0 | Local Park 2 | 4 | |
5663 | 5663 | 5662 | {"type": "Polygon", "coordinates": [[[-121.44274, 38.56401], [-121.44259, 38.56436], [-121.4422, 38.56426], [-121.44203, 38.56461], [-121.44198, 38.56461], [-121.44189, 38.56482], [-121.4414, 38.56469], [-121.44111, 38.56537], [-121.44019, 38.56513], [-121.44106, 38.56312], [-121.44249, 38.56349], [-121.44248, 38.56353], [-121.44274, 38.56401]]]} | Open Access 1 | 21147 | East Portal Park | 18379 | 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.354 | East Portal 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 | |
5665 | 5665 | 5664 | {"type": "Polygon", "coordinates": [[[-121.45286, 38.56331], [-121.45268, 38.56368], [-121.45263, 38.56369], [-121.45236, 38.56362], [-121.45254, 38.56322], [-121.45286, 38.56331]]]} | Open Access 1 | 21149 | East Lawn Childrens Park | 18376 | 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.331 | East Lawn Childrens Park | 0 | Local Park 2 | 4 | |
5666 | 5666 | 5665 | {"type": "MultiPolygon", "coordinates": [[[[-121.40892, 38.56163], [-121.4089, 38.5621], [-121.40883, 38.56227], [-121.40819, 38.56243], [-121.40787, 38.5625], [-121.40788, 38.56186], [-121.40892, 38.56163]]], [[[-121.40901, 38.56247], [-121.40895, 38.5634], [-121.4079, 38.56338], [-121.40793, 38.56264], [-121.40833, 38.56256], [-121.40901, 38.56247]]]]} | Open Access 1 | 21150 | University Park | 26687 | 1287 | Sacramento, City of 541 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | Sacramento 41 | 3.716 | University Park | 0 | Local Park 2 | 4 | |
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 |
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]);