I'm trying to load a shapefile (link) into my database with shp2pgsql.
shp2pgsql -D -W UTF8 -I -s 4326 scbel01012011_gen13.shp bel | psql -d stat
no problem so far, but when I'm trying to get some informations from the table by using a coordinate I get no results. I checked the table, all data are loaded. Here my query:
SELECT * FROM bel WHERE ST_Intersects(geom,ST_SetSRID(st_makepoint(4.380286, 51.112025), 4326));