QGIS中TimeManager的一个问题修复

在QGIS中使用TimeManager时遇到一个问题,即满足时空要素要求后,时空数据展示不出来。点击数据的layer查看发现其对应的sql语句大概是:
dbname='citybigdata' host=localhost port=5432 sslmode=disable key='id' srid=4326 type=Point table="qqheat"."milocal" (geom) sql=cast("ts" as character) < '2016-11-09 21:05:00' AND cast("ts" as character) >= '2016-11-09 21:00:00'
将类似的语句直接在psql中发现执行的时候有问题,无法返回结果。但将语句修改一下即可解决:
dbname='citybigdata' host=localhost port=5432 sslmode=disable key='id' srid=4326 type=Point table="qqheat"."milocal" (geom) sql=cast("ts" as text) < '2016-11-09 21:05:00' AND cast("ts" as text) >= '2016-11-09 21:00:00'
即将其中的character改成text即可。
为了使插件工作正常,就需要修改timemanager的代码,使用grep工具找到该代码的位置:

cd .qgis2/python/plugins/timemanger
grep -rnw ‘.’ -e ‘character’

发现是如下代码的问题:

./.git/hooks/pre-commit.sample:26:# printable range starts at the space character and ends with tilde.
./CONTRIBUTING.md:13:* Go to http://www.loc.gov/standards/iso639-2/php/code_list.php and find the 2-character ISO 639-1
./docs/Doxyfile:586:# This tag can be used to specify the character encoding of the source files
./query_builder.py:9:STRINGCAST_FORMAT = ‘cast(“{}” as character) {} \'{}\’ AND cast(“{}” as character) >= \'{}\’ ‘
./query_builder.py:56: return ‘ cast(“{}” as character) LIKE \’%BC\”.format(attr)
./query_builder.py:63: return ‘ cast(“{}” as character) LIKE \’%AD\”.format(attr)
./query_builder.py:79: return ” ‘{}’ {} cast(\”{}\” as character) “.format(val, comparison, col)
./query_builder.py:87: return ” ‘{}’ {} cast(\”{}\” as character) “.format(val, comparison, col)

将具体的代码修改,然后重启qgis,即可工作正常。


已发布

分类

,

来自

标签:

评论

《 “QGIS中TimeManager的一个问题修复” 》 有 13 条评论

  1. get enclomiphene generic switzerland

    how to order enclomiphene price on prescription

  2. acheter kamagra à londres

    acheter canadien kamagra

  3. Canada androxal no perscription

    how to order androxal purchase in canada

  4. discount flexeril cyclobenzaprine price at walmart

    how to buy flexeril cyclobenzaprine without prescriptions canada

  5. how to buy dutasteride cheap store

    get dutasteride generic available

  6. buying gabapentin generic equivalent

    discount gabapentin buy for cheap

  7. order fildena online

    ordering fildena usa discount

  8. buy staxyn generic is good

    get staxyn buy mastercard

  9. buying itraconazole generic pricing

    cheapest buy itraconazole generic when will be available

  10. buy avodart generic low price

    price of avodart at a pharmacy

  11. cheap rifaximin buy safely online

    cheapest price for rifaximin

  12. discount xifaxan buy mastercard

    buying xifaxan generic mastercard

  13. obecná lékárna usa kamagra

    kamagra super nejlepナ。テュ ceny

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注