Java Spring boot Geocode nearby operation with pagination and additional filter

Shubham_Sharma14 · 2024-07-11T11:36:21.907Z

Is there not a easy method to get paginated end point for geocode nearby operation with spring jpa repository method

If i have a distributorType as not null, my code below takes too much time to run even with proper indexes

private GeoPage<Property> searchNearBy(String lat, String lng, double radius, Integer pageNumber, Integer pageSize, String distributorType) {
	Point centerPoint = new Point(Double.parseDouble(lng), Double.parseDouble(lat));
	Distance maxDistance = new Distance(radius, Metrics.KILOMETERS);
	PageRequest page = PageRequest.of(pageNumber, pageSize);
	if(distributorType == null || distributorType.isEmpty()) {
		return repository.findByGeoCodeNear(centerPoint, maxDistance, page);
	} else {
		GeoResults<Property> result = mongoOperations.query(Property.class)
				.as(Property.class)
				.near(NearQuery.near(centerPoint)
						.maxDistance(maxDistance)
						.query(new Query(Criteria.where("distributorType").is(distributorType)))
						.with(page))
				.all();
		long count = mongoOperations.count(new Query(Criteria.where("distributorType").is(distributorType).and("location").near(centerPoint).maxDistance(maxDistance.getValue())), Property.class);
		return new GeoPage<>(result, page, count);
	}
}

Ashni_Mehta · 2024-07-15T16:58:42.441Z

Hi – I see you mentioned Spring JPA. Have you tried Spring Data MongoDB? There is support for $geoNear, documentation here.

Shubham_Sharma14 · 2024-07-22T11:05:09.332Z

Hi Ashni,

Thanks for your reply, can you please simple code snippet to get GeoPage with nearBy operation and for a particular distributorType, i dont want to get GeoResult and then being forced to write separate count query