superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where MNG_AGENCY = 243 sorted by LABEL_NAME descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10982 | 10982 | 10981 | {"type": "Polygon", "coordinates": [[[-117.99577, 34.06288], [-117.99574, 34.06354], [-117.99558, 34.06357], [-117.99489, 34.06356], [-117.99464, 34.06367], [-117.99407, 34.06328], [-117.99425, 34.06306], [-117.99333, 34.06245], [-117.99487, 34.06227], [-117.99517, 34.06294], [-117.99577, 34.06288]]]} | Open Access 1 | Walnut Creek Nature Park | 27226 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 4.574 | Walnut Creek Nature Park | ||
10194 | 10194 | 10193 | {"type": "Polygon", "coordinates": [[[-117.9786, 34.06336], [-117.97842, 34.06361], [-117.97729, 34.06397], [-117.97717, 34.0639], [-117.978, 34.0631], [-117.9786, 34.06336]]]} | Open Access 1 | Syhre | 26146 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1.365 | Syhre | ||
7209 | 7209 | 7208 | {"type": "Polygon", "coordinates": [[[-117.96468, 34.0876], [-117.96463, 34.08765], [-117.96323, 34.08766], [-117.96322, 34.08773], [-117.96265, 34.08773], [-117.96265, 34.08752], [-117.96257, 34.08749], [-117.96255, 34.08746], [-117.9625, 34.08748], [-117.9625, 34.08767], [-117.96159, 34.08768], [-117.96158, 34.08705], [-117.9623, 34.08688], [-117.96253, 34.08686], [-117.96261, 34.08682], [-117.96263, 34.0868], [-117.96263, 34.08668], [-117.96254, 34.08639], [-117.96457, 34.08592], [-117.96465, 34.08597], [-117.96468, 34.0876]]]} | Open Access 1 | Morgan Park | 22484 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 9.844 | Morgan Park | ||
5144 | 5144 | 5143 | {"type": "Polygon", "coordinates": [[[-117.95397, 34.08403], [-117.95379, 34.0842], [-117.95385, 34.08426], [-117.95193, 34.08606], [-117.95171, 34.08589], [-117.95372, 34.08401], [-117.95384, 34.08393], [-117.95397, 34.08403]]]} | Open Access 1 | Hilda L. Solis Park | 19956 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 1.947 | Hilda L. Solis Park | ||
1766 | 1766 | 1765 | {"type": "Polygon", "coordinates": [[[-117.99994, 34.06769], [-118.00005, 34.06802], [-118.0001, 34.06858], [-118.00009, 34.06938], [-117.99988, 34.07038], [-117.99954, 34.0713], [-117.99921, 34.07123], [-117.99916, 34.07136], [-117.9987, 34.07127], [-117.99966, 34.06802], [-117.99994, 34.06769]]]} | Open Access 1 | Barnes Park | 15821 | 1020 | Baldwin Park, City of 243 | City 2 | City Agency 2 | http://www.baldwinpark.com/ | City 2 | 6.575 | Barnes Park |
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]);