code: @Override
      public void setStatementParameters(PreparedStatement statement, boolean setDefaultId) throws SQLException {
          int oneBasedIndex = 1;
          if (!setDefaultId) statement.setInt(oneBasedIndex++, id);
          statement.setString(oneBasedIndex++, route_id);
          statement.setString(oneBasedIndex++, agency_id);
          statement.setString(oneBasedIndex++, route_short_name);
          statement.setString(oneBasedIndex++, route_long_name);
          statement.setString(oneBasedIndex++, route_desc);
          setIntParameter(statement, oneBasedIndex++, route_type);
          statement.setString(oneBasedIndex++, route_url != null ? route_url.toString() : null);
          statement.setString(oneBasedIndex++, route_branding_url != null ? route_branding_url.toString() : null);
          statement.setString(oneBasedIndex++, route_color);
          statement.setString(oneBasedIndex++, route_text_color);
          // Editor-specific fields publicly_visible, wheelchair_accessible, route_sort_order, and status.
          setIntParameter(statement, oneBasedIndex++, 0);
          setIntParameter(statement, oneBasedIndex++, 0);
          // route_sort_order
          setIntParameter(statement, oneBasedIndex++, route_sort_order);
          setIntParameter(statement, oneBasedIndex++, 0);
      }
docs: Sets the parameters for a prepared statement following the parameter order defined in
  {@link com.conveyal.gtfs.loader.Table#ROUTES}. JDBC prepared statement parameters use a one-based index.