units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where ACCESS_TYP = 2, COUNTY = 33 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11220 | 11220 | 11219 | {"type": "MultiPolygon", "coordinates": [[[[-121.85585, 38.54747], [-121.85574, 38.54752], [-121.8547, 38.54676], [-121.84865, 38.54676], [-121.84855, 38.54002], [-121.84765, 38.53629], [-121.84906, 38.5368], [-121.85056, 38.53688], [-121.85099, 38.53684], [-121.85466, 38.5454], [-121.85571, 38.54611], [-121.85593, 38.54711], [-121.85585, 38.54747]]], [[[-121.88703, 38.54702], [-121.87868, 38.54998], [-121.87833, 38.55008], [-121.87812, 38.5501], [-121.87787, 38.55007], [-121.8777, 38.55003], [-121.87756, 38.54997], [-121.87746, 38.5499], [-121.87729, 38.54975], [-121.87566, 38.54762], [-121.87541, 38.54739], [-121.87526, 38.5473], [-121.87488, 38.5472], [-121.87474, 38.54718], [-121.87446, 38.54719], [-121.87404, 38.5473], [-121.87295, 38.54768], [-121.86509, 38.5468], [-121.86285, 38.5476], [-121.86088, 38.54662], [-121.85933, 38.54626], [-121.85618, 38.54706], [-121.85594, 38.54599], [-121.85486, 38.54529], [-121.85281, 38.54046], [-121.86313, 38.54083], [-121.86314, 38.54082], [-121.86278, 38.53964], [-121.86247, 38.53841], [-121.86259, 38.5384], [-121.86348, 38.53839], [-121.86518, 38.5376], [-121.86643, 38.53745], [-121.87184, 38.53864], [-121.87529, 38.5381], [-121.88095, 38.53811], [-121.88215, 38.53851], [-121.88703, 38.54702]]], [[[-121.8512, 38.55961], [-121.84994, 38.55922], [-121.84958, 38.55931], [-121.84957, 38.55428], [-121.84039, 38.55427], [-121.84041, 38.55009], [-121.84036, 38.54796], [-121.84093, 38.54792], [-121.84094, 38.54717], [-121.8442, 38.54693], [-121.85462, 38.54697], [-121.85592, 38.54792], [-121.85632, 38.54873], [-121.85648, 38.54899], [-121.85667, 38.54923], [-121.8568, 38.54935], [-121.85706, 38.54949], [-121.85724, 38.54955], [-121.85758, 38.54962], [-121.85781, 38.54959], [-121.85852, 38.54943], [-121.85862, 38.55429], [-121.85861, 38.5615], [-121.85696, 38.5615], [-121.85696, 38.56138], [-121.85594, 38.56113], [-121.85488, 38.56091], [-121.85472, 38.56086], [-121.85462, 38.56078], [-121.85457, 38.56067], [-121.85451, 38.56043], [-121.85444, 38.56032], [-121.85429, 38.5602], [-121.85412, 38.56014], [-121.85328, 38.55999], [-121.8517, 38.55989], [-121.8512, 38.55961]]], [[[-121.87753, 38.55048], [-121.86982, 38.55324], [-121.86773, 38.55047], [-121.86777, 38.55427], [-121.86798, 38.56153], [-121.85884, 38.5615], [-121.8588, 38.54943], [-121.85897, 38.54935], [-121.85897, 38.54919], [-121.86515, 38.54699], [-121.87287, 38.54783], [-121.87313, 38.54778], [-121.87321, 38.54791], [-121.87269, 38.54808], [-121.87249, 38.54912], [-121.8725, 38.54913], [-121.87332, 38.54893], [-121.874, 38.54844], [-121.87547, 38.54781], [-121.87753, 38.55048]]]]} | Restricted Access 2 | 21555 | Russell Ranch | 24742 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Yolo 33 | 1568.46 | Russell Ranch | 0 | State Other or Unknown 104 | 4 | |
| 11481 | 11481 | 11480 | {"type": "MultiPolygon", "coordinates": [[[[-121.78572, 38.52691], [-121.78568, 38.52895], [-121.78352, 38.52897], [-121.78263, 38.52877], [-121.7824, 38.52859], [-121.78213, 38.52879], [-121.78196, 38.52865], [-121.78187, 38.52868], [-121.78033, 38.52991], [-121.78002, 38.53011], [-121.77969, 38.53029], [-121.7795, 38.53036], [-121.77922, 38.53043], [-121.77871, 38.53051], [-121.77837, 38.53053], [-121.77776, 38.53052], [-121.77775, 38.53054], [-121.77708, 38.53053], [-121.77706, 38.53051], [-121.77707, 38.53043], [-121.77704, 38.53031], [-121.77683, 38.52993], [-121.77683, 38.52983], [-121.77686, 38.52979], [-121.7769, 38.52978], [-121.77791, 38.52975], [-121.77826, 38.5297], [-121.77941, 38.52948], [-121.77985, 38.52932], [-121.78, 38.52925], [-121.78045, 38.52893], [-121.78161, 38.52794], [-121.78208, 38.52757], [-121.78229, 38.52735], [-121.78272, 38.52674], [-121.78285, 38.52671], [-121.78353, 38.52685], [-121.78572, 38.52691]]], [[[-121.80338, 38.52697], [-121.80338, 38.52711], [-121.80305, 38.52714], [-121.80278, 38.52719], [-121.80124, 38.52766], [-121.80093, 38.52773], [-121.8004, 38.52782], [-121.79956, 38.52787], [-121.79879, 38.52795], [-121.79831, 38.52799], [-121.79738, 38.52802], [-121.79678, 38.52799], [-121.79655, 38.52792], [-121.79616, 38.52767], [-121.79591, 38.52757], [-121.79525, 38.52737], [-121.7948, 38.52728], [-121.79447, 38.52719], [-121.79362, 38.52682], [-121.79304, 38.52659], [-121.79264, 38.52639], [-121.79206, 38.52603], [-121.79157, 38.52585], [-121.79099, 38.52556], [-121.79056, 38.52544], [-121.78994, 38.52521], [-121.78863, 38.5247], [-121.78818, 38.52447], [-121.78728, 38.5239], [-121.78697, 38.52374], [-121.7868, 38.52368], [-121.78656, 38.5236], [-121.78636, 38.52356], [-121.7862, 38.52354], [-121.78591, 38.52355], [-121.78507, 38.52365], [-121.7837, 38.52387], [-121.78363, 38.52355], [-121.78397, 38.52325], [-121.78466, 38.52325], [-121.78552, 38.5231], [-121.78601, 38.52309], [-121.7864, 38.52313], [-121.78697, 38.52329], [-121.78751, 38.52346], [-121.78861, 38.52401], [-121.78959, 38.52443], [-121.79037, 38.52473], [-121.79064, 38.5249], [-121.7912, 38.52516], [-121.79159, 38.52539], [-121.79191, 38.52556], [-121.79282, 38.52598], [-121.79328, 38.52622], [-121.79386, 38.5265], [-121.79465, 38.52684], [-121.79635, 38.52738], [-121.79711, 38.52752], [-121.79753, 38.52759], [-121.79791, 38.5276], [-121.79872, 38.52747], [-121.79978, 38.52733], [-121.80174, 38.52715], [-121.80253, 38.52704], [-121.80338, 38.52697]]], [[[-121.81242, 38.52598], [-121.81241, 38.52689], [-121.81218, 38.52689], [-121.81217, 38.52679], [-121.81207, 38.52674], [-121.81198, 38.52677], [-121.81195, 38.5268], [-121.81187, 38.52685], [-121.81139, 38.52696], [-121.8107, 38.5271], [-121.80999, 38.52715], [-121.80873, 38.52729], [-121.80597, 38.52746], [-121.80523, 38.52745], [-121.80473, 38.52727], [-121.80359, 38.52712], [-121.80359, 38.52695], [-121.80387, 38.52693], [-121.80622, 38.52688], [-121.80707, 38.52691], [-121.80756, 38.52687], [-121.80896, 38.52681], [-121.80952, 38.52671], [-121.80997, 38.52651], [-121.81068, 38.5263], [-121.81153, 38.52611], [-121.81242, 38.52598]]], [[[-121.81243, 38.53024], [-121.81236, 38.53025], [-121.81236, 38.5323], [-121.81202, 38.53231], [-121.81201, 38.53204], [-121.81149, 38.53205], [-121.81107, 38.53178], [-121.81049, 38.53209], [-121.80992, 38.53218], [-121.80969, 38.53219], [-121.80817, 38.53216], [-121.80761, 38.53218], [-121.8076, 38.53209], [-121.80761, 38.53181], [-121.80759, 38.53169], [-121.80755, 38.53163], [-121.80757, 38.53143], [-121.80754, 38.53128], [-121.80749, 38.53084], [-121.80722, 38.53078], [-121.807, 38.53071], [-121.80679, 38.53062], [-121.80659, 38.53051], [-121.8063, 38.53032], [-121.80593, 38.52989], [-121.80581, 38.52987], [-121.80529, 38.52989], [-121.80534, 38.52763], [-121.80897, 38.52739], [-121.80914, 38.52733], [-121.80946, 38.52729], [-121.80946, 38.52803], [-121.81072, 38.52803], [-121.81077, 38.52816], [-121.81085, 38.52825], [-121.81099, 38.52834], [-121.81109, 38.52837], [-121.81122, 38.52839], [-121.81242, 38.52839], [-121.81243, 38.53024]]]]} | Restricted Access 2 | 23108 | Putah Creek Riparian Reserve | 24035 | 217 | University of California 53 | State 5 | State Agency 5 | http://nrs.ucop.edu/ | Other State 5 | 217 | University of California 51 | State 5 | State Agency 5 | Yolo 33 | 125.443 | Putah Creek Riparian Reserve | 0 | State Conservation Area 8 | 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]);