Title: Geo Data Store
Author: Scott Cariss
Published: <strong>2011 年 5 月 13 日</strong>
Last modified: 2013 年 1 月 11 日

---

搜尋外掛

這個外掛**並未在最新的 3 個 WordPress 主要版本上進行測試**。開發者可能不再對這個
外掛進行維護或提供技術支援，並可能會與更新版本的 WordPress 產生使用上的相容性問題。

![](https://s.w.org/plugins/geopattern-icon/geo-data-store.svg)

# Geo Data Store

 由 [Scott Cariss](https://profiles.wordpress.org/l3rady/) 開發

[下載](https://downloads.wordpress.org/plugin/geo-data-store.2.0.3.zip)

 * [詳細資料](https://tw.wordpress.org/plugins/geo-data-store/#description)
 * [使用者評論](https://tw.wordpress.org/plugins/geo-data-store/#reviews)
 *  [安裝方式](https://tw.wordpress.org/plugins/geo-data-store/#installation)
 * [開發資訊](https://tw.wordpress.org/plugins/geo-data-store/#developers)

 [技術支援](https://wordpress.org/support/plugin/geo-data-store/)

## 外掛說明

This plugin is meant to be used by other developers and to be used together with
themes and other plugins. Many themes and plugins use WordPress meta data table 
to store longitude and latitude co-ordinates for posts. While this works fine the
meta data table cannot be indexed very well. Let’s take for example you have made
a custom post type called ‘properties’. You create 100,000 posts all attached with
latitude and longitude co-ordinates. You want your users to search for those properties
in a 50 mile radius for example. Because of the method of which WordPress stores
the meta data the query is slow especially when dealing with large amounts of data.

This plugin has been made to retro fit your current WordPress install. You as the
developer select, using filters, what meta data you want to start capturing and 
this plugin will put the data in a table better optimized for storing latitude and
longitude co-ordinates. Upon plugin activate existing data will be index and any
data from then on.

Usage:
 Before activating set what meta keys you want this plugin to capture by 
using the filter ‘sc_geodatastore_meta_keys’. Your latitude and longitude values
have to be stored in a single meta field like: `51.507334,-0.127682`

Example usage of the filter:

    ```
    add_filter( 'sc_geodatastore_meta_keys', 'homes_for_sale_geodata' );
    function homes_for_sale_geodata( $keys )
    {
        $keys[] = "properties_address_coords";
        return $keys;
    }
    ```

Notice:
 This plugin is currently limited to only allowing one pair of co-ordinates
per post. Maybe in a later version I will allow multiple pairs per post, but since
this plugin was made to serve my purpose and it serves it well I see no reason to
build upon it yet.

## 安裝方式

 * Upload to plugins dir
 * Activate plugin
 * Add `sc_geodatastore_meta_keys` filter to your functions of plugin file to set
   what meta data keys to capture.

## 使用者評論

這個外掛目前沒有任何使用者評論。

## 參與者及開發者

以下人員參與了開源軟體〈Geo Data Store〉的開發相關工作。

參與者

 *   [ Scott Cariss ](https://profiles.wordpress.org/l3rady/)

[將〈Geo Data Store〉外掛本地化為台灣繁體中文版](https://translate.wordpress.org/projects/wp-plugins/geo-data-store)

### 對開發相關資訊感興趣？

任何人均可[瀏覽程式碼](https://plugins.trac.wordpress.org/browser/geo-data-store/)、
查看 [SVN 存放庫](https://plugins.svn.wordpress.org/geo-data-store/)，或透過 [RSS](https://plugins.trac.wordpress.org/log/geo-data-store/?limit=100&mode=stop_on_copy&format=rss)
訂閱[開發記錄](https://plugins.trac.wordpress.org/log/geo-data-store/)。

## 變更記錄

#### 2.0.3

 * Fixed typo in SQL query preventing data store being updated from meta updates.

#### 2.0.2

 * Fixed typo in SQL query preventing data store being updated from meta updates.

#### 2.0.1

 * Mostly rewritten.
 * Now only supports co-ordinates to be stored in a single meta field (Storing in
   separate meta fields wasn’t really workable without causing problems with removing
   rows from the store on post delete)
 * Entries in data store are now removed when meta data is deleted or post with 
   meta data is deleted.

#### 1.3

 * — Never Publicly Released —
 * Fixed query in getPostIDsByRange() to use correct table name, not `t`.
 * Fixed PHP notice on activation. Thanks @Kaiser http://chat.stackexchange.com/
   transcript/message/2758673#2758673
 * Now hooking into `update_postmeta` and `delete_postmeta`. Credits to @sebastien.
   b for this http://wordpress.stackexchange.com/a/26438/4610
 * Table now stores meta_id as needed to achieve above.

#### 1.2

 * Added link on plugin screen that allows you to force a re-index.
 * Added function getPostIDsByRange() that includes ready made SQL for returning
   all post ID’s in order by distance of a given point

#### 1.1

 * Changed DB key not to be UNIQUE but to be INDEX
 * Added function getPostIDsOfInRange() that includes ready made SQL for searching
   for posts by that are within a given radius from a given point

#### 1.0

 * Initial release

## 中繼資料

 *  版本 **2.0.3**
 *  最後更新 **13 年前**
 *  啟用安裝數 **30+**
 *  WordPress 版本需求 ** 3.2 或更新版本 **
 *  已測試相容的 WordPress 版本 **3.4.2**
 *  語言
 * [English (US)](https://wordpress.org/plugins/geo-data-store/)
 * 標籤:
 * [geo](https://tw.wordpress.org/plugins/tags/geo/)[latitude](https://tw.wordpress.org/plugins/tags/latitude/)
   [location](https://tw.wordpress.org/plugins/tags/location/)[longitude](https://tw.wordpress.org/plugins/tags/longitude/)
 *  [進階檢視](https://tw.wordpress.org/plugins/geo-data-store/advanced/)

## 評分

 4.5 星，滿分為 5 星

 *  [  1 個 5 星使用者評論     ](https://wordpress.org/support/plugin/geo-data-store/reviews/?filter=5)
 *  [  1 個 4 星使用者評論     ](https://wordpress.org/support/plugin/geo-data-store/reviews/?filter=4)
 *  [  0 個 3 星使用者評論     ](https://wordpress.org/support/plugin/geo-data-store/reviews/?filter=3)
 *  [  0 個 2 星使用者評論     ](https://wordpress.org/support/plugin/geo-data-store/reviews/?filter=2)
 *  [  0 個 1 星使用者評論     ](https://wordpress.org/support/plugin/geo-data-store/reviews/?filter=1)

[Your review](https://wordpress.org/support/plugin/geo-data-store/reviews/#new-post)

[查看全部使用者評論](https://wordpress.org/support/plugin/geo-data-store/reviews/)

## 參與者

 *   [ Scott Cariss ](https://profiles.wordpress.org/l3rady/)

## 技術支援

使用者可在技術支援論壇提出意見反應或使用問題。

 [檢視技術支援論壇](https://wordpress.org/support/plugin/geo-data-store/)

## 贊助

想要支援這個外掛的發展嗎？

 [ 贊助這個外掛 ](http://l3rady.com/donate)