Title: Creating a mappable database
Last modified: October 20, 2018

---

# Creating a mappable database

 *  [tsortore](https://wordpress.org/support/users/tsortore/)
 * (@tsortore)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/creating-a-mappable-database/)
 * Hello, I am working on an employee portal for my company and need a bit of help
   getting a feature built.
 * 1) Admins, my boss and operations managers and I, will have a table of drilling
   rigs.
    2) They will create a new project, and assign it a rig and location (**
   must be lat/long or assigned lat/longs by directly picking from a map**). 3) 
   Employees, **users with BuddyPress profiles**, will then select a rig from a 
   drop-down menu when they get on-site. a) This could be from their BuddyPress 
   profile but that’s not necessary. 4) They and others at that location will be
   displayed in an info window on the map when the pin is clicked.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Joy](https://wordpress.org/support/users/joyously/)
 * (@joyously)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/creating-a-mappable-database/#post-10799878)
 * That’s not a question, that’s a requirements list.
    Start by searching for plugins
   that do parts of what you need. Then you can decide to use the ones you find 
   with code you write, or combine the ones you find to do what you want.
 * If the data for locations is not used for page display, it should probably be
   in its own table. WordPress is geared toward showing what’s in the posts table,
   although using postmeta could work if that’s how your data is needed.
    If each
   location is a custom post, with a map as image, or lat/long as post meta, then
   you can use the built-in queries and things for showing them.
 *  Thread Starter [tsortore](https://wordpress.org/support/users/tsortore/)
 * (@tsortore)
 * [7 years, 5 months ago](https://wordpress.org/support/topic/creating-a-mappable-database/#post-10800179)
 * Thanks for the replay, Joy.
 * The locations do not need to be displayed anywhere but on the map. I have the
   database of locations within a table using ‘Participants Database’. But sadly
   there doesn’t seem to be any compatibility between this table and the user database
   in BuddyPress without manually editing and code. I’ve done plenty of searching,
   and decided it was time to reach out to someone more acquainted with WordPress.
 * If there is a way to tie a location to a project, and map the projects with the
   users assigned to the project in the map markers’ infowindows, then this would
   be an easy task.
 * Any help would be wonderful!
 * Thanks again.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Creating a mappable database’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [tsortore](https://wordpress.org/support/users/tsortore/)
 * Last activity: [7 years, 5 months ago](https://wordpress.org/support/topic/creating-a-mappable-database/#post-10800179)
 * Status: not a support question

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics