units_with_maps
Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette
2 rows where COUNTY = 3 and MNG_AGENCY = 51
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7999 | 7999 | 7998 | {"type": "Polygon", "coordinates": [[[-117.85797, 33.6566], [-117.85687, 33.66016], [-117.85439, 33.66093], [-117.85304, 33.66254], [-117.85132, 33.66388], [-117.85077, 33.6635], [-117.85031, 33.66313], [-117.85005, 33.66289], [-117.84982, 33.66264], [-117.84939, 33.6621], [-117.84905, 33.66153], [-117.84883, 33.66102], [-117.84833, 33.65945], [-117.85104, 33.6568], [-117.84759, 33.65285], [-117.8483, 33.65243], [-117.84904, 33.65207], [-117.8495, 33.65186], [-117.85028, 33.65158], [-117.85094, 33.65138], [-117.85193, 33.65114], [-117.85261, 33.65103], [-117.85295, 33.65099], [-117.85572, 33.65361], [-117.85656, 33.65519], [-117.85797, 33.6566]]]} | Restricted Access 2 | 11237 | San Joaquin Marsh Reserve | 33193 | 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 | https://ucnrs.org/reserves/san-joaquin-marsh-reserve/ | Orange 3 | 198.279 | San Joaquin Marsh Reserve | 0 | State Conservation Area 8 | 2 |
| 15956 | 15956 | 15955 | {"type": "MultiPolygon", "coordinates": [[[[-117.84938, 33.6336], [-117.84896, 33.63375], [-117.84877, 33.63393], [-117.84868, 33.63406], [-117.84856, 33.63438], [-117.84843, 33.63446], [-117.84825, 33.63464], [-117.84802, 33.63476], [-117.84778, 33.63508], [-117.8471, 33.63637], [-117.84698, 33.63681], [-117.8468, 33.63794], [-117.84679, 33.63855], [-117.84675, 33.63878], [-117.84668, 33.63946], [-117.84657, 33.64131], [-117.84614, 33.6414], [-117.84598, 33.64145], [-117.84563, 33.64148], [-117.84524, 33.64145], [-117.84426, 33.64157], [-117.84389, 33.64167], [-117.84323, 33.64196], [-117.84338, 33.64163], [-117.84341, 33.64147], [-117.8437, 33.64134], [-117.84361, 33.64116], [-117.84375, 33.64108], [-117.84391, 33.64068], [-117.84403, 33.64028], [-117.84419, 33.63997], [-117.84442, 33.63969], [-117.84465, 33.63918], [-117.84505, 33.63843], [-117.84589, 33.63672], [-117.8455, 33.6364], [-117.84538, 33.63625], [-117.84528, 33.63604], [-117.84469, 33.63555], [-117.84475, 33.63549], [-117.84483, 33.6353], [-117.84484, 33.63475], [-117.84469, 33.63369], [-117.84439, 33.63309], [-117.84426, 33.63301], [-117.84406, 33.63299], [-117.84355, 33.63286], [-117.8429, 33.6324], [-117.84236, 33.63212], [-117.84201, 33.63176], [-117.84219, 33.63164], [-117.84408, 33.63207], [-117.84424, 33.63206], [-117.84428, 33.632], [-117.84479, 33.63213], [-117.84512, 33.63222], [-117.84534, 33.63233], [-117.84606, 33.6325], [-117.84646, 33.63263], [-117.84696, 33.63287], [-117.84718, 33.63294], [-117.84757, 33.63323], [-117.84777, 33.6333], [-117.84832, 33.63331], [-117.84883, 33.63335], [-117.84896, 33.6334], [-117.84895, 33.63345], [-117.84938, 33.6336]]], [[[-117.8551, 33.63794], [-117.85475, 33.63824], [-117.85449, 33.63843], [-117.85462, 33.63811], [-117.85467, 33.63797], [-117.8547, 33.63782], [-117.85469, 33.63758], [-117.85459, 33.63747], [-117.85451, 33.63744], [-117.85426, 33.63722], [-117.85418, 33.63704], [-117.85396, 33.63684], [-117.85368, 33.63669], [-117.85336, 33.63648], [-117.8531, 33.63611], [-117.85277, 33.63603], [-117.8526, 33.63607], [-117.85241, 33.63616], [-117.85222, 33.6363], [-117.85198, 33.6366], [-117.85182, 33.63674], [-117.85166, 33.63682], [-117.85154, 33.63694], [-117.8514, 33.63729], [-117.85131, 33.63741], [-117.85098, 33.6374], [-117.85088, 33.63733], [-117.85086, 33.63724], [-117.8509, 33.63719], [-117.85095, 33.63711], [-117.85114, 33.63695], [-117.8512, 33.63686], [-117.85137, 33.63645], [-117.85161, 33.63616], [-117.85164, 33.63607], [-117.85163, 33.63553], [-117.85159, 33.63535], [-117.85149, 33.63517], [-117.85133, 33.63499], [-117.85078, 33.63453], [-117.85025, 33.63404], [-117.85089, 33.63438], [-117.85227, 33.63535], [-117.85341, 33.63625], [-117.85353, 33.63636], [-117.85349, 33.6364], [-117.85389, 33.6367], [-117.85425, 33.63705], [-117.8544, 33.63723], [-117.8551, 33.63786], [-117.8551, 33.63794]]], [[[-117.85959, 33.64745], [-117.85951, 33.64768], [-117.85942, 33.64783], [-117.85933, 33.64794], [-117.85912, 33.64808], [-117.8588, 33.64825], [-117.85867, 33.64839], [-117.85857, 33.64864], [-117.85845, 33.64914], [-117.85843, 33.64948], [-117.85845, 33.64989], [-117.85811, 33.64992], [-117.85808, 33.64948], [-117.85805, 33.64941], [-117.85812, 33.64907], [-117.85843, 33.64823], [-117.85844, 33.6481], [-117.85843, 33.64771], [-117.85846, 33.64718], [-117.8585, 33.64714], [-117.85854, 33.64704], [-117.85915, 33.64718], [-117.85921, 33.64711], [-117.85926, 33.64697], [-117.85928, 33.64682], [-117.85927, 33.64667], [-117.85919, 33.64615], [-117.85903, 33.64548], [-117.85893, 33.64512], [-117.85871, 33.64449], [-117.8584, 33.64387], [-117.85829, 33.64377], [-117.85771, 33.64334], [-117.85771, 33.64328], [-117.85774, 33.64325], [-117.85788, 33.64321], [-117.858, 33.64311], [-117.85804, 33.64304], [-117.85805, 33.64293], [-117.8579, 33.64259], [-117.85776, 33.6423], [-117.85768, 33.64208], [-117.85745, 33.64163], [-117.85735, 33.64136], [-117.85732, 33.6412], [-117.85729, 33.64119], [-117.85723, 33.64121], [-117.85707, 33.64124], [-117.85648, 33.64124], [-117.85641, 33.64118], [-117.85639, 33.64109], [-117.85654, 33.64107], [-117.85691, 33.64047], [-117.85694, 33.64031], [-117.85689, 33.64], [-117.85673, 33.63954], [-117.85635, 33.63896], [-117.856, 33.6387], [-117.85571, 33.63855], [-117.85535, 33.6385], [-117.85478, 33.63856], [-117.85527, 33.63819], [-117.85542, 33.63837], [-117.85555, 33.63829], [-117.85566, 33.63833], [-117.85675, 33.63929], [-117.85687, 33.63944], [-117.85691, 33.63959], [-117.85692, 33.63967], [-117.85728, 33.64001], [-117.85723, 33.64005], [-117.85732, 33.64048], [-117.85752, 33.64087], [-117.85773, 33.6415], [-117.85783, 33.64175], [-117.85805, 33.64224], [-117.8584, 33.64296], [-117.8584, 33.64298], [-117.85841, 33.64302], [-117.85844, 33.64304], [-117.85856, 33.64336], [-117.85873, 33.64373], [-117.85866, 33.64382], [-117.85868, 33.64387], [-117.85882, 33.64392], [-117.85914, 33.64463], [-117.85924, 33.64491], [-117.85952, 33.64609], [-117.85964, 33.64685], [-117.85965, 33.64701], [-117.85964, 33.64712], [-117.85961, 33.64728], [-117.85954, 33.64751], [-117.85955, 33.64751], [-117.85959, 33.64745]]]]} | Open Access 1 | 14876 | University of California, Irvine Open Space Reserve | 26683 | 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 | Orange 3 | 81.364 | University of California, Irvine OSR | 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]);