The following query's all work fine, select distinct zoa_metar_xml.stn_id, zoa_metar_xml.metar_txt, zoa_metar_xml.time, zoa_metar_xml.flt_cat, zoa_metar_xml.cld_cvr, zoa_metar_xml.cld_base, zoa_metar_xml.lonlat, zoa_metar_xml.geom from zoa_metar_xml; select distinct id, kml, type, min_hgt, max_hgt from zoa_sectors_basetop where zoa_sectors_basetop.id='$i' and (zoa_sectors_basetop.type = 'LO' or zoa_sectors_basetop.type='HILO'); select distinct zoa_sectors_basetop.id, west_pirep_xml.raw_text, west_pirep_xml.cld_cvr, west_pirep_xml.cld_base, west_pirep_xml.cld_top, west_pirep_xml.altitude, west_pirep_xml.time, west_pirep_xml.acft_type, zoa_sectors_basetop.max_hgt, zoa_sectors_basetop.min_hgt, zoa_sectors_basetop.type, west_pirep_xml.lonlat from zoa_sectors_basetop, west_pirep_xml, artcc where (ST_DWithin(zoa_sectors_basetop.geom, west_pirep_xml.geom, 0) and ST_DWithin(artcc.the_geom, zoa_sectors_basetop.geom, 0)) and zoa_sectors_basetop.id='$i' and (west_pirep_xml.cld_base <= 5000 or west_pirep_xml.cld_top <= 10000) and west_pirep_xml.cld_cvr != 'SKC' and (zoa_sectors_basetop.type='LO' or zoa_sectors_basetop.type='HILO'); So I'm not sure why this query is not working, select distinct zoa_metar_xml.stn_id, zoa_metar_xml.metar_txt, zoa_metar_xml.time, zoa_metar_xml.flt_cat, zoa_metar_xml.cld_cvr, zoa_metar_xml.cld_base, zoa_metar_xml.lonlat from zoa_metar_xml, zoa_sectors_basetop, artcc where (ST_DWithin (zoa_sectors_basetop.geom, zoa_metar_xml.geom, 0) and ST_DWithin (artcc.the_geom, zoa_sectors_basetop.geom, 0)) and zoa_sectors_basetop.id='$i' and (zoa_sectors_basetop.type='LO' or zoa_sectors_basetop.type='HILO'); Believe it has something to do with the ST_DWithin portion of the query (but these work in other queries)...all of these queries are being executed from a php file, then create kml files. The first query creates kml file for metars, this is working and geometry is there, so I'm not sure why I can't match these with the zoa_sectors_basetop.geom or artcc.the_geom, because the last working query also works when matching intersecting polygons with the zoa_sectors_basetop.geom. So looks like the problem may lie in the geometry in the table zoa_metar_xml. But can't figure why? Hope this is enough info, can anyone help? Thanks, Nick -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
