superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
218 rows where MNG_AGENCY = 534
This data as json, copyable, CSV (advanced)
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5083 | 5083 | 5082 | {"type": "Polygon", "coordinates": [[[-121.51362, 38.66933], [-121.51356, 38.66936], [-121.51352, 38.66965], [-121.51202, 38.66965], [-121.51203, 38.66902], [-121.51201, 38.66897], [-121.51196, 38.66892], [-121.51187, 38.66888], [-121.51187, 38.66863], [-121.51362, 38.66862], [-121.51363, 38.66917], [-121.5136, 38.66928], [-121.51362, 38.66933]]]} | Open Access 1 | Heron Park | 19879 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.956 | Heron Park | ||
5190 | 5190 | 5189 | {"type": "Polygon", "coordinates": [[[-121.43874, 38.46569], [-121.43819, 38.46739], [-121.43747, 38.46762], [-121.43732, 38.46733], [-121.43733, 38.46729], [-121.43736, 38.46728], [-121.43753, 38.46725], [-121.43749, 38.46696], [-121.43743, 38.46676], [-121.43722, 38.46628], [-121.43718, 38.46612], [-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 | Hite Park | 20009 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.38 | Hite Park | ||
5299 | 5299 | 5298 | {"type": "Polygon", "coordinates": [[[-121.52692, 38.63473], [-121.52678, 38.63528], [-121.52555, 38.63509], [-121.52553, 38.63504], [-121.52557, 38.63475], [-121.52557, 38.6345], [-121.52553, 38.63432], [-121.52544, 38.63404], [-121.52544, 38.634], [-121.52549, 38.63396], [-121.52665, 38.63367], [-121.52679, 38.63402], [-121.52678, 38.63406], [-121.52678, 38.63411], [-121.52684, 38.6342], [-121.52688, 38.63452], [-121.52686, 38.63464], [-121.52687, 38.63468], [-121.52692, 38.63473]]]} | Open Access 1 | Hummingbird Park | 20149 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 4.292 | Hummingbird Park | ||
5386 | 5386 | 5385 | {"type": "Polygon", "coordinates": [[[-121.49051, 38.58452], [-121.49031, 38.58498], [-121.49032, 38.58499], [-121.49039, 38.58502], [-121.49021, 38.58543], [-121.48985, 38.58533], [-121.49004, 38.58488], [-121.48986, 38.58482], [-121.49005, 38.58439], [-121.49051, 38.58452]]]} | Open Access 1 | J. Neely Johnson Park | 20292 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.969 | J. Neely Johnson Park | ||
5431 | 5431 | 5430 | {"type": "Polygon", "coordinates": [[[-121.40888, 38.44576], [-121.4061, 38.44611], [-121.406, 38.44602], [-121.40602, 38.44602], [-121.40602, 38.446], [-121.4057, 38.44561], [-121.40562, 38.44542], [-121.40568, 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.44529], [-121.40888, 38.4453], [-121.40888, 38.44576]]]} | Open Access 1 | Jacinto Creek Park | 20298 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.721 | Jacinto Creek Park | ||
5434 | 5434 | 5433 | {"type": "Polygon", "coordinates": [[[-121.42447, 38.441], [-121.42427, 38.44108], [-121.4241, 38.44111], [-121.42304, 38.44103], [-121.42281, 38.44122], [-121.4226, 38.44135], [-121.42233, 38.44147], [-121.4221, 38.44152], [-121.42195, 38.44149], [-121.42175, 38.44139], [-121.42124, 38.44106], [-121.42109, 38.44103], [-121.42096, 38.44104], [-121.42084, 38.44107], [-121.42063, 38.44118], [-121.4202, 38.44142], [-121.41979, 38.44174], [-121.41976, 38.44175], [-121.41971, 38.44174], [-121.41912, 38.44137], [-121.41894, 38.44131], [-121.41871, 38.44158], [-121.41854, 38.44171], [-121.41828, 38.44184], [-121.418, 38.44191], [-121.41759, 38.44266], [-121.41759, 38.4429], [-121.41749, 38.4429], [-121.41748, 38.44285], [-121.41745, 38.44282], [-121.41736, 38.44279], [-121.41729, 38.4428], [-121.4172, 38.44286], [-121.41714, 38.44288], [-121.4153, 38.44286], [-121.41524, 38.44283], [-121.41522, 38.44275], [-121.41508, 38.44292], [-121.41501, 38.44293], [-121.41501, 38.44335], [-121.41399, 38.44336], [-121.41327, 38.44342], [-121.41121, 38.44344], [-121.41093, 38.44348], [-121.40932, 38.44348], [-121.40906, 38.44363], [-121.40901, 38.44362], [-121.40897, 38.44363], [-121.40879, 38.44356], [-121.40872, 38.44357], [-121.40872, 38.44297], [-121.40873, 38.44301], [-121.40877, 38.44305], [-121.40886, 38.44307], [-121.40893, 38.44306], [-121.40897, 38.44303], [-121.40935, 38.44293], [-121.40975, 38.4429], [-121.40985, 38.44293], [-121.40999, 38.44289], [-121.41014, 38.44289], [-121.41037, 38.44292], [-121.41066, 38.44301], [-121.41094, 38.44307], [-121.41115, 38.44307], [-121.4112, 38.44306], [-121.41215, 38.44305], [-121.41245, 38.44302], [-121.41295, 38.44286], [-121.41322, 38.44281], [-121.41411, 38.4428], [-121.41423, 38.44282], [-121.41431, 38.44281], [-121.4144, 38.44276], [-121.41442, 38.44269], [-121.4146, 38.44268], [-121.41475, 38.44257], [-121.41509, 38.44241], [-121.4153, 38.44244], [-121.41585, 38.44235], [-121.41592, 38.44219], [-121.41597, 38.44212], [-121.41604, 38.44207], [-121.41615, 38.44203], [-121.41615, 38.44165], [-121.41758, 38.44164], [-121.418, 38.44119], [-121.41806, 38.44117], [-121.41811, 38.44113], [-121.4182, 38.44078], [-121.41824, 38.44073], [-121.4183, 38.44071], [-121.41856, 38.4407], [-121.41878, 38.44086], [-121.41922, 38.44072], [-121.41963, 38.44066], [-121.41979, 38.4404], [-121.41997, 38.44031], [-121.42003, 38.44031], [-121.42009, 38.44033], [-121.42035, 38.44052], [-121.42045, 38.44065], [-121.42109, 38.44061], [-121.42135, 38.44062], [-121.42256, 38.44068], [-121.42405, 38.4408], [-121.42411, 38.44079], [-121.42427, 38.44072], [-121.42447, 38.441]]]} | Open Access 1 | Jacinto Creek Parkway | 20299 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 24.724 | Jacinto Creek Parkway | ||
5442 | 5442 | 5441 | {"type": "Polygon", "coordinates": [[[-121.45893, 38.6102], [-121.45821, 38.61059], [-121.45821, 38.61059], [-121.45818, 38.6102], [-121.45893, 38.6102]]]} | Open Access 1 | Jack Rea Park | 20307 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 0.344 | Jack Rea Park | ||
5530 | 5530 | 5529 | {"type": "Polygon", "coordinates": [[[-121.50648, 38.59414], [-121.50589, 38.59413], [-121.50489, 38.59417], [-121.5049, 38.59365], [-121.50497, 38.5932], [-121.50516, 38.59117], [-121.50526, 38.59069], [-121.50529, 38.59069], [-121.50538, 38.59115], [-121.5057, 38.59113], [-121.50574, 38.59129], [-121.50532, 38.59132], [-121.50531, 38.59134], [-121.50604, 38.59332], [-121.50643, 38.59332], [-121.50642, 38.59372], [-121.50644, 38.59396], [-121.50648, 38.59414]]]} | Open Access 1 | Jibboom Street Park | 20410 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.288 | Jibboom Street Park | ||
5547 | 5547 | 5546 | {"type": "Polygon", "coordinates": [[[-121.49759, 38.49088], [-121.49558, 38.49166], [-121.495, 38.49083], [-121.49492, 38.49067], [-121.49489, 38.49056], [-121.49493, 38.49051], [-121.49532, 38.49044], [-121.49563, 38.49034], [-121.49655, 38.49], [-121.4966, 38.49002], [-121.49676, 38.49022], [-121.49701, 38.49045], [-121.49759, 38.49088]]]} | Open Access 1 | John Cabrillo Park | 20431 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.681 | John Cabrillo Park | ||
5556 | 5556 | 5555 | {"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 | John Fremont Park | 20442 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.561 | John Fremont Park | ||
5567 | 5567 | 5566 | {"type": "Polygon", "coordinates": [[[-121.42484, 38.62521], [-121.42456, 38.62529], [-121.42179, 38.62553], [-121.42178, 38.6252], [-121.42158, 38.62521], [-121.42156, 38.62529], [-121.42155, 38.62531], [-121.42156, 38.62555], [-121.42073, 38.62562], [-121.42073, 38.62533], [-121.42219, 38.62387], [-121.42285, 38.62325], [-121.42376, 38.62411], [-121.42484, 38.62521]]]} | Open Access 1 | John Mackey Park At Kenwood Oaks | 20453 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 11.549 | John Mackey Park At Kenwood Oaks | ||
5573 | 5573 | 5572 | {"type": "Polygon", "coordinates": [[[-121.48304, 38.58619], [-121.48265, 38.58708], [-121.4816, 38.58679], [-121.48198, 38.58591], [-121.48304, 38.58619]]]} | Open Access 1 | John Muir Park | 20460 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.505 | John Muir Park | ||
5578 | 5578 | 5577 | {"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 | John Reith Park | 20465 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 1.297 | John Reith Park | ||
5596 | 5596 | 5595 | {"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.46569, 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 | Johnston Park | 20482 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 24.23 | Johnston Park | ||
5606 | 5606 | 5605 | {"type": "Polygon", "coordinates": [[[-121.51894, 38.51107], [-121.51871, 38.51126], [-121.5185, 38.51149], [-121.51835, 38.51173], [-121.51824, 38.512], [-121.51819, 38.51224], [-121.51819, 38.51251], [-121.51838, 38.51344], [-121.5184, 38.51364], [-121.51833, 38.51386], [-121.51792, 38.5146], [-121.51785, 38.51483], [-121.51782, 38.51504], [-121.51782, 38.51523], [-121.51784, 38.51541], [-121.51789, 38.51558], [-121.51796, 38.51576], [-121.51807, 38.51595], [-121.51817, 38.51608], [-121.51855, 38.51647], [-121.51855, 38.51653], [-121.51847, 38.51657], [-121.51823, 38.51664], [-121.51787, 38.51671], [-121.51677, 38.51676], [-121.51664, 38.51676], [-121.51651, 38.51673], [-121.51639, 38.51669], [-121.51568, 38.51631], [-121.51512, 38.51606], [-121.51574, 38.51448], [-121.51599, 38.5133], [-121.51609, 38.5134], [-121.51615, 38.51342], [-121.51629, 38.51343], [-121.51644, 38.5134], [-121.51659, 38.51334], [-121.51691, 38.51331], [-121.51711, 38.51334], [-121.51727, 38.51334], [-121.51741, 38.51329], [-121.51753, 38.51316], [-121.5176, 38.51306], [-121.51778, 38.51255], [-121.51778, 38.51237], [-121.51765, 38.51224], [-121.51766, 38.51207], [-121.51769, 38.51194], [-121.51776, 38.51185], [-121.51782, 38.5118], [-121.51788, 38.51178], [-121.51811, 38.51183], [-121.51817, 38.5118], [-121.5182, 38.51174], [-121.51824, 38.51159], [-121.51805, 38.51131], [-121.51801, 38.51115], [-121.51804, 38.51104], [-121.51797, 38.51087], [-121.51803, 38.51074], [-121.518, 38.51069], [-121.51799, 38.51065], [-121.51807, 38.51059], [-121.51809, 38.51047], [-121.51809, 38.51037], [-121.51806, 38.51027], [-121.51798, 38.51019], [-121.51779, 38.51017], [-121.51781, 38.51006], [-121.51773, 38.50994], [-121.51768, 38.5099], [-121.51763, 38.50978], [-121.51748, 38.50952], [-121.51746, 38.50944], [-121.51807, 38.50984], [-121.51894, 38.51107]]]} | Open Access 1 | Joseph Reichmuth Park | 20498 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 24.635 | Joseph Reichmuth Park | ||
5659 | 5659 | 5658 | {"type": "Polygon", "coordinates": [[[-121.48428, 38.48829], [-121.48427, 38.48823], [-121.48421, 38.48816], [-121.48413, 38.48811], [-121.48406, 38.4881], [-121.48271, 38.48809], [-121.48271, 38.48641], [-121.48428, 38.4864], [-121.48428, 38.48829]]]} | Open Access 1 | Mark Hopkins Park | 21870 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 6.367 | Mark Hopkins Park | ||
5771 | 5771 | 5770 | {"type": "Polygon", "coordinates": [[[-121.52956, 38.66067], [-121.52955, 38.66072], [-121.52948, 38.66087], [-121.52941, 38.66097], [-121.52928, 38.6611], [-121.52909, 38.66123], [-121.52872, 38.66144], [-121.52841, 38.66169], [-121.52837, 38.6617], [-121.52832, 38.66169], [-121.52805, 38.66156], [-121.52784, 38.66147], [-121.52694, 38.66117], [-121.52668, 38.66105], [-121.52641, 38.6609], [-121.52742, 38.65991], [-121.52769, 38.66005], [-121.5281, 38.66022], [-121.52851, 38.66037], [-121.52948, 38.66061], [-121.52953, 38.66063], [-121.52956, 38.66067]]]} | Open Access 1 | Kokomo Park | 20714 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 7.167 | Kokomo Park | ||
6063 | 6063 | 6062 | {"type": "Polygon", "coordinates": [[[-121.45141, 38.52857], [-121.45138, 38.52861], [-121.45006, 38.52916], [-121.45001, 38.52914], [-121.44926, 38.5281], [-121.44925, 38.52806], [-121.44927, 38.52803], [-121.44994, 38.52763], [-121.4501, 38.52749], [-121.45024, 38.52733], [-121.45028, 38.52731], [-121.45035, 38.52733], [-121.4514, 38.52853], [-121.45141, 38.52857]]]} | Open Access 1 | Lawrence Park | 21117 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 5.073 | Lawrence Park | ||
6089 | 6089 | 6088 | {"type": "Polygon", "coordinates": [[[-121.46704, 38.58193], [-121.46665, 38.58281], [-121.46646, 38.58276], [-121.46641, 38.58286], [-121.46554, 38.58263], [-121.46597, 38.58164], [-121.46704, 38.58193]]]} | Open Access 1 | Leland Stanford Park | 21147 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 2.762 | Leland Stanford Park | ||
6134 | 6134 | 6133 | {"type": "Polygon", "coordinates": [[[-121.54983, 38.50739], [-121.54826, 38.50827], [-121.54806, 38.50804], [-121.54827, 38.5079], [-121.54789, 38.50745], [-121.54906, 38.50678], [-121.54983, 38.50739]]]} | Open Access 1 | Lewis Park | 21193 | 1287 | Sacramento, City of 534 | City 2 | City Agency 2 | http://portal.cityofsacramento.org/ParksandRec | City 2 | 3.312 | Lewis Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);