superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 397
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4040 | 4040 | 4039 | {"type": "Polygon", "coordinates": [[[-122.34342, 40.54925], [-122.34026, 40.54929], [-122.33661, 40.5493], [-122.33662, 40.54563], [-122.33654, 40.54199], [-122.3391, 40.54199], [-122.33934, 40.54222], [-122.33967, 40.54281], [-122.33954, 40.54317], [-122.33981, 40.54565], [-122.34334, 40.54567], [-122.34342, 40.54925]]]} | Open Access 1 | Enterprise Community Park | 18684 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 82.844 | Enterprise Community Park | ||
4287 | 4287 | 4286 | {"type": "Polygon", "coordinates": [[[-122.41204, 40.58349], [-122.41177, 40.5837], [-122.41148, 40.58396], [-122.41121, 40.58411], [-122.41076, 40.58299], [-122.41174, 40.58275], [-122.41204, 40.58349]]]} | Open Access 1 | Foothill Park | 18978 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 2.384 | Foothill Park | ||
4295 | 4295 | 4294 | {"type": "Polygon", "coordinates": [[[-122.40445, 40.56459], [-122.40409, 40.56485], [-122.40378, 40.565], [-122.40356, 40.5647], [-122.40284, 40.56405], [-122.40413, 40.56436], [-122.40445, 40.56459]]]} | Open Access 1 | Indian Hills Park | 20203 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.362 | Indian Hills Park | ||
4357 | 4357 | 4356 | {"type": "Polygon", "coordinates": [[[-122.34472, 40.56826], [-122.34472, 40.56885], [-122.34406, 40.56885], [-122.34407, 40.56832], [-122.34426, 40.56832], [-122.34434, 40.56837], [-122.34442, 40.56839], [-122.34453, 40.56835], [-122.34458, 40.5683], [-122.34459, 40.56825], [-122.34472, 40.56826]]]} | Open Access 1 | Foxtail Park | 19038 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.807 | Foxtail Park | ||
4678 | 4678 | 4677 | {"type": "Polygon", "coordinates": [[[-122.3536, 40.56334], [-122.35329, 40.56334], [-122.35329, 40.56307], [-122.35359, 40.56308], [-122.3536, 40.56334]]]} | Open Access 1 | Graham Park | 19415 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.193 | Graham Park | ||
4962 | 4962 | 4961 | {"type": "Polygon", "coordinates": [[[-122.32063, 40.5651], [-122.32034, 40.5651], [-122.32033, 40.56473], [-122.32062, 40.56473], [-122.32063, 40.5651]]]} | Open Access 1 | Hawn Park | 19750 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.249 | Hawn Park | ||
5951 | 5951 | 5950 | {"type": "MultiPolygon", "coordinates": [[[[-122.40043, 40.59672], [-122.39835, 40.59669], [-122.39835, 40.59669], [-122.39867, 40.5964], [-122.39886, 40.59619], [-122.39893, 40.59622], [-122.39895, 40.59628], [-122.39901, 40.5963], [-122.39905, 40.59628], [-122.3991, 40.59627], [-122.40043, 40.59672]]], [[[-122.40163, 40.59392], [-122.40162, 40.59423], [-122.40122, 40.59516], [-122.40117, 40.59519], [-122.4011, 40.5952], [-122.40106, 40.59531], [-122.40111, 40.59534], [-122.40112, 40.59539], [-122.40067, 40.59641], [-122.40065, 40.59645], [-122.40059, 40.59647], [-122.40052, 40.59647], [-122.39906, 40.59596], [-122.3992, 40.59579], [-122.39947, 40.5954], [-122.39969, 40.595], [-122.39978, 40.59483], [-122.39996, 40.5944], [-122.40008, 40.59396], [-122.40163, 40.59392]]]]} | Open Access 1 | Lake Redding Park | 20963 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 9.978 | Lake Redding Park | ||
6158 | 6158 | 6157 | {"type": "Polygon", "coordinates": [[[-122.3923, 40.58278], [-122.39221, 40.5828], [-122.39188, 40.58203], [-122.39209, 40.58198], [-122.3923, 40.58278]]]} | Open Access 1 | Library Park | 21220 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.299 | Library Park | ||
6726 | 6726 | 6725 | {"type": "Polygon", "coordinates": [[[-122.39352, 40.57271], [-122.39244, 40.57282], [-122.39237, 40.57242], [-122.39254, 40.57239], [-122.39247, 40.57189], [-122.39228, 40.57189], [-122.39222, 40.57152], [-122.3933, 40.57141], [-122.39352, 40.57271]]]} | Open Access 1 | Martin Luther King Jr. Park | 21913 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 3.11 | Martin Luther King Jr. Park | ||
6744 | 6744 | 6743 | {"type": "Polygon", "coordinates": [[[-122.43578, 40.57537], [-122.43495, 40.57556], [-122.43443, 40.57611], [-122.4341, 40.5771], [-122.43043, 40.57569], [-122.43059, 40.57536], [-122.4308, 40.57528], [-122.43097, 40.57518], [-122.43112, 40.57505], [-122.43122, 40.57494], [-122.43187, 40.57365], [-122.43198, 40.57349], [-122.43213, 40.57336], [-122.43229, 40.57325], [-122.43252, 40.57316], [-122.43273, 40.57311], [-122.43306, 40.5731], [-122.43338, 40.57314], [-122.43377, 40.57327], [-122.43397, 40.57337], [-122.43412, 40.57347], [-122.43424, 40.57358], [-122.43439, 40.57377], [-122.43447, 40.57391], [-122.43461, 40.57427], [-122.43473, 40.57445], [-122.43484, 40.57458], [-122.43505, 40.57477], [-122.43554, 40.57511], [-122.43578, 40.57537]]]} | Open Access 1 | Mary Lake Park | 21934 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 26.668 | Mary Lake Park | ||
6860 | 6860 | 6859 | {"type": "Polygon", "coordinates": [[[-122.37493, 40.51983], [-122.37441, 40.52028], [-122.374, 40.52054], [-122.37376, 40.52032], [-122.37416, 40.52006], [-122.37388, 40.51971], [-122.37427, 40.51938], [-122.37493, 40.51983]]]} | Open Access 1 | Meadow Creek Park | 22070 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.471 | Meadow Creek Park | ||
7012 | 7012 | 7011 | {"type": "Polygon", "coordinates": [[[-122.33749, 40.59585], [-122.33659, 40.59638], [-122.3362, 40.59601], [-122.33626, 40.59604], [-122.33632, 40.59606], [-122.33639, 40.59606], [-122.33646, 40.59603], [-122.33651, 40.59599], [-122.33653, 40.59593], [-122.33652, 40.59587], [-122.33649, 40.59584], [-122.3371, 40.59547], [-122.33749, 40.59585]]]} | Open Access 1 | Minder Park | 22259 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.176 | Minder Park | ||
7313 | 7313 | 7312 | {"type": "Polygon", "coordinates": [[[-122.36272, 40.53922], [-122.3624, 40.53935], [-122.36222, 40.53907], [-122.36209, 40.53893], [-122.36194, 40.53846], [-122.36158, 40.53834], [-122.36236, 40.53775], [-122.36265, 40.53834], [-122.36232, 40.53846], [-122.36264, 40.53909], [-122.36272, 40.53922]]]} | No Public Access 3 | Native American Burial Site | 22661 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 1.762 | Native American Burial Site | ||
7644 | 7644 | 7643 | {"type": "Polygon", "coordinates": [[[-122.39151, 40.58627], [-122.39103, 40.58639], [-122.39092, 40.58614], [-122.3914, 40.58601], [-122.39151, 40.58627]]]} | Open Access 1 | Old City Hall | 23083 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.312 | Old City Hall | ||
7971 | 7971 | 7970 | {"type": "MultiPolygon", "coordinates": [[[[-122.3778, 40.56995], [-122.37773, 40.5701], [-122.3777, 40.57024], [-122.3777, 40.57041], [-122.37774, 40.57059], [-122.37773, 40.57063], [-122.37769, 40.57066], [-122.37747, 40.57077], [-122.37732, 40.57092], [-122.37711, 40.5713], [-122.37709, 40.57131], [-122.37696, 40.57161], [-122.37692, 40.57165], [-122.37685, 40.57167], [-122.37667, 40.57165], [-122.37642, 40.57167], [-122.37547, 40.57182], [-122.37535, 40.5719], [-122.37481, 40.57194], [-122.37474, 40.57197], [-122.37461, 40.57199], [-122.37458, 40.57202], [-122.37442, 40.57199], [-122.37494, 40.57155], [-122.37551, 40.57115], [-122.37577, 40.57082], [-122.37613, 40.57044], [-122.37653, 40.56986], [-122.37658, 40.56962], [-122.37723, 40.56968], [-122.3778, 40.56995]]], [[[-122.37914, 40.57064], [-122.37793, 40.57059], [-122.37788, 40.57054], [-122.37784, 40.57039], [-122.37784, 40.57023], [-122.37788, 40.57011], [-122.37793, 40.57001], [-122.37906, 40.57059], [-122.37914, 40.57064]]]]} | Open Access 1 | Parkview Riverfront Park and Trails | 23459 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 8.944 | Parkview Riverfront Park and Trails | ||
8082 | 8082 | 8081 | {"type": "MultiPolygon", "coordinates": [[[[-122.36938, 40.60315], [-122.36928, 40.60328], [-122.36919, 40.60346], [-122.36913, 40.60366], [-122.36912, 40.60377], [-122.36598, 40.6033], [-122.36513, 40.60346], [-122.36477, 40.60236], [-122.36435, 40.60213], [-122.36339, 40.60203], [-122.36335, 40.60023], [-122.36479, 40.60021], [-122.36481, 40.60143], [-122.36532, 40.60165], [-122.36574, 40.60123], [-122.36649, 40.6018], [-122.36653, 40.602], [-122.36938, 40.60315]]], [[[-122.37101, 40.60358], [-122.37056, 40.60414], [-122.37044, 40.60417], [-122.37058, 40.60455], [-122.37002, 40.60475], [-122.36978, 40.60389], [-122.36938, 40.60393], [-122.36936, 40.60386], [-122.36935, 40.6037], [-122.36938, 40.60355], [-122.36949, 40.60333], [-122.36974, 40.60301], [-122.36984, 40.60291], [-122.3701, 40.6027], [-122.37025, 40.60261], [-122.37054, 40.6029], [-122.37032, 40.60312], [-122.37101, 40.60358]]]]} | Open Access 1 | Peppertree Park | 23599 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 24.175 | Peppertree Park | ||
8560 | 8560 | 8559 | {"type": "Polygon", "coordinates": [[[-122.32243, 40.57834], [-122.32243, 40.57907], [-122.32199, 40.57906], [-122.32197, 40.57834], [-122.32243, 40.57834]]]} | Open Access 1 | Ravenwood Park | 24200 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 0.77 | Ravenwood Park | ||
8588 | 8588 | 8587 | {"type": "Polygon", "coordinates": [[[-122.33303, 40.65548], [-122.33271, 40.65558], [-122.33214, 40.65572], [-122.33135, 40.6567], [-122.33143, 40.65679], [-122.33162, 40.65705], [-122.33152, 40.6574], [-122.33089, 40.6578], [-122.33071, 40.65846], [-122.33013, 40.65841], [-122.3297, 40.65941], [-122.32912, 40.65953], [-122.32918, 40.65918], [-122.32917, 40.65909], [-122.32912, 40.65893], [-122.329, 40.65879], [-122.329, 40.65874], [-122.32921, 40.65848], [-122.32936, 40.65828], [-122.32941, 40.65818], [-122.32951, 40.65795], [-122.32973, 40.65777], [-122.32985, 40.65746], [-122.33022, 40.65671], [-122.33077, 40.65619], [-122.33222, 40.65514], [-122.33228, 40.65517], [-122.33261, 40.65497], [-122.33292, 40.65525], [-122.333, 40.65538], [-122.33303, 40.65548]]]} | Open Access 1 | Redding holding 1 | 24232 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 11.166 | Redding holding 1 | ||
8589 | 8589 | 8588 | {"type": "Polygon", "coordinates": [[[-122.3076, 40.57465], [-122.30296, 40.57463], [-122.30287, 40.5745], [-122.30289, 40.57104], [-122.3076, 40.57103], [-122.3076, 40.57465]]]} | Open Access 1 | Redding Soccer Park | 24234 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 39.52 | Redding Soccer Park | ||
8701 | 8701 | 8700 | {"type": "Polygon", "coordinates": [[[-122.42826, 40.56759], [-122.42796, 40.56791], [-122.42804, 40.56814], [-122.42794, 40.56816], [-122.42779, 40.56783], [-122.42747, 40.56764], [-122.42634, 40.56741], [-122.42596, 40.56709], [-122.42536, 40.56709], [-122.42511, 40.56735], [-122.42509, 40.56783], [-122.42553, 40.5688], [-122.42545, 40.56879], [-122.42523, 40.56839], [-122.42492, 40.56848], [-122.42368, 40.56848], [-122.4237, 40.56621], [-122.42486, 40.56621], [-122.42486, 40.56667], [-122.42649, 40.5667], [-122.42676, 40.56621], [-122.42689, 40.56626], [-122.42734, 40.56651], [-122.42751, 40.56672], [-122.4269, 40.56671], [-122.42663, 40.56685], [-122.42641, 40.56688], [-122.4264, 40.56698], [-122.42688, 40.56732], [-122.4277, 40.56758], [-122.42826, 40.56759]]]} | Open Access 1 | Ridgeview Park | 24360 | 1268 | Redding, City of 397 | City 2 | City Agency 2 | http://reddingrecreation.org/ | City 2 | 10.753 | Ridgeview 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]);