Home > 研究日誌 > 研究:日誌0621

研究:日誌0621

  • Posted by: hesuko
  • 2009年6月22日 01:29
  • 研究日誌
  •  

本日付けより全ての大学研究は全て日誌カテゴリに仕分けします。

http://www.mlit.go.jp/kokudokeikaku/gis/index.html
国土交通省GISのDBを1個CSV化

・国土数値情報 公共施設データ 全国(分割) 平成18年度版
公共施設:行政建築物関係(役所、郵便局(日本郵政公社時代)、学校等)
学校等は私立も含まれている。

ZIP、解凍でXML(JPGIS)形式でDL

xyxxyでGresreg
検索「ksj:」
置換「」
ファイル名「*」
フォルダ名「DLパス」
「勝手にセーブしろ」
「全て置換」

3350862件置換え

[okikae.xslt]-----------------------------------

<?xml version="1.0" encoding="utf-8"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" >
<xsl:output method="text" encoding="UTF-8" />

<xsl:template match="/">公共施設ID,地点,行政コード,公共施設大分類コード,公共施設小分類コード,名称,所在地,管理者コード,原典資料名
<xsl:apply-templates select="GI/dataset/object/AA01/OBJ/FB01" />
</xsl:template>
<xsl:template match="FB01">
<xsl:value-of select="@id" />,<xsl:value-of select="POS/@idref" />,<xsl:value-of select="AAC" />,<xsl:value-of select="PCA" />,<xsl:value-of select="PCI" />,<xsl:value-of select="NA0" />,<xsl:value-of select="ADS" />,<xsl:value-of select="APF" />,<xsl:value-of select="RCN" /><xsl:text>
</xsl:text>
</xsl:template>

</xsl:stylesheet>

---------------------------------

utf-8保存したら
KanjiTrancelator1.6で変換(さっきのファイルも全部)
変換先文字コード:UTF-8(BOM無し)
CR+LFでOK
んで
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_01.xml -xsl d:\test.xslt -out d:\work\henkan\01.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_02.xml -xsl d:\test.xslt -out d:\work\henkan\02.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_03.xml -xsl d:\test.xslt -out d:\work\henkan\03.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_04.xml -xsl d:\test.xslt -out d:\work\henkan\04.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_05.xml -xsl d:\test.xslt -out d:\work\henkan\05.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_06.xml -xsl d:\test.xslt -out d:\work\henkan\06.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_07.xml -xsl d:\test.xslt -out d:\work\henkan\07.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_08.xml -xsl d:\test.xslt -out d:\work\henkan\08.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_09.xml -xsl d:\test.xslt -out d:\work\henkan\09.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_10.xml -xsl d:\test.xslt -out d:\work\henkan\10.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_11.xml -xsl d:\test.xslt -out d:\work\henkan\11.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_12.xml -xsl d:\test.xslt -out d:\work\henkan\12.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_13.xml -xsl d:\test.xslt -out d:\work\henkan\13.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_14.xml -xsl d:\test.xslt -out d:\work\henkan\14.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_15.xml -xsl d:\test.xslt -out d:\work\henkan\15.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_16.xml -xsl d:\test.xslt -out d:\work\henkan\16.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_17.xml -xsl d:\test.xslt -out d:\work\henkan\17.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_18.xml -xsl d:\test.xslt -out d:\work\henkan\18.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_19.xml -xsl d:\test.xslt -out d:\work\henkan\19.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_20.xml -xsl d:\test.xslt -out d:\work\henkan\20.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_21.xml -xsl d:\test.xslt -out d:\work\henkan\21.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_22.xml -xsl d:\test.xslt -out d:\work\henkan\22.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_23.xml -xsl d:\test.xslt -out d:\work\henkan\23.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_24.xml -xsl d:\test.xslt -out d:\work\henkan\24.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_25.xml -xsl d:\test.xslt -out d:\work\henkan\25.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_26.xml -xsl d:\test.xslt -out d:\work\henkan\26.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_27.xml -xsl d:\test.xslt -out d:\work\henkan\27.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_28.xml -xsl d:\test.xslt -out d:\work\henkan\28.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_29.xml -xsl d:\test.xslt -out d:\work\henkan\29.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_30.xml -xsl d:\test.xslt -out d:\work\henkan\30.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_31.xml -xsl d:\test.xslt -out d:\work\henkan\31.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_32.xml -xsl d:\test.xslt -out d:\work\henkan\32.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_33.xml -xsl d:\test.xslt -out d:\work\henkan\33.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_34.xml -xsl d:\test.xslt -out d:\work\henkan\34.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_35.xml -xsl d:\test.xslt -out d:\work\henkan\35.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_36.xml -xsl d:\test.xslt -out d:\work\henkan\36.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_37.xml -xsl d:\test.xslt -out d:\work\henkan\37.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_38.xml -xsl d:\test.xslt -out d:\work\henkan\38.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_39.xml -xsl d:\test.xslt -out d:\work\henkan\39.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_40.xml -xsl d:\test.xslt -out d:\work\henkan\40.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_41.xml -xsl d:\test.xslt -out d:\work\henkan\41.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_42.xml -xsl d:\test.xslt -out d:\work\henkan\42.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_43.xml -xsl d:\test.xslt -out d:\work\henkan\43.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_44.xml -xsl d:\test.xslt -out d:\work\henkan\44.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_45.xml -xsl d:\test.xslt -out d:\work\henkan\45.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_46.xml -xsl d:\test.xslt -out d:\work\henkan\46.csv
java org.apache.xalan.xslt.Process -in d:\work\henkan\P02-06_47.xml -xsl d:\test.xslt -out d:\work\henkan\47.csv

ゴシカァン


他メモ:

wikipedia:神奈川県小学校一覧
http://ja.wikipedia.org/wiki/%E7%A5%9E%E5%A5%88%E5%B7%9D%E7%9C%8C%E5%B0%8F%E5%AD%A6%E6%A0%A1%E4%B8%80%E8%A6%A7

879件

国土交通省DB:901件

結論:こっこーしょー!

Comments:0

Comment Form

Trackbacks:0

TrackBack URL for this entry
http://sm.2-d.jp/mt/mt-tb.cgi/281
Listed below are links to weblogs that reference
研究:日誌0621 from SiteModifyBlog

Home > 研究日誌 > 研究:日誌0621

Return to page top