Geospatial Data With GraphQL | Building A Real Estate Search App With GRANDstack: Part 3

[jaggi]

Thanks for this awesome stream! If anyone is interested this is the cypher query that would calculate centroid properly:
match (p:Property)
unwind p.polygon as point
with p, avg(point.latitude) as lat, avg(point.longitude) as lon
set p.location = Point({ latitude: lat, longitude: lon })

[tractatusviii]

Will, this is awesome. Looking forward to the front-end part of the trip here

[dionjenkins]

Hi Will. Regarding the data model - I’m looking at commercial leasing app which has important attributes such as warehouse, office, yard etc. of the property. These could be properties on the Property node, but my way of thinking is that they might be nodes instead. The question is “find me a property with 1000sqm warehouse space and at least 250sqm office space”. What criteria determines whether it’s a node or properties in a node? Thanks!

[foodhobo-io]

45:00 -->spatial-algorithms release needs to be downloaded prior to working with coordinates

[michaelporter]

Great demo. Does Neo4j Aura allow you to use all of these extra procedures yet?

[ChrisB_Crisps]

Wouldn't would be easier to keep the cities (and any field unless there is a good reason) as lowercase (and also trimmed, to reduce unwanted data that could be considered duplicates)? Lowercase words are easier (and a maybe bit faster) to search without having to specify _Ignore case_ and also doesn't require the developer to use shift of caps lock when entering the test for that. The data can end up sometimes exported to a file and then it could be searched with other editor or tools, lowercase on most of the case require less effort from the developer to search or retype, not a big deal though but it helps knowing that fields generally are stored lowercase and doesn't require to stop and think if something is lowercase or uppercase :)

[foodhobo-io]

30:00 adding each geometry to their respective node

[TheSimbeye]

Will... I appreciate your tutorials. By the way, is there a way I can store " Multipolygon " Points as we have done with " Polygons" using or any other way. I will appreciate if you can drop a cypher query.

Kind regards.