By Anonymous (not verified) on

Looking for a Drupal/PHP coder, preferably with views integration, taxonomy and search experience, for an urgent job where another developer has let us down.

The job is a directory site with proximity filtering provided by a custom geo-spatially aware module (already built) which is essentially the 'location' module stripped down and made to save a mysql POINT(x,y) (based on the latitude and longitude of the 'location') in a 'geometry' column. The initial idea was to do the proximity searching without using views since there's currently no views integration for the mysql spatial proximity filter functions, but that scared our developer off so that's why we've asked for someone with experience in that area.

If you'd like to bid just for the job of integrating the custom location module with views, that's a possibility, so please contact me.

Other important aspects of the site are taxonomy (hierarchial) and search (flexible).

To be clear, we're not looking for a module installer. This will definitely require some custom work. I'd like to see SEVERAL examples of Drupal and Non-Drupal work, meaning ACTUAL code.

Please don't apply if you're planning on outsourcing it or would otherwise not be responsible directly for the code that is produced.

Regards

Steve

⋅ Categories: Drupal 6.x

Comments

gecnexus’s picture

gecnexus commented

The Location module actually adds a proximity filter to views, with both circular and rectangular proximity options, distance from a specified point or postal code origin, and a miles/kilometers unit specification. The calculation (in sites/all/modules/location/earth.inc) is also more accurate than the function most often used for distance calculations. Its based on the flattened ellipsoid model from the WGS-84 datum, rather than assuming a perfectly round earth as in the most often used function.

Also, from perusing the MySQL 5.5 documentation, the spatial functions built-in to MySQL still only support Euclidean (planar) calculations rather than geocentric ones you probably need.

From the MySQL documentation:

In MySQL, the SRID value is just an integer associated with the geometry value. All calculations are done assuming Euclidean (planar) geometry.