Genesis genhernandez

## UnresponsiveVehiclesSettingsInvestigation.ipynb

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                genhernandez
                / UnresponsiveVehiclesSettingsInvestigation.ipynb
            
            
              Last active
              January 25, 2019 20:35
            
          
        Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
      
    
## output
select ST_AsTWKB(st_geomfromgeojson(geometry)) from directions where id='256953377';
st_astwkb
--------------------------
 \x050001039d014a00000000

 select geometry from directions where id='256953377';
  {"type":"MultiLineString","coordinates":[[[-79.15735,37.40816],[-79.15749,37.40829],[-79.15722,37.40847],[-79.1567,37.40796],[-79.15589,37.40704],[-79.15549,37.40658],[-79.15599,37.40609],[-79.15619,37.40589],[-79.15642,37.40562],[-79.15662,37.40541],[-79.15675,37.40528],[-79.15654,37.40531],[-79.1563,37.4053],[-79.15601,37.40526],[-79.15573,37.40517],[-79.1555,37.40505],[-79.1553,37.40487],[-79.15504,37.4046],[-79.15472,37.40421],[-79.15373,37.40309],[-79.15373,37.40309],[-79.15327,37.40257],[-79.15309,37.40237],[-79.15309,37.40237],[-79.15255,37.40176],[-79.15187,37.40214],[-79.15163,37.40228],[-79.15069,37.40277],[-79.14978,37.40328],[-79.1492,37.40263],[-79.14907,37.40249],[-79.1486,37.40274],[-79.14822,37.40295],[-79.14816,37.40299],[-79.14738,37.40344],[-79.14726,37.40351],[-79.14641,37.4039

## ST_GeomFromGeoJSON
0105000000010000000102000000FE010000A301BC0512CA53C087C43D963EB442409CDCEF5014CA53C055A4C2D842B44240BC9179E40FCA53C0D5B2B5BE48B4424020D26F5F07CA53C0C009850838B4424080F10C1AFAC953C0F91400E319B44240B936548CF3C953C0959A3DD00AB4424032207BBDFBC953C0C79DD2C1FAB34240957D5704FFC953C000E31934F4B342402E1C08C902CA53C0404D2D5BEBB342409279E40F06CA53C056BC9179E4B3424079E9263108CA53C087DC0C37E0B34240042159C004CA53C0F25EB532E1B342405917B7D100CA53C0CE88D2DEE0B3424055F65D11FCC953C04030478FDFB342406440F67AF7C953C000A94D9CDCB34240CBA145B6F3C953C0569FABADD8B342406744696FF0C953C0D690B8C7D2B342409964E42CECC953C016FBCBEEC9B342406002B7EEE6C953C0AB5B3D27BDB34240809A5AB6D6C953C01DACFF7398B34240809A5AB6D6C953C01DACFF7398B342404F5DF92CCFC953C0E42CEC6987B342400FD6FF39CCC953C01D7233DC80B342400FD6FF39CCC953C01D7233DC80B342404F401361C3C953C0A56B26DF6CB3424096CFF23CB8C953C0EC34D25279B34240EBC5504EB4C953C0DDEA39E97DB342406475ABE7A4C953C0ABE7A4F78DB342401366DAFE95C953C0C190D5AD9EB342400B24287E8CC953C0BA313D6189B3424024B4E55C8AC953C0C87BD5CA84B3

## geojson_in_directions_table.json
{"coordinates":[[[-79.15735,37.40816],[-79.15749,37.40829],[-79.15722,37.40847],[-79.1567,37.40796],[-79.15589,37.40704],[-79.15549,37.40658],[-79.15599,37.40609],[-79.15619,37.40589],[-79.15642,37.40562],[-79.15662,37.40541],[-79.15675,37.40528],[-79.15654,37.40531],[-79.1563,37.4053],[-79.15601,37.40526],[-79.15573,37.40517],[-79.1555,37.40505],[-79.1553,37.40487],[-79.15504,37.4046],[-79.15472,37.40421],[-79.15373,37.40309],[-79.15373,37.40309],[-79.15327,37.40257],[-79.15309,37.40237],[-79.15309,37.40237],[-79.15255,37.40176],[-79.15187,37.40214],[-79.15163,37.40228],[-79.15069,37.40277],[-79.14978,37.40328],[-79.1492,37.40263],[-79.14907,37.40249],[-79.1486,37.40274],[-79.14822,37.40295],[-79.14816,37.40299],[-79.14738,37.40344],[-79.14726,37.40351],[-79.14641,37.40399],[-79.14641,37.40399],[-79.14634,37.40402],[-79.14551,37.40448],[-79.14551,37.40449],[-79.14452,37.4051],[-79.14393,37.40544],[-79.14376,37.40553],[-79.14367,37.40555],[-79.14357,37.40553],[-79.14356,37.40551],[-79.14357,37.4052],[-79.1435
	select ST_AsTWKB(st_geomfromgeojson(geometry)) from directions where id='256953377';
	st_astwkb
	--------------------------
	\x050001039d014a00000000

	select geometry from directions where id='256953377';
	{"type":"MultiLineString","coordinates":[[[-79.15735,37.40816],[-79.15749,37.40829],[-79.15722,37.40847],[-79.1567,37.40796],[-79.15589,37.40704],[-79.15549,37.40658],[-79.15599,37.40609],[-79.15619,37.40589],[-79.15642,37.40562],[-79.15662,37.40541],[-79.15675,37.40528],[-79.15654,37.40531],[-79.1563,37.4053],[-79.15601,37.40526],[-79.15573,37.40517],[-79.1555,37.40505],[-79.1553,37.40487],[-79.15504,37.4046],[-79.15472,37.40421],[-79.15373,37.40309],[-79.15373,37.40309],[-79.15327,37.40257],[-79.15309,37.40237],[-79.15309,37.40237],[-79.15255,37.40176],[-79.15187,37.40214],[-79.15163,37.40228],[-79.15069,37.40277],[-79.14978,37.40328],[-79.1492,37.40263],[-79.14907,37.40249],[-79.1486,37.40274],[-79.14822,37.40295],[-79.14816,37.40299],[-79.14738,37.40344],[-79.14726,37.40351],[-79.14641,37.4039