Quantcast

[pmapper-users] digitize plugin problem

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

[pmapper-users] digitize plugin problem

eleonora
Widow pop up is empty...


I have read this thread
https://www.mail-archive.com/search?l=pmapper-users@...&q=subject:%22[pmapper-users]+digitize+points%22&o=newest&f=1
and a try this query    SELECT *, ST_Distance_Sphere(%s, %s) AS %s in my
postgres but i have this error

Errore SQL:

ERROR:  syntax error at or near "%"
LINE 1: SELECT *, ST_Distance_Sphere(%s, %s) AS %s
                                      ^

Nel costrutto:
SELECT *, ST_Distance_Sphere(%s, %s) AS %s

no errors are reported in the connection db
$db = DB::connect($dsn, true);
if (DB::isError($db)) die ($db->getDebugInfo());

__________________________________________________

include_config.php
$dsn        = 'pgsql://user:pass@host:5432/dbname';
$db_table   = 'toponimi-cat';       // Table name.
$pkey       = 'gid';              // Table's primary key.
$the_geom   = 'the_geom';        // Table's geometry field, type POINT.
$srid_geom  = 32633;              // SRID of the geometry.
$srid_map   = 32633;              // SRID of the map (clicked screen
point).
$tolerance  = 500;               // Distance in meteres to pick existing
point for editing.
$hide_fields = array('id');      // Table fields not displayed in the
edit form.

FILE map

MAP
EXTENT  350117.586532 4739786.469378 382150.132577 4773295.848327
IMAGECOLOR     255 255 255
UNITS meters
SIZE 600 500
SHAPEPATH "/var/www/data"
SYMBOLSET "../common/symbols/symbols-pmapper.sym"
FONTSET "../common/fonts/msfontset.txt"
RESOLUTION 96
IMAGETYPE png
PROJECTION
     'proj=utm'
     'zone=33'
     'datum=WGS84'
     'units=m'
     'no_defs'
END


    LAYER
     NAME "Toponimi"
     TYPE POINT
     DUMP true
     TEMPLATE void
   EXTENT 360833.947860 4755676.707881 371581.165203 4766312.758308
    CONNECTIONTYPE postgis
     CONNECTION "dbname='xxx' host=localhost port=5432 user='xxxx'
password='xxx' sslmode=disable"
     DATA 'the_geom FROM "toponimi-cat" USING UNIQUE gid USING
srid=32633'
     METADATA
       'ows_title' 'toponimi-cat'
     END
     STATUS ON
     PROJECTION
     'proj=utm'
     'zone=33'
     'datum=WGS84'
     'units=m'
     'no_defs'
     END
  LABELITEM    "topo"
     CLASS
        NAME 'toponimi-cat'
        STYLE
          SYMBOL "square"
          SIZE 3.0
          OUTLINECOLOR 0 0 0
          COLOR 255 255 0
        END
    LABEL
         POSITION Auto
          COLOR 0 0 0
          BUFFER 2
          TYPE truetype
          ENCODING "UTF-8"
          FONT FreeSans
          SIZE 7
          MAXSIZE 9
          #SIZE small
        END #Label
     END
   END

help! thank you

Eleonora

------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
_______________________________________________
pmapper-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
Loading...