sql server - How can I do this Spatial Query in Sql 2008? -


I am trying to do a spatial query in SEC 2008 -> POI (interest status, long / lat Geography data), which they are present in postcode (Multipolision Geogography / data).

So this is what I tried, but this syntax is wrong: - 

  Select PostCodeId, from a postcard with a postcard where one. Shapefile.stits (point of view from point to point point in PointOfInterestId (dbo.fnSplit (@PoiIdList, ', select items from')

This means I pass through This is not a problem .. It is in my subquirer STIntersects . This is invalid.

.. Any suggestions people?

How about: 

  Select one. From PostCodeId, a.ShapeFile (SELECT Item dbo.fnSplit (@PoiIdList, ',')) Include INNER as POI_ID PointOf Interest S at PointOfInterests.PointOfInterestId = PO I_IDs.Item INNER JOIN Postcard on a SHAPFile.STIntersects (PointOfInterestsPointOfInterest) = 1

Comments

Post a Comment