RE: Windows Service

[Pires, Guilherme]

Hello,
4 words:  Non Sucking Service Manager (https://nssm.cc/) :)
Enjoy
Guilherme Pires | Principal Architect
Portugal | CGI

-Original Message-
From: Cannon, Steven [mailto:steven.can...@petrotechnics.com] 
Sent: quinta-feira, 3 de Março de 2016 19:34
To: solr-user@lucene.apache.org
Subject: Windows Service

Hi,

I am trying to install Solr into our Windows Server 2008 Environment so that it 
uses a Windows Service to start/ stop - but am having problems getting it 
configured.

I am using Solr v5.2.1 with Java 7.

Can anyone help? :)

Regards,

Steve


Steve Cannon | Enterprise Implementation Architect Petrotechnics Limited

 www.petrotechnics.com


__
Any opinions expressed in this email are those of the author and not 
necessarily those of Petrotechnics. If you are not the intended recipient of 
this email, please delete it and notify the sender. For quality assurance 
purposes, Petrotechnics may monitor incoming business communications. All email 
and attachments are scanned and free from viruses, although recipients are 
advised in accordance with best practise to confirm this for themselves.
__

RE: Indexing and Querying MS SQL Server 2012 Spatial

[Pires, Guilherme]

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.

Securing SOLR REST API

[Pires, Guilherme]

Hello Everyone,

I have been developing several solutions, mainly geospatial, that include solr.
The availability of the restful services seem to bother a lot of people. Mainly 
IT security, of course.

How can I guarantee that Solr services are only 'called' from my web 
html5/jquery based application?
Any ideas?

Thanks
Guilherme
GIS Solution Specialist

RE: solr 4.1 spatial with JTS - spatial query withitin a WKT polygon contained within another query ...

[Pires, Guilherme]

Hello David,

Thanks for your response.
I'm working deeply in this and it's fully decided that solr 4.1 + JTS is going 
to be supporting the map navigation for a 'public facing' GIS solution, i.e. 
will deliver the objects return by a bounding box intersection. Initially 
decided to index EVERYTHING and it worked fine. But this is in dev because I'm 
thinking, for production environment, I'll index only points and the (polygons 
and/or lines) pre-calculated bounds. I can live with the error of intersecting 
the bounds of an object that is not going to be showing in the map. 

Besides the navigation, I'm also querying back solr with points in polygon 
intersection for thematic mapping, heatmaps, clustering, etc. but for that I 
don't need the polygon index. On the other hand, If I later want to do some 
polygon on polygon intersection it might be handy to have a different field for 
indexing the polygon ... 

Can you give me a bit more detail on your idea of (...) writing such a Qparser 
should be pretty easy for your own needs (...)


Thanks
Guilehrme

-Original Message-
From: Smiley, David W. [mailto:dsmi...@mitre.org] 
Sent: quarta-feira, 27 de Fevereiro de 2013 8:26
To: solr-user@lucene.apache.org
Subject: Re: solr 4.1 spatial with JTS - spatial query withitin a WKT polygon 
contained within another query ...

Hi Guilherme,

That's a neat idea for a feature.  It'd be nice if there was a proper Solr
Qparser for these fields because that would then make a nice extension
point to further dereference the shape reference from the index itself.
There is a JIRA issue for that.  At least writing such a Qparser should be
pretty easy for your own needs.  In my spatial app, the polygons aren't in
the index so I wouldn't use it but we do have an ongoing problem of
constantly re-sending large polygons that repeatedly need to get re-parsed.

~ David Smiley

On 2/15/13 1:22 PM, Pires, Guilherme guilherme.pi...@cgi.com wrote:

Hello,

Thanks for the suggestion.

I actually solved the issue using POST and xmhttp.send(query). However I
think the most important question is do I really need to query an object
to obtain its wkt polygon and then send that polygon again to enquiry
solr geographically? Wouldn't be perfect if I could ...
Geo:intersects(anonject.polygon) ?

Thanks
Guilherme

De: Erick Erickson [erickerick...@gmail.com]
Enviado: sexta-feira, 15 de Fevereiro de 2013 13:20
Para: solr-user@lucene.apache.org
Assunto: Re: solr 4.1 spatial with JTS - spatial query withitin a WKT
polygon contained within another query ...

I've seen references to upping the packet limit that your servlet
container
allows, but
I don't have the details offhand. It's possible that you're never even
getting to Solr,
looking at the solr log and seeing if anything gets there when you issue
that request
should help.

Best
Erick


On Thu, Feb 14, 2013 at 6:12 AM, Pires, Guilherme
guilherme.pi...@cgi.comwrote:

 Hello Everyone,

 I've been integrating Solr 4.1 into a Web GIS solution and it's working
 great.
 I have implemented JTS within Solr 4.1 and indexed thousands of WKT
 polygons provided by XML document genereated by a GE's GIS Core system.
 Everything seems to working out great.

 Now I have a feature where I want to query solr with
  geo:intersects((POLYGON(...  with a polygon too big to send via xmlhttp
 object. I'm getting a http 505 error.

 1.  Is there any other way of sending this huge string back to solr?
 (I've tried GET and POST)
 2.  This polygon was the result of a previous query so, is there a
  way of query inside a query? Something like ,...
 fq=geo:intersects(another query.spatialfield_with_the_wkt_polygon) ?
 Thanks
 Guilherme

RE: solr 4.1 spatial with JTS - spatial query withitin a WKT polygon contained within another query ...

[Pires, Guilherme]

Hello,

Thanks for the suggestion.

I actually solved the issue using POST and xmhttp.send(query). However I think 
the most important question is do I really need to query an object to obtain 
its wkt polygon and then send that polygon again to enquiry solr 
geographically? Wouldn't be perfect if I could ... 
Geo:intersects(anonject.polygon) ?

Thanks
Guilherme

De: Erick Erickson [erickerick...@gmail.com]
Enviado: sexta-feira, 15 de Fevereiro de 2013 13:20
Para: solr-user@lucene.apache.org
Assunto: Re: solr 4.1 spatial with JTS - spatial query withitin a WKT polygon 
contained within another query ...

I've seen references to upping the packet limit that your servlet container
allows, but
I don't have the details offhand. It's possible that you're never even
getting to Solr,
looking at the solr log and seeing if anything gets there when you issue
that request
should help.

Best
Erick


On Thu, Feb 14, 2013 at 6:12 AM, Pires, Guilherme
guilherme.pi...@cgi.comwrote:

 Hello Everyone,

 I've been integrating Solr 4.1 into a Web GIS solution and it's working
 great.
 I have implemented JTS within Solr 4.1 and indexed thousands of WKT
 polygons provided by XML document genereated by a GE's GIS Core system.
 Everything seems to working out great.

 Now I have a feature where I want to query solr with
  geo:intersects((POLYGON(...  with a polygon too big to send via xmlhttp
 object. I'm getting a http 505 error.

 1.  Is there any other way of sending this huge string back to solr?
 (I've tried GET and POST)
 2.  This polygon was the result of a previous query so, is there a
  way of query inside a query? Something like ,...
 fq=geo:intersects(another query.spatialfield_with_the_wkt_polygon) ?
 Thanks
 Guilherme

solr 4.1 spatial with JTS - spatial query withitin a WKT polygon contained within another query ...

[Pires, Guilherme]

Hello Everyone,

I've been integrating Solr 4.1 into a Web GIS solution and it's working great.
I have implemented JTS within Solr 4.1 and indexed thousands of WKT polygons 
provided by XML document genereated by a GE's GIS Core system. Everything seems 
to working out great.

Now I have a feature where I want to query solr with  
geo:intersects((POLYGON(...  with a polygon too big to send via xmlhttp object. 
I'm getting a http 505 error.

1.  Is there any other way of sending this huge string back to solr? (I've 
tried GET and POST)
2.  This polygon was the result of a previous query so, is there a  way of 
query inside a query? Something like ,... fq=geo:intersects(another 
query.spatialfield_with_the_wkt_polygon) ?
Thanks
Guilherme

RE: thanks for solr 4.1

[Pires, Guilherme]

Subscribed! Just integrating solr 4.1 in a corporate GIS architecture as we 
speak.
Thanks!

Guilherme Pires 

-Original Message-
From: Bernd Fehling [mailto:bernd.fehl...@uni-bielefeld.de] 
Sent: terça-feira, 29 de Janeiro de 2013 15:34
To: solr-user@lucene.apache.org
Subject: thanks for solr 4.1

Now this must be said, thanks for solr 4.1 (and lucene 4.1)!

Great improvements compared to 4.0.

After building the first 4.1 index I thought the index was broken, but had no 
error messages anywhere.
Why I thought it was damaged?
The index size went down from 167 GB (solr 4.0) to 115 GB (solr 4.1)!!!

Will now move the new 4.1 index to testing stage and after it passes all 
testing it goes online.
Can't wait to see the new stats.

Regards,
Bernd