calands: units_with_maps: 1 row where DES_TP = 3, MNG_AGENCY = 9, MNG_AG_TYP = 2 and UNIT

Data license: Creative Commons Attribution · Data source: GreenInfo Network · About: simonw/calands-datasette

1 row where DES_TP = 3, MNG_AGENCY = 9, MNG_AG_TYP = 2 and UNIT_NAME = "Loch Lomond Recreation Area"

Search:

descending

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
16818	16818	16817	{"type": "MultiPolygon", "coordinates": [[[[-122.07938, 37.14744], [-122.06947, 37.14599], [-122.06911, 37.15298], [-122.06408, 37.15222], [-122.0643, 37.14878], [-122.05837, 37.14791], [-122.05856, 37.14212], [-122.04923, 37.14199], [-122.04922, 37.13494], [-122.04443, 37.13491], [-122.04443, 37.13153], [-122.0472, 37.13152], [-122.04715, 37.12854], [-122.04839, 37.12795], [-122.04892, 37.12795], [-122.05068, 37.12688], [-122.05061, 37.12666], [-122.05079, 37.12617], [-122.05058, 37.12595], [-122.0507, 37.12554], [-122.05097, 37.12503], [-122.05105, 37.12409], [-122.05112, 37.12374], [-122.05278, 37.12368], [-122.05271, 37.12226], [-122.05301, 37.12224], [-122.05292, 37.12039], [-122.05395, 37.12042], [-122.05399, 37.11904], [-122.05415, 37.11905], [-122.05416, 37.11879], [-122.05399, 37.11877], [-122.05401, 37.11818], [-122.05523, 37.11827], [-122.05524, 37.11854], [-122.05531, 37.11854], [-122.05532, 37.11828], [-122.05646, 37.11837], [-122.05642, 37.12031], [-122.05648, 37.12031], [-122.05652, 37.11837], [-122.05897, 37.11854], [-122.05896, 37.1185], [-122.05653, 37.11832], [-122.05657, 37.11663], [-122.05663, 37.11666], [-122.0568, 37.1166], [-122.05713, 37.11672], [-122.05745, 37.11657], [-122.0578, 37.11657], [-122.058, 37.11681], [-122.05806, 37.11677], [-122.05807, 37.11671], [-122.05904, 37.11679], [-122.05905, 37.11673], [-122.058, 37.11665], [-122.05799, 37.1167], [-122.05782, 37.11652], [-122.05742, 37.11652], [-122.05712, 37.11666], [-122.0568, 37.11655], [-122.05663, 37.1166], [-122.05656, 37.11656], [-122.05657, 37.11649], [-122.05664, 37.11637], [-122.05682, 37.11638], [-122.05698, 37.11633], [-122.05708, 37.11578], [-122.057, 37.11567], [-122.05719, 37.11544], [-122.05713, 37.11538], [-122.05694, 37.11529], [-122.05688, 37.11504], [-122.05707, 37.1149], [-122.05712, 37.11484], [-122.05912, 37.11499], [-122.05913, 37.11493], [-122.05516, 37.11466], [-122.05518, 37.11345], [-122.05542, 37.11346], [-122.05541, 37.11315], [-122.05501, 37.11315], [-122.05501, 37.11343], [-122.05511, 37.11344], [-122.05511, 37.1135], [-122.05485, 37.11349], [-122.05484, 37.11377], [-122.05476, 37.11377], [-122.05476, 37.11404], [-122.0551, 37.11406], [-122.0551, 37.11466], [-122.05426, 37.11461], [-122.05426, 37.11435], [-122.05418, 37.11434], [-122.05417, 37.11435], [-122.05417, 37.1146], [-122.05358, 37.11458], [-122.05357, 37.11432], [-122.05342, 37.1143], [-122.05341, 37.11431], [-122.05341, 37.11457], [-122.05238, 37.11453], [-122.05238, 37.11427], [-122.05323, 37.1143], [-122.05324, 37.11429], [-122.05323, 37.11403], [-122.05238, 37.114], [-122.05238, 37.11394], [-122.05271, 37.11396], [-122.05272, 37.11395], [-122.05272, 37.11342], [-122.05238, 37.1134], [-122.05238, 37.11307], [-122.05366, 37.11311], [-122.05367, 37.11338], [-122.05374, 37.11339], [-122.05375, 37.11312], [-122.0541, 37.11312], [-122.05417, 37.10961], [-122.05334, 37.10957], [-122.05331, 37.10702], [-122.05339, 37.10701], [-122.05351, 37.10712], [-122.05357, 37.10703], [-122.05391, 37.10702], [-122.05406, 37.10709], [-122.05448, 37.10714], [-122.05457, 37.10721], [-122.05505, 37.10734], [-122.05508, 37.1074], [-122.05505, 37.10747], [-122.05511, 37.10753], [-122.05524, 37.10752], [-122.05538, 37.10788], [-122.05545, 37.10854], [-122.05578, 37.10851], [-122.0559, 37.10848], [-122.05693, 37.10805], [-122.05703, 37.10807], [-122.05711, 37.10855], [-122.05726, 37.10852], [-122.0576, 37.10855], [-122.0578, 37.1086], [-122.05811, 37.1086], [-122.05846, 37.1085], [-122.05869, 37.1085], [-122.05907, 37.10835], [-122.05907, 37.10799], [-122.05921, 37.10798], [-122.05921, 37.1079], [-122.05906, 37.1079], [-122.05901, 37.10626], [-122.06395, 37.10605], [-122.06392, 37.10425], [-122.0685, 37.10409], [-122.0684, 37.09891], [-122.07235, 37.099], [-122.07267, 37.09665], [-122.07269, 37.09665], [-122.07272, 37.09691], [-122.07282, 37.09716], [-122.07478, 37.09905], [-122.07508, 37.09905], [-122.07663, 37.09894], [-122.07812, 37.09894], [-122.078, 37.10547], [-122.07788, 37.10823], [-122.07771, 37.1132], [-122.07772, 37.11429], [-122.07823, 37.1146], [-122.0789, 37.11508], [-122.07926, 37.1153], [-122.0796, 37.11557], [-122.07988, 37.11582], [-122.08, 37.11596], [-122.08008, 37.11603], [-122.08019, 37.11619], [-122.08026, 37.11635], [-122.08027, 37.11648], [-122.08021, 37.11801], [-122.08016, 37.11822], [-122.07992, 37.11849], [-122.07969, 37.11865], [-122.07946, 37.11885], [-122.0788, 37.11928], [-122.07852, 37.11944], [-122.07815, 37.11962], [-122.07774, 37.11979], [-122.07775, 37.12188], [-122.07805, 37.125], [-122.07836, 37.12906], [-122.07835, 37.12907], [-122.07953, 37.14382], [-122.07938, 37.14744]], [[-122.05315, 37.1137], [-122.05306, 37.1137], [-122.05307, 37.11397], [-122.05315, 37.11396], [-122.05315, 37.1137]], [[-122.05376, 37.11345], [-122.05375, 37.11346], [-122.05376, 37.11371], [-122.05425, 37.11373], [-122.05425, 37.11347], [-122.05376, 37.11345]], [[-122.05443, 37.11408], [-122.05442, 37.11409], [-122.05442, 37.11434], [-122.05459, 37.11436], [-122.05459, 37.11409], [-122.05443, 37.11408]], [[-122.0552, 37.11998], [-122.05536, 37.11999], [-122.05536, 37.11973], [-122.0552, 37.11972], [-122.0552, 37.11998]], [[-122.05582, 37.11381], [-122.05591, 37.11382], [-122.0559, 37.11355], [-122.05583, 37.11356], [-122.05582, 37.11381]], [[-122.05644, 37.11365], [-122.05654, 37.11379], [-122.05655, 37.11379], [-122.05656, 37.1136], [-122.05646, 37.11359], [-122.05644, 37.11365]], [[-122.0585, 37.11608], [-122.05858, 37.11608], [-122.05859, 37.11582], [-122.05843, 37.1158], [-122.05842, 37.11607], [-122.0585, 37.11608]]], [[[-122.05711, 37.11544], [-122.05692, 37.11567], [-122.05701, 37.11577], [-122.05693, 37.11629], [-122.05683, 37.11632], [-122.05662, 37.11631], [-122.05651, 37.11647], [-122.05651, 37.11653], [-122.05531, 37.11643], [-122.05531, 37.11619], [-122.0554, 37.11619], [-122.0554, 37.11594], [-122.05523, 37.11592], [-122.05514, 37.11592], [-122.05513, 37.11617], [-122.05523, 37.11619], [-122.05523, 37.11643], [-122.05475, 37.11639], [-122.05475, 37.11617], [-122.0546, 37.11615], [-122.05459, 37.11616], [-122.05459, 37.11638], [-122.05407, 37.11634], [-122.05253, 37.11631], [-122.05253, 37.11604], [-122.05235, 37.11603], [-122.05238, 37.11459], [-122.05408, 37.11465], [-122.05565, 37.11475], [-122.05565, 37.11502], [-122.05588, 37.11504], [-122.05589, 37.11503], [-122.05589, 37.11477], [-122.05703, 37.11484], [-122.0568, 37.11503], [-122.05687, 37.11533], [-122.05711, 37.11544]], [[-122.05279, 37.11516], [-122.0528, 37.11515], [-122.0528, 37.11488], [-122.05255, 37.11487], [-122.05254, 37.11514], [-122.05279, 37.11516]], [[-122.05304, 37.11575], [-122.05305, 37.11549], [-122.05288, 37.11548], [-122.05288, 37.11574], [-122.05304, 37.11575]], [[-122.05355, 37.11578], [-122.05356, 37.11577], [-122.05356, 37.11551], [-122.05339, 37.1155], [-122.05339, 37.11576], [-122.05355, 37.11578]], [[-122.05389, 37.11579], [-122.0539, 37.11578], [-122.0539, 37.11552], [-122.05374, 37.11552], [-122.05373, 37.11578], [-122.05389, 37.11579]], [[-122.05492, 37.11525], [-122.05493, 37.11524], [-122.05494, 37.11499], [-122.05486, 37.11498], [-122.05485, 37.11524], [-122.05492, 37.11525]]], [[[-122.05651, 37.11658], [-122.05646, 37.11831], [-122.05542, 37.11823], [-122.05542, 37.11797], [-122.05525, 37.11796], [-122.05508, 37.11795], [-122.05507, 37.11821], [-122.05401, 37.11813], [-122.05405, 37.11639], [-122.05529, 37.11649], [-122.05529, 37.11676], [-122.05545, 37.11677], [-122.05546, 37.1165], [-122.05555, 37.11651], [-122.05554, 37.11678], [-122.0557, 37.1168], [-122.0557, 37.11706], [-122.05586, 37.11706], [-122.05587, 37.11681], [-122.05611, 37.11682], [-122.05612, 37.11655], [-122.05651, 37.11658]]], [[[-122.0638, 37.16392], [-122.05802, 37.16311], [-122.05813, 37.1583], [-122.06373, 37.15932], [-122.0638, 37.16392]]]]}	Open Access 1	17380	Loch Lomond Recreation Area	12033	1320	Santa Cruz, City of 9	City 2	City Agency 2	http://www.cityofsantacruz.com/departments/parks-recreation	City 2	1320	Santa Cruz, City of 9	City 2	City Agency 2	http://www.cityofsantacruz.com/departments/water/recreation	Santa Cruz 5	2988.434	Loch Lomond Rec. Area	0	Local Recreation Area 3	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]);