Changes between Version 1 and Version 2 of UsersWikiExamplesInterpolateWithOffset

Timestamp:

Oct 26, 2009, 5:38:32 PM (15 years ago)

Author:

veggivore

Comment:

—

UsersWikiExamplesInterpolateWithOffset

@@ -6 +6 @@
 select 
 st_line_interpolate_point(te.the_geom, 
-        ((12710 - fromhn::float) / (tohn::float - fromhn::float)),
+        ((12345 - fromhn::float) / (tohn::float - fromhn::float)),
         case when side = 'R' then .0001 else -.0001 end
 ),
-'12710 3rd St, 92399'
+'A house'
 from tl_edges te
 join tl_addr ta on te.tlid = ta.tlid
-where fullname = '3rd St' and 12710 between fromhn::int and tohn::int and zip = '92399'
-and (12710 % 2) = (fromhn::int % 2)
+where fullname = 'Main St' and 12345 between fromhn::int and tohn::int and zip = '92333'
+and (12345 % 2) = (fromhn::int % 2)
 and fromhn::int < tohn::int;
 }}}