{ "info": { "author": "Eduardo G. S. Pereira", "author_email": "edu_vcd@hotmail.com", "bugtrack_url": null, "classifiers": [ "Programming Language :: Python :: 3", "Programming Language :: Python :: 3.4", "Programming Language :: Python :: 3.5", "Programming Language :: Python :: 3.6", "Programming Language :: Python :: 3.7" ], "description": "# pypika-gis\n\nSpatialTypes functions for extend [PyPika](https://github.com/kayak/pypika) with GIS.\n\n## Install\n\n```bash\npip install pypika-gis\n```\n\n## Example\n\n```python\nfrom pypika import Query\nfrom pypika_gis import spatialtypes as st\n\nquery = Query.from_('field').select('id', st.AsGeoJSON('geom'))\nprint(str(query))\n# SELECT \"id\",ST_AsGeoJSON('geom') FROM \"field\"\n\nquery = Query.from_('crop').select('id').where(st.Intersects('geom', st.SetSRID(st.MakePoint(10, 5), 4326)))\nprint(str(query))\n# SELECT \"id\" FROM \"crop\" WHERE ST_Intersects('geom',ST_SRID(ST_MakePoint(10,5),4326))\n```\n\n## Available functions\n\n- Envelope(ST_Envelope)\n- Extent(ST_Extent)\n- GeomFromGeoJSON(ST_GeomFromGeoJSON)\n- GeoHash(ST_GeoHash)\n- Intersection(ST_Intersection)\n- Intersects(ST_Intersects)\n- IsEmpty(ST_IsEmpty)\n- IsValid(ST_IsValid)\n- MakePoint(ST_MakePoint)\n- SetSRID(ST_SetSRID)\n- Within(ST_Within)\n- X(ST_X)\n- Y(ST_Y)\n- Z(ST_Z)\n\n## Development\n\n### Dependencies\n\n- [Python](https://www.python.org/downloads/)\n- [poetry](https://poetry.eustace.io/)\n\n### Setup\n\n```bash\npoetry install\n```\n\n### Tests\n\nFull tests and coverage\n\n```bash\npoetry run pytest\n```\n\n### Publish\n\n```bash\npoetry build\npoetry publish\n```\n\n## Credits\n\npypika-gis is based on [PyPika](https://github.com/kayak/pypika). Check their page for further query buider instructions, examples and more details about PyPika core.\n", "description_content_type": "text/markdown", "docs_url": null, "download_url": "", "downloads": { "last_day": -1, "last_month": -1, "last_week": -1 }, "home_page": "https://github.com/eduardogspereira/pypika-gis", "keywords": "pypika,gis,postgis,sql,builder", "license": "", "maintainer": "Eduardo G. S. Pereira", "maintainer_email": "edu_vcd@hotmail.com", "name": "pypika-gis", "package_url": "https://pypi.org/project/pypika-gis/", "platform": "", "project_url": "https://pypi.org/project/pypika-gis/", "project_urls": { "Homepage": "https://github.com/eduardogspereira/pypika-gis", "Repository": "https://github.com/eduardogspereira/pypika-gis" }, "release_url": "https://pypi.org/project/pypika-gis/1.2.3/", "requires_dist": [ "PyPika (<1.0.0)" ], "requires_python": ">=3.0.0,<4.0.0", "summary": "SpatialTypes functions for extend PyPika with GIS", "version": "1.2.3" }, "last_serial": 5655284, "releases": { "0.0.3": [ { "comment_text": "", "digests": { "md5": "d0a2517f71fafd07454d82ea17aa1fcf", "sha256": "e67c4016c709d3ccefe2363c2c1a30e694912f310d83ad17ad68a1557fa222c2" }, "downloads": -1, "filename": "pypika_gis-0.0.3-py3-none-any.whl", "has_sig": false, "md5_digest": "d0a2517f71fafd07454d82ea17aa1fcf", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5894, "upload_time": "2018-11-19T00:11:09", "url": "https://files.pythonhosted.org/packages/4a/73/009d539006ea8963fa5379fe8a77392bc2f5c105fe3479e56309f37cd454/pypika_gis-0.0.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "69c23d820762a42909b7bdaa1eff92f7", "sha256": "e438f502243f3898540a19fbace40529649cbd44a02351a6fe76b3abd25f8678" }, "downloads": -1, "filename": "pypika-gis-0.0.3.tar.gz", "has_sig": false, "md5_digest": "69c23d820762a42909b7bdaa1eff92f7", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 1295, "upload_time": "2018-11-19T00:11:11", "url": "https://files.pythonhosted.org/packages/d8/9e/5eeb8a250253cfeb2d5c321c9d92f6e7cff895a52d552da06b820b262876/pypika-gis-0.0.3.tar.gz" } ], "0.0.4": [ { "comment_text": "", "digests": { "md5": "65f555b8fc3f08691f277a93ba8ece26", "sha256": "d022063c74864faf639a81e5bc20a7c02bbf980feb2384d5e991e4463cc73252" }, "downloads": -1, "filename": "pypika_gis-0.0.4-py3-none-any.whl", "has_sig": false, "md5_digest": "65f555b8fc3f08691f277a93ba8ece26", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5893, "upload_time": "2018-11-19T00:18:42", "url": "https://files.pythonhosted.org/packages/4c/0f/ddb0e5ada64a88d7b830c431d1fbbfc4f6dac301cbce92ae8d00aedc869d/pypika_gis-0.0.4-py3-none-any.whl" } ], "0.0.5": [ { "comment_text": "", "digests": { "md5": "d1b882aa59d03021d7883e7b45a04786", "sha256": "7b4b953a6c64f59327dfba86b295b50b24a9ea6ccc6cebca27c269e59df2f089" }, "downloads": -1, "filename": "pypika_gis-0.0.5-py3-none-any.whl", "has_sig": false, "md5_digest": "d1b882aa59d03021d7883e7b45a04786", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 5929, "upload_time": "2018-11-19T00:24:04", "url": "https://files.pythonhosted.org/packages/9e/ff/cf6f223c6920b28171eb8dad975354cdab107bc5f863455e95e837bcfbe6/pypika_gis-0.0.5-py3-none-any.whl" } ], "0.0.6": [ { "comment_text": "", "digests": { "md5": "7445e6d6fd6a7d7f886f50b90132fac9", "sha256": "56237a495d8614aab0a95364ad23b9b779b1114601eeb25c2955ec4ef485995a" }, "downloads": -1, "filename": "pypika_gis-0.0.6-py3-none-any.whl", "has_sig": false, "md5_digest": "7445e6d6fd6a7d7f886f50b90132fac9", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7038, "upload_time": "2018-11-19T03:36:45", "url": "https://files.pythonhosted.org/packages/5c/d2/f9f183d9a6420c68690b36e39df4f684a7302cbc2197c4a85bb756be455b/pypika_gis-0.0.6-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "cd592308f843993b71bf8c9ad170b655", "sha256": "9ea916d98cf423dccf92c17e1dd2c17d2d9e672b2e6165a3b0ae7f3d32356981" }, "downloads": -1, "filename": "pypika-gis-0.0.6.tar.gz", "has_sig": false, "md5_digest": "cd592308f843993b71bf8c9ad170b655", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2515, "upload_time": "2018-11-19T03:36:47", "url": "https://files.pythonhosted.org/packages/8c/a4/facdf84b59b8888089b93730b57df8a90db226d54c37eb3817f9332f92dd/pypika-gis-0.0.6.tar.gz" } ], "1.0.0": [ { "comment_text": "", "digests": { "md5": "26e60436850c4626770bd7b33a0e76be", "sha256": "229caeb2e38c35a8b28e062f2bca2b566f02c7cb0c39a07d163e896377cd1bf9" }, "downloads": -1, "filename": "pypika_gis-1.0.0-py3-none-any.whl", "has_sig": false, "md5_digest": "26e60436850c4626770bd7b33a0e76be", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7035, "upload_time": "2018-11-19T03:41:50", "url": "https://files.pythonhosted.org/packages/66/05/4918b484cf4c62a5d7b7fd7f508a9578ea587bf56a2f345db05550346896/pypika_gis-1.0.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "4876258d4096d0d1c58884021d05d295", "sha256": "b4b320ad6cd08dcd13d31fa8b76d1cf54586762fe2a7c096cd95578e35b861a6" }, "downloads": -1, "filename": "pypika-gis-1.0.0.tar.gz", "has_sig": false, "md5_digest": "4876258d4096d0d1c58884021d05d295", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2572, "upload_time": "2018-11-19T03:41:52", "url": "https://files.pythonhosted.org/packages/ba/27/16554fe8a1a69c6b845064b0b2cdc825d24b4a0a6d4d255f144a82da9251/pypika-gis-1.0.0.tar.gz" } ], "1.1.0": [ { "comment_text": "", "digests": { "md5": "ba730818f917156725ce0065f918f20b", "sha256": "99a0f858715daba7cfad6096038a990d681885976c4b4246ec7d7628b2a5b21e" }, "downloads": -1, "filename": "pypika_gis-1.1.0-py3-none-any.whl", "has_sig": false, "md5_digest": "ba730818f917156725ce0065f918f20b", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": null, "size": 7036, "upload_time": "2018-11-19T03:50:37", "url": "https://files.pythonhosted.org/packages/e6/dc/ee94573315c27edc08dbfd12f29046afa9561c1452669a8742edb9e8fedd/pypika_gis-1.1.0-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "15f6f3eb21aaef3cef672e96f133bc63", "sha256": "b80daced6c63073f0083d6e987b639677783772e849ccb7c575419d43452f625" }, "downloads": -1, "filename": "pypika-gis-1.1.0.tar.gz", "has_sig": false, "md5_digest": "15f6f3eb21aaef3cef672e96f133bc63", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 2649, "upload_time": "2018-11-19T03:50:38", "url": "https://files.pythonhosted.org/packages/dd/bd/16c67b3d509779a010ed8f9b9e202caace087e9b5f28081e19d00065bac7/pypika-gis-1.1.0.tar.gz" } ], "1.2.0": [ { "comment_text": "", "digests": { "md5": "c71cd0ffe96c6e8dd27df2d7e357f6e1", "sha256": "6febd5f3daf97f0f6eb10efbb08784bad147b57be085df924fdcd26ebf41464e" }, "downloads": -1, "filename": "pypika_gis-1.2.0-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "c71cd0ffe96c6e8dd27df2d7e357f6e1", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 20571, "upload_time": "2019-04-07T03:33:47", "url": "https://files.pythonhosted.org/packages/74/5c/e2e04888b7a77ecb98d472fdd85249556c2119c051536526b812ab21e6d4/pypika_gis-1.2.0-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9437ecc9a1a0240f44f9b6aecb9b55b2", "sha256": "65b9f99fad50c347c2b0219c968909907cd073a07754aeede7b5c1fe26e5f9cc" }, "downloads": -1, "filename": "pypika-gis-1.2.0.tar.gz", "has_sig": false, "md5_digest": "9437ecc9a1a0240f44f9b6aecb9b55b2", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 6816, "upload_time": "2019-04-07T03:33:45", "url": "https://files.pythonhosted.org/packages/83/63/8aca5ebf12cf5cad7fe4ebf5ce5207c50946363b0c5c176490e2082f4d2f/pypika-gis-1.2.0.tar.gz" } ], "1.2.1": [ { "comment_text": "", "digests": { "md5": "11a3bfdef41e2f4db413c52204c5e5c1", "sha256": "52cc4f5e1390187be8c6c4cbf26bf4dfecf2f06926b4efcf10d068262dbe9b0d" }, "downloads": -1, "filename": "pypika_gis-1.2.1-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "11a3bfdef41e2f4db413c52204c5e5c1", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9728, "upload_time": "2019-08-09T11:49:28", "url": "https://files.pythonhosted.org/packages/45/70/c3772232b918faa9771b395113f5b8f4781d2dfa5047adff20a1b4c2eab8/pypika_gis-1.2.1-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "99c0a1c9706fd1997d7cc7eddaa3c600", "sha256": "2e8db3cc7e17ada63ce71bae3cb646297dc738b9b0bdd71ea1ffdbb1e0f103ef" }, "downloads": -1, "filename": "pypika-gis-1.2.1.tar.gz", "has_sig": false, "md5_digest": "99c0a1c9706fd1997d7cc7eddaa3c600", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8554, "upload_time": "2019-08-09T11:49:26", "url": "https://files.pythonhosted.org/packages/9c/75/193a3ff29622cc0a6d18da4b0cfae1ab442db4b2c95747b1f4cfadd08036/pypika-gis-1.2.1.tar.gz" } ], "1.2.2": [ { "comment_text": "", "digests": { "md5": "9ee26a98bd005eb3caa0ebc5263621e6", "sha256": "ef35eb925444333ad61fcb952b32b788552c6bda201231277ca48a622c5751bf" }, "downloads": -1, "filename": "pypika_gis-1.2.2-py2.py3-none-any.whl", "has_sig": false, "md5_digest": "9ee26a98bd005eb3caa0ebc5263621e6", "packagetype": "bdist_wheel", "python_version": "py2.py3", "requires_python": null, "size": 9736, "upload_time": "2019-08-09T11:54:44", "url": "https://files.pythonhosted.org/packages/db/a5/792e543e084fb83a19e89e62edf0db683060bf8bfcf64ad139e3ad72463d/pypika_gis-1.2.2-py2.py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "8721a4255ac46c0931099cde68d7587f", "sha256": "917d97ccdefcb0bf085db851ce8c33c0903e6ec576480013473062d2c20461c6" }, "downloads": -1, "filename": "pypika-gis-1.2.2.tar.gz", "has_sig": false, "md5_digest": "8721a4255ac46c0931099cde68d7587f", "packagetype": "sdist", "python_version": "source", "requires_python": null, "size": 8598, "upload_time": "2019-08-09T11:54:43", "url": "https://files.pythonhosted.org/packages/d1/ff/0a5141dc15c9459fe78756d68bbd84558af7ce6246bdbea1725dc520ca39/pypika-gis-1.2.2.tar.gz" } ], "1.2.3": [ { "comment_text": "", "digests": { "md5": "27399ce619306ea5208e97e423024f61", "sha256": "e3ac2afab24da76de6c97cdbe7002746ea33c2402e7319220a49983ade17d072" }, "downloads": -1, "filename": "pypika_gis-1.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "27399ce619306ea5208e97e423024f61", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.0.0,<4.0.0", "size": 7362, "upload_time": "2019-08-09T12:06:28", "url": "https://files.pythonhosted.org/packages/e2/f3/71c7cedd432fddd4f013aba83385e52e6b436ba96c618e754550f1b98d90/pypika_gis-1.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9a865ed6a21a03cdd41255f5fe86ba4f", "sha256": "1998bd62958b6fedcda31594a968032cf330112ea75951515c8c12d341a9e7b6" }, "downloads": -1, "filename": "pypika-gis-1.2.3.tar.gz", "has_sig": false, "md5_digest": "9a865ed6a21a03cdd41255f5fe86ba4f", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.0.0,<4.0.0", "size": 6993, "upload_time": "2019-08-09T12:06:27", "url": "https://files.pythonhosted.org/packages/12/a7/4fc7b0cdbc768b60326c644ac2c18241c5e4cf265af7ba25bf01dd258477/pypika-gis-1.2.3.tar.gz" } ] }, "urls": [ { "comment_text": "", "digests": { "md5": "27399ce619306ea5208e97e423024f61", "sha256": "e3ac2afab24da76de6c97cdbe7002746ea33c2402e7319220a49983ade17d072" }, "downloads": -1, "filename": "pypika_gis-1.2.3-py3-none-any.whl", "has_sig": false, "md5_digest": "27399ce619306ea5208e97e423024f61", "packagetype": "bdist_wheel", "python_version": "py3", "requires_python": ">=3.0.0,<4.0.0", "size": 7362, "upload_time": "2019-08-09T12:06:28", "url": "https://files.pythonhosted.org/packages/e2/f3/71c7cedd432fddd4f013aba83385e52e6b436ba96c618e754550f1b98d90/pypika_gis-1.2.3-py3-none-any.whl" }, { "comment_text": "", "digests": { "md5": "9a865ed6a21a03cdd41255f5fe86ba4f", "sha256": "1998bd62958b6fedcda31594a968032cf330112ea75951515c8c12d341a9e7b6" }, "downloads": -1, "filename": "pypika-gis-1.2.3.tar.gz", "has_sig": false, "md5_digest": "9a865ed6a21a03cdd41255f5fe86ba4f", "packagetype": "sdist", "python_version": "source", "requires_python": ">=3.0.0,<4.0.0", "size": 6993, "upload_time": "2019-08-09T12:06:27", "url": "https://files.pythonhosted.org/packages/12/a7/4fc7b0cdbc768b60326c644ac2c18241c5e4cf265af7ba25bf01dd258477/pypika-gis-1.2.3.tar.gz" } ] }