CREATE TABLE members
(
  id serial NOT NULL,
  name character varying(100),
  org_group character varying(100),
  contact_name character varying(100),
  address character varying(120),
  city character varying(75),
  zip character varying(20),
  lat double precision,
  lng double precision,
  earthloc cube,
  org_type character varying(200),
  contact_phone character varying(25),
  CONSTRAINT members_pkey PRIMARY KEY (id )
)
WITH (
  OIDS=FALSE
);
ALTER TABLE members
  OWNER TO client2;

-- Index: earthloc_idx

-- DROP INDEX earthloc_idx;

CREATE INDEX earthloc_idx
  ON members
  USING btree
  (earthloc );






EXPLAIN ANALYZE
SELECT
	"Member"."name" AS "Member__name",
	--round ( CAST ( (earth_distance(earthloc, ll_to_earth(43.0367907637681, -89.4037345224754)) / 1609.344) as numeric)  , 2) AS "Member__distance",
	earth_distance(earthloc, ll_to_earth(43.0367907637681, -89.4037345224754)) AS "Member__distance",
	"Member"."org_group" AS "Member__org_group",
	"Member"."contact_name" AS "Member__contact_name",
	"Member"."address" AS "Member__address",
	"Member"."city" AS "Member__city",
	"Member"."zip" AS "Member__zip",
	"Member"."lat" AS "Member__lat",
	"Member"."lng" AS "Member__lng",
	"Member"."org_type" AS "Member__org_type",
	"Member"."contact_phone" AS "Member__contact_phone"
	--"Member"."earthloc" AS "Member__earthloc",

FROM
	members AS "Member"
WHERE
	earth_box(ll_to_earth(43.0367907637681, -89.4037345224754), 8047) @> earthloc
ORDER BY
	"Member__distance"
LIMIT 10


Sort  (cost=193.76..193.77 rows=5 width=189) (actual time=4.041..4.221 rows=121 loops=1)
  Sort Key: (sec_to_gc(cube_distance((earthloc)::cube, '(48514.5932762172, -4661650.21416286, 4352894.51414327)'::cube)))
  Sort Method: quicksort  Memory: 57kB
  ->  Seq Scan on members "Member"  (cost=0.00..193.70 rows=5 width=189) (actual time=0.738..3.567 rows=121 loops=1)
        Filter: ('(40467.5938099192, -4669697.21362916, 4344847.51467698),(56561.5927425152, -4653603.21469656, 4360941.51360957)'::cube @> earthloc)
"Total runtime: 4.499 ms