units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where MNG_AGENCY = 129, MNG_AG_TYP = 2 and PARK_URL = "http://powaygis.poway.org/websites/CityOfPowayParks/" sorted by LAYER
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
326 | 326 | 325 | {"type": "Polygon", "coordinates": [[[-117.05157, 32.9804], [-117.05138, 32.98085], [-117.05133, 32.98094], [-117.05131, 32.981], [-117.05132, 32.98106], [-117.05102, 32.98153], [-117.051, 32.98153], [-117.04857, 32.98177], [-117.04856, 32.98156], [-117.04845, 32.98133], [-117.04846, 32.98125], [-117.04842, 32.98112], [-117.04839, 32.98059], [-117.04839, 32.98037], [-117.04841, 32.98015], [-117.04845, 32.98], [-117.04851, 32.97983], [-117.04992, 32.9802], [-117.05087, 32.98035], [-117.05157, 32.9804]]]} | Open Access 1 | 866 | Silverset Neighborhood Park | 25499 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaygis.poway.org/websites/CityOfPowayParks/ | San Diego 4 | 11.0 | Silverset Neighborhood Park | 0 | Local Park 2 | 4 |
337 | 337 | 336 | {"type": "Polygon", "coordinates": [[[-117.0528, 32.96429], [-117.05273, 32.96441], [-117.05225, 32.96502], [-117.05155, 32.96466], [-117.05071, 32.96559], [-117.04956, 32.96596], [-117.04947, 32.96586], [-117.04827, 32.96584], [-117.04826, 32.96581], [-117.04818, 32.96581], [-117.04818, 32.9658], [-117.04935, 32.96581], [-117.04935, 32.96401], [-117.04938, 32.96259], [-117.04985, 32.96205], [-117.05113, 32.96208], [-117.0521, 32.9619], [-117.05252, 32.96197], [-117.05254, 32.96199], [-117.05251, 32.96222], [-117.05229, 32.96331], [-117.05228, 32.96352], [-117.05234, 32.96373], [-117.05243, 32.96389], [-117.05251, 32.96399], [-117.05262, 32.96409], [-117.05266, 32.9642], [-117.0528, 32.96429]]]} | Open Access 1 | 928 | Starridge Neighborhood Park | 25809 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaygis.poway.org/websites/CityOfPowayParks/ | San Diego 4 | 26.113 | Starridge Neighborhood Park | 0 | Local Park 2 | 4 |
14758 | 14758 | 14757 | {"type": "Polygon", "coordinates": [[[-117.06245, 32.94818], [-117.06243, 32.94856], [-117.06232, 32.94841], [-117.06194, 32.94833], [-117.06196, 32.94802], [-117.06206, 32.94804], [-117.06216, 32.948], [-117.06245, 32.94818]]]} | Open Access 1 | 45136 | Poway Oaks Neighborhood Park | 23968 | 1262 | Poway, City of 132 | City 2 | City Agency 2 | http://poway.org/204/Community-Services---Parks-Recreation | City 2 | 1262 | Poway, City of 129 | City 2 | City Agency 2 | http://powaygis.poway.org/websites/CityOfPowayParks/ | San Diego 4 | 0.44 | Poway Oaks Neighborhood 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]);