Something went wrong. Try again.
Simple forward/reverse geocoder for WhosOnFirst admin data
Something went wrong. Try again.
12345678910111213141516171819202122232425262728-- sql/regions.sql-- GENERATED - DO NOT MODIFY. See README.litWITH RECURSIVE parent_chain AS ( SELECT id, parent_id, name, CAST([] AS VARCHAR[]) AS path_names FROM data WHERE id = $1
UNION ALL
SELECT t.id, t.parent_id, t.name, array_append(pc.path_names, t.name) FROM data t JOIN parent_chain pc ON t.id = pc.parent_id WHERE pc.parent_id != -1)SELECT path_namesFROM parent_chainORDER BY array_length(path_names) DESCLIMIT 1;