units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 3, MNG_AG_TYP = 2 and UNIT_NAME = "Cliff Drive Open Space"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7362 | 7362 | 7361 | {"type": "MultiPolygon", "coordinates": [[[[-122.03538, 36.95212], [-122.0353, 36.9523], [-122.03511, 36.95225], [-122.03518, 36.95204], [-122.03522, 36.95204], [-122.03538, 36.95212]]], [[[-122.03616, 36.95249], [-122.03607, 36.9526], [-122.0358, 36.95246], [-122.03587, 36.95235], [-122.03616, 36.95249]]], [[[-122.03706, 36.95292], [-122.03667, 36.95284], [-122.03627, 36.95268], [-122.03635, 36.95258], [-122.03706, 36.95292]]], [[[-122.04335, 36.95119], [-122.04321, 36.95125], [-122.04297, 36.9513], [-122.04287, 36.95135], [-122.04265, 36.95153], [-122.04235, 36.95186], [-122.04223, 36.95178], [-122.04223, 36.95171], [-122.04231, 36.9516], [-122.04243, 36.95156], [-122.04264, 36.95152], [-122.04267, 36.95147], [-122.04272, 36.95142], [-122.04272, 36.95138], [-122.04268, 36.95131], [-122.04269, 36.95129], [-122.04282, 36.95131], [-122.0429, 36.9513], [-122.04301, 36.95127], [-122.04334, 36.95113], [-122.04335, 36.95119]]], [[[-122.04432, 36.95078], [-122.04383, 36.95099], [-122.04383, 36.95099], [-122.04381, 36.9509], [-122.04385, 36.95088], [-122.04395, 36.95083], [-122.04403, 36.95082], [-122.0442, 36.95071], [-122.0443, 36.95067], [-122.04432, 36.95078]]], [[[-122.04653, 36.94982], [-122.04617, 36.95006], [-122.04599, 36.95014], [-122.04589, 36.95017], [-122.04568, 36.95017], [-122.0455, 36.95021], [-122.04547, 36.95006], [-122.04562, 36.95006], [-122.04575, 36.95009], [-122.04581, 36.95012], [-122.04591, 36.95012], [-122.04602, 36.95005], [-122.04606, 36.94995], [-122.04619, 36.94984], [-122.0465, 36.94968], [-122.04653, 36.94982]]]]} | Open Access 1 | 7318 | Cliff Drive Open Space | 17423 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | http://www.cityofsantacruz.com/departments/parks-recreation | City 2 | 1320 | Santa Cruz, City of 9 | City 2 | City Agency 2 | Santa Cruz 5 | 1.086 | Cliff Drive OS | 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]);