units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
220 rows where MNG_AGENCY = 534 sorted by DES_TP
This data as json, copyable, CSV (advanced)
DES_TP 10
- Local Park 152
- Local Recreation Area 18
- 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 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |
5668 | 5668 | 5667 | {"type": "Polygon", "coordinates": [[[-121.45137, 38.55665], [-121.45077, 38.55797], [-121.44992, 38.55774], [-121.45051, 38.55641], [-121.45137, 38.55665]]]} | Open Access 1 | 21153 | Coloma Park | 17525 | 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.044 | Coloma Park | 0 | Local Park 2 | 4 | |
5669 | 5669 | 5668 | {"type": "MultiPolygon", "coordinates": [[[[-121.39146, 38.55714], [-121.39076, 38.55721], [-121.39064, 38.55522], [-121.39032, 38.55522], [-121.38874, 38.55538], [-121.38866, 38.55491], [-121.38868, 38.55472], [-121.38862, 38.55445], [-121.38924, 38.55437], [-121.38979, 38.55436], [-121.38998, 38.55437], [-121.39001, 38.5544], [-121.39002, 38.55448], [-121.3902, 38.55448], [-121.39021, 38.55439], [-121.39026, 38.55436], [-121.39103, 38.55434], [-121.39128, 38.55431], [-121.39146, 38.55714]]], [[[-121.39125, 38.55376], [-121.39098, 38.55378], [-121.391, 38.55418], [-121.39057, 38.55419], [-121.39041, 38.55143], [-121.38987, 38.55054], [-121.39086, 38.55056], [-121.39086, 38.55089], [-121.39111, 38.55127], [-121.39125, 38.55376]]]]} | Open Access 1 | 21154 | Magoichi Oki Park | 21685 | 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 | 15.066 | Magoichi Oki Park | 0 | Local Park 2 | 4 | |
5670 | 5670 | 5669 | {"type": "Polygon", "coordinates": [[[-121.48279, 38.554], [-121.48176, 38.55372], [-121.48174, 38.55259], [-121.48273, 38.55257], [-121.48279, 38.554]]]} | Open Access 1 | 21156 | Sierra 2 Park | 25443 | 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.092 | Sierra 2 Park | 0 | Local Park 2 | 4 | |
5671 | 5671 | 5670 | {"type": "Polygon", "coordinates": [[[-121.47119, 38.54916], [-121.46908, 38.54859], [-121.46921, 38.54825], [-121.4674, 38.54775], [-121.46783, 38.54674], [-121.47117, 38.54673], [-121.47119, 38.54916]]]} | Open Access 1 | 21157 | C.K. McClatchy Park | 16629 | 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 | 15.191 | C.K. McClatchy Park | 0 | Local Park 2 | 4 | |
5672 | 5672 | 5671 | {"type": "Polygon", "coordinates": [[[-121.46014, 38.54819], [-121.4595, 38.54819], [-121.45946, 38.54749], [-121.4601, 38.54751], [-121.46014, 38.54819]]]} | Open Access 1 | 21158 | Fourth Avenue Park | 19027 | 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.076 | Fourth Avenue Park | 0 | Local Park 2 | 4 | |
5674 | 5674 | 5673 | {"type": "MultiPolygon", "coordinates": [[[[-121.47899, 38.54805], [-121.47897, 38.5475], [-121.47908, 38.54753], [-121.47922, 38.54764], [-121.47934, 38.54771], [-121.47961, 38.54777], [-121.47966, 38.54781], [-121.47968, 38.54786], [-121.47968, 38.548], [-121.47963, 38.54804], [-121.47899, 38.54805]]], [[[-121.48009, 38.54377], [-121.47905, 38.54378], [-121.479, 38.5406], [-121.48004, 38.54042], [-121.48009, 38.54377]]], [[[-121.48012, 38.5452], [-121.47907, 38.54521], [-121.47905, 38.54394], [-121.4801, 38.54393], [-121.48012, 38.5452]]], [[[-121.48013, 38.54591], [-121.47908, 38.54592], [-121.47907, 38.54537], [-121.48012, 38.54536], [-121.48013, 38.54591]]], [[[-121.48013, 38.54607], [-121.48015, 38.5473], [-121.48011, 38.54743], [-121.48006, 38.54751], [-121.47998, 38.54758], [-121.47988, 38.54764], [-121.47978, 38.54767], [-121.47955, 38.54769], [-121.47944, 38.54767], [-121.47934, 38.54763], [-121.47924, 38.54756], [-121.47918, 38.5475], [-121.47911, 38.54735], [-121.47908, 38.54608], [-121.48013, 38.54607]]], [[[-121.48031, 38.54803], [-121.47996, 38.54804], [-121.47992, 38.54803], [-121.47989, 38.54799], [-121.47989, 38.54777], [-121.47992, 38.54771], [-121.48006, 38.54762], [-121.48015, 38.54753], [-121.48023, 38.5475], [-121.48029, 38.54749], [-121.48031, 38.54803]]]]} | Open Access 1 | 21160 | William Curtis Park | 27542 | 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.577 | William Curtis 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]);