units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 3, ACRES = "74.622" and MNG_AGENCY = 389
This data as json, copyable, CSV (advanced)
MNG_AG_TYP 1
MNG_AGENCY 1
- The Environmental Trust · 1 ✖
DES_TP 1
ACCESS_TYP 1
- No Public 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
8158 | 8158 | 8157 | {"type": "MultiPolygon", "coordinates": [[[[-117.17834, 33.15876], [-117.17412, 33.15879], [-117.17398, 33.15703], [-117.16536, 33.15715], [-117.16518, 33.15371], [-117.16539, 33.15373], [-117.16535, 33.15406], [-117.16536, 33.15424], [-117.1653, 33.15459], [-117.16536, 33.15583], [-117.1655, 33.15606], [-117.16571, 33.15631], [-117.16592, 33.15648], [-117.16614, 33.15663], [-117.16637, 33.15671], [-117.16653, 33.15645], [-117.16662, 33.15649], [-117.16673, 33.15647], [-117.1668, 33.15639], [-117.1668, 33.15632], [-117.16676, 33.15627], [-117.1667, 33.15623], [-117.16656, 33.15624], [-117.16644, 33.15618], [-117.16629, 33.15609], [-117.16615, 33.15596], [-117.16607, 33.15585], [-117.16598, 33.15567], [-117.16595, 33.15553], [-117.16595, 33.15533], [-117.16599, 33.15511], [-117.16644, 33.15515], [-117.16644, 33.15488], [-117.16662, 33.15379], [-117.16669, 33.15355], [-117.16782, 33.15355], [-117.16766, 33.15382], [-117.16784, 33.15399], [-117.16813, 33.15402], [-117.16819, 33.15406], [-117.16824, 33.15408], [-117.16833, 33.15407], [-117.16838, 33.15403], [-117.1686, 33.15404], [-117.16859, 33.15441], [-117.16892, 33.15443], [-117.16893, 33.15461], [-117.16881, 33.15502], [-117.16883, 33.15511], [-117.1688, 33.15547], [-117.1687, 33.15564], [-117.16846, 33.15589], [-117.1683, 33.15596], [-117.16809, 33.15611], [-117.16802, 33.15629], [-117.16803, 33.15631], [-117.16829, 33.15631], [-117.16827, 33.15639], [-117.16829, 33.15644], [-117.16833, 33.15648], [-117.16841, 33.15651], [-117.16851, 33.15649], [-117.16858, 33.15641], [-117.16878, 33.15632], [-117.16895, 33.15618], [-117.16928, 33.15642], [-117.16936, 33.15633], [-117.1694, 33.15619], [-117.16953, 33.15608], [-117.1696, 33.15586], [-117.16973, 33.15556], [-117.17004, 33.1547], [-117.16996, 33.15425], [-117.16987, 33.15407], [-117.17073, 33.15411], [-117.1712, 33.15412], [-117.17139, 33.15408], [-117.17199, 33.15391], [-117.17277, 33.15391], [-117.17281, 33.15392], [-117.17278, 33.15402], [-117.17323, 33.15424], [-117.17339, 33.15423], [-117.17355, 33.15411], [-117.1735, 33.15352], [-117.17371, 33.15352], [-117.17399, 33.15703], [-117.17776, 33.15699], [-117.17782, 33.15716], [-117.17793, 33.15737], [-117.17807, 33.15756], [-117.17829, 33.15779], [-117.17834, 33.15876]]], [[[-117.17826, 33.15738], [-117.17816, 33.15727], [-117.17798, 33.15699], [-117.17823, 33.15699], [-117.17826, 33.15738]]]]} | No Public Access 3 | 12366 | Land Pres/Mitigation Bank - The Environmental Trust | 21002 | 3088 | The Environmental Trust 395 | Non Profit 6 | Non Profit - Land Trust 10 | Non Governmental Organization 10 | 3088 | The Environmental Trust 389 | Non Profit 6 | Non Profit - Land Trust 10 | San Diego 4 | 74.622 | Land Pres/Mitigation Bank - The Environmental Trust | 0 | Private Conservation 16 | 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]);