Skip to content

GitLab

Closed
Created by 金小龙@xiaolong.jinDeveloper

添加公司地址表、辖区范围表

-- 创建表
CREATE TABLE changning.`company_address` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `company_id` int(11) NOT NULL DEFAULT '0' COMMENT '公司id',
  `company_address` varchar(255) NOT NULL DEFAULT '' COMMENT '公司地址',
  `point` point NOT NULL COMMENT '经纬度',
  `create_time` INT NOT NULL DEFAULT 0 COMMENT '创建时间',
  `last_update` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE changning.`company_area` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `area_name` varchar(20) NOT NULL DEFAULT '' COMMENT '辖区名称',
  `company_num` int(11) NOT NULL DEFAULT '0' COMMENT '辖区公司数量',
  `polygon` polygon NOT NULL COMMENT '辖区范围',
  `area_fchar` varchar(5) NOT NULL DEFAULT '' COMMENT '区域首字母',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS changning.company_loan (
  id int(11) NOT NULL AUTO_INCREMENT,
  company_name text NOT NULL COMMENT '公司名称',
  loan_amount float NOT NULL COMMENT '贷款金额',
  arrears float NOT NULL COMMENT '逾期金额',
  date_index int(11) NOT NULL COMMENT '贷款时间',
  create_time int(11) NOT NULL DEFAULT '0',
  last_update timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='公司贷款，逾款相关';
CREATE TABLE `domain_unusual_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0' COMMENT '公司id',
  `did` int(11) NOT NULL DEFAULT '0' COMMENT '网站id',
  `create_time` int(11) NOT NULL DEFAULT '0' COMMENT '创建时间',
  `last_udpate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 修改表
ALTER TABLE changning.company_search DROP street;
ALTER TABLE changning.company_search CHANGE street_id area_id INT(11) NOT NULL DEFAULT '0' COMMENT '辖区id';
ALTER TABLE changning.company_search ADD website_count INT NOT NULL DEFAULT 0 COMMENT '可访问的网站数量' AFTER companies;
ALTER TABLE changning.company_search ADD early_warning_count INT NOT NULL DEFAULT 0 COMMENT '预警数量' AFTER companies;
ALTER TABLE changning.company_search ALTER COLUMN title SET DEFAULT '';
ALTER TABLE changning.company_search ALTER COLUMN company_digest SET DEFAULT '';
ALTER TABLE changning.company_search ALTER COLUMN fchar SET DEFAULT '';
ALTER TABLE changning.company_search ALTER COLUMN reg_money SET DEFAULT 0;
ALTER TABLE changning.company_search ALTER COLUMN pv SET DEFAULT 0;
ALTER TABLE changning.company_search ALTER COLUMN uv SET DEFAULT 0;
ALTER TABLE changning.company_search MODIFY industry VARCHAR(255) DEFAULT '' COMMENT '国民经济行业门类';
ALTER TABLE changning.company_search MODIFY remark VARCHAR(255) DEFAULT '' COMMENT '备注';
ALTER TABLE changning.company_search MODIFY companies VARCHAR(255) DEFAULT '' COMMENT '企业类型';

-- 添加初始记录
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('程家桥街道', 510, 0x00000000010300000001000000710000002C6519E258575E40DCBDDC2747313F408997A77345575E40FD14C78157333F409C8A54185B575E40CF49EF1B5F333F4017105A0F5F575E408E7747C66A333F4072DD94F25A575E40E7E44526E0333F404E4700378B575E4080D4264EEE333F404FCC7A3194575E407CB94F8E02343F40664E97C5C4575E40CEC29E76F8333F403FABCC94D6575E40024BAE62F1333F40CA198A3BDE575E40BABBCE86FC333F4059F78F85E8575E4005C4245CC8333F40AF5B04C6FA575E407098689082333F405BCD3AE3FB575E40FB03E5B67D333F4099F5622827585E400F9C33A2B4333F404419AA622A585E4070EF1AF4A5333F4019E42EC214585E403753211E89333F402310AFEB17585E407A7077D66E333F409A266C3F19585E40F1D4230D6E333F40AA436E861B585E40CA8CB7955E333F400EBBEF181E585E406DFDF49F35333F400BD1217024585E4021205F4205333F408656276728585E40179AEB34D2323F405CCCCF0D4D585E403F390A1005333F4006BCCCB051585E405036E50AEF323F40FF21FDF675585E400DAA0D4E44333F40BDE47FF277585E40419AB1683A333F40FEEDB25F77585E406840BD1935333F40AB93331477585E406283859334333F4071CCB22781585E4027DD96C805333F40CE52B29C84585E40C632FD12F1323F4035D1E7A38C585E40D68D7747C6323F401DC9E53FA4585E40F14A92E7FA323F40EAEC647094585E4040321D3A3D333F40768C2B2E8E585E40F44D9A0645333F40AC1BEF8E8C585E40D464C6DB4A333F403CF6B3588A585E40BDE47FF277333F40FEF0F3DF83585E4063B6645584333F405401F73C7F585E4032384A5E9D333F4020D1048A58585E408E40BCAE5F343F404A7EC4AF58585E40D0B4C4CA68343F404A7EC4AF58585E40D0B4C4CA68343F40DF18028063585E4034F3E49A02353F400306499F56585E40DAFE959526353F401E1B81785D585E40F4C29D0B23353F4057B439CE6D585E40FDD98F1491353F407BF8325184585E40B9C3263273353F4063B9A5D590585E40DF516342CC353F40B79BE09BA6585E40282CF180B2353F400B7BDAE1AF585E4060C8EA56CF353F40C991CEC0C8585E40CBF3E0EEAC353F40A5A14621C9585E40C636A968AC353F4033FAD170CA585E40A243E048A0353F406EC0E78711595E405DDDB1D826353F40A6D425E318595E40F52A323A20353F404F90D8EE1E595E405B423EE8D9343F4071C79BFC16595E408350DEC7D1343F4051F52B9D0F595E40787FBC57AD343F40986A662D05595E40965E9B8D95343F40F33D23111A595E4091F3FE3F4E343F40412C9B3924595E40BD1C76DF31343F40B05417F032595E40FC17080264343F4060048D9944595E40AA0EB9196E343F408445459C4E595E40D367075C57343F403370404B57595E4016DC0F7860343F40FCE07CEA58595E409BCB0D863A343F40FCE07CEA58595E400B0BEE073C343F40C6866EF607595E4050FF59F3E3333F40C3F4BD86E0585E405DF92CCF83333F40917C259012595E403DB665C059323F40849A215514595E4086ADD9CA4B323F40F2B5679604595E401B2B31CF4A323F4078EDD286C3585E4094A0BFD023323F40F5F411F8C3585E406BF0BE2A17323F400795B88E71585E40CAA8328CBB313F407FBDC282FB575E40A9DE1AD82A313F403997E2AAB2575E40CE5147C7D5303F406092CA1473575E404033880FEC303F40F2CEA10C55575E40A9DE1AD82A313F4071581AF851575E408BFCFA2136303F40E0D5726726575E402D228AC91B303F401558005306575E404644317903303F40A3AD4A22FB565E40103CBEBD6B303F4044A2D0B2EE565E408B53AD8559303F4064575A46EA565E4094BC3AC780303F40D505BCCCB0565E4066BE839F38303F40A437DC476E565E40AFCDC64ACC2F3F4053E751F17F565E40CE33F6251B2F3F40BC96900F7A565E40751DAA29C92E3F401AFB928D07565E40064A0A2C802D3F402CD32F116F555E40E50B5A48C0303F40BF2CEDD45C555E409E978A8D79313F40CB0EF10F5B555E4094128255F5363F40CA8CB7955E555E406FBDA60705393F40E59B6D6E4C565E402920ED7F80393F40BBF1EEC858565E4026732CEFAA373F40BBF1EEC858565E4026732CEFAA373F4084622B685A565E408C834BC79C373F401E3526C45C565E400DFAD2DB9F373F409886E12362565E4097AAB4C535363F406C770FD07D565E40068200193A363F406AC18BBE82565E40AF06280D35363F4022C7D63384565E408C82E0F1ED353F4053927538BA565E40DD408177F2353F4014B01D8CD8565E4072C5C551B9353F40B8AE9811DE565E406AA0F99CBB353F4010786000E1565E406DAAEE91CD353F40E02D90A0F8565E40C7D8092FC1353F40BC3D0801F9565E409D6340F67A333F40BC3D0801F9565E40894160E5D0323F40BBB7223141575E40ACE122F774313F40D5CF9B8A54575E401E32E54350313F402C6519E258575E40DCBDDC2747313F402C6519E258575E40DCBDDC2747313F40, 'c', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('天山路街道', 380, 0x0000000001030000000100000035000000FD4FFEEE1D5B5E4008AC1C5A64373F40161406651A5B5E40ABCC94D6DF363F404C6F7F2E1A5B5E409370218FE0363F4044FCC3961E5B5E404AEF1B5F7B363F40CF6A813D265B5E405740A19E3E363F40BD19355F255B5E4005E09F5225363F402BC0779B375B5E40C901BB9A3C353F407E1AF7E6375B5E404D486B0C3A353F40693A3B191C5B5E407BBC900E0F353F4035ED629AE95A5E40DB166536C8343F40A60F5D50DF5A5E407364E597C1343F40D712F241CF5A5E40FD82DDB06D353F404CA4349BC75A5E406CE9D1544F363F4017EFC7ED975A5E40C11BD2A8C0353F408D800A47905A5E4098C28366D7353F40C87BD5CA845A5E40FB592C45F2353F40B70DA320785A5E4095490D6D00363F40016DAB59675A5E404DBA2D910B363F40B96C74CE4F5A5E408656276728363F40F564FED1375A5E400C3F389F3A363F407C444C89245A5E40CD3CB9A640363F409DF3531C075A5E403FC7478B33363F406798DA52075A5E409BFF571D39363F4099BB96900F5A5E40F243A51133373F40FB7953910A5A5E405A9D9CA1B8373F4069520ABABD595E40BC40498105383F405801BEDBBC595E40577BD80B05383F40D386C3D2C0595E4076AA7CCF48383F409529E620E8595E40C287122D79383F4072C119FCFD595E40E15F048D99383F4034BF9A03045A5E403B8E1F2A8D383F4008E412471E5A5E409067976F7D383F405E488787305A5E40FC34EECD6F383F40E31934F44F5A5E404F04711E4E383F405D6BEF53555A5E408A3BDEE4B7383F4078D49810735A5E4065A6B4FE96383F40DA1D520C905A5E40C03C64CA87383F40FDD98F14915A5E40E15F048D99383F4044520B25935A5E40B3EBDE8AC4383F40944A7842AF5A5E40A4FFE55AB4383F401E37FC6EBA5A5E4015E126A3CA383F408484285FD05A5E40645DDC4603383F404E29AF95D05A5E40E17EC00303383F4081CEA44DD55A5E401822A7AFE7373F405C902DCBD75A5E4017299485AF373F40CD3AE3FBE25A5E407461A417B5373F40E4141DC9E55A5E405FB87361A4373F40AC0320EEEA5A5E407E39B35DA1373F405A2E1B9DF35A5E4040D9942BBC373F40D93F4F03065B5E4031ED9BFBAB373F40DC4603780B5B5E40A7E9B303AE373F40C7F484251E5B5E404089CF9D60373F40FD4FFEEE1D5B5E4008AC1C5A64373F40, 't', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('虹桥街道', 211, 0x0000000001030000000100000041000000705B5B785E5B5E40B1FB8EE1B1333F401AF7E6374C5B5E4017D522A298343F40363D2828455B5E40ACA92C0ABB343F40D1747632385B5E40488B338639353F407E1AF7E6375B5E404D486B0C3A353F40693A3B191C5B5E407BBC900E0F353F4035ED629AE95A5E40DB166536C8343F40A60F5D50DF5A5E407364E597C1343F40D712F241CF5A5E40FD82DDB06D353F404CA4349BC75A5E406CE9D1544F363F4017EFC7ED975A5E40C11BD2A8C0353F408D800A47905A5E4098C28366D7353F40C87BD5CA845A5E40FB592C45F2353F40B70DA320785A5E4095490D6D00363F40016DAB59675A5E404DBA2D910B363F40B96C74CE4F5A5E408656276728363F40F564FED1375A5E400C3F389F3A363F407C444C89245A5E40CD3CB9A640363F409DF3531C075A5E403FC7478B33363F406798DA52075A5E40AA49F08634363F40AC8BDB68005A5E401D5BCF108E353F40F568AA27F3595E40374F75C8CD343F400F27309DD6595E402D776682E1343F4026E1421EC1595E400EF62686E4343F400F7F4DD6A8595E40A12FBDFDB9343F404F3BFC3559595E4070D05E7D3C343F40FCE07CEA58595E400B0BEE073C343F40C6866EF607595E4050FF59F3E3333F40C3F4BD86E0585E405DF92CCF83333F40917C259012595E403DB665C059323F409D2ADF3312595E40AEF545425B323F4016FA60191B595E40AEF545425B323F40DE3994A12A595E400A2E56D460323F40C34A051555595E40B9C667B27F323F40C520B07268595E4066BD18CA89323F400B992B836A595E40DFC325C79D323F40F33CB83B6B595E40952A51F696323F40E8305F5E80595E404776A565A4323F403B38D89B185A5E40446CB07092323F4092CD55F31C5A5E4022E17B7F83323F404147AB5AD25A5E400056478E74323F408EB0A888D35A5E401B82E3326E323F4049BDA772DA5A5E40F5DBD78173323F4048E00F3FFF5A5E4012F5824F73323F40EE940ED6FF5A5E4017670C7382323F407497C459115B5E4036E84B6F7F323F401FBB0B94145B5E40D5EB1681B1323F40E23AC615175B5E402997C62FBC323F40FA9CBB5D2F5B5E40C1E44691B5323F400113B875375B5E404BE82E89B3323F407235B22B2D5B5E4022382EE3A6323F40FB1EF5D72B5B5E40F9872D3D9A323F404703780B245B5E401EC6A4BF97323F4077A1B94E235B5E405A84622B68323F40C0266BD4435B5E40F78E1A1362323F40BABA63B14D5B5E4040C05AB56B323F40B54E5C8E575B5E401C2444F982323F40ADDBA0F65B5B5E4017670C7382323F4065FED137695B5E4051A5660FB4323F4033DE567A6D5B5E40A9C29FE1CD323F40145D177E705B5E40B69DB64604333F40C97553CA6B5B5E4062BD512B4C333F40B80721205F5B5E40AB3E575BB1333F40705B5B785E5B5E40B1FB8EE1B1333F40705B5B785E5B5E40B1FB8EE1B1333F40, 'h', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('仙霞新村街道', 16, 0x00000000010300000001000000410000006798DA52075A5E409BFF571D39363F4099BB96900F5A5E40F243A51133373F40FB7953910A5A5E405A9D9CA1B8373F4069520ABABD595E40BC40498105383F40CF4BC5C6BC595E4051BEA08504383F409FAF592E1B595E40639CBF0985383F403FA7203F1B595E40EB3713D385383F409CA8A5B915595E40BFD4CF9B8A383F4001A260C614595E4099D711876C383F4045BB0A293F595E400261A75835383F40027E8D2441595E40C8B3CBB73E383F40001C7BF65C595E4056D28A6F28383F4031B77BB94F595E40AAF3A8F8BF373F4048C5FF1D51595E40C974E8F4BC373F406CB587BD50595E401004C8D0B1373F40D76B7A5050595E406B9A779CA2373F40D89FC4E74E595E40AB048BC399373F4027BF45274B595E40F850A2258F373F403657CD7344595E4045F46BEBA7373F40DD0BCC0A45595E40240B98C0AD373F408DEC4ACB48595E4019CBF44BC4373F4011E50B5A48595E4096ECD808C4373F40DB8651103C595E404F5DF92CCF373F405F28603B18595E40CC7EDDE9CE373F406BD619DF17595E40BBF083F3A9373F40C6A6954220595E40CFF753E3A5373F404AD3A0681E595E40A54E401361373F40438EAD6708595E400744882B67373F401137A79201595E4016F88A6EBD363F4047C66AF3FF585E40C5FF1D51A1363F40E6046D72F8585E40E5EFDE5163363F40CA6ABA9EE8585E405951836918363F4042B5C189E8585E4064CBF27519363F4042B5C189E8585E40CF4D9B711A363F400C23BDA8DD585E40FF5C34643C363F40D40E7F4DD6585E40AB5AD2510E363F402769FE98D6585E40E3FDB8FDF2353F4071CB4752D2585E40079ACFB9DB353F40FC36C478CD585E40BE688F17D2353F406F46CD57C9585E40D8D5E429AB353F401CEC4D0CC9585E40D8D5E429AB353F40A5A14621C9585E40C636A968AC353F4033FAD170CA585E40A243E048A0353F406EC0E78711595E405DDDB1D826353F40A6D425E318595E40F52A323A20353F404F90D8EE1E595E405B423EE8D9343F4071C79BFC16595E408350DEC7D1343F4051F52B9D0F595E40787FBC57AD343F40986A662D05595E40965E9B8D95343F40F33D23111A595E4091F3FE3F4E343F40412C9B3924595E40BD1C76DF31343F40B05417F032595E40FC17080264343F4060048D9944595E40AA0EB9196E343F408445459C4E595E40D367075C57343F403370404B57595E4016DC0F7860343F40FCE07CEA58595E409BCB0D863A343F404F3BFC3559595E4070D05E7D3C343F400F7F4DD6A8595E40A12FBDFDB9343F4026E1421EC1595E400EF62686E4343F400F27309DD6595E402D776682E1343F40F568AA27F3595E40374F75C8CD343F40AC8BDB68005A5E401D5BCF108E353F406798DA52075A5E40AA49F08634363F406798DA52075A5E409BFF571D39363F406798DA52075A5E409BFF571D39363F40, 'x', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('新泾镇', 86, 0x00000000010300000001000000D6000000DEFFC70913565E403C6BB75D683E3F40C1374D9F1D565E405B43A9BD883E3F40E29178793A565E40994A3FE1EC3E3F40F86EF3C649565E4075AE2825043F3F407214200A66565E40B82231410D3F3F40E4BED53A71565E401E335019FF3E3F405950189469565E4039471D1D573F3F40AA285E656D565E4005BF0D315E3F3F40B29B19FD68565E40878C47A9843F3F40DDCD531D72565E40BE86E0B88C3F3F4054C4E9245B565E405A68E7340B403F40E23C9CC074565E4078978BF84E403F404014CC9882565E408176871403403F408200193A76565E40C9570229B13F3F400D6FD6E07D565E4044183F8D7B3F3F40FA9B508880565E40AF433525593F3F4074417DCB9C565E40AF433525593F3F401283C0CAA1565E4011397D3D5F3F3F404628B682A6565E400CCC0A45BA3F3F4006A1BC8FA3565E40821FD5B0DF3F3F406CCEC133A1565E40E886A6ECF43F3F40AAD381ACA7565E40F7729F1C05403F40158DB5BFB3565E40E8DD585018403F407EC4AF58C3565E404AD3A0681E403F40F06E6589CE565E402BFBAE08FE3F3F4094A12AA6D2565E40F81BEDB8E13F3F408EB0A888D3565E40FCDF1115AA3F3F406403E962D3565E40670B08AD873F3F40A48AE255D6565E402497FF907E3F3F40E98024ECDB565E40AE9AE7887C3F3F40E98024ECDB565E40ED9C6681763F3F40DE205A2BDA565E40F1B73D41623F3F4084D558C2DA565E40E2CB4411523F3F40EF71A609DB565E40BED87BF1453F3F40B3EE1F0BD1565E4070EA03C93B3F3F4041446ADAC5565E401A6F2BBD363F3F400E9F7422C1565E4006685BCD3A3F3F400A302C7FBE565E405264ADA1D43E3F4097A8DE1AD8565E406A865451BC3E3F40EC8A19E1ED565E40E59D4319AA3E3F40FB761211FE565E40D13FC1C58A3E3F40A12B11A8FE565E405B43A9BD883E3F40FE80070610575E40A27BD6355A3E3F404F7633A31F575E4064744012F63D3F40647616BD53575E40A4FFE55AB43C3F4014268C6665575E404BE9995E623C3F40FF58880E81575E406DE525FF933B3F40261C7A8B87575E404E0D349F733B3F409544F64196575E4023BBD232523B3F409544F64196575E408E3D7B2E533B3F407E3672DD94575E4023BBD232523B3F405E64027E8D575E40508D976E123B3F40A5DC7D8E8F575E40596C938AC63A3F401A6EC0E787575E405F29CB10C73A3F40D00B772E8C575E40F1129CFA403A3F40CE893DB48F575E40DD0BCC0A453A3F40295AB91798575E40F1129CFA403A3F404034F3E49A575E40AE9E93DE373A3F40FB3DB14E95575E4015014EEFE2393F4037397CD289575E406C7C26FBE7393F40E3DEFC8689575E40B1C22D1F49393F407E3672DD94575E4023BBD232523B3F405E64027E8D575E40508D976E123B3F40A5DC7D8E8F575E40596C938AC63A3F401A6EC0E787575E405F29CB10C73A3F40D00B772E8C575E40F1129CFA403A3F40CE893DB48F575E40DD0BCC0A453A3F40295AB91798575E40F1129CFA403A3F404034F3E49A575E40AE9E93DE373A3F40FB3DB14E95575E4015014EEFE2393F4037397CD289575E406C7C26FBE7393F40E3DEFC8689575E40B1C22D1F49393F4043E38920CE585E40D49D279EB3393F405B423EE8D9585E403E20D099B4393F4093567C43E1585E40AF5FB01BB6393F40CA6ABA9EE8585E40B41CE8A1B6393F401F4AB4E4F1585E401F9F909DB7393F40D46531B1F9585E40C823B891B2393F4052F2EA1C03595E4091291F82AA393F40BBD1C77C40595E40287E8CB96B393F401D93C5FD47595E406C3D433866393F401D93C5FD47595E406C3D433866393F4070ED444948595E40D7BFEB3367393F404BAC8C463E595E40EB6F09C03F393F40A8FE412443595E4084BD892139393F40A5F78DAF3D595E400E130D52F0383F40CD1FD3DA34595E40043BFE0B04393F409CFC169D2C595E403621AD31E8383F4074D190F128595E407381CB63CD383F402CD49AE61D595E402CF2EB87D8383F40D9791B9B1D595E40C68A1A4CC3383F40C99063EB19595E408CA37213B5383F408C101E6D1C595E40A5677A89B1383F406954E0641B595E405DDF878384383F4016FA60191B595E40D3DB9F8B86383F403FA7203F1B595E40EB3713D385383F409CA8A5B915595E40BFD4CF9B8A383F4001A260C614595E4099D711876C383F4045BB0A293F595E400261A75835383F40027E8D2441595E40C8B3CBB73E383F40001C7BF65C595E4056D28A6F28383F4031B77BB94F595E40AAF3A8F8BF373F4048C5FF1D51595E40C974E8F4BC373F406CB587BD50595E401004C8D0B1373F40D76B7A5050595E406B9A779CA2373F40D89FC4E74E595E40AB048BC399373F4027BF45274B595E40F850A2258F373F403657CD7344595E4045F46BEBA7373F40DD0BCC0A45595E40240B98C0AD373F408DEC4ACB48595E4019CBF44BC4373F4011E50B5A48595E4096ECD808C4373F40DB8651103C595E404F5DF92CCF373F405F28603B18595E40CC7EDDE9CE373F406BD619DF17595E40BBF083F3A9373F40C6A6954220595E40CFF753E3A5373F404AD3A0681E595E40A54E401361373F40438EAD6708595E400744882B67373F401137A79201595E4016F88A6EBD363F4047C66AF3FF585E40C5FF1D51A1363F40E6046D72F8585E40E5EFDE5163363F40CA6ABA9EE8585E405951836918363F4042B5C189E8585E4064CBF27519363F4042B5C189E8585E40CF4D9B711A363F400C23BDA8DD585E40FF5C34643C363F40D40E7F4DD6585E40AB5AD2510E363F402769FE98D6585E40E3FDB8FDF2353F4071CB4752D2585E40079ACFB9DB353F40FC36C478CD585E40BE688F17D2353F406F46CD57C9585E40D8D5E429AB353F401CEC4D0CC9585E40D8D5E429AB353F40C991CEC0C8585E40CBF3E0EEAC353F400B7BDAE1AF585E4060C8EA56CF353F40B79BE09BA6585E40282CF180B2353F4063B9A5D590585E40DF516342CC353F407BF8325184585E40B9C3263273353F4057B439CE6D585E40FDD98F1491353F401E1B81785D585E40F4C29D0B23353F400306499F56585E40DAFE959526353F40DF18028063585E4034F3E49A02353F404A7EC4AF58585E40D0B4C4CA68343F404A7EC4AF58585E40D0B4C4CA68343F4020D1048A58585E408E40BCAE5F343F405401F73C7F585E4032384A5E9D333F40FEF0F3DF83585E4063B6645584333F403CF6B3588A585E40BDE47FF277333F40AC1BEF8E8C585E40D464C6DB4A333F40768C2B2E8E585E40F44D9A0645333F40EAEC647094585E4040321D3A3D333F401DC9E53FA4585E40F14A92E7FA323F4035D1E7A38C585E40D68D7747C6323F40CE52B29C84585E40C632FD12F1323F4071CCB22781585E4027DD96C805333F40AB93331477585E406283859334333F40FEEDB25F77585E406840BD1935333F40BDE47FF277585E40419AB1683A333F40FF21FDF675585E400DAA0D4E44333F4006BCCCB051585E405036E50AEF323F405CCCCF0D4D585E403F390A1005333F408656276728585E40179AEB34D2323F400BD1217024585E4021205F4205333F400EBBEF181E585E406DFDF49F35333F40AA436E861B585E40CA8CB7955E333F409A266C3F19585E40F1D4230D6E333F402310AFEB17585E407A7077D66E333F4019E42EC214585E403753211E89333F404419AA622A585E4070EF1AF4A5333F4099F5622827585E400F9C33A2B4333F405BCD3AE3FB575E40FB03E5B67D333F40AF5B04C6FA575E407098689082333F4059F78F85E8575E4005C4245CC8333F40CA198A3BDE575E40BABBCE86FC333F403FABCC94D6575E40024BAE62F1333F40664E97C5C4575E40CEC29E76F8333F404FCC7A3194575E407CB94F8E02343F404E4700378B575E4080D4264EEE333F4072DD94F25A575E40E7E44526E0333F4017105A0F5F575E408E7747C66A333F409C8A54185B575E40CF49EF1B5F333F408997A77345575E40FD14C78157333F402C6519E258575E40DCBDDC2747313F40D5CF9B8A54575E401E32E54350313F40BBB7223141575E40ACE122F774313F40BC3D0801F9565E40894160E5D0323F40BC3D0801F9565E409D6340F67A333F40E02D90A0F8565E40C7D8092FC1353F4010786000E1565E406DAAEE91CD353F40B8AE9811DE565E406AA0F99CBB353F4014B01D8CD8565E4072C5C551B9353F4053927538BA565E40DD408177F2353F4022C7D63384565E408C82E0F1ED353F406AC18BBE82565E40AF06280D35363F406C770FD07D565E40068200193A363F409886E12362565E4097AAB4C535363F401E3526C45C565E400DFAD2DB9F373F4084622B685A565E408C834BC79C373F40D5CF9B8A54575E401E32E54350313F40BBB7223141575E40ACE122F774313F40BC3D0801F9565E40894160E5D0323F40BC3D0801F9565E409D6340F67A333F40E02D90A0F8565E40C7D8092FC1353F4010786000E1565E406DAAEE91CD353F40B8AE9811DE565E406AA0F99CBB353F4014B01D8CD8565E4072C5C551B9353F4053927538BA565E40DD408177F2353F4022C7D63384565E408C82E0F1ED353F406AC18BBE82565E40AF06280D35363F406C770FD07D565E40068200193A363F409886E12362565E4097AAB4C535363F401E3526C45C565E400DFAD2DB9F373F4084622B685A565E408C834BC79C373F40E675C4211B565E40D8B628B3413E3F40B55208E412565E40CD936B0A643E3F40DEFFC70913565E403C6BB75D683E3F40DEFFC70913565E403C6BB75D683E3F40, 'x', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('北新泾街道', 0, 0x0000000001030000000100000033000000A12B11A8FE565E405B43A9BD883E3F40FE80070610575E40A27BD6355A3E3F404F7633A31F575E4064744012F63D3F40647616BD53575E40A4FFE55AB43C3F4014268C6665575E404BE9995E623C3F40FF58880E81575E406DE525FF933B3F40261C7A8B87575E404E0D349F733B3F409544F64196575E4023BBD232523B3F409544F64196575E408E3D7B2E533B3F407E3672DD94575E4023BBD232523B3F405E64027E8D575E40508D976E123B3F40A5DC7D8E8F575E40596C938AC63A3F401A6EC0E787575E405F29CB10C73A3F40D00B772E8C575E40F1129CFA403A3F40CE893DB48F575E40DD0BCC0A453A3F40295AB91798575E40F1129CFA403A3F404034F3E49A575E40AE9E93DE373A3F40FB3DB14E95575E4015014EEFE2393F4037397CD289575E406C7C26FBE7393F40E3DEFC8689575E40B1C22D1F49393F407E3672DD94575E4023BBD232523B3F405E64027E8D575E40508D976E123B3F40A5DC7D8E8F575E40596C938AC63A3F401A6EC0E787575E405F29CB10C73A3F40D00B772E8C575E40F1129CFA403A3F40CE893DB48F575E40DD0BCC0A453A3F40295AB91798575E40F1129CFA403A3F404034F3E49A575E40AE9E93DE373A3F40FB3DB14E95575E4015014EEFE2393F4037397CD289575E406C7C26FBE7393F40E3DEFC8689575E40B1C22D1F49393F404F9143C4CD585E4039639813B4393F40E1455F419A585E408BC3995FCD393F40A4A5F27684585E40E99D0AB8E7393F402E8CF4A276585E40922232ACE2393F400150C58D5B585E401155F833BC393F40F6D214014E585E40F2D3B837BF393F405E82531F48585E40A629029CDE393F40F54A598638585E401E1840F8503A3F407DAF21382E585E401E6FF25B743A3F4074B4AA251D585E40054D4BAC8C3A3F407B82C476F7575E40153944DC9C3A3F40C6E1CCAFE6575E40F50EB743C33A3F4034828DEBDF575E40E8BD3104003B3F403B730F09DF575E40A5F78DAF3D3B3F405CAAD216D7575E40EFCA2E185C3B3F40DB1324B6BB575E40B0C8AF1F623B3F40E3E13D0796575E4017D9CEF7533B3F40DCF0BBE996575E40A0DCB6EF513B3F40A12B11A8FE565E405B43A9BD883E3F40A12B11A8FE565E405B43A9BD883E3F40, 'b', 1469548548, '2016-07-26 11:55:48');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('江苏路街道', 283, 0x000000000103000000010000002900000064CC5D4BC85B5E4045F64196053B3F40A5DB12B9E05B5E404ED53DB2B93A3F40C1A90F24EF5B5E408C852172FA3A3F409B030473F45B5E401AFB928D073B3F40C0CC77F0135C5E406C5B94D9203B3F40261DE560365C5E40BAF770C9713B3F402827DA55485C5E40CA3505323B3B3F406F9F55664A5C5E40397CD289043B3F4062BD512B4C5C5E4081B4FF01D63A3F40A0C211A4525C5E402D0B26FE283A3F40D5777E51825C5E402F14B01D8C383F4060E63BF8895C5E400C21E7FD7F383F406859F78F855C5E408BFCFA2136383F40F1BDBF417B5C5E4051BEA08504383F405F5E807D745C5E4069E04735EC373F40E94482A9665C5E40F48C7DC9C6373F40D2E5CDE15A5C5E40791EDC9DB5373F4013D21A834E5C5E40ADA6EB89AE373F40DD3F16A2435C5E40ADA6EB89AE373F40319A95ED435C5E4017299485AF373F40DD3F16A2435C5E4082AB3C81B0373F40D9B3E732355C5E4027BEDA519C373F402C0E677E355C5E40D099B4A9BA373F407EE02A4F205C5E40E82D1EDE73383F40B7D100DE025C5E400A86730D33383F40AAEFFCA2045C5E409F03CB1132383F400A2C8029035C5E4094895B0531383F40C32B499EEB5B5E405359147651383F409EEA909BE15B5E401557957D57383F401840F850A25B5E4001F9122A38383F40D2C77C40A05B5E4012859675FF383F40124F7633A35B5E402D42B11534393F408F56B5A4A35B5E40A530EF71A6393F4055151A88655B5E40CD3E8F519E393F4008AC1C5A645B5E406D8D08C6C1393F4049BBD1C77C5B5E403A5CAB3DEC393F40D0420246975B5E4050FEEE1D353A3F406D1FF296AB5B5E4033182312853A3F403A1F9E25C85B5E40CFF9298E033B3F4064CC5D4BC85B5E4045F64196053B3F4064CC5D4BC85B5E4045F64196053B3F40, 'j', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('新华路街道', 130, 0x0000000001030000000100000023000000B7D100DE025C5E400A86730D33383F407EE02A4F205C5E40E82D1EDE73383F402C0E677E355C5E40D099B4A9BA373F40D9B3E732355C5E4027BEDA519C373F40DD3F16A2435C5E4082AB3C81B0373F40319A95ED435C5E4017299485AF373F40319A95ED435C5E40126C5CFFAE373F4088635DDC465C5E4063D34A2190373F40381092054C5C5E40C32D1F4949373F404777103B535C5E407B4E7ADFF8363F4019E3C3EC655C5E4080F0A1444B363F4056664AEB6F5C5E408978EBFCDB353F40C1745AB7415C5E403F55850662353F403815A930B65B5E406EF9484A7A343F40992EC4EA8F5B5E40D6E07D552E343F408942CBBA7F5B5E400E2DB29DEF333F400D384BC9725B5E40B51666A19D333F40C4B5DAC35E5B5E40A6811FD5B0333F40C4B5DAC35E5B5E40A6811FD5B0333F40705B5B785E5B5E40B1FB8EE1B1333F401AF7E6374C5B5E4017D522A298343F40363D2828455B5E40ACA92C0ABB343F40D1747632385B5E40488B338639353F402BC0779B375B5E40C901BB9A3C353F40BD19355F255B5E4005E09F5225363F40CF6A813D265B5E405740A19E3E363F4044FCC3961E5B5E404AEF1B5F7B363F404C6F7F2E1A5B5E409370218FE0363F40CF6740BD195B5E40B8AE9811DE363F403B545392755B5E40B341261939373F40821C9430D35B5E40FD6B79E57A373F409D685721E55B5E40FCC22B499E373F4064778192025C5E4094895B0531383F40B7D100DE025C5E400A86730D33383F40B7D100DE025C5E400A86730D33383F40, 'x', 1469548549, '2016-07-26 11:55:49');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('周家桥街道', 94, 0x00000000010300000001000000410000003A92CB7F48595E404F24986A66393F40F33977BB5E595E4074620FED63393F4064E76D6C76595E40C520B07268393F408544DAC69F595E409D12109370393F40427BF5F1D0595E406F47382D78393F40AEBCE47FF2595E40B534B74258393F401F679AB0FD595E40CADDE7F868393F40DA73999A045A5E4029081EDFDE393F4055F99E91085A5E4048E00F3FFF393F40404CC2853C5A5E4024ED461FF3393F402810768A555A5E400F9BC8CC053A3F40C7F65AD07B5A5E40D74E9484443A3F400B0DC4B2995A5E406808C72C7B3A3F400342EBE1CB5A5E40F96A47718E3A3F403468E89FE05A5E40268DD13AAA3A3F403468E89FE05A5E40268DD13AAA3A3F40D8BAD408FD5A5E406B6281AFE8D60940302DEA93DC5A5E409C89E942AC3A3F40931B45D61A5B5E40143FC6DCB5383F40F4DC4257225B5E40A06B5F402F383F40247B849A215B5E405378D0ECBA373F4050AA7D3A1E5B5E4014268C6665373F40C7F484251E5B5E404089CF9D60373F40DC4603780B5B5E40A7E9B303AE373F40D93F4F03065B5E4031ED9BFBAB373F405A2E1B9DF35A5E4040D9942BBC373F40AC0320EEEA5A5E407E39B35DA1373F40E4141DC9E55A5E405FB87361A4373F40CD3AE3FBE25A5E407461A417B5373F405C902DCBD75A5E4017299485AF373F4081CEA44DD55A5E401822A7AFE7373F404E29AF95D05A5E40E17EC00303383F408484285FD05A5E40645DDC4603383F401E37FC6EBA5A5E4015E126A3CA383F40944A7842AF5A5E40A4FFE55AB4383F4044520B25935A5E40B3EBDE8AC4383F40FDD98F14915A5E40E15F048D99383F40DA1D520C905A5E40C03C64CA87383F4078D49810735A5E4065A6B4FE96383F405D6BEF53555A5E408A3BDEE4B7383F40E31934F44F5A5E404F04711E4E383F405E488787305A5E40FC34EECD6F383F4008E412471E5A5E409067976F7D383F4034BF9A03045A5E403B8E1F2A8D383F4072C119FCFD595E40E15F048D99383F409529E620E8595E40C287122D79383F40D386C3D2C0595E4076AA7CCF48383F405801BEDBBC595E40577BD80B05383F409FAF592E1B595E40639CBF0985383F40CF4BC5C6BC595E4051BEA08504383F4016FA60191B595E40D3DB9F8B86383F406954E0641B595E405DDF878384383F408C101E6D1C595E40A5677A89B1383F40C99063EB19595E408CA37213B5383F40D9791B9B1D595E40C68A1A4CC3383F402CD49AE61D595E402CF2EB87D8383F4074D190F128595E407381CB63CD383F409CFC169D2C595E403621AD31E8383F40CD1FD3DA34595E40043BFE0B04393F40A5F78DAF3D595E400E130D52F0383F40A8FE412443595E4084BD892139393F404BAC8C463E595E40EB6F09C03F393F4070ED444948595E40D7BFEB3367393F403A92CB7F48595E404F24986A66393F403A92CB7F48595E404F24986A66393F40, 'z', 1469549160, '2016-07-26 12:06:00');
INSERT INTO changning.company_area (area_name, company_num, polygon, area_fchar, create_time, last_update) VALUES ('华阳路街道', 38, 0x000000000103000000010000002D000000D8BAD408FD5A5E406B6281AFE8D609400168942EFD5A5E404D2CF015DD3A3F4013D6C6D8095B5E40BF64E3C1163B3F4088670932025B5E40D5B48B69A63B3F407008556AF65A5E40EFC8586DFE3B3F40D34ECDE5065B5E401E3691990B3C3F4000AE64C7465B5E405439ED29393B3F405512D907595B5E400DAA0D4E443B3F40D5264EEE775B5E4079758E01D93B3F401EA9BEF38B5B5E402D228AC91B3C3F40F58079C8945B5E40FA997ADD223C3F40FDF9B660A95B5E40D2E28C614E3C3F40CEE0EF17B35B5E40FB928D075B3C3F400FED6305BF5B5E40999D45EF543C3F401172DEFFC75B5E4062A3ACDF4C3C3F40B5A4A31CCC5B5E40111C9771533B3F40D4F19881CA5B5E403A1E3350193B3F401172DEFFC75B5E40397CD289043B3F403A1F9E25C85B5E40CFF9298E033B3F406D1FF296AB5B5E4033182312853A3F40D0420246975B5E4050FEEE1D353A3F4049BBD1C77C5B5E403A5CAB3DEC393F4008AC1C5A645B5E406D8D08C6C1393F4055151A88655B5E40CD3E8F519E393F408F56B5A4A35B5E40A530EF71A6393F40124F7633A35B5E402D42B11534393F40D2C77C40A05B5E4012859675FF383F401840F850A25B5E4001F9122A38383F409EEA909BE15B5E401557957D57383F40C32B499EEB5B5E405359147651383F400A2C8029035C5E4094895B0531383F40AAEFFCA2045C5E409F03CB1132383F4064778192025C5E4094895B0531383F409D685721E55B5E40FCC22B499E373F40821C9430D35B5E40FD6B79E57A373F403B545392755B5E40B341261939373F40CF6740BD195B5E40B8AE9811DE363F40161406651A5B5E40ABCC94D6DF363F40FD4FFEEE1D5B5E4008AC1C5A64373F4050AA7D3A1E5B5E4014268C6665373F40247B849A215B5E405378D0ECBA373F40F4DC4257225B5E40A06B5F402F383F40931B45D61A5B5E40143FC6DCB5383F40302DEA93DC5A5E409C89E942AC3A3F40D8BAD408FD5A5E406B6281AFE8D60940, 'h', 1469549160, '2016-07-26 12:06:00');

https://dev.mysql.com/doc/refman/5.7/en/populating-spatial-columns.html