Quick Start Guide
Get started with Kinetica Developer Edition
Get started with Kinetica Developer Edition
To install the Kinetica Developer Edition. Copy and paste the following command into your terminal. Note, the Developer Edition requires Docker to be pre-installed and running.
Note that you will need to give Docker enough RAM to run smoothly. We recommend 8GB or higher.
|
|
From the command prompt (Press WIN + r, then type cmd and press Enter)
|
|
You can use the kinetica script to manage your installation, start, and stop the database. To see a full list of commands, run ./kinetica --help on Linux/Mac, or .\kinetica --help on Windows.
For this guide, we'll use several files with geospatial data in them. The nyct2010.csv file provides geospatial boundaries for neighborhoods in New York. The taxi_data_historical.parquet file provides a list of taxi pickups and dropoffs in New York.
Navigate to GAdmin > Query > SQL and run the following code.
|
|
|
|
|
|
|
|
What are the shortest, average, and longest trip lengths for each vendor?
|
|
|
|
Joining the NTA table and the taxi data using the STXY_Intersects function, you can group by neighborhood boundary to determine the total number of trips to the neighborhood and average fare for a trip from JFK to that neighborhood.
|
|
|
|
You can use neighborhood boundary data and pickup time to calculate in which NTA vendors were picking up passengers at night and display the results in a pivot table containing columns of percentages for all vendors and each individual vendor.
|
|
|
|
Using the STXY_Intersects function to determine which pickup points were located in the JFK International Airport neighborhood boundary, it’s simple to calculate the number of pickups per hour there were at JFK for all cab types.
|
|
|
|
Kinetica’s main visualization tools are Reveal and the Web Mapping Service (WMS). For our purposes, let's use the WMS feature.
Kinetica’s web map service renders geospatial images that are overlaid on map tools like Mapbox, OpenLayers, and Esri. Simply point your basemap provider to our /wms endpoint with your desired rendering parameters, and Kinetica will generate geospatial imagery on demand. Every pan and zoom will render a new image of your data, so you can visualize streaming updates in real time.
Say you own a small business or restaurant in Chelsea that relies on nearby foot traffic for new customers. You can easily visualize the density of taxi drop offs nearby with the help of the GEODIST function.
|
|
We used this query to create a table so the results can be seen on a map. To output the dropoff points to a map, we’ll use the WMS functionality of GAdmin. Let’s validate this query.
Next to the store_front_dropoffs table, click Map. The output is a map showing the dropoff points within 150 meters of your storefront.
Congratulations, you have successfully completed the Quick Start Guide! But, you have only just begun your journey with Kinetica. To learn more about in depth usage, check out these articles: