superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
14 rows where MNG_AGENCY = 265
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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]);