Fork: 0
coverage / osmCoverage
Transfer to URL with SHA Find file
Newer
Older
osmCoverage / src / osm / jp / postgis / PostgisItems.java
@yuu yuu on 24 Dec 2018 5 KB function: UnMapped.
Raw Blame History 
  1. package osm.jp.postgis;
  2.  
  3. import java.math.BigDecimal;
  4. import java.sql.ResultSet;
  5. import java.sql.SQLException;
  6. import java.util.ArrayList;
  7.  
  8. public class PostgisItems extends ArrayList<PostgisItem> {
  9.     String geom = "";
  10.     String gmlid = "";
  11.     String idref = "";
  12.     int area = 0;
  13.     int fixed = 0;
  14.     int code = 0;
  15.     double lat = 0.0D;
  16.     double lon = 0.0D;
  17.     
  18.     public static void main() {
  19.         @SuppressWarnings("MismatchedQueryAndUpdateOfCollection")
  20.         PostgisItems items = new PostgisItems();
  21.         items.add(new PostgisItem("gmlid", "gmlid"));
  22.         items.add(new PostgisItem("idref", "idref"));
  23.         items.add(new PostgisItem("area", "area"));
  24.         items.add(new PostgisItem("fixed", "fixed1"));
  25.         items.add(new PostgisItem("code", "code"));
  26.     }
  27.     
  28.     public PostgisItems() {
  29.         super();
  30.     }
  31.  
  32.     public void setResuit(ResultSet rset) throws SQLException {
  33.         for (PostgisItem item : this) {
  34.             switch (item.postName) {
  35.                 case "gmlid":
  36.                     gmlid = rset.getString(item.localName);
  37.                     break;
  38.                 case "idref":
  39.                     idref = rset.getString(item.localName);
  40.                     break;
  41.                 case "area":
  42.                     area = rset.getInt(item.localName);
  43.                     break;
  44.                 case "fixed":
  45.                     fixed = rset.getInt(item.localName);
  46.                     break;
  47.                 case "code":
  48.                     code = rset.getInt(item.localName);
  49.                     break;
  50.                 default:
  51.                     break;
  52.             }
  53.         }
  54.         lat = rset.getDouble("lat");
  55.         lon = rset.getDouble("lon");
  56.     }
  57.     
  58.     public void setPostResuit(ResultSet rset) throws SQLException {
  59.         for (PostgisItem item : this) {
  60.             switch (item.postName) {
  61.                 case "gmlid":
  62.                     gmlid = rset.getString(item.postName);
  63.                     break;
  64.                 case "idref":
  65.                     idref = rset.getString(item.postName);
  66.                     break;
  67.                 case "area":
  68.                     area = rset.getInt(item.postName);
  69.                     break;
  70.                 case "fixed":
  71.                     fixed = rset.getInt(item.postName);
  72.                     break;
  73.                 case "code":
  74.                     code = rset.getInt(item.postName);
  75.                     break;
  76.                 case "geom":
  77.                     geom = rset.getString(item.postName);
  78.                     break;
  79.                 case "lat":
  80.                     lat = rset.getDouble(item.postName);
  81.                     break;
  82.                 case "lon":
  83.                     lon = rset.getDouble(item.postName);
  84.                     break;
  85.                 default:
  86.                     break;
  87.             }
  88.         }
  89.     }
  90.  
  91.     public String getSqlStr(String tableName) {
  92.         StringBuilder sb = new StringBuilder();
  93.         sb.append("SELECT ");
  94.         for (PostgisItem item : this) {
  95.             sb.append(item.localName);
  96.             sb.append(",");
  97.         }
  98.         sb.append("lat,lon FROM ");
  99.         sb.append(tableName);
  100.         return sb.toString();
  101.     }
  102.  
  103.     public String getValue() {
  104.         StringBuilder sb = new StringBuilder();
  105.         boolean top = true;
  106.         for (PostgisItem item : this) {
  107.             if (top) {
  108.                 top = false;
  109.             }
  110.             else {
  111.                 sb.append(",");
  112.             }
  113.             switch (item.postName) {
  114.                 case "gmlid":
  115.                     sb.append(gmlid);
  116.                     break;
  117.                 case "idref":
  118.                     sb.append(idref);
  119.                     break;
  120.                 case "area":
  121.                     sb.append(area);
  122.                     break;
  123.                 case "fixed":
  124.                     sb.append(fixed);
  125.                     break;
  126.                 case "code":
  127.                     sb.append(code);
  128.                     break;
  129.                 case "geom":
  130.                     sb.append(geom);
  131.                     break;
  132.                 case "lat":
  133.                     sb.append(lat);
  134.                     break;
  135.                 case "lon":
  136.                     sb.append(lon);
  137.                     break;
  138.                 default:
  139.                     break;
  140.             }
  141.         }
  142.         return sb.toString();
  143.     }
  144.     
  145.     public String getPostSqlStr(String tableName) {
  146.         StringBuilder sb = new StringBuilder();
  147.         sb.append("SELECT ");
  148.         boolean top = true;
  149.         for (PostgisItem item : this) {
  150.             if (top) {
  151.                 top = false;
  152.             }
  153.             else {
  154.                 sb.append(",");
  155.             }
  156.             switch (item.postName) {
  157.                 case "lat":
  158.                     sb.append("ST_Y(geom) AS lat");
  159.                     break;
  160.                 case "lon":
  161.                     sb.append("ST_X(geom) AS lon");
  162.                     break;
  163.                 default:
  164.                     sb.append(item.postName);
  165.                     break;
  166.             }
  167.         }
  168.         sb.append(" FROM t_");
  169.         sb.append(tableName);
  170.         sb.append(" ORDER BY area, gmlid");
  171.         return sb.toString();
  172.     }
  173.     
  174.     public String getCsvHeader() {
  175.         StringBuilder sb = new StringBuilder();
  176.         boolean top = true;
  177.         for (PostgisItem item : this) {
  178.             if (top) {
  179.                 top = false;
  180.             }
  181.             else {
  182.                 sb.append(",");
  183.             }
  184.             sb.append(item.postName);
  185.         }
  186.         return sb.toString();
  187.     }
  188.     
  189.     public String getGeomStr() {
  190.         return String.format(
  191.             "ST_GeomFromText('POINT(%s %s)', 4612)", 
  192.             BigDecimal.valueOf(lon).toPlainString(), 
  193.             BigDecimal.valueOf(lat).toPlainString()
  194.         );
  195.     }
  196. }