# How to bing geospatial point from sql to stardog

**URL:** <https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155>\
**Category:** Support\
**Created:** [November 26, 2024, 1:21pm UTC](https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155 "2024-11-26T13:21:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dipanjan\_Chowdhury](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/dipanjan_chowdhury/32/1634_2.png) [@Dipanjan\_Chowdhury](https://community.stardog.com/u/Dipanjan_Chowdhury)\
**Post date:** [November 26, 2024, 1:21pm UTC](https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155/1 "2024-11-26T13:21:09Z")

</div>

```auto
MAPPING <urn:r2m2l_3657b6d8_a79a_4698_b3fb_e54f0e7eb746_1223895>
FROM SQL {
  SELECT *
  FROM `Hackathon_Exercise`.`adsb_signal`
}
TO {
  ?subject a geo:hasGeometry .
  ?subject <http://api.stardog.com/adsb_signal#aircraft_id> ?aircraft_id .
  ?subject <http://api.stardog.com/adsb_signal#altitude> ?altitude_double .
  ?subject <http://api.stardog.com/adsb_signal#ground_speed> ?ground_speed_double .
  ?subject <http://api.stardog.com/adsb_signal#heading> ?heading_double .
  ?subject <http://api.stardog.com/adsb_signal#latitude> ?latitude_double .
  ?subject <http://api.stardog.com/adsb_signal#location> ?location .
  ?subject <http://api.stardog.com/adsb_signal#longitude> ?longitude_double .
  ?subject <http://api.stardog.com/adsb_signal#ref-aircraft_id> ?ref_aircraft_id .
  ?subject <http://api.stardog.com/adsb_signal#signal_id> ?signal_id .
  ?subject <http://api.stardog.com/adsb_signal#signal_timestamp> ?signal_timestamp_dateTime .
  ?subject rdf:type :adsb_signal
} WHERE {
  BIND(StrDt(?altitude, xsd:double) AS ?altitude_double)
  BIND(StrDt(?ground_speed, xsd:double) AS ?ground_speed_double)
  BIND(StrDt(?heading, xsd:double) AS ?heading_double)
  BIND(StrDt(?latitude, xsd:double) AS ?latitude_double)
  BIND(StrDt(?longitude, xsd:double) AS ?longitude_double)
  
  BIND(StrDt(?signal_timestamp, xsd:dateTime) AS ?signal_timestamp_dateTime)
  BIND(template("http://api.stardog.com/adsb_signal/signal_id={signal_id}") AS ?subject)
  BIND(template("http://api.stardog.com/aircraft/aircraft_id={aircraft_id}") AS ?ref_aircraft_id)
}

```

I want to update the binding of location which is point such that i can use geosparql queries

---

<div class="post-metadata">

**Author:** ![Lars\_Heling](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.stardog.com/lars_heling/32/1657_2.png) [@Lars\_Heling](https://community.stardog.com/u/Lars_Heling)\
**Post date:** [November 27, 2024, 6:30am UTC](https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155/2 "2024-11-27T06:30:38Z")

</div>

Hi Dipanjan,

In general, to support geospatial queries, the geospatial data needs to be represented using the right class and properties. In your mappings, this would be something like:

```SQL
?subject a geo:Geometry .
?subject wgs:lat ?latitude_double.
?subject wgs:long ?longitude_double.
...

```

See also [our docs](https://docs.stardog.com/tutorials/stardog-geospatial#representing-single-points) for details.  
Moreover, geospatial queries are currently not supported to be evaluated over Virtual Graphs. As a result, you would need to materialize the virtual data into a database (with `spatial.enabled=true`) first.

Best regards  
Lars

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [June 23, 2025, 5:44am UTC](https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155/3 "2025-06-23T05:44:50Z")

</div>



---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex030/uploads/stardog/original/2X/e/ed66b48a616f505106a4acde3c9cee7e6da9bc67.svg) [@system](https://community.stardog.com/u/system)\
**Post date:** [February 10, 2026, 8:59am UTC](https://community.stardog.com/t/how-to-bing-geospatial-point-from-sql-to-stardog/5155/4 "2026-02-10T08:59:20Z")

</div>