calands: units_with_maps: 1 row where ACCESS_TYP = 1, LAYER = 4 and MNG

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

1 row where ACCESS_TYP = 1, LAYER = 4 and MNG_AGENCY = 859

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
11543	11543	11542	{"type": "MultiPolygon", "coordinates": [[[[-116.75415, 33.11659], [-116.74551, 33.11663], [-116.74542, 33.11289], [-116.7368, 33.11289], [-116.73672, 33.10922], [-116.74108, 33.10916], [-116.75405, 33.10902], [-116.75415, 33.11659]]], [[[-117.06775, 33.06646], [-117.06716, 33.06725], [-117.06706, 33.06737], [-117.06694, 33.06746], [-117.06674, 33.06757], [-117.06659, 33.06761], [-117.06614, 33.06765], [-117.06615, 33.06699], [-117.06613, 33.06643], [-117.06607, 33.06616], [-117.06632, 33.0655], [-117.06657, 33.06554], [-117.06673, 33.06562], [-117.06685, 33.06575], [-117.06695, 33.066], [-117.06705, 33.0661], [-117.06732, 33.06576], [-117.06738, 33.06579], [-117.06712, 33.06613], [-117.06775, 33.06646]]], [[[-117.10005, 33.06801], [-117.10004, 33.0681], [-117.09918, 33.06793], [-117.09753, 33.06784], [-117.09802, 33.06603], [-117.09804, 33.06572], [-117.09794, 33.06545], [-117.09654, 33.06581], [-117.09615, 33.06577], [-117.09574, 33.06582], [-117.09543, 33.06595], [-117.09509, 33.06631], [-117.09347, 33.06618], [-117.09347, 33.06612], [-117.08976, 33.06581], [-117.08969, 33.06653], [-117.08962, 33.067], [-117.08943, 33.06903], [-117.08916, 33.07157], [-117.08882, 33.07154], [-117.08889, 33.07095], [-117.08854, 33.07087], [-117.08821, 33.07118], [-117.08815, 33.07128], [-117.08807, 33.07148], [-117.08524, 33.07125], [-117.08536, 33.07057], [-117.08613, 33.07024], [-117.08581, 33.06924], [-117.08589, 33.06833], [-117.08632, 33.06777], [-117.08753, 33.06777], [-117.08762, 33.06754], [-117.08779, 33.06623], [-117.0888, 33.0652], [-117.08987, 33.06472], [-117.09055, 33.05824], [-117.09085, 33.05853], [-117.09103, 33.05874], [-117.09121, 33.05888], [-117.09135, 33.05904], [-117.09166, 33.05919], [-117.09172, 33.05933], [-117.09174, 33.05947], [-117.09168, 33.05958], [-117.09165, 33.05978], [-117.09184, 33.05974], [-117.09202, 33.05974], [-117.09213, 33.05976], [-117.09228, 33.05987], [-117.09235, 33.06], [-117.09239, 33.06006], [-117.0926, 33.06017], [-117.09276, 33.06029], [-117.09296, 33.06034], [-117.09301, 33.06038], [-117.09333, 33.06052], [-117.09392, 33.06053], [-117.09428, 33.06063], [-117.09463, 33.06078], [-117.09508, 33.06103], [-117.09529, 33.0611], [-117.09542, 33.06115], [-117.09562, 33.0613], [-117.09573, 33.06147], [-117.09574, 33.06156], [-117.0957, 33.06166], [-117.09562, 33.06174], [-117.09547, 33.06184], [-117.09542, 33.06191], [-117.09538, 33.06199], [-117.09537, 33.0621], [-117.09538, 33.06216], [-117.09548, 33.06228], [-117.09549, 33.06242], [-117.09547, 33.06251], [-117.09535, 33.06269], [-117.09535, 33.06283], [-117.09531, 33.06299], [-117.09522, 33.06312], [-117.09503, 33.06331], [-117.09488, 33.06337], [-117.09466, 33.06338], [-117.09466, 33.06342], [-117.09476, 33.06346], [-117.09479, 33.0635], [-117.09478, 33.06355], [-117.09473, 33.06365], [-117.09478, 33.06366], [-117.09495, 33.06356], [-117.09516, 33.06349], [-117.09559, 33.06346], [-117.09593, 33.06338], [-117.09621, 33.06337], [-117.09651, 33.06334], [-117.09674, 33.06338], [-117.09686, 33.06339], [-117.09697, 33.06341], [-117.09717, 33.06354], [-117.09725, 33.06361], [-117.0973, 33.06372], [-117.09731, 33.06378], [-117.0973, 33.06383], [-117.09732, 33.06386], [-117.09721, 33.06435], [-117.09726, 33.06436], [-117.09732, 33.06431], [-117.0975, 33.06423], [-117.09765, 33.06421], [-117.09778, 33.06421], [-117.09805, 33.06426], [-117.0982, 33.06433], [-117.09831, 33.06441], [-117.0985, 33.06459], [-117.09858, 33.06472], [-117.09862, 33.06486], [-117.09863, 33.06508], [-117.09869, 33.0652], [-117.09873, 33.06524], [-117.09874, 33.06531], [-117.0988, 33.06542], [-117.09884, 33.06552], [-117.09888, 33.06574], [-117.09888, 33.06593], [-117.0988, 33.06612], [-117.09881, 33.06652], [-117.09908, 33.06711], [-117.09908, 33.06717], [-117.09906, 33.06723], [-117.09902, 33.0673], [-117.09894, 33.06734], [-117.09888, 33.06737], [-117.09881, 33.06738], [-117.09872, 33.06737], [-117.09863, 33.06733], [-117.0986, 33.06734], [-117.09867, 33.06742], [-117.09869, 33.06746], [-117.0987, 33.06753], [-117.09868, 33.06761], [-117.09871, 33.06763], [-117.09888, 33.0676], [-117.09912, 33.0676], [-117.09942, 33.06765], [-117.09966, 33.06771], [-117.0997, 33.06775], [-117.09978, 33.06779], [-117.09995, 33.06782], [-117.10003, 33.06789], [-117.10005, 33.06801]], [[-117.0942, 33.06133], [-117.09419, 33.06132], [-117.09309, 33.06103], [-117.09303, 33.06118], [-117.09413, 33.06148], [-117.0942, 33.06133]]], [[[-117.13513, 33.04138], [-117.13481, 33.04144], [-117.13446, 33.04154], [-117.13417, 33.04167], [-117.13403, 33.04174], [-117.13394, 33.04181], [-117.13391, 33.04181], [-117.13368, 33.04198], [-117.13347, 33.04219], [-117.13332, 33.04214], [-117.13314, 33.04241], [-117.13296, 33.04272], [-117.13279, 33.04267], [-117.13263, 33.04304], [-117.13263, 33.04305], [-117.13281, 33.04311], [-117.1327, 33.04336], [-117.13284, 33.04341], [-117.13268, 33.04382], [-117.13078, 33.04382], [-117.13101, 33.04348], [-117.13122, 33.04321], [-117.13159, 33.04282], [-117.13197, 33.0423], [-117.13276, 33.0414], [-117.13399, 33.04103], [-117.13512, 33.04084], [-117.13513, 33.04138]]], [[[-117.25126, 32.9784], [-117.2474, 32.97836], [-117.2474, 32.98092], [-117.24741, 32.98098], [-117.24658, 32.98117], [-117.24639, 32.98118], [-117.2461, 32.98118], [-117.24268, 32.98074], [-117.24047, 32.98063], [-117.24017, 32.98064], [-117.23874, 32.98074], [-117.23873, 32.97897], [-117.24007, 32.97858], [-117.24168, 32.97829], [-117.24739, 32.97836], [-117.24737, 32.97395], [-117.24781, 32.97386], [-117.24927, 32.97325], [-117.24998, 32.97311], [-117.2509, 32.97555], [-117.25119, 32.97663], [-117.25137, 32.97716], [-117.25143, 32.97786], [-117.25126, 32.9784]]], [[[-117.24306, 32.97398], [-117.24287, 32.97407], [-117.24176, 32.9743], [-117.24176, 32.97464], [-117.24045, 32.97462], [-117.24045, 32.97177], [-117.23966, 32.97176], [-117.23971, 32.97146], [-117.23971, 32.9712], [-117.23969, 32.97091], [-117.23965, 32.97065], [-117.24127, 32.97067], [-117.24169, 32.97116], [-117.24305, 32.97158], [-117.24306, 32.97398]]]]}	Open Access 1	46821	San Dieguito River Park	30289	2134	San Dieguito River Park Joint Powers Authority 883	Special District 4	Open Space District 6	http://www.sdrp.org/	Special District 4	2134	San Dieguito River Park Joint Powers Authority 859	Special District 4	Open Space District 6	http://www.sdrp.org/wordpress/trails/	San Diego 4	539.164	San Dieguito River Park	0	Local Park 2	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]);