units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where DES_TP = 94, LAYER = 5 and MNG_AG_TYP = 5
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1041 | 1041 | 1040 | {"type": "Polygon", "coordinates": [[[-118.42426, 34.13667], [-118.4242, 34.13642], [-118.42398, 34.13639], [-118.42387, 34.13567], [-118.42373, 34.13499], [-118.42361, 34.13458], [-118.42363, 34.13425], [-118.42376, 34.13401], [-118.42374, 34.13394], [-118.42342, 34.13373], [-118.42341, 34.13374], [-118.42341, 34.13384], [-118.42315, 34.13384], [-118.42288, 34.13459], [-118.42283, 34.13517], [-118.42249, 34.13506], [-118.42249, 34.13323], [-118.4226, 34.13311], [-118.42266, 34.13301], [-118.4227, 34.13274], [-118.4228, 34.13262], [-118.42292, 34.13241], [-118.42306, 34.13231], [-118.42347, 34.1322], [-118.42374, 34.13209], [-118.42389, 34.132], [-118.42401, 34.1319], [-118.42405, 34.13183], [-118.42406, 34.13177], [-118.424, 34.13167], [-118.424, 34.13163], [-118.42418, 34.1315], [-118.42433, 34.13143], [-118.42462, 34.13136], [-118.42518, 34.13136], [-118.42524, 34.1314], [-118.42525, 34.13148], [-118.42521, 34.13154], [-118.4251, 34.13164], [-118.42508, 34.13171], [-118.42508, 34.13178], [-118.42516, 34.13194], [-118.42515, 34.13207], [-118.42524, 34.13217], [-118.42525, 34.13221], [-118.42522, 34.13226], [-118.42512, 34.1323], [-118.42507, 34.13235], [-118.42506, 34.13241], [-118.42509, 34.13257], [-118.42506, 34.13266], [-118.42499, 34.13278], [-118.42498, 34.13287], [-118.42501, 34.13294], [-118.42513, 34.13297], [-118.42515, 34.13302], [-118.42502, 34.13334], [-118.42497, 34.13352], [-118.42457, 34.13439], [-118.42426, 34.13667]]]} | Open Access 1 | 6864 | Dixie Canyon Park | 18170 | 215 | Santa Monica Mountains Conservancy 49 | State 5 | State Agency 5 | http://www.smmc.ca.gov | Other State 5 | 215 | Santa Monica Mountains Conservancy 303 | State 5 | State Agency 5 | Los Angeles 6 | 18.289 | Dixie Canyon Park | None 94 |
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]);