Search by GNIS Feature ID (Domestic and Foreign API service)

187 views
Skip to first unread message

Linwood Creekmore III

unread,
May 20, 2017, 3:05:22 AM5/20/17
to GeoNames
Thanks in advance Geonames community for the help. I also apologize if this is the wrong forum to ask the question but ask that you direct me to the appropriate medium for the question.

The question:  Is there a service where I can search a GNIS Feature ID (531871 for Washington D.C or -1898541 for Beijing, China) and return the json or xml data for the ID?

Why: I am trying to improve my gdeltPyR module that accesses GDELT data using an API; I want to normalize the place names in my result sets.

Why do this?: The GDELT data has an "ActionGeo_FeatureID" column, which uses GNIS Ids, but the "ActionGeo_FullName" column is extracted from the news article and can be different although it refers to the same place.

What I've tried: I know I can search for domestic FeatureIDs at USGS and for foreign (outside of US) IDs at NGAs GeoNames server. I also know the geonames.org site has a few web services, but didn't find the ID search

What I'm looking for specifically: Single API or endpoint where I can enter the numeric featureID and get the info return in XML or (preferably) JSON format.

What I will do with the return?: Replace the GDELT full name value with a normalized value based on the common featureID.

Backup: I know I could just pass seperate queries to the USGS or NGA service based on the country, but I wanted to see if there was a single FeatureID query service.

Thanks!

Very respectfully,
Linwood Creekmore

Marc Wick

unread,
Jun 2, 2017, 1:35:06 PM6/2/17
to geon...@googlegroups.com
Hi Linwood

There is an export of the geonameids and ufi/fids:
http://www.geonames.org/gnis_geonameid.csv.gz
http://www.geonames.org/nga_geonameid.csv.gz

Do you need it for only a handful of features?

Best Regards

Marc

Linwood Creekmore III wrote:
> Thanks in advance Geonames community for the help. I also apologize if
> this is the wrong forum to ask the question but ask that you direct me
> to the appropriate medium for the question.
>
> The question: Is there a service where I can search a GNIS Feature ID
> (531871 for Washington D.C or -1898541 for Beijing, China) and return
> the json or xml data for the ID?
>
> Why: I am trying to improve my gdeltPyR module
> <https://github.com/linwoodc3/gdeltPyR> that accesses GDELT data using
> an API; I want to normalize the place names in my result sets.
>
> Why do this?: The GDELT data has an "ActionGeo_FeatureID" column, which
> uses GNIS Ids, but the "ActionGeo_FullName" column is extracted from the
> news article and can be different although it refers to the same place.
>
> What I've tried: I know I can search for domestic FeatureIDs at USGS
> <https://geonames.usgs.gov/apex/f?p=138:1:0::NO:::>and for foreign
> (outside of US) IDs at NGAs GeoNames server
> <http://geonames.nga.mil/namesgaz/>. I also know the geonames.org site
> has a few web services, but didn't find the ID search
>
> What I'm looking for specifically: Single API or endpoint where I can
> enter the numeric featureID and get the info return in XML or
> (preferably) JSON format.
>
> What I will do with the return?: Replace the GDELT full name value with
> a normalized value based on the common featureID.
>
> Backup: I know I could just pass seperate queries to the USGS or NGA
> service based on the country, but I wanted to see if there was a single
> FeatureID query service.
>
> Thanks!
>
> Very respectfully,
> Linwood Creekmore
>
> --
> You received this message because you are subscribed to the Google
> Groups "GeoNames" group.
> To unsubscribe from this group and stop receiving emails from it, send
> an email to geonames+u...@googlegroups.com
> <mailto:geonames+u...@googlegroups.com>.
> To post to this group, send email to geon...@googlegroups.com
> <mailto:geon...@googlegroups.com>.
> Visit this group at https://groups.google.com/group/geonames.
> For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages