Project

General

Profile

Statistics
| Revision:

metacat / src @ 3052

Name Size Revision Age Author Comment
  com 2532 over 15 years sgarg renaming enum to catalogEnum to prevent compila...
  edu 3052 over 14 years Matt Jones Modifications to the table definitions to add i...
  perl 2994 over 14 years sgarg added function to get list of projects for NCEA...
  query-client 2824 about 15 years tyburczy Unix port of transform.bat
  spatial 3034 over 14 years perry initial import of changes to metacat source and...
addforeignkeyfortable.sql 135 Bytes 1626 over 17 years Jing Tao Create a foreign key for table accesssubtree.
alter-datafile-for-knbbackup.sql 1.66 KB 2662 over 15 years Jing Tao Add a new sql file to alter control file which ...
clear.sql 312 Bytes 704 almost 20 years berkley added removal of relations
drop-postgres.sql 2.02 KB 2769 about 15 years Matt Jones New SQL tables and db upgrade scripts that defi...
loaddtd.sql 2.36 KB 979 almost 19 years Jing Tao Change every "http://@server@ to "@systemidserv...
loaddtdschema.sql 3.08 KB 3016 over 14 years sgarg Modified the sql commands such that eml-2.0.1 s...
loadschema.sql 476 Bytes 3016 over 14 years sgarg Modified the sql commands such that eml-2.0.1 s...
package-count.sql 373 Bytes 2283 over 16 years Matt Jones Added sql for counting packages.
showdoc.sql 340 Bytes 390 over 20 years Matt Jones Added new utility query to return all of the xm...
sqlcatlist.sql 253 Bytes 123 over 20 years Matt Jones Modifying storage model to use DOM TEXT nodes
sqldoclist.sql 209 Bytes 531 about 20 years Matt Jones Changed utility query to include the user_owner...
sqlnodeslist.sql 94 Bytes 108 over 20 years Matt Jones added utility files and queries
sqlnodesview.sql 358 Bytes 166 over 20 years Matt Jones minor modifications to fix problems introduced ...
sqlrevisions.sql 205 Bytes 203 over 20 years Matt Jones Merged in substantial changes to DBWriter and a...
upgrade-db-to-1.2-postgres.sql 637 Bytes 2276 over 16 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.2.sql 596 Bytes 1827 over 17 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.3-postgres.sql 2.56 KB 2276 over 16 years Matt Jones New schema changes, including upgrade scripts. ...
upgrade-db-to-1.3.sql 1.44 KB 1827 over 17 years Matt Jones Renamed the upgrade sql files to more understan...
upgrade-db-to-1.4-postgres.sql 5.11 KB 2314 over 16 years sgarg Added code that changes the node column size
upgrade-db-to-1.4.sql 4.44 KB 2279 over 16 years Matt Jones Added lines for updating xml_catalog in the upg...
upgrade-db-to-1.5-postgres.sql 6.13 KB 2504 almost 16 years sgarg Making changes in postgres db upgrade script su...
upgrade-db-to-1.5.sql 5.79 KB 2443 almost 16 years sgarg Removed the code which created triggers. Added ...
upgrade-db-to-1.6-postgres.sql 7.64 KB 2969 almost 15 years sgarg Removing the comments from postgres upgrade scr...
upgrade-db-to-1.6.sql 9.37 KB 3016 over 14 years sgarg Modified the sql commands such that eml-2.0.1 s...
upgrade-db-to-1.7-postgres.sql 509 Bytes 3052 over 14 years Matt Jones Modifications to the table definitions to add i...
upgrade_db_to_1_5.java 4.83 KB 2504 almost 16 years sgarg Making changes in postgres db upgrade script su...
xmlpackage.sql 1.94 KB 439 over 20 years berkley sql file defining the table structure for eml-p...
xmltables-postgres.sql 17 KB 3052 over 14 years Matt Jones Modifications to the table definitions to add i...
xmltables-sqlserver.sql 11.8 KB 2359 about 16 years sgarg Modified database creation sql code so that in ...
xmltables.sql 19.4 KB 2769 about 15 years Matt Jones New SQL tables and db upgrade scripts that defi...

Latest revisions

# Date Author Comment
3052 09/27/2006 04:21 PM Matt Jones

Modifications to the table definitions to add indices that should be used
when searching the database. Added an upgrade script to create these
indices as well. Modified QueryTerm.java to use the '=' comparator rather
than 'LIKE' so that we can do index scans rather than table scans. This needs...

3051 09/18/2006 04:47 PM perry

fixed point centroid calculation to reflect bboxs that cross the dateline

3050 09/18/2006 04:45 PM perry

fixed point centroid calculation to reflect bboxs that cross the dateline

3048 09/18/2006 12:07 PM perry

Make spatial query more accurate by actually intersecting geometries in addition to a simple bbox filter. Important for testing intersection of irregular shaped objects or multi-geometries

3047 09/18/2006 11:21 AM perry

Added docid override mechanism to DBQuery. Bypasses the queryspec.printSQL method and creates an optimized docid query in cases (like the spatial query) where you know the docids a priori

3045 09/13/2006 04:46 PM perry

Updated spatial query to also look at point spatial cache as some documents may only be represented as a single point.

3044 09/13/2006 04:10 PM perry

Rewrote spatial query handler to use geotools directly against the spatial cache.

3043 09/13/2006 12:24 PM perry

Allow only public readable docs in the spatial cache

3040 09/11/2006 02:22 PM perry

Added javadoc comments for all new spatial classes. Optimized the title query in SpatialDocument.

3039 09/11/2006 12:58 PM perry

Removed old spatial classes

View revisions

Also available in: Atom