superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
56 rows where MNG_AGENCY = 275
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5922 | 5922 | 5921 | {"type": "Polygon", "coordinates": [[[-122.88764, 39.13862], [-122.88696, 39.13862], [-122.88696, 39.13744], [-122.88763, 39.13743], [-122.88764, 39.13862]]]} | Open Access 1 | Lake holding 16 | 20902 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.908 | Lake holding 16 | ||
5923 | 5923 | 5922 | {"type": "Polygon", "coordinates": [[[-122.89337, 39.13328], [-122.88871, 39.13329], [-122.88871, 39.1332], [-122.88877, 39.13316], [-122.88878, 39.13309], [-122.88874, 39.13303], [-122.88866, 39.133], [-122.88857, 39.13303], [-122.88852, 39.13309], [-122.88854, 39.13316], [-122.8886, 39.1332], [-122.8886, 39.13329], [-122.88617, 39.13328], [-122.8858, 39.13288], [-122.88559, 39.13233], [-122.88591, 39.13145], [-122.88676, 39.12965], [-122.88655, 39.12909], [-122.88418, 39.12758], [-122.88395, 39.12737], [-122.88347, 39.12681], [-122.8834, 39.12657], [-122.88525, 39.12758], [-122.88647, 39.12756], [-122.89334, 39.12755], [-122.89337, 39.13328]]]} | Open Access 1 | Lake holding 2 | 20906 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 102.264 | Lake holding 2 | ||
5924 | 5924 | 5923 | {"type": "Polygon", "coordinates": [[[-122.59606, 39.07511], [-122.59518, 39.07571], [-122.59489, 39.07545], [-122.5946, 39.0751], [-122.594, 39.0747], [-122.59361, 39.0744], [-122.59328, 39.07408], [-122.593, 39.07393], [-122.59211, 39.07315], [-122.5918, 39.0733], [-122.59122, 39.07237], [-122.5919, 39.07178], [-122.59202, 39.07174], [-122.59228, 39.0718], [-122.59256, 39.07206], [-122.59296, 39.07226], [-122.59282, 39.07243], [-122.59295, 39.07245], [-122.59334, 39.07298], [-122.59349, 39.07311], [-122.59358, 39.07331], [-122.59414, 39.07361], [-122.59441, 39.07371], [-122.59455, 39.0738], [-122.59482, 39.07404], [-122.59503, 39.0741], [-122.5955, 39.07444], [-122.5958, 39.07463], [-122.59582, 39.07482], [-122.59596, 39.07494], [-122.59606, 39.07511]]]} | Open Access 1 | Lake holding 21 | 20908 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 13.423 | Lake holding 21 | ||
5925 | 5925 | 5924 | {"type": "Polygon", "coordinates": [[[-122.58053, 39.05051], [-122.57867, 39.0505], [-122.5787, 39.04838], [-122.58003, 39.04844], [-122.58027, 39.04833], [-122.58037, 39.04845], [-122.58009, 39.04849], [-122.5799, 39.04854], [-122.57937, 39.04851], [-122.57927, 39.04866], [-122.57929, 39.0489], [-122.5794, 39.04938], [-122.57964, 39.04988], [-122.58009, 39.05022], [-122.58037, 39.05029], [-122.58053, 39.05041], [-122.58053, 39.05051]]]} | Open Access 1 | Lake holding 22 | 20909 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 4.826 | Lake holding 22 | ||
5926 | 5926 | 5925 | {"type": "Polygon", "coordinates": [[[-122.58644, 39.072], [-122.58591, 39.07249], [-122.58556, 39.07269], [-122.5852, 39.07314], [-122.58404, 39.0735], [-122.5834, 39.07464], [-122.5835, 39.07201], [-122.58382, 39.0711], [-122.58321, 39.07029], [-122.58343, 39.07025], [-122.58507, 39.0697], [-122.58515, 39.06972], [-122.58531, 39.06986], [-122.58546, 39.06993], [-122.586, 39.07005], [-122.58631, 39.07018], [-122.58652, 39.07115], [-122.58654, 39.0716], [-122.58644, 39.072]]]} | Open Access 1 | Lake holding 23 | 20910 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 21.903 | Lake holding 23 | ||
5927 | 5927 | 5926 | {"type": "Polygon", "coordinates": [[[-122.60266, 39.07852], [-122.60246, 39.07885], [-122.60223, 39.07853], [-122.60188, 39.07828], [-122.60102, 39.07803], [-122.60051, 39.07797], [-122.59998, 39.07801], [-122.59948, 39.07772], [-122.59909, 39.07741], [-122.59823, 39.07719], [-122.59784, 39.07698], [-122.59791, 39.07683], [-122.59762, 39.07657], [-122.59691, 39.07631], [-122.59639, 39.07629], [-122.59606, 39.07622], [-122.59518, 39.07571], [-122.59606, 39.07511], [-122.59618, 39.07535], [-122.59641, 39.07554], [-122.59696, 39.07574], [-122.59726, 39.07576], [-122.5984, 39.07616], [-122.59844, 39.07619], [-122.59856, 39.07599], [-122.59904, 39.07605], [-122.60016, 39.07662], [-122.60109, 39.07663], [-122.60164, 39.07693], [-122.60183, 39.07731], [-122.60206, 39.07727], [-122.60226, 39.07761], [-122.60234, 39.07804], [-122.60242, 39.07821], [-122.60253, 39.07838], [-122.60266, 39.07852]]]} | Open Access 1 | Lake holding 25 | 20912 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 18.101 | Lake holding 25 | ||
5928 | 5928 | 5927 | {"type": "Polygon", "coordinates": [[[-122.59666, 39.07534], [-122.59641, 39.07554], [-122.59618, 39.07535], [-122.59606, 39.07511], [-122.59631, 39.07494], [-122.59666, 39.07534]]]} | Open Access 1 | Lake holding 41 | 20930 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.441 | Lake holding 41 | ||
5929 | 5929 | 5928 | {"type": "Polygon", "coordinates": [[[-122.84342, 38.97848], [-122.84318, 38.97845], [-122.843, 38.97792], [-122.84307, 38.97802], [-122.84336, 38.97826], [-122.84341, 38.97837], [-122.84342, 38.97848]]]} | Open Access 1 | Lake holding 45 | 20934 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.209 | Lake holding 45 | ||
5930 | 5930 | 5929 | {"type": "Polygon", "coordinates": [[[-122.8436, 39.12015], [-122.84342, 39.12115], [-122.84209, 39.12103], [-122.84189, 39.12087], [-122.84231, 39.12014], [-122.8436, 39.12015]]]} | Open Access 1 | Lake holding 46 | 20935 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 3.223 | Lake holding 46 | ||
5931 | 5931 | 5930 | {"type": "Polygon", "coordinates": [[[-122.84494, 39.12016], [-122.84493, 39.12125], [-122.84431, 39.12124], [-122.8441, 39.12121], [-122.8443, 39.12016], [-122.84494, 39.12016]]]} | Open Access 1 | Lake holding 48 | 20937 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.887 | Lake holding 48 | ||
5932 | 5932 | 5931 | {"type": "Polygon", "coordinates": [[[-122.78298, 39.06985], [-122.78285, 39.07024], [-122.78253, 39.07024], [-122.78268, 39.06984], [-122.78298, 39.06985]]]} | Open Access 1 | Lake holding 49 | 20938 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.292 | Lake holding 49 | ||
5933 | 5933 | 5932 | {"type": "Polygon", "coordinates": [[[-122.58509, 39.05743], [-122.58494, 39.05768], [-122.58471, 39.0589], [-122.58463, 39.05948], [-122.58473, 39.06], [-122.58334, 39.06003], [-122.58335, 39.05434], [-122.5838, 39.05434], [-122.58428, 39.05545], [-122.58455, 39.05592], [-122.58476, 39.05642], [-122.5849, 39.05694], [-122.58509, 39.05743]]]} | Open Access 1 | Lake holding 5 | 20939 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 17.145 | Lake holding 5 | ||
5934 | 5934 | 5933 | {"type": "Polygon", "coordinates": [[[-122.58394, 39.06571], [-122.58328, 39.06589], [-122.58268, 39.0646], [-122.58334, 39.06442], [-122.58394, 39.06571]]]} | Open Access 1 | Lake holding 50 | 20940 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 2.296 | Lake holding 50 | ||
5935 | 5935 | 5934 | {"type": "Polygon", "coordinates": [[[-122.58335, 39.05434], [-122.58333, 39.06442], [-122.58269, 39.06462], [-122.58327, 39.06588], [-122.58332, 39.06588], [-122.58332, 39.06643], [-122.58147, 39.06705], [-122.58055, 39.06526], [-122.58, 39.06339], [-122.57999, 39.06218], [-122.58069, 39.06177], [-122.58002, 39.0596], [-122.58029, 39.05881], [-122.5797, 39.05518], [-122.57927, 39.05435], [-122.58335, 39.05434]]]} | Open Access 1 | Lake holding 6 | 20941 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 91.245 | Lake holding 6 | ||
5937 | 5937 | 5936 | {"type": "Polygon", "coordinates": [[[-122.59856, 39.07599], [-122.59846, 39.0762], [-122.5984, 39.07616], [-122.59726, 39.07576], [-122.59696, 39.07574], [-122.59671, 39.07565], [-122.59692, 39.07546], [-122.59764, 39.07578], [-122.59831, 39.07595], [-122.59856, 39.07599]]]} | Open Access 1 | Lake holding 7 | 20942 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 0.677 | Lake holding 7 | ||
5938 | 5938 | 5937 | {"type": "Polygon", "coordinates": [[[-122.88635, 39.13614], [-122.8863, 39.13862], [-122.88342, 39.13859], [-122.88375, 39.13812], [-122.88487, 39.13733], [-122.88578, 39.13657], [-122.88635, 39.13614]]]} | Open Access 1 | Lake holding 8 | 20943 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 9.011 | Lake holding 8 | ||
5960 | 5960 | 5959 | {"type": "Polygon", "coordinates": [[[-122.85229, 39.02769], [-122.85033, 39.02801], [-122.84847, 39.02937], [-122.84759, 39.02973], [-122.84753, 39.02691], [-122.84753, 39.02424], [-122.85208, 39.02421], [-122.85209, 39.026], [-122.85226, 39.02602], [-122.85229, 39.02769]]]} | Open Access 1 | Lakeside Park | 20977 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 47.438 | Lakeside Park | ||
6453 | 6453 | 6452 | {"type": "MultiPolygon", "coordinates": [[[[-122.79578, 39.09064], [-122.79316, 39.09184], [-122.7929, 39.09159], [-122.79562, 39.09034], [-122.79578, 39.09064]]], [[[-122.79712, 39.0901], [-122.79604, 39.09058], [-122.79567, 39.0898], [-122.79554, 39.08961], [-122.79536, 39.08941], [-122.7961, 39.08908], [-122.79625, 39.08915], [-122.79632, 39.08922], [-122.79651, 39.08943], [-122.79661, 39.08959], [-122.79677, 39.08968], [-122.79696, 39.08974], [-122.79707, 39.08983], [-122.79713, 39.08998], [-122.79712, 39.0901]]]]} | Open Access 1 | Lucerne Harbor County Park | 21576 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 5.641 | Lucerne Harbor County Park | ||
6454 | 6454 | 6453 | {"type": "MultiPolygon", "coordinates": [[[[-122.79242, 39.08558], [-122.79204, 39.08575], [-122.7918, 39.08552], [-122.79166, 39.08535], [-122.7915, 39.08506], [-122.79145, 39.08486], [-122.7914, 39.08451], [-122.79189, 39.08428], [-122.79198, 39.08444], [-122.7921, 39.08494], [-122.79217, 39.08506], [-122.79233, 39.08547], [-122.79242, 39.08558]]], [[[-122.79502, 39.08842], [-122.79451, 39.08867], [-122.79377, 39.08745], [-122.79383, 39.08734], [-122.79383, 39.0873], [-122.7938, 39.08722], [-122.79366, 39.08727], [-122.79352, 39.08714], [-122.79358, 39.08712], [-122.79358, 39.0871], [-122.79347, 39.0871], [-122.79242, 39.08611], [-122.79288, 39.08589], [-122.79301, 39.08596], [-122.79308, 39.0861], [-122.79325, 39.08622], [-122.79356, 39.08657], [-122.79421, 39.08685], [-122.79432, 39.087], [-122.79431, 39.08751], [-122.79436, 39.08767], [-122.79453, 39.08784], [-122.79458, 39.08796], [-122.79466, 39.08809], [-122.79486, 39.08824], [-122.79502, 39.08842]]], [[[-122.79734, 39.09099], [-122.7968, 39.09122], [-122.79645, 39.09104], [-122.79631, 39.09093], [-122.7962, 39.09079], [-122.79608, 39.09056], [-122.79712, 39.0901], [-122.79712, 39.09016], [-122.79706, 39.09028], [-122.79704, 39.09036], [-122.7971, 39.09061], [-122.79717, 39.09082], [-122.79734, 39.09099]]], [[[-122.79938, 39.09182], [-122.79934, 39.09201], [-122.79853, 39.09245], [-122.7981, 39.092], [-122.79897, 39.09161], [-122.79938, 39.09182]]], [[[-122.79971, 39.0928], [-122.79909, 39.09308], [-122.79874, 39.09269], [-122.79924, 39.09247], [-122.79931, 39.09261], [-122.79939, 39.09271], [-122.79947, 39.09275], [-122.79956, 39.09271], [-122.79964, 39.09277], [-122.79971, 39.0928]]], [[[-122.80016, 39.09381], [-122.80013, 39.09375], [-122.79982, 39.09389], [-122.79943, 39.09346], [-122.80005, 39.09318], [-122.8, 39.09329], [-122.80009, 39.09362], [-122.80014, 39.0937], [-122.80016, 39.09381]]], [[[-122.80057, 39.09394], [-122.80057, 39.09394], [-122.80056, 39.09394], [-122.80056, 39.09394], [-122.80057, 39.09394]]], [[[-122.80054, 39.09395], [-122.80042, 39.09397], [-122.80049, 39.09395], [-122.80054, 39.09395]]], [[[-122.80166, 39.09528], [-122.80146, 39.09536], [-122.80125, 39.09547], [-122.80071, 39.09487], [-122.80152, 39.09441], [-122.80144, 39.09469], [-122.80166, 39.09528]]]]} | Open Access 1 | Lucerne Park | 21577 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 11.444 | Lucerne Park | 0 | |
6976 | 6976 | 6975 | {"type": "Polygon", "coordinates": [[[-122.61613, 38.75511], [-122.61574, 38.75571], [-122.61516, 38.75555], [-122.61543, 38.75493], [-122.61613, 38.75511]]]} | Open Access 1 | Middletown Park | 22209 | 345 | Lake, County of 275 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 1.072 | Middletown 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]);