semvec/pypi-packages huggingface dataset:
encounter 0.0.1
Tools for studying aircraft detection
Requires Python: >=3.5, <4
Keywords: sample,setuptools,development

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;
plutopy 0.0.1
WardenAllen's Library Package
Requires Python: >=3.6

# Example Package

This is a simple example package. You can use
[Github-flavored Markdown](https://guides.github.com/features/mastering-markdown/)
to write your content.

python setup.py sdist bdist_wheel
python -m twine upload dist/*

pip install --index-url https://test.pypi.org/simple/ --no-deps plutopy