Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-24 Thread david.w.smi...@gmail.com
On Sun, Aug 24, 2014 at 2:29 AM, Bostic, Alex wrote: > Ok updating my field type to the below, allowed me to index :-) HUGE THANKS > > class="solr.SpatialRecursivePrefixTreeFieldType" > spatialContextFactory="com.spatial4j.core.context.jts.JtsSpatialContextFactory" > geo="false" distErrP

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
line: 301-820-3287 cell line: 301-213-2639 -Original Message- From: Bostic, Alex [mailto:alex.bos...@urs.com] Sent: Sunday, August 24, 2014 2:04 AM To: solr-user@lucene.apache.org Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial Not sure where I copied them from. Remove

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
l line: 301-213-2639 -Original Message- From: david.w.smi...@gmail.com [mailto:david.w.smi...@gmail.com] Sent: Saturday, August 23, 2014 11:22 PM To: solr-user@lucene.apache.org Subject: Re: Indexing and Querying MS SQL Server 2012 Spatial What’s with the double square brackets around your WKT?

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
;com.spatial4j.core.context.jts.JtsSpatialContextFactory" > geo="false" distErrPct="0.025" maxDistErr="0.09" units="degrees" > /> > > Alex Bostic > GIS Developer > URS Corporation > 12420 Milestone Center Drive, Su

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
rmantown, MD 20876 direct line: 301-820-3287 cell line: 301-213-2639 -Original Message- From: Bostic, Alex [mailto:alex.bos...@urs.com] Sent: Saturday, August 23, 2014 2:27 PM To: solr-user@lucene.apache.org Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial Thanks I will try

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
through the DIH query do I return WKT, maybe that's the issue. From: david.w.smi...@gmail.com [david.w.smi...@gmail.com] Sent: Saturday, August 23, 2014 2:03 PM To: solr-user@lucene.apache.org Subject: Re: Indexing and Querying MS SQL Server 2012 Sp

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
ermantown, MD 20876 > direct line: 301-820-3287 > cell line: 301-213-2639 > > > -Original Message- > From: david.w.smi...@gmail.com [mailto:david.w.smi...@gmail.com] > Sent: Saturday, August 23, 2014 9:15 AM > To: solr-user@lucene.apache.org > Subject: Re: Indexing a

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
ssage- From: david.w.smi...@gmail.com [mailto:david.w.smi...@gmail.com] Sent: Saturday, August 23, 2014 9:15 AM To: solr-user@lucene.apache.org Subject: Re: Indexing and Querying MS SQL Server 2012 Spatial The jts-1.13.jar file (other JTS jars that come with it aren’t used) needs to go on the jav

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
:alex.bos...@urs.com] > Sent: Saturday, August 23, 2014 3:53 AM > To: solr-user@lucene.apache.org > Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial > > Hello, I guess I'm closer. But my geom field does not show up in the index. > > I have a table full of polys, stored as S

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
M To: solr-user@lucene.apache.org Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial Hello, I guess I'm closer. But my geom field does not show up in the index. I have a table full of polys, stored as SQL Server Geometry Type. Taken from the example schema I have: .. .. In my

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
e: 301-820-3287 cell line: 301-213-2639 -Original Message- From: Bostic, Alex [mailto:alex.bos...@urs.com] Sent: Wednesday, August 20, 2014 4:41 PM To: solr-user@lucene.apache.org Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial Ok Great, I'm just going to dive in and see

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-20 Thread Bostic, Alex
Pires, Guilherme [mailto:guilherme.pi...@cgi.com] Sent: Wednesday, August 20, 2014 4:30 PM To: solr-user@lucene.apache.org Subject: RE: Indexing and Querying MS SQL Server 2012 Spatial Hello, I've been working with Solr together with JTS and use location_rpt class for the geometry field for a

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-20 Thread Pires, Guilherme
-user@lucene.apache.org Assunto: Re: Indexing and Querying MS SQL Server 2012 Spatial Hi Alex, I guess a spatial tutorial might be helpful, but there isn’t one. There is a sample at the Lucene-spatial layer but not up at Solr. You need to use WKT syntax for line’s and polys, and you may do so as

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-20 Thread david.w.smi...@gmail.com
Hi Alex, I guess a spatial tutorial might be helpful, but there isn’t one. There is a sample at the Lucene-spatial layer but not up at Solr. You need to use WKT syntax for line’s and polys, and you may do so as well for other shapes. And in the schema use location_rpt copied from Solr’s example

Indexing and Querying MS SQL Server 2012 Spatial

2014-08-19 Thread Bostic, Alex
Hello I'm new to Solr: I have a SQL Server 2012 database with spatial columns (points/lines/polys) Do you have any resources to point to for the following Creating a Solr index of a sql server spatial table Bounding Box query (intersect) example, possibly with front-end from GMaps or OpenLayers I