units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 4, MNG_AGENCY = 157, MNG_AG_TYP = 2 and YR_EST = 1981
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- City Agency · 1 ✖
MNG_AGENCY 1
- Palo Alto, City of · 1 ✖
DES_TP 1
- Local Conservation Area · 1 ✖
ACCESS_TYP 1
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9987 | 9987 | 9986 | {"type": "MultiPolygon", "coordinates": [[[[-122.18066, 37.38892], [-122.1723, 37.39048], [-122.17088, 37.3901], [-122.16933, 37.39028], [-122.17039, 37.38577], [-122.17089, 37.38599], [-122.17123, 37.38611], [-122.17368, 37.38683], [-122.17413, 37.38691], [-122.17612, 37.38712], [-122.17645, 37.38713], [-122.17716, 37.38704], [-122.17843, 37.38682], [-122.17869, 37.38674], [-122.18066, 37.38892]]], [[[-122.19585, 37.37295], [-122.19488, 37.37474], [-122.19337, 37.37928], [-122.1929, 37.37985], [-122.19134, 37.37966], [-122.19009, 37.37923], [-122.18963, 37.379], [-122.18935, 37.37883], [-122.18893, 37.37861], [-122.18882, 37.37856], [-122.18849, 37.37847], [-122.18694, 37.37945], [-122.18633, 37.37986], [-122.18633, 37.37988], [-122.18759, 37.38062], [-122.18585, 37.3829], [-122.18536, 37.38246], [-122.18519, 37.38234], [-122.18488, 37.38219], [-122.18474, 37.38206], [-122.18467, 37.3819], [-122.18464, 37.38154], [-122.18456, 37.38135], [-122.18442, 37.38117], [-122.18423, 37.38104], [-122.18399, 37.38095], [-122.18378, 37.38092], [-122.18356, 37.3809], [-122.18262, 37.38091], [-122.18244, 37.38094], [-122.1822, 37.38102], [-122.18205, 37.3811], [-122.18192, 37.3812], [-122.18178, 37.38138], [-122.18172, 37.38151], [-122.18147, 37.38258], [-122.18116, 37.38325], [-122.18109, 37.38347], [-122.18096, 37.38427], [-122.1809, 37.38445], [-122.18075, 37.38471], [-122.1805, 37.38505], [-122.18026, 37.3853], [-122.18008, 37.38544], [-122.17967, 37.3857], [-122.17886, 37.38644], [-122.17859, 37.38662], [-122.17846, 37.38667], [-122.17713, 37.3869], [-122.17665, 37.38697], [-122.17645, 37.38698], [-122.17625, 37.38697], [-122.17415, 37.38675], [-122.17388, 37.3867], [-122.17361, 37.38664], [-122.17131, 37.38596], [-122.17099, 37.38584], [-122.17051, 37.38564], [-122.17182, 37.37974], [-122.17235, 37.37987], [-122.17349, 37.38141], [-122.17451, 37.38173], [-122.17551, 37.38101], [-122.17651, 37.37943], [-122.17791, 37.37798], [-122.17633, 37.37702], [-122.17632, 37.37597], [-122.178, 37.37698], [-122.17878, 37.37696], [-122.18074, 37.37494], [-122.17973, 37.37432], [-122.17976, 37.37388], [-122.17957, 37.37382], [-122.17936, 37.37354], [-122.17861, 37.37286], [-122.17862, 37.37267], [-122.17857, 37.37249], [-122.17852, 37.37237], [-122.17829, 37.37201], [-122.17866, 37.37149], [-122.17768, 37.37094], [-122.17768, 37.37067], [-122.17716, 37.37065], [-122.17655, 37.37056], [-122.1766, 37.37034], [-122.17566, 37.36981], [-122.17561, 37.36965], [-122.17757, 37.36969], [-122.17773, 37.36904], [-122.17655, 37.36839], [-122.17787, 37.36834], [-122.17847, 37.36744], [-122.17931, 37.36763], [-122.17994, 37.36759], [-122.18039, 37.36775], [-122.18086, 37.36775], [-122.18133, 37.36761], [-122.18155, 37.3674], [-122.18172, 37.36694], [-122.18209, 37.36668], [-122.18307, 37.36647], [-122.1833, 37.36619], [-122.18362, 37.36568], [-122.18581, 37.36661], [-122.18401, 37.36823], [-122.18401, 37.36824], [-122.18958, 37.37147], [-122.19, 37.37155], [-122.19129, 37.37156], [-122.19157, 37.37158], [-122.19525, 37.37274], [-122.19585, 37.37295]]]]} | Open Access 1 | 17184 | Enid Pearson-Arastradero Preserve | 33226 | 1243 | Palo Alto, City of 161 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/ | City 2 | 1243 | Palo Alto, City of 157 | City 2 | City Agency 2 | http://www.cityofpaloalto.org/gov/depts/csd/parks/preserves/arastradero/ | Santa Clara 19 | 657.833 | Enid Pearson-Arastradero Preserve | 1981 | 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]);