superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where ACCESS_TYP = 1 and MNG_AGENCY = 265
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency 14
MNG_AGENCY 1
- Rolling Hills Estates, City of · 14 ✖
ACCESS_TYP 1
- Open Access · 14 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
759 | 759 | 758 | {"type": "Polygon", "coordinates": [[[-118.32627, 33.7734], [-118.32628, 33.77344], [-118.32626, 33.77352], [-118.32612, 33.77383], [-118.32571, 33.77354], [-118.32607, 33.77337], [-118.32618, 33.77335], [-118.32624, 33.77337], [-118.32627, 33.7734]]]} | Open Access 1 | Butcher Park | 32701 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 0.369 | Butcher Park | ||
765 | 765 | 764 | {"type": "Polygon", "coordinates": [[[-118.32607, 33.77115], [-118.32599, 33.77123], [-118.32563, 33.77096], [-118.32521, 33.77076], [-118.32461, 33.77039], [-118.32447, 33.77017], [-118.32387, 33.76957], [-118.32369, 33.76922], [-118.32361, 33.769], [-118.32367, 33.76886], [-118.32378, 33.76883], [-118.32391, 33.76911], [-118.32414, 33.76948], [-118.32397, 33.76954], [-118.32402, 33.76965], [-118.32455, 33.77018], [-118.32519, 33.77056], [-118.32541, 33.77066], [-118.32557, 33.77075], [-118.32577, 33.77093], [-118.32607, 33.77115]]]} | Open Access 1 | Miller's Trail | 32708 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1.225 | Miller's Trail | ||
2829 | 2829 | 2828 | {"type": "Polygon", "coordinates": [[[-118.35431, 33.78427], [-118.35235, 33.78499], [-118.35184, 33.78464], [-118.35278, 33.78412], [-118.35191, 33.78351], [-118.35212, 33.78326], [-118.35248, 33.7835], [-118.35279, 33.78319], [-118.35431, 33.78427]]]} | Open Access 1 | Chandler Park and City Hall | 17120 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 5.329 | Chandler Park and City Hall | ||
3438 | 3438 | 3437 | {"type": "Polygon", "coordinates": [[[-118.32787, 33.77344], [-118.3276, 33.77346], [-118.32728, 33.77365], [-118.32683, 33.77368], [-118.32694, 33.77336], [-118.32699, 33.77308], [-118.32778, 33.77278], [-118.32787, 33.77344]]]} | Open Access 1 | Dapplegray Park | 17924 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1.464 | Dapplegray Park | ||
4049 | 4049 | 4048 | {"type": "Polygon", "coordinates": [[[-118.35465, 33.79521], [-118.35105, 33.7952], [-118.34951, 33.7939], [-118.34964, 33.7937], [-118.34986, 33.79344], [-118.35, 33.7933], [-118.35031, 33.79305], [-118.35058, 33.79289], [-118.354, 33.79099], [-118.35465, 33.79521]]]} | Open Access 1 | Ernie Howlett Park | 18697 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 34.409 | Ernie Howlett Park | ||
4538 | 4538 | 4537 | {"type": "Polygon", "coordinates": [[[-118.33718, 33.76768], [-118.33635, 33.76814], [-118.33599, 33.76854], [-118.33549, 33.76865], [-118.33479, 33.76891], [-118.33421, 33.76885], [-118.33391, 33.76892], [-118.33374, 33.76913], [-118.33223, 33.76984], [-118.33131, 33.77004], [-118.3307, 33.77005], [-118.33068, 33.76988], [-118.32983, 33.76993], [-118.32914, 33.77014], [-118.32747, 33.77059], [-118.32699, 33.77124], [-118.32727, 33.77181], [-118.3271, 33.77189], [-118.32733, 33.77234], [-118.32698, 33.77247], [-118.32693, 33.77225], [-118.32676, 33.77186], [-118.32654, 33.77151], [-118.32637, 33.77132], [-118.32611, 33.77107], [-118.3259, 33.77091], [-118.32492, 33.77026], [-118.32701, 33.77025], [-118.32756, 33.76972], [-118.32885, 33.7694], [-118.33031, 33.76865], [-118.33101, 33.76955], [-118.33165, 33.76962], [-118.333, 33.76871], [-118.33343, 33.7675], [-118.33564, 33.76652], [-118.33578, 33.76691], [-118.33655, 33.7668], [-118.33718, 33.76768]]]} | Open Access 1 | George F Canyon Nature Park and Preserve | 19263 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 33.292 | George F Canyon Nature Park and Preserve | ||
5140 | 5140 | 5139 | {"type": "Polygon", "coordinates": [[[-118.38472, 33.7674], [-118.38471, 33.76744], [-118.38366, 33.76744], [-118.38366, 33.7679], [-118.38267, 33.76803], [-118.38088, 33.76799], [-118.3811, 33.76595], [-118.38166, 33.7661], [-118.38244, 33.76619], [-118.38244, 33.76675], [-118.3835, 33.76676], [-118.38351, 33.7674], [-118.38472, 33.7674]]]} | Open Access 1 | Highridge Park | 19951 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 10.727 | Highridge Park | ||
6217 | 6217 | 6216 | {"type": "Polygon", "coordinates": [[[-118.33737, 33.77887], [-118.33716, 33.77986], [-118.3364, 33.78049], [-118.33571, 33.78009], [-118.33621, 33.77894], [-118.33246, 33.7784], [-118.33242, 33.77815], [-118.3333, 33.77828], [-118.33367, 33.77836], [-118.33369, 33.77834], [-118.33737, 33.77887]]]} | Open Access 1 | Linden H. Chandler Preserve - RHE | 21290 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 6.993 | Linden H. Chandler Preserve - RHE | ||
8848 | 8848 | 8847 | {"type": "Polygon", "coordinates": [[[-118.3601, 33.7881], [-118.35853, 33.78827], [-118.35845, 33.78793], [-118.3585, 33.78785], [-118.35958, 33.78763], [-118.35961, 33.7877], [-118.35968, 33.78774], [-118.35976, 33.78774], [-118.3598, 33.78772], [-118.3601, 33.7881]]]} | Open Access 1 | Rockbluff Park | 24514 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1.71 | Rockbluff Park | ||
9683 | 9683 | 9682 | {"type": "Polygon", "coordinates": [[[-118.36382, 33.79119], [-118.36363, 33.79154], [-118.36332, 33.79142], [-118.36294, 33.79131], [-118.36295, 33.79126], [-118.36382, 33.79119]]]} | Open Access 1 | Silver Spur Park | 25494 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 0.398 | Silver Spur Park | ||
12687 | 12687 | 12686 | {"type": "Polygon", "coordinates": [[[-118.35279, 33.78319], [-118.35247, 33.78351], [-118.35212, 33.78326], [-118.35234, 33.78291], [-118.35239, 33.78291], [-118.35279, 33.78319]]]} | Open Access 1 | Pepper Wood Park | 29833 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 0.537 | Pepper Wood Park | ||
12688 | 12688 | 12687 | {"type": "Polygon", "coordinates": [[[-118.36454, 33.7693], [-118.36407, 33.76975], [-118.36351, 33.76944], [-118.36368, 33.76924], [-118.36401, 33.76894], [-118.36408, 33.76895], [-118.36454, 33.7693]]]} | Open Access 1 | Levitt Park | 29836 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 1.118 | Levitt Park | ||
12689 | 12689 | 12688 | {"type": "MultiPolygon", "coordinates": [[[[-118.32142, 33.77464], [-118.32102, 33.77473], [-118.31834, 33.77544], [-118.31832, 33.77535], [-118.32123, 33.77458], [-118.32138, 33.77457], [-118.32142, 33.77464]]], [[[-118.32635, 33.77317], [-118.32602, 33.77328], [-118.32555, 33.77349], [-118.32506, 33.77368], [-118.32436, 33.77389], [-118.3217, 33.77457], [-118.32165, 33.77444], [-118.32332, 33.77403], [-118.32405, 33.77387], [-118.32459, 33.77371], [-118.32495, 33.77357], [-118.32545, 33.77341], [-118.32634, 33.77302], [-118.32635, 33.77317]]], [[[-118.32748, 33.77267], [-118.32699, 33.77284], [-118.32693, 33.77282], [-118.32689, 33.77274], [-118.3269, 33.77269], [-118.32738, 33.77249], [-118.32748, 33.77267]]], [[[-118.33179, 33.77213], [-118.33028, 33.77212], [-118.32945, 33.77218], [-118.32863, 33.77231], [-118.32785, 33.77252], [-118.32759, 33.77261], [-118.32751, 33.77246], [-118.3283, 33.77225], [-118.32871, 33.77216], [-118.32929, 33.77206], [-118.32984, 33.77201], [-118.33067, 33.77201], [-118.33179, 33.77205], [-118.33179, 33.77213]]], [[[-118.3694, 33.79003], [-118.36941, 33.79011], [-118.36939, 33.7902], [-118.36926, 33.79047], [-118.36907, 33.79074], [-118.36884, 33.79097], [-118.36868, 33.79111], [-118.36848, 33.79124], [-118.36816, 33.79136], [-118.36793, 33.79143], [-118.36744, 33.79149], [-118.36707, 33.79147], [-118.36666, 33.79136], [-118.36603, 33.79112], [-118.36584, 33.79107], [-118.3652, 33.79095], [-118.36475, 33.79093], [-118.36394, 33.79098], [-118.36362, 33.79099], [-118.36332, 33.79102], [-118.36329, 33.79096], [-118.36461, 33.79085], [-118.36504, 33.79085], [-118.36523, 33.79086], [-118.36567, 33.79092], [-118.36602, 33.79101], [-118.36694, 33.79133], [-118.36719, 33.79137], [-118.36741, 33.79139], [-118.36772, 33.79136], [-118.36794, 33.79133], [-118.36818, 33.79125], [-118.36845, 33.79112], [-118.3687, 33.79096], [-118.36898, 33.79067], [-118.36936, 33.78999], [-118.3694, 33.79003]]], [[[-118.37239, 33.78615], [-118.37228, 33.78674], [-118.37214, 33.78728], [-118.37186, 33.78788], [-118.37168, 33.78815], [-118.37146, 33.78838], [-118.37112, 33.78864], [-118.37056, 33.78896], [-118.37047, 33.78904], [-118.37019, 33.78919], [-118.37004, 33.78935], [-118.36988, 33.78945], [-118.36978, 33.78954], [-118.36968, 33.78965], [-118.36959, 33.7898], [-118.36949, 33.78975], [-118.36981, 33.78938], [-118.37023, 33.78902], [-118.37064, 33.78875], [-118.37131, 33.78829], [-118.37145, 33.78815], [-118.37164, 33.78792], [-118.3718, 33.78768], [-118.37197, 33.78735], [-118.37233, 33.78617], [-118.37239, 33.78615]]]]} | Open Access 1 | Rolling Hills City Parkland | 29837 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 7.202 | Rolling Hills City Parkland | ||
15517 | 15517 | 15516 | {"type": "Polygon", "coordinates": [[[-118.32989, 33.77012], [-118.3292, 33.7703], [-118.32914, 33.77014], [-118.32983, 33.76993], [-118.32989, 33.77012]]]} | Open Access 1 | George F Canyon Nature Center and Rolling Hills Estates Community Center | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=119 | 29834 | 1283 | Rolling Hills Estates, City of 265 | City 2 | City Agency 2 | http://www.ci.rolling-hills-estates.ca.us/index.aspx?page=109 | City 2 | 0.341 | George F Canyon Nature Ctr. and Rolling Hills Estates Community Ctr. |
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]);