text: INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (1,'Ballwin Court','636.227.9468','','http://www.ballwin.mo.us/Departments/Government-Departments/Municipal-Court/Municipal-Court/','iPayCourt','300 Park Drive','St. Louis','MO','63011','38.59729089','-90.54189364',-1,'LINK','http://www.stlouisco.com/LawandPublicSafety/MunicipalCourts/NoticeofRights','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (2,'Bella Villa Court','314.638.8840','','','IPG','751 Avenue H','St. Louis','MO','63125','38.54256229','-90.28909176',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (3,'Bellefontaine Neighbors Court','314.867.0076','','http://www.cityofbn.com/departments/court/','iPayCourt','9641 Bellefontaine Road','St. Louis','MO','63137','38.74151895','-90.22576437',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (4,'Normandy Court','314.385.3300','3014','','nCourt','7700 Natural Bridge Road','St. Louis','MO','63121','38.70629459','-90.30322952',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (5,'Bel-Nor Court','314.381.2834','','http://www.bel-nor.org/index.php/municipal-court','','8416 Natural Bridge Road','St. Louis','MO','63121','38.70896713','-90.31745003',-1,'LINK','http://www.bel-nor.org/index.php/municipal-court/category/7-municipal-court-procedures','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (6,'Bel-Ridge Court','314.429.2878','','http://bel-ridge.us/?page_id=90','Collector Solutions','8920 Natural Bridge Road','St. Louis','MO','63121','38.71566804','-90.32623591',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (7,'Berkeley Court','314.400.3700','','http://www.cityofberkeley.us/department/index.php?structureid=17','iPayCourt','8425 Airport Road','St. Louis','MO','63134','38.7504757','-90.3327254',-1,'LINK','http://209.43.125.150/topic/index.php?topicid=50&structureid=17','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (8,'Beverly Hills Court','314.382.6544','','','','7150 Natural Bridge Road','St. Louis','MO','63121','38.7009367','-90.29187735',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (9,'Black Jack Court','314.355-0400','102','http://www.cityofblackjack.com/241/Municipal-Court','iPayCourt','12500 Old Jamestown Road','St. Louis','MO','63033','38.7947506','-90.26261696',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (10,'Breckenridge Hills Court','314.427.1412','','','nCourt','9623 St. Charles Rock Road','St. Louis','MO','63114','38.71925635','-90.36600678',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (11,'Brentwood Court','314.963.8623','','http://www.brentwoodmo.org/index.aspx?nid=476','','2348 South Brentwood Boulevard','St. Louis','MO','63144','38.61842688','-90.34844504',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (12,'Bridgeton Court','314.739.1145','','http://www.bridgetonmo.com/departments/municipal-court','iPayCourt','12355 Natural Bridge Road','St. Louis','MO','63044','38.75626745','-90.42347742',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (13,'Calverton Park Court','314.524.1212','12','http://www.calvertonparkmo.com/village-court/','nCourt','52 Young Drive','St. Louis','MO','63135','38.7646557','-90.31692672',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (14,'Charlack Court','314.427.4715','','http://www.cityofcharlack.com/#!municipal-court/c1g4i','IPG','8401 Midland Boulevard','St. Louis','MO','63114','38.69634571','-90.33991661',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (15,'Chesterfield Court','636.537.4717','','http://www.chesterfield.mo.us/municipal-court.html','IPG','690 Chesterfield Parkway West','St. Louis','MO','63017','38.66190342','-90.56366971',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (16,'Clarkson Valley Court','636.227.8607','','http://www.clarksonvalley.org/traffic.html','iPayCourt','15933 Clayton Road','St. Louis','MO','63011','38.60490831','-90.58713047',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (17,'Clayton Court','314.290.8441','','http://www.claytonmo.gov/Government/Municipal_Court.htm?','iPayCourt','10 South Brentwood Boulevard','St. Louis','MO','63105','38.64984611','-90.34146558',-1,'PDF','Clayton_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (18,'Cool Valley Court','314.521.3500','','http://www.cityofcoolvalley.com/index.php/departments/municipal-court','IPG','100 Signal Drive','St. Louis','MO','63121','38.70770154','-90.30290904',-1,'PDF','Cool_Valley_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (19,'Country Club Hills Court','314.261.0845','4','','','7422 Eunice Avenue','St. Louis','MO','63136','38.71945332','-90.27428266',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (20,'Town and Country Court','314.587.2832','','http://www.town-and-country.org/150/Municipal-Court','IPG','1011 Municipal Center Drive','St. Louis','MO','63131','38.63201598','-90.45143593',-1,'PDF','Town_and_Country_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (21,'Crestwood Court','314.729.4776','','http://www.cityofcrestwood.org/department/index.php?structureid=19','iPayCourt','1 Detjen Drive','St. Louis','MO','63126','38.55936592','-90.38569543',-1,'PDF','Crestwood_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (22,'Creve Coeur Court','314.432.8844','','http://www.creve-coeur.org/index.aspx?nid=101','IPG','300 North New Ballas Road','St. Louis','MO','63141','38.66179036','-90.443226',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (23,'Frontenac Court','314.994.3204','','','IPG','10555 Clayton Road','St. Louis','MO','63131','38.63307777','-90.41216022',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (24,'Dellwood Court','314.521.4339','104','http://www.cityofdellwoodmo.com/563/Municipal-Court','nCourt','1415 Chambers Road','St. Louis','MO','63135','38.74944799','-90.28180026',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (25,'Des Peres Court','314.835.6119','','http://www.desperesmo.org/Index.aspx?NID=96','nCourt','12325 Manchester Road','St. Louis','MO','63131','38.60332431','-90.4419091',-1,'PDF','Des_Peres_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (26,'Edmundson Court','314.428.7125','117','http://www.cityofedmundson.com/index.php?option=com_content&view=article&id=7&Itemid=115','nCourt','4440 Holman Lane','St. Louis','MO','63134','38.73303513','-90.3638459',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (27,'Ellisville Court','636.227.3727','','http://www.ellisville.mo.us/165/Municipal-Court','','37 Weis Avenue','St. Louis','MO','63011','38.5928963','-90.59225362',-1,'PDF','Ellisville_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (28,'Eureka Court','636.938.6600','208','http://www.eureka.mo.us/departments/municipal-court/','iPayCourt','120 City Hall Drive','St. Louis','MO','63025','38.49536426','-90.62921936',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (29,'Fenton Court','636.343.1007','','http://fentonmo.org/index.aspx?nid=563','IPG','625 New Smizer Mill Road','St. Louis','MO','63026','38.51775109','-90.45204336',-1,'PDF','Fenton_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (30,'Ferguson Court','314.524.5354','','http://www.fergusoncity.com/60/The-City-Of-Ferguson-Municipal-court','IPG','110 Church Street','St. Louis','MO','63135','38.74499337','-90.30386823',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (31,'Flordell Hills Court','314.382.5524','','','','7001 Brandon Avenue','St. Louis','MO','63136','38.71705529','-90.26183924',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (32,'Florissant Court','314.921.3322','','http://www.florissantmo.com/department/index.php?structureid=19','iPayCourt','315 Howdershell Road','St. Louis','MO','63031','38.80713686','-90.3612334',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (33,'Glendale Court','314.965.0000','','http://www.glendalemo.org/index.php?option=com_content&view=article&id=11&Itemid=18','iPayCourt','424 North Sappington Road','St. Louis','MO','63122','38.58970992','-90.38647565',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (34,'Grantwood Village Court','314.842.4409','','','','1 Missionary Way','St. Louis','MO','63123','38.54861159','-90.34399783',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (35,'St. Louis County Municipal Court - South Division','314.615.8760','','http://www.stlouisco.com/LawandPublicSafety/Municipalcourt','Municipal Online Payments Tyler','4544 Lemay Ferry Road','St. Louis','MO','63129','38.49676468','-90.33667373',8,'PDF','Notice_of_Rights_7_1_17.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (36,'Hanley Hills Court','314.725.0909','','','iPayCourt','7713 Utica Drive','St. Louis','MO','63133','38.68316018','-90.32347577',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (37,'Hazelwood Court','314.839.2212','','http://www.hazelwoodmo.org/city-government/departments/court','iPayCourt','415 Elm Grove Lane','St. Louis','MO','63042','38.78499519','-90.3552467',-1,'PDF','Hazelwood_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (38,'Hillsdale Court','314.381.0288','','','','6428 Jesse Jackson Avenue','St. Louis','MO','63121','38.68527443','-90.28953233',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (39,'Jennings Court','314.385.4670','','http://www.cityofjennings.org/court.html','','7005 Florence Avenue','St. Louis','MO','63136','38.71028485','-90.2666946',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (40,'Kinloch Court','314.521.3335','','','','8140 Scott','St. Louis','MO','63140','38.73771069','-90.32253562',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (41,'Kirkwood Court','314.822.5840','','http://www.kirkwoodmo.org/content/City-Departments/2040/municipal-court.aspx','iPayCourt','139 S. Kirkwood Road','St. Louis','MO','63122','38.58022142','-90.40643518',-1,'PDF','Kirkwood_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (42,'Ladue Court','314.993.3919','','http://www.cityofladue-mo.gov/departments/municipal-court-196','iPayCourt','9435 Clayton Road','St. Louis','MO','63124','38.64080665','-90.3796107',-1,'PDF','Ladue_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (43,'Lakeshire Court','314.631.6222','6','http://www.lakeshiremo.com/court-procedures/','','10000 Puttington Drive','St. Louis','MO','63123','38.53679413','-90.33812054',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (44,'Shrewsbury Court','314.647.8634','','http://www.cityofshrewsbury.com/municipal-courts.htm','','4400 Shrewsbury Avenue','St. Louis','MO','63119','38.59351418','-90.32669611',-1,'PDF','Shrewsbury_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (45,'Manchester Court','636.227.1410','','http://www.manchestermo.gov/index.asp?SEC=0BE94A96-7F3E-4567-A282-BB5616082CA4&Type=B_BASIC','Municipal Online Payments Tyler','200 Highlands Blvd. Dr.','St. Louis','MO','63011','38.59520185','-90.5048459',-1,'PDF','Manchester_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (46,'Maplewood Court','314.646.3636','','http://www.cityofmaplewood.com/index.aspx?nid=66','iPayCourt','7601 Manchester Road','St. Louis','MO','63143','38.61291917','-90.32600283',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (48,'Maryland Heights Court','314.291.6036','','http://www.marylandheights.com/index.aspx?page=78','nCourt','11911 Dorsett Road','St. Louis','MO','63043','38.71455813','-90.43552075',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (49,'Moline Acres Court','314.868.2433','102/103','http://www.molineacres.org/court.aspx','nCourt','2449 Chambers Road','St. Louis','MO','63136','38.7511275','-90.24399078',-1,'PDF','Moline_Acres_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (50,'Northwoods Court','314.385.0260','','','nCourt','4600 Oakridge Boulevard','St. Louis','MO','63121','38.70600205','-90.28025478',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (51,'St. Louis County Municipal Court - North Division','314.615.7400','','http://www.stlouisco.com/LawandPublicSafety/Municipalcourt','Municipal Online Payments Tyler','715 Northwest Plaza Drive','St. Ann','MO','63074','38.733026','-90.4023659',8,'PDF','Notice_of_Rights_7_1_17.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (52,'Oakland Court','314.842.0778','','http://www.oaklandmo.org/municipal-court.aspx','','1320 W. Lockwood Avenue','St. Louis','MO','63122','38.58289279','-90.37908042',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (53,'Olivette Court','314.991.6047','','http://www.olivettemo.com/pView.aspx?id=2037&catid=29','iPayCourt','1140 Dielman Road','St. Louis','MO','63132','38.6759433','-90.3761334',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (54,'Overland Court','314.428.1224','','http://www.overlandmo.org/58/Overland-Municipal-Court','nCourt','2410 Goodale Avenue','St. Louis','MO','63114','38.7002179','-90.35906835',-1,'PDF','Overland_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (55,'Pacific Court','636.257.4553','','','iPayCourt','300 Hoven Drive','St. Louis','MO','63079','38.27440022','-91.1054967',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (56,'Pagedale Court','314.726.1200','','http://www.cityofpagedale.com/#!municipal-court/cme6','','1420 Ferguson Avenue','St. Louis','MO','63133','38.68204661','-90.30739183',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (57,'Pasadena Hills Court','314.382.4453','','','nCourt','3915 Roland Boulevard','St. Louis','MO','63121','38.7044589','-90.29349626',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (58,'Pasadena Park Court','314.385.4115','','','nCourt','7615 South Sunset','St. Louis','MO','63121','38.70988086','-90.29806144',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (59,'Pine Lawn Court','314.802.1043','','http://www.pinelawn.org/#!court/c78g','nCourt','6250 Steve Marve Avenue','St. Louis','MO','63121','38.69286188','-90.27816339',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (60,'Richmond Heights Court','314.645.1982','','http://www.richmondheights.org/departments/court/index.php','iPayCourt','7447 Dale Avenue','St. Louis','MO','63117','38.62792123','-90.3187518',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (61,'Riverview Court','314.868.0700','','http://www.riverviewmo.org/court.aspx','iPayCourt','9699 Lilac Drive','St. Louis','MO','63137','38.74009119','-90.21496583',-1,'PDF','Riverview_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (62,'Rock Hill Court','314.962.6265','','http://www.rockhillmo.net/court.aspx','iPayCourt','320 West Thornton Avenue','St. Louis','MO','63119','38.60546309','-90.3623925',-1,'PDF','Rock_Hill_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (63,'St. Ann Court','314.428.6811','6','http://www.stannmo.org/369/Municipal-Court','nCourt','10405 St. Charles Rock Road','St. Louis','MO','63074','38.72840568','-90.38262593',-1,'PDF','St_Ann_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (64,'St. John Court','314.427.8700','6','http://www.cityofstjohn.org/index.php/municipal-court.html','nCourt','8944 St. Charles Rock Road','St. Louis','MO','63114','38.71151496','-90.35188417',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (65,'Sunset Hills Court','314.849.3402','','http://www.sunset-hills.com/148/Municipal-Court','','3939 South Lindbergh','St. Louis','MO','63127','38.5453508','-90.40242404',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (66,'University City Court','314.505.8540','','http://www.ucitymo.org/index.aspx?nid=82','iPayCourt','975 Pennsylvania Avenue','St. Louis','MO','63130','38.6640235','-90.31591854',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (67,'Uplands Park Court','314.383.1856','','https://uplandsparkmissouri.wordpress.com/municipal-court/','nCourt','6390 Natural Bridge Road','St. Louis','MO','63121','38.69371954','-90.28107949',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (68,'Valley Park Court','636.225.5696','','','iPayCourt','320 Benton Street','St. Louis','MO','63088','38.55144034','-90.4874997',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (69,'Velda City Court','314.382.6600','','http://www.veldacity.org/departments/municipal-court','iPayCourt','2560 Lucas & Hunt Road','St. Louis','MO','63121','38.69258924','-90.29618745',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (70,'Velda Village Hills Court','314.261.7221','','','nCourt','3501 Avondale Avenue','St. Louis','MO','63121','38.69312888','-90.28588658',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (71,'Vinita Park Court','314.428.7373','','http://www.vinitapark.org/index.php/city-departments/court-information','nCourt','8374 Midland Boulevard','St. Louis','MO','63114','38.69556481','-90.33883384',-1,'PDF','Vinita_Park_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (73,'Warson Woods Court','314.965.3100','','http://www.warsonwoods.com/Templates/Warson%20Woods%20City%20Hall%203.5%20(Court%20Page).html','','10015 Manchester Road','St. Louis','MO','63122','38.60313788','-90.38556887',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (74,'Webster Groves Court','314.963.5416','','http://www.webstergroves.org/index.aspx?nid=239','IPG','4 Lockwood Aveue','St. Louis','MO','63119','38.58883088','-90.34656765',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (75,'Wellston Court','314.553.8002','','','nCourt','1414 Evergreen','St. Louis','MO','63133','38.67538348','-90.28923273',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (76,'Wildwood Court','636.458.8277','','http://www.cityofwildwood.com/135/Municipal-Court','IPG','16860 Main Street','St. Louis','MO','63040','38.58090325','-90.63089227',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (77,'Winchester Court','636.391.0600','','http://www.city.winchester.mo.us/Municipal-Court/','','109 Lindy Boulevard','St. Louis','MO','63021','38.592682','-90.52712599',-1,'PDF','','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (78,'Woodson Terrace Court','314.427.2600','','http://woodsonterrace.net/City-Clerk/Municipal-Court-Information-Online-Payment-Link/','iPayCourt','4323 Woodson Road','St. Louis','MO','63134','38.72808378','-90.35789852',-1,'PDF','Woodson_Terrace_Rights.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (79,'St. Louis County Municipal Court - Central Division','314.615.8760','','http://www.stlouisco.com/LawandPublicSafety/Municipalcourt','Municipal Online Payments Tyler','7900 Carondelet Avenue','St. Louis','MO','63105','38.64893351','-90.33859257',8,'PDF','Notice_of_Rights_7_1_17.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (80,'St. Louis County Municipal Court - West Division','314.615.8760','','http://www.stlouisco.com/LawandPublicSafety/Municipalcourt','Municipal Online Payments Tyler','82 Clarkson Wilson Centre','St. Louis','MO','63017','38.627512','-90.58024738',8,'PDF','Notice_of_Rights_7_1_17.pdf','America/Chicago');
  INSERT INTO court(court_id,court_name,phone,extension,website,payment_system,address,city,state,zip_code,latitude,longitude,citation_expires_after_days,rights_type,rights_value,zone_id) VALUES (81,'St. Louis City Municipal Court','314.622.3231','','http://www.stlcitycourt.org/frmHome.aspx','iPayCourt','1520 Market St.','St. Louis','MO','63103','38.627998','-90.203384',-1,'PDF','','America/Chicago');