[B! geo] moqadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

moqada id:moqada

geoã«é–¢ã™ã‚‹moqadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (18)

${{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}}

ã“ã“æœ€è¿‘ã®Webåœ°å›³å‘¨è¾ºã®å‹•å‘ã‚’ã¾ã¨ã‚ã¦ã¿ãŸ
Webåœ°å›³ã®æ´å²ã¨ã„ã†ã®ã¯ Google Maps ç™»å ´ä»¥å‰ã¨ç™»å ´å¾Œã«åˆ†ã‘ã‚‰ã‚Œã‚‹ã®ã§ã™ãŒã€2015å¹´ç¾åœ¨ã€ã¾ã•ã«Google Mapsç™»å ´ã¨åŒã˜ãã‚‰ã„ã®å¤‰é©ãŒWebåœ°å›³ã®ä¸–ç•Œã«è¨ªã‚Œã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ï¼Ÿ ã¨å‹æ‰‹ã«æ€ã£ã¦ã„ã‚‹ã®ã§è‡ªåˆ†ã®è¦³æ¸¬ç¯„å›²å†…ã§ã¾ã¨ã‚ã¦ã¿ã¾ã—ãŸã€‚ æ¦‚è¦ ç°¡å˜ã«è¦ç‚¹ã‚’ã¾ã¨ã‚ã‚‹ã¨ã€Canvasã¨ã‹SVGã¨ã‹WebGLã¨ã‹ãƒ–ãƒ©ã‚¦ã‚¶å‘¨ã‚Šã®è¡¨ç¾åŠ›ã®é€²åŒ–ãŒWebåœ°å›³ã«ã‚‚å½±éŸ¿ã‚’åŠã¼ã—ã¦ã„ã¦ã€ãã“ã«GeoJSONã®ã‚ˆã†ãªãã‚Œã¾ã§GISãªã©ã«ç–Žã‹ã£ãŸãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã«ã‚‚æ°—è»½ã«æ‰±ã†ã“ã¨ãŒã§ãã‚‹ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãŒæ™®åŠã—å§‹ã‚ãŸã“ã¨ã¨ã€é™ã£ã¦æ¹§ã„ãŸã‚ˆã†ãªãƒ‡ãƒ¼ã‚¿ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚¼ãƒ¼ã‚·ãƒ§ãƒ³ãƒ–ãƒ¼ãƒ ãªã©ã«ã‚ˆã£ã¦çˆ†ç™ºçš„ã«ã‚¨ã‚³ã‚·ã‚¹ãƒ†ãƒ ãŒå¢—æ®–ã—ã€ã•ã‚‰ã«ãƒ•ãƒãƒ³ãƒˆã‚¨ãƒ³ãƒ‰å›žã‚Šã®æ–°æŠ€è¡“ã€ä»®æƒ³DOMã¨ã‹ Web Components ã¨ã‹FRPã ã¨ã‹ã‚‚ã‚ã‚‚ã‚ã„ã‚ã„ã‚çµ¡ã¾ã£ã¦ã‚ˆãã‚ã‹ã‚‰ãªã„ã‘ã©åœ°å‘³ã«å‡„ã„ã“ã¨ã«ãªã£ã¦ã„ã¾ã™ã€‚ G
moqada 2015/05/25
geo

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Elasticsearch ã‚’ä½¿ã£ãŸä½ç½®æƒ…å ±æ¤œç´¢ - ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰é–‹ç™ºè€…ãƒ–ãƒã‚°
ãƒ›ãƒªãƒ‡ãƒ¼äº‹æ¥å®¤ã®å†…è—¤ã§ã™ã€‚ ãƒ›ãƒªãƒ‡ãƒ¼äº‹æ¥å®¤ã¯æ˜¨å¹´ã®4æœˆã«ç™ºè¶³ã—ãŸéƒ¨ç½²ã§ã€Holidayï¼ˆhttps://haveagood.holidayï¼‰ã¨ã„ã†æ–°è¦ã‚µãƒ¼ãƒ“ã‚¹ã®é–‹ç™ºã‚’è¡Œã£ã¦ã„ã¾ã™ã€‚ Holiday ã¨ã¯ã€ã‚¯ãƒƒã‚¯ãƒ‘ãƒƒãƒ‰ãŒé•·å¹´å–ã‚Šçµ„ã‚“ã§ã„ã‚‹ã€Œæ¯Žæ—¥ã®æ–™ç†ã‚’æ¥½ã—ã¿ã«ã™ã‚‹ã€åˆ†é‡Žã‹ã‚‰ã¯å°‘ã—ã ã‘é›¢ã‚Œã€ã€Œã„ã¤ã‚‚ã®ä¼‘æ—¥ã‚’æ¥½ã—ãã™ã‚‹ã“ã¨ã§äººç”Ÿã‚’è±Šã‹ã«ã™ã‚‹ã€ã“ã¨ã‚’ç›®æŒ‡ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ ä¾‹ãˆã°ã“ã¡ã‚‰ã®ãŠã§ã‹ã‘ãƒ—ãƒ©ãƒ³ã®ã‚ˆã†ã«ã€ã€Œã€‡ã€‡ã«è¡Œããªã‚‰ã“ã“ã‚‚è¡Œã£ãŸã»ã†ãŒã„ã„ã‚ˆã€ã‚„ã€Œã€‡ã€‡ã‚’æ•£ç–ã™ã‚‹ãªã‚‰ã“ã®ã‚³ãƒ¼ã‚¹ã ã‚ˆãã€ãªã©ã€ãŠã§ã‹ã‘ã®ãƒ¬ã‚·ãƒ”ã‚’æŠ•ç¨¿ã—ãŸã‚ŠæŽ¢ã™ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€å…¨æ–‡æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ Elasticsearch ã‚’ä½¿ã£ã¦ã€å…¨æ–‡æ¤œç´¢ã¨ä½ç½®æƒ…å ±ã‚’çµ¡ã‚ãŸæ¤œç´¢ã«ã¤ã„ã¦ãŠè©±ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ æœ¬ç¨¿ã§èª¬æ˜Žã™ã‚‹å†…å®¹ã¯ã€å®Ÿéš›ã« Holiday ã®ä¸ã§ã‚‚å¿œç”¨ã‚’åŠ ãˆãŸå½¢ã§ä½¿ã‚ã‚Œã¦ã„ã¾ã™ã€‚ Holiday ã§ã¯ã€è¤‡æ•°
moqada 2015/03/12
elasticsearch

geo
ãƒªãƒ³ã‚¯
ç·å‹™çœã®ãƒ‡ãƒ¼ã‚¿ã‚’ä½¿ã£ã¦ã€ç·¯åº¦çµŒåº¦ã‹ã‚‰å¸‚åŒºç”ºæ‘ã®ä½•ä¸ç›®ã¾ã§ã‚’å–ã‚Šå‡ºã™ - Qiita
Deleted articles cannot be recovered. Draft of this article would be also deleted. Are you sure you want to delete this article? ãã£ã‹ã‘ã¯ã“ã®è¨˜äº‹ã§ã™ã€‚ http://qiita.com/masuidrive/it ems/21a282c7bf54fd6a4985 ã“ã“æ•°å¹´ã€ä½ç½®æƒ…å ±ã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªãƒ»ã‚µãƒ¼ãƒ“ã‚¹ãŒå¢—ãˆã¾ã—ãŸãŒã€GPSã‹ã‚‰å–å¾—å‡ºæ¥ã‚‹ç·¯åº¦çµŒåº¦ã ã‘ã§ã¯ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ä½¿ã„ã«ãã„äº‹ãŒã‚ã‚Šã¾ã™ã€‚ Googleã®Geocodingã‚µãƒ¼ãƒ“ã‚¹ãªã©ã§ã€ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã¸ã®å¤‰æ›ãŒã§ãã¾ã™ãŒã€ä»¶æ•°ã‚„é€Ÿåº¦ã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ãã“ã§ã€å›½åœŸäº¤é€šçœã®ãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«ã€ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã¸ã®å¤‰æ›ã‚’è¡Œã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ä»Šå›žã¯ã€ç·å‹™çœã®ãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«ã€ç·¯åº¦çµŒåº¦ã‹ã‚‰ä½æ‰€ã¸ã®å¤‰æ›ã‚’è¡Œã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ æ”¿
moqada 2014/11/29
geo
ãƒªãƒ³ã‚¯
MySQL TIPS 3 ç©ºé–“æƒ…å ±(geometry)ã‚’ä½¿ã£ã¦çµŒåº¦ãƒ»ç·¯åº¦ã®æ¤œç´¢ã‚’é«˜é€ŸåŒ–ã™ã‚‹ - ã‚¤ãƒŽãƒ™ãƒ¼ãƒˆãªéžæ—¥å¸¸
ä»¥ä¸‹ã®ã‚ˆã†ãªãƒ”ã‚¿ã‚´ãƒ©ã‚¹ã®å®šç†ã‚’ä½¿ã£ãŸæŒ‡å®šã—ãŸçµŒåº¦ç·¯åº¦ã«æœ€ã‚‚è¿‘ã„ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹SQLã¯çµæ§‹ã‚ã‚ŠãŒã¡ã§ã™ãŒã€CPUè² è·ãŒé«˜ãåŠ¹çŽ‡ã‚‚æ‚ªã„ã®ã§MySQLã«æ¨™æº–æè¼‰ã¨ãªã£ãŸç©ºé–“æƒ…å ±(geometry)ã‚’ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã™ã€‚ SELECT * FROM loc ORDER BY power(abs(latitude - ç·¯åº¦ ), 2) + power(abs(longitude - ç·¯åº¦ ), 2) LIMIT 1 MySQLã®ç©ºé–“æƒ…å ±(geometry)æ©Ÿèƒ½ã¯PostGIS(Postgresã‚«ã‚¹ã‚¿ãƒžã‚¤ã‚º)ã«æ¯”ã¹ã‚‹ã¨è²§å¼±ãªã®ã§ã€ãã®ç‚ºã®å·¥å¤«ã‚’è¡Œã„ã¾ã™ã€‚ä¾‹ãˆã°ã“ã“ã®ã¨ãŠã‚Šã®ã¾ã¾ã ã¨é€†ã«SQLãŒé…ããªã‚Šã¾ã™ã€‚ ã¾ãšã¯ã€ãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾©ã‹ã‚‰ é€šå¸¸ã®ãƒ†ãƒ¼ãƒ–ãƒ« CREATE TABLE IF NOT EXISTS `loc` ( `loc_id` int(11) NOT NULL auto_incremen
moqada 2014/04/30
mysql

geo
ãƒªãƒ³ã‚¯
MySQL ç·¯åº¦çµŒåº¦ã‹ã‚‰è©²å½“ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ç¯„å›²æŠ½å‡ºã™ã‚‹æ–¹æ³• | QK
ã¡ã‚‡ã£ã¨è©±ãŒã€å‰å›žã®ã‚¹ãƒˆã‚¢ãƒ‰ãƒ—ãƒã‚·ãƒ¼ã‚¸ãƒ£ã‚’ä½¿ã†è©±ã¨å‰å¾Œã—ã¦ã—ã¾ã„ã¾ã™ãŒãƒ»ãƒ»ãƒ» iPhone, Androidç‰ã®ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã®çˆ†ç™ºçš„ãªæ™®åŠã«ã‚ˆã£ã¦æœ€è¿‘ã€ä½ç½®æƒ…å ±ã‚’æ´»ç”¨ã—ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãŒå¢—ãˆã¦ãã¾ã—ãŸã€‚ã‚¹ãƒžãƒ¼ãƒˆãƒ•ã‚©ãƒ³ã‹ã‚‰å‡ºåŠ›ã•ã‚Œã‚‹ä½ç½®æƒ…å ±ã¯ã€ç·¯åº¦ã€çµŒåº¦ã®æƒ…å ±ã ã‘ãªã®ã§ã€ãã‚Œã«ç´ã¥ãä½æ‰€æƒ…å ±ã‚‚å–ã‚ŠãŸã„ã§ã™ã‚ˆãï¼Ÿï¼ˆãŸã¶ã‚“ï¼‰ã€ä»Šå›žã€MySQLã‚’åˆ©ç”¨ã—ã¦GPSãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¦ã¿ã¾ã—ãŸã€‚æƒ…å ±ãŒã‚ã¾ã‚Šãªã„ã®ã§æ‰‹é †ã‚’å«ã‚ã„ã‚ã„ã‚ã¨ä¸è¶³ãªéƒ¨åˆ†ã‚‚ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ãŒã€æ¤œè¨¼ã§ã¯ã¾ã‚ã¾ã‚ã€æœŸå¾…ã•ã‚Œã‚‹å€¤ãŒã¨ã‚Œã¦ã„ã‚‹ã¨åˆ¤æ–ã—ã¾ã—ãŸã®ã§ï½— ãã®æ‰‹é †ã‚’å…¬é–‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ä½ç½®æƒ…å ±ã®å…ƒãƒã‚¿ã‚’æŽ¢ã™ ã˜ã‚ƒã‚ä½ç½®æƒ…å ±ã£ã¦ã©ã“ã«ã‚ã‚‹ã®ï¼Ÿå®Ÿã¯ã€å›½åœŸäº¤é€šçœã«ã‚ã£ãŸã‚Šã™ã‚‹ã‚“ã§ã™ã€‚ã—ã‹ã‚‚ç„¡å„Ÿã§è‡ªç”±ãªç›®çš„ã§åˆ©ç”¨ã§ããŸã‚Šã¾ã™ã€‚çŸ¥ã‚‰ãªã‹ã£ãŸã€‚ ä»Šå›žã®èª¬æ˜Žã§ã¯ã€ä½ç½®æƒ…å ±ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€MySQLã®åœ°ç†æƒ…å ±ãƒ†ãƒ¼ãƒ–ãƒ«ã«å–ã‚Šè¾¼ã¿ã€
moqada 2014/04/30
geo

mysql
ãƒªãƒ³ã‚¯
ä½ç½®æƒ…å ±ã‚µãƒ¼ãƒ“ã‚¹ã«å¿…è¦ãªæŠ€è¡“ã¾ã¨ã‚ Â« TheDesignium
6ã€Google Map (V3)ã§ãƒžãƒ¼ã‚«ãƒ¼ã‹ã‚‰ã®åŠå¾„ã«è‰²ã‚’ã¤ã‘ã‚‹ ä¸Šè¨˜ã®æŠ€è¡“ã¨çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§ã€ãƒžãƒ¼ã‚«ãƒ¼ã‚’ãƒ‰ãƒ©ãƒƒã‚°ã—ã€åŠå¾„ã‚’é¸æŠžã™ã‚‹ã“ã¨ã§æ¤œç´¢ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’ä½œæˆã§ãã¾ã™ã€‚ setRadiusã«ã‚ˆã‚Šãƒ¡ãƒ¼ãƒˆãƒ«å˜ä½ã§åŠå¾„ã‚’æŒ‡å®šã—ã€bindToã§æç”»ã™ã‚‹ã ã‘ã§ã™ã€‚å€¤ã¯jQueryã«ã‚ˆã‚Šid=â€™r'ã‹ã‚‰ã¨ã£ã¦ãã¦ã„ã¾ã™ã®ã§ã€å€¤ãŒå¤‰ã‚ã£ãŸã‚‰setc ircleã‚’å‹•ã‹ã—ã¦åˆ©ç”¨ã—ã¾ã™ã€‚ //============== var centerPos = new google.maps.LatLng( 37.521108333 , 139.938030556 ); var mapOptions = {zoom : 15,center : centerPos,mapTypeId: google.maps.MapTypeId.ROADMAP}; var map = new google.maps.Map(doc
moqada 2014/04/30
geo

mysql

postgresql

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
Webã‚µãƒ¼ãƒ“ã‚¹ã«ãŠã‘ã‚‹å¤–éƒ¨APIã®ä½¿ç”¨(ãã®2) - MySQL Spatial Extensionsã«ã‚ˆã‚‹ä½ç½®æƒ…å ±ã®æ¤œç´¢ - O'Reilly Japan Community Blog
æœ€è¿‘ã®Webã‚µãƒ¼ãƒ“ã‚¹ã§ã¯ã€å¤–éƒ¨APIã‚’æ´»ç”¨ã—ãŸã‚‚ã®ãŒéžå¸¸ã«å¤šããªã£ã¦ã„ã¾ã™ã€‚å‰å›žã¯å¤–éƒ¨APIã®ã‚¢ã‚¯ã‚»ã‚¹æ•°åˆ¶é™ã‚’å›žé¿ã™ã‚‹ãŸã‚ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã€åŠã³å…·ä½“ä¾‹ã¨ã—ã¦ä½ç½®æƒ…å ±ã‚µãƒ¼ãƒ“ã‚¹ã®foursquare APIã®çµæžœã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹ä»•çµ„ã¿ã‚’è¨è¨ˆã—ã¾ã—ãŸã€‚ä»Šå›žã¯ã€MySQLã«ä¿å˜ã•ã‚ŒãŸä½ç½®æƒ…å ±ãƒ‡ãƒ¼ã‚¿ã®ã‚ãƒ£ãƒƒã‚·ãƒ¥ã‚’MySQL Spatial Extensionsã‚’ä½¿ã£ã¦æ¤œç´¢ã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã™ã€‚ ã¯ã˜ã‚ã« Rettyæ ªå¼ä¼šç¤¾ã®é¹¿å³¶ã§ã™ã€‚å‰å›žã¯ã€æœ€è¿‘ã®Webã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ˆãä½¿ã‚ã‚Œã¦ã„ã‚‹å¤–éƒ¨ã®APIãŠã‚ˆã³ã‚µãƒ¼ãƒ“ã‚¹åœæ¢ã«è‡´å‘½çš„ãªå½±éŸ¿ã‚’ä¸Žãˆã‹ããªã„rate limitã«ã¤ã„ã¦èª¬æ˜Žã—ã¾ã—ãŸã€‚ã¾ãŸrate limitã®è¶…éŽã‚’é˜²ããŸã‚ã®ã€Œã‚ãƒ£ãƒƒã‚·ãƒ¥ã€ã¨ã„ã†æ–¹æ³•ã«ã¤ã„ã¦ã‚‚èª¬æ˜Žã—ã¾ã—ãŸã€‚ å…·ä½“ä¾‹ã¨ã—ã¦ã€ä½ç½®æƒ…å ±SNSã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹foursquareã®APIã‚’å–ã‚Šä¸Šã’ã€ãã®çµæžœã‚’ã‚ãƒ£ãƒƒã‚·ãƒ¥ã™ã‚‹ä»•çµ„ã¿ã®åŸºæœ¬çš„ãªè¨è¨ˆã‚’èª¬æ˜Ž
moqada 2014/04/30
mysql

geo
ãƒªãƒ³ã‚¯
GeoHashã‚’ä¸å¿ƒã«ï¼Œã¯ã¦ãªæŠ€è¡“å‹‰å¼·ä¼šã‚’å—ã‘ã¦ã®è°è«–
ã¯ã¦ãª æŠ€è¡“å‹‰å¼·ä¼š #1 ã®ç¬¬2éƒ¨ã§ã€Œä½ç½®æƒ…å ±ã®å–èª¬ã€ã¨ã„ã†ç™ºè¡¨ãŒ id:chris4403 ã•ã‚“ã«ã‚ˆã£ã¦è¡Œã‚ã‚Œã¾ã—ãŸï¼Ž http://d.hatena.ne.jp/hatena tech/20100823/1282536309 ã“ã“ã§ã¯ï¼Œã“ã®å‹‰å¼·ä¼šã§è©±é¡Œã«ãªã£ãŸGeoHashã¨ã„ã†æŠ€è¡“ã‚’ä¸å¿ƒã« å‹‰å¼·ä¼šä¸ã®è°è«–åŠã³å¾Œæ—¥è«‡ã‚’ã¾ã¨ã‚ã¦ã„ã¾ã™ï¼Ž ç¶šãã‚’èªã‚€
moqada 2014/04/30
geo
ãƒªãƒ³ã‚¯
Solrã®Spatial Searchã‚’è©¦ã—ã¦ã¿ãŸ - Y's note
å‰æ›¸ã 10ä»£ã®é ƒã¯(ã‚´ãƒ¼ã‚¹ãƒˆ)ãƒ©ã‚¤ã‚¿ãƒ¼ã¨ã„ã†è·æ¥ã«æ†§ã‚Œã¦ã„ãŸæ™‚æœŸã‚‚ã‚ã‚Šã¾ã—ãŸ@yutakikuchi_ã§ã™ã€‚ Geospatial Indexes and Queries â€• Mongo DB Manual 2.4.9 MySQL :: MySQL 4.1 ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« :: 10.6.1 ç©ºé–“ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã®ä½œæˆ ä½ç½®æƒ…å ±Indexã‚’Mongo DBã§ç®¡ç†ã™ã‚‹æ‰‹æ³•ã«ã¤ã„ã¦ã¯å‰ã«èª¿æŸ»æ¸ˆã¿ã§ã€mysqlã«ã‚‚Spatialindexã¯ã‚ã¾ã‚Šæ™®åŠã—ã¦ã„ãªã„å°è±¡ã€ã¨ã„ã†ã“ã¨ã§...ä»Šæ—¥ã¯æ¤œç´¢Solrã®Spatial Searchã«ã¤ã„ã¦èª¿ã¹ã¦ã¿ã¾ã™ã€‚æœ€çµ‚çš„ã«ã¯Fessã‚„Nutchã§WebPageã‚’Crawlingã—ã¦å¾—ãŸä½æ‰€ãƒ‡ãƒ¼ã‚¿ã‚’Geocodingã§Lat/Lngãƒ‡ãƒ¼ã‚¿ã«å¤‰æ›ã—ã¦è‡ªå‰ã®Serverã«Indexingã—ã¦ã„ãäº‹ã‚’è€ƒãˆã¦ãŠã‚Šã€ãã®å‰æ®µéšŽã®ä½œæ¥ã§ã™ã€‚Solrã‚’é¸ã¶ç†ç”±ã§ã™ãŒSpa
moqada 2014/04/30
solr

geo
ãƒªãƒ³ã‚¯
MySQLãƒ¦ãƒ¼ã‚¶è¦–ç‚¹ã§ã®å°ã•ãå§‹ã‚ã‚‹Elasticsearch
2. 1. ã¯ã˜ã‚ã« 2. è‡ªå·±ç´¹ä»‹ 3. ä»Šå›žã®ãƒ†ãƒ¼ãƒž æœ¬æ—¥ã®æµã‚Œ 4. Yamabikoã®ç´¹ä»‹ 5. æ¤œç´¢ã“ã¨ã¯ã˜ã‚ 6. Elasticsearché›‘æ„Ÿ 7. ã¾ã¨ã‚ page 2
moqada 2014/04/30
elasticsearch

mysql

geo

presentation
ãƒªãƒ³ã‚¯
ä½ç½®æƒ…å ±ï¼ˆç·¯åº¦ã€çµŒåº¦ï¼‰ã‚’MySQLã®Geometryåž‹ã§ä¿å˜ã™ã‚‹
ã“ã‚“ã°ã‚“ã¯ã€‚BSäº‹æ¥éƒ¨éšŠå“¡ã§ã™ã€‚ ä»Šå›žã¯ã€ä½ç½®æƒ…å ±(ç·¯åº¦ã€çµŒåº¦)ã®ä¿å˜æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ ã“ã‚Œã‚‚ã¾ãŸå¾—æ„ã®ã‚°ã‚°ã‚Šã§è¦‹ã¤ã‘ãŸã‚‚ã®ã§ã™ã€‚ ãƒ»ä½ç½®æƒ…å ±ã‚µãƒ¼ãƒ“ã‚¹ã®ã¯ã˜ã‚æ–¹ ãƒ»Google Mapsã¨MySQLã®é€£æº MySQL(v5.0)ã®Geometryåž‹.... ä¾¿åˆ©ãã†ï¼ã¨ã†ã„ã†ã“ã¨ã§ä½¿ã£ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã€‚ .... ãã‚ã—ã„ã“ã¨ã¯ã€å…ˆè¼©æ–¹ã®ã‚µã‚¤ãƒˆã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚è©³ã—ãè¼‰ã£ã¦ã¾ã™ã€‚ ã“ã“ã§ã¯ã€ãƒã‚¤ãƒ³ãƒˆã ã‘ã€‚â€» ä¾‹ã®ä½ç½®æƒ…å ±ã¯é©å½“ã§ã™ã€‚ ï¼‘ï¼ŽGeometryåž‹ã¨ã¯ MySQL4.1ä»¥é™ã§ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ç©ºé–“æƒ…å ±ã‚’æ‰±ã†ãƒ‡ãƒ¼ã‚¿åž‹ ï¼’ï¼Žãƒ†ãƒ¼ãƒ–ãƒ«å®šç¾© å¯¾è±¡ã‚«ãƒ©ãƒ ã®åž‹ã‚’Geometryã¨ã™ã‚‹ã ã‘ã€‚ CREATE TABLE points ( point_id INT NOT NULL ,latlon GEOMETRY NOT NULL ,PRIMARY KEY (point_id) ,SPATI
moqada 2014/04/30
geo

mysql
ãƒªãƒ³ã‚¯
ã€Œç°¡æ˜“é€†ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ã®ä½œã‚Šæ–¹ - PostGIS ã¨ç„¡å„Ÿãƒ‡ãƒ¼ã‚¿ã¨åœ°å›³ã®çŸ¥è˜å°‘ã€… - / How to make "Simple Reverse Geo-coding Service" - Information on PostGIS, Maps and Free Data - â€” NPOæ³•äºº æ—¥æœ¬PostgreSQLãƒ¦ãƒ¼ï¿½ï¿½
ã€Œç°¡æ˜“é€†ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã€ã®ä½œã‚Šæ–¹ - PostGIS ã¨ç„¡å„Ÿãƒ‡ãƒ¼ã‚¿ã¨åœ°å›³ã®çŸ¥è˜å°‘ã€… - / How to make "Simple Reverse Geo-coding Service" - Information on PostGIS, Maps and Free Data - Click here to get the file Size 435.1 kB - File type application/pdf
moqada 2014/04/30
geo
ãƒªãƒ³ã‚¯
ä½ç½®æƒ…å ±ç³»å‡¦ç†ã®ãŠè©± a.k.a ç¶šãƒ»è‡ªæ–‡æ›¸æŠ½å‡ºæ—¥æœ¬çš„ä½æ‰€
moqada 2014/04/30
geo

presentation
ãƒªãƒ³ã‚¯
åœ°ç†ç©ºé–“æƒ…å ±ã‚’ç°¡å˜ã«è¡¨ç¤ºã—ã‚ˆã†ï¼ Geothematics (Geo Fuse) Lightning Talk tokyo
ç¬¬10å›žã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆç™ºè¡¨è³‡æ–™ã€‚ Georepublic ç¤¾ãŒæä¾›ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ“ã‚¸ãƒ¥ã‚¢ãƒ©ã‚¤ã‚¼ãƒ¼ã‚·ãƒ§ãƒ³ã‚µãƒ¼ãƒ“ã‚¹ã€Geothematics åŠã³ GeoFuse ã«é–¢ã™ã‚‹ãƒ©ã‚¤ãƒˆãƒ‹ãƒ³ã‚°ãƒˆãƒ¼ã‚¯è³‡æ–™ã§ã™ã€‚ Geothematics: http://geothematics.com/ GeoFuse: http://geofuse.georepublic.net/Read less
moqada 2014/04/30
geo

presentation
ãƒªãƒ³ã‚¯
é¢ç™½ã„ï¼ä½ç½®æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¯ãƒ©ã‚¦ãƒ‰æä¾›Â·CartoDB MOONGIFT
CartoDBã¯ä½ç½®æƒ…å ±ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¯ãƒ©ã‚¦ãƒ‰æä¾›ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã§ã™ã€‚ åœ°å›³ã‚’ä½¿ã£ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã¯å¸¸ã«äººæ°—ãŒã‚ã‚Šã¾ã™ã€‚ãã‚“ãªä¸ã€ä½ç½®æƒ…å ±ã‚’æ ¼ç´ã§ãã‚‹DBã‚’ã‚¯ãƒ©ã‚¦ãƒ‰ã§æä¾›ã™ã‚‹ã®ãŒCartoDBã§ã™ã€‚ OSSé˜ªã®ä»–ã€Webã‚µãƒ¼ãƒ“ã‚¹ç‰ˆã‚‚æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ã“ã¡ã‚‰ã¯Webã‚µãƒ¼ãƒ“ã‚¹ç‰ˆã§ã™ã€‚ ã¾ãšã‚µã‚¤ãƒ³ã‚¢ãƒƒãƒ—ã—ã¾ã™ã€‚ ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œæˆã—ã¾ã™ã€‚ã‚µãƒ–ãƒ‰ãƒ¡ã‚¤ãƒ³ã‚‚æ±ºã‚ã¾ã™ã€‚ ãƒžãƒƒãƒ”ãƒ³ã‚°ãŒçµ‚ã‚ã£ã¦DNSã«åæ˜ ã•ã‚Œã‚‹ã¾ã§ã¯å°‘ã—æ™‚é–“ãŒã‹ã‹ã‚Šã¾ã™ã€‚ ãƒã‚°ã‚¤ãƒ³ã—ã¾ã—ãŸã€‚ã“ã‚Œã¯ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã§ã™ã€‚ ã¾ãšãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ è¡Œã‚’è¿½åŠ ã—ã¾ã™ã€‚ä½ç½®æƒ…å ±ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ å…¥åŠ›ã—ã¾ã—ãŸã€‚ åœ°å›³è¡¨ç¤ºã«åˆ‡ã‚Šæ›¿ãˆã‚‹ã¨ç™»éŒ²ã—ãŸä½ç½®ã«ãƒžãƒ¼ã‚«ãƒ¼ãŒç«‹ã¡ã¾ã™ã€‚ ãƒžãƒ¼ã‚«ãƒ¼ã«å¯¾å¿œã—ãŸæƒ…å ±ã‚‚è¡¨ç¤ºã§ãã¾ã™ã€‚ ãƒžãƒ¼ã‚«ãƒ¼ã®è‰²è¨å®šã§ã™ã€‚ SQL APIãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒžãƒƒãƒ— APIã®èª¬æ˜Žã§ã™ã€‚ CartoDBã¯ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦PostGISã‚’ä½¿ã£
moqada 2014/04/25
geo

webservice

library
ãƒªãƒ³ã‚¯
å„ç¨®ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°apiã®ç½ ã¨å¯¾å‡¦æ³• - æ–‡ç³»ãƒ—ãƒã‚°ãƒ©ãƒžã«ã‚ˆã‚‹TIPSãƒ–ãƒã‚°
è‰²ã€…ã‚ã‚‹ã®ã§ãã‚Œãžã‚Œè¦ç´„ã‚’èª¿ã¹ã¦ã¿ã¾ã—ãŸã‚ˆã€œ å„ç¨®ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ãŒã€ä¸»ã«åˆ©ç”¨åˆ¶é™å‘¨ã‚Šã«ç½ ãŒã‚ã‚Šã¾ã™ã€‚ã“ã‚Œã‚’ã—ã£ã¦ã„ãªã„ã¨è‰²ã€…åˆ©ç”¨è¦ç´„ã«é•åã—ã¦ã—ã¾ã†ã®ã§ã€æ°—ã‚’ã¤ã‘ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ãã‚Œãžã‚Œå†…å®¹ã‚’ç¢ºèªã—ã€ã¾ãšã¯åˆ¶é™ã‚’çŸ¥ã‚Šã€å¯¾ç–ã‚’æ¤œè¨Žã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ è¨˜äº‹ã®æœ€å¾Œã«ã€å®Ÿæˆ¦å‘ãã®ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°å‡¦ç†ã‚’è¼‰ã›ã¦ã„ã‚‹ã®ã§ã€æ˜¯éžã”è¦§ä¸‹ã•ã„ã€‚ å„ç¨®ã‚¸ã‚ªã‚³ãƒ¼ãƒ€ google geocoding v2 google geocoding v3 Yahoo!ã‚¸ã‚ªã‚³ãƒ¼ãƒ€API ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã®åˆ¶é™ å›½åœŸäº¤é€šçœï¼šä½ç½®å‚ç…§æƒ…å ±ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ å®Ÿè·µã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ï¼ï¼ çŒ«ã§ã‚‚è§£ã‚‹ç°¡æ˜“å‡¦ç†ãƒ•ãƒãƒ¼ ç”¨æ„ã™ã‚‹ã‚‚ã®ï¼šã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚ãƒ¥ãƒ¼ãƒ†ãƒ¼ãƒ–ãƒ« ç”¨æ„ã™ã‚‹ã‚‚ã®ï¼šã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°çµæžœãƒ†ãƒ¼ãƒ–ãƒ« ç”¨æ„ã™ã‚‹ã‚‚ã®ï¼šã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚µã‚¤ãƒ‰ã§Googleã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚° ç”¨æ„ã™ã‚‹ã‚‚ã®ï¼šã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ã®ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒãƒƒãƒ
moqada 2014/04/24
geo

map

api
ãƒªãƒ³ã‚¯
groongaã§é«˜é€Ÿãªä½ç½®æƒ…å ±æ¤œç´¢ - 2011-09-13 - ã‚¯ã‚¯ãƒã‚°
groongaã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚‚ä½ç½®æƒ…å ±æ¤œç´¢ã«ã¤ã„ã¦æ›¸ã‹ã‚Œã¦ã„ã‚‹ã®ã§ã™ãŒã€æƒ…å ±ã®æ›´æ–°ãŒè¿½ã„ã¤ã„ã¦ã„ãªã„ãŸã‚æƒ…å ±ãŒä¸è¶³ã—ã¦ã„ã¾ã™ã€‚ãã“ã§ã€ã“ã“ã«ç¾çŠ¶ã«åˆã‚ã›ãŸgroongaã®ä½ç½®æƒ…å ±æ¤œç´¢ã«ã¤ã„ã¦ã®æƒ…å ±ã‚’ã¾ã¨ã‚ã¦ãŠãã¾ã™ã€‚ãªãŠã€ã“ã“ã«ã¾ã¨ã‚ãŸå†…å®¹ã‚‚ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«åæ˜ ã•ã›ã‚‹äºˆå®šã§ã™ã€‚ ã§ãã‚‹ã“ã¨ groongaã«ã¯ä½ç½®æƒ…å ±ã‚’ç”¨ã„ãŸæ¤œç´¢æ©Ÿèƒ½ãŒã¤ã„ã¦ã„ã¾ã™ã€‚ä½ç½®æƒ…å ±ã‚’ç”¨ã„ãŸæ¤œç´¢ã§ã¯ç´¢å¼•ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ã€å…¨æ–‡æ¤œç´¢ã¨åŒã˜ã‚ˆã†ã«é«˜é€Ÿã«æ¤œç´¢ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ãŸã ã—ã€PostGISã‚„MySQLã®ã‚ˆã†ã«1ç·šã‚„é¢ãªã©ã‚‚ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ä¿æŒã§ãã‚‹ã¨ã„ã†ã‚ã‘ã§ã¯ãªãã€ç‚¹ã®ã¿ã‚’ãƒ‡ãƒ¼ã‚¿ã¨ã—ã¦ä¿æŒã§ãã¾ã™ã€‚ã‚ˆã£ã¦ã€groongaã«ã§ãã‚‹ã“ã¨ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ æŒ‡å®šã—ãŸå››è§’ã®ä¸ã«å«ã¾ã‚Œã¦ã„ã‚‹åº§æ¨™ã‚’æŒã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ã€‚ æŒ‡å®šã—ãŸå††ã®ä¸ã«å«ã¾ã‚Œã¦ã„ã‚‹åº§æ¨™ã‚’æŒã¤ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’æ¤œç´¢ã™ã‚‹ã€‚ åº§æ¨™é–“ã®è·é›¢ã‚’è¨ˆç®—ã™ã‚‹ã€‚ ã‚ã‚‹åº§æ¨™ã‹ã‚‰ã®è·é›¢ãŒè¿‘
moqada 2012/01/25
groonga

geo

mysql
ãƒªãƒ³ã‚¯
iPhoneã§ä½¿ãˆã‚‹ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãƒ©ã‚¤ãƒ–ãƒ©ãƒªÂ·GMGeocoder MOONGIFT
GMGeocoderã¯iPhoneå‘ã‘ã®ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚iPhoneã¯æºå¸¯é›»è©±ãªã®ã§å¤–ã§ä½¿ã†ã‚±ãƒ¼ã‚¹ãŒå¤šãã€ãã®ãŸã‚ã«åœ°å›³ã‚„å ´æ‰€ã‚’åŸºç‚¹ã¨ã—ãŸæƒ…å ±ã¨ç›¸æ€§ãŒã„ã„ã€‚ã•ã‚‰ã«GPSã‚‚å…¥ã£ã¦ã„ã‚‹ã®ã§ä½ç½®æƒ…å ±ã«é–¢ã—ã¦ã¯ã°ã£ã¡ã‚Šã ã€‚ã ãŒä½æ‰€ã‹ã‚‰ä½ç½®æƒ…å ±ã«å¤‰æ›ã™ã‚‹ã‚¸ã‚ªã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ãŒå¼±ã„ã‚ˆã†ã ã€‚ æ—¥æœ¬èªžã‚‚ä½¿ãˆã‚‹ ãã“ã§ä½œã‚‰ã‚ŒãŸãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒGMGeocoderã ã€‚é©å½“ãªä½æ‰€ã®æ–‡å—åˆ—ã‚’ä½ç½®æƒ…å ±å¤‰æ›ã—ã¦å¤‰æ›ã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚ã‚‹Tiny Geocoderã‚’ä½¿ã„ã€iPhoneã§ä»»æ„ã®æ–‡å—åˆ—ã‹ã‚‰ä½æ‰€æƒ…å ±ã‚’å–å¾—ã—ã¦è¿”ã™ã“ã¨ãŒã§ãã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã«ãªã£ã¦ã„ã‚‹ã€‚ è‹±èªžã¯ã‚‚ã¡ã‚ã‚“ã€æ—¥æœ¬èªžã‚’ä½¿ã†ã“ã¨ã‚‚ã§ãã‚‹ã€‚ãƒ‡ãƒ¢ã‚¢ãƒ—ãƒªã§ã¯ãƒ†ã‚ã‚¹ãƒˆãƒœãƒƒã‚¯ã‚¹ã«ä»»æ„ã®ä½æ‰€ã‚’å…¥åŠ›ã™ã‚Œã°ã€Googleãƒžãƒƒãƒ—ä¸Šã«ãƒ”ãƒ³ã‚’ç«‹ã¦ã¦ãã‚Œã‚‹ã€‚ãã®æ™‚ã«ã¯ç·¯åº¦çµŒåº¦ã«é–¢ã™ã‚‹æƒ…å ±ã‚‚è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ã€‚ã“ã‚Œã¯åœ°å›³ã«ãã®ã¾ã¾æŠ•å½±ã—ã¦ã„ã‚‹ãŒã€ã‚‚ã£ã¨è‰²ã€…ãªä½¿ã„æ–¹ãŒè€ƒãˆã‚‰ã‚Œã‚‹ã ã‚ã†
moqada 2010/01/11
iphone

geo

library
ãƒªãƒ³ã‚¯
1