units_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 | 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
13094 | 13094 | 13093 | {"type": "Polygon", "coordinates": [[[-122.88631, 39.13873], [-122.88627, 39.14019], [-122.88546, 39.14008], [-122.88385, 39.14009], [-122.88351, 39.13976], [-122.8834, 39.13871], [-122.88631, 39.13873]]]} | Open Access 1 | 35977 | Lake holding 14 | 20900 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 9.084 | Lake holding 14 | 0 | Local Other or Unknown 14 | 4 | |
13190 | 13190 | 13189 | {"type": "Polygon", "coordinates": [[[-122.8466, 39.12359], [-122.8459, 39.1236], [-122.84588, 39.12313], [-122.84659, 39.12311], [-122.8466, 39.12359]]]} | Open Access 1 | 35980 | Hinman County Park | 31183 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.8 | Hinman County Park | 0 | Local Park 2 | 4 | |
13588 | 13588 | 13587 | {"type": "Polygon", "coordinates": [[[-122.76448, 39.00476], [-122.76443, 39.00541], [-122.76419, 39.00534], [-122.76351, 39.00525], [-122.7632, 39.00528], [-122.76329, 39.00446], [-122.76448, 39.00476]]]} | Open Access 1 | 35921 | Lake holding 40 | 20929 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 2.028 | Lake holding 40 | 0 | Local Other or Unknown 14 | 4 | |
13590 | 13590 | 13589 | {"type": "Polygon", "coordinates": [[[-122.88696, 39.13744], [-122.88696, 39.13862], [-122.88631, 39.13862], [-122.88633, 39.13744], [-122.88696, 39.13744]]]} | Open Access 1 | 35924 | Lake holding 1 | 20895 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.798 | Lake holding 1 | 0 | Local Other or Unknown 14 | 4 | |
13591 | 13591 | 13590 | {"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 | 35925 | Lake holding 8 | 20943 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 9.011 | Lake holding 8 | 0 | Local Other or Unknown 14 | 4 | |
13592 | 13592 | 13591 | {"type": "Polygon", "coordinates": [[[-122.67605, 39.02326], [-122.67603, 39.0234], [-122.67559, 39.02335], [-122.67556, 39.02348], [-122.67511, 39.02344], [-122.67522, 39.02283], [-122.67546, 39.02268], [-122.67605, 39.02326]]]} | Open Access 1 | 35927 | Nylander County Park | 31180 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.079 | Nylander County Park | 0 | Local Park 2 | 4 | |
13598 | 13598 | 13597 | {"type": "Polygon", "coordinates": [[[-122.8886, 39.13329], [-122.88859, 39.13509], [-122.88709, 39.13506], [-122.88729, 39.13459], [-122.88721, 39.13418], [-122.88617, 39.13328], [-122.8886, 39.13329]]]} | Open Access 1 | 35935 | Lake holding 12 | 20898 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 6.977 | Lake holding 12 | 0 | Local Other or Unknown 14 | 4 | |
13599 | 13599 | 13598 | {"type": "Polygon", "coordinates": [[[-122.58526, 39.06827], [-122.58519, 39.06843], [-122.58504, 39.06928], [-122.58292, 39.06817], [-122.58196, 39.06838], [-122.58196, 39.06769], [-122.58147, 39.06706], [-122.58332, 39.06644], [-122.58461, 39.06646], [-122.58462, 39.06655], [-122.58457, 39.06748], [-122.58476, 39.06807], [-122.58526, 39.06827]]]} | Open Access 1 | 35939 | Lake holding 38 | 20926 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 13.996 | Lake holding 38 | 0 | Local Other or Unknown 14 | 4 | |
13600 | 13600 | 13599 | {"type": "Polygon", "coordinates": [[[-122.63516, 38.74947], [-122.63921, 38.75517], [-122.63967, 38.75585], [-122.63994, 38.75632], [-122.64033, 38.75706], [-122.6411, 38.75872], [-122.64111, 38.75882], [-122.64108, 38.75887], [-122.64102, 38.75892], [-122.64095, 38.75895], [-122.64084, 38.75895], [-122.64033, 38.75884], [-122.63064, 38.75622], [-122.63516, 38.74947]]]} | Open Access 1 | 35941 | Middleton Trailside Park | 31182 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 106.712 | Middleton Trailside Park | 0 | Local Park 2 | 4 | |
13601 | 13601 | 13600 | {"type": "Polygon", "coordinates": [[[-122.59791, 39.07683], [-122.59784, 39.07698], [-122.59718, 39.07662], [-122.59667, 39.07654], [-122.59596, 39.07635], [-122.59569, 39.07621], [-122.59512, 39.07575], [-122.59518, 39.07571], [-122.59606, 39.07622], [-122.59639, 39.07629], [-122.59691, 39.07631], [-122.59762, 39.07657], [-122.59791, 39.07683]]]} | Open Access 1 | 35942 | Lake holding 35 | 20923 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.335 | Lake holding 35 | 0 | Local Other or Unknown 14 | 4 | |
13602 | 13602 | 13601 | {"type": "Polygon", "coordinates": [[[-122.59518, 39.07571], [-122.59512, 39.07575], [-122.59446, 39.07539], [-122.5943, 39.07507], [-122.59353, 39.07447], [-122.59313, 39.07422], [-122.59266, 39.07372], [-122.59205, 39.07329], [-122.5918, 39.0733], [-122.59211, 39.07315], [-122.593, 39.07393], [-122.59328, 39.07408], [-122.59361, 39.0744], [-122.594, 39.0747], [-122.5946, 39.0751], [-122.59489, 39.07545], [-122.59518, 39.07571]]]} | Open Access 1 | 35943 | Lake holding 34 | 20922 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.324 | Lake holding 34 | 0 | Local Other or Unknown 14 | 4 | |
13607 | 13607 | 13606 | {"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 | 35953 | Lake holding 2 | 20906 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 102.257 | Lake holding 2 | 0 | Local Other or Unknown 14 | 4 | |
13608 | 13608 | 13607 | {"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 | 35954 | Lake holding 48 | 20937 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.887 | Lake holding 48 | 0 | Local Other or Unknown 14 | 4 | |
13609 | 13609 | 13608 | {"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 | 35955 | Lake holding 46 | 20935 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 3.223 | Lake holding 46 | 0 | Local Other or Unknown 14 | 4 | |
13610 | 13610 | 13609 | {"type": "Polygon", "coordinates": [[[-122.58509, 39.05743], [-122.58494, 39.05767], [-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 | 35957 | Lake holding 5 | 20939 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 17.146 | Lake holding 5 | 0 | Local Other or Unknown 14 | 4 | |
13612 | 13612 | 13611 | {"type": "Polygon", "coordinates": [[[-122.58335, 39.05434], [-122.58333, 39.06442], [-122.58269, 39.06461], [-122.58328, 39.06589], [-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 | 35958 | Lake holding 6 | 20941 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 91.232 | Lake holding 6 | 0 | Local Other or Unknown 14 | 4 | |
13613 | 13613 | 13612 | {"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 | 35959 | Lake holding 7 | 20942 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 0.677 | Lake holding 7 | 0 | Local Other or Unknown 14 | 4 | |
13621 | 13621 | 13620 | {"type": "Polygon", "coordinates": [[[-122.84421, 39.12015], [-122.84404, 39.12101], [-122.84402, 39.12101], [-122.84398, 39.1212], [-122.84359, 39.12117], [-122.84377, 39.12015], [-122.84421, 39.12015]]]} | Open Access 1 | 35967 | Lake holding 47 | 20936 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 1.05 | Lake holding 47 | 0 | Local Other or Unknown 14 | 4 | |
13629 | 13629 | 13628 | {"type": "Polygon", "coordinates": [[[-122.88859, 39.13865], [-122.88764, 39.13862], [-122.88763, 39.13743], [-122.88859, 39.13742], [-122.88859, 39.13865]]]} | Open Access 1 | 35975 | Lake holding 15 | 20901 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 2.73 | Lake holding 15 | 0 | Local Other or Unknown 14 | 4 | |
13630 | 13630 | 13629 | {"type": "Polygon", "coordinates": [[[-122.86885, 39.12496], [-122.86874, 39.1253], [-122.86734, 39.12488], [-122.86722, 39.12495], [-122.867, 39.12504], [-122.86675, 39.12513], [-122.86661, 39.1252], [-122.86634, 39.12572], [-122.86476, 39.12547], [-122.8655, 39.12316], [-122.86581, 39.12261], [-122.86586, 39.12261], [-122.86608, 39.12222], [-122.86677, 39.12251], [-122.86602, 39.12361], [-122.86717, 39.12424], [-122.86885, 39.12496]]]} | Open Access 1 | 35982 | Hammond Avenue Park | 31181 | 345 | Lake, County of 279 | County 3 | County Agency 3 | http://parks.lakecountyca.gov/ | County 3 | 345 | Lake, County of 275 | County 3 | County Agency 3 | Lake 40 | 12.675 | Hammond Avenue 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]);