units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
1 row where AGNCY_WEB = "http://www.rangelandtrust.org/" and MNG_AG_TYP = 10
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12523 | 12523 | 12522 | {"type": "MultiPolygon", "coordinates": [[[[-120.62587, 35.95355], [-120.61343, 35.95358], [-120.61365, 35.96403], [-120.60943, 35.96405], [-120.60936, 35.96059], [-120.60516, 35.9606], [-120.60502, 35.95011], [-120.60095, 35.95012], [-120.60099, 35.95362], [-120.59679, 35.95363], [-120.59698, 35.93941], [-120.60079, 35.9394], [-120.60075, 35.9358], [-120.60639, 35.93581], [-120.60639, 35.92859], [-120.61621, 35.92861], [-120.61644, 35.93583], [-120.62104, 35.93584], [-120.62113, 35.9394], [-120.62555, 35.93945], [-120.62587, 35.95355]]], [[[-120.69833, 35.90039], [-120.69742, 35.90191], [-120.69722, 35.90218], [-120.69702, 35.90239], [-120.69632, 35.90299], [-120.69609, 35.90316], [-120.69576, 35.90333], [-120.69503, 35.90358], [-120.69471, 35.90374], [-120.6944, 35.90395], [-120.69383, 35.90446], [-120.69357, 35.90464], [-120.69323, 35.90483], [-120.69286, 35.90497], [-120.69271, 35.90506], [-120.69255, 35.90518], [-120.69236, 35.90537], [-120.69143, 35.90667], [-120.69105, 35.90728], [-120.69077, 35.90762], [-120.68696, 35.90759], [-120.68699, 35.91081], [-120.68666, 35.91126], [-120.68635, 35.91171], [-120.68607, 35.91217], [-120.68577, 35.9127], [-120.68571, 35.91283], [-120.68568, 35.91297], [-120.68567, 35.91339], [-120.68562, 35.91353], [-120.68555, 35.91367], [-120.68545, 35.9138], [-120.68536, 35.91388], [-120.68458, 35.91442], [-120.68434, 35.91461], [-120.68412, 35.91486], [-120.68402, 35.915], [-120.68392, 35.91519], [-120.6836, 35.91613], [-120.6833, 35.91708], [-120.68326, 35.91729], [-120.68326, 35.9175], [-120.6833, 35.91802], [-120.68331, 35.91835], [-120.68331, 35.91844], [-120.68326, 35.91853], [-120.67819, 35.9164], [-120.67822, 35.91825], [-120.67737, 35.92185], [-120.67738, 35.92186], [-120.67792, 35.92187], [-120.65201, 35.93276], [-120.65199, 35.93613], [-120.64758, 35.93609], [-120.64761, 35.93787], [-120.64313, 35.93605], [-120.63429, 35.93597], [-120.63436, 35.93953], [-120.62995, 35.93949], [-120.62545, 35.93586], [-120.62506, 35.92142], [-120.62489, 35.91427], [-120.62928, 35.9143], [-120.62921, 35.91071], [-120.62481, 35.91066], [-120.62472, 35.9071], [-120.6203, 35.90706], [-120.6111, 35.90701], [-120.61109, 35.90336], [-120.61564, 35.9034], [-120.61557, 35.89975], [-120.62011, 35.89969], [-120.62012, 35.89968], [-120.62002, 35.89609], [-120.61549, 35.89615], [-120.61544, 35.889], [-120.61092, 35.889], [-120.61097, 35.88184], [-120.61519, 35.88184], [-120.61516, 35.87462], [-120.61956, 35.87464], [-120.61956, 35.87102], [-120.62405, 35.87104], [-120.62402, 35.86737], [-120.62849, 35.86739], [-120.62852, 35.87106], [-120.6375, 35.8711], [-120.63749, 35.84954], [-120.66198, 35.84961], [-120.66198, 35.84976], [-120.66237, 35.84993], [-120.66248, 35.8501], [-120.66255, 35.8503], [-120.66258, 35.85058], [-120.66261, 35.85075], [-120.66275, 35.85113], [-120.66291, 35.85144], [-120.66311, 35.85169], [-120.66358, 35.85245], [-120.66399, 35.85302], [-120.66413, 35.8532], [-120.66436, 35.85344], [-120.66447, 35.85349], [-120.66439, 35.86394], [-120.66439, 35.8676], [-120.67758, 35.86769], [-120.67755, 35.87872], [-120.68206, 35.87874], [-120.68207, 35.87964], [-120.68176, 35.87987], [-120.68153, 35.88014], [-120.68142, 35.88032], [-120.68104, 35.88117], [-120.68093, 35.88135], [-120.68078, 35.88155], [-120.68063, 35.88171], [-120.68043, 35.88189], [-120.68021, 35.88205], [-120.67991, 35.88222], [-120.67978, 35.88232], [-120.67967, 35.88245], [-120.6796, 35.88256], [-120.67954, 35.88268], [-120.67951, 35.88278], [-120.67949, 35.883], [-120.67946, 35.88309], [-120.67939, 35.88318], [-120.67927, 35.88328], [-120.67835, 35.88368], [-120.67818, 35.88373], [-120.67775, 35.88377], [-120.67752, 35.88383], [-120.67652, 35.88424], [-120.67601, 35.88449], [-120.67573, 35.88458], [-120.6754, 35.88464], [-120.6752, 35.88466], [-120.675, 35.88463], [-120.67479, 35.88455], [-120.67463, 35.88447], [-120.67444, 35.8843], [-120.67412, 35.8838], [-120.67407, 35.88374], [-120.67401, 35.88371], [-120.67389, 35.8837], [-120.67362, 35.88376], [-120.67347, 35.88383], [-120.67337, 35.88393], [-120.67329, 35.88408], [-120.67318, 35.88466], [-120.67327, 35.8894], [-120.67553, 35.88942], [-120.6755, 35.88583], [-120.6777, 35.88585], [-120.67779, 35.893], [-120.68667, 35.89306], [-120.68664, 35.8895], [-120.68888, 35.88951], [-120.68879, 35.88234], [-120.69107, 35.88235], [-120.69124, 35.89674], [-120.69565, 35.89676], [-120.6957, 35.90038], [-120.69833, 35.90039]]]]} | No Public Access 3 | 29015 | Deer Valley Ranch | 18003 | 3012 | California Rangeland Trust 1030 | Non Profit 6 | Non Profit - Land Trust 10 | http://www.rangelandtrust.org/ | Non Governmental Organization 10 | 3012 | California Rangeland Trust 991 | Non Profit 6 | Non Profit - Land Trust 10 | Monterey 14 | 12787.096 | Deer Valley Ranch | 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]);