Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using cypher from Neo4j, how would I compute the bike 'id' that was used on the trip from station 1 Ave & E 18 St

Using cypher from Neo4j, how would I compute the bike 'id' that was used on the trip from station "1 Ave & E 18 St" to station "Riverside Dr & W 82 St".

A partial dataset is seen below:

image text in transcribed

birth_year trip_id 2 0 gender 1958 1967 1992 1952 2 1 1 2 2 3 1963 1 4 1980 1 5 1 6 start_time stop_time trip_duration start_station_id start_station_name start_station_start_station_stop_station_id stop_station_name stop_station_stop_statior bike_id user_type 01/05/2019 06:29 01/05/2019 06:57 1679 3697 W 64 St & Thelonio 40.77515953 -73.989187 327 Vesey Pl & River Terr. 40.7153379 -74.01658 33882 Subscriber 01/05/2019 06:34 01/05/2019 06:54 1184 3140 1 Ave & E 78 St 40.77140426 -73.9535166 3140 1 Ave & E 78 St 40.7714043 -73.95352 30766 Subscriber 01/05/2019 06:43 01/05/2019 06:46 184 3151 E 81 St & York Ave 40.7728384 -73.9498923 3140 1 Ave & E 78 St 40.7714043 -73.95352 34246 Subscriber 01/05/2019 06:53 01/05/2019 07:01 483 3169 Riverside Dr & W8 40.78720869 -73.9812813 3697 W 64 St & Thelonious 40.7751595 -73.98919 16250 Subscriber 01/05/2019 07:01 01/05/2019 07:02 81 2003 1 Ave & E 18 St 40.73381219 -73.9805442 2003 1 Ave & E 18 St 40.7338122 -73.98054 25149 Subscriber 01/05/2019 07:02 01/05/2019 07:13 681 327 Vesey Pl & River Te 40.7153379 -74.0165835 3472 W 15 St & 10 Ave 40.7427538 -74.00747 29186 Subscriber 01/05/2019 07:10 01/05/2019 07:18 481 410 Suffolk St & Stanto 40.72066442 -73.9851798 257 Lispenard St & Broad 40.7193923 -74.00247 32893 Subscriber 01/05/2019 07:15 01/05/2019 07:23 476 366 Clinton Ave & Myrt 40.693261 -73.968896 3440 Fulton St & Adams St 40.6924183 -73.98949 20168 Subscriber 01/05/2019 07:19 01/05/2019 07:30 624 515 W 43 St & 10 Ave 40.76009437 -73.9946184 522 E 51 St & Lexington A 40.7571476 -73.97208 26072 Subscriber 01/05/2019 07:27 01/05/2019 07:32 256 326 E 11 St & 1 Ave 40.72953837 -73.9842673 2003 1 Ave & E 18 St 40.7338122 -73.98054 21002 Subscriber 01/05/2019 07:31 01/05/2019 07:41 624 3140 1 Ave & E 78 St 40.77140426 -73.9535166 3132 E 59 St & Madison Av 40.7635053 -73.97109 20182 Subscriber 01/05/2019 07:36 01/05/2019 07:57 1264 410 Suffolk St & Stanto 40.72066442 -73.9851798 522 E 51 St & Lexington A 40.7571476 -73.97208 17231 Subscriber 01/05/2019 07:39 01/05/2019 07:41 123 3151 E 81 St & York Ave 40.7728384 -73.9498923 3151 E 81 St & York Ave 40.7728384 -73.94989 26349 Subscriber 01/05/2019 07:47 01/05/2019 07:58 629 346 Bank St & Hudson S 40.73652889 -74.0061803 327 Vesey Pl & River Terr: 40.7153379 -74.01658 30034 Subscriber 01/05/2019 07:50 01/05/2019 08:02 715 3140 1 Ave & E 78 St 40.77140426 -73.9535166 3132 E 59 St & Madison Av 40.7635053 -73.97109 35175 Subscriber 01/05/2019 07:52 01/05/2019 08:09 1032 545 E 23 St & 1 Ave 40.736502 -73.9780947 522 E 51 St & Lexington A 40.7571476 -73.97208 18909 Subscriber 2 7 8 2 1 9 1 10 1979 1988 1987 1967 1995 1994 1941 1994 1987 1982 1 11 1 12 1 13 2 14 1 15

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data And Databases

Authors: Jeff Mapua

1st Edition

1978502257, 978-1978502253

Students also viewed these Databases questions

Question

What is the difference between Needs and GAP Analyses?

Answered: 1 week ago

Question

What are ERP suites? Are HCMSs part of ERPs?

Answered: 1 week ago