Database Report

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

Choices available depend on the type of open database.
  • Text (CSV)
  • HTML 
  • 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. 
  • Other database formats
    • 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:
  • KML: export for Google earth.
    • Quick--uses current settings.
    • Deliberate--lets you adjust output
  • 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.
  • 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 with having to PIZ the file.  You can Uncompress with MICRODEM, and rename the file and then use any software that handles zips.  The 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.
  • Clear field ranges

 


Last revision 8/5/2017