Re: [postgis-users] Dropping the PostGIS Java components
El Miércoles, 21 de Diciembre de 2011, Sandro Santilli escribió: Is there anyone using the Java components of PostGIS ? We're wondering if we should just drop them as they are not really maintained by anyone. Maybe every Javaist is using some other components ? What are exactly the Java components of PostGIS? The java jdbc driver? --strk; ,--o-. | __/ |Thank you for PostGIS-2.0 Topology ! | | / 2.0 |http://www.pledgebank.com/postgistopology `-o--' ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Dropping the PostGIS Java components
El Miércoles, 21 de Diciembre de 2011, Sandro Santilli escribió: On Wed, Dec 21, 2011 at 11:32:03AM +0100, Maria Arias de Reyna wrote: El Miércoles, 21 de Diciembre de 2011, Sandro Santilli escribió: Is there anyone using the Java components of PostGIS ? We're wondering if we should just drop them as they are not really maintained by anyone. Maybe every Javaist is using some other components ? What are exactly the Java components of PostGIS? The java jdbc driver? The java/ subdir of PostGIS source tree: http://trac.osgeo.org/postgis/browser/trunk/java There is a jdbc subdir in there but I dont know more than that. I don't know about the ejb* and pljava directories, but the jdbc driver should stay there as it should be the default way to access a postGIS database from Java. For example, the HIbernate Spatial extension uses this driver[1]. Are you sure there is no-one maintaining it? Yesterday there was a commit[2]. Anyway, if you need someone to maintain it, I can take a look as I am interested on the continuity of this driver. [1]http://www.hibernatespatial.org/ [2]http://trac.osgeo.org/postgis/changeset/8481/trunk/java/jdbc -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] how to get point, polygon value in postgis JDBC?
El Viernes, 4 de Noviembre de 2011, LeeHyung Joo - Kevin escribió: Hi all. I have a big problem on my work. First of all, the version based on my work is PostgreSQL : 8.1.11, PostGIS : 1.5.2. The problem is I can not get the value of Point and Polygon. The code is below : blah blah -- -- public Test find(String Id) throws DAOException, ClassNotFoundException, SQLException { Class.forName(org.postgresql.Driver); String url = jdbc:postgresql://localhost:8080/testdao; Connection conn = DriverManager.getConnection(url, admin, apple); PreparedStatement ps = conn.prepareStatement(select name, addr, ST_AsText(position) from listFriend where id=?); ps.setString(1, Id); ResultSet rs = ps.executeQuery(); // ((org.postgresql.PGConnection)conn).addDataType(point,Class.forName(org .postgis.Point)); while(rs.next()) { test = new Test(); p = new Point(); test.setName(rs.getString(1)); test.setAddr(rs.getString(2)); test.setPosition(p); //System.out.println(rs.getString(3)); --- --- If I run the sentence, System.out.println(rs.getString(3));, it works. It prints right output like Point(13.123 11.123). But I don't know how to fix test.setPosition(p); any helps will be thank. P.S. is it possible to be reason why the low or high version of PostgreSQL and PostGIS? Best Regards Kevin Lee. Maybe you are looking for a WKT Parser? Like this one: http://www.vividsolutions.com/jts/javadoc/com/vividsolutions/jts/io/WKTReader.html If you are using the postGIS driver you should be able to use the geometry directly on your query, instead of using as_text. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.com ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] no template_postgis
El Viernes 02 Septiembre 2011, vassilis Trigkas escribió: I install post gis 1.5 in ubuntu 11.04 with postgresql 9.0 but I can't find template_postgis. I try to do a new database from pgAdmin and i' didnt find template_postgis. The only way i to run postgis.sql I usually do the template_postgis myself. You just have to create a postgis database named template_postgis. http://postgis.refractions.net/documentation/manual-1.5/ch02.html#id2619431 *Some packaged distributions* of PostGIS (in particular the Win32 installers for PostGIS = 1.1.5) load the PostGIS functions into a template database called template_postgis. If the template_postgis database exists in your PostgreSQL Some packaged distributions, not all. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Mapserver with postgis, sql query error.
El Sábado 30 Julio 2011, Nicolas ( cse ) escribió: select encode(AsBinary(force_collection(force_2d(the_geom)),'NDR'),'hex') as geom,gid from t_parcelas where the_geom GeomFromText('POLYGON((5600615.254754 5725111.70807103,5600615.254754 5739818.70784397,5620240.983548 5739818.70784397,5620240.983548 5725111.70807103,5600615.254754 5725111.70807103))',find_srid('','t_parcelas','the_geom')) With thi error: ERROR: geometry requires more points ** Error ** ERROR: geometry requires more points SQL state: XX000 A stupid question, just in case. You say that AsBinary returns a valid geometry, but does it have a collection with points? I mean, could it be an empty collection? Also, are you sure the encode function is not corrupted? If AsBinary returns something hexadecimal, the encode function should have no problem, no matter if the geometry is valid or not. Have you tried to run the encode function with the result of the AsBinary? And with something simpler? -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Shapefiles exported from PostGIS and ESRI ArcView 9 compatibility
El Jueves 21 Julio 2011, Ben Madin escribió: We have a client (potential client) who wants some mapping done and the maps returned in shapefile format. In the contract they insist on specifying that the shapefiles are compatible with ESRI's ArcView version 9 (their words, not mine). If ArcView has no public specification of their Shapefiles, you can always tell your potential client all the problems derivated from using a privative and dark format. In fact, you *should* at least mention it. It will save you a lot of troubles in the future. If you explain it right, clients usually understand it and _sometimes_ they agree to move to open formats. Anyway, you should ask your client for a couple of examples of their shapefiles and compare them with yours. Maybe the difference is small and you can post- process your generated shapefiles to adjust them. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] PG Routing
El Domingo 03 Julio 2011, James David Smith escribió: Dear all, I have a table of GPS points which are the locations of vehicles every 15 seconds. Each journey that a car makes has an ID. For example a taxi is on 'job 1' and has 50 points while it does this job, and then another 50 or 60 when it is on 'job 2' etc. What I would like to do however is investigate whether the car took the most effecient route between the two points. To this end I think that I can use the PGROUTING extension of PostGIS...? Does this sound possible? You can calculate the shortest path with pgRouting and then compare it with the length of the linestring formed with this GPS points. Probably you will have a longer path with the GPS points (because the GPS is never exact) but if you add a percent of error to the shortest path calculated by pgRouting you will know if the vehicle did a good or a bad path. I have found the PGROUTING website, and download the ZIP file for Windows installation, however I am not sure how to install it. Could somebody please tell me how or provide a link to a good place to read about how to install and use PGROUTING? Why are you using Windows (for any serious work)? There is a PPA for Ubuntu[1] which has a direct install while pgRouting binaries for Windows are old and strongly dependent of a postgresql version. And remember that you must install postgis first. Anyway, if you are thinking of having a real-time server with several vehicles sending positions every 15 seconds, forget Windows. It will be insane. If it is insane if you do it on a non-strongly-optimized database on Linux I don't want to know how hard it will be on Windows. Believe me, I have made a few of this real-time systems. [1]https://launchpad.net/~georepublic/+archive/pgrouting -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Postgis 2.0 and geoserver 2.1 rc4
El Monday 18 April 2011, 龙龙 escribió: Hi, I am getting the following error when trying to add a layer from a postgis 2.0 database: java.lang.RuntimeException: java.io.IOException: Error occured calculating bounds at org.geotools.jdbc.JDBCFeatureSource.getBoundsInternal(JDBCFeatureSource.ja va:476) at org.geotools.jdbc.JDBCFeatureStore.getBoundsInternal(JDBCFeatureStore.java :178) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSourc e.java:369) at org.geotools.data.store.ContentFeatureSource.getBounds(ContentFeatureSourc e.java:341) at org.geotools.data.SimpleFeatureSourceBridge.getBounds(SimpleFeatureSourceB ridge.java:49) at org.vfny.geoserver.global.GeoServerFeatureSource.getBounds(GeoServerFeatur eSource.java:529) at org.geoserver.catalog.CatalogBuilder.getNativeBounds(CatalogBuilder.java:4 63) at org.geoserver.web.data.resource.BasicResourceConfig$1.onSubmit(BasicResour ceConfig.java:115) at org.apache.wicket.ajax.markup.html.form.AjaxSubmitLink$1.onSubmit(AjaxSubm itLink.java:68) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitB ehavior.java:143) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:17 7) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefau ltAjaxBehavior.java:300) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget. processEvents(BehaviorRequestTarget.java:119) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(Abst ractRequestCycleProcessor.java:92) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1 250) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1329) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1436) at org.apache.wicket.RequestCycle.request(RequestCycle.java:545) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:484) at org.apache.wicket.protocol.http.WicketServlet.doPost(WicketServlet.java:16 0) at javax.servlet.http.HttpServlet.service(HttpServlet.java:727) at javax.servlet.http.HttpServlet.service(HttpServlet.java:820) at org.springframework.web.servlet.mvc.ServletWrappingController.handleReques tInternal(ServletWrappingController.java:158) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(Abstr actController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle( SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherSer vlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServ let.java:809) at But this problem doesn't exist when I use postgis 1.5. So, is this a postgis problem or a geoserver problem. How shall I deal with it? The data from the table is the same? I had this error once when the geometry column wasn't correctly defined. Are you sure the table is defined on the geometry_columns table? Can you look inside geoserver to see which is the exact sql sentence that is used there? -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Securing postgis
El Tuesday 01 March 2011, Karl O. Pinc escribió: Hi, I have a number of users each of which has their own schema. I don't want the users to be able to enable/disable the geospatialness of anyone else's columns. What's the right way to secure postgis so as to prevent this? It seems that a single, global, geometry_columns is the problem. I see a number of possibliities. If geometry_coulumns is all that needs to be secured I could create the table in each user's schema. If there's a lot of other infrastructure that needs to be duplicated this would not work as well -- the user's schemas would be all cluttered up. But I can see where having multiple geometry_columns tables could complicate an upgrade I could create a separate postgis schema for each user, but that seems overkill and I'm not at all clear on how $user is expanded in the search_path and whether or not it'd be possible to automatically have such schemas in the search path. then again I could just forget about it and hope the users don't kill each other. What's the best approach here? What if you write a trigger on every delete/update on the geometry_columns table? This trigger can cancel the delete/update if the user has no permission for that row. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to remotely edit a postgis db?
El Wednesday 26 January 2011, Robert Buckley escribió: Hi, with Quantum GIS v1.6.0 I just managed to connect and edit!!! I don´t believe i because I was trying all last night and it wasn´t working? ok...so it works! great! As a newbie then, I have a questions? How do I define different users to different tables in a database?...I was thinking of creating various databases for different users. Could I then define different user accounts/roles to the databases to ensure that only correct person is able to edit his/her database?...for example I have a region with 10 counties. If I create 10 databases for each county, I could then assign 10 users (county_1, county_2 ...county_10) to database_1, Database_2...Database_10 etc so that the user County_2 can only edit the database County_2. does that make sense? Is it feasable/doable? If you can think of it, you can do it ;) PostGIS is only an extension of PostgreSQL. You might want to check how roles and users work on PostgreSQL: http://www.postgresql.org/docs/8.4/static/user-manag.html Anyway, try not to create a new thread every time you have a new question of the same topic. It makes it difficult to follow. yours, Robert -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to remotely edit a postgis db over a webclient?
El Wednesday 26 January 2011, Robert Buckley escribió: Hi, I´m interested! Here is my setup at the moment. Server: Ubuntu 8.04 Mapserver: Geoserver - at the moment i´m using geoserver from the opengeosuite. Spatial db: Postgresql 8.3 with postgis - I did a separate installation to get this working ( Ths OpenGeoSuite´s installation of postgis isn´t supported for ubuntu 8.04) Do you have a test app? yours, Robert Please, can you stop creating new threads instead of replying the already created thread? Thanks :) And good luck with your project! -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] How to remotely edit a postgis db?
El Wednesday 26 January 2011, Robert Buckley escribió: Hi, i have installed postgis on postgresql and everything seems to working fine. At the moment I uploading tables through shp2psql and this is working too. I would now like to edit the data from remote pcs. I have experience using various open source gis software e.g Jump, QGIS, svSIG, Udig etc but I cannot edit and commit changed through these gis systems. My system is Ubuntu 8.04. postgresql is version 8.3 / postgresql-8.3-postgis I installed postgis as sudo...therefore the installation folder is owned by root cd .. /usr/share/postgresql drwxr-xr-x 6 root root 4096 2011-01-25 15:22 8.3 I have created a user called geoserver for gis work sudo -u postgres -i createuser geoserver createdb -E UTF8 -O geoserver gis and then created the language... createlang plpgsql gis I was following these instructions by the way. http://weait.com/content/build-your-own-openstreetmap-server-v1 So...as far as I can see, I have a working installation of postgresql with postgis isntalled. I can log in to postgresql with pgadmin3 and see my gis db which is spatially enabled with the postgis functions. Fantastic! I uploaded a shp and even loaded it into geoserver which displayed it perfectly. so...Now I want to edit the data... It is probably a problem of postgreSQL configuration, not PostGIS. Check which users (postgreSQL users) have rights to select, update and delete the tables you are trying to use. Question: 1. does user geoserver have editing permission? How can I find out? Try to connect to the database with the same user and password geoserver is using from the IP in which geoserver is installed. If you can, geoserver can. 2. is postgres a user account on ubuntu or just the login name for the db?...When I look in my /home folder on ubuntu there is no folder there called postgres so I guess no!?!? postgres is a user account on your OS, but is also a user account for postgreSQL, which is a completely different thing. 3. Why can´t I just log in through any of the software mentioned above and edit? Have you checked that the /etc/postgresql/*/main/pg_hba.conf file is configured for the username, password and IP you are trying to use? Have you checked that the /etc/postgresql/*/main/postgresql.conf file is configured for the IP you are trying to use? The #listen_addresses = 'localhost' line. I would be grateful for any pointers... thanks, Robert Buckley -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] refractions web site
El Tuesday 21 September 2010, Guillaume Sueur escribió: Hi, What's wrong with www.refractions.net website and its sub-domains like postgis.refractions.net ? Has it moved somewhere else ? Did they forget to pay the domain? -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Backup and Restore of a PostGis database
El Wednesday 04 August 2010, Luís de Sousa escribió: 1. Creating a fresh empty database at server B and then restoring. With this process PostGres complains of not having permissions to create basic types. Are you executing that restore with a user who has permissions to create basic types? User 'postgres' perhaps? Probably this can be the easiest solution. Anyway, pg_dump has a lot of options, you can try to look for a better combination of them. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] cruces de vias en tabla postgis.
El Monday 02 August 2010, FRANK RADA escribió: Hola estoy contruyendo los sentidos en un tabla que almacena las vias de la zona centrica de una ciudad, los sentidos son simples, solo quiero saber como puedo modelar los cruces y los sentidos. he visto que en arcgis utilizan un par de columnas FROMLEFT, TOLEFT, FROMRIGHT, TORIGHT. Gracias. ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users He's asking about modelling turns and crosses. Hola Frank, Echale un vistazo a este enlace: http://www.davidgis.fr/blog/index.php?2008/07/24/349-shooting-star-usage-example-with-turn-restriction De todas formas, si quieres mejores (y más) contestaciones deberías escribir en inglés, que si no te vamos a entender pocos aquí. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] making a line from a known point and direction
El Tuesday 20 July 2010, ahmet temiz escribió: hello I want to make a linestring from a known point and known direction (as azimuth) with certain length. how can I do that ? Can you calculate the final point instead of the direction? -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] OpenStreetMap + osm2pgsql + pgRouting into Postgis
El Wednesday 19 May 2010, roshni.spain escribió: Hi, how can i be sure about this? If i get wrong results i mean ... Well, you can try some samples and check it by hand. If I am not mistaken, that number is used to know the size of the buffer used to calculate which node goes to each vertex. If you use a small number and the lines you are using are not close enough, pgrouting will think they are not touching and will not assign them the same vertex. If you use a big number, pgrouting can think that lines, who should not be touching, are touching. Then it can lead you to stupid routes, like jumping from one road to the paralell. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] Problem: Save a postgis layer as a shape file
El Tuesday 18 May 2010, Anita Van Deventer escribió: I want to save a postgis layer as a shape file - it returns an error that it cannot create an attribute field. Any suggestions? How are you saving it as a shape file and what error does it shows exactly? -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] implement your own index
El Tuesday 18 May 2010, Biddy escribió: write your own spatial index. Do you mean this: http://postgis.refractions.net/docs/ch04.html#id2794434 ? Take a look at the docs, probably most of your questions are answered there. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] OpenStreetMap + osm2pgsql + pgRouting into Postgis
El Tuesday 18 May 2010, Roshni Budhrani escribió: I have been told that this is probably because the OSM data is not properly noded at all intersections. If it is so, then how can i fix my data? Most probably. You can try to use a bigger number on the assign_vertex_id function, but it can lead you to wrong results too. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] HINT: No function matches the given name and argument types
El Friday 14 May 2010, rakesh modi escribió: hi, i am using select query which is shown below SELECT sum(length(the_geom))/1000 AS km_roads FROM routable; and get error like - HINT: No function matches the given name and argument types. You might need to add explicit type casts. I usually prefer to use ST_length instead of length. Maybe that's the problem? (Btw, are you sure you have postgis installed on that database?) -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] ShootingStar: Rule with comma separated... bug?
Hi, I'm trying to do a shooting_star calculation following this example: http://www.davidgis.fr/blog/index.php?2008/07/24/349-shooting-star-usage-example-with-turn-restriction But I think that it has a bug when reading the rule. If I try to set more than one restriction on a rule, like update routing set to_cost = 100,rule='9,5' where id = 6; it only works for the first edge defined on rule (9), not the second edge (5). Am I doing something wrong or is it a bug? If I invert the rule: update routing set to_cost = 100,rule='5,9' where id = 6; it works well for the first edge again (5), but not for the second (9). -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] ShootingStar: Rule with comma separated... bug?
El Tuesday 04 May 2010, Fred Lehodey escribió: Hi Maria. If you need multiple restrictions for a given edge then you have to add multiple records for that edge each with a separate restriction http://pgrouting.postlbs.org/wiki/ShootingStar Fred. Thanks Fred :) I suppose that I followed deprecated tutorials. -- María Arias de Reyna Domínguez Área de Operaciones Emergya Consultoría Tfno: +34 954 51 75 77 / +34 607 43 74 27 Fax: +34 954 51 64 73 www.emergya.es ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] lspostgis.sql shows errors
Now I understand, thanks. It was that, a configuration problem. I used the same postgresql for another project and it changed it. -- María Arias de Reyna Domínguez Emergya Consultoría ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] lspostgis.sql shows errors
I'm trying to create a new postgis database on a postgresql 8.3. I have done it on the past on the same computer and it worked fine. But now, running lwpostgis.sql shows me errors: [...] psql:/usr/postgis-1.3.3/lwpostgis.sql:: ERROR: se ha denegado el permiso para crear �pg_catalog.geometry_dump� DETAIL: Las modificaciones al catalogo del sistema estan actualmente deshabilitadas. [...] After the first error, it rollsback the whole transaction. Could it be due to an upgrade of the library gdal? Or is it something easier? -- María Arias de Reyna Domínguez Emergya Consultoría ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] lspostgis.sql shows errors
El Martes 20 Enero 2009 10:50, Mark Cave-Ayland escribió: You must be logged in as the database superuser (normally postgres) in order to load lwpostgis.sql. I am doing it as postgres, the superuser of the db,so it must be another mistake. -- María Arias de Reyna Domínguez Emergya Consultoría ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] buffer(the_geom, 0) crashes the database
El Martes 20 Enero 2009 12:13, Stefan Zweig escribió: hi mark, the file i have upload includes just a single query. it includes the geometry (a multipolygon of russia) that crashes with buffer(the_geom, 0) in wkt representation. so it is nothing more than select buffer(geomfromtext('MULTIPOLYGON(.)',4326),0) i think without having the actual coordinates of this MULTIPOLYGON it won't be possible to debug. Then maybe it is a memory problem -- María Arias de Reyna Domínguez Emergya Consultoría ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
Re: [postgis-users] lspostgis.sql shows errors
El Martes 20 Enero 2009 13:13, Obe, Regina escribió: Strange. Is it the same error as you got before? What does SELECT * FROM pg_settings WHERE name = 'search_path' return. It returns me postgis queries that are being running on parallel databases. PostGIS seem to work (well, works) on databases created before this error. Now I can't create new gis databases. -- María Arias de Reyna Domínguez Emergya Consultoría ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users