units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
26 rows where MNG_AGENCY = 143 sorted by rowid descending
This data as json, copyable, CSV (advanced)
Link | rowid ▲ | id | map | ACCESS_TYP | UNIT_ID | UNIT_NAME | SUID_NMA | AGNCY_ID | AGNCY_NAME | AGNCY_LEV | AGNCY_TYP | AGNCY_WEB | LAYER | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | PARK_URL | COUNTY | ACRES | LABEL_NAME | YR_EST | DES_TP | GAP_STS |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4400 | 4400 | 4399 | {"type": "Polygon", "coordinates": [[[-117.90951, 34.14686], [-117.9095, 34.1481], [-117.90942, 34.14811], [-117.90929, 34.14758], [-117.90916, 34.14691], [-117.9092, 34.14685], [-117.90928, 34.14683], [-117.90951, 34.14683], [-117.90951, 34.14686]]]} | Open Access 1 | 46030 | Canyon Park | 29355 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 0.735 | Canyon Park | 0 | Local Park 2 | 4 | |
3641 | 3641 | 3640 | {"type": "Polygon", "coordinates": [[[-117.89406, 34.16397], [-117.89267, 34.16401], [-117.89233, 34.1637], [-117.89222, 34.16349], [-117.89221, 34.16311], [-117.89406, 34.16397]]]} | Open Access 1 | 29516 | River Wilderness Park | 24431 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 1.847 | River Wilderness Park | 0 | Local Conservation Area 4 | 2 | |
3000 | 3000 | 2999 | {"type": "Polygon", "coordinates": [[[-117.92179, 34.11982], [-117.92177, 34.12163], [-117.92068, 34.12164], [-117.92067, 34.12153], [-117.91871, 34.12153], [-117.91861, 34.12146], [-117.91861, 34.1209], [-117.91868, 34.12085], [-117.91899, 34.12085], [-117.91926, 34.1209], [-117.91985, 34.1209], [-117.92004, 34.12087], [-117.92028, 34.12079], [-117.92041, 34.12076], [-117.92109, 34.12076], [-117.92125, 34.12079], [-117.92137, 34.12077], [-117.92143, 34.12071], [-117.92146, 34.12063], [-117.92143, 34.12048], [-117.92143, 34.1201], [-117.92146, 34.11993], [-117.92145, 34.11987], [-117.92141, 34.11982], [-117.92179, 34.11982]]]} | Open Access 1 | 20566 | Zacatecas Park | 27850 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 6.772 | Zacatecas Park | 0 | Local Park 2 | 4 | |
1678 | 1678 | 1677 | {"type": "Polygon", "coordinates": [[[-117.90234, 34.13098], [-117.90097, 34.13097], [-117.90096, 34.13044], [-117.90019, 34.13043], [-117.9002, 34.13022], [-117.90096, 34.13023], [-117.90097, 34.12991], [-117.90234, 34.12992], [-117.90234, 34.13098]]]} | Open Access 1 | 12775 | Slauson Park | 25553 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.076 | Slauson Park | 0 | Local Park 2 | 4 | |
893 | 893 | 892 | {"type": "Polygon", "coordinates": [[[-117.90512, 34.14554], [-117.9051, 34.14659], [-117.90507, 34.14664], [-117.90497, 34.14665], [-117.90332, 34.14665], [-117.90332, 34.1466], [-117.90342, 34.14629], [-117.90377, 34.14598], [-117.90382, 34.14597], [-117.90387, 34.14587], [-117.904, 34.14577], [-117.90401, 34.14566], [-117.90398, 34.14557], [-117.904, 34.14553], [-117.90512, 34.14554]]]} | Open Access 1 | 5754 | Pioneer Park | 23718 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.093 | Pioneer Park | 0 | Local Park 2 | 4 | |
357 | 357 | 356 | {"type": "Polygon", "coordinates": [[[-117.90242, 34.11526], [-117.90241, 34.11696], [-117.90124, 34.11696], [-117.90125, 34.11535], [-117.90158, 34.11535], [-117.90207, 34.11526], [-117.90242, 34.11526]]]} | Open Access 1 | 1002 | Gladstone Park | 19305 | 1018 | Azusa, City of 147 | City 2 | City Agency 2 | http://www.ci.azusa.ca.us/index.aspx?NID=249 | City 2 | 1018 | Azusa, City of 143 | City 2 | City Agency 2 | Los Angeles 6 | 4.901 | Gladstone Park | 0 | Local Park 2 | 4 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE units_with_maps( id INT, map, ACCESS_TYP INT, UNIT_ID INT, UNIT_NAME TEXT, SUID_NMA INT, AGNCY_ID INT, AGNCY_NAME INT, AGNCY_LEV INT, AGNCY_TYP INT, AGNCY_WEB TEXT, LAYER INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, PARK_URL TEXT, COUNTY INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, DES_TP INT, GAP_STS TEXT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([id]), FOREIGN KEY([AGNCY_NAME]) REFERENCES [AGNCY_NAME]([id]), FOREIGN KEY([AGNCY_LEV]) REFERENCES [AGNCY_LEV]([id]), FOREIGN KEY([AGNCY_TYP]) REFERENCES [AGNCY_TYP]([id]), FOREIGN KEY([LAYER]) REFERENCES [LAYER]([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([COUNTY]) REFERENCES [COUNTY]([id]), FOREIGN KEY([DES_TP]) REFERENCES [DES_TP]([id]) ); CREATE INDEX [idx_units_with_maps_DES_TP] ON [units_with_maps] ([DES_TP]); CREATE INDEX [idx_units_with_maps_COUNTY] ON [units_with_maps] ([COUNTY]); CREATE INDEX [idx_units_with_maps_MNG_AG_TYP] ON [units_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_units_with_maps_MNG_AG_LEV] ON [units_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_units_with_maps_MNG_AGENCY] ON [units_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_units_with_maps_LAYER] ON [units_with_maps] ([LAYER]); CREATE INDEX [idx_units_with_maps_AGNCY_TYP] ON [units_with_maps] ([AGNCY_TYP]); CREATE INDEX [idx_units_with_maps_AGNCY_LEV] ON [units_with_maps] ([AGNCY_LEV]); CREATE INDEX [idx_units_with_maps_AGNCY_NAME] ON [units_with_maps] ([AGNCY_NAME]); CREATE INDEX [idx_units_with_maps_ACCESS_TYP] ON [units_with_maps] ([ACCESS_TYP]);