Referential integrity

33 views
Skip to first unread message

Marco

unread,
Jun 15, 2012, 6:53:26 PM6/15/12
to geon...@googlegroups.com
Hello,
out of some of your files I built a database with relational integrity and loaded continents, countries, and area1 codes very fine. Unfortunately the area2 file seems to have a lot of points that do not belong to the area1 file's areas. Is that intentional, or perhaps a list of the missing points I have built could help you fixing this?

Thanks
  Marco

Marc Wick

unread,
Jun 20, 2012, 2:05:29 AM6/20/12
to geon...@googlegroups.com
Hi Marco

For some features we have obsolete admin codes in the source file and
they are includes in the export. You can set them to 'null' if they
cause you troubles. They are included as some users are interested in
obsolete admin info rather than nothing.
If you want to help fix it you can investigate what the current admin
division is for the feature.

Best Regards

Marc
> --
> You received this message because you are subscribed to the Google
> Groups "GeoNames" group.
> To view this discussion on the web visit
> https://groups.google.com/d/msg/geonames/-/15H2HAurAJAJ.
> To post to this group, send email to geon...@googlegroups.com.
> To unsubscribe from this group, send email to
> geonames+u...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/geonames?hl=en.

Marco

unread,
Jun 20, 2012, 5:51:46 PM6/20/12
to geon...@googlegroups.com
Hello Marc,
thank you for the information. At the moment I think I will just ignore the rows with obsolete codes until someone complains!

Thanks
  Marco
Reply all
Reply to author
Forward
0 new messages