[B! *gis] hurvinekã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

hurvinek id:hurvinek

*gisã«é–¢ã™ã‚‹hurvinekã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

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

PostGIS ãƒ‡ãƒ¼ã‚¿ã®æ ¼ç´ã¨è¡¨ç¤º | Let's POSTGRES
è¾²æ¥ãƒ»é£Ÿå“ç”£æ¥æŠ€è¡“ç·åˆç ”ç©¶æ©Ÿæ§‹ è¿‘ç•¿ä¸å›½å››å›½è¾²æ¥ç ”ç©¶ã‚»ãƒ³ã‚¿ãƒ¼ å¯ºå…ƒ éƒåš ã¯ã˜ã‚ã« ä»Šå›žã¯ã€å®Ÿéš›ã« GIS ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ãƒ‡ãƒ¼ã‚¿ã‚’å©ãè¾¼ã‚“ã§ã¿ã¾ã™ã€‚ ã¾ãŸã€æ ¼ç´ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’ã€ãƒ‡ã‚¹ã‚¯ãƒˆãƒƒãƒ— GIS ã§è¡¨ç¤ºã—ã¦ã¿ã¾ã™ã€‚ æœ¬ä¾‹ã§ã®å‰æã¯æ¬¡ã®é€šã‚Šã§ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã¯ pgis æ ¼ç´ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ã¯ã€å›½åœŸæ•°å€¤æƒ…å ± (è¡Œæ”¿åŒºåŸŸ) ã®ã†ã¡åºƒå³¶çœŒ ãƒ†ãƒ¼ãƒ–ãƒ«åã¯ admarea ã‚¸ã‚ªãƒ¡ãƒˆãƒªã‚«ãƒ©ãƒ åã¯ the_geom (shp2pgsql ã®ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆ) ã“ã“ã§çªç„¶ã€Œã‚¸ã‚ªãƒ¡ãƒˆãƒªã‚«ãƒ©ãƒ ã€ã¨ã„ã†èªžã‚’å‡ºã—ã¦ã—ã¾ã„ã¾ã—ãŸãŒã€ã‚¸ã‚ªãƒ¡ãƒˆãƒªåž‹ã®ã‚«ãƒ©ãƒ ã¨ã„ã†æ„å‘³ã§ã™ã€‚ æœ¬ä¾‹ã§ã¯ MULTIPOLYGON åž‹ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã‚¸ã‚ªãƒ¡ãƒˆãƒªåž‹ã«ã¯ã€ä»–ã«ã‚‚ POINT, LINESTRING, POLYGON åž‹ãªã©ãŒã‚ã‚Šã¾ã™ã€‚ ç©ºé–“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä½œæˆ ã¾ãšã¯ã€å©ãè¾¼ã¿å…ˆã¨ãªã‚‹ç©ºé–“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åã¯ "p
hurvinek 2011/01/26
*gis
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šMapServerã§åœ°å›³ã‚’è¡¨ç¤ºã—ã¦ã¿ã‚ˆã† (1/3)
ãƒ‡ãƒ¼ã‚¿ã®ç”¨æ„ã¾ã§ã§ããŸã®ã§ã€ã„ã‚ˆã„ã‚ˆåœ°å›³ã®å‡ºåŠ›ã§ã™ã€‚åœ°å›³ã®å‡ºåŠ›ã¯ã¨ã¦ã‚‚ç°¡å˜ã§ã€ãƒªã‚¹ãƒˆ1ã«æŽ²è¼‰ã™ã‚‹PHPãƒ•ã‚¡ã‚¤ãƒ«ã‚’list1.phpã¨ã—ã¦ä¿å˜ã—ã€åŒéšŽå±¤ã«ãƒªã‚¹ãƒˆ2ã«ç¤ºã™åœ°å›³ç”»åƒã®è¨å®šç”¨ã®ãƒ•ã‚¡ã‚¤ãƒ«ï¼ˆMapãƒ•ã‚¡ã‚¤ãƒ«ï¼‰ã‚’list2.mapã¨ã„ã†åå‰ã§ä¿å˜ã—ã¾ã™ã€‚ ãƒªã‚¹ãƒˆ1 1 <?php 2 3 // æ±äº¬éƒ½ã®ç·¯åº¦çµŒåº¦æƒ…å ± 4 $min_lon = 138.9; $min_lat = 35.45; 5 $max_lon = 140.0; $max_lat = 35.95; 6 7 8 // è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã™ã‚‹ 9 $map = ms_newMapObj("./list2.map"); 10 // å‡ºåŠ›ã™ã‚‹ç”»åƒã‚µã‚¤ã‚ºã®è¨å®š 11 $map->setSize(800, 400); 12 // åœ°å›³ç”»åƒã«å«ã¾ã‚Œã‚‹ç·¯åº¦çµŒåº¦ã®æŒ‡å®š 13 $map->setExtent($min_lon,
hurvinek 2011/01/26
*gis
ãƒªãƒ³ã‚¯
CADWEB - ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰:PostGISã‚³ãƒ³ãƒãƒ¼ã‚¿ Pgsqlout for IntelliCAD/AutoCAD
hurvinek 2011/01/26
*gis
ãƒªãƒ³ã‚¯
GISãƒ»SISãƒ’ãƒ³ãƒˆé›†
hurvinek 2011/01/26
*gis
ãƒªãƒ³ã‚¯
PostGISã‚’ä½¿ã† - kopug memo
http://d.hatena.ne.jp/kopug/20091011/1255240821 ä¸Šè¨˜ã®ã‚¨ãƒ³ãƒˆãƒªã§PostGISã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ã¤ã„ã¦æ›¸ã„ãŸãŒã€ä»Šåº¦ã¯å®Ÿéš›ã«ä½¿ã£ã¦ã¿ã‚‹ ã‚„ã‚ŠãŸã„äº‹ã¨ã—ã¦ã¯ä»¥ä¸‹ã®ã¨ãŠã‚Š æºå¸¯ã®GPSã‹ã‚‰ç·¯åº¦ã€çµŒåº¦ã‚’å–å¾—ã—ã€è¿‘éš£(åŠå¾„200mä»¥å†…)ã®åº—èˆ—ã‚’æ¤œç´¢ã™ã‚‹ è¿‘ã„é †ã«ã‚½ãƒ¼ãƒˆã‚’ã—ã¦ä¸€è¦§ã‚’å‡ºã™ 1. DBã®ä½œæˆ $ createdb -U postgres -T template_postgis geomanse 2. ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä½œæˆ (â€»1) $ psql -U postgres geomanse CREATE TABLE SAMPLE (id serial); SELECT AddGeometryColumn('sample', 'point', 4326, 'POINT', 2); â€»1 4326ã£ã¦ä½•ã•ï¼Ÿ # ä¸–ç•Œæ¸¬åœ°ç³»(WGS84)ã§ã®æ ¼ç´ã‚’æ„å‘³ #
hurvinek 2011/01/26
*gis
ãƒªãƒ³ã‚¯
PostGISã€MapServerã€OpenLayersã‚’ä½¿ã£ã¦ã€Google Mapã¨è‡ªå‰ã®ä½ç½®æƒ…å ±ã‚’é‡ãåˆã‚ã›ã¦ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã™ã‚‹
Home PostGISã€MapServerã€OpenLayersã‚’ä½¿ã£ã¦ã€Google Mapã¨è‡ªå‰ã®ä½ç½®æƒ…å ±ã‚’é‡ãåˆã‚ã›ã¦ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã™ã‚‹ PostGISã€MapServerã€OpenLayersã‚’ä½¿ã£ã¦ã€Google Mapã¨è‡ªå‰ã®ä½ç½®æƒ…å ±ã‚’é‡ãåˆã‚ã›ã¦ãƒ–ãƒ©ã‚¦ã‚¶ã«è¡¨ç¤ºã™ã‚‹ PostgreSQLã«PostGISã‚’ä½¿ã£ã¦ä½ç½®æƒ…å ±ã‚’å…¥å‡ºåŠ›ã™ã‚‹ã€‚ MapServerã¯ã€PostgreSQLã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦æƒ…å ±ã‚’å–å¾—ã€WEBã¸ã‚µãƒ¼ãƒ“ã‚¹ã™ã‚‹ã€‚ OpenLayersã¯ã€MapServerã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦æƒ…å ±ã‚’å–å¾—ã€ãƒ–ãƒ©ã‚¦ã‚¶ä¸Šã«åœ°å›³ã‚’æç”»ã™ã‚‹ã€‚ ã§ã€ã“ã“ã«ã„ã‚ã„ã‚ã¨æƒ…å ±ã‚’è¼‰ã£ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ã—ã¦è¡Œã“ã†ã¨ã„ã†ã“ã¨ã§ã€ã¨ã‚Šã‚ãˆãšGoogle Mapã®è¡¨ç¤ºã¨PostGISã«æ ¼ç´ã—ãŸè‡ªå‰ã®ä½ç½®æƒ…å ±ã‚’é‡ãåˆã‚ã›ã‚‹ã‚µãƒ¼ãƒã‚’ãŸã¦ã¦ã¿ã‚‹ã€‚ å‰æï¼ˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ¸ˆã¿ï¼‰ Ubuntu 10.10 Apache2 Postgr
hurvinek 2011/01/26
*gis

*MapServer
ãƒªãƒ³ã‚¯
1