[B! PostGIS] shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

shokai id:shokai

PostGISã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

å®Ÿè·µï¼šGeoKit ã¨ iPhone ã§ä½œã‚‹ä½ç½®æƒ…å ±ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆå‰ç·¨ï¼‰ - Cirius Lab. ãƒ–ãƒã‚°
ã€Œæ˜”ã‹ã‚‰è‡ªåˆ†ã®ãƒŠãƒ‹ã®ã‚µã‚¤ã‚ºãŒå°ã•ã„ã®ãŒã‚³ãƒ³ãƒ—ãƒ¬ãƒƒã‚¯ã‚¹ã«ãªã£ã¦ã„ã¾ã™ã€ ã‚³ãƒ³ãƒ—ãƒ¬ãƒƒã‚¯ã‚¹ã«ãªã£ãŸãã£ã‹ã‘ã¯ä¸å¦ã®æ™‚ã®ä¿®å¦æ—…è¡Œã§ã™ã€‚ ãã‚Œã¾ã§ç‰¹ã«æ°—ã«ãªã‚‰ãªã‹ã£ãŸã®ã§ã™ãŒã€ãŠé¢¨å‘‚ã®æ™‚é–“ã«å‹äººã®ã‚’è¦‹ã¦ã€è‡ªåˆ†ãŒå°ã•ã„æ–¹ãªã“ã¨ã«æ°—ãŒä»˜ãã¾ã—ãŸã€‚ ãã‚Œã‹ã‚‰ã¯æ¥ãšã‹ã—ãæ€ã†ã‚ˆã†ã«ã€‚ ãã‚Œã‹ã‚‰10å¹´è¿‘ãçµŒã¡ã¾ã—ãŸãŒã€ç‰¹ã«ã‚µã‚¤ã‚ºã¯å¤‰ã‚ã£ã¦ã„ãªã„ã§ã™ã€‚ å¤§äººã«ãªã£ã¦ãµã¨æ€ã£ãŸã‚“ã§ã™ã€‚ ã‚³ãƒ³ãƒ—ãƒ¬ãƒƒã‚¯ã‚¹ã‚’è§£æ¶ˆã™ã‚‹æ–¹æ³•ã£ã¦ç„¡ã„ã®ã‹ãªã¨ã€‚ ãã—ã¦èª¿ã¹ã¦ã¿ãŸã‚‰ã€æœ€è¿‘ã¯è‰²ã€…ãªæ–¹æ³•ãŒã‚ã‚‹ã“ã¨ã‚’çŸ¥ã‚Šã¾ã—ãŸã€‚ ç‰¹ã«æ°—ã«ãªã£ãŸã®ã¯ã€å‡ç¸®é»’ã‚¦ã‚³ãƒ³DEXã€‘ã¨ã„ã†å¢—å¤§ã‚µãƒ—ãƒªãƒ¡ãƒ³ãƒˆã§ã™ã€‚ å…¨ä½“çš„ã«è©•ä¾¡ã‚‚é«˜ãã¦ã€ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’èªã‚“ã§ã„ã¦ã‚‚ã‹ãªã‚ŠæœŸå¾…ã§ãã‚‹ãªã¨æ€ã„ã¾ã—ãŸã€‚ ã§ã™ãŒåˆã‚ã¦ã®ã“ã¨ãªã®ã§ã€è‡ªåˆ†ã«åŠ¹æžœãŒã‚ã‚‹ã®ã‹ã¨ã„ã†ä¸å®‰ã‚‚ã‚ã‚Šã¾ã™ã€‚ ãªã®ã§å‡ç¸®é»’ã‚¦ã‚³ãƒ³DEXã«ã¤ã„ã¦è©³ã—ãèª¿ã¹ã¦ã¿ãŸã„ãªã¨ã€‚ èª¿ã¹å°½ãã—ã¦ã€ä½¿ã„ãŸã„ã¨ã„ã†æ°—æŒã¡ãŒå¼·ã‘ã‚Œã°æ³¨æ–‡
shokai 2010/07/13
PostGIS

Rails
ãƒªãƒ³ã‚¯
y-matsui::Weblog: [c#] ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã‚’å¿œç”ã™ã‚‹Webã‚µãƒ¼ãƒ“ã‚¹
â€ç·¯åº¦çµŒåº¦ã‚’å¼•æ•°ã«ã€è¿‘å‚ã‚’æ¤œç´¢ã™ã‚‹æ©Ÿèƒ½â€ã®ãŸã‚ã€è¡—åŒºãƒ¬ãƒ™ãƒ«ä½ç½®å‚ç…§æƒ…å ±ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’postgreSQLä¸Šã«æ§‹ç¯‰ã—ã€å¹¾ä½•ãƒ‡ãƒ¼ã‚¿æ¤œç´¢ã«ã‚ˆã£ã¦ã€æŒ‡å®šç¯„å›²ã®ãƒã‚¤ãƒ³ãƒˆã‚’æ¤œç´¢ã§ãã‚‹ã¨ã“ã‚ã¾ã§æ¥ãŸã€‚ ä»Šå›žã¯æ¬¡ã®æ®µéšŽã¨ã—ã¦ã€ã“ã‚Œã‚’Webã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã—ãŸã€‚ åˆã‚ã¦ã®ASP.NETã®Webã‚µãƒ¼ãƒ“ã‚¹é–‹ç™ºã ã€‚å¿ƒãªã—ã‹ãƒ‰ã‚ãƒ‰ã‚ã™ã‚‹ã€‚ ãƒ‰ã‚ãƒ‰ã‚ã—ã¦å§‹ã‚ãŸã¯ã„ã„ãŒã€ ã€Œãªãƒ¼ã‚“ã ã€ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã™ã‚‹å´ã‹ã‚‰ã™ã‚Œã°å˜ãªã‚‹ã‚¯ãƒ©ã‚¹ã˜ã‚ƒã‚“ã€ã£ã¦ã“ã¨ã€‚ é–‹ç™ºç’°å¢ƒï¼ˆVisualWebDeveloper2008Expressï¼‰ã‚„ãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ãŒéš ãºã„ã—ã¦ãã‚Œã¦ã„ã‚‹ãŠã‹ã’ã€‚ 100è¡Œè¶³ã‚‰ãšã®ã‚½ãƒ¼ã‚¹ã‚³ãƒ¼ãƒ‰ã§ã€ç·¯åº¦çµŒåº¦ã‹ã‚‰è¿‘å‚æ¤œç´¢Webã‚µãƒ¼ãƒ“ã‚¹ãŒã§ããŸã€‚ æ¬¡ã¯Windows Mobile GPSã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‹ã‚‰Webã‚µãƒ¼ãƒ“ã‚¹ã‚’å‚ç…§ã—ã¦ã€XMLã‚’ãƒ‘ãƒ¼ã‚¹â†’ãƒ‰ãƒãƒƒãƒ—ãƒ€ã‚¦ãƒ³ãƒªã‚¹ãƒˆã‚„ãƒ‡ãƒ¼ã‚¿ã‚°ãƒªãƒƒãƒ‰ã«è¡¨ç¤ºã™ã‚‹éƒ¨åˆ†ã ãƒ¼ã€‚ã„ã‚ˆ
shokai 2009/03/18
PostGIS

.NET

C#

geocoder
ãƒªãƒ³ã‚¯
ã‚‰ã‚€ã®å‚™å¿˜éŒ²
ã€ŒPostGISã€ã¨ã¯ã€ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®DBMSã®ã²ã¨ã¤ã§ã‚ã‚‹PostgreSQLä¸Šã§ã€ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã®å‡¦ç†ã‚’å¯èƒ½ã«ã™ã‚‹ãŸã‚ã®æ‹¡å¼µã€‚ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã€åº§æ¨™ã‚’ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§åŠ¹çŽ‡ã‚ˆãæ‰±ã†ã§è¡Œã£ãŸã®ã§ã€ä»Šå›žã¯ã“ã‚Œã‚’ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã™ã‚‹ã€‚ ã€ŒSpatial Adapter for Railsã€ã¯ã€Ruby on Railsä¸Šã§ã€PostgreSQL+PostGISã€MySQLã®ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ãˆã‚‹ã‚ˆã†ã«ã™ã‚‹ãŸã‚ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã€‚ ä»Šå›žã¯ã€ã“ã‚Œã‚’ä½¿ã£ã¦ã€Railsä¸Šã§ç©ºé–“ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã£ã¦ã¿ã‚‹ã€‚ ç’°å¢ƒ colinux + CentOS4.4 PostgreSQL 7.4.16 PostGIS 1.2.1 (+Proj4&GIOS) Ruby 1.8.5 Rails 1.2.2 Eclipse + RadR ails Subversion 1.4.3ï¼ˆSpacial Adapter for Rails ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
shokai 2008/03/20
PostGIS

Rails

GeoRuby
ãƒªãƒ³ã‚¯
GeoRuby + Spatial Adapter
GeoRuby provides data types intended to hold data returned from PostGIS and the Spatial Extensions of MySql. The data model roughly follows the OGC Simple Features for SQL specification, although without any kind of advanced functionalities (such as geometric operators or reprojections). The library inputs and outputs EWKB, HexEWKB and EWKT. A recent version also includes input and output of
shokai 2008/03/20
GeoRuby

GIS

PostGIS

Rails

Ruby
ãƒªãƒ³ã‚¯
ã“ã“ã‚®ã‚³ï¼: MySQL4.1ä»¥é™ã§ã®ç©ºé–“æƒ…å ±ã®æ‰±ã„æ–¹
Posted by nene2001 at 01:25 / Tag(Edit): mysql spatial / 2 Comments: Post / View / 1 TrackBack / Google Maps Web2.0ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ§ãƒƒãƒ—ã§è¬›æ¼”ã™ã‚‹ã®ã«ã€ãŸã ã§ã•ãˆä¸€äººã ã‘ç´ äººã§ã¾ã¨ã‚‚ãªè¬›æ¼”ã§ãã‚‹ã‹ä¸å®‰ãªã®ã«ã€å‹‰å¼·ã›ãšã«ä»Šã®çŸ¥è˜ã ã‘ã§ã¯ã„ã‹ã‚“ã ã‚ã†ã¨ã„ã†ã“ã¨ã§ã€ä»Šã¾ã§ã»ã£ãŸã‚‰ã‹ã—ã¦ããŸMySQL4.1ä»¥é™ã®ç©ºé–“æƒ…å ±åˆ©ç”¨æ³•ã‚’å‹‰å¼·ã€‚ ã¨ã„ã£ã¦ã‚‚ã€ã“ã¡ã‚‰ã«4.1ã®æ—¥æœ¬èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã‚ã‚‹ã®ã§å…¨ç„¶è‹¦åŠ´ãªã—ã ãŒã€‚ ãŸã å‹•ä½œç¢ºèªã¯5.1ã§ã‚„ã£ã¦ã„ã‚‹ã®ã§ã€è‹±èªžç‰ˆ5.1ãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã¨ã®ç…§ã‚‰ã—åˆã‚ã›ã¯ã‚„ã£ã¦ã¾ã™ã‘ã©ã€‚ä¸€å¿œã€‚ PostGISã¨ã®æ¯”è¼ƒã§æ›¸ãã¨ã€PostGISã®å ´åˆã€PostgreSQL æœ¬ä½“ã¨ã¯åˆ¥ã®ãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã‚ã‚‹ã›ã„ã‹ã€ä½ç½®æƒ…å ±ã‚«ãƒ©ãƒ ã®ã¤ã„ãŸãƒ†ãƒ¼ãƒ–ãƒ«ã¯ã„ã£ãºã‚“ã«ã¯ã§ããªã„ã€‚ ä¾‹ãˆ
shokai 2006/11/20
PostGIS

MySQL

GIS
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

ã‚‚ã£ã¨èªã‚€

å…¬å¼Twitter

@hatebu
æœ€æ–°ã®äººæ°—ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®é…ä¿¡

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

jæ¬¡ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kå‰ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

lã‚ã¨ã§èªã‚€

eã‚³ãƒ¡ãƒ³ãƒˆä¸€è¦§ã‚’é–‹ã

oãƒšãƒ¼ã‚¸ã‚’é–‹ã

è¨å®šã‚’å¤‰æ›´ã—ã¾ã—ãŸx

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

PostGISã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

ã‚¿ã‚°

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

PostGISã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

å®Ÿè·µï¼šGeoKit ã¨ iPhone ã§ä½œã‚‹ä½ç½®æƒ…å ±ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆå‰ç·¨ï¼‰ - Cirius Lab. ãƒ–ãƒ­ã‚°

y-matsui::Weblog: [c#] ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã‚’å¿œç­”ã™ã‚‹Webã‚µãƒ¼ãƒ“ã‚¹

ã‚‰ã‚€ã®å‚™å¿˜éŒ²

GeoRuby + Spatial Adapter

ã“ã“ã‚®ã‚³ï¼: MySQL4.1ä»¥é™ã§ã®ç©ºé–“æƒ…å ±ã®æ‰±ã„æ–¹

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚­ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚­ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹

é–¢é€£ã‚¿ã‚°ã§çµžã‚Šè¾¼ã‚€ (8)

PostGISã«é–¢ã™ã‚‹shokaiã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

å®Ÿè·µï¼šGeoKit ã¨ iPhone ã§ä½œã‚‹ä½ç½®æƒ…å ±ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ï¼ˆå‰ç·¨ï¼‰ - Cirius Lab. ãƒ–ãƒã‚°

y-matsui::Weblog: [c#] ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã‚’å¿œç”ã™ã‚‹Webã‚µãƒ¼ãƒ“ã‚¹

ã‚‰ã‚€ã®å‚™å¿˜éŒ²

ã“ã“ã‚®ã‚³ï¼: MySQL4.1ä»¥é™ã§ã®ç©ºé–“æƒ…å ±ã®æ‰±ã„æ–¹

ãŠçŸ¥ã‚‰ã›

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬2é€±ï¼‰

æœˆé–“ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2024å¹´12æœˆï¼‰

ä»Šé€±ã®ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æ•°ãƒ©ãƒ³ã‚ãƒ³ã‚°ï¼ˆ2025å¹´1æœˆç¬¬1é€±ï¼‰

å…¬å¼Twitter

ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆä¸€è¦§

ã¯ã¦ãªãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

å…¬å¼Twitter

ã¯ã¦ãªã®ã‚µãƒ¼ãƒ“ã‚¹