rsimon

sudo -u postgres psql recogito


ALTER TABLE gdocuments ADD COLUMN geo_origin character varying(254);
ALTER TABLE gdocuments ADD COLUMN geo_findspot character varying(254);
ALTER TABLE gdocuments ADD COLUMN geo_author_location character varying(254);

rsimon

rsimon

SELECT 
  -- concat (toponym, toponym_corrected), count(*) 
  coalesce(toponym, toponym_corrected), count(*) 
  
FROM annotations WHERE
 (status = 'NOT_IDENTIFYABLE' OR status = 'NO_SUITABLE_MATCH' OR status = 'AMBIGUOUS' OR status = 'MULTIPLE')
-- GROUP BY concat(toponym, toponym_corrected)
GROUP BY coalesce(toponym, toponym_corrected)
ORDER BY count desc ;

rsimon

'''
Created on 02.05.2013

@author: simonr
'''

from pylab import plot,show
from numpy import vstack,array
from numpy.random import rand
from scipy.cluster.vq import kmeans,vq

rsimon

import sbt._
import Keys._

object ScalagiosBuild extends Build {

    lazy val core = Project(id = "scalagios-core",
                            base = file("scalagios-core"))

    lazy val legacy = Project(id = "scalagios-legacy",
                           base = file("foo")) dependsOn(core)

rsimon

import scala.xml.XML
import java.io.FileWriter
import scala.xml.transform.RewriteRule
import scala.xml.Node
import scala.xml.NodeSeq
import scala.xml.Elem
import scala.xml.transform.RuleTransformer
import scala.xml.Text

object TEI extends App {