units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
4 rows where COUNTY = 12, LAYER = 5 and MNG_AG_TYP = 5
This data as json, copyable, CSV (advanced)
Suggested facets: AGNCY_ID, AGNCY_NAME, AGNCY_WEB, MNG_AG_ID, YR_EST
MNG_AGENCY 3
DES_TP 3
- State Conservation Area 2
- None 1
- None 1
ACCESS_TYP 3
MNG_AG_TYP 1
- State Agency · 4 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
125 | 125 | 124 | {"type": "Polygon", "coordinates": [[[-122.16054, 37.91443], [-122.15949, 37.91447], [-122.15824, 37.91493], [-122.15833, 37.91517], [-122.15835, 37.9154], [-122.15843, 37.91558], [-122.15855, 37.91562], [-122.1591, 37.91596], [-122.15923, 37.916], [-122.15932, 37.91606], [-122.15944, 37.9161], [-122.15978, 37.91678], [-122.15987, 37.91706], [-122.15989, 37.91733], [-122.15981, 37.91743], [-122.15968, 37.9175], [-122.15952, 37.91752], [-122.1583, 37.91752], [-122.15781, 37.91755], [-122.15781, 37.9177], [-122.15682, 37.91818], [-122.15556, 37.91921], [-122.15437, 37.92001], [-122.15249, 37.92204], [-122.15111, 37.92218], [-122.14987, 37.92221], [-122.14886, 37.92159], [-122.14828, 37.92145], [-122.14816, 37.92139], [-122.14803, 37.92129], [-122.14763, 37.92077], [-122.14752, 37.92071], [-122.14689, 37.92039], [-122.14573, 37.91988], [-122.14487, 37.91881], [-122.14368, 37.91819], [-122.14285, 37.91769], [-122.14266, 37.9176], [-122.14226, 37.91738], [-122.14209, 37.91701], [-122.14195, 37.91666], [-122.14182, 37.91621], [-122.14211, 37.9161], [-122.14325, 37.91561], [-122.14391, 37.91541], [-122.14487, 37.91524], [-122.14541, 37.91512], [-122.14599, 37.91505], [-122.14652, 37.91488], [-122.14719, 37.91472], [-122.14806, 37.91437], [-122.14828, 37.91418], [-122.14845, 37.91387], [-122.14876, 37.91372], [-122.14919, 37.91365], [-122.14961, 37.91369], [-122.14986, 37.91367], [-122.15009, 37.91362], [-122.15051, 37.91345], [-122.15067, 37.91336], [-122.1508, 37.91331], [-122.15093, 37.9132], [-122.15112, 37.91294], [-122.15129, 37.91276], [-122.15141, 37.91268], [-122.15173, 37.91256], [-122.15298, 37.91254], [-122.15334, 37.91257], [-122.15363, 37.91257], [-122.15418, 37.9127], [-122.15462, 37.91292], [-122.15559, 37.91319], [-122.15586, 37.91333], [-122.15636, 37.91343], [-122.15653, 37.91344], [-122.15685, 37.9134], [-122.15756, 37.9135], [-122.15813, 37.9136], [-122.15841, 37.91372], [-122.15882, 37.91396], [-122.15901, 37.91397], [-122.15914, 37.91394], [-122.1593, 37.91388], [-122.15958, 37.91383], [-122.15976, 37.91392], [-122.1601, 37.91419], [-122.16054, 37.91443]]]} | Restricted Access 2 | 315 | Russell Research Station (UC) | 24744 | 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 | Contra Costa 12 | 247.32 | Russell Research Station (UC) | None 17 | |||
8447 | 8447 | 8446 | {"type": "MultiPolygon", "coordinates": [[[[-121.62267, 37.80157], [-121.62226, 37.80072], [-121.62267, 37.80062], [-121.62267, 37.80062], [-121.62267, 37.80157]]], [[[-121.55271, 37.82044], [-121.5527, 37.82055], [-121.55258, 37.82072], [-121.55211, 37.82084], [-121.5519, 37.82083], [-121.55134, 37.82068], [-121.55128, 37.82061], [-121.55125, 37.82052], [-121.55127, 37.82045], [-121.55133, 37.82041], [-121.55148, 37.82039], [-121.55211, 37.82049], [-121.55256, 37.82043], [-121.55271, 37.82044]]], [[[-121.61977, 37.80132], [-121.61811, 37.80233], [-121.60775, 37.81064], [-121.60703, 37.81129], [-121.60645, 37.81193], [-121.59685, 37.82357], [-121.59566, 37.82283], [-121.59566, 37.82262], [-121.59995, 37.81661], [-121.60495, 37.81028], [-121.60494, 37.80939], [-121.60484, 37.80938], [-121.60486, 37.80574], [-121.60879, 37.80398], [-121.61977, 37.80132]]], [[[-121.62324, 37.80314], [-121.62261, 37.80386], [-121.62268, 37.80861], [-121.62145, 37.80934], [-121.61396, 37.80941], [-121.60494, 37.81918], [-121.60473, 37.81939], [-121.59966, 37.82384], [-121.59888, 37.82485], [-121.59861, 37.82466], [-121.59756, 37.82401], [-121.6072, 37.81232], [-121.60773, 37.81173], [-121.60839, 37.81115], [-121.62101, 37.80102], [-121.62209, 37.80076], [-121.62267, 37.80196], [-121.62267, 37.80228], [-121.62283, 37.80228], [-121.62324, 37.80314]]], [[[-121.60028, 37.83829], [-121.59481, 37.83821], [-121.59483, 37.83946], [-121.59478, 37.83962], [-121.59461, 37.83973], [-121.59436, 37.83973], [-121.59423, 37.83967], [-121.59408, 37.83952], [-121.59409, 37.83933], [-121.59415, 37.83907], [-121.59372, 37.83863], [-121.59371, 37.83864], [-121.59376, 37.83898], [-121.59362, 37.83937], [-121.59289, 37.8395], [-121.59271, 37.84067], [-121.59224, 37.84168], [-121.5918, 37.84299], [-121.59147, 37.84356], [-121.59136, 37.84414], [-121.59164, 37.84485], [-121.5914, 37.84562], [-121.59176, 37.84608], [-121.592, 37.84684], [-121.59184, 37.84734], [-121.59107, 37.84797], [-121.59055, 37.84814], [-121.59054, 37.84838], [-121.5902, 37.84881], [-121.58979, 37.84904], [-121.58929, 37.84921], [-121.58897, 37.84925], [-121.58851, 37.84919], [-121.58805, 37.84896], [-121.58786, 37.84883], [-121.58727, 37.8488], [-121.58631, 37.84888], [-121.5852, 37.84904], [-121.58491, 37.84914], [-121.5849, 37.84975], [-121.58538, 37.84994], [-121.58533, 37.85066], [-121.58551, 37.8512], [-121.58601, 37.85189], [-121.58598, 37.85264], [-121.58555, 37.85313], [-121.58501, 37.85341], [-121.58502, 37.85346], [-121.5844, 37.85383], [-121.58409, 37.85522], [-121.58396, 37.85539], [-121.58346, 37.85618], [-121.58343, 37.85676], [-121.58347, 37.85742], [-121.58344, 37.85804], [-121.58332, 37.85835], [-121.58306, 37.85853], [-121.58233, 37.85875], [-121.58124, 37.85883], [-121.58047, 37.85883], [-121.58013, 37.85882], [-121.57969, 37.85865], [-121.5764, 37.8585], [-121.5764, 37.85848], [-121.5775, 37.85806], [-121.57724, 37.85739], [-121.57561, 37.85733], [-121.57328, 37.85701], [-121.56941, 37.85671], [-121.56829, 37.85672], [-121.56799, 37.85707], [-121.56788, 37.85681], [-121.56625, 37.85743], [-121.56515, 37.85624], [-121.56291, 37.85322], [-121.56211, 37.85322], [-121.55881, 37.8459], [-121.55961, 37.84589], [-121.553, 37.82898], [-121.55738, 37.82822], [-121.55891, 37.8263], [-121.56794, 37.82621], [-121.56796, 37.82531], [-121.57554, 37.82543], [-121.57738, 37.82369], [-121.58162, 37.82007], [-121.58339, 37.82005], [-121.58611, 37.82058], [-121.58617, 37.82384], [-121.58999, 37.82384], [-121.59262, 37.82531], [-121.59363, 37.82576], [-121.59479, 37.82384], [-121.59565, 37.82384], [-121.59568, 37.82497], [-121.59656, 37.82391], [-121.59727, 37.82435], [-121.59569, 37.82627], [-121.59571, 37.82748], [-121.59686, 37.82747], [-121.59659, 37.82758], [-121.59507, 37.8298], [-121.59535, 37.83007], [-121.59559, 37.83007], [-121.59881, 37.83171], [-121.59931, 37.83214], [-121.60036, 37.83424], [-121.60028, 37.83829]]]]} | Restricted Access 2 | 13126 | Clifton Court Forebay | 29182 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Contra Costa 12 | 3217.242 | Clifton Court Forebay | 0 | None 707 | ||
13162 | 13162 | 13161 | {"type": "Polygon", "coordinates": [[[-121.69523, 37.99864], [-121.69516, 37.99875], [-121.69492, 37.99898], [-121.69489, 37.99899], [-121.69479, 37.99908], [-121.6946, 37.99933], [-121.69451, 37.99949], [-121.69412, 38.00034], [-121.69357, 38.00137], [-121.69349, 38.00155], [-121.69341, 38.00178], [-121.69332, 38.00199], [-121.69256, 38.00334], [-121.69235, 38.00375], [-121.69214, 38.00408], [-121.69172, 38.00498], [-121.69157, 38.0052], [-121.6915, 38.00533], [-121.69134, 38.00615], [-121.6913, 38.00678], [-121.69131, 38.00698], [-121.69117, 38.00802], [-121.69114, 38.00835], [-121.69102, 38.00912], [-121.691, 38.00933], [-121.69101, 38.01008], [-121.69106, 38.01024], [-121.69104, 38.01035], [-121.69121, 38.01057], [-121.69102, 38.01082], [-121.69092, 38.01111], [-121.6909, 38.01129], [-121.69083, 38.01153], [-121.69057, 38.01169], [-121.69041, 38.01184], [-121.69042, 38.01202], [-121.69037, 38.01241], [-121.68974, 38.01329], [-121.68931, 38.01338], [-121.68885, 38.01329], [-121.68808, 38.0132], [-121.68616, 38.01353], [-121.68476, 38.01351], [-121.68233, 38.012], [-121.6797, 38.01151], [-121.6779, 38.01073], [-121.67466, 38.01191], [-121.67439, 38.01196], [-121.67438, 38.01228], [-121.66372, 38.01239], [-121.66372, 38.01234], [-121.66361, 38.01228], [-121.66332, 38.01219], [-121.66305, 38.01222], [-121.66269, 38.0124], [-121.66098, 38.01241], [-121.66075, 38.01191], [-121.66066, 38.01164], [-121.6605, 38.0114], [-121.65932, 38.0089], [-121.65922, 38.00863], [-121.65914, 38.00835], [-121.65911, 38.00795], [-121.65919, 37.99845], [-121.66012, 37.99845], [-121.66014, 37.99791], [-121.66013, 37.9979], [-121.6592, 37.9979], [-121.65925, 37.99124], [-121.66028, 37.99208], [-121.66047, 37.99221], [-121.66068, 37.99233], [-121.6609, 37.99243], [-121.66357, 37.99352], [-121.66415, 37.99377], [-121.67363, 37.99756], [-121.67366, 37.99754], [-121.67405, 37.99767], [-121.67431, 37.99772], [-121.67459, 37.99775], [-121.6759, 37.99776], [-121.67585, 37.99946], [-121.67687, 38.0005], [-121.67805, 38.00051], [-121.67798, 38.00067], [-121.67805, 38.00087], [-121.67806, 38.00179], [-121.67966, 38.00179], [-121.67966, 38.00051], [-121.68253, 38.00051], [-121.68379, 38.0001], [-121.68381, 37.99788], [-121.68397, 37.99792], [-121.6859, 37.99855], [-121.6862, 37.99862], [-121.68641, 37.99865], [-121.68662, 37.99866], [-121.69523, 37.99864]]]} | No Public Access 3 | 35110 | Dutch Slough | 18320 | 207 | California Department of Water Resources 477 | State 5 | State Agency 5 | http://www.water.ca.gov/ | Other State 5 | 207 | California Department of Water Resources 470 | State 5 | State Agency 5 | Contra Costa 12 | 1185.171 | Dutch Slough | 0 | State Conservation Area 8 | 2 | |
16588 | 16588 | 16587 | {"type": "Polygon", "coordinates": [[[-122.08502, 38.04767], [-122.08408, 38.04783], [-122.08258, 38.04779], [-122.08257, 38.0478], [-122.08277, 38.048], [-122.08063, 38.04867], [-122.08033, 38.04836], [-122.07995, 38.04829], [-122.07934, 38.04871], [-122.07613, 38.04893], [-122.07593, 38.04866], [-122.07562, 38.04889], [-122.07444, 38.04899], [-122.07363, 38.04926], [-122.07293, 38.04945], [-122.07168, 38.05038], [-122.07142, 38.05098], [-122.07146, 38.05109], [-122.07226, 38.05157], [-122.07223, 38.05179], [-122.07158, 38.05184], [-122.07135, 38.05202], [-122.0715, 38.05227], [-122.07133, 38.05262], [-122.07098, 38.0527], [-122.07105, 38.05304], [-122.07066, 38.05347], [-122.07052, 38.05352], [-122.07034, 38.05351], [-122.06961, 38.05324], [-122.06941, 38.05294], [-122.06871, 38.05258], [-122.06851, 38.0523], [-122.06696, 38.05237], [-122.0668, 38.05227], [-122.06662, 38.05251], [-122.0662, 38.05266], [-122.06621, 38.0528], [-122.06593, 38.05282], [-122.06539, 38.05309], [-122.05623, 38.03898], [-122.05668, 38.03862], [-122.0702, 38.03475], [-122.07035, 38.03502], [-122.07606, 38.0387], [-122.07679, 38.03882], [-122.08121, 38.04194], [-122.08247, 38.04615], [-122.08282, 38.04611], [-122.08283, 38.04609], [-122.0817, 38.04174], [-122.08277, 38.04078], [-122.08346, 38.04144], [-122.08338, 38.04163], [-122.08502, 38.04767]]]} | Open Access 1 | 25330 | Point Edith Wildlife Area | 30488 | 209 | California State Lands Commission 75 | State 5 | State Agency 5 | http://www.slc.ca.gov/ | Other State 5 | 201 | California Department of Fish and Wildlife 25 | State 5 | State Agency 5 | Contra Costa 12 | 727.388 | Point Edith Wildlife Area | 1985 | 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]);