sources/potlatch/post.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

--
--  Taginfo source: Potlatch
--
--  post.sql
--

.bail ON

-- pull over category name from categories table so we don't need joins later
UPDATE features SET category_name = (SELECT name FROM categories WHERE id=category_id);

ANALYZE;

UPDATE source SET update_end=datetime('now');