superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AG_TYP = 2 and PARK_NAME = "Uplands of the Kern River Parkway Park"
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10567 | 10567 | 10566 | {"type": "Polygon", "coordinates": [[[-119.02868, 35.39679], [-119.02821, 35.39709], [-119.0278, 35.39747], [-119.02762, 35.39767], [-119.02735, 35.39792], [-119.02715, 35.39817], [-119.02705, 35.39832], [-119.027, 35.39846], [-119.02684, 35.39878], [-119.02681, 35.39902], [-119.02658, 35.39913], [-119.02645, 35.39906], [-119.0261, 35.39805], [-119.02594, 35.39804], [-119.02589, 35.39812], [-119.02574, 35.39843], [-119.02569, 35.39859], [-119.02556, 35.39872], [-119.0253, 35.39889], [-119.02512, 35.39905], [-119.02489, 35.39919], [-119.02481, 35.39928], [-119.02467, 35.39929], [-119.02454, 35.39935], [-119.02439, 35.39951], [-119.02404, 35.39963], [-119.02381, 35.39966], [-119.02294, 35.39965], [-119.02279, 35.39968], [-119.02263, 35.39968], [-119.02236, 35.39976], [-119.02206, 35.39993], [-119.02189, 35.40007], [-119.02169, 35.40012], [-119.0215, 35.40012], [-119.02138, 35.40017], [-119.02126, 35.40024], [-119.02125, 35.40031], [-119.02113, 35.40045], [-119.02093, 35.40051], [-119.02085, 35.40057], [-119.02083, 35.40063], [-119.02072, 35.40067], [-119.02059, 35.40069], [-119.02043, 35.40073], [-119.02028, 35.40073], [-119.02024, 35.4008], [-119.02002, 35.40099], [-119.01979, 35.40127], [-119.01976, 35.40134], [-119.01976, 35.40142], [-119.01982, 35.40161], [-119.01975, 35.40174], [-119.01966, 35.40177], [-119.01956, 35.40177], [-119.01911, 35.40095], [-119.01903, 35.40059], [-119.01945, 35.40047], [-119.01991, 35.40029], [-119.0203, 35.40001], [-119.02148, 35.39921], [-119.02175, 35.39908], [-119.02256, 35.39881], [-119.02307, 35.39873], [-119.02293, 35.39821], [-119.02305, 35.39819], [-119.02326, 35.39872], [-119.02508, 35.39826], [-119.02559, 35.39802], [-119.02593, 35.39793], [-119.02621, 35.39794], [-119.02638, 35.39792], [-119.02661, 35.39782], [-119.0267, 35.39771], [-119.02674, 35.39755], [-119.02674, 35.39741], [-119.02683, 35.39731], [-119.02703, 35.39701], [-119.02711, 35.39673], [-119.02713, 35.39614], [-119.02715, 35.39596], [-119.02715, 35.39578], [-119.0272, 35.39566], [-119.02868, 35.39679]]]} | Open Access 1 | Uplands of the Kern River Parkway Park | 26724 | 1019 | Bakersfield, City of 244 | City 2 | City Agency 2 | http://www.bakersfieldcity.us/recreation/ | City 2 | 23.301 | Uplands of the Kern River Parkway 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]);