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
Comments
United States, Alaska, Aleutians West
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