Database Report

Menu from the "Report" button on database table form.  

Choices available depend on the type of open database.
  • Export text (CSV).  You can supply any file extension.
  • Export HTML 
  • Export DBF Table: Create new dBase table.  The options here will only use the filtered records, and the displayed attributes/fields, so be careful.  You can lose data, which can be good or bad depending on your desires. 
  • Data DBF only (no geometry)
  • Quick KML: export for Google earth, using current settings.
    • Quick--uses current settings.
  • Export other database formats
    • Export Text (Deliberate): use only if you want a separator other than a comma, or to thin the export.
    • Deliberate KML--lets you adjust output
    • XML: export as XML file, which includes a definition of the database.  This is valid XML, but I have seen 3 different exports into XML of a DBF file, so it might or might not import into other software.
    • CDS:
    • SQLite:
    Earthquake focal mechanisms
    • Quick
    • Deliberate

  • Database structure: see the field types and lengths.
  • Coordinates to text file--you can get your preferred lat/long format, or all of them
  • Merged table: create merged string grid with all the currently active records, combining fields from the main table and joined table.  You can save this as a CSV file and then convert to a dBase table.

  • Export points to registration table
  • ArcGIS viewshed sensors
  • Create point shapefile--writes SHP and SHX files for the current database, and includes all records and fields. MICRODEM does not normally use the SHP and SHX files for point shape files (but see the next option), and does not automatically update them if you edit the file. If you need, subset first using the "DBF Table" option which also has an option to save as a shapefile.  This creates a PRJ file acceptable to ArcGIS.  If there is a field Z or ELEV, this will be a 3D shapefile.
  • Create point SHX index: writes SHX files for the current database, and includes all records and fields. MICRODEM can use the SHX file for point shape file to Zoom to DB coverage on the Plot popup.
  • Create grid: makes grid with the same extent and spacing as the one associated with the map.
  • Export lat/long/z to text file: must be line or area shape file, with Z values in a field, and creates a text file with all the coordinates.
  • Export XYZ triples: must be 3D line or area shape file, and creates a point shape file with all the coordinates from the shapefile.
  • Thin database: save DB to a new file, with a specified thinning (decimation) factor.

  • Shapefile export--only works for line and area shapefiles.  Use the DBF table option for point files.
  • Create area/line shape file from points
  • Create points file (along line, or in area)
  • Normalize fields--select fields will be scaled so that 0 is  mean of the original field, and values represent standard deviations from the mean.  This will create a new database.
  • Compress shapefile: creates a zip file (with SHZ extension) with the shapefile's 3 files and the MICRODEM specific symbology in the INI file) and the linked table if there is a join.  This keeps the files together to send to someone else, compresses the data, and lets you email without having to PIZ the file.  MICRODEM and use the SHZ file, or you can Uncompress with MICRODEM, and rename the file and then use any software that handles zips.  The SHZ file name will have the current date and time, so you can track edits to a database.
  • Copy data files: copies all files in the FILENAME field to a specified directory.  You can have previously filtered the database.
  • Movie:
  • Legend:
  • Fonts
    • Grid
    • Legend
  • Hide unused fields: for fields that are blank, hides them all.  You can can export the database to remove them.
  • Show DB settings
  • Clear DB Settings: restore default plotting and join options, by clearing the database's INI file.
  • Clear field ranges


Last revision 11/15/2018