[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] Problem with ST_Multi and schemas in Postgresql
From: Jean Marchal <jean.d.marchal () gmail ! com>
Date: 2013-08-28 11:40:55
Message-ID: CACF6B3UMC_ORoGCCZrN=xos=ieOjBJA1j5YWo8kyRDG9Bn3mbg () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
I think you are missing the "convert to geometry" part ("::geometry") ...
which gives you something like
SELECT
ST_AsGeoJson(ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D8792E62FB84 \
2407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DDA885EC0DC0 \
01817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B742408A756F7A0 \
4895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A6C03B959DB7424 \
0194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE4455B895EC0D46DA \
936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E0B74240C4B0CDFF7C8 \
95EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895EC06180139632B842408 \
E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408B0736A873895EC061F44B6 \
684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7DC5ACB84240671A89CA49895 \
EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A26895EC067F5A6E9C4B84240D52 \
CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84240FEA6C6FCF2885EC0CC5A7B47A \
BB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC025549B2A82B842403EC43943D1885EC \
05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240' \
::geometry))
Jean
2013/8/28 Ekaitz HERNANDEZ <ekaitz.hernandez@gmail.com>
>
> Hi Al!
>
> I have the next problem, I have now different schemas, all it was working
> perfect until I execute ST_Multi, I haven't other problems with other
> functions in postgis it seems that ST_Mult can't figure out what schema to
> choose.
>
> This is the query that is not working:
>
> SELECT
> ST_AsGeoJson(ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D8792E62FB \
> 842407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DDA885EC \
> 0DC001817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B742408A7 \
> 56F7A04895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A6C03B9 \
> 59DB74240194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE4455B8 \
> 95EC0D46DA936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E0B7424 \
> 0C4B0CDFF7C895EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895EC0618 \
> 0139632B842408E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408B0736A \
> 873895EC061F44B6684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7DC5ACB \
> 84240671A89CA49895EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A26895EC \
> 067F5A6E9C4B84240D52CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84240FEA \
> 6C6FCF2885EC0CC5A7B47ABB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC025549B2 \
> A82B842403EC43943D1885EC05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240'))
>
> *LINE 1: SELECT ST_AsGeoJson(ST_Multi('0103000020E610000001000000210...*
> * ^*
> *HINT: Could not choose a best candidate function. You might need to add
> explicit type casts.*
> *
> *
> *
> *
> If I set explicitly the schema in ST_multi it works perfect, however I
> don't need to put the schema in ST_AsGeoJson.
>
> SELECT
> ST_AsGeoJson(dev02.ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D879 \
> 2E62FB842407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DD \
> A885EC0DC001817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B74 \
> 2408A756F7A04895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A \
> 6C03B959DB74240194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE \
> 4455B895EC0D46DA936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E \
> 0B74240C4B0CDFF7C895EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895 \
> EC06180139632B842408E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408 \
> B0736A873895EC061F44B6684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7 \
> DC5ACB84240671A89CA49895EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A2 \
> 6895EC067F5A6E9C4B84240D52CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84 \
> 240FEA6C6FCF2885EC0CC5A7B47ABB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC02 \
> 5549B2A82B842403EC43943D1885EC05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240'))
>
> search_path:"dev02, shared"
>
> Post_gis version:
> "POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" PROJ="Rel. 4.7.1, 23
> September 2009" LIBXML="2.7.6" LIBJSON="UNKNOWN""
>
> Sorry I wrote in the wrong mail list I don't know if this is a Postgres
> problem or Postgis problem.
>
> Thank you
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
--
Jean Marchal
Etudiant au doctorat / PHD student
Université Laval - Pavillon Abitibi-Price
Faculté de foresterie, de géographie et de géomatique
2405, rue de la Terrasse
Québec (Québec) G1V 0A6
Tél: 418-656-2131 poste 2620
[Attachment #5 (text/html)]
<div dir="ltr"><div>I think you are missing the "convert to geometry" part \
("::geometry") ... which gives you something like<br><br>SELECT \
ST_AsGeoJson(ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D8792E62 \
FB842407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DDA885EC \
0DC001817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B742408A756 \
F7A04895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A6C03B959DB \
74240194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE4455B895EC0D \
46DA936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E0B74240C4B0CDF \
F7C895EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895EC06180139632B84 \
2408E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408B0736A873895EC061F \
44B6684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7DC5ACB84240671A89CA4 \
9895EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A26895EC067F5A6E9C4B8424 \
0D52CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84240FEA6C6FCF2885EC0CC5A7 \
B47ABB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC025549B2A82B842403EC43943D18 \
85EC05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240' \
::geometry))</div>
<div class="gmail_extra"><br></div>Jean<div class="gmail_extra"><br><br><div \
class="gmail_quote">2013/8/28 Ekaitz HERNANDEZ <span dir="ltr"><<a \
href="mailto:ekaitz.hernandez@gmail.com" \
target="_blank">ekaitz.hernandez@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><br clear="all"><div>Hi \
Al!</div><div><br></div><div>I have the next problem, I have now different schemas, \
all it was working perfect until I execute ST_Multi, I haven't other problems \
with other functions in postgis it seems that ST_Mult can't figure out what \
schema to choose.</div>
<div><br></div><div>This is the query that is not working: \
</div><div><br></div><div><div> SELECT \
ST_AsGeoJson(ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D8792E62 \
FB842407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DDA885EC \
0DC001817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B742408A756 \
F7A04895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A6C03B959DB \
74240194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE4455B895EC0D \
46DA936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E0B74240C4B0CDF \
F7C895EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895EC06180139632B84 \
2408E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408B0736A873895EC061F \
44B6684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7DC5ACB84240671A89CA4 \
9895EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A26895EC067F5A6E9C4B8424 \
0D52CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84240FEA6C6FCF2885EC0CC5A7 \
B47ABB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC025549B2A82B842403EC43943D18 \
85EC05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240'))</div>
</div><div><br></div><div><div><b>LINE 1: SELECT \
ST_AsGeoJson(ST_Multi('0103000020E610000001000000210...</b></div><div><b> \
^</b></div><div><b>HINT: Could not choose a best candidate function. You might need \
to add explicit type casts.</b></div>
</div><div><b><br></b></div><div><b><br></b></div><div>If I set explicitly the \
schema in ST_multi it works perfect, however I don't need to put the schema in \
ST_AsGeoJson.</div><div><br></div><div><div> SELECT \
ST_AsGeoJson(dev02.ST_Multi('0103000020E610000001000000210000004CC6D989CA885EC06D8 \
792E62FB842407858A47BCC885EC003B2621E13B84240340535E9D1885EC02AABA47EF7B742405CC81E9DD \
A885EC0DC001817DEB742406C4EBF41E6885EC065BEA4E1C7B74240CE108A64F4885EC003B1C1B8B5B7424 \
08A756F7A04895EC0E220104FA8B74240E29934E515895EC0D8677F28A0B74240D94287F927895EC0A6C03 \
B959DB74240194492053A895EC01F0A9AAEA0B7424017CBD1574B895EC0B0B51E56A9B742400C8EE4455B8 \
95EC0D46DA936B7B7424047FC163369895EC0F4F9B9C7C9B742409436689674895EC0B44CAE52E0B74240C \
4B0CDFF7C895EC00C4AC6F9F9B7424079BA811C82895EC0D267A8C015B84240778532BA83895EC06180139 \
632B842408E3BF2C881895EC0A4955E5E4FB84240DBEAD45B7C895EC0124E5FFE6AB842408B0736A873895 \
EC061F44B6684B84240007FAC0368895EC068E02D9C9AB84240C957C1E059895EC0026C7DC5ACB84240671 \
A89CA49895EC09FCA882FBAB8424063464B5F38895EC051F65256C2B8424055766C4A26895EC067F5A6E9C \
4B84240D52CD73D14895EC0146C2DD0C1B84240CB4924EB02895EC0F20E6628B9B84240FEA6C6FCF2885EC \
0CC5A7B47ABB842403E3B7D0FE5885EC01A25FCB598B84240C5654CACD9885EC025549B2A82B842403EC43 \
943D1885EC05188298368B84240346AFE26CC885EC0DFF70DBC4CB842404CC6D989CA885EC06D8792E62FB84240'))</div>
</div><div><br></div><div>search_path:"dev02, \
shared"</div><div><br></div><div>Post_gis version: \
</div><div>"POSTGIS="2.0.1 r9979" GEOS="3.3.5-CAPI-1.7.5" \
PROJ="Rel. 4.7.1, 23 September 2009" LIBXML="2.7.6" \
LIBJSON="UNKNOWN""<br>
</div><div><br></div><div>Sorry I wrote in the wrong mail list I don't know if \
this is a Postgres problem or Postgis problem.</div><div><br></div><div>Thank \
you</div><br> </div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" \
target="_blank">postgis-users@lists.osgeo.org</a><br> <a \
href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" \
target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br \
clear="all"><br>-- <br>Jean Marchal<br>
<br>Etudiant au doctorat / PHD student<br>Université Laval - Pavillon \
Abitibi-Price<br>Faculté de foresterie, de géographie et de géomatique<br>2405, rue \
de la Terrasse<br>Québec (Québec) G1V 0A6<br>Tél: <a href="tel:418-656-2131" \
value="+14186562131" target="_blank">418-656-2131</a> poste 2620 </div></div>
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic