encounter


Nameencounter JSON
Version 0.0.1 PyPI version JSON
download
home_pagehttps://bitbucket.org/j2-riseley/qcr-py-tools/
SummaryTools for studying aircraft detection
upload_time2020-09-17 03:35:13
maintainer
docs_urlNone
authorJenna Riseley
requires_python>=3.5, <4
license
keywords sample setuptools development
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            SQL Cheatsheet



Find all the aicraft on a particular hour over Haight St, San Fran:

.. code-block:: SQL

    select * from state_vectors_data4 where hour=1480759200 and lat > 38.0000 and lat < 39.0000 and lon > -123.0000 and lon < -122.0000;


Count all the timestamps in the same location but over about a week:

.. code-block:: SQL

    SELECT COUNT(*) FROM state_vectors_data4 WHERE hour>=1598918400 AND hour<=1599523200  and lat > 38.0000 and lat < 39.0000 and lon > -123.0000 and lon < -122.0000;


Count aircraft which arrived or departed or crossed Frankfurt airport during a certain hour:

.. code-block:: SQL 

    SELECT COUNT(DISTINCT icao24) FROM state_vectors_data4 WHERE lat<=50.07 AND lat>=49.98 AND lon<=8.62 AND lon>=8.48 AND hour=1493892000;
            

Raw data

            {
    "_id": null,
    "home_page": "https://bitbucket.org/j2-riseley/qcr-py-tools/",
    "name": "encounter",
    "maintainer": "",
    "docs_url": null,
    "requires_python": ">=3.5, <4",
    "maintainer_email": "",
    "keywords": "sample,setuptools,development",
    "author": "Jenna Riseley",
    "author_email": "j2.riseley@qut.edu.au",
    "download_url": "https://files.pythonhosted.org/packages/b1/a1/439d610bcd353e4652a8583483b8b31943b6aad592e1c42d5e1ff5b91ff3/encounter-0.0.1.tar.gz",
    "platform": "",
    "description": "SQL Cheatsheet\n\n\n\nFind all the aicraft on a particular hour over Haight St, San Fran:\n\n.. code-block:: SQL\n\n    select * from state_vectors_data4 where hour=1480759200 and lat > 38.0000 and lat < 39.0000 and lon > -123.0000 and lon < -122.0000;\n\n\nCount all the timestamps in the same location but over about a week:\n\n.. code-block:: SQL\n\n    SELECT COUNT(*) FROM state_vectors_data4 WHERE hour>=1598918400 AND hour<=1599523200  and lat > 38.0000 and lat < 39.0000 and lon > -123.0000 and lon < -122.0000;\n\n\nCount aircraft which arrived or departed or crossed Frankfurt airport during a certain hour:\n\n.. code-block:: SQL \n\n    SELECT COUNT(DISTINCT icao24) FROM state_vectors_data4 WHERE lat<=50.07 AND lat>=49.98 AND lon<=8.62 AND lon>=8.48 AND hour=1493892000;",
    "bugtrack_url": null,
    "license": "",
    "summary": "Tools for studying aircraft detection",
    "version": "0.0.1",
    "split_keywords": [
        "sample",
        "setuptools",
        "development"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "b3b49997f7365a8030cfa5b4860a2e0b",
                "sha256": "6230b2a4c053a20d1f5aed96d925ac631564a300fe686b2c184d260b11bfefd5"
            },
            "downloads": -1,
            "filename": "encounter-0.0.1.tar.gz",
            "has_sig": false,
            "md5_digest": "b3b49997f7365a8030cfa5b4860a2e0b",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.5, <4",
            "size": 6156,
            "upload_time": "2020-09-17T03:35:13",
            "upload_time_iso_8601": "2020-09-17T03:35:13.989215Z",
            "url": "https://files.pythonhosted.org/packages/b1/a1/439d610bcd353e4652a8583483b8b31943b6aad592e1c42d5e1ff5b91ff3/encounter-0.0.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2020-09-17 03:35:13",
    "github": false,
    "gitlab": false,
    "bitbucket": true,
    "bitbucket_user": null,
    "bitbucket_project": "j2-riseley",
    "lcname": "encounter"
}
        
Elapsed time: 0.13414s