units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where ACCESS_TYP = 1, DES_TP = 2, MNG_AG_TYP = 2 and UNIT_NAME = "Village Green Park"
This data as json, copyable, CSV (advanced)
MNG_AGENCY 4
MNG_AG_TYP 1
- City Agency · 4 ✖
DES_TP 1
- Local Park · 4 ✖
ACCESS_TYP 1
- Open Access · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1302 | 1302 | 1301 | {"type": "Polygon", "coordinates": [[[-122.7616, 38.42519], [-122.7609, 38.42525], [-122.76082, 38.42464], [-122.76085, 38.4246], [-122.76086, 38.42454], [-122.76083, 38.42446], [-122.7608, 38.42413], [-122.76146, 38.42409], [-122.7616, 38.42519]]]} | Open Access 1 | 10458 | Village Green Park | 27116 | 1324 | Santa Rosa, City of 30 | City 2 | City Agency 2 | http://ci.santa-rosa.ca.us/departments/recreationandparks/Pages/default.aspx | City 2 | 1324 | Santa Rosa, City of 29 | City 2 | City Agency 2 | Sonoma 16 | 1.837 | Village Green Park | 0 | Local Park 2 | 4 | |
4429 | 4429 | 4428 | {"type": "Polygon", "coordinates": [[[-117.74499, 33.50432], [-117.74514, 33.50449], [-117.74514, 33.50456], [-117.74473, 33.50478], [-117.74455, 33.50455], [-117.74499, 33.50432]]]} | Open Access 1 | 30240 | Village Green Park | 27115 | 1164 | Laguna Beach, City of 181 | City 2 | City Agency 2 | http://www.lagunabeachcity.net/cityhall/pw/parks.asp | City 2 | 1164 | Laguna Beach, City of 177 | City 2 | City Agency 2 | Orange 3 | 0.367 | Village Green Park | 0 | Local Park 2 | 4 | |
12891 | 12891 | 12890 | {"type": "Polygon", "coordinates": [[[-117.94093, 33.77908], [-117.9409, 33.77908], [-117.94088, 33.77918], [-117.94084, 33.77929], [-117.94072, 33.77928], [-117.94037, 33.77891], [-117.93998, 33.77859], [-117.93998, 33.77855], [-117.93993, 33.77855], [-117.93965, 33.77834], [-117.93963, 33.77784], [-117.93954, 33.77784], [-117.93952, 33.77713], [-117.93944, 33.77712], [-117.93943, 33.777], [-117.94042, 33.77699], [-117.94043, 33.77688], [-117.94048, 33.77687], [-117.94048, 33.77642], [-117.94085, 33.77642], [-117.94087, 33.77777], [-117.94083, 33.77778], [-117.94083, 33.77789], [-117.94089, 33.7779], [-117.94089, 33.77808], [-117.94086, 33.77809], [-117.94086, 33.77826], [-117.94091, 33.77827], [-117.94093, 33.77908]]]} | Open Access 1 | 30349 | Village Green Park | 27114 | 1116 | Garden Grove, City of 62 | City 2 | City Agency 2 | http://www.ci.garden-grove.ca.us/commserv/recreation | City 2 | 1116 | Garden Grove, City of 60 | City 2 | City Agency 2 | Orange 3 | 6.647 | Village Green Park | 0 | Local Park 2 | 4 | |
14377 | 14377 | 14376 | {"type": "Polygon", "coordinates": [[[-121.23981, 36.31708], [-121.23921, 36.31754], [-121.23883, 36.3171], [-121.23934, 36.31671], [-121.23981, 36.31708]]]} | Open Access 1 | 47106 | Village Green Park | 30771 | 1124 | Greenfield, City of 176 | City 2 | City Agency 2 | http://www.ci.greenfield.ca.us/index.aspx?page=179 | City 2 | 1124 | Greenfield, City of 172 | City 2 | City Agency 2 | Monterey 14 | 1.0 | Village Green 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]);