units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACRES = "1385.441" and DES_TP = 4
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16272 | 16272 | 16271 | {"type": "MultiPolygon", "coordinates": [[[[-121.8323, 37.81744], [-121.82307, 37.81755], [-121.8232, 37.82443], [-121.80977, 37.82434], [-121.80523, 37.82419], [-121.80526, 37.81714], [-121.80523, 37.81543], [-121.80528, 37.81019], [-121.83217, 37.81014], [-121.8323, 37.81744]], [[-121.80846, 37.81457], [-121.80845, 37.81456], [-121.80822, 37.81452], [-121.80818, 37.81463], [-121.80843, 37.81468], [-121.80846, 37.81457]]], [[[-121.85021, 37.86746], [-121.84095, 37.86747], [-121.84101, 37.85307], [-121.83203, 37.85309], [-121.83213, 37.84579], [-121.83744, 37.84582], [-121.83761, 37.84596], [-121.83898, 37.84662], [-121.8394, 37.84711], [-121.83988, 37.84728], [-121.84104, 37.84817], [-121.84102, 37.8522], [-121.84124, 37.85225], [-121.8415, 37.85221], [-121.84169, 37.85221], [-121.84234, 37.85232], [-121.84254, 37.85233], [-121.84323, 37.8523], [-121.84334, 37.85227], [-121.84347, 37.85217], [-121.84361, 37.8521], [-121.84378, 37.85207], [-121.84402, 37.8521], [-121.84402, 37.85305], [-121.84787, 37.85304], [-121.84831, 37.85382], [-121.84841, 37.85495], [-121.84864, 37.85614], [-121.84892, 37.85712], [-121.8487, 37.85785], [-121.84901, 37.85876], [-121.84923, 37.85928], [-121.84982, 37.85981], [-121.84977, 37.86039], [-121.84995, 37.86064], [-121.84495, 37.86065], [-121.84503, 37.86318], [-121.8502, 37.86446], [-121.85021, 37.86746]]], [[[-121.84407, 37.84584], [-121.84404, 37.84923], [-121.84326, 37.84904], [-121.84251, 37.8487], [-121.84199, 37.8483], [-121.84122, 37.84808], [-121.84104, 37.84794], [-121.84104, 37.84649], [-121.83937, 37.84678], [-121.83913, 37.8465], [-121.83771, 37.84582], [-121.84407, 37.84584]]], [[[-121.85936, 37.86025], [-121.85019, 37.86026], [-121.85018, 37.85755], [-121.84893, 37.85755], [-121.84906, 37.8571], [-121.84878, 37.85614], [-121.84855, 37.85494], [-121.84845, 37.8538], [-121.84803, 37.85304], [-121.85092, 37.85302], [-121.85932, 37.853], [-121.85936, 37.86025]]]]} | No Public Access 3 | 29629 | Morgan Territory Regional Preserve | 22488 | 2032 | East Bay Regional Park District 89 | Special District 4 | Recreation/Parks District 4 | http://www.ebparks.org/ | Special District 4 | 2032 | East Bay Regional Park District 87 | Special District 4 | Recreation/Parks District 4 | Contra Costa 12 | 1385.441 | Morgan Territory RPr | 1975 | Local Conservation Area 4 | 2 |
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]);