[B! GPS][ã‚ã¨ã§èªã‚€] d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

d4-1977 id:d4-1977

GPSã¨ã‚ã¨ã§èªã‚€ã«é–¢ã™ã‚‹d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ç¬¬2å›žã€€ä½ç½®æƒ…å ±ã‚’å–å¾—ã—ã¦ã¿ã‚ˆã†ï¼ˆå‰ç·¨ï¼‰ | gihyo.jp
é€£è¼‰ç¬¬2å›žç›®ã®ä»Šå›žã¯ã€æœ€åˆã«ä½ç½®æƒ…å ±ã®åŸºæœ¬çš„ãªå†…å®¹ã‚’ç¢ºèªã—ã¦ã€å®Ÿéš›ã®ãƒ‡ãƒã‚¤ã‚¹ã‹ã‚‰ä½ç½®æƒ…å ±ã‚’å–å¾—ã—ã¦ã¿ã¾ã™ã€‚ ä½ç½®æƒ…å ±ã®åŸºæœ¬ ä½ç½®æƒ…å ±ã¯åœ°çƒä¸Šã®ã‚ã‚‹åœ°ç‚¹ã‚’æŒ‡ã—ç¤ºã™æƒ…å ±ã§ã€ä¸»ã«ã€Œç·¯åº¦ã€ã€Œâ çµŒåº¦ã€ã§è¡¨ç¾ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ ã€Œç·¯åº¦ã€ã¯ã€ã‚ã‚‹åœ°ç‚¹ã®èµ¤é“é¢ã¨ã®è§’åº¦ã®ã“ã¨ã§ã™ã€‚èµ¤é“ä¸Šã‚’0åº¦ã¨ã—ã¦ã€åŒ—æ¥µç‚¹ã€å—æ¥µç‚¹ã§ãã‚Œãžã‚ŒåŒ—ç·¯90åº¦ã€å—ç·¯90åº¦ã¨ãªã‚Šã¾ã™ã€‚è‹±èªžã§ã¯ã€latitudeã¨ãªã‚Šã€çœç•¥ã•ã‚Œã‚‹ã¨ãã¯latã¨ãªã‚Šã¾ã™ã€‚ ã€Œç·¯åº¦ã€ã¯ã€ã‚ã‚‹åœ°ç‚¹ã®ã‚°ãƒªãƒ‹ãƒƒã‚¸ååˆç·šã‹ã‚‰ã®è§’åº¦ã®ã“ã¨ã§ã™ã€‚ååˆç·šä¸Šã‚’0åº¦ã¨ã—ã¦ã€ã‚°ãƒªãƒ‹ãƒƒã‚¸ã‹ã‚‰æ±ã‚’æ±çµŒã€è¥¿ã‚’è¥¿çµŒã¨å‘¼ã³ã¾ã™ã€‚è‹±èªžã§ã¯ã€longitudeã¨ãªã‚Šã€çœç•¥ã•ã‚Œã‚‹ã¨ãã¯ã€lonã‚„lngã¨ãªã‚Šã¾ã™ã€‚ ç·¯åº¦ã‚‚çµŒåº¦ã‚‚ã€35Â°40â â€™19.31â â€ã®ã‚ˆã†ã«åº¦åˆ†ç§’ã€ã‚‚ã—ãã¯35.672031ã®ã‚ˆã†ã«åº¦ã®ã¿ã§è¡¨ç¾ã•ã‚Œã¾ã™ã€‚åº¦åˆ†ç§’ã‹ã‚‰åº¦ã®è¡¨è¨˜ã«ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«å¤‰æ›ã§ãã¾ã™ã€‚ 35 + (
d4-1977 2010/10/16
ã‚±ãƒ¼ã‚¿ã‚¤ã§ã®ä½ç½®æƒ…å ±ã‚‚å«ã‚€é€£è¼‰

ä½ç½®æƒ…å ±

ã¯ã¦ãª

ã‚ã¨ã§èªã‚€

GPS

mobile
ãƒªãƒ³ã‚¯
ç¬¬ä¸€å›žGeoHexå‹‰å¼·ä¼šã¨ãã®å‘¨è¾º
@sa2daã•ã‚“ã«ã‚ˆã‚‹GeoHex http://geogames.net/labs/geohex ã®å‹‰å¼·ä¼šã¨ã€ãã®å‘¨è¾ºã§ã®tweetã§ã™ã€‚ GeoHexã«ã¤ã„ã¦ http://geogames.net/labs/geohex GeoHexv2ã«ã¤ã„ã¦ http://geogames.net/geohex/v2 ç¶šãã‚’èªã‚€
d4-1977 2010/10/07
GeoHex

GPS

ä½ç½®æƒ…å ±

Twitter

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ç¬¬6å›žã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆé–‹å‚¬ã„ãŸã—ã¾ã—ãŸã€‚
ä»Šå›žã§6å›žç›®ã¨ãªã‚‹ã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆã€‚é§’å ´æ±å¤§ã§é–‹å‚¬ã—ã€330åã‚’è¶…ãˆã‚‹æ¥å ´è€…ã‚’é›†ã‚ãŸå‰å›žã®ã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆã‚’çµŒã¦ã€ä»Šå›žã¯Gç©ºé–“EXPOã¨ã„ã†ã‚¤ãƒ™ãƒ³ãƒˆã®ä¸ã§é–‹å‚¬ã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ä»Šå›žã¯å¸æ•°ãŒ176å¸ã¨å°‘ãªã‹ã£ãŸã“ã¨ã‚‚ã‚ã‚Šã€å—ä»˜é–‹å§‹æ—©ã€…ã«å®šå“¡ã«é”ã—ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ç§ã¯ã€ä¸»å¹¹äº‹åŠã³ç·åˆå¸ä¼šã€ãƒ“ã‚¸ãƒã‚¹ã‚»ãƒƒã‚·ãƒ§ãƒ³ã®å¸ä¼šã‚’æ‹…å½“ã—ã¾ã—ãŸã®ã§ã€ã‚¤ãƒ™ãƒ³ãƒˆã‚’æŒ¯ã‚Šè¿”ã£ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ åŸºæœ¬æƒ…å ± ç¬¬6å›žã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆ 9æœˆ20æ—¥ã€€10:00ã€œ17:00ã€€ãƒ‘ã‚·ãƒ•ã‚£ã‚³æ¨ªæµœã€€ã‚¢ãƒãƒƒã‚¯ã‚¹ãƒ›ãƒ¼ãƒ« ãƒ—ãƒã‚°ãƒ©ãƒ ï¼š http://atnd.org/events/6799 Ustreamã«ã‚ˆã‚‹éŒ²ç”»ã‚’ã€TechWaveã•ã‚“ã®ãƒãƒ£ãƒ³ãƒãƒ«ã§é–²è¦§ã§ãã¾ã™ã€‚ http://www.ustream.tv/channel/techwavejp åˆã®è©¦ã¿ã¨ãªã‚‹ã€çµ‚æ—¥ã‚¤ãƒ™ãƒ³ãƒˆ çµ‚æ—¥é–‹å‚¬ã¨ã„ã†ã®ã¯ã€ã“ã‚Œã¾ã§ã«ãªã„
d4-1977 2010/09/29
ã‚ã¨ã§èªã‚€

GPS

ä½ç½®æƒ…å ±
ãƒªãƒ³ã‚¯
ä¸€æ—¥ä¸€æ© : CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚
2010å¹´09æœˆ07æ—¥23:39 ã‚«ãƒ†ã‚´ãƒªé–‹ç™ºCakePHP CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚ ãŠã²ã•ã—ã¶ã‚Šã§ã™ã€‚ å‰å›žæ›´æ–°ã‹ã‚‰ã€ãšã„ã¶ã‚“æ™‚é–“ãŒçµŒã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ä»Šå›žã®ãƒã‚¿ã¯ã‚¿ã‚¤ãƒˆãƒ«ã®é€šã‚Šã§ã™ã€‚ ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°é–¢ä¿‚ã®ã“ã¨ãªã®ã§ã€èˆˆå‘³ãªã„äººã¯ã‚¹ãƒ«ãƒ¼ã—ã¦ãã ã•ã„ã€‚ Geometryåž‹ã£ã¦ä½•ï¼Ÿã¨ã„ã†ã®ã¯ä»¥ä¸‹ã‚’ã”è¦§ãã ã•ã„ã€‚ http://dev.mysql.com/doc/refman/5.1/ja/spatial-extensions.html ç§ã¯ã€Google Mapsã¨ã‹ã«è¡¨ç¤ºã™ã‚‹ã‚³ãƒ³ãƒ†ãƒ³ãƒ„ã«é–¢ã—ã¦ã€åº§æ¨™ã‚„ãƒãƒªãƒ©ã‚¤ãƒ³ã‚’æ ¼ç´ã™ã‚‹ãŸã‚ã«ä½¿ã„ãŸã„ã¨æ€ã£ã¦ã„ã¾ã™ã€‚ ä»Šå›žã€åº§æ¨™ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ãŸã„ã‚«ãƒ©ãƒ åã‚’'latlng'ã¨ã—ã€åž‹ã«ã¯Geometryã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã¯ãŠã¾ã‹ã›ã™ã‚‹ã¨ã—ã¦ã€å•é¡Œã¯ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã‚’ã©ã†ã™ã‚‹ã‹ã§ã™ã€‚ é€šå¸¸ã¯ã€ãƒ¢ãƒ‡ãƒ«ã®saveãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿
d4-1977 2010/09/10
CakePHP

GPS

ä½ç½®æƒ…å ±

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
ï¼ ãƒãƒƒãƒˆãŠãŸã:RE:CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚
CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚ ä»Šå›žã€åº§æ¨™ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã—ãŸã„ã‚«ãƒ©ãƒ åã‚’'latlng'ã¨ã—ã€åž‹ã«ã¯Geometryã‚’ä½¿ç”¨ã—ã¾ã—ãŸã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆæ–¹æ³•ã¯ãŠã¾ã‹ã›ã™ã‚‹ã¨ã—ã¦ã€å•é¡Œã¯ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã‚’ã©ã†ã™ã‚‹ã‹ã§ã™ã€‚ é€šå¸¸ã¯ã€ãƒ¢ãƒ‡ãƒ«ã®saveãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹ã¨æ€ã„ã¾ã™ã€‚ saveãƒ¡ã‚½ãƒƒãƒ‰ã§ã†ã¾ãå‡ºæ¥ã‚Œã°ã‚ˆã‹ã£ãŸã®ã§ã™ãŒã€ã©ã†ã—ã¦ã‚‚ã†ã¾ãã„ã‹ãªã‹ã£ãŸã®ã§ã€ä»Šå›žã¯ãƒ¢ãƒ‡ãƒ«ã®å®Ÿè£…éƒ¨åˆ†ã§afterSaveãƒ¡ã‚½ãƒƒãƒ‰ã‚’ã‚ªãƒ¼ãƒãƒ¼ãƒ©ã‚¤ãƒ‰ã—ã¦ä½¿ã†ã“ã¨ã«ã—ã¾ã—ãŸã€‚ afterSaveãƒ¡ã‚½ãƒƒãƒ‰ã¯ãƒ‡ãƒ¼ã‚¿ãŒä¿å˜ã•ã‚ŒãŸå¾Œã«å‘¼ã³å‡ºã•ã‚Œã‚‹ãƒ¡ã‚½ãƒƒãƒ‰ã§ã™ã€‚ ã“ã®ãƒ¡ã‚½ãƒƒãƒ‰ã§ä»¥ä¸‹ã®ã‚ˆã†ãªã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã™ã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ "UPDATE $tablename SET `latlng` = GeomFromText('POINT($lng $lat)') WHERE id = $id" $tablenam
d4-1977 2010/09/10
CakePHP

GPS

ä½ç½®æƒ…å ±

ã‚ã¨ã§èªã‚€
ãƒªãƒ³ã‚¯
1

ãŠçŸ¥ã‚‰ã›

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

å…¬å¼Twitter

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

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

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

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

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

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

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

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

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

ã‚¿ã‚°

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

GPSã¨ã‚ã¨ã§èªã‚€ã«é–¢ã™ã‚‹d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

ã‚¿ã‚°

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

GPSã¨ã‚ã¨ã§èª­ã‚€ã«é–¢ã™ã‚‹d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ç¬¬2å›žã€€ä½ç½®æƒ…å ±ã‚’å–å¾—ã—ã¦ã¿ã‚ˆã†ï¼ˆå‰ç·¨ï¼‰ | gihyo.jp

ç¬¬ä¸€å›žGeoHexå‹‰å¼·ä¼šã¨ãã®å‘¨è¾º

ç¬¬6å›žã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆé–‹å‚¬ã„ãŸã—ã¾ã—ãŸã€‚

ä¸€æ—¥ä¸€æ­© : CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚

ï¼ ãƒãƒƒãƒˆãŠãŸã:RE:CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚

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

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

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

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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

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

GPSã¨ã‚ã¨ã§èªã‚€ã«é–¢ã™ã‚‹d4-1977ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

ç¬¬2å›žã€€ä½ç½®æƒ…å ±ã‚’å–å¾—ã—ã¦ã¿ã‚ˆã†ï¼ˆå‰ç·¨ï¼‰ | gihyo.jp

ç¬¬ä¸€å›žGeoHexå‹‰å¼·ä¼šã¨ãã®å‘¨è¾º

ç¬¬6å›žã‚¸ã‚ªãƒ¡ãƒ‡ã‚£ã‚¢ã‚µãƒŸãƒƒãƒˆé–‹å‚¬ã„ãŸã—ã¾ã—ãŸã€‚

ä¸€æ—¥ä¸€æ© : CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚

ï¼ ãƒãƒƒãƒˆãŠãŸã:RE:CakePHPã§Geometryåž‹ã‚’ä½¿ã£ã¦ã¿ãŸã‚ˆã€‚

ãŠçŸ¥ã‚‰ã›

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

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

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

å…¬å¼Twitter

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

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

å…¬å¼Twitter

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