If you look at the POLE data provided by neo4j, you should get all labels by
MATCH (n)
RETURN DISTINCT labels(n)
[["Person"], ["Location"], ["Phone"], ["Email"], ["Officer"], ["Crime"], ["PhoneCall"], ["PostCode"], ["Area"], ["Vehicle"], ["Object...
Hi,
We have a OSM data uploaded for San Diego. We also have housing data for which we've found longitudes and latitudes and have uploaded as nodes with corresponding spatial points.
How would one join this housing data with the OSM? I spent a while o...
I also posted this at SO (which has pictures that couldn't be uploaded on this site): https://stackoverflow.com/questions/74736940/adding-properties-from-one-dataset-to-a-previously-created-node-from-another-dat
I've created a dataset of nodes from c...
Yeah, so it sounds like friend, famFriend, etc. are node labels. It certainly isn't something I've created and does need a colon before it. Weird that it isn't showing up.
I'm using the POLE / Crime investigations data on Neo4j Sandbox, but I also fo...
Thanks. Yes, I did collect to display the results. Thanks for the second snippet of code. Good to know how to deal with multiple labels.
Yes, that is the 'friend' I am referring to. So what I don't understand is how that becomes a variable because WI...
This seems to do the trick:
LOAD CSV WITH HEADERS
FROM "file:///Data-Census-clean_cen.csv" AS row
MATCH (geo_id: GEOID {GEOID: row.GEOID})
SET geo_id.Total_population = row.Total_population, geo_id.housing_units = row.Housing_unit,geo_id.number_fami...
Maybe I'm misunderstanding your solution, but in using your "where" statement, aren't you just limiting this to joining one tract node? Given that there ~300 tract_ids, this would take forever, no?