superunits_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, MNG_AGENCY = 147 and PARK_NAME = "Centennial 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
585 | 585 | 584 | {"type": "MultiPolygon", "coordinates": [[[[-121.97601, 38.37279], [-121.97442, 38.37692], [-121.97337, 38.37952], [-121.97228, 38.38237], [-121.97079, 38.38635], [-121.96709, 38.38651], [-121.96528, 38.38665], [-121.96512, 38.38613], [-121.9649, 38.38546], [-121.96482, 38.38545], [-121.96457, 38.38384], [-121.96459, 38.38369], [-121.96442, 38.38233], [-121.96462, 38.38185], [-121.96554, 38.38052], [-121.96572, 38.38021], [-121.96575, 38.3802], [-121.96579, 38.38014], [-121.96578, 38.38012], [-121.96631, 38.3794], [-121.96673, 38.37888], [-121.96773, 38.37756], [-121.96778, 38.37744], [-121.96781, 38.37706], [-121.96776, 38.3766], [-121.96784, 38.37624], [-121.96789, 38.37461], [-121.96788, 38.37444], [-121.9679, 38.37261], [-121.96792, 38.37188], [-121.96794, 38.3716], [-121.9681, 38.36995], [-121.96854, 38.36818], [-121.96846, 38.36803], [-121.96819, 38.36764], [-121.96796, 38.36765], [-121.96759, 38.36733], [-121.96833, 38.36707], [-121.96974, 38.36866], [-121.97015, 38.36908], [-121.9703, 38.36922], [-121.9706, 38.36942], [-121.97061, 38.36955], [-121.97019, 38.36997], [-121.96982, 38.3703], [-121.96968, 38.37047], [-121.96961, 38.37061], [-121.96957, 38.3708], [-121.96956, 38.37095], [-121.96958, 38.37107], [-121.96972, 38.37102], [-121.96974, 38.37084], [-121.9698, 38.37071], [-121.96986, 38.37062], [-121.97002, 38.37046], [-121.97081, 38.36971], [-121.97084, 38.36969], [-121.97098, 38.36968], [-121.97138, 38.36993], [-121.97099, 38.3704], [-121.97099, 38.37042], [-121.97166, 38.37012], [-121.97189, 38.36999], [-121.97317, 38.3709], [-121.976, 38.37276], [-121.97601, 38.37279]]], [[[-121.96952, 38.368], [-121.96952, 38.368], [-121.96865, 38.36697], [-121.96936, 38.36672], [-121.96952, 38.36784], [-121.96952, 38.368]]]]} | Open Access 1 | Centennial Park | http://www.cityofvacaville.com/index.aspx?page=128 | 14382 | 1364 | Vacaville, City of 147 | City 2 | City Agency 2 | http://www.cityofvacaville.com/index.aspx?page=374 | City 2 | 283.18 | Centennial 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]);