calands: units_with_maps: 1 row where ACCESS_TYP = 1 and DES

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

1 row where ACCESS_TYP = 1 and DES_TP = 820

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
9639	9639	9638	{"type": "MultiPolygon", "coordinates": [[[[-122.4862, 37.9463], [-122.4862, 37.94753], [-122.48584, 37.94754], [-122.48583, 37.94654], [-122.48362, 37.94655], [-122.48363, 37.94541], [-122.48389, 37.94543], [-122.48389, 37.94557], [-122.48418, 37.94559], [-122.48418, 37.94584], [-122.48414, 37.94585], [-122.48414, 37.94608], [-122.48406, 37.94608], [-122.48406, 37.94617], [-122.48445, 37.94617], [-122.48446, 37.94614], [-122.48458, 37.94614], [-122.48459, 37.94612], [-122.48479, 37.94611], [-122.4848, 37.94608], [-122.48518, 37.94608], [-122.4852, 37.94616], [-122.48572, 37.94616], [-122.48572, 37.9462], [-122.48576, 37.94621], [-122.48577, 37.94625], [-122.48604, 37.94625], [-122.48605, 37.94628], [-122.48612, 37.94628], [-122.48613, 37.94631], [-122.4862, 37.9463]]], [[[-122.48745, 37.94767], [-122.4871, 37.94768], [-122.48704, 37.94751], [-122.48707, 37.9475], [-122.48699, 37.94727], [-122.48685, 37.94707], [-122.4867, 37.94694], [-122.48669, 37.94681], [-122.48652, 37.94655], [-122.48667, 37.94645], [-122.48707, 37.94645], [-122.48713, 37.94651], [-122.48743, 37.9466], [-122.48744, 37.94665], [-122.4874, 37.94684], [-122.48741, 37.94694], [-122.48744, 37.94704], [-122.48756, 37.9472], [-122.48776, 37.94734], [-122.4878, 37.94743], [-122.48778, 37.94749], [-122.4877, 37.94755], [-122.48742, 37.94757], [-122.48745, 37.94767]]], [[[-122.49589, 37.95147], [-122.49439, 37.95243], [-122.49478, 37.95363], [-122.4948, 37.95379], [-122.49476, 37.95399], [-122.49495, 37.95406], [-122.49506, 37.95413], [-122.49515, 37.95422], [-122.49521, 37.95432], [-122.4957, 37.95574], [-122.49571, 37.95582], [-122.49571, 37.95597], [-122.49566, 37.9561], [-122.49562, 37.95617], [-122.49503, 37.95674], [-122.49473, 37.95693], [-122.49457, 37.957], [-122.49446, 37.95703], [-122.49435, 37.95704], [-122.49413, 37.95703], [-122.49393, 37.95699], [-122.49378, 37.95694], [-122.49353, 37.9568], [-122.49333, 37.95663], [-122.49317, 37.95638], [-122.49297, 37.95594], [-122.48931, 37.95668], [-122.48776, 37.95194], [-122.48783, 37.95198], [-122.48784, 37.95197], [-122.48783, 37.95194], [-122.48787, 37.95196], [-122.48788, 37.95196], [-122.48702, 37.94932], [-122.48787, 37.94932], [-122.48797, 37.94951], [-122.48814, 37.94951], [-122.48831, 37.94956], [-122.48879, 37.94949], [-122.48842, 37.94835], [-122.48911, 37.94821], [-122.48918, 37.94814], [-122.48984, 37.94854], [-122.48995, 37.94842], [-122.48991, 37.94832], [-122.48992, 37.94825], [-122.48999, 37.94817], [-122.48992, 37.94811], [-122.48996, 37.94807], [-122.49028, 37.94827], [-122.49043, 37.94838], [-122.49089, 37.9488], [-122.4906, 37.94915], [-122.49045, 37.94927], [-122.49037, 37.94935], [-122.49031, 37.94944], [-122.49021, 37.94969], [-122.49012, 37.94977], [-122.48982, 37.94984], [-122.48959, 37.94988], [-122.4892, 37.9501], [-122.48863, 37.95007], [-122.4885, 37.95008], [-122.48847, 37.95013], [-122.48857, 37.95031], [-122.48861, 37.95035], [-122.4887, 37.95038], [-122.48887, 37.9504], [-122.48923, 37.95036], [-122.48934, 37.95039], [-122.48944, 37.9505], [-122.48948, 37.95058], [-122.48949, 37.95066], [-122.48958, 37.95076], [-122.48961, 37.95081], [-122.48968, 37.95113], [-122.48965, 37.95123], [-122.4896, 37.95129], [-122.48954, 37.95132], [-122.4893, 37.95137], [-122.48912, 37.95151], [-122.48897, 37.95158], [-122.48888, 37.95165], [-122.48883, 37.95171], [-122.48881, 37.95177], [-122.48881, 37.95185], [-122.48884, 37.95191], [-122.48902, 37.95185], [-122.48881, 37.952], [-122.49019, 37.95326], [-122.49014, 37.9534], [-122.49014, 37.95352], [-122.48932, 37.95369], [-122.48969, 37.95484], [-122.48973, 37.95514], [-122.48991, 37.95576], [-122.49023, 37.95641], [-122.49295, 37.95586], [-122.49257, 37.95465], [-122.49256, 37.95452], [-122.49257, 37.95439], [-122.49261, 37.95426], [-122.4927, 37.95411], [-122.49283, 37.95397], [-122.493, 37.95385], [-122.49319, 37.95377], [-122.49341, 37.95372], [-122.49372, 37.95371], [-122.49392, 37.95374], [-122.4943, 37.95385], [-122.49433, 37.95379], [-122.49435, 37.95366], [-122.49391, 37.9523], [-122.49561, 37.95121], [-122.49564, 37.95124], [-122.49552, 37.95133], [-122.49558, 37.9514], [-122.49564, 37.95137], [-122.49571, 37.95143], [-122.49579, 37.95137], [-122.49589, 37.95147]]], [[[-122.49385, 37.96635], [-122.49304, 37.96873], [-122.48848, 37.96873], [-122.48836, 37.96425], [-122.48978, 37.96425], [-122.48983, 37.96451], [-122.48987, 37.96463], [-122.49001, 37.96487], [-122.49009, 37.96498], [-122.49025, 37.96515], [-122.4904, 37.96527], [-122.49065, 37.96543], [-122.49095, 37.96555], [-122.4911, 37.96559], [-122.49116, 37.96561], [-122.49119, 37.96555], [-122.49385, 37.96635]]], [[[-122.49634, 37.9633], [-122.49613, 37.96323], [-122.49605, 37.96343], [-122.49596, 37.96355], [-122.49586, 37.96363], [-122.4957, 37.96369], [-122.49556, 37.9637], [-122.49542, 37.96369], [-122.49503, 37.96353], [-122.49488, 37.96351], [-122.49467, 37.9635], [-122.49445, 37.96353], [-122.49432, 37.96357], [-122.49407, 37.9637], [-122.49394, 37.96374], [-122.4937, 37.96377], [-122.49357, 37.96375], [-122.49342, 37.96369], [-122.49314, 37.9635], [-122.49286, 37.96337], [-122.492, 37.96306], [-122.49196, 37.96302], [-122.49194, 37.96297], [-122.49196, 37.96289], [-122.49216, 37.96274], [-122.49228, 37.96262], [-122.49241, 37.96241], [-122.49246, 37.96226], [-122.49247, 37.96211], [-122.49245, 37.96195], [-122.4924, 37.96181], [-122.49228, 37.96161], [-122.49226, 37.96153], [-122.49228, 37.96146], [-122.49233, 37.96139], [-122.4924, 37.96134], [-122.49252, 37.9613], [-122.49263, 37.96129], [-122.49275, 37.9613], [-122.49296, 37.96138], [-122.49314, 37.96142], [-122.4938, 37.96145], [-122.49396, 37.96144], [-122.49411, 37.9614], [-122.4942, 37.96135], [-122.49491, 37.96088], [-122.49507, 37.96085], [-122.49527, 37.96089], [-122.49536, 37.96094], [-122.49544, 37.96102], [-122.49549, 37.96114], [-122.49549, 37.96131], [-122.49557, 37.96133], [-122.49555, 37.96141], [-122.49531, 37.96194], [-122.49526, 37.96219], [-122.49528, 37.96234], [-122.49534, 37.96243], [-122.49542, 37.96251], [-122.49604, 37.96287], [-122.49613, 37.96294], [-122.49621, 37.96302], [-122.49632, 37.96317], [-122.49634, 37.9633]]], [[[-122.4922, 37.94968], [-122.49213, 37.94969], [-122.49207, 37.94967], [-122.49214, 37.94963], [-122.4922, 37.94968]]], [[[-122.49868, 37.96085], [-122.49843, 37.96137], [-122.49834, 37.96145], [-122.49831, 37.96155], [-122.49799, 37.96139], [-122.49769, 37.96116], [-122.49747, 37.96093], [-122.49727, 37.96062], [-122.49701, 37.96038], [-122.49686, 37.96027], [-122.4967, 37.96018], [-122.49638, 37.96004], [-122.49574, 37.95984], [-122.4981, 37.95948], [-122.49837, 37.95951], [-122.4981, 37.959], [-122.49756, 37.95669], [-122.49808, 37.95719], [-122.49842, 37.95912], [-122.49837, 37.95952], [-122.49835, 37.96075], [-122.49868, 37.96085]]], [[[-122.49782, 37.96376], [-122.49738, 37.96507], [-122.49675, 37.96695], [-122.49671, 37.96693], [-122.49684, 37.96652], [-122.49669, 37.96633], [-122.49673, 37.96623], [-122.49659, 37.96607], [-122.49665, 37.96601], [-122.49665, 37.96595], [-122.49682, 37.96592], [-122.49693, 37.96568], [-122.49686, 37.96565], [-122.49697, 37.96544], [-122.49705, 37.96543], [-122.4971, 37.96537], [-122.4971, 37.9653], [-122.49705, 37.96526], [-122.49716, 37.96502], [-122.49714, 37.965], [-122.49723, 37.96479], [-122.49728, 37.96477], [-122.49732, 37.96471], [-122.49731, 37.96465], [-122.49727, 37.96462], [-122.49711, 37.96456], [-122.49715, 37.96445], [-122.49729, 37.96448], [-122.4973, 37.96441], [-122.49742, 37.9641], [-122.49749, 37.96409], [-122.49755, 37.96403], [-122.49756, 37.96399], [-122.49755, 37.96395], [-122.49748, 37.9639], [-122.49758, 37.96368], [-122.49782, 37.96376]]]]}	Open Access 1	16221	San Rafael Lands 007	24978	1312	San Rafael, City of 352	City 2	City Agency 2	http://www.cityofsanrafael.org/comsvcs-home/	City 2	1312	San Rafael, City of 349	City 2	City Agency 2		Marin 23	129.981	San Rafael Lands 007		None 820

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]);