superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
28 rows where ACCESS_TYP = 1 and MNG_AGENCY = 287 sorted by PARK_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1236 | 1236 | 1235 | {"type": "Polygon", "coordinates": [[[-118.01451, 33.95008], [-118.01401, 33.9514], [-118.01308, 33.95088], [-118.01304, 33.95089], [-118.01275, 33.95073], [-118.01441, 33.95002], [-118.01451, 33.95008]]]} | Open Access 1 | Anaconda Park | 15464 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.702 | Anaconda Park | ||
10445 | 10445 | 10444 | {"type": "MultiPolygon", "coordinates": [[[[-118.01025, 33.96928], [-118.00905, 33.97078], [-118.0088, 33.97086], [-118.00826, 33.97078], [-118.00886, 33.97002], [-118.00795, 33.9695], [-118.00792, 33.9694], [-118.00843, 33.96896], [-118.00845, 33.96883], [-118.00937, 33.96935], [-118.00969, 33.96896], [-118.01025, 33.96928]]], [[[-118.01077, 33.9639], [-118.01053, 33.9642], [-118.01004, 33.96394], [-118.01029, 33.9636], [-118.01076, 33.96386], [-118.01077, 33.9639]]]]} | Open Access 1 | Arroyo Pescadero | http://www.habitatauthority.org/trails/ | 28934 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 6.298 | Arroyo Pescadero | |
2267 | 2267 | 2266 | {"type": "MultiPolygon", "coordinates": [[[[-118.03963, 33.98542], [-118.03962, 33.98623], [-118.03916, 33.98622], [-118.03917, 33.98541], [-118.03963, 33.98542]]], [[[-118.04078, 33.98623], [-118.03971, 33.98623], [-118.0397, 33.98582], [-118.04077, 33.98583], [-118.04078, 33.98623]]]]} | Open Access 1 | Broadway Park | 16409 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.032 | Broadway Park | ||
2776 | 2776 | 2775 | {"type": "Polygon", "coordinates": [[[-118.03492, 33.98096], [-118.03491, 33.98163], [-118.03392, 33.98163], [-118.03394, 33.98096], [-118.03492, 33.98096]]]} | Open Access 1 | Central Park | 17064 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1.688 | Central Park | ||
4339 | 4339 | 4338 | {"type": "MultiPolygon", "coordinates": [[[[-118.0454, 33.98641], [-118.0454, 33.98717], [-118.04443, 33.98717], [-118.04443, 33.9864], [-118.0454, 33.98641]]], [[[-118.04592, 33.9864], [-118.04592, 33.98717], [-118.04548, 33.98716], [-118.04548, 33.9864], [-118.04592, 33.9864]]], [[[-118.04752, 33.98641], [-118.04752, 33.98724], [-118.04609, 33.98725], [-118.0461, 33.98641], [-118.04752, 33.98641]]]]} | Open Access 1 | Founders Memorial Park | 19019 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 5.779 | Founders Memorial Park | ||
4424 | 4424 | 4423 | {"type": "Polygon", "coordinates": [[[-118.03492, 33.97189], [-118.03492, 33.97353], [-118.03427, 33.97353], [-118.03331, 33.9734], [-118.03332, 33.97241], [-118.03385, 33.9724], [-118.03385, 33.97215], [-118.03394, 33.97214], [-118.03395, 33.97189], [-118.0344, 33.9719], [-118.03442, 33.97215], [-118.03447, 33.97213], [-118.03448, 33.9719], [-118.03492, 33.97189]]]} | Open Access 1 | Friends Park Complex | 19117 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 5.692 | Friends Park Complex | ||
1378 | 1378 | 1377 | {"type": "MultiPolygon", "coordinates": [[[[-118.03213, 33.99081], [-118.03186, 33.9908], [-118.03187, 33.99053], [-118.03212, 33.99053], [-118.03213, 33.99081]]], [[[-118.03399, 33.98995], [-118.03398, 33.99019], [-118.0325, 33.99019], [-118.03251, 33.98994], [-118.03399, 33.98995]]], [[[-118.03322, 33.98945], [-118.03321, 33.98986], [-118.03274, 33.98986], [-118.03275, 33.98944], [-118.03322, 33.98945]]], [[[-118.03607, 33.99067], [-118.03607, 33.99067], [-118.03508, 33.99066], [-118.03587, 33.99044], [-118.03606, 33.99043], [-118.03607, 33.99067]]], [[[-118.03783, 33.99604], [-118.03756, 33.99644], [-118.03728, 33.99647], [-118.03727, 33.99604], [-118.03757, 33.99584], [-118.03783, 33.99604]]], [[[-118.0374, 33.99507], [-118.03728, 33.99507], [-118.03728, 33.99483], [-118.03734, 33.99483], [-118.0374, 33.99507]]], [[[-118.03924, 33.99587], [-118.0392, 33.99627], [-118.0389, 33.9963], [-118.03892, 33.99616], [-118.03906, 33.99613], [-118.03913, 33.99609], [-118.03915, 33.99604], [-118.03917, 33.99586], [-118.03924, 33.99587]]], [[[-118.04615, 34.00015], [-118.04611, 34.00027], [-118.04606, 34.00029], [-118.046, 34.00034], [-118.04595, 34.00041], [-118.04595, 34.00044], [-118.04593, 34.00044], [-118.04593, 34.00008], [-118.04615, 34.00015]]]]} | Open Access 1 | Hellman Park | http://www.lamountains.com/parks.asp?parkid=633 | 14853 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.86 | Hellman Park | |
5245 | 5245 | 5244 | {"type": "MultiPolygon", "coordinates": [[[[-118.05395, 33.99771], [-118.05385, 33.99785], [-118.05376, 33.9978], [-118.05374, 33.99776], [-118.05379, 33.99767], [-118.05387, 33.99761], [-118.05395, 33.99771]]], [[[-118.05481, 33.99824], [-118.05455, 33.99845], [-118.05418, 33.99801], [-118.0541, 33.99797], [-118.05419, 33.99786], [-118.05447, 33.99773], [-118.05481, 33.99824]]], [[[-118.05463, 33.99697], [-118.05456, 33.99704], [-118.05445, 33.99709], [-118.05438, 33.99708], [-118.05432, 33.99701], [-118.05462, 33.99687], [-118.05463, 33.99697]]]]} | Open Access 1 | Hoover Fountain and Park | 20078 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.789 | Hoover Fountain and Park | ||
5416 | 5416 | 5415 | {"type": "Polygon", "coordinates": [[[-118.04432, 33.97678], [-118.04324, 33.97681], [-118.04324, 33.97595], [-118.04431, 33.97595], [-118.04432, 33.97678]]]} | Open Access 1 | J.G. Whittier Park | 20294 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 2.325 | J.G. Whittier Park | ||
4583 | 4583 | 4582 | {"type": "Polygon", "coordinates": [[[-118.0358, 33.96005], [-118.03541, 33.96044], [-118.03449, 33.95981], [-118.03489, 33.95943], [-118.0358, 33.96005]]]} | Open Access 1 | Kennedy Park | 20601 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1.527 | Kennedy Park | ||
14743 | 14743 | 14742 | {"type": "Polygon", "coordinates": [[[-118.00215, 33.94886], [-118.00214, 33.9489], [-118.00206, 33.949], [-118.002, 33.94912], [-118.00178, 33.94976], [-118.00198, 33.94984], [-118.00196, 33.94995], [-118.00167, 33.9504], [-118.0013, 33.95135], [-118.00092, 33.95167], [-118.00051, 33.95194], [-118.00042, 33.9518], [-118.0004, 33.95175], [-118.0004, 33.95168], [-118.00045, 33.95164], [-118.00065, 33.95159], [-118.00085, 33.95147], [-118.00099, 33.95134], [-118.00109, 33.95122], [-118.00154, 33.95019], [-118.00168, 33.94978], [-118.00193, 33.94917], [-118.00205, 33.94898], [-118.00215, 33.94886]]]} | Open Access 1 | La Serna Drive Open Space | 20807 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 1.663 | La Serna Drive OS | ||
6050 | 6050 | 6049 | {"type": "Polygon", "coordinates": [[[-118.02931, 33.95594], [-118.0286, 33.95664], [-118.02858, 33.95668], [-118.02856, 33.95668], [-118.0283, 33.9565], [-118.02902, 33.95578], [-118.02909, 33.95578], [-118.02931, 33.95594]]]} | Open Access 1 | Laurel Park | 21103 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.838 | Laurel Park | ||
6078 | 6078 | 6077 | {"type": "Polygon", "coordinates": [[[-118.03725, 33.96882], [-118.03725, 33.96957], [-118.03679, 33.96957], [-118.0368, 33.96954], [-118.0368, 33.96881], [-118.03725, 33.96882]]]} | Open Access 1 | Lee Owens Park | 21134 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.873 | Lee Owens Park | ||
6080 | 6080 | 6079 | {"type": "Polygon", "coordinates": [[[-117.99593, 33.93932], [-117.99532, 33.9402], [-117.99459, 33.93977], [-117.99393, 33.93977], [-117.99376, 33.94011], [-117.99329, 33.94011], [-117.99324, 33.94009], [-117.99322, 33.94006], [-117.99324, 33.93934], [-117.99593, 33.93932]]]} | Open Access 1 | Leffingwell Ranch Park | 21137 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 3.955 | Leffingwell Ranch Park | ||
6971 | 6971 | 6970 | {"type": "Polygon", "coordinates": [[[-118.02298, 33.96402], [-118.02183, 33.96545], [-118.01994, 33.9644], [-118.02109, 33.96296], [-118.02298, 33.96402]]]} | Open Access 1 | Michigan Park | 22200 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 9.971 | Michigan Park | ||
7274 | 7274 | 7273 | {"type": "Polygon", "coordinates": [[[-117.9869, 33.95804], [-117.98648, 33.95805], [-117.9864, 33.95809], [-117.98534, 33.9581], [-117.98445, 33.95834], [-117.98413, 33.95852], [-117.98303, 33.95922], [-117.98195, 33.95881], [-117.98125, 33.95823], [-117.98154, 33.95805], [-117.98175, 33.95808], [-117.98243, 33.95767], [-117.9827, 33.95744], [-117.98339, 33.95729], [-117.98337, 33.95714], [-117.98383, 33.95702], [-117.98396, 33.95707], [-117.98483, 33.95676], [-117.98529, 33.95633], [-117.98569, 33.9564], [-117.98619, 33.9569], [-117.98671, 33.95678], [-117.98673, 33.95685], [-117.98678, 33.95718], [-117.98678, 33.9572], [-117.98674, 33.95723], [-117.98675, 33.95738], [-117.98681, 33.95741], [-117.9869, 33.95804]]]} | Open Access 1 | Murphy Ranch Park | 22609 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 19.414 | Murphy Ranch Park | ||
7874 | 7874 | 7873 | {"type": "MultiPolygon", "coordinates": [[[[-118.05718, 33.99178], [-118.05479, 33.99178], [-118.05477, 33.99], [-118.05543, 33.99001], [-118.05718, 33.99178]]], [[[-118.05829, 33.99261], [-118.05747, 33.99178], [-118.05572, 33.99], [-118.05744, 33.98999], [-118.05804, 33.99178], [-118.05829, 33.99261]]]]} | Open Access 1 | Palm Park | 23346 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 12.606 | Palm Park | ||
7984 | 7984 | 7983 | {"type": "Polygon", "coordinates": [[[-118.0032, 33.93615], [-118.00318, 33.93794], [-118.00101, 33.9369], [-118.00093, 33.93678], [-118.00093, 33.93533], [-118.00095, 33.93532], [-118.003, 33.93532], [-118.00301, 33.93614], [-118.0032, 33.93615]]]} | Open Access 1 | Parnell Park | 23471 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 11.57 | Parnell Park | ||
8003 | 8003 | 8002 | {"type": "Polygon", "coordinates": [[[-118.00272, 33.96169], [-118.00267, 33.96172], [-118.00217, 33.96176], [-118.0021, 33.96173], [-118.002, 33.96147], [-118.00205, 33.96143], [-118.00216, 33.96141], [-118.00237, 33.96144], [-118.00269, 33.96162], [-118.00271, 33.96164], [-118.00272, 33.96169]]]} | Open Access 1 | Pat Nixon Fountain and Park | 23503 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.433 | Pat Nixon Fountain and Park | ||
15209 | 15209 | 15208 | {"type": "MultiPolygon", "coordinates": [[[[-118.07201, 33.99374], [-118.07172, 33.99428], [-118.07171, 33.9943], [-118.07171, 33.9943], [-118.07201, 33.99374]]], [[[-118.0717, 33.99431], [-118.07163, 33.99444], [-118.07136, 33.99471], [-118.0712, 33.9946], [-118.07149, 33.9943], [-118.07164, 33.9944], [-118.0717, 33.99431]]], [[[-118.07229, 33.99322], [-118.07171, 33.99283], [-118.07171, 33.99283], [-118.07197, 33.99299], [-118.07229, 33.99322]]]]} | Open Access 1 | Pío Pico State Historic Park | 28084 | 1380 | Whittier, City of 287 | City 2 | City Agency 2 | http://www.cityofwhittier.org/depts/prcs/default.asp | City 2 | 0.216 | Pío Pico SHP | 1917 |
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]);