spatial.addPointLayerXY

Procedure

Adds a new simple point layer with the given properties for x and y coordinates, returns the layer root node

Signature

spatial.addPointLayerXY(name :: STRING, xProperty :: STRING, yProperty :: STRING, indexType = rtree :: STRING, crsName =  :: STRING, indexConfig =  :: STRING) :: (node :: NODE)

Input parameters

Name Type Default Description

name

STRING

null

The name of the layer

xProperty

STRING

null

The property of the node to read the x coordinate from

yProperty

STRING

null

The property of the node to read the y coordinate from

indexType

STRING

"rtree"

The type of the index algorithm to be used, valid values are: rtree, geohash, zorder or hilbert

crsName

STRING

""

The CRS to be used, valid values are: wgs84

indexConfig

STRING

""

The configuration of the newly created index

Output parameters

Name Type Description

node

NODE

Examples

Create a point layer with X and Y properties

CALL spatial.addPointLayerXY('geom','lon','lat')

Add two nodes to the layer

CREATE (n1:Node {id: 1, lat:60.1,lon:15.2}),(n2:Node {id: 2, lat:60.1,lon:15.3}) WITH n1,n2 CALL spatial.addNodes('geom',[n1,n2]) YIELD count RETURN n1,n2,count
Table 1. Result
count n1 n2 
2
 
(:Node {
    bbox: [ 15.2, 60.1, 15.2, 60.1 ],
    gtype: 1,
    id: 1,
    lat: 60.1,
    lon: 15.2
})
 
(:Node {
    bbox: [ 15.3, 60.1, 15.3, 60.1 ],
    gtype: 1,
    id: 2,
    lat: 60.1,
    lon: 15.3
})

Find nodes within distance

CALL spatial.withinDistance('geom',{lon:15.0,lat:60.0},100)
Table 2. Result
distance node 
15.713441434310283
 
(:Node {
    bbox: [ 15.2, 60.1, 15.2, 60.1 ],
    gtype: 1,
    id: 1,
    lat: 60.1,
    lon: 15.2
})
 
20.024944023694385
 
(:Node {
    bbox: [ 15.3, 60.1, 15.3, 60.1 ],
    gtype: 1,
    id: 2,
    lat: 60.1,
    lon: 15.3
})

Remove node 1

MATCH (node) WHERE node.id = 1
CALL spatial.removeNode('geom', node) YIELD nodeId
RETURN nodeId
CALL spatial.withinDistance('geom',{lon:15.0,lat:60.0},100)
Table 3. Result
distance node 
20.024944023694385
 
(:Node {
    bbox: [ 15.3, 60.1, 15.3, 60.1 ],
    gtype: 1,
    id: 2,
    lat: 60.1,
    lon: 15.3
})

Remove node 2

MATCH (node) WHERE node.id = 2
CALL spatial.removeNode.byId('geom', elementId(node)) YIELD nodeId
RETURN nodeId
CALL spatial.withinDistance('geom',{lon:15.0,lat:60.0},100)
Result

No results