superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "39.154" and MNG_AG_TYP = 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1995 | 1995 | 1994 | {"type": "Polygon", "coordinates": [[[-117.88503, 33.63009], [-117.88492, 33.63054], [-117.88457, 33.63087], [-117.8844, 33.63098], [-117.88427, 33.63103], [-117.8841, 33.63106], [-117.88263, 33.63112], [-117.88253, 33.63115], [-117.88207, 33.63138], [-117.88279, 33.63178], [-117.88289, 33.63186], [-117.88295, 33.63192], [-117.883, 33.63202], [-117.88302, 33.63212], [-117.88308, 33.63273], [-117.88312, 33.63284], [-117.88322, 33.63295], [-117.88329, 33.63301], [-117.8846, 33.63364], [-117.88468, 33.63377], [-117.88483, 33.63395], [-117.88461, 33.63407], [-117.88448, 33.6339], [-117.88271, 33.63315], [-117.8824, 33.63265], [-117.88259, 33.63222], [-117.88182, 33.63176], [-117.88079, 33.63166], [-117.88049, 33.6317], [-117.88026, 33.6317], [-117.87975, 33.63121], [-117.87955, 33.63087], [-117.87928, 33.63058], [-117.87925, 33.63028], [-117.87851, 33.62913], [-117.87825, 33.629], [-117.87804, 33.62901], [-117.87801, 33.62898], [-117.87782, 33.62903], [-117.87737, 33.62921], [-117.87721, 33.62923], [-117.87699, 33.6293], [-117.87664, 33.62918], [-117.87761, 33.62757], [-117.87822, 33.62674], [-117.87836, 33.62695], [-117.87841, 33.62732], [-117.87879, 33.6275], [-117.87934, 33.62797], [-117.87967, 33.62852], [-117.88023, 33.62895], [-117.88053, 33.62966], [-117.88079, 33.62984], [-117.8811, 33.62989], [-117.8824, 33.62957], [-117.88277, 33.62964], [-117.88345, 33.63013], [-117.88367, 33.63011], [-117.8839, 33.62992], [-117.88411, 33.62992], [-117.8842, 33.62989], [-117.88503, 33.63009]]]} | Open Access 1 | Big Canyon Park | 16076 | 1224 | Newport Beach, City of 52 | City 2 | City Agency 2 | http://www.newportbeachca.gov/index.aspx?page=66 | City 2 | 39.154 | Big Canyon 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]);