superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
3 rows where ACRES = "5.154"
This data as json, copyable, CSV (advanced)
These facets timed out: ACCESS_TYP, MNG_AGENCY, MNG_AG_TYP
Link | rowid ▼ | id | map | ACCESS_TYP | PARK_NAME | PARK_URL | SUID_NMA | MNG_AG_ID | MNG_AGENCY | MNG_AG_LEV | MNG_AG_TYP | AGNCY_WEB | LAYER | ACRES | LABEL_NAME | YR_EST |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2652 | 2652 | 2651 | {"type": "MultiPolygon", "coordinates": [[[[-119.52905, 34.3961], [-119.52846, 34.39735], [-119.52762, 34.39922], [-119.52766, 34.39927], [-119.52741, 34.39995], [-119.5269, 34.39971], [-119.52637, 34.39941], [-119.52671, 34.39929], [-119.52671, 34.39926], [-119.52674, 34.39925], [-119.52684, 34.39932], [-119.52708, 34.39925], [-119.52717, 34.39921], [-119.52737, 34.39902], [-119.5274, 34.39902], [-119.5288, 34.39601], [-119.52905, 34.3961]]], [[[-119.53027, 34.40061], [-119.5299, 34.40115], [-119.52919, 34.40081], [-119.52943, 34.40021], [-119.53027, 34.40061]]]]} | Restricted Access 2 | Carpinteria Salt Marsh Reserve | 16900 | 2141 | Santa Barbara Flood Control and Water Conserv. District 45 | Special District 4 | Flood District 9 | http://cosb.countyofsb.org/pwd/pwwater.aspx?id=3572 | Special District 4 | 5.154 | Carpinteria Salt Marsh Reserve | ||
9351 | 9351 | 9350 | {"type": "Polygon", "coordinates": [[[-117.74323, 33.61692], [-117.74313, 33.6172], [-117.74313, 33.61738], [-117.74317, 33.61755], [-117.74316, 33.61759], [-117.7425, 33.61783], [-117.74246, 33.61783], [-117.74242, 33.61781], [-117.74227, 33.61763], [-117.74218, 33.61755], [-117.74202, 33.61745], [-117.74189, 33.61739], [-117.74157, 33.61732], [-117.74116, 33.61732], [-117.74111, 33.61586], [-117.74145, 33.61573], [-117.74176, 33.61557], [-117.74179, 33.61663], [-117.742, 33.61696], [-117.74323, 33.61692]]]} | Open Access 1 | Santa Vittoria Park | 25142 | 1165 | Laguna Hills, City of 226 | City 2 | City Agency 2 | http://www.ci.laguna-hills.ca.us/ | City 2 | 5.154 | Santa Vittoria Park | ||
13715 | 13715 | 13714 | {"type": "Polygon", "coordinates": [[[-117.16142, 32.70441], [-117.16105, 32.7048], [-117.16002, 32.70409], [-117.15893, 32.70438], [-117.15841, 32.70444], [-117.15826, 32.70436], [-117.15952, 32.70313], [-117.16011, 32.70349], [-117.16142, 32.70441]]]} | Open Access 1 | San Diego Bayfront Park | https://www.portofsandiego.org/san-diego-bayfront-park.html | 31202 | 2133 | San Diego Unified Port District 182 | Special District 4 | Port/Harbor District 14 | http://www.portofsandiego.org/ | Special District 4 | 5.154 | San Diego Bayfront Park |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE superunits_with_maps( id INT, map, ACCESS_TYP INT, PARK_NAME TEXT, PARK_URL TEXT, SUID_NMA INT, MNG_AG_ID INT, MNG_AGENCY INT, MNG_AG_LEV INT, MNG_AG_TYP INT, AGNCY_WEB TEXT, LAYER INT, ACRES REAL, LABEL_NAME TEXT, YR_EST INT, FOREIGN KEY([ACCESS_TYP]) REFERENCES [ACCESS_TYP]([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([LAYER]) REFERENCES [LAYER]([id]) ); CREATE INDEX [idx_superunits_with_maps_LAYER] ON [superunits_with_maps] ([LAYER]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_TYP] ON [superunits_with_maps] ([MNG_AG_TYP]); CREATE INDEX [idx_superunits_with_maps_MNG_AG_LEV] ON [superunits_with_maps] ([MNG_AG_LEV]); CREATE INDEX [idx_superunits_with_maps_MNG_AGENCY] ON [superunits_with_maps] ([MNG_AGENCY]); CREATE INDEX [idx_superunits_with_maps_ACCESS_TYP] ON [superunits_with_maps] ([ACCESS_TYP]);