calands: units_with_maps: 1 row where ACCESS_TYP = 1, DES_TP = 3 and SUID

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

1 row where ACCESS_TYP = 1, DES_TP = 3 and SUID_NMA = 30258

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
15980	15980	15979	{"type": "MultiPolygon", "coordinates": [[[[-117.14563, 32.97103], [-117.14535, 32.97153], [-117.14517, 32.97181], [-117.14502, 32.9721], [-117.1449, 32.97239], [-117.14476, 32.97285], [-117.1447, 32.97352], [-117.14471, 32.97379], [-117.14474, 32.97406], [-117.14485, 32.97453], [-117.14507, 32.97506], [-117.14405, 32.97512], [-117.14409, 32.97105], [-117.14563, 32.97103]]], [[[-117.15342, 32.97095], [-117.15284, 32.97113], [-117.1522, 32.97139], [-117.1516, 32.9717], [-117.15113, 32.972], [-117.15077, 32.97226], [-117.14711, 32.97518], [-117.14681, 32.97538], [-117.14647, 32.97566], [-117.14583, 32.97505], [-117.14549, 32.97443], [-117.14535, 32.97414], [-117.1454, 32.97411], [-117.14533, 32.97378], [-117.14539, 32.97321], [-117.14554, 32.97268], [-117.14582, 32.9719], [-117.14605, 32.97147], [-117.14617, 32.97103], [-117.14813, 32.97103], [-117.14827, 32.97101], [-117.15093, 32.971], [-117.15108, 32.97049], [-117.15121, 32.97017], [-117.1512, 32.97], [-117.15112, 32.96994], [-117.15117, 32.96973], [-117.15066, 32.96947], [-117.15047, 32.96946], [-117.15007, 32.96967], [-117.14967, 32.96958], [-117.14942, 32.96959], [-117.14916, 32.96979], [-117.14886, 32.96991], [-117.14875, 32.96996], [-117.14832, 32.97006], [-117.14815, 32.97014], [-117.14793, 32.97016], [-117.14773, 32.97018], [-117.1476, 32.97015], [-117.14739, 32.97018], [-117.14696, 32.97019], [-117.14679, 32.97013], [-117.14664, 32.97012], [-117.14665, 32.96997], [-117.14664, 32.96996], [-117.14641, 32.97027], [-117.14638, 32.97027], [-117.14646, 32.96978], [-117.14652, 32.96861], [-117.14739, 32.9687], [-117.15088, 32.96878], [-117.15174, 32.96915], [-117.15208, 32.96907], [-117.15215, 32.96891], [-117.15251, 32.96865], [-117.15279, 32.96826], [-117.15275, 32.97098], [-117.15342, 32.97095]]], [[[-117.15525, 32.97813], [-117.1549, 32.97829], [-117.15502, 32.97866], [-117.15464, 32.97894], [-117.15452, 32.97967], [-117.15389, 32.97966], [-117.15399, 32.9795], [-117.15404, 32.97927], [-117.15403, 32.97913], [-117.15401, 32.97905], [-117.15365, 32.97819], [-117.15361, 32.97795], [-117.15349, 32.97797], [-117.15351, 32.97812], [-117.15354, 32.97824], [-117.15389, 32.97908], [-117.15391, 32.97927], [-117.15388, 32.97941], [-117.15374, 32.97965], [-117.15249, 32.97962], [-117.15194, 32.97955], [-117.15145, 32.97946], [-117.1516, 32.97841], [-117.15086, 32.97813], [-117.14872, 32.97815], [-117.14862, 32.97808], [-117.14728, 32.97689], [-117.14722, 32.97682], [-117.1471, 32.97666], [-117.14653, 32.97614], [-117.14654, 32.9761], [-117.15105, 32.97251], [-117.15151, 32.97216], [-117.15206, 32.97185], [-117.15263, 32.97157], [-117.15324, 32.97136], [-117.15398, 32.97118], [-117.15347, 32.97364], [-117.15379, 32.97398], [-117.15422, 32.97429], [-117.15433, 32.97458], [-117.15424, 32.97461], [-117.15408, 32.97473], [-117.154, 32.97469], [-117.15358, 32.97493], [-117.15341, 32.97533], [-117.15342, 32.97575], [-117.15388, 32.97576], [-117.15387, 32.97588], [-117.15389, 32.97599], [-117.15425, 32.97709], [-117.15412, 32.97717], [-117.1539, 32.9775], [-117.15384, 32.97794], [-117.15522, 32.97787], [-117.15525, 32.97813]]], [[[-117.15705, 32.96558], [-117.15703, 32.96727], [-117.15477, 32.96739], [-117.15553, 32.96645], [-117.15626, 32.96629], [-117.15653, 32.96577], [-117.15671, 32.96557], [-117.15705, 32.96558]]], [[[-117.15968, 32.96837], [-117.15966, 32.96841], [-117.15968, 32.96844], [-117.15958, 32.96849], [-117.15955, 32.96847], [-117.15938, 32.96856], [-117.15915, 32.96856], [-117.15901, 32.96854], [-117.15887, 32.96848], [-117.15881, 32.96848], [-117.15868, 32.96853], [-117.15851, 32.96863], [-117.15838, 32.96867], [-117.15823, 32.96884], [-117.15819, 32.96895], [-117.1582, 32.96909], [-117.15813, 32.96922], [-117.15814, 32.96794], [-117.1596, 32.96786], [-117.15959, 32.96795], [-117.15968, 32.96837]]], [[[-117.16086, 32.96351], [-117.16071, 32.96352], [-117.15942, 32.9636], [-117.15973, 32.96344], [-117.15998, 32.96321], [-117.16005, 32.96325], [-117.16039, 32.96329], [-117.16086, 32.96351]]], [[[-117.16405, 32.96505], [-117.16391, 32.96539], [-117.16385, 32.96547], [-117.16363, 32.96556], [-117.16357, 32.96562], [-117.16348, 32.96568], [-117.16343, 32.96568], [-117.16328, 32.96572], [-117.16296, 32.96591], [-117.16286, 32.96601], [-117.16282, 32.9661], [-117.16275, 32.96614], [-117.16273, 32.96623], [-117.16268, 32.96626], [-117.16256, 32.96625], [-117.16255, 32.9664], [-117.16235, 32.96646], [-117.16228, 32.9665], [-117.16224, 32.96656], [-117.16223, 32.96662], [-117.16224, 32.96678], [-117.16221, 32.96678], [-117.16218, 32.96682], [-117.16221, 32.96698], [-117.16232, 32.96714], [-117.16227, 32.96712], [-117.16218, 32.96714], [-117.16207, 32.96712], [-117.16201, 32.96704], [-117.16186, 32.96693], [-117.16177, 32.96682], [-117.16172, 32.96678], [-117.1617, 32.96674], [-117.16162, 32.96669], [-117.16156, 32.9667], [-117.1613, 32.96685], [-117.16132, 32.96378], [-117.16179, 32.96418], [-117.16363, 32.96506], [-117.16405, 32.96505]]], [[[-117.16982, 32.96119], [-117.16965, 32.96138], [-117.1691, 32.96154], [-117.16904, 32.96173], [-117.16895, 32.9618], [-117.16848, 32.96163], [-117.16832, 32.96178], [-117.16806, 32.96194], [-117.16804, 32.96215], [-117.16786, 32.96222], [-117.16764, 32.96216], [-117.16699, 32.96253], [-117.16623, 32.96268], [-117.16613, 32.9629], [-117.16599, 32.96294], [-117.16534, 32.96319], [-117.16528, 32.96325], [-117.16281, 32.96339], [-117.16237, 32.96332], [-117.16216, 32.96322], [-117.16185, 32.96295], [-117.1616, 32.96266], [-117.16132, 32.96253], [-117.16133, 32.96222], [-117.16145, 32.96242], [-117.16148, 32.96242], [-117.16164, 32.96259], [-117.16227, 32.96304], [-117.16241, 32.96311], [-117.16261, 32.96308], [-117.16282, 32.96284], [-117.16281, 32.96274], [-117.1629, 32.96273], [-117.16321, 32.96243], [-117.1637, 32.96261], [-117.16406, 32.96261], [-117.16427, 32.96249], [-117.16425, 32.96235], [-117.16442, 32.96242], [-117.16485, 32.96209], [-117.16467, 32.96179], [-117.1645, 32.96167], [-117.16428, 32.96158], [-117.16402, 32.96139], [-117.16413, 32.9613], [-117.16411, 32.96128], [-117.16423, 32.96119], [-117.16475, 32.96086], [-117.16488, 32.9608], [-117.16515, 32.96073], [-117.16526, 32.96072], [-117.16523, 32.96095], [-117.16521, 32.96096], [-117.16521, 32.96105], [-117.16528, 32.96105], [-117.16529, 32.96097], [-117.16528, 32.96096], [-117.16531, 32.96072], [-117.16545, 32.96073], [-117.16553, 32.96077], [-117.16552, 32.9608], [-117.16646, 32.96147], [-117.16649, 32.96145], [-117.16687, 32.96161], [-117.16714, 32.96163], [-117.16731, 32.96162], [-117.1675, 32.96147], [-117.16762, 32.96125], [-117.1675, 32.96115], [-117.16767, 32.96114], [-117.16788, 32.96049], [-117.1682, 32.96037], [-117.16864, 32.96026], [-117.1688, 32.96032], [-117.16883, 32.96027], [-117.16878, 32.96024], [-117.16901, 32.96018], [-117.16912, 32.96009], [-117.16916, 32.95998], [-117.1692, 32.95982], [-117.16919, 32.95942], [-117.16982, 32.95939], [-117.16982, 32.96119]]], [[[-117.1677, 32.96664], [-117.16769, 32.96679], [-117.1677, 32.96869], [-117.16728, 32.96824], [-117.16679, 32.9682], [-117.16628, 32.9685], [-117.16622, 32.9686], [-117.16622, 32.96867], [-117.16619, 32.96872], [-117.16613, 32.96876], [-117.16611, 32.9688], [-117.165, 32.96901], [-117.16484, 32.96896], [-117.16459, 32.96898], [-117.16462, 32.96887], [-117.16455, 32.96877], [-117.16461, 32.96873], [-117.16568, 32.9677], [-117.16601, 32.96746], [-117.16611, 32.96734], [-117.1662, 32.96728], [-117.16627, 32.96721], [-117.16633, 32.96713], [-117.1665, 32.96698], [-117.16674, 32.96673], [-117.16699, 32.9666], [-117.16703, 32.96649], [-117.16728, 32.96649], [-117.1677, 32.96664]]]]}	Open Access 1	46801	McGonigle Canyon Open Space	30258	1297	San Diego, City of 4	City 2	City Agency 2	http://www.sandiego.gov/park-and-recreation/	City 2	1297	San Diego, City of 4	City 2	City Agency 2		San Diego 4	231.79	McGonigle Canyon OS	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]);