units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where DES_TP = 14 and LABEL_NAME = "Water Lots"
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_LEV, AGNCY_WEB, LAYER, MNG_AG_LEV
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1192 | 1192 | 1191 | {"type": "MultiPolygon", "coordinates": [[[[-122.48372, 37.92711], [-122.47966, 37.92717], [-122.4794, 37.92537], [-122.48367, 37.9253], [-122.48372, 37.92711]]], [[[-122.49518, 37.92873], [-122.48832, 37.92884], [-122.48822, 37.92522], [-122.49509, 37.9251], [-122.49518, 37.92873]]], [[[-122.49976, 37.92865], [-122.49747, 37.92869], [-122.49739, 37.92507], [-122.49764, 37.92506], [-122.49818, 37.92572], [-122.49942, 37.92654], [-122.49972, 37.92677], [-122.49976, 37.92865]]]]} | Open Access 1 | 6910 | Water Lots | 27294 | 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 | Marin 23 | 93.387 | Water Lots | 0 | Local Other or Unknown 14 | 4 | |
7430 | 7430 | 7429 | {"type": "MultiPolygon", "coordinates": [[[[-122.48318, 37.96068], [-122.47517, 37.96081], [-122.47508, 37.95723], [-122.47394, 37.95724], [-122.47393, 37.95725], [-122.47411, 37.96404], [-122.46763, 37.9615], [-122.47012, 37.95879], [-122.47324, 37.9542], [-122.47373, 37.9512], [-122.47381, 37.95388], [-122.483, 37.95372], [-122.48318, 37.96068]]], [[[-122.47874, 37.96585], [-122.47643, 37.96495], [-122.47641, 37.96441], [-122.4787, 37.96437], [-122.47874, 37.96585]]], [[[-122.48582, 37.96425], [-122.48328, 37.9643], [-122.48324, 37.96297], [-122.4858, 37.96293], [-122.48582, 37.96425]]]]} | Open Access 1 | 6933 | Water Lots | 27294 | 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 | Marin 23 | 237.341 | Water Lots | 0 | Local Other or Unknown 14 | 4 | |
7456 | 7456 | 7455 | {"type": "MultiPolygon", "coordinates": [[[[-122.47021, 38.02945], [-122.46746, 38.02948], [-122.46829, 38.02814], [-122.46957, 38.02491], [-122.47016, 38.02465], [-122.47021, 38.02945]]], [[[-122.47952, 38.03427], [-122.47724, 38.03443], [-122.4749, 38.03454], [-122.47257, 38.03457], [-122.47027, 38.03457], [-122.47025, 38.0331], [-122.4795, 38.03299], [-122.47952, 38.03427]]], [[[-122.4864, 38.03291], [-122.48181, 38.03297], [-122.48174, 38.02934], [-122.4863, 38.0293], [-122.4864, 38.03291]]], [[[-122.49743, 38.02563], [-122.4883, 38.02568], [-122.48814, 38.01948], [-122.49495, 38.01885], [-122.49505, 38.0221], [-122.49731, 38.02209], [-122.49743, 38.02563]]]]} | Open Access 1 | 6945 | Water Lots | 27294 | 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 | Marin 23 | 215.954 | Water Lots | 0 | Local Other or Unknown 14 | 4 | |
12733 | 12733 | 12732 | {"type": "MultiPolygon", "coordinates": [[[[-122.50606, 38.01702], [-122.50538, 38.01773], [-122.50389, 38.0179], [-122.5039, 38.01851], [-122.4971, 38.01865], [-122.48, 38.02023], [-122.47926, 38.02067], [-122.47925, 38.02058], [-122.47924, 38.02057], [-122.46957, 38.02491], [-122.46829, 38.02814], [-122.46444, 38.03432], [-122.45826, 38.01394], [-122.45798, 38.00928], [-122.45797, 38.00928], [-122.45718, 38.01038], [-122.45356, 37.99846], [-122.46201, 38.00454], [-122.47026, 38.00744], [-122.47894, 38.01033], [-122.48622, 38.01267], [-122.48627, 38.01271], [-122.48923, 38.01368], [-122.49539, 38.01456], [-122.50181, 38.01539], [-122.50328, 38.01578], [-122.50332, 38.0158], [-122.50338, 38.01576], [-122.50344, 38.01707], [-122.50606, 38.01702]]], [[[-122.49754, 38.02919], [-122.49296, 38.02924], [-122.49287, 38.02566], [-122.49743, 38.02564], [-122.49754, 38.02919]]]]} | Open Access 1 | 29763 | Water Lots | 27293 | 353 | Marin, County of 1034 | County 3 | County Agency 3 | http://www.marincounty.org/recreation/parks-in-marin | County 3 | 353 | Marin, County of 996 | County 3 | County Agency 3 | Marin 23 | 1356.794 | Water Lots | 1976 | Local Other or Unknown 14 | 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]);