units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where AGNCY_LEV = 2, DES_TP = 3 and MNG_AGENCY = 152
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3299 | 3299 | 3298 | {"type": "Polygon", "coordinates": [[[-119.3038, 36.33243], [-119.30349, 36.33305], [-119.30313, 36.33297], [-119.30331, 36.33236], [-119.30375, 36.33236], [-119.3038, 36.33243]]]} | Open Access 1 | 48211 | Provident Skate Park | 32751 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 0.738 | Provident Skate Park | 0 | Local Recreation Area 3 | 4 | |
4039 | 4039 | 4038 | {"type": "Polygon", "coordinates": [[[-119.3057, 36.35936], [-119.30569, 36.36362], [-119.29729, 36.36359], [-119.29718, 36.36351], [-119.29718, 36.36299], [-119.2972, 36.36276], [-119.2972, 36.36186], [-119.29717, 36.36185], [-119.29718, 36.36115], [-119.2972, 36.36093], [-119.29719, 36.3602], [-119.29729, 36.36012], [-119.2973, 36.36001], [-119.29818, 36.35999], [-119.30454, 36.35938], [-119.30485, 36.35936], [-119.3057, 36.35936]]]} | Open Access 1 | 44284 | Visalia Riverway Sports Complex | 27162 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 82.276 | Visalia Riverway Sports Complex | 0 | Local Recreation Area 3 | 4 | |
6260 | 6260 | 6259 | {"type": "Polygon", "coordinates": [[[-119.30539, 36.3334], [-119.30537, 36.33344], [-119.30532, 36.33345], [-119.30506, 36.33343], [-119.30481, 36.33345], [-119.30349, 36.33305], [-119.3038, 36.33244], [-119.30375, 36.33236], [-119.30331, 36.33236], [-119.30313, 36.33297], [-119.30233, 36.33288], [-119.30231, 36.3311], [-119.30316, 36.3311], [-119.30317, 36.33148], [-119.30537, 36.33147], [-119.30539, 36.3334]]]} | Open Access 1 | 1385 | Recreation Park | 24218 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 12.862 | Rec. Park | 0 | Local Recreation Area 3 | 4 | |
8490 | 8490 | 8489 | {"type": "Polygon", "coordinates": [[[-119.38553, 36.32294], [-119.38391, 36.32361], [-119.38313, 36.32419], [-119.38113, 36.32421], [-119.3811, 36.31994], [-119.38099, 36.31272], [-119.38131, 36.31274], [-119.38155, 36.31279], [-119.38178, 36.3129], [-119.38549, 36.31585], [-119.38569, 36.31605], [-119.38727, 36.3181], [-119.38829, 36.31895], [-119.38855, 36.31913], [-119.38879, 36.31924], [-119.38901, 36.31932], [-119.38949, 36.31943], [-119.38976, 36.31954], [-119.39004, 36.31974], [-119.3902, 36.31992], [-119.3903, 36.32009], [-119.39038, 36.32034], [-119.39039, 36.3206], [-119.39036, 36.32078], [-119.3903, 36.32093], [-119.39015, 36.32116], [-119.39001, 36.3213], [-119.38987, 36.32141], [-119.38968, 36.32151], [-119.38952, 36.32157], [-119.38896, 36.3217], [-119.38874, 36.32178], [-119.38849, 36.32193], [-119.38828, 36.32212], [-119.38817, 36.32228], [-119.38808, 36.32248], [-119.3877, 36.32389], [-119.3877, 36.32401], [-119.38774, 36.32416], [-119.38802, 36.32477], [-119.3881, 36.32488], [-119.38818, 36.32496], [-119.38839, 36.32509], [-119.38863, 36.32517], [-119.38891, 36.32519], [-119.38914, 36.32514], [-119.38954, 36.32498], [-119.38967, 36.32496], [-119.38995, 36.32496], [-119.3898, 36.32615], [-119.38881, 36.32651], [-119.3882, 36.32664], [-119.3877, 36.3267], [-119.38715, 36.32673], [-119.38555, 36.32675], [-119.38466, 36.32696], [-119.38131, 36.32696], [-119.38114, 36.32683], [-119.38113, 36.32424], [-119.38315, 36.32421], [-119.38393, 36.32363], [-119.38553, 36.32297], [-119.39037, 36.32063], [-119.39035, 36.32062], [-119.39, 36.32078], [-119.38553, 36.32294]]]} | Restricted Access 2 | 1435 | Valley Oaks Golf Course | 32996 | 1368 | Visalia, City of 156 | City 2 | City Agency 2 | http://www.ci.visalia.ca.us/depts/parks_n_recreation/default.asp | City 2 | 1368 | Visalia, City of 152 | City 2 | City Agency 2 | Tulare 29 | 215.293 | Valley Oaks GC | 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]);