units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 1, LABEL_NAME = "Little Mtn. OSP" and MNG_AG_TYP = 4
This data as json, copyable, CSV (advanced)
These facets timed out: MNG_AGENCY, MNG_AG_TYP, DES_TP
ACCESS_TYP 1
- Open Access · 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5110 | 5110 | 5109 | {"type": "Polygon", "coordinates": [[[-122.63003, 38.12056], [-122.62866, 38.12079], [-122.62849, 38.12084], [-122.62828, 38.12092], [-122.62813, 38.12103], [-122.62802, 38.12123], [-122.6279, 38.12139], [-122.62743, 38.12165], [-122.627, 38.12185], [-122.62683, 38.12198], [-122.62643, 38.12233], [-122.62629, 38.12242], [-122.62616, 38.12247], [-122.62604, 38.12249], [-122.62588, 38.12248], [-122.6258, 38.12246], [-122.62536, 38.12223], [-122.62512, 38.12214], [-122.62475, 38.1219], [-122.62457, 38.1218], [-122.62443, 38.12167], [-122.62422, 38.12142], [-122.6241, 38.12133], [-122.62393, 38.12126], [-122.62377, 38.12122], [-122.62357, 38.12121], [-122.62326, 38.12124], [-122.62301, 38.12122], [-122.62263, 38.12112], [-122.62248, 38.12112], [-122.62223, 38.12107], [-122.62203, 38.12096], [-122.6214, 38.12026], [-122.62113, 38.11978], [-122.62101, 38.1197], [-122.62085, 38.11968], [-122.62047, 38.11976], [-122.62027, 38.11977], [-122.61989, 38.11977], [-122.6198, 38.11972], [-122.61975, 38.11965], [-122.61965, 38.11941], [-122.61954, 38.11935], [-122.62072, 38.11659], [-122.62052, 38.11661], [-122.61976, 38.11657], [-122.6148, 38.11518], [-122.61336, 38.11466], [-122.61588, 38.11359], [-122.61582, 38.11322], [-122.61631, 38.11317], [-122.6163, 38.11298], [-122.61727, 38.11303], [-122.61904, 38.113], [-122.61906, 38.11268], [-122.61919, 38.11268], [-122.61919, 38.113], [-122.62004, 38.113], [-122.62035, 38.11302], [-122.62059, 38.11302], [-122.62092, 38.11298], [-122.62101, 38.11295], [-122.62083, 38.11264], [-122.62096, 38.11258], [-122.62115, 38.11289], [-122.62133, 38.11281], [-122.62175, 38.11271], [-122.62278, 38.11279], [-122.62313, 38.11275], [-122.62305, 38.11242], [-122.62312, 38.1124], [-122.62328, 38.11271], [-122.62354, 38.11263], [-122.62364, 38.11256], [-122.62383, 38.11239], [-122.62422, 38.11251], [-122.6245, 38.11258], [-122.62496, 38.11263], [-122.62498, 38.11228], [-122.62511, 38.11228], [-122.62511, 38.11264], [-122.62619, 38.11265], [-122.6262, 38.11229], [-122.62633, 38.11229], [-122.62634, 38.11264], [-122.62736, 38.11264], [-122.62776, 38.11287], [-122.6281, 38.11294], [-122.62843, 38.11287], [-122.62891, 38.11259], [-122.62897, 38.11254], [-122.62903, 38.11229], [-122.62911, 38.1123], [-122.62905, 38.11259], [-122.62908, 38.11261], [-122.62996, 38.1126], [-122.63003, 38.12056]]]} | Open Access 1 | 17396 | Little Mountain Open Space Preserve | 31441 | 2070 | Marin County Open Space District 44 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/Depts/PK.aspx | Special District 4 | 2070 | Marin County Open Space District 43 | Special District 4 | Recreation/Parks District 4 | http://www.marincountyparks.org/depts/pk/divisions/open-space/little-mountain | Marin 23 | 239.312 | Little Mtn. OSP | 1995 | 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]);