superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 474 and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2508 | 2508 | 2507 | {"type": "Polygon", "coordinates": [[[-117.80335, 35.17567], [-117.80287, 35.17721], [-117.80288, 35.17729], [-117.80266, 35.17732], [-117.80235, 35.17739], [-117.79993, 35.17807], [-117.79977, 35.17642], [-117.79942, 35.17626], [-117.79986, 35.1756], [-117.80077, 35.176], [-117.80113, 35.17576], [-117.80117, 35.17569], [-117.80335, 35.17567]]]} | Open Access 1 | California City holding 14 | 16694 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 15.96 | California City holding 14 | ||
2509 | 2509 | 2508 | {"type": "Polygon", "coordinates": [[[-117.66203, 35.241], [-117.66202, 35.24427], [-117.65941, 35.24431], [-117.65919, 35.24387], [-117.65816, 35.24293], [-117.65836, 35.24106], [-117.66203, 35.241]]]} | Open Access 1 | California City holding 15 | 16695 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 28.555 | California City holding 15 | ||
2510 | 2510 | 2509 | {"type": "Polygon", "coordinates": [[[-117.82635, 35.20202], [-117.82297, 35.20203], [-117.82299, 35.20178], [-117.82297, 35.19927], [-117.8263, 35.19926], [-117.82635, 35.20202]]]} | Open Access 1 | California City holding 17 | 16697 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 23.041 | California City holding 17 | ||
2511 | 2511 | 2510 | {"type": "Polygon", "coordinates": [[[-117.81361, 35.18622], [-117.81361, 35.18722], [-117.81319, 35.1873], [-117.81266, 35.18731], [-117.81267, 35.18624], [-117.81361, 35.18622]]]} | Open Access 1 | California City holding 18 | 16698 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.509 | California City holding 18 | ||
2512 | 2512 | 2511 | {"type": "Polygon", "coordinates": [[[-117.66562, 35.18641], [-117.66149, 35.18644], [-117.65978, 35.18627], [-117.65981, 35.18583], [-117.66561, 35.18594], [-117.66562, 35.18641]]]} | Open Access 1 | California City holding 19 | 16699 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 7.556 | California City holding 19 | ||
2515 | 2515 | 2514 | {"type": "Polygon", "coordinates": [[[-117.81267, 35.18624], [-117.81266, 35.18731], [-117.81188, 35.18733], [-117.81167, 35.1873], [-117.8115, 35.18723], [-117.81141, 35.18718], [-117.81134, 35.1871], [-117.81197, 35.18652], [-117.8121, 35.1864], [-117.81221, 35.18625], [-117.81267, 35.18624]]]} | Open Access 1 | California City holding 2 | 16700 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.492 | California City holding 2 | ||
2516 | 2516 | 2515 | {"type": "Polygon", "coordinates": [[[-117.66566, 35.18855], [-117.65975, 35.1885], [-117.65978, 35.18627], [-117.66149, 35.18644], [-117.66264, 35.18668], [-117.66334, 35.1867], [-117.66446, 35.18721], [-117.66564, 35.18745], [-117.66566, 35.18855]]]} | Open Access 1 | California City holding 20 | 16701 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 26.188 | California City holding 20 | ||
2518 | 2518 | 2517 | {"type": "Polygon", "coordinates": [[[-117.92768, 35.13802], [-117.92733, 35.1383], [-117.92725, 35.13823], [-117.92712, 35.13817], [-117.92695, 35.13813], [-117.92678, 35.13814], [-117.92677, 35.13795], [-117.92672, 35.13781], [-117.92654, 35.13763], [-117.92649, 35.1376], [-117.92638, 35.13756], [-117.92629, 35.13755], [-117.92619, 35.13756], [-117.92606, 35.13764], [-117.92596, 35.13774], [-117.92597, 35.1378], [-117.92601, 35.13782], [-117.92609, 35.13779], [-117.92611, 35.13772], [-117.92625, 35.13764], [-117.92635, 35.13764], [-117.92645, 35.13768], [-117.9266, 35.13781], [-117.92668, 35.13796], [-117.92668, 35.13803], [-117.92664, 35.13816], [-117.92653, 35.13827], [-117.92658, 35.13834], [-117.92669, 35.13826], [-117.92681, 35.13822], [-117.92694, 35.13822], [-117.92702, 35.13822], [-117.92711, 35.13826], [-117.92719, 35.1383], [-117.92725, 35.13837], [-117.92592, 35.13947], [-117.92459, 35.13832], [-117.92635, 35.13688], [-117.92768, 35.13802]]]} | Open Access 1 | California City Memorial Park | 16714 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 9.382 | California City Memorial Park | ||
3760 | 3760 | 3759 | {"type": "Polygon", "coordinates": [[[-117.70274, 35.27024], [-117.69774, 35.27032], [-117.69769, 35.26783], [-117.70266, 35.26773], [-117.70274, 35.27024]]]} | Open Access 1 | E Park | 18331 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 31.113 | E Park | ||
4466 | 4466 | 4465 | {"type": "Polygon", "coordinates": [[[-117.75932, 35.21794], [-117.75625, 35.21792], [-117.75623, 35.21688], [-117.75651, 35.21681], [-117.75643, 35.21662], [-117.75622, 35.21657], [-117.7562, 35.21523], [-117.75745, 35.21522], [-117.75749, 35.2144], [-117.7592, 35.21439], [-117.75928, 35.21695], [-117.75923, 35.217], [-117.75928, 35.21713], [-117.75932, 35.21794]]]} | Open Access 1 | Galileo Hill Park | 19174 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 24.033 | Galileo Hill Park | ||
4813 | 4813 | 4812 | {"type": "Polygon", "coordinates": [[[-117.71537, 35.19254], [-117.71535, 35.19456], [-117.71106, 35.19462], [-117.71102, 35.19263], [-117.71537, 35.19254]]]} | Open Access 1 | H Park | 19580 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 21.644 | H Park | ||
5314 | 5314 | 5313 | {"type": "Polygon", "coordinates": [[[-117.78613, 35.15297], [-117.78142, 35.15322], [-117.78147, 35.15123], [-117.7846, 35.1512], [-117.78608, 35.15118], [-117.78613, 35.15297]]]} | Open Access 1 | I Park | 20168 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 21.99 | I Park | ||
12308 | 12308 | 12307 | {"type": "MultiPolygon", "coordinates": [[[[-117.94984, 35.13219], [-117.94919, 35.13247], [-117.9489, 35.13268], [-117.94835, 35.13286], [-117.9477, 35.13328], [-117.94715, 35.13328], [-117.94713, 35.13315], [-117.94567, 35.13316], [-117.94563, 35.13299], [-117.94471, 35.1329], [-117.94471, 35.13281], [-117.94476, 35.1327], [-117.94507, 35.1326], [-117.94504, 35.13243], [-117.94452, 35.1326], [-117.94441, 35.1326], [-117.94434, 35.13254], [-117.94422, 35.13229], [-117.94412, 35.13222], [-117.94339, 35.13198], [-117.94354, 35.13187], [-117.94361, 35.13167], [-117.94357, 35.13137], [-117.9434, 35.13101], [-117.94349, 35.13096], [-117.9435, 35.13093], [-117.94313, 35.13091], [-117.94315, 35.13046], [-117.9433, 35.13045], [-117.94332, 35.12994], [-117.94289, 35.12993], [-117.94286, 35.13016], [-117.94264, 35.13015], [-117.94267, 35.12929], [-117.94233, 35.12925], [-117.94229, 35.12918], [-117.94098, 35.12914], [-117.94092, 35.12908], [-117.94111, 35.12886], [-117.94107, 35.12882], [-117.94142, 35.12892], [-117.94213, 35.12881], [-117.94255, 35.12865], [-117.94255, 35.1284], [-117.94247, 35.12833], [-117.94236, 35.12785], [-117.94267, 35.1275], [-117.94311, 35.12732], [-117.94325, 35.12741], [-117.94311, 35.12771], [-117.94311, 35.12797], [-117.9434, 35.12807], [-117.94384, 35.12803], [-117.94422, 35.12792], [-117.94423, 35.12764], [-117.94412, 35.12743], [-117.94501, 35.12737], [-117.94523, 35.12746], [-117.94523, 35.12762], [-117.94495, 35.12785], [-117.9449, 35.1283], [-117.94442, 35.12849], [-117.94344, 35.12858], [-117.94331, 35.1287], [-117.94334, 35.12915], [-117.94312, 35.12929], [-117.94311, 35.12953], [-117.94375, 35.12968], [-117.94381, 35.12986], [-117.9437, 35.13002], [-117.9437, 35.1302], [-117.94384, 35.13032], [-117.94437, 35.13043], [-117.9447, 35.13062], [-117.94537, 35.13076], [-117.94551, 35.13094], [-117.94554, 35.13227], [-117.94546, 35.1323], [-117.94546, 35.13232], [-117.94558, 35.13231], [-117.94562, 35.13073], [-117.94666, 35.13073], [-117.94667, 35.13027], [-117.9477, 35.13027], [-117.94772, 35.13113], [-117.9478, 35.13123], [-117.9479, 35.13128], [-117.94815, 35.1313], [-117.94902, 35.13129], [-117.94923, 35.13128], [-117.94932, 35.13125], [-117.9494, 35.13119], [-117.94944, 35.13111], [-117.94945, 35.13026], [-117.94981, 35.13026], [-117.94971, 35.13033], [-117.94965, 35.13041], [-117.94966, 35.13115], [-117.94981, 35.13116], [-117.94984, 35.13219]]], [[[-117.95983, 35.12231], [-117.95872, 35.12232], [-117.95655, 35.12177], [-117.95527, 35.12204], [-117.95512, 35.12207], [-117.95498, 35.12215], [-117.95463, 35.12234], [-117.95354, 35.12419], [-117.95339, 35.12518], [-117.95338, 35.1258], [-117.95164, 35.1258], [-117.95164, 35.12565], [-117.95169, 35.12544], [-117.95179, 35.12528], [-117.9519, 35.12516], [-117.95197, 35.12482], [-117.95181, 35.12444], [-117.95159, 35.12419], [-117.95055, 35.12353], [-117.94994, 35.12329], [-117.94971, 35.12316], [-117.94946, 35.12327], [-117.9491, 35.12355], [-117.94868, 35.12484], [-117.94847, 35.12534], [-117.94855, 35.12537], [-117.9485, 35.12583], [-117.94503, 35.12583], [-117.94502, 35.12557], [-117.94396, 35.12425], [-117.94403, 35.1234], [-117.94411, 35.123], [-117.94433, 35.12284], [-117.94497, 35.12324], [-117.94504, 35.1241], [-117.94539, 35.12444], [-117.94632, 35.12517], [-117.94734, 35.12559], [-117.94869, 35.12353], [-117.9479, 35.12314], [-117.94735, 35.12303], [-117.94684, 35.12276], [-117.94475, 35.12249], [-117.94453, 35.12244], [-117.94455, 35.12223], [-117.94535, 35.12216], [-117.94711, 35.12197], [-117.94786, 35.12211], [-117.94949, 35.12295], [-117.94995, 35.12287], [-117.95071, 35.12241], [-117.95113, 35.12266], [-117.95203, 35.12267], [-117.95237, 35.12257], [-117.95337, 35.12203], [-117.95359, 35.12186], [-117.95369, 35.12163], [-117.95483, 35.12057], [-117.95504, 35.12008], [-117.95513, 35.11981], [-117.95503, 35.1193], [-117.95497, 35.11906], [-117.9549, 35.11863], [-117.95736, 35.11868], [-117.9566, 35.11915], [-117.9566, 35.11917], [-117.95706, 35.11977], [-117.95796, 35.12056], [-117.95832, 35.12077], [-117.95915, 35.12101], [-117.95961, 35.12121], [-117.95983, 35.12121], [-117.95983, 35.12231]]], [[[-117.96166, 35.13066], [-117.96126, 35.13091], [-117.96113, 35.13092], [-117.96104, 35.1309], [-117.96099, 35.13085], [-117.96056, 35.1304], [-117.95966, 35.13056], [-117.95925, 35.13016], [-117.95911, 35.12989], [-117.95782, 35.13009], [-117.9568, 35.13035], [-117.95606, 35.13048], [-117.95568, 35.13035], [-117.95516, 35.13034], [-117.95499, 35.13029], [-117.95449, 35.12986], [-117.95416, 35.12995], [-117.95384, 35.13031], [-117.95312, 35.1307], [-117.95258, 35.13121], [-117.95206, 35.13153], [-117.95173, 35.1316], [-117.95015, 35.13225], [-117.95013, 35.13111], [-117.95031, 35.13108], [-117.95081, 35.13083], [-117.95114, 35.13004], [-117.95112, 35.13003], [-117.95094, 35.13012], [-117.95063, 35.13023], [-117.95045, 35.13028], [-117.95022, 35.13031], [-117.95015, 35.13031], [-117.95013, 35.13014], [-117.95051, 35.13009], [-117.95062, 35.13004], [-117.9507, 35.13003], [-117.95098, 35.12992], [-117.95126, 35.12971], [-117.95141, 35.12956], [-117.95159, 35.12926], [-117.95161, 35.12918], [-117.95165, 35.12888], [-117.95164, 35.12853], [-117.95162, 35.12612], [-117.95344, 35.12612], [-117.95338, 35.12702], [-117.95347, 35.12749], [-117.95333, 35.12797], [-117.95298, 35.12825], [-117.95271, 35.1286], [-117.95263, 35.12887], [-117.95265, 35.1292], [-117.95372, 35.12922], [-117.95375, 35.12895], [-117.95428, 35.12885], [-117.95586, 35.12844], [-117.95667, 35.12839], [-117.95727, 35.12848], [-117.95813, 35.12838], [-117.95863, 35.12857], [-117.95895, 35.12859], [-117.96003, 35.12813], [-117.96003, 35.12819], [-117.96011, 35.12839], [-117.9602, 35.12869], [-117.96041, 35.12912], [-117.96055, 35.12933], [-117.96083, 35.12974], [-117.96166, 35.13066]]]]} | Restricted Access 2 | Tierra Del Sol Golf | 33049 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 178.183 | Tierra Del Sol Golf | ||
13175 | 13175 | 13174 | {"type": "MultiPolygon", "coordinates": [[[[-117.94979, 35.1278], [-117.94897, 35.12779], [-117.9487, 35.12788], [-117.94845, 35.1281], [-117.94846, 35.13001], [-117.94782, 35.13002], [-117.94782, 35.12984], [-117.9478, 35.12855], [-117.94753, 35.12829], [-117.94728, 35.12823], [-117.94692, 35.12838], [-117.94679, 35.12856], [-117.94677, 35.12887], [-117.94677, 35.13003], [-117.94655, 35.13003], [-117.94636, 35.12998], [-117.94627, 35.12999], [-117.9462, 35.13003], [-117.94617, 35.13008], [-117.94615, 35.13017], [-117.94619, 35.13027], [-117.94625, 35.13031], [-117.94633, 35.13033], [-117.94653, 35.13028], [-117.94667, 35.13027], [-117.94667, 35.13073], [-117.94562, 35.13074], [-117.94558, 35.13233], [-117.94541, 35.13232], [-117.94554, 35.13225], [-117.94551, 35.13095], [-117.94538, 35.13076], [-117.9447, 35.13062], [-117.94436, 35.13043], [-117.94384, 35.13032], [-117.9437, 35.1302], [-117.9437, 35.13002], [-117.94381, 35.12986], [-117.94375, 35.12968], [-117.94311, 35.12954], [-117.94311, 35.12929], [-117.94333, 35.12915], [-117.94331, 35.12869], [-117.94345, 35.12858], [-117.94442, 35.12849], [-117.94489, 35.12831], [-117.94495, 35.12785], [-117.94523, 35.12762], [-117.94522, 35.12745], [-117.945, 35.12737], [-117.94413, 35.12743], [-117.94413, 35.12745], [-117.94423, 35.12764], [-117.94423, 35.12791], [-117.94384, 35.12803], [-117.94339, 35.12807], [-117.94311, 35.12798], [-117.94311, 35.12771], [-117.94325, 35.12742], [-117.9431, 35.12732], [-117.94267, 35.1275], [-117.94236, 35.12784], [-117.94247, 35.12833], [-117.94255, 35.1284], [-117.94255, 35.12865], [-117.94214, 35.12881], [-117.94141, 35.12892], [-117.94102, 35.12879], [-117.94103, 35.12755], [-117.94109, 35.12738], [-117.9412, 35.12699], [-117.94123, 35.12672], [-117.94124, 35.12613], [-117.94977, 35.12613], [-117.94979, 35.1278]]], [[[-117.94286, 35.13016], [-117.94286, 35.13018], [-117.94264, 35.13018], [-117.94264, 35.13015], [-117.94286, 35.13016]]], [[[-117.94567, 35.13316], [-117.94481, 35.1331], [-117.94404, 35.133], [-117.94334, 35.13283], [-117.94307, 35.13275], [-117.94334, 35.13215], [-117.94332, 35.13203], [-117.94339, 35.13198], [-117.94412, 35.13222], [-117.94422, 35.13229], [-117.94434, 35.13254], [-117.94441, 35.1326], [-117.94452, 35.1326], [-117.94504, 35.13242], [-117.94508, 35.1326], [-117.94476, 35.1327], [-117.94471, 35.13281], [-117.94471, 35.1329], [-117.94564, 35.13299], [-117.94567, 35.13316]]], [[[-117.94352, 35.13092], [-117.94349, 35.13096], [-117.9434, 35.13101], [-117.94331, 35.13102], [-117.9432, 35.13099], [-117.94313, 35.13092], [-117.94352, 35.13092]]]]} | Restricted Access 2 | California City Central Park/Tierra Del Sol Golf | 33388 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 67.762 | California City Central Park/Tierra Del Sol Golf |
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]);