code: public static void addNote( Connection connection, long id, double lon, double lat, double altim, long timestamp, String text,
              String form ) throws Exception {
          String insertSQL = "INSERT INTO " + TableDescriptions.TABLE_NOTES + "(" + //
                  TableDescriptions.NotesTableFields.COLUMN_ID.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_LAT.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_LON.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_ALTIM.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_TS.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_TEXT.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_FORM.getFieldName() + ", " + //
                  TableDescriptions.NotesTableFields.COLUMN_ISDIRTY.getFieldName() + //
                  ") VALUES" + "(?,?,?,?,?,?,?,?)";
          try (PreparedStatement writeStatement = connection.prepareStatement(insertSQL)) {
              writeStatement.setLong(1, id);
              writeStatement.setDouble(2, lat);
              writeStatement.setDouble(3, lon);
              writeStatement.setDouble(4, altim);
              writeStatement.setLong(5, timestamp);
              writeStatement.setString(6, text);
              writeStatement.setString(7, form);
              writeStatement.setInt(8, 1);
  
              writeStatement.executeUpdate();
          }
      }
docs: Add a new note to the database.
  
  @param id        the id
  @param lon       lon
  @param lat       lat
  @param altim     elevation
  @param timestamp the UTC timestamp in millis.
  @param text      a text
  @param form      the optional json form.
  
  @throws IOException if something goes wrong.