calands: units_with_maps: 1 row where ACCESS_TYP = 1, MNG_AG_TYP = 3 and PARK

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

1 row where ACCESS_TYP = 1, MNG_AG_TYP = 3 and PARK_URL = "http://ocparks.com/parks/william"

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
16348	16348	16347	{"type": "MultiPolygon", "coordinates": [[[[-117.80729, 33.65821], [-117.80687, 33.65821], [-117.80482, 33.65803], [-117.80424, 33.65799], [-117.80367, 33.658], [-117.80304, 33.65804], [-117.80167, 33.65458], [-117.80013, 33.65338], [-117.7967, 33.65259], [-117.79561, 33.65097], [-117.79457, 33.64881], [-117.7945, 33.6486], [-117.79373, 33.64829], [-117.79355, 33.64828], [-117.79348, 33.64814], [-117.79357, 33.64801], [-117.79363, 33.64779], [-117.79331, 33.64772], [-117.79321, 33.64755], [-117.79317, 33.64712], [-117.79319, 33.64681], [-117.79341, 33.6465], [-117.79359, 33.6464], [-117.79437, 33.64623], [-117.79452, 33.6463], [-117.79454, 33.64629], [-117.79456, 33.64629], [-117.79483, 33.646], [-117.79491, 33.646], [-117.79492, 33.64598], [-117.79508, 33.64598], [-117.79528, 33.64573], [-117.79552, 33.64535], [-117.79548, 33.64504], [-117.79505, 33.64469], [-117.7924, 33.64422], [-117.79262, 33.64384], [-117.79316, 33.64371], [-117.79404, 33.64374], [-117.79502, 33.64349], [-117.79495, 33.64333], [-117.79342, 33.64294], [-117.79345, 33.6426], [-117.7938, 33.64254], [-117.79424, 33.64235], [-117.79414, 33.64219], [-117.794, 33.64189], [-117.79409, 33.64171], [-117.79442, 33.64067], [-117.79444, 33.63951], [-117.79446, 33.63931], [-117.79451, 33.63913], [-117.79457, 33.63884], [-117.79458, 33.63843], [-117.79469, 33.63812], [-117.79471, 33.63806], [-117.79517, 33.63669], [-117.79522, 33.63669], [-117.79558, 33.63575], [-117.79687, 33.63574], [-117.79708, 33.64124], [-117.79733, 33.64384], [-117.79855, 33.64522], [-117.79857, 33.64671], [-117.7982, 33.64672], [-117.79783, 33.64768], [-117.79791, 33.64799], [-117.79788, 33.64806], [-117.7979, 33.64815], [-117.79803, 33.64819], [-117.79823, 33.64831], [-117.79832, 33.6484], [-117.79837, 33.64857], [-117.79843, 33.64863], [-117.79879, 33.6488], [-117.79907, 33.64903], [-117.79907, 33.64909], [-117.7992, 33.64927], [-117.79936, 33.64941], [-117.79959, 33.64958], [-117.79976, 33.64946], [-117.79988, 33.64962], [-117.79995, 33.64977], [-117.79996, 33.64992], [-117.80019, 33.65011], [-117.80044, 33.65024], [-117.80064, 33.65012], [-117.80074, 33.65017], [-117.80098, 33.65037], [-117.8011, 33.65043], [-117.80134, 33.65043], [-117.80163, 33.65042], [-117.80171, 33.65065], [-117.80182, 33.65089], [-117.802, 33.65121], [-117.80212, 33.65138], [-117.80239, 33.6517], [-117.80376, 33.65313], [-117.80375, 33.65315], [-117.80405, 33.65344], [-117.80428, 33.6537], [-117.80456, 33.65407], [-117.80475, 33.65439], [-117.80489, 33.65465], [-117.80521, 33.65552], [-117.80529, 33.65578], [-117.80541, 33.65604], [-117.80553, 33.65623], [-117.80578, 33.65653], [-117.80607, 33.65677], [-117.80653, 33.65722], [-117.80679, 33.65742], [-117.80694, 33.65757], [-117.80716, 33.65787], [-117.80727, 33.65812], [-117.80729, 33.65821]]], [[[-117.80688, 33.6565], [-117.80653, 33.65685], [-117.80625, 33.65659], [-117.80607, 33.65644], [-117.80587, 33.65622], [-117.80576, 33.65608], [-117.80563, 33.65586], [-117.80556, 33.65568], [-117.80525, 33.6548], [-117.80512, 33.6545], [-117.80496, 33.65418], [-117.80469, 33.65377], [-117.80446, 33.65349], [-117.80416, 33.65317], [-117.80397, 33.653], [-117.80526, 33.65309], [-117.80619, 33.65604], [-117.80688, 33.6565]]], [[[-117.8276, 33.65706], [-117.82748, 33.65715], [-117.82667, 33.65714], [-117.82601, 33.65709], [-117.82293, 33.65703], [-117.82175, 33.65704], [-117.82121, 33.6571], [-117.8207, 33.65719], [-117.82013, 33.65734], [-117.81977, 33.65745], [-117.81925, 33.65765], [-117.81816, 33.65813], [-117.81782, 33.65826], [-117.81724, 33.65841], [-117.8166, 33.65846], [-117.81565, 33.65842], [-117.81526, 33.65837], [-117.81428, 33.65803], [-117.81393, 33.65789], [-117.81347, 33.65767], [-117.8132, 33.65757], [-117.81245, 33.65738], [-117.81173, 33.65728], [-117.81145, 33.65728], [-117.81112, 33.6573], [-117.81051, 33.65741], [-117.80984, 33.65766], [-117.80942, 33.65783], [-117.80914, 33.65792], [-117.80862, 33.65805], [-117.80818, 33.65813], [-117.80767, 33.65819], [-117.80754, 33.65818], [-117.80753, 33.65806], [-117.80741, 33.6578], [-117.80702, 33.65731], [-117.80673, 33.65702], [-117.80705, 33.65666], [-117.80771, 33.65722], [-117.80947, 33.65708], [-117.81023, 33.65587], [-117.81175, 33.65549], [-117.81263, 33.65523], [-117.81399, 33.65546], [-117.81416, 33.65639], [-117.81493, 33.65707], [-117.8165, 33.65649], [-117.81666, 33.6566], [-117.81687, 33.65651], [-117.81787, 33.65537], [-117.81816, 33.65479], [-117.81802, 33.65447], [-117.81904, 33.65347], [-117.8192, 33.65358], [-117.81934, 33.65341], [-117.81947, 33.65332], [-117.81982, 33.65319], [-117.82056, 33.65452], [-117.82223, 33.65464], [-117.82504, 33.65446], [-117.82657, 33.65382], [-117.82701, 33.65456], [-117.82716, 33.65486], [-117.82734, 33.65531], [-117.82753, 33.65596], [-117.82759, 33.65656], [-117.8276, 33.65706]]], [[[-117.83887, 33.65552], [-117.83864, 33.65677], [-117.83862, 33.65722], [-117.83858, 33.65723], [-117.83856, 33.6574], [-117.82807, 33.65715], [-117.82801, 33.65711], [-117.82801, 33.65664], [-117.82791, 33.65594], [-117.82774, 33.65534], [-117.82715, 33.65406], [-117.827, 33.65382], [-117.82702, 33.65375], [-117.82786, 33.65343], [-117.82838, 33.65328], [-117.82908, 33.65305], [-117.82974, 33.65274], [-117.82995, 33.65262], [-117.83016, 33.65279], [-117.83107, 33.65305], [-117.83173, 33.65399], [-117.83215, 33.654], [-117.83235, 33.65317], [-117.83283, 33.65259], [-117.83321, 33.6525], [-117.83331, 33.65241], [-117.83339, 33.65241], [-117.83348, 33.65245], [-117.83352, 33.65249], [-117.83359, 33.65276], [-117.83404, 33.65347], [-117.83507, 33.6537], [-117.83639, 33.65402], [-117.83669, 33.65387], [-117.83707, 33.65402], [-117.83721, 33.65489], [-117.83887, 33.65552]]]]}	Open Access 1	15394	William R Mason Regional Park	8130	312	Orange, County of 142	County 3	County Agency 3	http://ocparks.com/	County 3	312	Orange, County of 138	County 3	County Agency 3	http://ocparks.com/parks/william	Orange 3	438.515	William R Mason RP	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]);