units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where LABEL_NAME = "Pasadena City Parkland" and MNG_AGENCY = 297
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1658 | 1658 | 1657 | {"type": "MultiPolygon", "coordinates": [[[[-118.20428, 34.26086], [-118.20289, 34.26135], [-118.19949, 34.25848], [-118.19999, 34.25788], [-118.20192, 34.2573], [-118.20428, 34.26086]]], [[[-118.20284, 34.26137], [-118.20252, 34.26149], [-118.19905, 34.25902], [-118.19947, 34.25851], [-118.20284, 34.26137]]]]} | Open Access 1 | 12550 | Pasadena City Parkland | 8444 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 27.888 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
8229 | 8229 | 8228 | {"type": "MultiPolygon", "coordinates": [[[[-118.17544, 34.16686], [-118.17536, 34.16689], [-118.17502, 34.16662], [-118.17488, 34.16648], [-118.17474, 34.1663], [-118.17407, 34.16531], [-118.17396, 34.1652], [-118.17383, 34.16511], [-118.1737, 34.16505], [-118.17312, 34.16488], [-118.17291, 34.16479], [-118.17263, 34.1646], [-118.17241, 34.16437], [-118.17234, 34.16412], [-118.17216, 34.16321], [-118.1724, 34.16314], [-118.17188, 34.16173], [-118.17218, 34.16164], [-118.17226, 34.1619], [-118.17235, 34.16188], [-118.17313, 34.16369], [-118.17279, 34.1638], [-118.17291, 34.1642], [-118.17256, 34.1643], [-118.1726, 34.16443], [-118.17296, 34.16433], [-118.17304, 34.16455], [-118.17357, 34.16482], [-118.17398, 34.16497], [-118.17422, 34.16537], [-118.17466, 34.16581], [-118.17498, 34.16597], [-118.17515, 34.16636], [-118.17525, 34.16672], [-118.17544, 34.16686]]], [[[-118.17631, 34.1679], [-118.17603, 34.1679], [-118.17609, 34.16786], [-118.1761, 34.16783], [-118.17608, 34.16779], [-118.1748, 34.16674], [-118.17423, 34.1661], [-118.17395, 34.16587], [-118.17362, 34.1655], [-118.1734, 34.16537], [-118.17323, 34.16533], [-118.17317, 34.1658], [-118.17349, 34.16654], [-118.17365, 34.16704], [-118.17372, 34.16733], [-118.17338, 34.16734], [-118.17318, 34.16645], [-118.17271, 34.16507], [-118.17259, 34.1648], [-118.17276, 34.1649], [-118.17295, 34.16499], [-118.17359, 34.16519], [-118.17372, 34.16525], [-118.17383, 34.16532], [-118.17391, 34.1654], [-118.17459, 34.16642], [-118.17477, 34.16663], [-118.17493, 34.16678], [-118.17631, 34.1679]]], [[[-118.17398, 34.16791], [-118.17351, 34.16792], [-118.1734, 34.16742], [-118.17381, 34.16742], [-118.17398, 34.16791]]], [[[-118.17658, 34.16789], [-118.17539, 34.16692], [-118.17539, 34.16692], [-118.17582, 34.16679], [-118.17582, 34.16676], [-118.17626, 34.16662], [-118.17638, 34.16691], [-118.17594, 34.16704], [-118.17588, 34.16691], [-118.17555, 34.16702], [-118.17642, 34.16768], [-118.17646, 34.16769], [-118.17651, 34.16769], [-118.17655, 34.16766], [-118.17657, 34.16763], [-118.17658, 34.16789]]]]} | Open Access 1 | 12553 | Pasadena City Parkland | 8444 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 10.096 | Pasadena City Parkland | 0 | Local Park 2 | 4 | |
8230 | 8230 | 8229 | {"type": "Polygon", "coordinates": [[[-118.18119, 34.1867], [-118.18015, 34.1874], [-118.18008, 34.18726], [-118.17997, 34.1871], [-118.17978, 34.1869], [-118.17962, 34.18678], [-118.17937, 34.18664], [-118.17911, 34.18637], [-118.17847, 34.18578], [-118.17853, 34.18566], [-118.17863, 34.18566], [-118.17891, 34.18575], [-118.17893, 34.18573], [-118.17982, 34.18602], [-118.17991, 34.18607], [-118.18036, 34.18647], [-118.18048, 34.18654], [-118.18061, 34.18658], [-118.18099, 34.18664], [-118.18119, 34.1867]]]} | Open Access 1 | 12557 | Pasadena City Parkland | 8444 | 1246 | Pasadena, City of 301 | City 2 | City Agency 2 | http://cityofpasadena.net/PublicWorks/Parks_Natural_Resources_Division/ | City 2 | 1246 | Pasadena, City of 297 | City 2 | City Agency 2 | Los Angeles 6 | 4.108 | Pasadena City Parkland | 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]);