`db/seed_segments.sql`

32 lines
-- Seed corridor_segments with the Ventura Blvd centerline polyline
-- (same 27 anchor points used by the HERE/Foursquare ingest, west→east).
TRUNCATE corridor_segments RESTART IDENTITY;

INSERT INTO corridor_segments (ord, city, west_lat, west_lng, east_lat, east_lng) VALUES
( 1, 'Calabasas',       34.1466, -118.6086, 34.1505, -118.6005),
( 2, 'Calabasas',       34.1505, -118.6005, 34.1530, -118.5915),
( 3, 'Woodland Hills',  34.1530, -118.5915, 34.1545, -118.5810),
( 4, 'Woodland Hills',  34.1545, -118.5810, 34.1556, -118.5705),
( 5, 'Woodland Hills',  34.1556, -118.5705, 34.1563, -118.5605),
( 6, 'Woodland Hills',  34.1563, -118.5605, 34.1568, -118.5500),
( 7, 'Woodland Hills',  34.1568, -118.5500, 34.1572, -118.5400),
( 8, 'Woodland Hills',  34.1572, -118.5400, 34.1575, -118.5305),
( 9, 'Tarzana',         34.1575, -118.5305, 34.1577, -118.5210),
(10, 'Tarzana',         34.1577, -118.5210, 34.1580, -118.5115),
(11, 'Tarzana',         34.1580, -118.5115, 34.1583, -118.5025),
(12, 'Encino',          34.1583, -118.5025, 34.1586, -118.4930),
(13, 'Encino',          34.1586, -118.4930, 34.1590, -118.4835),
(14, 'Encino',          34.1590, -118.4835, 34.1593, -118.4740),
(15, 'Encino',          34.1593, -118.4740, 34.1597, -118.4645),
(16, 'Encino',          34.1597, -118.4645, 34.1600, -118.4550),
(17, 'Sherman Oaks',    34.1600, -118.4550, 34.1604, -118.4455),
(18, 'Sherman Oaks',    34.1604, -118.4455, 34.1606, -118.4360),
(19, 'Sherman Oaks',    34.1606, -118.4360, 34.1599, -118.4270),
(20, 'Sherman Oaks',    34.1599, -118.4270, 34.1565, -118.4200),
(21, 'Sherman Oaks',    34.1565, -118.4200, 34.1505, -118.4140),
(22, 'Studio City',     34.1505, -118.4140, 34.1450, -118.4070),
(23, 'Studio City',     34.1450, -118.4070, 34.1421, -118.3985),
(24, 'Studio City',     34.1421, -118.3985, 34.1402, -118.3895),
(25, 'Studio City',     34.1402, -118.3895, 34.1385, -118.3820),
(26, 'Studio City',     34.1385, -118.3820, 34.1370, -118.3760);