units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where AGNCY_TYP = 3, COUNTY = 9 and DES_TP = 3
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12322 | 12322 | 12321 | {"type": "Polygon", "coordinates": [[[-119.47502, 36.7331], [-119.47483, 36.73317], [-119.47481, 36.73326], [-119.47375, 36.73264], [-119.47308, 36.73291], [-119.4716, 36.73202], [-119.47134, 36.73246], [-119.47051, 36.73212], [-119.47043, 36.7321], [-119.47052, 36.73197], [-119.47095, 36.7312], [-119.47206, 36.73151], [-119.47297, 36.73185], [-119.47502, 36.7331]]]} | Open Access 1 | 25985 | Kings river Access Park | 20661 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 7.286 | Kings river Access Park | 0 | Local Recreation Area 3 | 4 | |
15708 | 15708 | 15707 | {"type": "Polygon", "coordinates": [[[-119.91096, 36.84512], [-119.90786, 36.84617], [-119.90717, 36.84638], [-119.90647, 36.84658], [-119.90541, 36.84683], [-119.90469, 36.84697], [-119.90396, 36.8471], [-119.90287, 36.84725], [-119.90247, 36.84764], [-119.89722, 36.84425], [-119.90643, 36.84421], [-119.90626, 36.84057], [-119.90871, 36.84057], [-119.91065, 36.84027], [-119.91086, 36.84418], [-119.91096, 36.84418], [-119.91096, 36.84512]]]} | Restricted Access 2 | 25955 | Riverside Municipal Golf Course | 33087 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 107.589 | Riverside Municipal GC | 0 | Local Recreation Area 3 | 4 | |
16711 | 16711 | 16710 | {"type": "Polygon", "coordinates": [[[-119.74048, 36.9629], [-119.74046, 36.96322], [-119.74044, 36.96339], [-119.73993, 36.96544], [-119.73943, 36.96697], [-119.73768, 36.97137], [-119.73595, 36.97372], [-119.73239, 36.97692], [-119.73129, 36.97793], [-119.73031, 36.97791], [-119.72304, 36.97794], [-119.72301, 36.97562], [-119.72458, 36.9743], [-119.72577, 36.9743], [-119.72576, 36.97335], [-119.72618, 36.97296], [-119.72661, 36.9725], [-119.727, 36.97202], [-119.72727, 36.97165], [-119.72758, 36.97113], [-119.72785, 36.9706], [-119.72803, 36.97019], [-119.72821, 36.96964], [-119.72832, 36.96922], [-119.72846, 36.96849], [-119.72876, 36.96559], [-119.72882, 36.96514], [-119.72884, 36.96481], [-119.72883, 36.96447], [-119.72878, 36.96392], [-119.72872, 36.96359], [-119.72864, 36.96326], [-119.72779, 36.96087], [-119.73636, 36.96082], [-119.73638, 36.96293], [-119.74048, 36.9629]]]} | Open Access 1 | 25929 | Lost Lake Recreation Area | 21541 | 301 | Fresno, County of 296 | County 3 | County Agency 3 | http://www.co.fresno.ca.us/DepartmentPage.aspx?id=51904 | County 3 | 301 | Fresno, County of 292 | County 3 | County Agency 3 | Fresno 9 | 425.466 | Lost Lake Rec. Area | 0 | Local Recreation Area 3 | 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]);