units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
5 rows where COUNTY = 55, MNG_AGENCY = 578 and MNG_AG_TYP = 2
This data as json, copyable, CSV (advanced)
Suggested facets: YR_EST
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3119 | 3119 | 3118 | {"type": "Polygon", "coordinates": [[[-122.19199, 39.75275], [-122.19197, 39.75436], [-122.1904, 39.75436], [-122.1898, 39.75407], [-122.18755, 39.75307], [-122.18756, 39.75147], [-122.18867, 39.75147], [-122.18868, 39.75108], [-122.19022, 39.75107], [-122.19022, 39.75273], [-122.19199, 39.75275]]]} | Open Access 1 | 25424 | Vinsonhaler Park | 27144 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 21.88 | Vinsonhaler Park | 0 | Local Park 2 | 4 | |
3120 | 3120 | 3119 | {"type": "Polygon", "coordinates": [[[-122.19389, 39.75222], [-122.19389, 39.75309], [-122.19289, 39.75309], [-122.1929, 39.75221], [-122.19389, 39.75222]]]} | Open Access 1 | 25431 | Spence Park | 25719 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 2.05 | Spence Park | 0 | Local Park 2 | 4 | |
3135 | 3135 | 3134 | {"type": "Polygon", "coordinates": [[[-122.1988, 39.76147], [-122.19852, 39.7617], [-122.19829, 39.76149], [-122.19798, 39.76125], [-122.19747, 39.76098], [-122.19751, 39.76094], [-122.19762, 39.76095], [-122.19773, 39.76092], [-122.19777, 39.76085], [-122.19778, 39.7608], [-122.19776, 39.76075], [-122.19853, 39.76076], [-122.19853, 39.76101], [-122.19856, 39.76116], [-122.19866, 39.76135], [-122.1988, 39.76147]]]} | Open Access 1 | 48038 | Heartland Park | 32531 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | Glenn 55 | 1.394 | Heartland Park | 2015 | Local Park 2 | 4 |
8219 | 8219 | 8218 | {"type": "Polygon", "coordinates": [[[-122.17218, 39.7377], [-122.17216, 39.73975], [-122.16882, 39.73975], [-122.16886, 39.73637], [-122.17218, 39.7377]]]} | Open Access 1 | 48037 | Lely Park | 32530 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | Glenn 55 | 21.3 | Lely Park | 1980 | Local Park 2 | 4 |
14253 | 14253 | 14252 | {"type": "Polygon", "coordinates": [[[-122.19401, 39.74396], [-122.194, 39.74508], [-122.19296, 39.74508], [-122.19297, 39.74396], [-122.19401, 39.74396]]]} | Open Access 1 | 44173 | Library Park | 21223 | 1441 | Orland, City of 588 | City 2 | City Agency 2 | http://www.cityoforland.com/govt/dept/recreation/parks.asp | City 2 | 1441 | Orland, City of 578 | City 2 | City Agency 2 | Glenn 55 | 2.726 | Library 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]);