[Geomoose-users] Doubt about QUERY

Wed Jun 23 14:53:21 EDT 2010

Skipped content of type multipart/alternative-------------- next part --------------
[Wed Jun 23 15:52:20 2010].671000 msPOSTGISLayerOpen called datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].671000 MSPOSTGISLayerOpen -- shared connection not available.
[Wed Jun 23 15:52:20 2010].687000 msConnPoolRegister(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].687000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].687000 msPOSTGISLayerWhichShapes called
[Wed Jun 23 15:52:20 2010].687000 msPOSTGISLayerParseData: unique column = gid, srid='', geom_column_name = the_geom, table_name=usuarios
[Wed Jun 23 15:52:20 2010].687000 query_string_0_6:DECLARE mycursor BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR'),gid::text from usuarios WHERE the_geom && setSRID('BOX3D(684144.685943711 8783028.99962586,684146.290369776 8783030.60405192)'::BOX3D, find_srid('','usuarios','the_geom') )
[Wed Jun 23 15:52:20 2010].703000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].703000 msPOSTGISLayerClose datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].703000 msPOSTGISLayerClose -- closing query_result
[Wed Jun 23 15:52:20 2010].703000 msConnPoolRelease(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].703000 msConnPoolClose(user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].703000 msPOSTGISLayerOpen called datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].703000 MSPOSTGISLayerOpen -- shared connection not available.
[Wed Jun 23 15:52:20 2010].718000 msConnPoolRegister(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerGetShape called for record = 2652
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerParseData: unique column = gid, srid='', geom_column_name = the_geom, table_name=usuarios
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT asbinary(force_collection(force_2d(the_geom)),'NDR') from usuarios WHERE gid = 2652 
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerClose datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerClose -- query_result is NULL
[Wed Jun 23 15:52:20 2010].718000 msConnPoolRelease(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].718000 msConnPoolClose(user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].718000 msDrawMap(): Layer 0 (usuarios), 0.015s
[Wed Jun 23 15:52:20 2010].718000 msPOSTGISLayerOpen called datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].718000 MSPOSTGISLayerOpen -- shared connection not available.
[Wed Jun 23 15:52:20 2010].734000 msConnPoolRegister(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].734000 in msPOSTGISLayerGetItems  (find column names)
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerParseData: unique column = gid, srid='', geom_column_name = the_geom, table_name=usuarios
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerInitItemInfo called
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerGetShape called for record = 2652
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerParseData: unique column = gid, srid='', geom_column_name = the_geom, table_name=usuarios
[Wed Jun 23 15:52:20 2010].734000 msPOSTGISLayerGetShape: DECLARE mycursor2 BINARY CURSOR FOR SELECT "gid"::text,"matricula"::text,"localiz"::text,"nome"::text,"endereco"::text,"numero"::text,"hidrom"::text,"situacao"::text,"vl_debito"::text,"qtd_fat"::text,"dt_corte"::text,"ult_ocor"::text,"med_cons"::text,"ult_cons"::text,"trf_social"::text,"total_os"::text,"os_pend"::text,"dt_proc"::text,"cx"::text,"cy"::text,"ligacao"::text,"sancoes"::text,"cort_pedido"::text,"cort_solic_adm"::text,"nego_ajuste_cont"::text,"nego_parc"::text,"nego_espec_pqd"::text,"religacoes"::text,"intervencoes"::text,"outros"::text,"categoria"::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from usuarios WHERE gid = 2652 
[Wed Jun 23 15:52:20 2010].750000 msPOSTGISLayerFreeItemInfo called
[Wed Jun 23 15:52:20 2010].750000 msPOSTGISLayerClose datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].750000 msPOSTGISLayerClose -- query_result is NULL
[Wed Jun 23 15:52:20 2010].750000 msConnPoolRelease(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].750000 msConnPoolClose(user=postgres password=postgres dbname=deso host=192.168.1.3,01B0DA10)
[Wed Jun 23 15:52:20 2010].750000 msPOSTGISLayerClose datastatement: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:20 2010].750000 msPOSTGISLayerClose -- layerinfo is  NULL
-------------- next part --------------
[Wed Jun 23 15:52:44 2010].353780 msPostGISLayerOpen called: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:44 2010].353847 msPostGISLayerOpen: No connection in pool, creating a fresh one.
[Wed Jun 23 15:52:44 2010].358384 msConnPoolRegister(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,0x9cdb588)
[Wed Jun 23 15:52:44 2010].358426 msPostGISLayerFreeItemInfo called.
[Wed Jun 23 15:52:44 2010].358434 msPostGISLayerGetItems called.
[Wed Jun 23 15:52:44 2010].358439 msPostGISParseData called.
[Wed Jun 23 15:52:44 2010].358462 msPostGISParseData: unique_column=gid, srid=, geom_column_name=the_geom, table_name=usuarios
[Wed Jun 23 15:52:44 2010].358468 msPostGISLayerGetItems executing SQL: select * from usuarios where false limit 0
[Wed Jun 23 15:52:44 2010].360509 msPostGISLayerInitItemInfo called.
[Wed Jun 23 15:52:44 2010].360523 msPostGISLayerInitItemInfo called.
[Wed Jun 23 15:52:44 2010].360531 msPostGISLayerWhichShapes called.
[Wed Jun 23 15:52:44 2010].360536 msPostGISParseData called.
[Wed Jun 23 15:52:44 2010].360543 msPostGISParseData: unique_column=gid, srid=, geom_column_name=the_geom, table_name=usuarios
[Wed Jun 23 15:52:44 2010].360550 msPostGISBuildSQL called.
[Wed Jun 23 15:52:44 2010].360555 msPostGISBuildSQLItems called.
[Wed Jun 23 15:52:44 2010].360560 msPostGISBuildSQLItems: 31 items requested.
[Wed Jun 23 15:52:44 2010].360574 msPostGISBuildSQLFrom called.
[Wed Jun 23 15:52:44 2010].360579 msPostGISBuildSQLWhere called.
[Wed Jun 23 15:52:44 2010].360584 msPostGISBuildSQLSRID called.
[Wed Jun 23 15:52:44 2010].360588 msPostGISBuildSQLSRID: Building find_srid line.
[Wed Jun 23 15:52:44 2010].360592 msPostGISBuildSQLSRID: Found table (usuarios)
[Wed Jun 23 15:52:44 2010].360598 msPostGISBuildSQLBox called.
[Wed Jun 23 15:52:44 2010].360621 msPostGISLayerWhichShapes query: select "gid","matricula","localiz","nome","endereco","numero","hidrom","situacao","vl_debito","qtd_fat","dt_corte","ult_ocor","med_cons","ult_cons","trf_social","total_os","os_pend","dt_proc","cx","cy","ligacao","sancoes","cort_pedido","cort_solic_adm","nego_ajuste_cont","nego_parc","nego_espec_pqd","religacoes","intervencoes","outros","categoria",encode(AsBinary(force_collection(force_2d("the_geom")),'NDR'),'hex') as geom,"gid" from usuarios where the_geom && GeomFromText('POLYGON((-25.0663909774433 -25.0663909774433,-25.0663909774433 23.0663909774433,23.0663909774433 23.0663909774433,23.0663909774433 -25.0663909774433,-25.0663909774433 -25.0663909774433))',find_srid('','usuarios','the_geom'))
[Wed Jun 23 15:52:44 2010].377296 msPostGISLayerWhichShapes query status: PGRES_TUPLES_OK (2)
[Wed Jun 23 15:52:44 2010].377331 msPostGISLayerWhichShapes got 0 records in result.
[Wed Jun 23 15:52:44 2010].377346 msPostGISLayerNextShape called.
[Wed Jun 23 15:52:44 2010].377355 msPostGISLayerFreeItemInfo called.
[Wed Jun 23 15:52:44 2010].377366 msPostGISLayerClose called: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:44 2010].377377 msConnPoolRelease(usuarios,user=postgres password=postgres dbname=deso host=192.168.1.3,0x9cdb588)
[Wed Jun 23 15:52:44 2010].377386 msConnPoolClose(user=postgres password=postgres dbname=deso host=192.168.1.3,0x9cdb588)
[Wed Jun 23 15:52:44 2010].377515 msQueryByPoint(): Search returned no results. No matching record(s) found.
[Wed Jun 23 15:52:44 2010].377556 msPostGISLayerClose called: the_geom FROM usuarios USING UNIQUE gid
[Wed Jun 23 15:52:44 2010].377584 freeLayer(): freeing layer at 0x9cd0870.
[Wed Jun 23 15:52:44 2010].377592 msPostGISLayerIsOpen called.