units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where ACCESS_TYP = 4, AGNCY_WEB = "http://www.jclandtrust.org/" and DES_TP = 399
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14118 | 14118 | 14117 | {"type": "MultiPolygon", "coordinates": [[[[-124.03502, 40.80993], [-124.03498, 40.81172], [-124.03246, 40.81177], [-124.03248, 40.81705], [-124.02927, 40.8171], [-124.02926, 40.81711], [-124.02992, 40.8179], [-124.03317, 40.82081], [-124.03489, 40.822], [-124.03491, 40.82314], [-124.0345, 40.82247], [-124.03312, 40.82178], [-124.03296, 40.82168], [-124.02823, 40.82176], [-124.02824, 40.82087], [-124.02836, 40.81711], [-124.02895, 40.8171], [-124.02881, 40.81654], [-124.02839, 40.81594], [-124.02798, 40.81568], [-124.02707, 40.8152], [-124.02645, 40.81468], [-124.02631, 40.81455], [-124.0261, 40.8141], [-124.0262, 40.81377], [-124.02613, 40.81335], [-124.02589, 40.81297], [-124.02556, 40.81266], [-124.02527, 40.81232], [-124.02447, 40.81117], [-124.02409, 40.81086], [-124.02396, 40.81062], [-124.0239, 40.81002], [-124.02352, 40.80855], [-124.02346, 40.80814], [-124.02564, 40.80819], [-124.02561, 40.81005], [-124.03502, 40.80993]]], [[[-124.04434, 40.82678], [-124.04426, 40.82918], [-124.04221, 40.82917], [-124.04219, 40.82908], [-124.04223, 40.82879], [-124.04169, 40.82846], [-124.04067, 40.82843], [-124.0405, 40.82846], [-124.04036, 40.82856], [-124.03973, 40.82756], [-124.03983, 40.82704], [-124.03977, 40.8268], [-124.04013, 40.82673], [-124.04434, 40.82678]]], [[[-124.05768, 40.8335], [-124.05768, 40.83357], [-124.05758, 40.83375], [-124.05737, 40.83393], [-124.05725, 40.8342], [-124.05728, 40.83437], [-124.05736, 40.83451], [-124.0574, 40.83454], [-124.05702, 40.83465], [-124.05688, 40.83687], [-124.05618, 40.83864], [-124.05609, 40.83871], [-124.05475, 40.83809], [-124.05509, 40.83359], [-124.05526, 40.83358], [-124.05592, 40.83345], [-124.05625, 40.83344], [-124.05636, 40.8335], [-124.0566, 40.83349], [-124.05699, 40.83336], [-124.05719, 40.83333], [-124.0574, 40.83333], [-124.05753, 40.83335], [-124.05766, 40.83344], [-124.05768, 40.8335]]], [[[-124.07009, 40.83765], [-124.0679, 40.83919], [-124.06747, 40.83885], [-124.06692, 40.83922], [-124.06663, 40.83902], [-124.06593, 40.83952], [-124.06344, 40.83745], [-124.06343, 40.83657], [-124.05867, 40.83659], [-124.05867, 40.8347], [-124.06281, 40.83472], [-124.06288, 40.83478], [-124.06298, 40.83472], [-124.06301, 40.83472], [-124.06303, 40.83523], [-124.06343, 40.83522], [-124.06343, 40.83497], [-124.06488, 40.83499], [-124.06557, 40.83532], [-124.06597, 40.83578], [-124.06597, 40.83587], [-124.06601, 40.83598], [-124.06608, 40.83605], [-124.06619, 40.83612], [-124.06629, 40.83616], [-124.0664, 40.83618], [-124.06718, 40.83656], [-124.06763, 40.83681], [-124.06893, 40.83725], [-124.06923, 40.83733], [-124.06978, 40.83708], [-124.07009, 40.83765]]]]} | Unknown Access 4 | 46794 | Unnamed site - Jacoby Creek Land Trust | 30249 | 6085 | Jacoby Creek Land Trust 1072 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.jclandtrust.org/ | Non Governmental Organization 10 | 6085 | Jacoby Creek Land Trust 1028 | Non Profit 6 | Non Profit - Land Trust 10 | Humboldt 45 | 262.805 | 0 | Private Other or Unknown 399 | 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]);