extract.py 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268
  1. """!@package grass.temporal
  2. @brief GRASS Python scripting module (temporal GIS functions)
  3. Temporal GIS related functions to be used in Python scripts.
  4. (C) 2012-2013 by the GRASS Development Team
  5. This program is free software under the GNU General Public
  6. License (>=v2). Read the file COPYING that comes with GRASS
  7. for details.
  8. @author Soeren Gebbert
  9. """
  10. from grass.script.utils import get_num_suffix
  11. from space_time_datasets import *
  12. from open_stds import *
  13. from multiprocessing import Process
  14. import grass.script as gscript
  15. ############################################################################
  16. def extract_dataset(input, output, type, where, expression, base, nprocs=1,
  17. register_null=False, layer=1,
  18. vtype="point,line,boundary,centroid,area,face"):
  19. """!Extract a subset of a space time raster, raster3d or vector dataset
  20. A mapcalc expression can be provided to process the temporal extracted
  21. maps.
  22. Mapcalc expressions are supported for raster and raster3d maps.
  23. @param input The name of the input space time raster/raster3d dataset
  24. @param output The name of the extracted new space time raster/raster3d
  25. dataset
  26. @param type The type of the dataset: "raster", "raster3d" or vector
  27. @param where The temporal SQL WHERE statement for subset extraction
  28. @param expression The r(3).mapcalc expression or the v.extract where
  29. statement
  30. @param base The base name of the new created maps in case a mapclac
  31. expression is provided
  32. @param nprocs The number of parallel processes to be used for mapcalc
  33. processing
  34. @param register_null Set this number True to register empty maps
  35. (only raster and raster3d maps)
  36. @param layer The vector layer number to be used when no timestamped
  37. layer is present, default is 1
  38. @param vtype The feature type to be extracted for vector maps, default
  39. is point,line,boundary,centroid,area and face
  40. """
  41. # Check the parameters
  42. msgr = get_tgis_message_interface()
  43. if expression and not base:
  44. msgr.fatal(_("You need to specify the base name of new created maps"))
  45. mapset = get_current_mapset()
  46. dbif = SQLDatabaseInterfaceConnection()
  47. dbif.connect()
  48. sp = open_old_space_time_dataset(input, type, dbif)
  49. # Check the new stds
  50. new_sp = check_new_space_time_dataset(output, type, dbif,
  51. gscript.overwrite())
  52. if type == "vector":
  53. rows = sp.get_registered_maps(
  54. "id,name,mapset,layer", where, "start_time", dbif)
  55. else:
  56. rows = sp.get_registered_maps("id", where, "start_time", dbif)
  57. new_maps = {}
  58. if rows:
  59. num_rows = len(rows)
  60. msgr.percent(0, num_rows, 1)
  61. # Run the mapcalc expression
  62. if expression:
  63. count = 0
  64. proc_count = 0
  65. proc_list = []
  66. for row in rows:
  67. count += 1
  68. if count % 10 == 0:
  69. msgr.percent(count, num_rows, 1)
  70. map_name = "{base}_{suffix}".format(base=base,
  71. suffix=get_num_suffix(count, num_rows))
  72. # We need to modify the r(3).mapcalc expression
  73. if type != "vector":
  74. expr = "%s = %s" % (map_name, expression)
  75. expr = expr.replace(sp.base.get_map_id(), row["id"])
  76. expr = expr.replace(sp.base.get_name(), row["id"])
  77. # We need to build the id
  78. map_id = AbstractMapDataset.build_id(map_name, mapset)
  79. else:
  80. map_id = AbstractMapDataset.build_id(map_name, mapset, row["layer"])
  81. new_map = sp.get_new_map_instance(map_id)
  82. # Check if new map is in the temporal database
  83. if new_map.is_in_db(dbif):
  84. if gscript.overwrite():
  85. # Remove the existing temporal database entry
  86. new_map.delete(dbif)
  87. new_map = sp.get_new_map_instance(map_id)
  88. else:
  89. msgr.error(_("Map <%s> is already in temporal database"
  90. ", use overwrite flag to overwrite") %
  91. (new_map.get_map_id()))
  92. continue
  93. # Add process to the process list
  94. if type == "raster":
  95. msgr.verbose(_("Applying r.mapcalc expression: \"%s\"")
  96. % expr)
  97. proc_list.append(Process(target=run_mapcalc2d,
  98. args=(expr,)))
  99. elif type == "raster3d":
  100. msgr.verbose(_("Applying r3.mapcalc expression: \"%s\"")
  101. % expr)
  102. proc_list.append(Process(target=run_mapcalc3d,
  103. args=(expr,)))
  104. elif type == "vector":
  105. msgr.verbose(_("Applying v.extract where statement: \"%s\"")
  106. % expression)
  107. if row["layer"]:
  108. proc_list.append(Process(target=run_vector_extraction,
  109. args=(row["name"] + "@" + \
  110. row["mapset"],
  111. map_name, row["layer"],
  112. vtype, expression)))
  113. else:
  114. proc_list.append(Process(target=run_vector_extraction,
  115. args=(row["name"] + "@" + \
  116. row["mapset"],
  117. map_name, layer, vtype,
  118. expression)))
  119. proc_list[proc_count].start()
  120. proc_count += 1
  121. # Join processes if the maximum number of processes are
  122. # reached or the end of the loop is reached
  123. if proc_count == nprocs or count == num_rows:
  124. proc_count = 0
  125. exitcodes = 0
  126. for proc in proc_list:
  127. proc.join()
  128. exitcodes += proc.exitcode
  129. if exitcodes != 0:
  130. dbif.close()
  131. msgr.fatal(_("Error in computation process"))
  132. # Empty process list
  133. proc_list = []
  134. # Store the new maps
  135. new_maps[row["id"]] = new_map
  136. msgr.percent(0, num_rows, 1)
  137. temporal_type, semantic_type, title, description = sp.get_initial_values()
  138. new_sp = open_new_space_time_dataset(output, type,
  139. sp.get_temporal_type(),
  140. title, description,
  141. semantic_type, dbif,
  142. gscript.overwrite())
  143. # collect empty maps to remove them
  144. empty_maps = []
  145. # Register the maps in the database
  146. count = 0
  147. for row in rows:
  148. count += 1
  149. if count % 10 == 0:
  150. msgr.percent(count, num_rows, 1)
  151. old_map = sp.get_new_map_instance(row["id"])
  152. old_map.select(dbif)
  153. if expression:
  154. # Register the new maps
  155. if row["id"] in new_maps:
  156. new_map = new_maps[row["id"]]
  157. # Read the raster map data
  158. new_map.load()
  159. # In case of a empty map continue, do not register empty
  160. # maps
  161. if type == "raster" or type == "raster3d":
  162. if new_map.metadata.get_min() is None and \
  163. new_map.metadata.get_max() is None:
  164. if not register_null:
  165. empty_maps.append(new_map)
  166. continue
  167. elif type == "vector":
  168. if new_map.metadata.get_number_of_primitives() == 0 or \
  169. new_map.metadata.get_number_of_primitives() is None:
  170. if not register_null:
  171. empty_maps.append(new_map)
  172. continue
  173. # Set the time stamp
  174. new_map.set_temporal_extent(old_map.get_temporal_extent())
  175. # Insert map in temporal database
  176. new_map.insert(dbif)
  177. new_sp.register_map(new_map, dbif)
  178. else:
  179. new_sp.register_map(old_map, dbif)
  180. # Update the spatio-temporal extent and the metadata table entries
  181. new_sp.update_from_registered_maps(dbif)
  182. msgr.percent(num_rows, num_rows, 1)
  183. # Remove empty maps
  184. if len(empty_maps) > 0:
  185. names = ""
  186. count = 0
  187. for map in empty_maps:
  188. if count == 0:
  189. names += "%s" % (map.get_name())
  190. else:
  191. names += ",%s" % (map.get_name())
  192. count += 1
  193. if type == "raster":
  194. gscript.run_command("g.remove", type='rast', name=names, quiet=True, flags='f')
  195. elif type == "raster3d":
  196. gscript.run_command("g.remove", type='rast3d', name=names, quiet=True, flags='f')
  197. elif type == "vector":
  198. gscript.run_command("g.remove", type='vect', name=names, quiet=True, flags='f')
  199. dbif.close()
  200. ###############################################################################
  201. def run_mapcalc2d(expr):
  202. """Helper function to run r.mapcalc in parallel"""
  203. exit(gscript.run_command("r.mapcalc", expression=expr,
  204. overwrite=gscript.overwrite(), quiet=True))
  205. def run_mapcalc3d(expr):
  206. """Helper function to run r3.mapcalc in parallel"""
  207. exit(gscript.run_command("r3.mapcalc", expression=expr,
  208. overwrite=gscript.overwrite(), quiet=True))
  209. def run_vector_extraction(input, output, layer, type, where):
  210. """Helper function to run r.mapcalc in parallel"""
  211. exit(gscript.run_command("v.extract", input=input, output=output,
  212. layer=layer, type=type, where=where,
  213. overwrite=gscript.overwrite(), quiet=True))