Last active
August 29, 2015 14:02
-
-
Save rvanbruggen/738fda50eee8254874b8 to your computer and use it in GitHub Desktop.
Graph Local queries v2.cql
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
//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