superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
34 rows where MNG_AGENCY = 474 sorted by LABEL_NAME
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1739 | 1739 | 1738 | {"type": "Polygon", "coordinates": [[[-118.00113, 35.13116], [-118.00109, 35.13151], [-118.00065, 35.13151], [-118.00029, 35.13147], [-117.99982, 35.13137], [-117.99964, 35.13132], [-117.9993, 35.13118], [-117.99892, 35.13098], [-117.9979, 35.1303], [-117.9976, 35.13013], [-117.99721, 35.12997], [-117.99715, 35.12993], [-117.99671, 35.12983], [-117.99674, 35.1294], [-117.99688, 35.12935], [-117.99695, 35.12927], [-117.99699, 35.12919], [-117.99699, 35.12904], [-117.9971, 35.12863], [-117.99725, 35.12864], [-117.99772, 35.12875], [-117.99799, 35.12884], [-117.9985, 35.12905], [-117.99884, 35.12924], [-118.00029, 35.13017], [-118.00048, 35.13025], [-118.00093, 35.13035], [-118.00096, 35.13084], [-118.00094, 35.13094], [-118.00095, 35.13102], [-118.00106, 35.13113], [-118.00113, 35.13116]]]} | Open Access 1 | Balsitis Park | 15791 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 15.002 | Balsitis Park | ||
2155 | 2155 | 2154 | {"type": "Polygon", "coordinates": [[[-117.83929, 35.17301], [-117.83602, 35.1731], [-117.83577, 35.17263], [-117.8351, 35.17127], [-117.83534, 35.1712], [-117.83775, 35.17071], [-117.83802, 35.17037], [-117.83852, 35.17], [-117.83925, 35.16999], [-117.83929, 35.17301]]]} | Open Access 1 | Borax Bill Park | 16276 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 22.747 | Borax Bill Park | ||
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 | ||
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 | ||
2503 | 2503 | 2502 | {"type": "Polygon", "coordinates": [[[-117.82688, 35.25347], [-117.82591, 35.25347], [-117.8261, 35.25307], [-117.82615, 35.25189], [-117.82627, 35.25163], [-117.82674, 35.25113], [-117.82685, 35.25106], [-117.82688, 35.25347]]]} | Open Access 1 | California City holding 1 | 16689 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 3.93 | California City holding 1 | ||
2504 | 2504 | 2503 | {"type": "Polygon", "coordinates": [[[-117.77229, 35.1638], [-117.77201, 35.16434], [-117.77031, 35.16558], [-117.76994, 35.16597], [-117.76939, 35.167], [-117.76933, 35.16753], [-117.76956, 35.16838], [-117.76975, 35.16886], [-117.76969, 35.16945], [-117.76955, 35.16976], [-117.76951, 35.16914], [-117.76942, 35.16876], [-117.76841, 35.16875], [-117.7684, 35.16826], [-117.76877, 35.1674], [-117.76886, 35.16681], [-117.76891, 35.16627], [-117.76909, 35.16595], [-117.76953, 35.1653], [-117.76956, 35.16465], [-117.76953, 35.16448], [-117.77127, 35.16445], [-117.77161, 35.1644], [-117.77164, 35.16403], [-117.7715, 35.1636], [-117.76951, 35.16363], [-117.76956, 35.16306], [-117.77214, 35.16304], [-117.77216, 35.16319], [-117.77225, 35.16349], [-117.77229, 35.1638]]]} | Open Access 1 | California City holding 10 | 16690 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 16.445 | California City holding 10 | ||
2505 | 2505 | 2504 | {"type": "Polygon", "coordinates": [[[-117.77282, 35.16525], [-117.77268, 35.16555], [-117.77152, 35.16564], [-117.77156, 35.17038], [-117.77014, 35.17041], [-117.76958, 35.17041], [-117.76955, 35.16976], [-117.76969, 35.16945], [-117.76975, 35.16886], [-117.76956, 35.16838], [-117.76933, 35.16752], [-117.76939, 35.167], [-117.76994, 35.16597], [-117.77031, 35.16558], [-117.77201, 35.16434], [-117.77229, 35.1638], [-117.77241, 35.16416], [-117.77269, 35.16479], [-117.77282, 35.16525]]]} | Open Access 1 | California City holding 11 | 16691 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 28.227 | California City holding 11 | ||
2506 | 2506 | 2505 | {"type": "Polygon", "coordinates": [[[-117.66564, 35.18745], [-117.66446, 35.18721], [-117.66334, 35.1867], [-117.66264, 35.18668], [-117.66149, 35.18644], [-117.66562, 35.18641], [-117.66564, 35.18745]]]} | Open Access 1 | California City holding 12 | 16692 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 4.986 | California City holding 12 | ||
2507 | 2507 | 2506 | {"type": "Polygon", "coordinates": [[[-117.78144, 35.18139], [-117.78133, 35.18224], [-117.78107, 35.18291], [-117.78066, 35.18339], [-117.77995, 35.18383], [-117.77895, 35.18418], [-117.77676, 35.18527], [-117.77541, 35.18598], [-117.77414, 35.18683], [-117.77367, 35.1864], [-117.77319, 35.18585], [-117.77433, 35.18523], [-117.77557, 35.18426], [-117.77642, 35.18382], [-117.77685, 35.18375], [-117.7777, 35.18383], [-117.7781, 35.1837], [-117.77848, 35.18343], [-117.77881, 35.18305], [-117.77918, 35.1825], [-117.7797, 35.18139], [-117.78144, 35.18139]]]} | Open Access 1 | California City holding 13 | 16693 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 29.954 | California City holding 13 | ||
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 | ||
1775 | 1775 | 1774 | {"type": "Polygon", "coordinates": [[[-117.81584, 35.18562], [-117.81582, 35.18618], [-117.8141, 35.18621], [-117.81412, 35.18564], [-117.81584, 35.18562]]]} | Open Access 1 | California City holding 16 | 16696 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.424 | California City holding 16 | ||
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 | ||
2488 | 2488 | 2487 | {"type": "Polygon", "coordinates": [[[-117.81411, 35.18564], [-117.8141, 35.18621], [-117.81221, 35.18625], [-117.8123, 35.18612], [-117.81239, 35.18589], [-117.81244, 35.18568], [-117.81411, 35.18564]]]} | Open Access 1 | California City holding 21 | 16702 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 2.484 | California City holding 21 | ||
2489 | 2489 | 2488 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25106], [-117.82674, 35.25113], [-117.82627, 35.25162], [-117.82616, 35.25189], [-117.8261, 35.25307], [-117.82591, 35.25347], [-117.82372, 35.25348], [-117.82367, 35.25201], [-117.82381, 35.25191], [-117.82507, 35.25133], [-117.82579, 35.25117], [-117.82685, 35.25106]]]} | Open Access 1 | California City holding 22 | 16703 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 12.684 | California City holding 22 | ||
2491 | 2491 | 2490 | {"type": "Polygon", "coordinates": [[[-117.82685, 35.25105], [-117.8258, 35.25117], [-117.82507, 35.25133], [-117.82381, 35.25191], [-117.82367, 35.25201], [-117.82363, 35.25017], [-117.82683, 35.25021], [-117.82685, 35.25105]]]} | Open Access 1 | California City holding 23 | 16704 | 1041 | California City, City of 474 | City 2 | City Agency 2 | http://californiacity.com/index.html | City 2 | 9.537 | California City holding 23 |
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]);