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 = 6 and UNIT_NAME = "Ventu Park Open Space"
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
- Open Space District · 1 ✖
MNG_AGENCY 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
16007 | 16007 | 16006 | {"type": "MultiPolygon", "coordinates": [[[[-118.91389, 34.16856], [-118.91377, 34.16876], [-118.91372, 34.16925], [-118.91365, 34.16948], [-118.91353, 34.16955], [-118.91314, 34.16949], [-118.91303, 34.16953], [-118.91264, 34.1693], [-118.91282, 34.16914], [-118.91258, 34.16883], [-118.91348, 34.16856], [-118.91351, 34.16868], [-118.91367, 34.16861], [-118.91382, 34.16851], [-118.91389, 34.16856]]], [[[-118.92101, 34.17209], [-118.92069, 34.1721], [-118.92069, 34.17421], [-118.9206, 34.17423], [-118.92042, 34.17414], [-118.92024, 34.17401], [-118.91984, 34.17358], [-118.91958, 34.17356], [-118.91924, 34.17368], [-118.91911, 34.17366], [-118.91897, 34.17345], [-118.91878, 34.17327], [-118.91889, 34.17298], [-118.91859, 34.1725], [-118.91834, 34.17245], [-118.91825, 34.17225], [-118.91741, 34.1721], [-118.91651, 34.17183], [-118.91621, 34.17185], [-118.91557, 34.17197], [-118.91507, 34.17171], [-118.91465, 34.17175], [-118.91438, 34.17181], [-118.91441, 34.17203], [-118.91433, 34.17203], [-118.91427, 34.17206], [-118.91423, 34.17211], [-118.91423, 34.17223], [-118.91411, 34.17225], [-118.91404, 34.17183], [-118.9141, 34.17181], [-118.914, 34.17103], [-118.91367, 34.17105], [-118.91365, 34.17082], [-118.91409, 34.17058], [-118.91409, 34.16711], [-118.91574, 34.16546], [-118.91754, 34.16532], [-118.92098, 34.16443], [-118.92103, 34.17037], [-118.92101, 34.17209]]], [[[-118.91663, 34.17627], [-118.91649, 34.1764], [-118.91547, 34.17657], [-118.91479, 34.17663], [-118.91441, 34.17663], [-118.91423, 34.1754], [-118.91456, 34.17536], [-118.91438, 34.17392], [-118.91466, 34.17408], [-118.91508, 34.17445], [-118.91517, 34.17455], [-118.91536, 34.1746], [-118.91515, 34.17484], [-118.91505, 34.17514], [-118.91516, 34.17534], [-118.91591, 34.1755], [-118.91624, 34.17538], [-118.91663, 34.17627]]], [[[-118.91896, 34.17568], [-118.91883, 34.17588], [-118.91885, 34.176], [-118.91712, 34.17629], [-118.91686, 34.17613], [-118.9168, 34.17572], [-118.91685, 34.17552], [-118.9169, 34.17546], [-118.91705, 34.17542], [-118.91715, 34.17514], [-118.91743, 34.17503], [-118.91774, 34.1751], [-118.91789, 34.17508], [-118.91808, 34.17496], [-118.91824, 34.17512], [-118.91838, 34.17515], [-118.91857, 34.17516], [-118.91876, 34.17534], [-118.91896, 34.17568]]]]} | Open Access 1 | 1701 | Ventu Park Open Space | 26849 | 2024 | Conejo Open Space Conservation Agency 504 | Special District 4 | Open Space District 6 | http://www.conejo-openspace.org/ | Special District 4 | 2024 | Conejo Open Space Conservation Agency 496 | Special District 4 | Open Space District 6 | Ventura 8 | 141.038 | Ventu Park 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]);