Skip to content

Instantly share code, notes, and snippets.

@apetresc

apetresc/gist:3189756

Created July 27, 2012 18:50
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save apetresc/3189756 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save apetresc/3189756 to your computer and use it in GitHub Desktop.
Download ZIP
select * from placex where place_id=118271518;
Raw
gistfile1.txt
place_id | partition | osm_type | osm_id | class | type | name | admin_level | housenumber | street | isin | postcode | country_code | extratags | geometry | parent_place_id | linked_place_id | rank_address | rank_search | importance | indexed_status | indexed_date | wikipedia | geometry_sector | calculated_country_code | centroid
-----------+-----------+----------+-----------+----------+------+-------------------------------------------------------------------------------------+-------------+-------------+--------+------+----------+--------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+-----------------+--------------+-------------+------------+----------------+--------------+-----------+-----------------+-------------------------+----------
118271518 | 244 | W | 132778101 | building | yes | "name"=>"Michael G. DeGroote School of Medicine", "operator"=>"McMaster University" | 15 | | | | | | | 0103000020E61000000100000005000000E65DF580F91F54C043EF4394E5B945403460353BF71F54C0AB2BFA9EECB945400A4ED8D9EB1F54C06D8896E1E4B94540F1EB2C1FEE1F54C0064CE0D6DDB94540E65DF580F91F54C043EF4394E5B94540 | | | 30 | 30 | | 1 | | | 244580457 | ca |
@apetresc
Copy link
Copy Markdown
Author

apetresc commented Jul 27, 2012 

nominatim=# update placex set indexed_status=0 where place_id=118271518;
UPDATE 1

@apetresc
Copy link
Copy Markdown
Author

apetresc commented Jul 27, 2012 

 place_id  | partition | osm_type |  osm_id   |  class   | type |                                        name                                         | admin_level | housenumber | street | isin | postcode | country_code | extratags |                                                                                              geometry                                                                                              | parent_place_id | linked_place_id | rank_address | rank_search | importance | indexed_status |        indexed_date        | wikipedia | geometry_sector | calculated_country_code | centroid 
-----------+-----------+----------+-----------+----------+------+-------------------------------------------------------------------------------------+-------------+-------------+--------+------+----------+--------------+-----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------------+-----------------+--------------+-------------+------------+----------------+----------------------------+-----------+-----------------+-------------------------+----------
 118271518 |       244 | W        | 132778101 | building | yes  | "name"=>"Michael G. DeGroote School of Medicine", "operator"=>"McMaster University" |          15 |             |        |      |          |              |           | 0103000020E61000000100000005000000E65DF580F91F54C043EF4394E5B945403460353BF71F54C0AB2BFA9EECB945400A4ED8D9EB1F54C06D8896E1E4B94540F1EB2C1FEE1F54C0064CE0D6DDB94540E65DF580F91F54C043EF4394E5B94540 |        20437774 |                 |           30 |          30 |            |              0 | 2012-07-27 14:52:28.130456 |           |       244580457 | ca                      | 
(1 row)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment