Global Administrative Areas

Loaded gadm1.shp in Oracle Spatial with gdal. ObjectID 152086 returns in many queries.

Regards,

Gosse Adema


select objectid, name_0, name_1, name_2
from gadm1 a
, geo_geonames_data b
where sdo_filter (a.ora_geometry, b.gps_location ) = 'TRUE'
and b.name = 'Amsterdam' -- 4.89990234375,52.3730839945403,0
and country_code = 'NL'


OBJECTID NAME_0 NAME_1 NAME_2
---------- ------------------ ------------------ ---------------
80400 Netherlands Noord-Holland Amsterdam
152086 United States Alaska Aleutians West