Hello,
I have loaded the spatial data in the attached file using REST API script
(which is also attached). The nodes are created and I can visualize them on
DB.
However when I perform the query
"START n=node:geom('withinDistance:[41.8082, -87.7084, 10.0]') RETURN n" in
CYPHER window , I am getting "Unknown Error" as result.
Please help.
--
You received this message because you are subscribed to the Google Groups
"Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
9712873,HX363301,07/27/2014 11:45:00 PM,038XX S CALIFORNIA AVE,1811,NARCOTICS,POSS: CANNABIS 30GMS OR LESS,STREET,true,false,0911,009,12,58,18,1158286,1879292,2014,08/03/2014 12:37:30 PM,41.82451978982706,-87.69480710342923,"(41.82451978982706, -87.69480710342923)"
9712861,HX363280,07/27/2014 11:45:00 PM,007XX N HAMLIN AVE,1811,NARCOTICS,POSS: CANNABIS 30GMS OR LESS,SIDEWALK,true,false,1112,011,27,23,18,1150889,1904471,2014,08/03/2014 12:37:30 PM,41.89376161572923,-87.72128616748815,"(41.89376161572923, -87.72128616748815)"
9712978,HX363281,07/27/2014 11:45:00 PM,056XX N WESTERN AVE,0810,THEFT,OVER $500,TAVERN/LIQUOR STORE,false,false,2011,020,40,2,06,1159260,1937656,2014,08/03/2014 12:37:30 PM,41.98465541278182,-87.6896270317053,"(41.98465541278182, -87.6896270317053)"
9712867,HX363289,07/27/2014 11:44:00 PM,019XX N TRIPP AVE,0470,PUBLIC PEACE VIOLATION,RECKLESS CONDUCT,ALLEY,true,false,2534,025,30,20,24,1147780,1912737,2014,08/03/2014 12:37:30 PM,41.91650465834968,-87.73249193921424,"(41.91650465834968, -87.73249193921424)"
9712874,HX363277,07/27/2014 11:40:00 PM,012XX W 64TH ST,0486,BATTERY,DOMESTIC BATTERY SIMPLE,STREET,false,true,0724,007,17,67,08B,1168791,1862292,2014,08/03/2014 12:37:30 PM,41.77764918159004,-87.65675840450875,"(41.77764918159004, -87.65675840450875)"
9712909,HX363263,07/27/2014 11:35:00 PM,033XX W 47TH ST,0460,BATTERY,SIMPLE,PARKING LOT/GARAGE(NON.RESID.),false,false,0821,008,14,58,08B,1154612,1873308,2014,08/03/2014 12:37:30 PM,41.808173036722756,-87.70844562528686,"(41.808173036722756, -87.70844562528686)"
9712949,HX363291,07/27/2014 11:30:00 PM,0000X S CICERO AVE,0460,BATTERY,SIMPLE,ALLEY,false,false,1113,011,28,25,08B,1144435,1899423,2014,08/03/2014 12:37:30 PM,41.880033198763805,-87.74511687107176,"(41.880033198763805, -87.74511687107176)"
9719615,HX369089,07/27/2014 11:30:00 PM,039XX S MICHIGAN AVE,1563,SEX OFFENSE,CRIMINAL SEXUAL ABUSE,RESTAURANT,false,false,0213,002,3,38,17,1177848,1879097,2014,08/03/2014 12:37:30 PM,41.82356332537494,-87.62304642266882,"(41.82356332537494, -87.62304642266882)"
import csv
import requests
import json
headers = {'content-type': 'application/json'}
# Create geom index
url = "http://localhost:7474/db/data/index/node/";
payload= {
"name" : "geom",
"config" : {
"provider" : "spatial",
"geometry_type" : "point",
"lat" : "lat",
"lon" : "lon"
}
}
r = requests.post(url, data=json.dumps(payload), headers=headers)
with open('/home/mk/Data/Crimes_sample_test.csv', 'rb') as f: # read data file
reader = csv.reader(f)
for row in reader:
# create crime node
url = "http://localhost:7474/db/data/node";
payload = {'id':int(row[0]),'case_number':row[1],'date':row[2],'crime_type':row[5],'district':int(row[11]),'ward':int(row[12]),'lat': float(row[19]), 'lon': float(row[20])}
r = requests.post(url, data=json.dumps(payload), headers=headers)
node = r.json()['self']
#add node to geom index
url = "http://localhost:7474/db/data/index/node/geom";
payload = {'value': 'dummy', 'key': 'dummy', 'uri': node}
r = requests.post(url, data=json.dumps(payload), headers=headers)
#add node to Spatial index
url = "http://localhost:7474/db/data/ext/SpatialPlugin/graphdb/addNodeToLayer";
payload = {'layer': 'geom', 'node': node}
r = requests.post(url, data=json.dumps(payload), headers=headers)
