units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, LABEL_NAME = "Pacheco Path" and MNG_AGENCY = 150
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- Marin County Parks Department, County of · 1 ✖
DES_TP 1
- Local Recreation 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14521 | 14521 | 14520 | {"type": "Polygon", "coordinates": [[[-122.54025, 38.03365], [-122.53987, 38.03375], [-122.53969, 38.03377], [-122.53924, 38.03375], [-122.53916, 38.03379], [-122.53855, 38.03417], [-122.53781, 38.03479], [-122.53764, 38.03494], [-122.53753, 38.03506], [-122.53742, 38.03526], [-122.53729, 38.03577], [-122.5373, 38.03598], [-122.5373, 38.03615], [-122.53713, 38.03656], [-122.5371, 38.03673], [-122.53706, 38.0376], [-122.53714, 38.03825], [-122.53741, 38.03953], [-122.5375, 38.03985], [-122.53751, 38.0401], [-122.53743, 38.04065], [-122.53725, 38.04116], [-122.53702, 38.04159], [-122.53662, 38.04223], [-122.53568, 38.04355], [-122.53555, 38.04389], [-122.53512, 38.04463], [-122.53338, 38.04702], [-122.53332, 38.04711], [-122.53324, 38.04736], [-122.53317, 38.04747], [-122.53298, 38.04762], [-122.53288, 38.0478], [-122.53288, 38.04783], [-122.53293, 38.04788], [-122.53349, 38.04817], [-122.53363, 38.04816], [-122.53357, 38.04824], [-122.53352, 38.04825], [-122.53347, 38.04824], [-122.53347, 38.04821], [-122.5329, 38.04791], [-122.53282, 38.04783], [-122.53283, 38.04779], [-122.53294, 38.04759], [-122.53313, 38.04745], [-122.53319, 38.04734], [-122.53327, 38.0471], [-122.53333, 38.047], [-122.53508, 38.04461], [-122.5355, 38.04387], [-122.53563, 38.04353], [-122.53657, 38.04222], [-122.53697, 38.04158], [-122.5372, 38.04115], [-122.53737, 38.04065], [-122.53745, 38.0401], [-122.53745, 38.03992], [-122.53742, 38.03976], [-122.53736, 38.03955], [-122.53708, 38.03827], [-122.53701, 38.0376], [-122.53701, 38.03728], [-122.53705, 38.03682], [-122.53705, 38.03674], [-122.53708, 38.03655], [-122.53725, 38.03615], [-122.53725, 38.03598], [-122.53723, 38.03577], [-122.53737, 38.03525], [-122.53744, 38.03511], [-122.5376, 38.03492], [-122.53895, 38.03378], [-122.53909, 38.03372], [-122.53927, 38.03369], [-122.53929, 38.03372], [-122.53969, 38.03373], [-122.53994, 38.03369], [-122.54018, 38.03362], [-122.54025, 38.03365]]]} | Open Access 1 | 47182 | Pacheco Path | 30874 | 306 | Marin County Parks Department, County of 154 | County 3 | County Agency - Parks 7 | http://www.marincountyparks.org/depts/pk | County 3 | 306 | Marin County Parks Department, County of 150 | County 3 | County Agency - Parks 7 | Marin 23 | 2.279 | Pacheco Path | 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]);