units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 2 and UNIT_NAME = "Woodward Regional Park"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6531 | 6531 | 6530 | {"type": "MultiPolygon", "coordinates": [[[[-119.77984, 36.87156], [-119.77966, 36.87362], [-119.77899, 36.87362], [-119.77909, 36.87304], [-119.77923, 36.8718], [-119.77984, 36.87156]]], [[[-119.77985, 36.8713], [-119.77924, 36.87154], [-119.77958, 36.86783], [-119.77973, 36.86805], [-119.77993, 36.8686], [-119.77999, 36.86929], [-119.77985, 36.8713]]], [[[-119.79146, 36.87061], [-119.78963, 36.87074], [-119.78963, 36.87116], [-119.78948, 36.87117], [-119.78764, 36.8717], [-119.78655, 36.87182], [-119.78507, 36.87095], [-119.78472, 36.87079], [-119.78321, 36.87199], [-119.78336, 36.8725], [-119.78317, 36.87293], [-119.78262, 36.87323], [-119.78149, 36.87337], [-119.78108, 36.87363], [-119.77986, 36.87363], [-119.78006, 36.87141], [-119.78019, 36.86928], [-119.78012, 36.86857], [-119.77992, 36.868], [-119.77961, 36.86751], [-119.77973, 36.86629], [-119.77997, 36.86552], [-119.78036, 36.86468], [-119.78061, 36.86427], [-119.7828, 36.86076], [-119.78288, 36.86073], [-119.78347, 36.86095], [-119.78398, 36.86117], [-119.78432, 36.86127], [-119.78469, 36.86134], [-119.78481, 36.86134], [-119.78498, 36.86136], [-119.78531, 36.86136], [-119.78674, 36.86118], [-119.78719, 36.86116], [-119.78817, 36.86119], [-119.78935, 36.86117], [-119.79014, 36.86126], [-119.79103, 36.86126], [-119.7911, 36.86129], [-119.79113, 36.86134], [-119.79118, 36.86235], [-119.79119, 36.8629], [-119.7914, 36.86729], [-119.79136, 36.87004], [-119.79125, 36.87043], [-119.7913, 36.87054], [-119.79146, 36.87061]]]]} | Open Access 1 | 2849 | Woodward Regional Park | 3935 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/Government/DepartmentDirectory/ParksandRecreation/ParksandFacilities/default.htm | City 2 | 1114 | Fresno, City of 14 | City 2 | City Agency 2 | http://www.fresno.gov/government/departmentdirectory/parksandrecreation/parksandfacilities/regional+parks/woodwardpark.htm | Fresno 9 | 290.772 | Woodward RP | 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]);