Published
Edited
Jun 17, 2019
1 star
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
callDB('SELECT * FROM erbil LIMIT 1')
Insert cell
Insert cell
callDB(`SELECT mahallahna FROM erbil WHERE ST_Intersects(wkb_geometry, ST_SetSRID(ST_MakePoint(${longitude}, ${latitude}), 4326))`)
Insert cell
Insert cell
Insert cell
Insert cell
testcall = callDB(`SELECT mahallahna FROM erbil WHERE ST_Intersects(wkb_geometry, ST_SetSRID(ST_MakePoint(${lng2}, ${lat2}), 4326))`)
Insert cell
JSON.parse(testcall).length ? testcall : 'Not Erbil'
Insert cell
Insert cell
Insert cell
Insert cell
callDB(`SELECT mahallahna, ST_AsGeoJSON(wkb_geometry)
FROM erbil
WHERE ST_Intersects(wkb_geometry, ST_SetSRID(ST_MakePoint(${lng3}, ${lat3}), 4326))`)
Insert cell

Purpose-built for displays of data

Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
Learn more