Skip to content

Instantly share code, notes, and snippets.

@kylefelipe

kylefelipe/cep_para_todos_pilotos_sp.sql

Last active September 20, 2024 15:26
Show Gist options
  • Save kylefelipe/2948ffbd6b444917a880e0312b06b121 to your computer and use it in GitHub Desktop.
Save kylefelipe/2948ffbd6b444917a880e0312b06b121 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cep_para_todos_pilotos_sp.sql
CREATE SCHEMA IF NOT EXISTS public;
DROP TABLE IF EXISTS public.cep_para_todos_pilotos_sp;
CREATE TABLE public.cep_para_todos_pilotos_sp (
logradouro TEXT,
localidade TEXT,
bairro TEXT,
cep TEXT,
geom geometry(MultiPolygon, 4326)
);
INSERT INTO public.cep_para_todos_pilotos_sp VALUES
('Travessa Praia da Rendinha', 'Furnas (Santa Cruz)', 'Jardim Cruz do Corisco', '02366-285', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.59356349419507, -23.433414221120483], [-46.593706906544995, -23.433589690348633], [-46.59375414826027, -23.433618372818618], [-46.594940252754384, -23.434095851583674]]]}')),
('Rua Francisco Mendes', 'Furnas (Santa Cruz)', 'Jardim Cruz do Corisco', '02366-288', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.595098006339306, -23.433741538719136], [-46.594940252754384, -23.434095851583674], [-46.59483817690531, -23.43431771892503]]]}')),
('Rua Bahia', 'Furnas (Santa Cruz)', 'Jardim Cruz do Corisco', '02366-287', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.59399035683662, -23.434304221292095], [-46.59407724784864, -23.434070543521916], [-46.59411605354332, -23.434046079062224], [-46.59423584503561, -23.434080666746617], [-46.59483817690531, -23.43431771892503], [-46.594942783560555, -23.43439195590617], [-46.5951427172484, -23.434548022286975], [-46.595215267025424, -23.43462985168664], [-46.59522032863777, -23.43469227823896], [-46.5951933333719, -23.434764828015982], [-46.59510897316606, -23.434884619508274]]]}')),
('Travessa Esperança', 'Santa Cruz', 'Jardim Cruz do Corisco', '02366-281', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.59438431899788, -23.43337794623197], [-46.59455978822603, -23.43318897937089], [-46.59458509628778, -23.433140050451502], [-46.59458172187955, -23.433096183144464], [-46.59451254651076, -23.43303544379626], [-46.59435394932378, -23.432900467466915]]]}')),
('Rua Benta', 'Nova Conquista', 'Parque Novo Mundo', '02175-052', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.572728612508136, -23.516447773401463], [-46.57309912253219, -23.516745634401197], [-46.57313302541021, -23.516798910352367]]]}')),
('Rua da Amizade', 'Nova Conquista', 'Parque Novo Mundo', '02175-054', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.572577260374125, -23.51657854164525], [-46.57269137988315, -23.516677223236627], [-46.5728254778739, -23.516795277901153], [-46.572865434837276, -23.516861872840117]]]}')),
('Viela do Corrego', 'Nova Conquista', 'Parque Novo Mundo', '02175-056', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.573375188824606, -23.516708704480493], [-46.57313302541021, -23.516798910352367], [-46.572865434837276, -23.516861872840117]]]}')),
('Viela Seis', 'Nova Conquista', 'Parque Novo Mundo', '02175-058', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.57269137988315, -23.516677223236627], [-46.57153353605798, -23.517649509345507]]]}')),
('Avenida Noeli Alves Gomes', 'Scorpion', 'Jardim Nove de Julho', '03952-152', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.4769977823377, -23.59255731291864], [-46.47670537103351, -23.592161209212613], [-46.4764081144236, -23.5917872332608], [-46.47622103771483, -23.59155701930781]]]}')),
('Rua André Gomes', 'Scorpion', 'Jardim Nove de Julho', '03952-158', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.47785383000767, -23.592137159394625], [-46.4775269093982, -23.592280035809132], [-46.4769977823377, -23.59255731291864], [-46.476790732618376, -23.59261422132103], [-46.476481974264985, -23.592776470808694]]]}')),
('Rua Antonio Dorna de Oliveira', 'Scorpion', 'Jardim Nove de Julho', '03952-154', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.4775269093982, -23.592280035809132], [-46.47748453080069, -23.592201332699453], [-46.47747726589826, -23.592093569980037], [-46.47746273609339, -23.59175817365107], [-46.47742277913001, -23.591634670309716], [-46.477333178666676, -23.591329544407543], [-46.477300486605735, -23.591261738651507], [-46.47724357820334, -23.59124115476128]]]}')),
('Rua Antonio Dorna de Oliveira', 'Scorpion', 'Jardim Nove de Julho', '03952-154', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.47724357820334, -23.59124115476128], [-46.4764081144236, -23.5917872332608]]]}')),
('Rua Euclides da Cunha', 'Scorpion', 'Jardim Nove de Julho', '03952-160', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.476628102599214, -23.593006693821415], [-46.476481974264985, -23.592776470808694], [-46.476303984155386, -23.592431387943147], [-46.47603033949709, -23.592085094260536]]]}')),
('Rua Iolanda Navarro de Oliveira', 'Scorpion', 'Jardim Nove de Julho', '03952-156', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.47742277913001, -23.591634670309716], [-46.47670537103351, -23.592161209212613], [-46.476303984155386, -23.592431387943147]]]}')),
('Rua Vitória de Marte', 'Morro da Lua', 'Jardim Ingá', '05736-055', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.74274700003425, -23.63179113809846], [-46.742864354454106, -23.63154705590291], [-46.74296408696413, -23.631421827864013], [-46.74313580684979, -23.631319845748504], [-46.7431631770499, -23.631296599825117], [-46.74322129185838, -23.63124335916187], [-46.74326178475719, -23.631180370208178], [-46.74337051568918, -23.631071639276207], [-46.743483745832116, -23.630950160579786]]]}')),
('Viela Alegria do Sol', 'Morro da Lua', 'Jardim Ingá', '05736-054', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.74400472438398, -23.63004130894716], [-46.74374057579201, -23.630385884536253], [-46.743559107615866, -23.630679832986832], [-46.743581344361175, -23.630830431961368], [-46.743550859062516, -23.63096853235795]]]}')),
('Viela Júpiter', 'Morro da Lua', 'Jardim Ingá', '05736-056', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.743970715093916, -23.63084957228765], [-46.743767571057944, -23.63075856917896], [-46.743559107615866, -23.630679832986832], [-46.74340332897067, -23.63063817252609]]]}')),
('Viela Paz da Terra', 'Morro da Lua', 'Jardim Ingá', '05736-053', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.744177363707735, -23.630686363207182], [-46.74410856125897, -23.630631044508934], [-46.74410277244363, -23.630609336451446], [-46.74384480751307, -23.630457122043413], [-46.74381477888096, -23.63043929000112], [-46.74374057579201, -23.630385884536253]]]}')),
('Viela Saturno', 'Morro da Lua', 'Jardim Ingá', '05736-057', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.743483745832116, -23.630950160579786], [-46.743550859062516, -23.63096853235795], [-46.7439432182211, -23.631094149735357]]]}')),
('Viela Urano', 'Morro da Lua', 'Jardim Ingá', '05736-058', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.74337193450818, -23.631596329465253], [-46.74324023895942, -23.631415428986184], [-46.7431631770499, -23.631296599825117]]]}')),
('Rua 28 de Dezembro', 'Bananal', 'Vila do Sol', '04962-031', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.782396201714626, -23.73751896865546], [-46.782317838483415, -23.738401186968108], [-46.78230014356024, -23.73866913866192], [-46.78230772709875, -23.738714639892944], [-46.78243411940715, -23.738947201740405]]]}')),
('Rua Bahia', 'Bananal', 'Vila do Sol', '04962-035', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78176676801879, -23.739278349588417], [-46.78243411940715, -23.738947201740405], [-46.78277537863984, -23.738782891739483], [-46.783156407473584, -23.738650019486986]]]}')),
('Rua Beira Rio', 'Bananal', 'Vila do Sol', '04962-143', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78427229394473, -23.737224881771404], [-46.78417284368859, -23.737312768044276], [-46.784109241780584, -23.73740874910544], [-46.784067611440804, -23.73752785813315], [-46.78405951665251, -23.737619213601004], [-46.78408958300903, -23.7377082562722], [-46.78415434131536, -23.737823896104928], [-46.78420406644343, -23.73798694826907], [-46.78424222758822, -23.738111839288422], [-46.78426304275811, -23.738208976747913], [-46.78431045508953, -23.73844719480333], [-46.784359023819285, -23.73873745078348], [-46.78444922288881, -23.739213886894312], [-46.78445182478504, -23.73925031344162], [-46.784460786872074, -23.739366531473514], [-46.78446541246538, -23.73953305283264], [-46.78446772526204, -23.739637128682094], [-46.784416843735634, -23.73992391546726]]]}')),
('Rua Bento Rodrigues', 'Bananal', 'Vila do Sol', '04962-166', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78537179263512, -23.732853196590785], [-46.78535662555811, -23.733277874747017], [-46.785331347096424, -23.733449768286444], [-46.78529595725007, -23.733631773210544], [-46.78523781678821, -23.733849167980996]]]}')),
('Rua Carolyne', 'Bananal', 'Vila do Sol', '04962-001', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78517209278784, -23.73415756521349], [-46.78496733724824, -23.734038756443596], [-46.784792915862646, -23.733854223673326], [-46.784532547707336, -23.733682330133902], [-46.78429240232138, -23.733639356749045], [-46.784130620166614, -23.733626717518206], [-46.78380163982554, -23.73343189525794], [-46.783733748318234, -23.733252596285336]]]}')),
('Rua Caruaru', 'Bananal', 'Vila do Sol', '04962-146', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78531202082537, -23.73788364580328], [-46.785195099809904, -23.73813034166165], [-46.78511646472364, -23.738271422257572], [-46.78502857845078, -23.738447773002488], [-46.78499851209426, -23.738551270652778], [-46.78496035094947, -23.738777346525758]]]}')),
('Rua da Carvoeira', 'Bananal', 'Vila do Sol', '04962-176', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.786601273815116, -23.734780047332396], [-46.78676842764296, -23.734522838984773], [-46.78685437441268, -23.73442172513805], [-46.78700604518276, -23.734297860675817], [-46.78715013241433, -23.73417905190592], [-46.787385222107964, -23.733913628058275]]]}')),
('Rua da Gavia', 'Bananal', 'Vila do Sol', '04962-004', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.784014417117746, -23.73429225561343], [-46.783508770009284, -23.73454938136953]]]}')),
('Rua da Grama', 'Bananal', 'Vila do Sol', '04962-003', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78377851185898, -23.73388982899554], [-46.78310937031474, -23.734311763829734]]]}')),
('Rua das Palmeiras', 'Bananal', 'Vila do Sol', '04962-017', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.785391687525546, -23.736756540448848], [-46.78523557375135, -23.736672123370962], [-46.785110682732004, -23.736593488284708], [-46.78497654052604, -23.736494038028564], [-46.78489559264313, -23.73642696692558], [-46.78467818975761, -23.73586727013518], [-46.78458567789143, -23.73555966818012], [-46.78447235085536, -23.735265943004993], [-46.7843682750059, -23.734995345796413], [-46.78417631288357, -23.734595231975177], [-46.784014417117746, -23.73429225561343], [-46.78386871092851, -23.734035535184777], [-46.78377851185898, -23.73388982899554], [-46.78371375355267, -23.733718682043104], [-46.78371375355267, -23.733646985346812], [-46.78374150711252, -23.733561411870596], [-46.78380163982554, -23.73343189525794]]]}')),
('Rua do Campinho', 'Bananal', 'Vila do Sol', '04962-142', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78407721941636, -23.739057163048713], [-46.78395588280029, -23.738741182277707], [-46.78388257526142, -23.73855917735361], [-46.78385982464591, -23.73842772935287], [-46.78384971326124, -23.738121859966533], [-46.78384718541508, -23.737593540117413], [-46.783963466338804, -23.737138527807165]]]}')),
('Rua Eucalipto', 'Bananal', 'Vila do Sol', '04962-149', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.785391687525546, -23.736756540448848], [-46.78529917565936, -23.736957753757792], [-46.785248294132955, -23.737052578420627], [-46.78519741260656, -23.737133526303538], [-46.785121090316956, -23.737182095033283], [-46.78505401921397, -23.737219099779757], [-46.78502164006081, -23.737265355712847], [-46.785023952857465, -23.737341678002448], [-46.78507714718052, -23.737468881818447], [-46.7851696590467, -23.737598398431103], [-46.78527373489616, -23.73771403826383], [-46.78529455006605, -23.73774410462034], [-46.78531427043083, -23.737804347209767], [-46.78531202082537, -23.73788364580328]]]}')),
('Rua Gideon', 'Bananal', 'Vila do Sol', '04962-178', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78764811810944, -23.73430797206049], [-46.78742313980048, -23.734467226369073], [-46.787145076722, -23.734709899601206]]]}')),
('Rua Joao Paulo', 'Bananal', 'Vila do Sol', '04962-144', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78445182478504, -23.73925031344162], [-46.784525545178404, -23.739261299225728], [-46.78471056891077, -23.739267081217363], [-46.78486841728244, -23.739272285009836], [-46.7849580381528, -23.73927633240398], [-46.785017592666655, -23.739272863209], [-46.785108369935344, -23.739256673632415], [-46.78518353582662, -23.73926708121736], [-46.78527257849782, -23.73930061676885], [-46.78533502400749, -23.739348029100267], [-46.7853778107456, -23.73939891062667], [-46.7854414126536, -23.739524958044342], [-46.78547494820509, -23.739616313512197], [-46.7855050145616, -23.739728484149943], [-46.78552814252814, -23.73986840834754]]]}')),
('Rua Luiz Gomes', 'Bananal', 'Vila do Sol', '04962-002', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78496733724824, -23.734038756443596], [-46.78474741463162, -23.73433451444526], [-46.78468674632358, -23.734412877676466], [-46.78464377293873, -23.734430572599642], [-46.78458563247686, -23.734412877676466], [-46.78450726924565, -23.734289013214234], [-46.784130620166614, -23.733626717518206]]]}')),
('Rua Murici', 'Bananal', 'Vila do Sol', '04962-168', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78471519450406, -23.73518268232543], [-46.785088711163766, -23.735280976183248], [-46.785348900787405, -23.735367706057794], [-46.78552608565566, -23.73542028900634], [-46.78569235109062, -23.735516881442013], [-46.78581377291498, -23.735617488096484], [-46.78590339378534, -23.73573081513256]]]}')),
('Rua Oriental', 'Bananal', 'Chacara Sonho Azul', '04962-328', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78812402768674, -23.739521921000737], [-46.787741648417686, -23.73972009070627], [-46.78755205995508, -23.73982373239916], [-46.7873928056465, -23.739897039938032], [-46.787170355183704, -23.73994759686139], [-46.78704396287531, -23.739960236092234], [-46.78696054395176, -23.739927374092048], [-46.78691598953909, -23.73977387681553]]]}')),
('Rua Saboia', 'Bananal', 'Vila do Sol', '04962-147', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.786226485456694, -23.735513124019075], [-46.786142125250855, -23.735608732252363], [-46.7860498914258, -23.735676220417037], [-46.785963281614464, -23.73571446371035], [-46.78590339378534, -23.73573081513256], [-46.78585755015648, -23.735744833384455], [-46.78576081712045, -23.73578757588875], [-46.785674207309114, -23.73584719043421], [-46.78558984710327, -23.73591805300712], [-46.78555385341544, -23.735964169919647], [-46.78552123413585, -23.73608339901057], [-46.78551336051663, -23.736193629679537], [-46.78549723413121, -23.736275108368236], [-46.785469050871434, -23.73649450809459], [-46.785430807578116, -23.736647481267855], [-46.785391687525546, -23.736756540448848]]]}')),
('Rua Santa Catarina', 'Bananal', 'Chacara Sonho Azul', '04962-324', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78850083660619, -23.73919347859933], [-46.788355737052136, -23.73923847070911], [-46.78815889657184, -23.739298085254575], [-46.78802992495867, -23.739329216333616], [-46.78802841945347, -23.73932957973142], [-46.78784395180336, -23.739334078942402], [-46.78768535461637, -23.739349826180824], [-46.787571749539175, -23.73937794624944], [-46.787548128681536, -23.739403816712564], [-46.78754250466781, -23.7394375607949], [-46.787546452955, -23.7394651988052], [-46.78754700387879, -23.73946905527175], [-46.78752563262665, -23.739503924156832], [-46.78736703543966, -23.73959165877091], [-46.787215187069144, -23.739671519765775], [-46.78712520284958, -23.739706388650855], [-46.78691598953909, -23.73977387681553]]]}')),
('Rua Santana', 'Bananal', 'Chacara Sonho Azul', '04962-330', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78937480833871, -23.73896739324767], [-46.78928369931639, -23.738924650743375], [-46.78919483989957, -23.738933649165332], [-46.789102606074515, -23.738998887724517], [-46.789005873038484, -23.739103494379762], [-46.788929386451855, -23.73921147544324], [-46.788856274273456, -23.739358824602782], [-46.788794410122506, -23.73945668244156], [-46.78872670348306, -23.73952216919119], [-46.78872579715509, -23.739523045803487], [-46.78864593616023, -23.739555665083078], [-46.78840860278112, -23.739626527655986], [-46.788299496914895, -23.739664770949304], [-46.78824438158041, -23.739672644568515], [-46.78820388868161, -23.7396546477246], [-46.78816227098006, -23.739597282784626], [-46.78812402768674, -23.739521921000737]]]}')),
('Rua São Caetano', 'Bananal', 'Vila do Sol', '04962-169', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.786601273815116, -23.734780047332396], [-46.78645718658353, -23.73506443002631], [-46.78634191396632, -23.735282749310734], [-46.786226485456694, -23.735513124019075]]]}')),
('Rua São Francisco', 'Bananal', 'Chacara Sonho Azul', '04962-318', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78747369672386, -23.736009212531584], [-46.7878351787259, -23.73650719822669]]]}')),
('Rua São Jorge', 'Bananal', 'Vila do Sol', '04962-164', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78665313800572, -23.733558037462352], [-46.78656877779987, -23.733637336055846], [-46.78651225646196, -23.73368373416906], [-46.78638993416349, -23.733758814752257], [-46.78622711896622, -23.733830520927224], [-46.7861157634945, -23.733888729469253], [-46.78597656915486, -23.733984900103913], [-46.785819659172, -23.734105535198267], [-46.785804474334945, -23.734139279280605], [-46.78581712836582, -23.734178084975294], [-46.78621699574151, -23.734527758028513], [-46.786336787233815, -23.734613383637438], [-46.78646502658672, -23.7346906220659], [-46.786601273815116, -23.734780047332396]]]}')),
('Rua São Jose', 'Bananal', 'Vila do Sol', '04962-038', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78307542167597, -23.73748584864636], [-46.783104104145956, -23.738317640275966], [-46.78312097618713, -23.738511668749407], [-46.783156407473584, -23.738650019486986]]]}')),
('Rua São Sebastião', 'Bananal', 'Chacara Sonho Azul', '04962-320', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.787056602106134, -23.736244302225213], [-46.78754447641658, -23.736939459921423]]]}')),
('Travessa Joao Paulo', 'Bananal', 'Vila do Sol', '04962-145', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78549460697666, -23.737940692335975], [-46.78550559276077, -23.738021640218886], [-46.78552872072732, -23.738199725561287], [-46.785516000345716, -23.738300332215758], [-46.785468588014304, -23.738415972048486], [-46.78532750741838, -23.738774455529942], [-46.78520839839066, -23.738965261253945], [-46.78509622775291, -23.73914912858798], [-46.785017592666655, -23.739272863209]]]}')),
('Rua da Mina', 'Bananal', 'Chacara Sonho Azul', '04962-312', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78850421101447, -23.73578026467092], [-46.787489638938865, -23.736002975614348], [-46.787248931151524, -23.736117705494294], [-46.78699247612576, -23.736279677089517], [-46.78687212223209, -23.736368536506337], [-46.786638163261216, -23.736586748238786], [-46.78660329437614, -23.736677857261093], [-46.786572924702035, -23.73694780991979], [-46.786494188509906, -23.737374110159987], [-46.78644807159738, -23.737509086489336], [-46.78636708579978, -23.737651936437896], [-46.78625460552532, -23.737820656849582], [-46.78613875084263, -23.73794550995423], [-46.78598802727486, -23.738045617398495], [-46.78588791983059, -23.738064739045154], [-46.785974512282486, -23.738202038357937], [-46.78611385352346, -23.738555393168213], [-46.78617459287167, -23.738767980886937], [-46.786249735084375, -23.739071649900044], [-46.78629830381412, -23.739474076517936], [-46.786279801440884, -23.739980578985282]], [[-46.78588791983059, -23.738064739045154], [-46.785803559624746, -23.738015247724395], [-46.78569782816676, -23.73798037883931], [-46.78555272861271, -23.73794550995423], [-46.78549460697666, -23.737940692335975], [-46.785448121957465, -23.73792638830757], [-46.78531202082537, -23.73788364580328]]]}')),
('Rua Dom Pedro I', 'Bananal', 'Vila do Sol', '04962-177', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.787588212194706, -23.734350377370916], [-46.78741050056964, -23.73473012237055], [-46.78725630195339, -23.73493740575633], [-46.787155188106674, -23.73505368668006], [-46.78711474256798, -23.73513457775744], [-46.7870894641063, -23.735215468834816], [-46.78699340595192, -23.735346916835553], [-46.78690240348987, -23.735450558528445], [-46.78677095548913, -23.735607284990863], [-46.786634451796054, -23.735736205145432], [-46.78645144600561, -23.7358494400397], [-46.78640982830405, -23.736119392698395], [-46.786328842506435, -23.736398343779058], [-46.786200614993554, -23.736816770400036], [-46.786119629195944, -23.73700686206387], [-46.78598690247208, -23.737252069062187], [-46.785868798183905, -23.73738142137781], [-46.78565846007067, -23.737511898496177], [-46.78534464010494, -23.737742483058817], [-46.78531427043083, -23.737804347209767]]]}')),
('Rua São José do Norte', 'Bananal', 'Vila do Sol', '04962-141', ST_GeomFromGeoJSON('{"type": "MultiLineString", "coordinates": [[[-46.78405951665251, -23.737619213601004], [-46.78384718541508, -23.737593540117413], [-46.78365538508705, -23.737570157540336], [-46.78326609677717, -23.737504433539968], [-46.78307542167597, -23.73748584864636], [-46.78259368969647, -23.73748421077062], [-46.782396201714626, -23.73751896865546]], [[-46.783675607856395, -23.73862174154624], [-46.78365538508705, -23.737570157540336]]]}'))
;
CREATE INDEX ON public.cep_para_todos_pilotos_sp USING GIST(geom);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment