units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, LAYER = 2 and MNG_AGENCY = 112
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
280 | 280 | 279 | {"type": "Polygon", "coordinates": [[[-121.85612, 36.61199], [-121.8561, 36.6123], [-121.85602, 36.6123], [-121.85604, 36.61196], [-121.85607, 36.61194], [-121.85612, 36.61199]]]} | Restricted Access 2 | 956 | South Monterey Dunes | 25664 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 0.07 | South Monterey Dunes | None 30 | |||
9447 | 9447 | 9446 | {"type": "Polygon", "coordinates": [[[-121.82991, 36.63229], [-121.82592, 36.63574], [-121.82568, 36.63592], [-121.82546, 36.63603], [-121.82507, 36.63615], [-121.82474, 36.63618], [-121.81961, 36.63593], [-121.81935, 36.63593], [-121.81911, 36.63596], [-121.81872, 36.63606], [-121.81842, 36.6362], [-121.8183, 36.63628], [-121.81716, 36.63727], [-121.81692, 36.63709], [-121.81597, 36.63671], [-121.81592, 36.63661], [-121.81575, 36.63637], [-121.81533, 36.63587], [-121.81503, 36.63572], [-121.81455, 36.63544], [-121.81353, 36.63481], [-121.8128, 36.63419], [-121.81388, 36.63201], [-121.81361, 36.63084], [-121.81575, 36.62643], [-121.81895, 36.62681], [-121.82132, 36.62198], [-121.82148, 36.62204], [-121.82208, 36.62234], [-121.82269, 36.62251], [-121.82291, 36.6226], [-121.82351, 36.62312], [-121.82385, 36.6233], [-121.82411, 36.62337], [-121.82463, 36.62366], [-121.82508, 36.62391], [-121.82592, 36.62448], [-121.82574, 36.62606], [-121.82589, 36.62664], [-121.82609, 36.62719], [-121.82662, 36.62852], [-121.82696, 36.62899], [-121.82756, 36.62939], [-121.82804, 36.62959], [-121.82889, 36.62973], [-121.82916, 36.63084], [-121.82912, 36.6309], [-121.82991, 36.63229]]]} | Restricted Access 2 | 17283 | Bayonet Black Horse Golf Course | 33056 | 1330 | Seaside, City of 115 | City 2 | City Agency 2 | http://www.ci.seaside.ca.us/index.aspx?page=313 | City 2 | 1330 | Seaside, City of 112 | City 2 | City Agency 2 | Monterey 14 | 373.525 | Bayonet Black Horse GC | 0 | Local Recreation Area 3 | 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]);