a trick to solve the problem is to use, for me, `instead of '.
Example (acero dell`Atlante instead of acero dell'Atlante).
I don't like it very much but at the moment I have no other solutions.
In option list I have regularly all the values but when selected one with
single quote I have no result
Hi all,
I have a problem in a search function. I cant obtain results when strings
have single quote (') (ex.: cedro dell'atlante).
I'm using postgis in "options" mode research.
Thank you
Giovanni
--
View this message in context:
http://pmapper-users-p-mapper-users-mailing-list.993774.n3.nabble.
That's it, I thought the SQL tag wasn't required as I didn't need to filter
the postgis data.
Now it works:
pgsql://user:pass@localhost
/db_name
SELECT DISTINCT id_tree FROM tree ORDER BY
id_tree
Thanx a lot Armin!
why don't you try a definition similar to the settings from the wiki
for exactly Postgis and suggest (there is one...)? you are for sure
missing the tag. And when it works update the wiki and explain
in more detail what parameters are required...
On Thu, Apr 12, 2012 at 1:34 PM, Chris forum wrot
Wow, thanx for the fast answer!
I wasn't clear sorry, the 2 following lines were supposed to tell what I
did to correct each related error:
=> apt-get install php-mdb2
=> apt-get install php-mdb2-driver-pgsql
So the 2 missing packages are already installed.
But now I have this error, with which I
well, your operating systems already tells you the commands for
installing the missing packages ("apt-get install") ...
in addition, you can search for MDB2 on the wiki, there you'll get
e.g. a link to
http://svn.pmapper.net/trac/wiki/UpgradeOlderVersions
armin
On Thu, Apr 12, 2012 at 1:13
Hi Armin, hi all,
I am trying to set up an attribute search on a postgis table.
A simple query works fine, but I get errors as soon as I add the Definition
tag, in order to have the suggest option working.
[error] [client 127.0.0.1] PHP Fatal err
On 20/10/2009 19:32, Armin Burger wrote:
> On 20/10/2009 16:52, Niccolo Rigacci wrote:
>> On Tue, Oct 20, 2009 at 07:39:41AM -0700, JacTheWolf wrote:
>>> I found the problem. Apparently my version of IE (6.0) does not work the
>>> second parameter of function "window.open". To fix put null:
>>>
On 20/10/2009 16:52, Niccolo Rigacci wrote:
> On Tue, Oct 20, 2009 at 07:39:41AM -0700, JacTheWolf wrote:
>> I found the problem. Apparently my version of IE (6.0) does not work the
>> second parameter of function "window.open". To fix put null:
>>
>> var popup = window.open(
>> PM
On Fri, Oct 16, 2009 at 10:59:35AM +0700, Dark Knight wrote:
>
> How to setting this plugin in pmapper-3.2..
The plugin needs some changes in the JavaScript, and also a fix
in the php code.
I made a quick backport that you can find here:
https://trac.faunalia.it/svn/digitizepoints/branches/dig
On Tue, Oct 20, 2009 at 07:39:41AM -0700, JacTheWolf wrote:
>
> I found the problem. Apparently my version of IE (6.0) does not work the
> second parameter of function "window.open". To fix put null:
>
> var popup = window.open(
> PM_PLUGIN_LOCATION +
> '/digitizepoints/digitizep
I found the problem. Apparently my version of IE (6.0) does not work the
second parameter of function "window.open". To fix put null:
var popup = window.open(
PM_PLUGIN_LOCATION +
'/digitizepoints/digitizepoints.php?lon=' + px + "&lat=" + py,
null,
On Mon, Oct 19, 2009 at 04:10:02AM -0700, JacTheWolf wrote:
>
> Niccolo Nice work, the plugin works fine in firefox and
> chrome but I can not make it work in IE. The event digitizepoints_start is
> never fired.
I will try it in IE in the next days. Stay tuned.
--
Niccolo Rigacci
Firenze - Ita
Niccolo Nice work, the plugin works fine in firefox and
chrome but I can not make it work in IE. The event digitizepoints_start is
never fired.
Any ideas?
Thank you !
Niccolo Rigacci wrote:
>
> Hello,
>
> I just finished a simple plugin which allows to digitize points
> directly into a Po
How to setting this plugin in pmapper-3.2..
I try to follow instruction in README.. but when I click digitize tool
button.. its nothing happen..
To add the toolbar button: edit config/default/js_config.php,
add a button element into PM.buttonsDefault definition:
{tool:'digitizepoints', name:'Dig
Hello,
I just finished a simple plugin which allows to digitize points
directly into a PostgreSQL/PostGIS table. It was tested on
p.Mapper version 4, but it should work on version 3 too.
Main features:
* Insert new points and update existing ones into a
PostgreSQL/PostGIS table.
* Allow
Hi,
Your table has a constraint concerning projection. Maybe you should try
this:
DATA "the_geom FROM t473175 USING UNIQUE gid USING SRID=4326"
Is there any interesting information in your log files (with ms4w -->
ms4w/Apache/logs/*.log) ?
Fernando Bordignon a écrit :
> Hi
>
> First, sorry b
Hi
I have more information about my problen with pmapper and postgis (see
past mail " [pmapper-users] Postgis ¿ The problem is the row s
quantity?"). When i edit map.php and delete the lines 759 to 801 (see
the code in the bottom) the problem dissapear and the display is OK.
Can you
Hi
First, sorry by my english. I have a new project with pmapper
(pmapper-4.0.beta2, ms4w and Postgresql 8.3). My problem is with a
postgresql table. The definition is
CREATE TABLE t473175
( gid serial NOT NULL,
__gid integer,
categoria_ character varying(80),
humedad_ma numeric,
humedad
Maybe you should add an internal PK to the table (integer type), use it
in the view and then modify your mapfile as explain by Marcello :
DATA "geom FROM your_table USING UNIQUE your_pk USING SRID=4326"
Sidney Gijzen a écrit :
> No, I mean querying by using the Identifier tool, so he has to find
No, I mean querying by using the Identifier tool, so he has to find the
RESULT_FIELD I specified in the Map-file. I already double-checked it,
and the RESULT_FIELD does exist in the DB. However it suddenly expects
an integer as PK to return when I query.. and I have no integers in
the DB-vi
You mean querying with search.xml?
Sidney Gijzen a écrit :
> Yes, I can display the layer without any problems. However, as soon as I
> start querying it gives the PHP-error and the query result window
> doesn't load.
>
> --
Yes, I can display the layer without any problems. However, as soon as I
start querying it gives the PHP-error and the query result window
doesn't load.
--
Let Crystal Reports handle the reporting - Free Crystal Reports
Does your layer definition works fine ?
Have you got errors when trying something like that:
http://:/cgi-bin/mapserv.exe?mode=map&map=&layers=
Sidney Gijzen a écrit :
> Hi Thomas,
>
> Thank you for your suggestion!
>
> Changing the procedure_id to an integer in the DB is something I
> actually
Hi Thomas,
Thank you for your suggestion!
Changing the procedure_id to an integer in the DB is something I
actually can't change, since I'm working according to OGC SWE standards,
and the procedure_id is defined as a "character varying" data type.
So, that leaves your second option "change the
Hi,
Now it seems to be a problem of types: "procedure_id" is a string and
the "WHERE" try to evaluate it as a numeric value.
You should try directly in your db (pgAdmin3 or psql client line
interface for instance) the query extracted from the error log :
"SELECT
"procedure_id"::text,"procedure
You need a PK field for the postGIS Layer, try this:
--view
CREATE VIEW *procedure *AS
SELECTprocedure.procedure_id AS *procedure_id*,
procedure.description_url AS procedure_description_url,
procedure.description_type AS procedure_description_type,
feature_of_interest.feature_of_i
Hi Marcello,
Thank you very much for your suggestion! I created a view (which works
:)), however I get the following php-error when querying the layer:
[27-Jul-2009 15:16:15] PHP Fatal error: [MapServer Error]:
msPOSTGISLayerGetShape(): Error executing POSTGIS SQL statement (in
FETCH ALL): D
Hello,
I forgot to add some version info. I'm working with the following setup:
p.mapper 4.0 dev
PostGIS 1.3.6
PostgreSQL 8.3
Mapserver 5.2.1
I hope this is helpful :) If you need more info, please ask.
Thank you in advance,
Sidney
-
Hi list!
I've recently dived into p.mapper, and the documentation has been really
helpful. I was able to join a few tables in a PostGIS DB and display
that in p.mapper. However, I get the following PHP ERROR when I try to
query this layer:
[27-Jul-2009 11:57:16] PHP Fatal error: [MapServer Er
Hello,
I have the problem with searching my postgis layer (pmapper 3.2 on
ubuntu). In version 3.1 everything worked fine:( And wiht shapefile
works fine. The problem is postgis layer.
My search is simple:
and layer too:
LAYER
NAME "Zabudowa"
TYPE POLYGON
Hi,
I have started using p.mapper with PROCESSING "CLOSE_CONNECTION=DEFER"
parameter for all postgis layers. (using the latest version of mapserver
5.0.x and patch for the issue with CLOSE_CONNECTION=DEFER).
In htop I see lot of connections "postgres: user database 127.0.0.1(47132)
idle in tran
Hi,
I found the solution:
DATA "the_geom FROM (SELECT min(gid) AS gid, (geomunion(the_geom)) AS
the_geom FROM parafie GROUP BY dekanat) foo USING UNIQUE gid"
Bogumil
-
Check out the new SourceForge.net Marketplace.
Hello,
I am trying to create a polygon layer from existing polygons in my table in
postgis database.
When I use the sql command on postgis database it works and make the one
polygon from others
INSERT INTO dekanaty (the_geom,dekanat)
SELECT (geomunion(the_geom)) AS the_geom,dekanat FROM par
Awesome catch, thanks. All working now.
Armin Burger wrote:
> Kyle
>
> I enabled the DEBUG for the layers and I discovered the problem with
> your data definition when applying the query directly on the table:
>
> You specified 'USING UNIQUE gid' but gid is not unique after the joining
> sinc
Kyle
I enabled the DEBUG for the layers and I discovered the problem with
your data definition when applying the query directly on the table:
You specified 'USING UNIQUE gid' but gid is not unique after the joining
since you multiply it with the joins. If you specify 'USING UNIQUE pid'
then ev
Kyle
a fast workaround would be to put the filter statement into the DATA tag
instead of having a FILTER tag, like
DATA "the_geom from (SELECT * from forecast left join grid on
grid.gid=forecast.gid_fk where time=TIMESTAMP'2007-11-07 11:00:00') as
data USING UNIQUE gid USING SRID=4326"
This w
Must alter the grid's table creation to add the bathymetry column..
forgot about that one:
CREATE TABLE grid (gid serial primary key, bathymetry real);
Kyle Wilcox wrote:
> I will download the CVS later tonight and let you know tomorrow! Thanks.
>
> Here are the files to reproduce my issue:
>
I will download the CVS later tonight and let you know tomorrow! Thanks.
Here are the files to reproduce my issue:
Table creation:
http://155.206.18.162/create.txt
Data for grid table:
http://155.206.18.162/grid_insert.sql
Data for forecast table:
http://155.206.18.162/PostGIS-Forecast-2007-11
Kyle
I added the possibility to define custom images for the layer classes.
Define it via the KEYIMAGE tag, like
CLASS
KEYIMAGE "images/legend/custom-icon.png"
You can get the updated version either directly via SVN
see http://svn.pmapper.net/trac/changeset/232/pmapper/trunk/incphp
for th
Yes the layers use the same two tables, grid and forecast. The only
thing that changes between layers is the FILTER. I will ask on
Mapserver list, thanks.
A legend icon for classes would be great.
Armin Burger wrote:
> I might not understand it completely. Your layers are always using the
> sam
I might not understand it completely. Your layers are always using the
same Postgis table, just setting another FILTER. Is that correct? I
would guess that the queryByPoint() call does not consider the FILTER
specifications. I thought that this is only the case for attribute
queries (therefore
Did the usual searching without finding anything relevant.
The pmapper application I am referencing is at:
http://155.206.18.162/mapping/map/map.phtml
I have time series data in a PostGIS enabled database (current and wind
fields from model output). I can display the point data without
problems
Hi, please, can anybody let me a little explanation about how / where
put a custom postgis sql in order to work with search section?
I set the array in js_config.php
searchList['calles'] = new Array('',
'#STREET1&&#STREET2', '','');
I need run a SQL with this 2 text ( #STREET1&&#STREET2) :
Sorry but for me in this moment is complicated to open an access ssh on a
server with oracle client and pmapper installed and configured.
An alternative is, if you have time, to download and install Oracle Express
Edition it's free for data less than 4Gb and it has an extension (locator)
in order
> I have tried to activate a search also on a layer oracle (10g) with
> oraclespatial type connection:
> DATA "GEOMETRY FROM SEZIONI_CENS01 USING UNIQUE ID2"
>
> The search does not produce result and no error in the log php appears.
> The search on oracle layer is also possible?
>
no, becasue
With the new lines of code the search works perfectly and is sure one
solution more standard.
I have tried to activate a search also on a layer oracle (10g) with
oraclespatial type connection:
DATA "GEOMETRY FROM SEZIONI_CENS01 USING UNIQUE ID2"
The search does not produce result and no error i
if your layer/table has an entry in table 'geometry_columns' you can
also skip completely 'using srid=26591'. This is just needed in case
this entry is not existing, typically eg. for DB views.
I don't know why 'USING UNIQUE srid=26591' doesn't produce a low level
error of Mapserver, though, Map
Sorry Armin,
if I have not answered fastly to your first message.
Yes my definition DATA in the mapfile is:
> "the_geom from mytable USING UNIQUE gid using srid=26591"
I have changed the definition DATA with this:
"the_geom from mytable USING UNIQUE gid USING UNIQUE srid=26591"
and now the qu
I guess your DATA definition is of type
"the_geom from mytable USING UNIQUE gid using srid=26591"
try to substitute in squery.php the line ~716
$data_list['unique_field'] = trim($tabl[1]);
with
$unique_list = preg_split('/[\s]+/', trim($tabl[1]));
$data_list['unique_field'] = trim($u
Marino Fiorito wrote:
> Hi,
>
> I'm trying a postgis layer in pmapper with administrative boundaries.
> The visualization of map it's ok but the query on the column of a layer
> is not performed and the query returned the following php error:
>
> [04-Oct-2006 10:40:15] PHP Warning: pg_query()
Hi,
I'm trying a postgis layer in pmapper with administrative boundaries.
The visualization of map it's ok but the query on the column of a layer is
not performed and the query returned the following php error:
[04-Oct-2006 10:40:15] PHP Warning: pg_query() [function.pg-query]: Query failed: ERR
Luca
I cannot reproduce your error. When I search for a commune I always get
the sinkholes for that commune highlighted when I click on the lens in
the pop-up window and the sinkhole is centered on the map, like you see
in the attached image.
The only thing I don't understand is why it does no
m: [EMAIL PROTECTED] (Alessandro Pasotti)
Date: Mon Sep 26 09:58:58 2005
Subject: [Pmapper-users] postgis
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Il 08:29, luned? 26 settembre 2005, Luca Innocenti ha scritto:
> i'
54 matches
Mail list logo
