view ChangeLog @ 1539:5bf0afdae932

updated postgres/postgis jdbc so that it is compliant with the new versions of postgresql and postgis
author Konstantina Bereta <>
date Tue Oct 10 17:41:06 2017 +0300 (2017-10-10)
parents 38b0c0a12614
children 4c2fcc026c4c
line source
1 Wed Oct 04 11:55:13 2017 +0300
3 * Bug #82 fixed : Added capability to Endpoint for the user to supply
4 and store his unique Google Maps API Key. The context path of the
5 endpoint is not restricted when a Key is provided. Users that do not
6 supply a key can still run the application as before.
8 Wed Mar 11 21:02:48 2015 Pyravlos Team
10 * Bug #73, modified appendBuffer function to take the srid into
11 consideration even if the argument is a constant (wktLiteral
12 or strdf literal)
14 * Update jar references on scripts used by the debian packaging.
15 Previously these references pointed only (incorrectly) to
18 * Updated package names (since repositories cannot include capital
19 letters + runtime and endpoint-exec must have different names
21 * Version 3.3.1 released.
23 * Bug #58, added script that is invoked my maven to also update the
24 version described in the deb/control file of the runtime and
25 endpoint-exec components.
27 * Related to bug #58, but it generally enhances Strabon; The runtime
28 component has also been debianized. Dependencies are added to
29 /usr/share/jdeb/lib/strabon-runtime. ClassPath and strabon script
30 have also been updated accordingly (strabon-cmd)
32 * Bug #58: Maven creates the debian package conditionally. Use
33 -Ddebian=true in the mvn package command.
35 * Bug #58: Added dependencies - java, postgresql, tomcat. Also, added
36 a strabon-init script that detects the postgis installation path
37 and sets up the template_postgis. Finally the script creates a db
38 called "endpoint" (assuming it does not already exist) that is used
39 for the strabon-endpoint command.
41 * Fixed an issue that returned null SRID when unmarshalling GML geometries if
42 the SRID did not follow one of the supported formats by GML-JTS. To fix that
43 we added a function that handles these cases by reading the userData variable
44 that JTS provides.
46 * Fixed a bug that would return no results when a variable that results
47 from a BIND clause appears in the FILTER or in the projection of a
48 query and is inside a spatial function.
49 (bug #78:
51 * Fixed the precision of the geometry literals in GeoJSON writer. Now,
52 this defaults to the precision model of JTS (equals to 16). Prior to
53 this it was fixed to 4.
55 * Now the GeoJSON writer is aware of the kind of typed literals (e.g.,
56 numeric, boolean, calendar, etc.) and prints the corresponding
57 values according to these types.
59 * Fixed a bug that would not return the correct result or would fail
60 when a spatial function involved a constant and a variable.
61 (bug #74:
63 * Fixed a bug that would not return the correct spatial datatype of a
64 projected geometry literal stored in the database.
65 (bug #71:
67 * Now, geometries expressed in CRS84 and a `geo:wktLiteral' datatype
68 are assigned the correct CRS, i.e., EPSG:4326 with a longitude
69 latitude axis order.
71 * Now, we report a parse error when a constant geometry given in a
72 SELECT or HAVING clause is not well-formed according to the WKT
73 specification.
74 (bug #69:
76 * Function `geof:convexHull' is now supported in a Having clause.
78 * Fixed older implementation of `strdf:distance' that would expect two
79 arguments instead of three when present in a HAVING clause.
81 * Fixed a bug that would cause a class cast exception for grounded
82 expressions with function nesting in the SELECT or HAVING clause.
84 * Fixed a bug in which `postgis:ST_Centroid' did not work in the SELECT
85 clause with input geometries from the database.
87 * Fixed a bug that `geof:getSRID' would return an integer instead of a
88 the URI corrresponding to the CRS that the input geometry was
89 expressed.
90 (bug #32:
92 * Fixed a bug that would raise an exception for queries involving two
93 UNION graph patterns and a projection to a predicate or a URI in
94 general.
95 (bug #53:
97 Wed Sep 17 20:14:12 2014 Pyravlos Team
99 * Version 3.2.10 released.
101 * The test suite of Strabon has now reached a mature level. It
102 contains tests for both stSPARQL and GeoSPARQL query languages and
103 most of the compliance tests covered in the specification of
104 GeoSPARQL (well, only those tests for the components that we have
105 chosen to implement).
107 * The endpoint now parses Accept headers with multiple values and uses
108 the first mimetype corresponding to a valid stSPARQLQueryResultFormat.
109 (bug #64:
111 * The endpoint now registers a handler for SIGTERM signals, so that if
112 it is run from the command-line (endpoint-exec), then the closing of
113 the connection will be ultimately called.
114 (bug #40:
116 * Strabon goes debian v1. the endpoint-exec jar is now given in a .deb
117 format. By dpkg-ing it, one can run a stand alone strabon endpoint
118 locally.
119 (bug #45
121 * Fixed a bug in which Strabon hanged when a unary spatial construct
122 had a ternary spatial construct as argument.
123 (bug #45
125 * Fixed a bug according to which spatial functions in ORDER BY were not
126 evaluated at all.
127 (bug #62:
129 * Fixed a bug according to which spatial boolean functions appearing
130 in the SELECT clause were raising a NULL pointer exception.
131 (bug #34:
133 * Fixed a bug in queries that contain variables that exist inside
134 spatial functions in select and do not exist in the where clause
135 made Strabon throw a NULL pointer exception.
136 (bug #51
138 * Various changes in the interface and behavior of Strabon Endpoint:
139 - Revised the logos and the sample queries.
140 - Results query limit is set to zero (unlimited).
141 - Users can now store RDF data that is present in a file on the
142 client side (the file is uploaded to the server).
143 - Credentials are now required for uploading files or executing
144 UPDATE queries, unless Strabon Endpoint runs locally (localhost).
145 - When viewing the results of queries in HTML, any URI is now an
146 active link to itself. Previously, that URI was being DESCRIBEd
147 and one was being transferred to a page viewing the result of the
148 DESCRIBE query.
149 - The DESCRIBE functionality can now be accessed through the menu bar.
151 * Fixed a bug where strdf:intersection function did not work as an
152 aggregate when used without 'GROUP BY'.
153 (bug #46
156 Sat Oct 19 23:37:23 2013 Pyravlos Team
158 * Version 3.2.9 released.
160 * Added support for the following google chart types: PieChart,
161 AreaChart and ColumnChart to strabon endpoint.
163 * Added Timemap as new results format in Strabon endpoint. This
164 option displays results in a map and a timeline on the same time,
165 using the Timemap js library (
166 The KMLWriter has been extended for that purpose, by transforming
167 dateTime values that are included in the result set into the respective
168 TimeStamp KML primitive (
169 In the "temporals" branch, the values of the strdf:period datatype
170 are converted into the respective KML TimeSpan primitive.
172 * Added extension function <> which is
173 mapped to the ST_Centroid(geometry) extension function of PostGIS.
174 See also: <>.
176 * Added extension function <> which is
177 mapped to the ST_MakeLine(geometry, geometry) extension function of
178 PostGIS. See also: <>.
180 * Added PostGIS vocabulary class.
182 * Added support of all SPARQL result types provided by Sesame (json,
183 xml, csv, tsv, binary). To get the respective writer, just prepend the
184 string "SPARQL/", e.g., "SPARQL/JSON". This is to ensure that we
185 support all SPARQL result formats of the SPARQL Protocol.
187 * Fixed a bug where a non-implemented extension function would make
188 Strabon throw a NULL pointer exception. Now we get away with it
189 through a warning.
191 * Strabon endpoint now publishes the URIs of the supported units of
192 measure for use in strdf:distance and geof:distance functions of
193 stSPARQL and GeoSPARQL, respectively. The URIs are those defined by
194 OGC Units of Measure 1.0 specification which may be found at
195 Strabon endpoint publishes
196 the URIs at http://localhost:8080/endpoint/Capabilities.
198 * Created new module with name 'vocab` and artifactId
199 'strabon-vocabulary` and moved there. Other
200 vocabularies have been added as well, such as Simple Features, and
201 GeoSPARQL.
203 * Strabon endpoint now publishes the URIs of the supported extension
204 functions for stSPARQL and GeoSPARQL. One should access them by
205 hitting the link http://localhost:8080/endpoint/Capabilities.
207 * Support for parsing EPSG URIs in geometry literals with datatype
208 geo:wktLiteral.
209 (bug #33:
211 * Endpoint Client now supports querying of Virtuoso and Parliament endpoints.
213 * Endpoint Client now supports store and update operations, but only
214 for Strabon Endpoints.
216 * GeoSPARQL functions sfCrosses, sfOverlaps, ehOverlaps do not use the
217 ST_Relate PostGIS function (bug #24:
219 * All Simple Features functions of GeoSPARQL do not use the ST_Relate
220 PostGIS function
222 * Added diffTime function. This function performs the difference
223 between two literals of xsd:time datatype and returns a literal of
224 the xsd:time datatype as well.
226 * Added a testsuite package in default branch. Full tester guide can be found
227 in README. Among other, most of GeoSPARQL compliance tests
228 (, pg. 53) have been
229 implemented.
231 * Changed the definition and implementation of strdf:distance function, by
232 adopting the definition of GeoSPARQL.
233 (bug #23:
235 * Changed the definition and implementation of strdf:buffer function, by
236 adopting the definition of GeoSPARQL.
237 (bug #35:
239 * Added geof:distance and geof:buffer functions, which have the same definition
240 with strdf:distance and strdf:buffer respectively.
241 (bug #32:
243 * Added a download button when performing describe and construct queries at the
244 endpoint.
245 (bug #38:
247 * Fixed a bug, where XMLWriter and TSVWriter did not return geometries with the
248 SRID.
249 (bug #47:
251 * Fixed a bug where the GeoSPARQL construct functions did not return the datatype
252 geo:wktLiteral datatype but strdf:WKT.
254 Tue Mar 26 13:28:26 2013 Pyravlos Team
256 * Version 3.2.8 released.
258 * Added support for handling (storing/querying) GeoSPARQL datatypes.
259 (bug #31:
261 * Fixed a bug in StoreOp that wouldn't close the connection, neither
262 rollback the transaction upon an exception. This had as a side effect
263 the abnormal termination of StoreOp (through for example the use of
264 Ctrl-C signal) which was leaving the database locked.
266 * Fixed bug where spatial aggregates (e.g., union) didn't work as
267 expected when the query didn't contain a `GROUP BY' clause.
268 (bug #22:
270 * Updated GeoSPARQL namespaces and fixed function names to comply with
271 the GeoSPARQL specification.
272 (bug #25:
274 Wed Jan 09 18:06:41 2013 Pyravlos Team
276 * Version 3.2.7 released.
278 * Add an extension function
279 <> for computing the
280 span (in milliseconds) between two timestamps.
282 * Added an <endpoint-exec> module. This module builds an executable jar file
283 with an embedded Apache Tomcat 7. To create and run the executable jar just
284 type:
285 $ mvn clean package
286 $ java -jar endpoint-exec/target/strabon-endpoint-executable-*.jar
288 * Modified strabon script and postgis/monetdb.StoreOP class to get an
289 option for storing a RDF file in a named graph. Moreover, the RDF
290 format of the input RDF file now is given as an option (still, if it
291 is missing, it is assumed that the input is in N-TRIPLES format). The
292 option for the format is -f and the option for the named graph is -g
293 (takes a URI as an argument).
295 * Modified the names of the stSPARQL extension functions that
296 utilize the minimum bounding boxes of the involved geometries.
298 Tue Dec 11 19:33:45 2012 Pyravlos Team
300 * Version 3.2.6 released.
302 * Modified the names of the stSPARQL extension functions to comply
303 with the OGC Simple Features Access standard.
305 Tue Dec 11 00:11:43 2012 Pyravlos Team
307 * Version 3.2.5 released.
309 * Added support for querying temporal information. This functionality
310 may be found in the `temporals' branch.
312 The datatypes <> and
313 <> are used to
314 represent periods and instants respectively.
316 The valid time time of triples is represented using quadtruples,
317 with the valid time annotation(instant or period) being the
318 fourth element of the quad. In the same way, temporal triple
319 patterns are used in queries to retrieve the valid time of
320 triples.
322 Some functions have been renamed (their URIs have changed) to
323 follow the names of the respective relations of Allen's
324 interval algebra and other functions have been added.
326 The following temporal functions are supported:
327 during, periodOverlaps, equalsPeriod, nequalsPeriod, adjacent,
328 before, after, overleft, overright, meets, starts, finishes,
329 period_intersect, period_union, preceding_period, and
330 succeeding_period.
332 * Changed behaviour of Strabon and Strabon Endpoint for connecting to
333 a spatially-enabled database. Only one instance of Strabon is allowed
334 at a time.
336 * Implemented a Java client for Strabon Endpoint. The client should be
337 used only with endpoint versions >=3.2.5. The implementation may be
338 found int the `endpoint-client' submodule of maven. Currently, only
339 querying of Strabon Endpoints is supported.
341 * Added support for requesting the capabilities of Strabon Endpoint
342 (fixes Bug #20 <>). See
343 changesets f840796400bf and ?<TBC>? for specific details and how you
344 can determine the capabilities of older endpoints (versions <= 3.2.4).
346 * Updated KML writer to include the projected variables of an stSPARQL
347 query in "ExtendedData" and "Data" tags. This is the proper way to
348 do it if we need to convert a KML to a ESRI shapefile and also include
349 such information as attributes for a feature. See related pages from
350 KML specification:
351 <>
352 <>
354 * Added user authentication for storing RDF data through Strabon
355 Endpoint. The credentials are specified in
356 WEB-INF/ file.
358 * Strabon Endpoints now limits the number of the results to a maximum
359 one. The maximum number is specified in the beans.xml file. This
360 corresponds to parameter "maxLimit". The endpoint script has also been
361 updated correspondingly; the limit can be given using the option "-l".
362 One can disable limiting of query results, by setting the "maxLimit"
363 parameter to 0. Addresses Bug #6
364 (<>).
366 * Added "Known Issues" section to README.
368 * Added -m (more memory) and -M (much more memory) options in strabon
369 script for out-of-memory exceptions.
371 * Fixed Bug #10 (<>). Now
372 KMLWriter handles more geometric types (other than polygons). See
373 changeset 9a3bfee64a39.
375 * Menu and navigation in Strabon Endpoint has changed to use jquery.
376 The menu is now populated using the queries placed inside the beans.xml.
378 * Added BrowseBean and browse.jsp for browsing the RDF data using the
379 Strabon Endpoint.