Re: [WKT] Spatial Searching
On Mar 29, 2011, at 8:12 AM, Mattmann, Chris A (388J) wrote: >> >> RE SIS... I wonder how the expertise on that project compares to that of >> JTS's Martin Davis -- an expert, and the library has been in use for 10 >> years. > > Time will tell. I'd favor the Apache model where instead of name dropping we > rely on the collective expertise p a group of like minded individuals Lucene was originally the work of one expert. That's not a bad way to start. wunder -- Walter Underwood
Re: [WKT] Spatial Searching
> > It's not saying specifically we can't compile against LGPL, it's ambiguously > saying "include". I take that to mean the result of the build -- e.g. class > and jar files, which may not include LGPL. This uncertainty was was enough to make it a non starter for us. > RE SIS... I wonder how the expertise on that project compares to that of > JTS's Martin Davis -- an expert, and the library has been in use for 10 years. Time will tell. I'd favor the Apache model where instead of name dropping we rely on the collective expertise p a group of like minded individuals. Cheers, Chris > > ~ David > > From: Mattmann, Chris A (388J) [chris.a.mattm...@jpl.nasa.gov] > Sent: Tuesday, March 29, 2011 1:00 AM > To: solr-user@lucene.apache.org > Cc: Adam Estrada > Subject: Re: [WKT] Spatial Searching > > LGPL licenses and Apache aren't exactly compatible, see: > > http://www.apache.org/legal/3party.html#transition-examples-lgpl > http://www.apache.org/legal/resolved.html#category-x > > In practice, this was the reason we started the SIS project. > > Cheers, > Chris > > On Mar 28, 2011, at 11:16 AM, Smiley, David W. wrote: > >> (This is one of those messages that I would have responded to at the time if >> I only noticed it.) >> >> There is not yet indexing of arbitrary shapes (i.e. your data can only be >> points), but with SOLR-2155 you can query via WKT thanks to JTS. If you >> want to index shapes then you'll have to wait a month or two for work that >> is underway right now. It's coming; be patient. >> >> I don't see the LGPL licensing as a problem; it's *L*GPL, not GPL, after >> all. In SOLR-2155 the patch I take measures to download this library >> dynamically at build time and compile against it. JTS need not ship with >> Solr; the user can get it themselves if they want this capability. Non-JTS >> query shapes should work without the presence of JTS. >> >> ~ David Smiley >> Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/ >> >> On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: >> >>> I just came across a ~nudge post over in the SIS list on what the status is >>> for that project. This got me looking more in to spatial mods with Solr4.0. >>> I found this enhancement in Jira. >>> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >>> mentions that he's already integrated JTS in to Solr4.0 for querying on >>> polygons stored as WKT. >>> >>> It's relatively easy to get WKT strings in to Solr but does the Field type >>> exist yet? Is there a patch or something that I can test out? >>> >>> Here's how I would do it using GDAL/OGR and the already existing csv update >>> handler. http://www.gdal.org/ogr/drv_csv.html >>> >>> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >>> This converts a shapefile to a csv with the geometries in tact in the form >>> of WKT. You can then get the data in to Solr by running the following >>> command. >>> curl >>> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >>> There are lots of flavors of geometries so I suspect that this will be a >>> daunting task but because JTS recognizes each geometry type it should be >>> possible to work with them. >>> Does anyone know of a patch or even when this functionality might be >>> included in to Solr4.0? I need to query for polygons ;-) >>> Thanks, >>> Adam > > > ++ > Chris Mattmann, Ph.D. > Senior Computer Scientist > NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA > Office: 171-266B, Mailstop: 171-246 > Email: chris.a.mattm...@nasa.gov > WWW: http://sunset.usc.edu/~mattmann/ > ++ > Adjunct Assistant Professor, Computer Science Department > University of Southern California, Los Angeles, CA 90089 USA > ++ >
Re: [WKT] Spatial Searching
> Does anyone know of a patch or even when this functionality might be included > in to Solr4.0? I need to query for polygons ;-) check: http://code.google.com/p/lucene-spatial-playground/ This is my sketch / soon-to-be-proposal for what I think lucene spatial should look like. It includes a WKTField that can do complex geometry queries: https://lucene-spatial-playground.googlecode.com/svn/trunk/spatial-lucene/src/main/java/org/apache/lucene/spatial/search/jts/ ryan
RE: [WKT] Spatial Searching
Thanks for the links Chris. I think my approach in SOLR-2155 complies with those rules. The only part that concerns me wether this is true is the rule regarding the default action of a build script: YOU MUST NOT distribute build scripts or documentation within an Apache product with the purpose of causing the default/standard build of an Apache product to include any part of a prohibited work. It's not saying specifically we can't compile against LGPL, it's ambiguously saying "include". I take that to mean the result of the build -- e.g. class and jar files, which may not include LGPL. RE SIS... I wonder how the expertise on that project compares to that of JTS's Martin Davis -- an expert, and the library has been in use for 10 years. ~ David From: Mattmann, Chris A (388J) [chris.a.mattm...@jpl.nasa.gov] Sent: Tuesday, March 29, 2011 1:00 AM To: solr-user@lucene.apache.org Cc: Adam Estrada Subject: Re: [WKT] Spatial Searching LGPL licenses and Apache aren't exactly compatible, see: http://www.apache.org/legal/3party.html#transition-examples-lgpl http://www.apache.org/legal/resolved.html#category-x In practice, this was the reason we started the SIS project. Cheers, Chris On Mar 28, 2011, at 11:16 AM, Smiley, David W. wrote: > (This is one of those messages that I would have responded to at the time if > I only noticed it.) > > There is not yet indexing of arbitrary shapes (i.e. your data can only be > points), but with SOLR-2155 you can query via WKT thanks to JTS. If you want > to index shapes then you'll have to wait a month or two for work that is > underway right now. It's coming; be patient. > > I don't see the LGPL licensing as a problem; it's *L*GPL, not GPL, after all. > In SOLR-2155 the patch I take measures to download this library dynamically > at build time and compile against it. JTS need not ship with Solr; the user > can get it themselves if they want this capability. Non-JTS query shapes > should work without the presence of JTS. > > ~ David Smiley > Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/ > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam ++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: chris.a.mattm...@nasa.gov WWW: http://sunset.usc.edu/~mattmann/ ++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++
Re: [WKT] Spatial Searching
LGPL licenses and Apache aren't exactly compatible, see: http://www.apache.org/legal/3party.html#transition-examples-lgpl http://www.apache.org/legal/resolved.html#category-x In practice, this was the reason we started the SIS project. Cheers, Chris On Mar 28, 2011, at 11:16 AM, Smiley, David W. wrote: > (This is one of those messages that I would have responded to at the time if > I only noticed it.) > > There is not yet indexing of arbitrary shapes (i.e. your data can only be > points), but with SOLR-2155 you can query via WKT thanks to JTS. If you want > to index shapes then you'll have to wait a month or two for work that is > underway right now. It's coming; be patient. > > I don't see the LGPL licensing as a problem; it's *L*GPL, not GPL, after all. > In SOLR-2155 the patch I take measures to download this library dynamically > at build time and compile against it. JTS need not ship with Solr; the user > can get it themselves if they want this capability. Non-JTS query shapes > should work without the presence of JTS. > > ~ David Smiley > Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/ > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam ++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: chris.a.mattm...@nasa.gov WWW: http://sunset.usc.edu/~mattmann/ ++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++
Re: [WKT] Spatial Searching
Outstanding! Thanks David...I can't wait to take a look at it. Adam Sent from my iPhone On Mar 28, 2011, at 2:16 PM, "Smiley, David W." wrote: > (This is one of those messages that I would have responded to at the time if > I only noticed it.) > > There is not yet indexing of arbitrary shapes (i.e. your data can only be > points), but with SOLR-2155 you can query via WKT thanks to JTS. If you want > to index shapes then you'll have to wait a month or two for work that is > underway right now. It's coming; be patient. > > I don't see the LGPL licensing as a problem; it's *L*GPL, not GPL, after all. > In SOLR-2155 the patch I take measures to download this library dynamically > at build time and compile against it. JTS need not ship with Solr; the user > can get it themselves if they want this capability. Non-JTS query shapes > should work without the presence of JTS. > > ~ David Smiley > Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/ > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam
Re: [WKT] Spatial Searching
(This is one of those messages that I would have responded to at the time if I only noticed it.) There is not yet indexing of arbitrary shapes (i.e. your data can only be points), but with SOLR-2155 you can query via WKT thanks to JTS. If you want to index shapes then you'll have to wait a month or two for work that is underway right now. It's coming; be patient. I don't see the LGPL licensing as a problem; it's *L*GPL, not GPL, after all. In SOLR-2155 the patch I take measures to download this library dynamically at build time and compile against it. JTS need not ship with Solr; the user can get it themselves if they want this capability. Non-JTS query shapes should work without the presence of JTS. ~ David Smiley Author: http://www.packtpub.com/solr-1-4-enterprise-search-server/ On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > I just came across a ~nudge post over in the SIS list on what the status is > for that project. This got me looking more in to spatial mods with Solr4.0. > I found this enhancement in Jira. > https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David > mentions that he's already integrated JTS in to Solr4.0 for querying on > polygons stored as WKT. > > It's relatively easy to get WKT strings in to Solr but does the Field type > exist yet? Is there a patch or something that I can test out? > > Here's how I would do it using GDAL/OGR and the already existing csv update > handler. http://www.gdal.org/ogr/drv_csv.html > > ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT > This converts a shapefile to a csv with the geometries in tact in the form of > WKT. You can then get the data in to Solr by running the following command. > curl > "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; > There are lots of flavors of geometries so I suspect that this will be a > daunting task but because JTS recognizes each geometry type it should be > possible to work with them. > Does anyone know of a patch or even when this functionality might be included > in to Solr4.0? I need to query for polygons ;-) > Thanks, > Adam
Re: [WKT] Spatial Searching
Thought I would share this on web mapping...it's a great write up and something to consider when talking about working with spatial data. http://www.tokumine.com/2010/09/20/gis-data-payload-sizes/ Adam On Feb 9, 2011, at 7:03 AM, Grant Ingersoll wrote: > The show stopper for JTS is it's license, unfortunately. Otherwise, I think > it would be done already! We could, since it's LGPL, make it an optional > dependency, assuming someone can stub it out. > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam >> >> >> > > -- > Grant Ingersoll > http://www.lucidimagination.com/ >
Re: [WKT] Spatial Searching
Grant, How could i stub this out not being a java guy? What is needed in order to do this? Licensing is always going to be an issue with JTS which is why I am interested in the project SIS sitting in incubation right now. I'm willing to put forth the effort if I had a little direction on how to implement it from the peanut gallery ;-) Adam On Feb 9, 2011, at 7:03 AM, Grant Ingersoll wrote: > The show stopper for JTS is it's license, unfortunately. Otherwise, I think > it would be done already! We could, since it's LGPL, make it an optional > dependency, assuming someone can stub it out. > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam >> >> >> > > -- > Grant Ingersoll > http://www.lucidimagination.com/ >
Re: [WKT] Spatial Searching
Thought I would share this on web mapping...it's a great write up and something to consider when talking about working with spatial data. http://www.tokumine.com/2010/09/20/gis-data-payload-sizes/ Adam On Feb 9, 2011, at 7:03 AM, Grant Ingersoll wrote: > The show stopper for JTS is it's license, unfortunately. Otherwise, I think > it would be done already! We could, since it's LGPL, make it an optional > dependency, assuming someone can stub it out. > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam >> >> >> > > -- > Grant Ingersoll > http://www.lucidimagination.com/ >
Re: [WKT] Spatial Searching
How could i stub this out not being a java guy? What is needed in order to do this? Licensing is always going to be an issue with JTS which is why I am interested in the project SIS sitting in incubation right now. I willing to put forth the effort if I had a little direction from the peanut gallery ;-) Adam On Feb 9, 2011, at 7:03 AM, Grant Ingersoll wrote: > The show stopper for JTS is it's license, unfortunately. Otherwise, I think > it would be done already! We could, since it's LGPL, make it an optional > dependency, assuming someone can stub it out. > > On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > >> I just came across a ~nudge post over in the SIS list on what the status is >> for that project. This got me looking more in to spatial mods with Solr4.0. >> I found this enhancement in Jira. >> https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David >> mentions that he's already integrated JTS in to Solr4.0 for querying on >> polygons stored as WKT. >> >> It's relatively easy to get WKT strings in to Solr but does the Field type >> exist yet? Is there a patch or something that I can test out? >> >> Here's how I would do it using GDAL/OGR and the already existing csv update >> handler. http://www.gdal.org/ogr/drv_csv.html >> >> ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT >> This converts a shapefile to a csv with the geometries in tact in the form >> of WKT. You can then get the data in to Solr by running the following >> command. >> curl >> "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; >> There are lots of flavors of geometries so I suspect that this will be a >> daunting task but because JTS recognizes each geometry type it should be >> possible to work with them. >> Does anyone know of a patch or even when this functionality might be >> included in to Solr4.0? I need to query for polygons ;-) >> Thanks, >> Adam >> >> >> > > -- > Grant Ingersoll > http://www.lucidimagination.com/ >
Re: [WKT] Spatial Searching
The show stopper for JTS is it's license, unfortunately. Otherwise, I think it would be done already! We could, since it's LGPL, make it an optional dependency, assuming someone can stub it out. On Feb 8, 2011, at 11:18 PM, Adam Estrada wrote: > I just came across a ~nudge post over in the SIS list on what the status is > for that project. This got me looking more in to spatial mods with Solr4.0. > I found this enhancement in Jira. > https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David > mentions that he's already integrated JTS in to Solr4.0 for querying on > polygons stored as WKT. > > It's relatively easy to get WKT strings in to Solr but does the Field type > exist yet? Is there a patch or something that I can test out? > > Here's how I would do it using GDAL/OGR and the already existing csv update > handler. http://www.gdal.org/ogr/drv_csv.html > > ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT > This converts a shapefile to a csv with the geometries in tact in the form of > WKT. You can then get the data in to Solr by running the following command. > curl > "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; > There are lots of flavors of geometries so I suspect that this will be a > daunting task but because JTS recognizes each geometry type it should be > possible to work with them. > Does anyone know of a patch or even when this functionality might be included > in to Solr4.0? I need to query for polygons ;-) > Thanks, > Adam > > > -- Grant Ingersoll http://www.lucidimagination.com/
Re: [WKT] Spatial Searching
+1 to David's patch from SOLR-2155. It would be great to implement. Great job using GDAL on converting the WKT Adam! Cheers, Chris On Feb 8, 2011, at 8:18 PM, Adam Estrada wrote: > I just came across a ~nudge post over in the SIS list on what the status is > for that project. This got me looking more in to spatial mods with Solr4.0. > I found this enhancement in Jira. > https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David > mentions that he's already integrated JTS in to Solr4.0 for querying on > polygons stored as WKT. > > It's relatively easy to get WKT strings in to Solr but does the Field type > exist yet? Is there a patch or something that I can test out? > > Here's how I would do it using GDAL/OGR and the already existing csv update > handler. http://www.gdal.org/ogr/drv_csv.html > > ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT > This converts a shapefile to a csv with the geometries in tact in the form of > WKT. You can then get the data in to Solr by running the following command. > curl > "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; > There are lots of flavors of geometries so I suspect that this will be a > daunting task but because JTS recognizes each geometry type it should be > possible to work with them. > Does anyone know of a patch or even when this functionality might be included > in to Solr4.0? I need to query for polygons ;-) > Thanks, > Adam > > > ++ Chris Mattmann, Ph.D. Senior Computer Scientist NASA Jet Propulsion Laboratory Pasadena, CA 91109 USA Office: 171-266B, Mailstop: 171-246 Email: chris.a.mattm...@nasa.gov WWW: http://sunset.usc.edu/~mattmann/ ++ Adjunct Assistant Professor, Computer Science Department University of Southern California, Los Angeles, CA 90089 USA ++
[WKT] Spatial Searching
I just came across a ~nudge post over in the SIS list on what the status is for that project. This got me looking more in to spatial mods with Solr4.0. I found this enhancement in Jira. https://issues.apache.org/jira/browse/SOLR-2155. In this issue, David mentions that he's already integrated JTS in to Solr4.0 for querying on polygons stored as WKT. It's relatively easy to get WKT strings in to Solr but does the Field type exist yet? Is there a patch or something that I can test out? Here's how I would do it using GDAL/OGR and the already existing csv update handler. http://www.gdal.org/ogr/drv_csv.html ogr2ogr -f CSV output.csv input.shp -lco GEOMETRY=AS_WKT This converts a shapefile to a csv with the geometries in tact in the form of WKT. You can then get the data in to Solr by running the following command. curl "http://localhost:8983/solr/update/csv?commit=true&separator=%2C&fieldnames=id,attr1,attr2,attr3,geom&stream.file=C:\tmp\output.csv&overwrite=true&stream.contentType=text/plain;charset=utf-8"; There are lots of flavors of geometries so I suspect that this will be a daunting task but because JTS recognizes each geometry type it should be possible to work with them. Does anyone know of a patch or even when this functionality might be included in to Solr4.0? I need to query for polygons ;-) Thanks, Adam
