RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-24 Thread Bostic, Alex
...@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? Remove them. ~ David Smiley Freelance Apache Lucene/Solr Search Consultant/Developer http

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-24 Thread Bostic, Alex
...@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? Remove them. ~ David Smiley Freelance Apache Lucene/Solr

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 alex.bos...@urs.com wrote: Ok updating my field type to the below, allowed me to index :-) HUGE THANKS fieldType name=location_rpt class=solr.SpatialRecursivePrefixTreeFieldType

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
- From: 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

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
-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: .. field name=geom type

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
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: .. field name=geom type=location_rpt indexed=true

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread Bostic, Alex
: 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 java classpath. I

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
- 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 java

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 Spatial

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread 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 for a correct install. I have many other fields that are indexing fine, I will inspect for further errors and use

Re: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-23 Thread david.w.smi...@gmail.com
-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 for a correct install. I have many other fields that are indexing

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

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-20 Thread Pires, Guilherme
@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 well

RE: Indexing and Querying MS SQL Server 2012 Spatial

2014-08-20 Thread Bostic, Alex
, 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 while now