Stack Overflow
Stack Overflow

Questions tagged [geokettle]

GeoKettle is a spatially-enable version of the Pentaho Data Integration Kettle software. Kettle and GeoKettle are Extract, Transform, and Load (ETL) tools.

When you have some GIS data (say in a shapefile) and you want to transfer some part of that data into a spatial database you can use GeoKettle to EXTRACT the data from the shapefile (it does it one feature at a time) apply any TRANSFORM-ation required, for example you could change the coordinate reference system, or calculate the area of a polygon, or select only some of the data based on some logic, and then LOAD it into the database. The GeoKettle environment is GUI driven, so you drag a step onto your workspace that handles a part of the process, then add further steps and link them together to form a processing chain.

An example of a GeoKettle transformation

20 questions
3
votes
1 answer

Geokettle insert in cascade, ETL normalization process

I'm new to ETL process. At this moment I'm working with kettle more precisely with geokettle to make a ETL process. I'm building a transformation to insert data in a normalized structure on my database target from a descriptive table of a database…
ePascoal
  • 2,362
  • 6
  • 26
  • 44
1
vote
0 answers

Plot Geomondrian Spatial data on a map

Is there a way to plot and visualize geomondrian spatial data on map ? i found here an issue about it ?! i have also find an article speaking about a solution (SOLAPLAYERS) but i didn't find a way to downloaded it from sourceforge.
A.HADDAD
  • 1,809
  • 4
  • 26
  • 51
1
vote
0 answers

Free Solap client for geomondrian

Jpivot hasn't been updated since 2008, it doesn't allow the visualization of geo spatial properties within a map, is there a free alternative that allow it for geomondrian ?
A.HADDAD
  • 1,809
  • 4
  • 26
  • 51
1
vote
0 answers

Kettle: How to add a geometry type

i'm using kettle but i don't have geometry type. My issue is how can i create a geometry type so i can make transformations with databases that has postgis. I tried to use geokettle but i found some bugs and since that geokettle doesn't have any…
ePascoal
  • 2,362
  • 6
  • 26
  • 44
1
vote
1 answer

joining two table inputs in a single transaction

Hi, I am trying to create a kettle transaction where the data is read from two tables and then joined. Above seems to be very simple and basic transformation but i get an issue when trying to do it in a single transaction i.e. with "make the…
Sushant
  • 173
  • 1
  • 4
  • 15
1
vote
1 answer

Filling in running headings in Kettle

I have an XLS file of district-level data, where each district is in a region. But the region column is only filled for the first district in the region. Something like: District Region Population Foo Bar 1234 Baz 345 …
Spacedman
  • 92,590
  • 12
  • 140
  • 224
0
votes
2 answers

Pentaho Spoon: Cannot split string in JavaScript Step

I am trying to use the JavaScript step in order to extract the first part of a string of the input field "name". An example entry for the field "name" would be: "14 Ri.". And I want to extract the "14" out of the string. For this, I have tried to do…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
1 answer

Pentaho Geokettle: Convert Epoch time to human time

I am currently working with Pentaho GeoKettle (or Spoon) and I am trying to import data into a database from a csv file. In the csv-file, there is a column which holds a timestamp in Epoch-format. But I have to import it to the database in the human…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
2 answers

Pentaho Kettle insert Error Handling of step

I am new to GeoKettle (Spoon) of Pentaho and I am currently rows from an Excel-file into my database. Now I want to avoid duplicates in my databasetable. That is why I want to insert only those rows into my database table which aren't there yet (to…
user7335295
  • 401
  • 2
  • 7
  • 31
0
votes
0 answers

SQL Server not inserting geometry type (worked in Postgres though)

Problem: insert a shapefile (.shp) into sql server Steps: 1- I use Geokettle to transform .shp to sql server query 2- I use the sql query to create the table in sql server the SQL Server code looks like: INSERT INTO [dbo].[CARGA_SHAPE](the_geom,…
gustavomoty
  • 21
  • 1
0
votes
0 answers

GDAL error on CentOS 7

I’m no IT guy so it’s possible that I making something very wrong. But I’m struggling for days with this issue… Working in a VM with CentOS 7. When running something in GeoKettle I have this error that points to GDAL. Native library load…
Pedro
  • 13
  • 4
0
votes
1 answer

how to convert 12 hrs format to 24 hrs format in kettle

I have CSV file that contains timestamp column and data type is a string. It looks like this. timestamp 12/03/2016 01:00 PM 12/04/2016 01:15 PM 12/04/2016 01:30 PM So I want to convert time value in 24 hrs format
Pratik Panchal
  • 1
0
votes
1 answer

Rename field name in geokettle

Greeting, I want to rename a field using "Modified Java Script Value" script. For example I have Input field "field1" and I want to rename it using JavaScript to "NewField". Thank you,
Eyla
  • 5,751
  • 20
  • 71
  • 116
0
votes
1 answer

Memory Leak with Pentaho Kettle Looping?

I have an ETL requirement like: I need to fetch around 20000 records from a table and process each record separately.(The processing of each record involves a couple of steps like creating a table for each record and inserting some data into it).…
user6786116
0
votes
1 answer

Kettle: ETL Normalization split string fields

I have database where it has one attribute that actually carries two(string separated by "; "). Take a look on the following example: Example This is my Database A (Source) which has a table like this: In fact, this seems all ok, but when you…
ePascoal
  • 2,362
  • 6
  • 26
  • 44
1
2