Hi,
TGRASS is currently broken in G7.0.svn. Running Anna's teaching
script (http://courses.ncsu.edu/mea592/common/Assign_GISmdmodel/a_temporal.html,
the second part on climate) fails:
GRASS 7.0.0svn (nc_climate_spm_2000_2012):~ > t.create
output=precipsum type=strds temporaltype=absolute
title="Precipitation" \
description="Monthly precipitation in NC [mm]"
ERROR: Unable to execute transaction:
--#############################################################################
-- This SQL script generates the table in which all registered GRASS_MAP
maps
-- are listed in.
--
-- This table will be created for each STDS.
--
-- Author: Soeren Gebbert soerengebbert <at> googlemail <dot> com
--#############################################################################
-- SPACETIME_NAME is a placeholder for specific stds name (SQL compliant):
name_mapset
-- GRASS_MAP is a placeholder for specific map type: raster, raster3d or
vector
-- This table stores the.ids of the GRASS_MAP maps registered in the
current spacetime GRASS_MAP table
CREATE TABLE SPACETIME_NAME_GRASS_MAP_register (
id VARCHAR NOT NULL, -- This colum is a primary key storing the registered
GRASS_MAP map.ids
PRIMARY KEY (id)
);
CREATE INDEX raster_map_register_3f85a9eb73d64bc2b3451204e12af4df_index ON
raster_map_register_3f85a9eb73d64bc2b3451204e12af4df (id);INSERT INTO
strds_base ( name ,creator ,mapset ,creation_time ,modification_time
,temporal_type ,id ,semantic_type ) VALUES ('precipsum' ,'neteler'
,'climate_1970_2012' ,'2014-05-28 02:01:56.688439' ,'2014-05-28
02:01:56.688537' ,'absolute' ,'precipsum@climate_1970_2012' ,'mean') ;
INSERT INTO strds_absolute_time ( start_time ,granularity ,id ,map_time
,end_time ) VALUES (NULL ,NULL ,'precipsum@climate_1970_2012' ,NULL ,NULL)
;
INSERT INTO strds_spatial_extent ( north ,bottom ,west ,top ,proj ,east ,id
,south ) VALUES (NULL ,NULL ,NULL ,NULL ,'XY' ,NULL
,'precipsum@climate_1970_2012' ,NULL) ;
INSERT INTO strds_metadata ( max_min ,description ,ewres_min ,title
,min_max ,nsres_min ,nsres_max ,number_of_maps ,raster_register ,command
,min_min ,ewres_max ,id ,max_max ,aggregation_type ) VALUES (NULL ,'Monthly
precipitation in NC [mm]' ,NULL ,'Precipitation' ,NULL ,NULL ,NULL ,NULL
,'raster_map_register_3f85a9eb73d64bc2b3451204e12af4df' ,'# 2014-05-28
02:01:56
t.create output="precipsum" type="strds"
temporaltype="absolute" title="Precipitation"
description="Monthly precipitation in NC [mm]"
' ,NULL ,NULL ,'precipsum@climate_1970_2012' ,NULL ,NULL) ;
*** stack smashing detected ***: python terminated
Traceback (most recent call last):
File "/home/neteler/software/grass70/dist.x86_64-unknown-linux-gnu/scripts/t.create",
line 83, in <module>
main()
File "/home/neteler/software/grass70/dist.x86_64-unknown-linux-gnu/scripts/t.create",
line 79, in main
semantic, None, grass.overwrite())
File "/home/neteler/software/grass70/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/open_stds.py",
line 169, in open_new_space_time_dataset
sp.insert(dbif)
File "/home/neteler/software/grass70/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/abstract_space_time_dataset.py",
line 366, in insert
dbif.execute_transaction(statement)
File "/home/neteler/software/grass70/dist.x86_64-unknown-linux-gnu/etc/python/grass/temporal/core.py",
line 955, in execute_transaction
self.cursor.executescript(statement)
sqlite3.OperationalError: table SPACETIME_NAME_GRASS_MAP_register already exists
GRASS 7.0.0svn (nc_climate_spm_2000_2012):~ > db.tables -p
No tables found
It works in trunk. The reason is likely a series of missing backports.
Markus