Skip to content

Instantly share code, notes, and snippets.

@mattmakesmaps

mattmakesmaps/layer.sql Secret

Created January 2, 2014 21:23
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mattmakesmaps/45fe32931cacdf40d107 to your computer and use it in GitHub Desktop.
Save mattmakesmaps/45fe32931cacdf40d107 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
layer.sql
somalia=# SELECT *
somalia-# FROM layer;
topology_id | layer_id | schema_name | table_name | feature_column | feature_type | level | child_id
-------------+----------+---------------+-----------------+----------------+--------------+-------+----------
1 | 1 | public | somalia_admin1s | topogeoms | 3 | 0 |
2 | 1 | somalia_bakup | LAYER1 | | 3 | 0 |
3 | 1 | somalia2 | LAYER1 | | 3 | 0 |
4 | 1 | somalia3 | LAYER1 | | 3 | 0 |
5 | 1 | somalia4 | LAYER1 | | 3 | 0 |
6 | 1 | somalia5 | LAYER1 | | 3 | 0 |
7 | 1 | somalia6 | LAYER1 | | 3 | 0 |
8 | 1 | somalia7 | LAYER1 | | 3 | 0 |
somalia=# SELECT *
somalia-# FROM topology;
id | name | srid | precision | hasz
----+---------------+------+-----------+------
1 | somalia | 4326 | 0 | f
2 | somalia_bakup | 4326 | 0 | f
3 | somalia2 | 4326 | 0 | f
4 | somalia3 | 4326 | 0 | f
5 | somalia4 | 4326 | 0 | f
6 | somalia5 | 4326 | 0 | f
7 | somalia6 | 4326 | 0 | f
8 | somalia7 | 4326 | 0 | f
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment