Skip to content

Instantly share code, notes, and snippets.

@rvanbruggen
Last active August 29, 2015 14:02
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save rvanbruggen/738fda50eee8254874b8 to your computer and use it in GitHub Desktop.
Graph Local queries v2.cql
//the small dataset
create (_0:`OBSERVATION_LOCATION` {`latitude`:50.737160, `location_id`:1378, `longitude`:-3.405790, `name`:"EXETER AIRPORT", `postcode`:"EX5 2"}),
(_1:`OBSERVATION_LOCATION` {`latitude`:50.736540, `location_id`:57263, `longitude`:-3.532200, `name`:"EXETER UNIVERSITY", `postcode`:"EX4 4"}),
(_2:`OBSERVATION_LOCATION` {`latitude`:58.453700, `location_id`:32, `longitude`:-3.089960, `name`:"WICK AIRPORT", `postcode`:"KW1 4"}),
(_3:`OBSERVATION_LOCATION` {`latitude`:58.287710, `location_id`:44, `longitude`:-4.442370, `name`:"ALTNAHARRA NO 2", `postcode`:"IV27 4"}),
(_4:`OBSERVATION_LOCATION` {`latitude`:57.612760, `location_id`:66, `longitude`:-5.306250, `name`:"KINLOCHEWE", `postcode`:"IV22 2"}),
(_5:`OBSERVATION_LOCATION` {`latitude`:56.866560, `location_id`:105, `longitude`:-4.707970, `name`:"TULLOCH BRIDGE", `postcode`:"PH31 4"}),
(_6:`OBSERVATION_LOCATION` {`latitude`:57.711260, `location_id`:137, `longitude`:-3.323350, `name`:"LOSSIEMOUTH", `postcode`:"IV31 6"}),
(_7:`OBSERVATION_LOCATION` {`latitude`:55.601060, `location_id`:1013, `longitude`:-4.226120, `name`:"SAUGHALL", `postcode`:"KA17 0"}),
(_8:`OBSERVATION_LOCATION` {`latitude`:54.742890, `location_id`:13343, `longitude`:-4.958560, `name`:"LOGAN BOTANIC GARDEN", `postcode`:"DG9 9"}),
(_9:`OBSERVATION_LOCATION` {`latitude`:55.234250, `location_id`:56937, `longitude`:-6.512530, `name`:"GIANTS CAUSEWAY", `postcode`:"BT57 8"}),
(_10:`EQUIPMENT` {`id`:1}),
(_11:`EQUIPMENT` {`id`:2}),
(_12:`EQUIPMENT` {`id`:3}),
(_13:`EQUIPMENT` {`id`:4}),
(_14:`EQUIPMENT` {`id`:5}),
(_15:`EQUIPMENT` {`id`:6}),
(_16:`EQUIPMENT` {`id`:7}),
(_17:`EQUIPMENT` {`id`:8}),
(_18:`EQUIPMENT` {`id`:9}),
(_19:`EQUIPMENT` {`id`:10}),
(_20:`EQUIPMENT` {`id`:11}),
(_21:`EQUIPMENT` {`id`:12}),
(_22:`EQUIPMENT` {`id`:13}),
(_23:`EQUIPMENT` {`id`:14}),
(_24:`EQUIPMENT` {`id`:15}),
(_25:`EQUIPMENT` {`id`:16}),
(_26:`EQUIPMENT` {`id`:17}),
(_27:`EQUIPMENT` {`id`:18}),
(_28:`EQUIPMENT` {`id`:19}),
(_29:`EQUIPMENT` {`id`:20}),
(_30:`EQUIPMENT` {`id`:21}),
(_31:`EQUIPMENT` {`id`:22}),
(_32:`EQUIPMENT` {`id`:23}),
(_33:`EQUIPMENT` {`id`:24}),
(_34:`EQUIPMENT` {`id`:25}),
(_35:`EQUIPMENT` {`id`:26}),
(_36:`EQUIPMENT` {`id`:27}),
(_37:`EQUIPMENT` {`id`:28}),
(_38:`EQUIPMENT` {`id`:29}),
(_39:`EQUIPMENT` {`id`:30}),
(_40:`EQUIPMENT` {`id`:31}),
(_41:`EQUIPMENT` {`id`:32}),
(_42:`EQUIPMENT` {`id`:33}),
(_43:`EQUIPMENT` {`id`:34}),
(_44:`EQUIPMENT` {`id`:35}),
(_45:`EQUIPMENT` {`id`:36}),
(_46:`EQUIPMENT` {`id`:37}),
(_47:`EQUIPMENT` {`id`:38}),
(_48:`EQUIPMENT` {`id`:39}),
(_49:`EQUIPMENT_TYPE` {`name`:"RAIN: SPLAY-BASE 127MM - MK2"}),
(_50:`EQUIPMENT_TYPE` {`name`:"RAIN: TBR MET MK5 - 0.2MM TIP"}),
(_51:`EQUIPMENT_TYPE` {`name`:"TEMP: ERT - MK4"}),
(_52:`EQUIPMENT_TYPE` {`name`:"WIND: CUP ANEMOMETER - VECTOR MK6"}),
(_53:`EQUIPMENT_TYPE` {`name`:"WIND: ELECTRICAL ANEMOGRAPH"}),
(_54:`EQUIPMENT_TYPE` {`name`:"WIND: WEC STANDARD HEIGHT"}),
(_55:`EQUIPMENT_TYPE` {`name`:"WIND: WIND VANE - MK4"}),
(_56:`EQUIPMENT_TYPE` {`name`:"RAIN: 127MM GAUGE"}),
(_57:`EQUIPMENT_TYPE` {`name`:"TEMP: L-I-G (MERCURY) MAXIMUM THERMOMETER"}),
(_58:`EQUIPMENT_TYPE` {`name`:"WIND: CLIMBABLE STANDARD HEIGHT"}),
(_59:`EQUIPMENT_TYPE` {`name`:"RAIN: TBR MUNRO - 0.2MM TIP"}),
(_60:`EQUIPMENT_TYPE` {`name`:"RAIN: STAINLESS STEEL DAILY RAINGAUGE"}),
(_61:`EQUIPMENT_TYPE` {`name`:"TEMP: L-I-G MINIMUM THERMOMETER"}),
(_62:`EQUIPMENT_TYPE` {`name`:"WIND: CUP ANEMOMETER - MUNRO MK4"}),
(_63:`EQUIPMENT_TYPE` {`name`:"RAIN: STAINLESS STEEL MONTHLY RAINGAUGE"}),
(_64:`EQUIPMENT_TYPE` {`name`:"RAIN: TBR - ENVIRONMENTAL MEASUREMENTS"}),
(_65:`EQUIPMENT_TYPE` {`name`:"RAIN: TBR - 0.2MM TIP"}),
(_66:`EQUIPMENT_TYPE` {`name`:"TEMP: THERMISTOR"}),
(_67:`OBSERVATION_TYPE` {`name`:"RAIN1"}),
(_68:`OBSERVATION_TYPE` {`name`:"RAIN2"}),
(_69:`OBSERVATION_TYPE` {`name`:"TEMP"}),
(_70:`OBSERVATION_TYPE` {`name`:"WIND1"}),
(_71:`OBSERVATION_TYPE` {`name`:"WIND2"}),
(_72:`OBSERVATION_TYPE` {`name`:"WIND3"}),
(_73:`OBSERVATION_TYPE` {`name`:"WIND4"}),
(_74:`OBSERVATION_TYPE` {`name`:"RAIN"}),
(_75:`OBSERVATION_TYPE` {`name`:"WIND"}),
(_76:`OBSERVATION_TYPE` {`name`:"TEMP1"}),
(_77:`OBSERVATION_TYPE` {`name`:"TEMP2"}),
(_78:`OBSERVATION_TYPE` {`name`:"RAIN3"}),
(_79:`OBSERVATION_TYPE` {`name`:"RAIN4"}),
(_80:`OBSERVATION_TYPE` {`name`:"RAIN5"}),
(_81:`OBSERVATION` {`amount`:0.200000, `date`:41604.416670, `id`:1001}),
(_82:`OBSERVATION` {`amount`:0.400000, `date`:41605.125000, `id`:1002}),
(_83:`OBSERVATION` {`amount`:8, `date`:41604.041670, `id`:1003}),
(_84:`OBSERVATION` {`amount`:6, `date`:41604.083330, `id`:1004}),
(_85:`OBSERVATION` {`amount`:11, `date`:41604.291670, `id`:1005}),
(_86:`OBSERVATION` {`amount`:14, `date`:41604.166670, `id`:1006}),
(_87:`OBSERVATION` {`amount`:9, `date`:41604.291670, `id`:1007}),
(_88:`OBSERVATION` {`amount`:5.400000, `date`:41598.375000, `id`:1008}),
(_89:`OBSERVATION` {`amount`:4.300000, `date`:41600.375000, `id`:1009}),
(_90:`OBSERVATION` {`amount`:0.800000, `date`:41601.375000, `id`:1010}),
(_91:`OBSERVATION` {`amount`:0.400000, `date`:41605.041670, `id`:1011}),
(_92:`OBSERVATION` {`amount`:0.800000, `date`:41605.083330, `id`:1012}),
(_93:`OBSERVATION` {`amount`:0.400000, `date`:41606.375000, `id`:1013}),
(_94:`OBSERVATION` {`amount`:9, `date`:41604.041670, `id`:1014}),
(_95:`OBSERVATION` {`amount`:9, `date`:41604.041670, `id`:1015}),
(_96:`OBSERVATION` {`amount`:12, `date`:41604.083330, `id`:1016}),
(_97:`OBSERVATION` {`amount`:5.700000, `date`:41598.375000, `id`:1017}),
(_98:`OBSERVATION` {`amount`:1.200000, `date`:41605.375000, `id`:1018}),
(_99:`OBSERVATION` {`amount`:3.400000, `date`:41603.375000, `id`:1019}),
(_100:`OBSERVATION` {`amount`:8.500000, `date`:41606.375000, `id`:1020}),
(_101:`OBSERVATION` {`amount`:0.200000, `date`:41604.416670, `id`:1021}),
(_102:`OBSERVATION` {`amount`:0.200000, `date`:41605.083330, `id`:1022}),
(_103:`OBSERVATION` {`amount`:1, `date`:41604.041670, `id`:1023}),
(_104:`OBSERVATION` {`amount`:3, `date`:41604.291670, `id`:1024}),
(_105:`OBSERVATION` {`amount`:2, `date`:41604.333330, `id`:1025}),
(_106:`OBSERVATION` {`amount`:4, `date`:41604.500000, `id`:1026}),
(_107:`OBSERVATION` {`amount`:5, `date`:41604.208330, `id`:1027}),
(_108:`OBSERVATION` {`amount`:6, `date`:41604.291670, `id`:1028}),
(_109:`OBSERVATION` {`amount`:6, `date`:41605.166670, `id`:1029}),
(_110:`OBSERVATION` {`amount`:1.900000, `date`:41603.375000, `id`:1030}),
(_111:`OBSERVATION` {`amount`:7.800000, `date`:41606.375000, `id`:1031}),
(_112:`OBSERVATION` {`amount`:0.200000, `date`:41602.083330, `id`:1032}),
(_113:`OBSERVATION` {`amount`:1.200000, `date`:41604.375000, `id`:1033}),
(_114:`OBSERVATION` {`amount`:0.600000, `date`:41604.458330, `id`:1034}),
(_115:`OBSERVATION` {`amount`:0.200000, `date`:41605.208330, `id`:1035}),
(_116:`OBSERVATION` {`amount`:19, `date`:41604.125000, `id`:1036}),
(_117:`OBSERVATION` {`amount`:12, `date`:41604.375000, `id`:1037}),
(_118:`OBSERVATION` {`amount`:0.200000, `date`:41604.500000, `id`:1038}),
(_119:`OBSERVATION` {`amount`:0.200000, `date`:41604.041670, `id`:1039}),
(_120:`OBSERVATION` {`amount`:0.200000, `date`:41605.083330, `id`:1040}),
(_121:`OBSERVATION` {`amount`:0.200000, `date`:41601.416670, `id`:1041}),
(_122:`OBSERVATION` {`amount`:0.200000, `date`:41605.375000, `id`:1042}),
(_123:`OBSERVATION` {`amount`:4.400000, `date`:41600.375000, `id`:1043}),
(_124:`OBSERVATION` {`amount`:2.700000, `date`:41602.375000, `id`:1044}),
(_125:`OBSERVATION` {`amount`:0.200000, `date`:41601.375000, `id`:1045}),
(_126:`OBSERVATION` {`amount`:0.200000, `date`:41605.375000, `id`:1046}),
(_127:`OBSERVATION` {`amount`:0.800000, `date`:41601.375000, `id`:1047}),
(_128:`OBSERVATION` {`amount`:0.200000, `date`:41602.125000, `id`:1048}),
(_129:`OBSERVATION` {`amount`:0.600000, `date`:41602.166670, `id`:1049}),
(_130:`OBSERVATION` {`amount`:0.600000, `date`:41605.375000, `id`:1050}),
(_131:`OBSERVATION` {`amount`:8.500000, `date`:41601.375000, `id`:1051}),
(_132:`INSPECTION` {`id`:10001, `inspection_date`:39723, `review_date`:41184}),
(_133:`INSPECTION` {`id`:10002, `inspection_date`:39729, `review_date`:40634}),
(_134:`INSPECTION` {`id`:10003, `inspection_date`:40296, `review_date`:40661}),
(_135:`INSPECTION` {`id`:10004, `inspection_date`:40344, `review_date`:40709}),
(_136:`INSPECTION` {`id`:10005, `inspection_date`:40487, `review_date`:40852}),
(_137:`INSPECTION` {`id`:10006, `inspection_date`:40648, `review_date`:41744}),
(_138:`INSPECTION` {`id`:10007, `inspection_date`:40696, `review_date`:41062}),
(_139:`INSPECTION` {`id`:10008, `inspection_date`:40710, `review_date`:41076}),
(_140:`INSPECTION` {`id`:10009, `inspection_date`:40742, `review_date`:41108}),
(_141:`INSPECTION` {`id`:10010, `inspection_date`:40794, `review_date`:41160}),
(_142:`INSPECTION` {`id`:10011, `inspection_date`:40975, `review_date`:41340}),
(_143:`INSPECTION` {`id`:10012, `inspection_date`:41151, `review_date`:42246}),
(_144:`INSPECTION` {`id`:10013, `inspection_date`:41485, `review_date`:41850}),
(_145:`INSPECTION` {`id`:10014, `inspection_date`:41505, `review_date`:42601}),
(_146:`INSPECTION` {`id`:10015, `inspection_date`:41527, `review_date`:41892}),
(_147:`INSPECTION` {`id`:10016, `inspection_date`:41550, `review_date`:41915}),
_10-[:`LOCATED_AT`]->_2,
_10-[:`IS_OF_TYPE`]->_49,
_10-[:`USED_FOR`]->_67,
_11-[:`LOCATED_AT`]->_2,
_11-[:`IS_OF_TYPE`]->_50,
_11-[:`USED_FOR`]->_68,
_12-[:`LOCATED_AT`]->_2,
_12-[:`IS_OF_TYPE`]->_51,
_12-[:`USED_FOR`]->_69,
_13-[:`LOCATED_AT`]->_2,
_13-[:`IS_OF_TYPE`]->_52,
_13-[:`USED_FOR`]->_70,
_14-[:`LOCATED_AT`]->_2,
_14-[:`IS_OF_TYPE`]->_53,
_14-[:`USED_FOR`]->_71,
_15-[:`LOCATED_AT`]->_2,
_15-[:`IS_OF_TYPE`]->_54,
_15-[:`USED_FOR`]->_72,
_16-[:`LOCATED_AT`]->_2,
_16-[:`IS_OF_TYPE`]->_55,
_16-[:`USED_FOR`]->_73,
_17-[:`LOCATED_AT`]->_3,
_17-[:`IS_OF_TYPE`]->_56,
_17-[:`USED_FOR`]->_74,
_18-[:`LOCATED_AT`]->_3,
_18-[:`IS_OF_TYPE`]->_57,
_18-[:`USED_FOR`]->_69,
_19-[:`LOCATED_AT`]->_3,
_19-[:`IS_OF_TYPE`]->_58,
_19-[:`USED_FOR`]->_75,
_20-[:`LOCATED_AT`]->_4,
_20-[:`IS_OF_TYPE`]->_49,
_20-[:`USED_FOR`]->_67,
_21-[:`LOCATED_AT`]->_4,
_21-[:`IS_OF_TYPE`]->_59,
_21-[:`USED_FOR`]->_68,
_22-[:`LOCATED_AT`]->_4,
_22-[:`IS_OF_TYPE`]->_51,
_22-[:`USED_FOR`]->_76,
_23-[:`LOCATED_AT`]->_4,
_23-[:`IS_OF_TYPE`]->_57,
_23-[:`USED_FOR`]->_77,
_24-[:`LOCATED_AT`]->_5,
_24-[:`IS_OF_TYPE`]->_49,
_24-[:`USED_FOR`]->_67,
_25-[:`LOCATED_AT`]->_5,
_25-[:`IS_OF_TYPE`]->_60,
_25-[:`USED_FOR`]->_68,
_26-[:`LOCATED_AT`]->_5,
_26-[:`IS_OF_TYPE`]->_51,
_26-[:`USED_FOR`]->_76,
_27-[:`LOCATED_AT`]->_5,
_27-[:`IS_OF_TYPE`]->_61,
_27-[:`USED_FOR`]->_77,
_28-[:`LOCATED_AT`]->_5,
_28-[:`IS_OF_TYPE`]->_62,
_28-[:`USED_FOR`]->_75,
_29-[:`LOCATED_AT`]->_6,
_29-[:`IS_OF_TYPE`]->_49,
_29-[:`USED_FOR`]->_74,
_30-[:`LOCATED_AT`]->_6,
_30-[:`IS_OF_TYPE`]->_51,
_30-[:`USED_FOR`]->_76,
_31-[:`LOCATED_AT`]->_6,
_31-[:`IS_OF_TYPE`]->_57,
_31-[:`USED_FOR`]->_77,
_32-[:`LOCATED_AT`]->_6,
_32-[:`IS_OF_TYPE`]->_58,
_32-[:`USED_FOR`]->_70,
_33-[:`LOCATED_AT`]->_6,
_33-[:`IS_OF_TYPE`]->_62,
_33-[:`USED_FOR`]->_71,
_34-[:`LOCATED_AT`]->_7,
_34-[:`IS_OF_TYPE`]->_49,
_34-[:`USED_FOR`]->_67,
_35-[:`LOCATED_AT`]->_7,
_35-[:`IS_OF_TYPE`]->_63,
_35-[:`USED_FOR`]->_68,
_36-[:`LOCATED_AT`]->_7,
_36-[:`IS_OF_TYPE`]->_64,
_36-[:`USED_FOR`]->_78,
_37-[:`LOCATED_AT`]->_7,
_37-[:`IS_OF_TYPE`]->_64,
_37-[:`USED_FOR`]->_79,
_38-[:`LOCATED_AT`]->_7,
_38-[:`IS_OF_TYPE`]->_59,
_38-[:`USED_FOR`]->_80,
_39-[:`LOCATED_AT`]->_7,
_39-[:`IS_OF_TYPE`]->_51,
_39-[:`USED_FOR`]->_69,
_40-[:`LOCATED_AT`]->_0,
_40-[:`IS_OF_TYPE`]->_56,
_40-[:`USED_FOR`]->_67,
_41-[:`LOCATED_AT`]->_0,
_41-[:`IS_OF_TYPE`]->_65,
_41-[:`USED_FOR`]->_68,
_42-[:`LOCATED_AT`]->_0,
_42-[:`IS_OF_TYPE`]->_51,
_42-[:`USED_FOR`]->_69,
_43-[:`LOCATED_AT`]->_0,
_43-[:`IS_OF_TYPE`]->_52,
_43-[:`USED_FOR`]->_75,
_44-[:`LOCATED_AT`]->_8,
_44-[:`IS_OF_TYPE`]->_49,
_44-[:`USED_FOR`]->_74,
_45-[:`LOCATED_AT`]->_8,
_45-[:`IS_OF_TYPE`]->_51,
_45-[:`USED_FOR`]->_69,
_46-[:`LOCATED_AT`]->_9,
_46-[:`IS_OF_TYPE`]->_59,
_46-[:`USED_FOR`]->_74,
_47-[:`LOCATED_AT`]->_9,
_47-[:`IS_OF_TYPE`]->_51,
_47-[:`USED_FOR`]->_76,
_48-[:`LOCATED_AT`]->_9,
_48-[:`IS_OF_TYPE`]->_66,
_48-[:`USED_FOR`]->_77,
_81-[:`IS_OF_TYPE`]->_67,
_81-[:`OBSERVED_AT_LOCATION`]->_2,
_82-[:`IS_OF_TYPE`]->_67,
_82-[:`OBSERVED_AT_LOCATION`]->_2,
_83-[:`IS_OF_TYPE`]->_70,
_83-[:`OBSERVED_AT_LOCATION`]->_2,
_84-[:`IS_OF_TYPE`]->_70,
_84-[:`OBSERVED_AT_LOCATION`]->_2,
_85-[:`IS_OF_TYPE`]->_71,
_85-[:`OBSERVED_AT_LOCATION`]->_2,
_86-[:`IS_OF_TYPE`]->_71,
_86-[:`OBSERVED_AT_LOCATION`]->_2,
_87-[:`IS_OF_TYPE`]->_73,
_87-[:`OBSERVED_AT_LOCATION`]->_2,
_88-[:`IS_OF_TYPE`]->_69,
_88-[:`OBSERVED_AT_LOCATION`]->_2,
_89-[:`IS_OF_TYPE`]->_69,
_89-[:`OBSERVED_AT_LOCATION`]->_2,
_90-[:`IS_OF_TYPE`]->_74,
_90-[:`OBSERVED_AT_LOCATION`]->_3,
_91-[:`IS_OF_TYPE`]->_74,
_91-[:`OBSERVED_AT_LOCATION`]->_3,
_92-[:`IS_OF_TYPE`]->_74,
_92-[:`OBSERVED_AT_LOCATION`]->_3,
_93-[:`IS_OF_TYPE`]->_74,
_93-[:`OBSERVED_AT_LOCATION`]->_3,
_94-[:`IS_OF_TYPE`]->_75,
_94-[:`OBSERVED_AT_LOCATION`]->_3,
_95-[:`IS_OF_TYPE`]->_75,
_95-[:`OBSERVED_AT_LOCATION`]->_3,
_96-[:`IS_OF_TYPE`]->_75,
_96-[:`OBSERVED_AT_LOCATION`]->_3,
_97-[:`IS_OF_TYPE`]->_69,
_97-[:`OBSERVED_AT_LOCATION`]->_3,
_98-[:`IS_OF_TYPE`]->_67,
_98-[:`OBSERVED_AT_LOCATION`]->_4,
_99-[:`IS_OF_TYPE`]->_76,
_99-[:`OBSERVED_AT_LOCATION`]->_4,
_100-[:`IS_OF_TYPE`]->_77,
_100-[:`OBSERVED_AT_LOCATION`]->_4,
_101-[:`IS_OF_TYPE`]->_67,
_101-[:`OBSERVED_AT_LOCATION`]->_5,
_102-[:`IS_OF_TYPE`]->_68,
_102-[:`OBSERVED_AT_LOCATION`]->_5,
_103-[:`IS_OF_TYPE`]->_75,
_103-[:`OBSERVED_AT_LOCATION`]->_5,
_104-[:`IS_OF_TYPE`]->_75,
_104-[:`OBSERVED_AT_LOCATION`]->_5,
_105-[:`IS_OF_TYPE`]->_75,
_105-[:`OBSERVED_AT_LOCATION`]->_5,
_106-[:`IS_OF_TYPE`]->_75,
_106-[:`OBSERVED_AT_LOCATION`]->_5,
_107-[:`IS_OF_TYPE`]->_75,
_107-[:`OBSERVED_AT_LOCATION`]->_5,
_108-[:`IS_OF_TYPE`]->_75,
_108-[:`OBSERVED_AT_LOCATION`]->_5,
_109-[:`IS_OF_TYPE`]->_75,
_109-[:`OBSERVED_AT_LOCATION`]->_5,
_110-[:`IS_OF_TYPE`]->_77,
_110-[:`OBSERVED_AT_LOCATION`]->_5,
_111-[:`IS_OF_TYPE`]->_77,
_111-[:`OBSERVED_AT_LOCATION`]->_5,
_112-[:`IS_OF_TYPE`]->_74,
_112-[:`OBSERVED_AT_LOCATION`]->_6,
_113-[:`IS_OF_TYPE`]->_74,
_113-[:`OBSERVED_AT_LOCATION`]->_6,
_114-[:`IS_OF_TYPE`]->_74,
_114-[:`OBSERVED_AT_LOCATION`]->_6,
_115-[:`IS_OF_TYPE`]->_74,
_115-[:`OBSERVED_AT_LOCATION`]->_6,
_116-[:`IS_OF_TYPE`]->_70,
_116-[:`OBSERVED_AT_LOCATION`]->_6,
_117-[:`IS_OF_TYPE`]->_76,
_117-[:`OBSERVED_AT_LOCATION`]->_6,
_118-[:`IS_OF_TYPE`]->_67,
_118-[:`OBSERVED_AT_LOCATION`]->_7,
_119-[:`IS_OF_TYPE`]->_68,
_119-[:`OBSERVED_AT_LOCATION`]->_7,
_120-[:`IS_OF_TYPE`]->_78,
_120-[:`OBSERVED_AT_LOCATION`]->_7,
_121-[:`IS_OF_TYPE`]->_79,
_121-[:`OBSERVED_AT_LOCATION`]->_7,
_122-[:`IS_OF_TYPE`]->_79,
_122-[:`OBSERVED_AT_LOCATION`]->_7,
_123-[:`IS_OF_TYPE`]->_69,
_123-[:`OBSERVED_AT_LOCATION`]->_7,
_124-[:`IS_OF_TYPE`]->_69,
_124-[:`OBSERVED_AT_LOCATION`]->_7,
_125-[:`IS_OF_TYPE`]->_67,
_125-[:`OBSERVED_AT_LOCATION`]->_0,
_126-[:`IS_OF_TYPE`]->_74,
_126-[:`OBSERVED_AT_LOCATION`]->_8,
_127-[:`IS_OF_TYPE`]->_74,
_127-[:`OBSERVED_AT_LOCATION`]->_9,
_128-[:`IS_OF_TYPE`]->_74,
_128-[:`OBSERVED_AT_LOCATION`]->_9,
_129-[:`IS_OF_TYPE`]->_74,
_129-[:`OBSERVED_AT_LOCATION`]->_9,
_130-[:`IS_OF_TYPE`]->_74,
_130-[:`OBSERVED_AT_LOCATION`]->_9,
_131-[:`IS_OF_TYPE`]->_77,
_131-[:`OBSERVED_AT_LOCATION`]->_9,
_132-[:`EXECUTED_AT`]->_8,
_133-[:`EXECUTED_AT`]->_7,
_134-[:`EXECUTED_AT`]->_3,
_135-[:`EXECUTED_AT`]->_2,
_136-[:`EXECUTED_AT`]->_4,
_137-[:`EXECUTED_AT`]->_7,
_138-[:`EXECUTED_AT`]->_3,
_139-[:`EXECUTED_AT`]->_2,
_140-[:`EXECUTED_AT`]->_5,
_141-[:`EXECUTED_AT`]->_9,
_142-[:`EXECUTED_AT`]->_0,
_143-[:`EXECUTED_AT`]->_9,
_144-[:`EXECUTED_AT`]->_4,
_145-[:`EXECUTED_AT`]->_8,
_146-[:`EXECUTED_AT`]->_5,
_147-[:`EXECUTED_AT`]->_0
//make sure the index is there
create index on :OBSERVATION(id)
//let's add more observation data
using periodic commit 10000
match (o:OBSERVATION)-[r:IS_OF_TYPE]->(ot:OBSERVATION_TYPE),
(o)-[s:OBSERVED_AT_LOCATION]->(ol:OBSERVATION_LOCATION)
with range(1,10000) as RANGE,o,r,ot,s,ol
foreach (ran in RANGE | create (ot)<-[:IS_OF_TYPE]-(newobservation:OBSERVATION:DEMO {id: ran+1000000, date: round(rand()*100)+41000 , amount: round(rand())+1 })-[:OBSERVED_AT_LOCATION]->(ol) );
//look for the EQUIPMENT_TYPE of certain OBSERVATIONs
match
(eqt:EQUIPMENT_TYPE)<-[:IS_OF_TYPE]-(eq:EQUIPMENT)-[:LOCATED_AT]->(ol:OBSERVATION_LOCATION)<-[:OBSERVED_AT_LOCATION]-(o:OBSERVATION {id:1001})return eqt.name, ol.name, o.id;
//suggested more complex query
match
(eqt:EQUIPMENT_TYPE)<-[:IS_OF_TYPE]-(eq:EQUIPMENT)-[:LOCATED_AT]->(ol:OBSERVATION_LOCATION)<-[:OBSERVED_AT_LOCATION]-(o:OBSERVATION {id:1001}),
(eq)-[:USED_FOR]->(ot:OBSERVATION_TYPE)<-[:IS_OF_TYPE]-(o)
return eqt.name, ol.name, o.id;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment