Ok thanks, I am even closer I put jts-1.13.jar here C:\Program Files (x86)\Java\jre7\lib\ext
And removed it from the cmd line when starting solr I no longer get the class not found issues. I removed the jar from the above location and got the error again, so I put it back to confirm I'm past the Not Found issue. My core appears to startup fine, I select my core in the browser manager and Execute a full-import with Clean and Commit checked. That appears to go well. However, I still don't see my geom field as part of my index I do ALSO have the jar in C:\AddSoftware\solr-4.9.0\ocsirasspatial\solr-webapp\webapp\WEB-INF\lib Any other hints are certainly welcome. I think I'm close Alex Bostic GIS Developer URS Corporation 12420 Milestone Center Drive, Suite 150 Germantown, 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 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 haven’t tried to do it using the way you’re doing it. Note that the “lib” directories Solr manages won’t work for some jar’s like this one. I forget but I think putting it in examples/lib works. Unpacking the WAR and putting it in WEB-INF/lib definitely works. ~ David Smiley Freelance Apache Lucene/Solr Search Consultant/Developer http://www.linkedin.com/in/davidwsmiley On Sat, Aug 23, 2014 at 4:36 AM, Bostic, Alex <alex.bos...@urs.com> wrote: > Ok, I was missing > spatialContextFactory="com.spatial4j.core.context.jts.JtsSpatialContextFactory" > > > Now I am getting > > Error loading core:java.util.concurrent.ExecutionException: > java.lang.NoClassDefFoundError: > com/vividsolutions/jts/geom/CoordinateSequenceFactory > > Any help resolving my path issues would be great > > Alex Bostic > GIS Developer > URS Corporation > 12420 Milestone Center Drive, Suite 150 Germantown, 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 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 SQL Server Geometry Type. > > Taken from the example schema I have: > .. > <field name="geom" type="location_rpt" indexed="true" stored="true"/> .. > > In my data-config.xml I have: > <entity name="data" dataSource="ds1" pk="key" > query="SELECT wt.Id, wt.Name, > wt.WorkTypeTypeId,wt.ChildId,wt.CreatedDate,wt.ModifiedDate,wt.Year, > wta.GEOM.STAsText(), wta.OBJECTID > FROM dbo.WorkTypes wt Inner Join dbo.WorkTypeAreas wta ON wt.Id = > wta.WorkTypeId"> > <field column="Id" name="id" /> > <field column="ChildId" name="childid" /> > <field column="WorkTypeTypeId" name="worktypetypeid" /> > <field column="Name" name="name" /> > <field column="CreatedDate" name="createddate" /> > <field column="ModifiedDate" name="modifieddate" /> > <field column="UserId" name="userid" /> > <field column="Year" name="year" /> > <field column="GEOM" name="geom" /> > <field column="OBJECTID" name="objectid" /> > </entity> > > OBJECTID shows up fine in my updated index, gut GEOM does not. The > index was successful and I don't see any errors in the console or the > log (from the web) > > I am starting solr like so: > java -Dsolr.solr.home=c:\AddedSoftware\solr-4.90\ocsirasspatial\solr > -Djetty.class.path=c:\AddedSoftware\solr-4.9.0\jts-1.13\lib -jar > start.jar > > Based on the above, what am I missing to get this to work. Maybe I am > overlooking an issue in the console? > > Thanks > > > Alex Bostic > GIS Developer > URS Corporation > 12420 Milestone Center Drive, Suite 150 Germantown, MD 20876 direct > line: 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 if I can index my data. Does > spatial reference matter? > > Alex Bostic > GIS Developer > URS Corporation > 12420 Milestone Center Drive, Suite 150 Germantown, MD 20876 direct > line: 301-820-3287 cell line: 301-213-2639 > > > -----Original Message----- > 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 for a while now. (However, I must say > that the index grew a lot when used this class instead of the geohash > for simple points ..so use it only if you really need to index > polylines and/or polygons) > > I actually already successfully connected solr to postGis and oracle spatial > via DIH but in this live website ( http://cascaismap.com ) we had a GE > Smallworld as the GIS system so it was easier just to build a sync engine > that periodically queries differences from the GIS and push them into solr > via xml document. This project has already couple of years now so a lot would > be different now. > > In that website, solr provides, obviously, all the text search on the top and > also 70% of the themes available on the treeview on the left (expand in the > red button) that are result of a bounding box query to geometry index in solr. > Something like this : (...)q=bounds:Intersects(-9.463118366688718 > 38.67913579372146 -9.370549969166746 38.7109390712568)(...) > > After this, we actually provided for a different project, a similar sync > mechanism but between in-house solr instances and google maps engine > datastore in the cloud and it works like a charm. > > Guilherme Pires > Geospatial Intelligence @ CGI > guilherme.pi...@cgi.com > > ________________________________________ > De: david.w.smi...@gmail.com [david.w.smi...@gmail.com] > Enviado: quarta-feira, 20 de Agosto de 2014 18:49 > Para: solr-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 well for other shapes. And > in the schema use location_rpt copied from Solr's example schema for > starters, but modified as the ref guide & wiki show to use JTS. > The ref guide, wiki, and I would guess that book should show how to to a > bounding box query using {!bbox} - it's pretty simple. > > ~ David Smiley > Freelance Apache Lucene/Solr Search Consultant/Developer > http://www.linkedin.com/in/davidwsmiley > > > On Tue, Aug 19, 2014 at 11:25 AM, Bostic, Alex <alex.bos...@urs.com> wrote: > >> 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'm currently reading Apache Solr Beginner's >> Guide and have reviewed >> https://wiki.apache.org/solr/SolrAdaptersForLuceneSpatial4 >> I am able to index and query my non spatial data, I am just looking >> for some resource that may have some more detail about how to set everything >> up. >> I can provide more detail if needed. >> Thanks >> >> Alex Bostic >> GIS Developer >> URS Corporation >> 12420 Milestone Center Drive, Suite 150 Germantown, MD 20876 direct >> line: 301-820-3287 cell line: 301-213-2639 >> >> >> >> This e-mail and any attachments contain URS Corporation confidential >> information that may be proprietary or privileged. If you receive >> this message in error or are not the intended recipient, you should >> not retain, distribute, disclose or use any of this information and >> you should destroy the e-mail and any attachments or copies. >> > > > This e-mail and any attachments contain URS Corporation confidential > information that may be proprietary or privileged. If you receive this > message in error or are not the intended recipient, you should not retain, > distribute, disclose or use any of this information and you should destroy > the e-mail and any attachments or copies.
