-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Tempo de geração: 08-Abr-2026 às 11:20
-- Versão do servidor: 5.7.44
-- versão do PHP: 8.1.34

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Banco de dados: `almondfr_gpstratores`
--

-- --------------------------------------------------------

--
-- Estrutura da tabela `alfaias`
--

CREATE TABLE `alfaias` (
  `id` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `largura_metros` decimal(5,2) NOT NULL,
  `ativa` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `alfaias`
--

INSERT INTO `alfaias` (`id`, `nome`, `largura_metros`, `ativa`) VALUES
(1, 'Atomizador', 6.00, 1),
(2, 'Destroçador', 3.00, 1),
(3, 'Barras Herbicida', 6.00, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `campos`
--

CREATE TABLE `campos` (
  `id` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `cultura_id` int(11) DEFAULT NULL,
  `variedade_id` int(11) DEFAULT NULL,
  `coordenadas_geojson` longtext NOT NULL,
  `area_hectares` decimal(8,2) DEFAULT NULL,
  `data_importacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `campos`
--

INSERT INTO `campos` (`id`, `nome`, `cultura_id`, `variedade_id`, `coordenadas_geojson`, `area_hectares`, `data_importacao`) VALUES
(81, 'MAS1', 1, 5, '[[38.19017410928422,-8.156230632688182],[38.18815798169589,-8.155962316790163],[38.18801248614969,-8.155817969056386],[38.18793240741426,-8.156518361592713],[38.18720764545062,-8.156159856710094],[38.18721587469116,-8.156002973422773],[38.18731201516731,-8.155713183984547],[38.18741730635483,-8.15554246201122],[38.18744689188998,-8.155501342920696],[38.18747309265232,-8.155265219058732],[38.18757416210892,-8.15525636485857],[38.18760302308913,-8.154894253912182],[38.18764232639607,-8.154854570089944],[38.18766582931668,-8.154406304224777],[38.18778315582917,-8.154356308609689],[38.18783522970877,-8.153514834046689],[38.18786832243535,-8.153496701166471],[38.18789944990977,-8.153122177869317],[38.1879962905107,-8.152932697753748],[38.18802731950744,-8.152795674623057],[38.18812973396744,-8.152779748441583],[38.18814476257501,-8.152829489974007],[38.18823159045229,-8.152850450942017],[38.18825025395757,-8.15274184928457],[38.18819083121743,-8.152668585323093],[38.1881269988757,-8.152601594095039],[38.1880268488397,-8.152561018351342],[38.18804426416123,-8.152282526562763],[38.18805942357189,-8.15223309698922],[38.18814201019399,-8.152321531249813],[38.18823250631418,-8.152472694734003],[38.18851099687431,-8.15271206799069],[38.18893534238379,-8.152801954561856],[38.18893838457149,-8.15288376434893],[38.18899105557809,-8.15288377778722],[38.18900972619043,-8.152694247980033],[38.189247699261,-8.152726500804343],[38.18901641239231,-8.152980460237426],[38.18901133641342,-8.153138455929525],[38.18908234109988,-8.153184690443194],[38.18906621447907,-8.153472386453767],[38.18910962427434,-8.15351015248783],[38.18909610602078,-8.153678743479865],[38.18903216692836,-8.153693289734676],[38.18902308562007,-8.153792188175453],[38.18908016146435,-8.153835754058465],[38.18916242910495,-8.153949152764929],[38.18929911364798,-8.153963385479026],[38.18932697920099,-8.153754216803545],[38.18928205454969,-8.15358199655957],[38.18938302835265,-8.153493560037804],[38.18937723002614,-8.153387821852716],[38.18928449141225,-8.15334634235645],[38.18914070400185,-8.153352543714076],[38.18916020005959,-8.153104487453904],[38.1891455772652,-8.15300216439421],[38.18902458970756,-8.152976951866254],[38.18924875314779,-8.152730459260356],[38.1892408551973,-8.152869196899054],[38.18931973975826,-8.152907366490492],[38.18937429009475,-8.15282293681625],[38.18932066868055,-8.15276629600325],[38.1893628189293,-8.152729856064752],[38.18952819705206,-8.152744802622156],[38.18968417064909,-8.152772707673066],[38.19029542836581,-8.15280539245104],[38.19038858199622,-8.152900106698864],[38.19036546849385,-8.153395300975088],[38.19028930657809,-8.153521034804026],[38.19035513750917,-8.15359538760894],[38.19022974136367,-8.155038937916169],[38.19023218341064,-8.15515851718085],[38.19020972209599,-8.155306370090875],[38.1901153041434,-8.15528353982028],[38.19007081163535,-8.155375446239075],[38.19008403937965,-8.155526776390605],[38.19022765487362,-8.155533282706202],[38.19017410928422,-8.156230632688182]]', NULL, '2026-04-07 10:52:14'),
(82, 'MAS2', 1, 5, '[[38.19030829498029,-8.152761900207782],[38.18860413805731,-8.152590081824192],[38.18843943207117,-8.152538893132176],[38.18829322630837,-8.152410751319405],[38.18819250563932,-8.152154465105065],[38.18812427472144,-8.151943649556527],[38.18815675952209,-8.151509614274762],[38.18823147989453,-8.151112781190829],[38.18837766779487,-8.150376985037392],[38.18850760011981,-8.149504773522139],[38.18857257102972,-8.149260881898043],[38.18867328710844,-8.149186469694644],[38.18890396205106,-8.149091381162306],[38.18932307624848,-8.148938407691386],[38.18943354140053,-8.1489218656843],[38.18954400749477,-8.148930126144236],[38.18971369349274,-8.14904738314012],[38.19001367126127,-8.149512447419067],[38.1900261814807,-8.14936808169811],[38.18993887334444,-8.149254893989434],[38.18986800264572,-8.14911434760931],[38.18982287774865,-8.149060860162349],[38.18976826440316,-8.148965610365979],[38.1897873571886,-8.148725304720845],[38.18988647982436,-8.14872958000781],[38.18989134801312,-8.148822274161692],[38.18992177986473,-8.14884014110254],[38.18998454046331,-8.148884539457741],[38.19008662018545,-8.148973603955708],[38.19007784545363,-8.149386270170707],[38.1900296590694,-8.149383128908838],[38.19001962595863,-8.149513294592358],[38.19010930584108,-8.149724774377363],[38.19021738135172,-8.150934909728619],[38.19020144607048,-8.151244131404194],[38.19019286157081,-8.15140406015078],[38.19024142624357,-8.151480342427385],[38.19027676440373,-8.151764561038302],[38.19032451194129,-8.152185682085266],[38.19030829498029,-8.152761900207782]]', NULL, '2026-04-07 10:52:14'),
(83, 'MAS3', 1, 5, '[[38.18484546911859,-8.154924078158214],[38.18612924928391,-8.151157648240424],[38.18788038779684,-8.15212392478847],[38.18789466904629,-8.152175805894132],[38.18772518383869,-8.153088727338531],[38.18764106281786,-8.153068480232958],[38.18756148894283,-8.15308872916585],[38.18752056521766,-8.153123440531262],[38.18753193285448,-8.153187076921139],[38.18762514782006,-8.15324782024353],[38.18770761324492,-8.15327541625115],[38.18765048045692,-8.153598196740147],[38.18758598533897,-8.153981293197983],[38.18753427516712,-8.154135054862286],[38.18748213081314,-8.15428048901125],[38.18745741599847,-8.154650260769671],[38.18740400138605,-8.154902699009863],[38.18721097805505,-8.155499209198556],[38.18698711962831,-8.156062012051478],[38.18484546911859,-8.154924078158214]]', NULL, '2026-04-07 10:52:14'),
(84, 'MAS4', 1, 6, '[[38.18612514615013,-8.151162045106574],[38.18747137131597,-8.147275506513838],[38.18965757563989,-8.148463224582954],[38.18934887388765,-8.148615634906225],[38.18914787906198,-8.148693566393458],[38.1888595423556,-8.148840050844948],[38.18854106523115,-8.148984362661375],[38.18840391168641,-8.14909915234896],[38.18832905796216,-8.149321529894229],[38.18828200571437,-8.149632701822963],[38.18817711680116,-8.150292896170313],[38.18797211408732,-8.15155287704256],[38.18793016362912,-8.151755385376331],[38.18790871150406,-8.15183982011705],[38.18790491906294,-8.151955927729855],[38.18791229608237,-8.152143039151671],[38.18612514615013,-8.151162045106574]]', NULL, '2026-04-07 10:52:14'),
(85, 'MAS5', 1, 6, '[[38.1874668249593,-8.147259537286898],[38.18895346287022,-8.142952715538684],[38.18900632226673,-8.142866942597173],[38.18937211512771,-8.142863421017845],[38.18949290683717,-8.142914977914657],[38.18952153755683,-8.143073262571939],[38.18956201937735,-8.143404588273253],[38.18956079537212,-8.143501845474045],[38.18958128107808,-8.143685444298459],[38.18961081252342,-8.143961064494107],[38.18961110595185,-8.144299690541459],[38.18963364802224,-8.14473356840048],[38.18967117295163,-8.145175099596845],[38.18967258368351,-8.145488913412438],[38.18969131020173,-8.14595400586181],[38.18971109018564,-8.146193810615674],[38.18973165840966,-8.146606696755493],[38.18979287798471,-8.14721510229704],[38.18982572152873,-8.14773507576782],[38.18983912857784,-8.14808971854005],[38.18980068862661,-8.148245859542467],[38.18978565569517,-8.148314117624453],[38.18969956378315,-8.148418290925749],[38.18965876392356,-8.148459824133731],[38.1874668249593,-8.147259537286898]]', NULL, '2026-04-07 10:52:14'),
(86, 'MAS6', 1, 5, '[[38.18380970930487,-8.151226790676251],[38.18415063363243,-8.151422339089242],[38.184250795804,-8.151471821229148],[38.18436497805186,-8.151532525235849],[38.18443631774278,-8.151516913379142],[38.18447448333004,-8.15148751277617],[38.18449358562699,-8.151478894014256],[38.1845323388514,-8.151398013408153],[38.18472448147544,-8.151491944533321],[38.18474483905359,-8.15144399499616],[38.18483796554603,-8.151482642027206],[38.18487162898496,-8.151433318874904],[38.18492066030552,-8.151429615060767],[38.18502290588549,-8.151436841392721],[38.18507434425499,-8.151370203010748],[38.18512537883639,-8.151396728067299],[38.18514600111706,-8.151436286769613],[38.18517307588243,-8.151440936732408],[38.18517288828122,-8.151398300945187],[38.18517980287492,-8.151377102614696],[38.18523334120277,-8.151281458884021],[38.18527045964778,-8.151148619356093],[38.18521743408041,-8.151003052094598],[38.18520008946167,-8.150856997421643],[38.18513262521048,-8.150817931673496],[38.18503418029095,-8.150765930043395],[38.18487447002718,-8.150668663926574],[38.18485192262374,-8.150723257960298],[38.18453180085028,-8.150556066150731],[38.18443746812201,-8.150524027492054],[38.18441678395668,-8.150571579752924],[38.18414045169992,-8.150430141024534],[38.18411508090854,-8.150415535046127],[38.18421858032331,-8.150104542008165],[38.18609205661022,-8.151130764493635],[38.18488880765142,-8.154605202905332],[38.18480195652843,-8.154881297432333],[38.18291973216819,-8.153869482775983],[38.18380970930487,-8.151226790676251]]', NULL, '2026-04-07 10:52:14'),
(87, 'MAS7', 1, 6, '[[38.18420295238388,-8.150093870812528],[38.18554138516045,-8.146224782494647],[38.18743951980547,-8.147241342571023],[38.18610758329652,-8.151135733413481],[38.18420295238388,-8.150093870812528]]', NULL, '2026-04-07 10:52:14'),
(88, 'MAS8', 1, 6, '[[38.18556771341932,-8.146237810614888],[38.18663897485595,-8.143070760400159],[38.18667957136523,-8.142974687912433],[38.18670028971466,-8.142893429450634],[38.18881541514914,-8.142866111732847],[38.18891497870732,-8.142898770506571],[38.1889175228802,-8.142983909598058],[38.18743964615094,-8.147236572787914],[38.18556771341932,-8.146237810614888]]', NULL, '2026-04-07 10:52:14'),
(89, 'MAS9', 1, 5, '[[38.18286886299425,-8.153853818230512],[38.18128359435683,-8.152957358887074],[38.18119319996864,-8.15280145605604],[38.18114188513825,-8.152648649287581],[38.18110505218534,-8.152484899390188],[38.18106783005923,-8.152304828292916],[38.18109649882472,-8.152208092307674],[38.18167109099846,-8.150507720223839],[38.18220694330903,-8.149049458621157],[38.18415862919623,-8.15009596636461],[38.18403285713413,-8.150464154896582],[38.18388462681792,-8.150381867278753],[38.18378127105387,-8.150520594969848],[38.18359737067424,-8.150492044950159],[38.18361208378228,-8.150384098886212],[38.18357009982043,-8.150289189111772],[38.18346730035265,-8.150319852634993],[38.18334289466707,-8.15042238157578],[38.1832436806468,-8.15044406932114],[38.18316870776732,-8.150569524299087],[38.18318533688515,-8.150776794124889],[38.18323435243746,-8.150880768525678],[38.18328676791786,-8.151011789062698],[38.18341751055024,-8.15105340552871],[38.18349137028708,-8.151144079617028],[38.18354036257226,-8.151252558308467],[38.18370989777394,-8.151321517245359],[38.18286886299425,-8.153853818230512]]', NULL, '2026-04-07 10:52:14'),
(90, 'MAS10', 1, 6, '[[38.18218010303793,-8.149030457229516],[38.18224351481767,-8.148927366959807],[38.18230340403525,-8.148842204842918],[38.18227521664667,-8.148774976243091],[38.18243021351469,-8.148322280881484],[38.18263100395114,-8.147770973606281],[38.18279489971533,-8.147461875855118],[38.18310298561415,-8.146959624360914],[38.18350164722492,-8.146338589680202],[38.18424375785838,-8.145506736852251],[38.18516402930323,-8.146010811197446],[38.18500409512974,-8.14610448837611],[38.1849014125775,-8.14615094924983],[38.18473940282983,-8.146226446848122],[38.18458715399537,-8.146273373183968],[38.18452263081485,-8.146345495671241],[38.18448593087469,-8.146445923400504],[38.18444003616626,-8.146594451675513],[38.18439051372186,-8.146746998559998],[38.18432230045075,-8.146927641917749],[38.18432024808534,-8.14706517777825],[38.18433465062662,-8.147165579792812],[38.18422175242075,-8.147273318522391],[38.1841201365766,-8.147226644699334],[38.18415964894036,-8.147151231136489],[38.18409472734793,-8.147115327158728],[38.18403262544304,-8.147025558630718],[38.18393947826397,-8.146996839206588],[38.18390278882334,-8.147075843359339],[38.18385480799656,-8.147136893648913],[38.18373625730536,-8.147104585366803],[38.18372497078082,-8.147176405176362],[38.18366852514035,-8.14729491087056],[38.18371086814565,-8.147373907963676],[38.18381530522204,-8.14739544497525],[38.18384353462915,-8.147463670557714],[38.18380120095051,-8.14756781129251],[38.18389435006766,-8.147639622706375],[38.18399031875531,-8.147650387937812],[38.18408346486105,-8.147661153421316],[38.18413992177344,-8.147765286726806],[38.18424153222372,-8.147704232476679],[38.1842415285403,-8.147628822254362],[38.18418224979269,-8.147542643941186],[38.18424152230419,-8.147503138546032],[38.18425845335216,-8.147413363047647],[38.18422739780602,-8.147276909011925],[38.18433465081534,-8.147169170769608],[38.18444053341477,-8.14725126052623],[38.18453132369898,-8.147220939055856],[38.18467669466869,-8.14728770552496],[38.1847006015609,-8.147248655685397],[38.18478598077322,-8.147270104185782],[38.18482011103336,-8.147241765815682],[38.18509249496146,-8.147379226217673],[38.18499163563855,-8.147656611350346],[38.18477161989171,-8.148292593262202],[38.18415172841983,-8.150089061505376],[38.18218010303793,-8.149030457229516]]', NULL, '2026-04-07 10:52:14'),
(91, 'MAS11', 1, 6, '[[38.18553422129063,-8.146124199921715],[38.18524491443004,-8.1459632219308],[38.18517623644046,-8.146018810450256],[38.18425035572445,-8.145509438288967],[38.18441372873701,-8.145338240128279],[38.18448741001492,-8.145309701877496],[38.18450342388661,-8.145248564199436],[38.18458351067135,-8.145195570714286],[38.18464437601236,-8.145146655037196],[38.18464757647933,-8.145101821596217],[38.1849262701864,-8.144804259921827],[38.18499354451006,-8.144779797399199],[38.1850031511885,-8.144722735635185],[38.18517933745733,-8.144543380547843],[38.18525622130166,-8.144498537478654],[38.18529786244333,-8.144417016686829],[38.18537794472223,-8.144302884473287],[38.18542600027526,-8.14431510571046],[38.18546764448681,-8.14427434239067],[38.18549006472662,-8.144205050935478],[38.18550928416,-8.144172441962116],[38.18552850381344,-8.14414390881439],[38.18557015210991,-8.14415613073026],[38.18561179865951,-8.144143897845645],[38.18560858905407,-8.144066457855525],[38.18566945875231,-8.144070525513825],[38.1857111010012,-8.144001231006943],[38.18572605334545,-8.143895589331304],[38.18648560110116,-8.143057324698527],[38.18654260198119,-8.143082742744944],[38.18657385211198,-8.1430386486612],[38.18658530723347,-8.143078873924312],[38.18553422129063,-8.146124199921715]]', NULL, '2026-04-07 10:52:14'),
(92, 'MCS12', 1, 2, '[[38.18633783731155,-8.156020894118509],[38.18629741771872,-8.156109654907448],[38.185958328556,-8.156417065355615],[38.1857537594663,-8.156639984275259],[38.18560996540679,-8.156840268962334],[38.18540561766799,-8.15719189026311],[38.18516059919467,-8.157465703697905],[38.18506658483874,-8.157538733720916],[38.18468767858231,-8.157528526042142],[38.18455638368948,-8.157321965119756],[38.18441021330027,-8.157180496304244],[38.18437511316861,-8.157127118919043],[38.18429101396978,-8.157120041136212],[38.1839141972068,-8.157115087324552],[38.18394142052272,-8.156926498281539],[38.18393872655582,-8.156830530552696],[38.18344411843869,-8.156837217221755],[38.18343738048812,-8.156769699340439],[38.18334478674498,-8.15676406624043],[38.18332337566576,-8.15648750686552],[38.18329687103969,-8.1564232382003],[38.18310846666073,-8.156393901962492],[38.18290627444976,-8.156748024077983],[38.18268419193675,-8.156734250739943],[38.18283485453225,-8.15655266173368],[38.18297348358669,-8.156361133508632],[38.18311944623643,-8.156115745871071],[38.18323621091255,-8.155860152676803],[38.18334108283297,-8.155642182757997],[38.18347279581376,-8.15543027249619],[38.18360079377647,-8.155344868316082],[38.18380896687312,-8.155313810548655],[38.1838732752902,-8.155230240032447],[38.18395276336815,-8.155111569877725],[38.18402321354993,-8.154971048789118],[38.18406021090797,-8.154870771454384],[38.18408598988991,-8.154788824822294],[38.18417063440084,-8.154798219926837],[38.18483757701352,-8.155155367875263],[38.18506590987175,-8.15525143646164],[38.18524750991345,-8.155443818111799],[38.18633783731155,-8.156020894118509]]', NULL, '2026-04-07 10:52:14'),
(93, 'MCS13', 1, 2, '[[38.18391563368074,-8.154669589462987],[38.18393350813848,-8.154860603036816],[38.18389878852821,-8.154978303244505],[38.18382901236509,-8.155065835768415],[38.18376525048444,-8.155116444339878],[38.18363914298924,-8.155167069033405],[38.18351522360259,-8.155231751279505],[38.18342862206657,-8.155284747517243],[38.18334527345751,-8.1553671979807],[38.18326333455158,-8.155507967620006],[38.183167876821,-8.155685523100074],[38.18301252920767,-8.156008546567389],[38.18281733862233,-8.156350397447401],[38.18266396156511,-8.156531831026872],[38.18251048144921,-8.156704972656435],[38.18238192404405,-8.15687600971754],[38.18226509530554,-8.157062698176931],[38.18221118836814,-8.157145741763069],[38.1820848272974,-8.157163659760604],[38.18205567419109,-8.157240713796536],[38.18207527744201,-8.157293748820468],[38.18214643211783,-8.157298601975867],[38.18201516899767,-8.157556749124863],[38.18198068369882,-8.157644188996427],[38.18173571812298,-8.157667514546919],[38.18088177135857,-8.157667671617755],[38.18086172364585,-8.157053223305414],[38.18129047450535,-8.157063991719685],[38.18130063786604,-8.157012112464422],[38.18148387611772,-8.157009569027942],[38.18150285956548,-8.157080321836373],[38.18134995110218,-8.157077106967481],[38.18134852114668,-8.157339677337289],[38.18151333465092,-8.157343457256736],[38.18151084716931,-8.157113036854458],[38.18148235306762,-8.156938298763452],[38.18146681402703,-8.15679653115151],[38.18145645673344,-8.156671248603844],[38.18120373356905,-8.156656793736262],[38.18120074677978,-8.156723525017053],[38.18102643499732,-8.156720863175636],[38.18102654626623,-8.156925388846016],[38.18085007398287,-8.156926651224657],[38.18086169497349,-8.156579104582333],[38.18106712254154,-8.156575948364965],[38.18112611479469,-8.15648641381632],[38.18117659413813,-8.156331639617163],[38.1810984917555,-8.156220879213015],[38.18099987844696,-8.15603687643503],[38.18086533320259,-8.156017352057825],[38.18119229871098,-8.153373966619885],[38.18151350286659,-8.153373303342162],[38.18391563368074,-8.154669589462987]]', NULL, '2026-04-07 10:52:14'),
(94, 'MCS14', 1, 6, '[[38.17847496040601,-8.154991984427792],[38.17849186148835,-8.153294015292538],[38.17847403628735,-8.151778930272295],[38.17865192705892,-8.151800039768876],[38.17899049237339,-8.151999420284723],[38.17931668106406,-8.15217834588262],[38.17975310799309,-8.152409222100903],[38.18045044004174,-8.152784445822777],[38.18098847089772,-8.153107916216998],[38.18108743767941,-8.15322813024415],[38.18109361007262,-8.153295972487802],[38.1808808485157,-8.155070032829443],[38.17847496040601,-8.154991984427792]]', NULL, '2026-04-07 10:52:14'),
(95, 'MCS15', 1, 6, '[[38.18087460271101,-8.15507076083314],[38.1807037345679,-8.156320299501395],[38.18070639399053,-8.156695712006218],[38.18076041739749,-8.157998782210829],[38.17848097516609,-8.157962284901433],[38.17848306731368,-8.155000337717622],[38.18087460271101,-8.15507076083314]]', NULL, '2026-04-07 10:52:14'),
(96, 'MCS16', 1, 6, '[[38.17621551373676,-8.154939582571767],[38.17621689917463,-8.150575156479219],[38.17636739128093,-8.150550152006756],[38.17842315285491,-8.151673368272732],[38.1784401452208,-8.154989171160583],[38.17621551373676,-8.154939582571767]]', NULL, '2026-04-07 10:52:14'),
(97, 'MCS17', 1, 6, '[[38.17621964244533,-8.157907947662885],[38.17620604585414,-8.154943504168376],[38.17844899649356,-8.154993911685105],[38.1784503985437,-8.157960486192732],[38.17621964244533,-8.157907947662885]]', NULL, '2026-04-07 10:52:14'),
(98, 'MCS18', 1, 6, '[[38.1739266671947,-8.154896457574784],[38.17391870337593,-8.15174522592683],[38.17393261199861,-8.151705544667053],[38.17396860977014,-8.151686511772011],[38.17430774591168,-8.151695343183684],[38.1748490382819,-8.151707283202997],[38.17504101394645,-8.151722428182227],[38.17504900151791,-8.151778140567853],[38.17516975709349,-8.151781958279809],[38.17526853722968,-8.151860282195763],[38.17536331721831,-8.151856830826182],[38.17543199144465,-8.151798629060645],[38.17547868544768,-8.151719050487714],[38.17560531130182,-8.151723592964329],[38.17560844464801,-8.151809737760065],[38.17571109647474,-8.151836472816115],[38.17576705843735,-8.15175510901193],[38.17570732601862,-8.1516217939504],[38.17583531448765,-8.151256822664966],[38.17600007980656,-8.151265153286209],[38.17609951483729,-8.151205555681548],[38.17607273225384,-8.151133880979893],[38.17587576628291,-8.150999028421174],[38.1757375339287,-8.15074502672443],[38.17581805928516,-8.150740847581128],[38.17585390467391,-8.150638087617718],[38.17567678443203,-8.150611610040068],[38.17545919970275,-8.15036182257022],[38.17519749577901,-8.150155067684308],[38.17549421873392,-8.150158710291944],[38.17564804666974,-8.150218668737493],[38.17585221100378,-8.150289324461474],[38.17618093749061,-8.15044933748952],[38.1761833718741,-8.1534513964527],[38.1760649841079,-8.153451838882944],[38.17602557380275,-8.153493740520963],[38.17604314765884,-8.153560207794078],[38.17605635934387,-8.15360175681683],[38.17618147546581,-8.153612631345798],[38.17618992674734,-8.15495421615861],[38.1739266671947,-8.154896457574784]]', NULL, '2026-04-07 10:52:14'),
(99, 'MCS19', 1, 4, '[[38.17617727943315,-8.154941414587306],[38.17619165588874,-8.157913185571351],[38.17394641771994,-8.157858106600438],[38.17393017531532,-8.154892143454372],[38.17617727943315,-8.154941414587306]]', NULL, '2026-04-07 10:52:14'),
(100, 'MCS20', 1, 4, '[[38.17241477168358,-8.154842102322844],[38.17228306557678,-8.154034089224185],[38.17219410074524,-8.153654233462579],[38.17205830931171,-8.152931892689793],[38.17199036545306,-8.152541281147721],[38.17198591477045,-8.152386049955881],[38.17188855090519,-8.152022279222974],[38.17189244921738,-8.151824201371005],[38.17189637215629,-8.15164218294804],[38.17186936314022,-8.151512971071552],[38.17185800792149,-8.15133179450637],[38.17192924881972,-8.151138898460854],[38.17210505562544,-8.150808058104104],[38.17226720636017,-8.150830221362613],[38.17227706935948,-8.150672397814283],[38.17214744054882,-8.150657494675709],[38.17221311451014,-8.150046147802835],[38.17279111807628,-8.150075020727606],[38.17283861801067,-8.150457618355775],[38.17281451684933,-8.150671840075727],[38.17280635197605,-8.150862691947253],[38.17266074520668,-8.15086825081481],[38.17249402402495,-8.150835736734772],[38.17249073070845,-8.150906256702477],[38.17263936568887,-8.150924871142426],[38.17266142673687,-8.15104678008213],[38.1726376777144,-8.151237247228615],[38.1726886430591,-8.151445817914176],[38.17270192072368,-8.151600536647102],[38.17277994191817,-8.151645763164494],[38.17278879376811,-8.151722570758707],[38.17292707900668,-8.15173559653027],[38.17292588809484,-8.151686324401792],[38.17311099652388,-8.15168424712662],[38.17320478459567,-8.15177441998493],[38.17312771920508,-8.151855976261423],[38.17316476861728,-8.151940354476658],[38.17326576049979,-8.151910376313056],[38.17333454125541,-8.151936832161148],[38.1734384748071,-8.15178367035433],[38.17343180146437,-8.15168142343322],[38.17363150692142,-8.151678154951925],[38.17386537955218,-8.15169613009445],[38.17387150527264,-8.15176013820677],[38.1738873039902,-8.154884429755484],[38.17241477168358,-8.154842102322844]]', NULL, '2026-04-07 10:52:14'),
(101, 'MCS21', 1, 4, '[[38.17304294633139,-8.157835006065653],[38.17296937548603,-8.157711790525381],[38.17290101342045,-8.157511891372561],[38.17276480970815,-8.156646873641018],[38.17259321634612,-8.155787654152919],[38.172516588928,-8.155225897686245],[38.17244106727905,-8.154845031998937],[38.17388936078181,-8.154880950528607],[38.1738962012425,-8.157852568426838],[38.17304294633139,-8.157835006065653]]', NULL, '2026-04-07 10:52:14'),
(102, 'MCS22', 1, 4, '[[38.17071724379947,-8.154801026082616],[38.17071467223358,-8.15455551126281],[38.17070979448246,-8.154237461976443],[38.1708122208889,-8.153807543390062],[38.17083165014618,-8.153606613047918],[38.17091643043842,-8.153115354543262],[38.17099484595685,-8.152763610872393],[38.17109751936106,-8.152211606908384],[38.17116294305357,-8.151848821215568],[38.17120993536307,-8.151516299799654],[38.17123320687654,-8.151207340699951],[38.17122892115284,-8.151043101830705],[38.17139715418715,-8.1510830666124],[38.17142189521586,-8.151346412335279],[38.17146056866542,-8.151443950327172],[38.17153660891868,-8.151504687861253],[38.1715488219284,-8.1515631526419],[38.17160728796497,-8.151573977366027],[38.17162213879991,-8.151542057691344],[38.17156162311738,-8.15141325743949],[38.17154733326868,-8.151213258581915],[38.17154725939951,-8.151166252009212],[38.17186742082619,-8.151162275191247],[38.17183276467882,-8.15130013813141],[38.17183422048871,-8.151402809627555],[38.1718717674672,-8.1515628247448],[38.17187179255716,-8.151819071318831],[38.17188508092424,-8.152082280893357],[38.1722505405304,-8.153967017657944],[38.17218032643238,-8.154019686296575],[38.17217415547745,-8.154107956114789],[38.17228625468387,-8.154150960525861],[38.17241343335311,-8.15485069225619],[38.17071724379947,-8.154801026082616]]', NULL, '2026-04-07 10:52:14'),
(103, 'MCS23', 1, 4, '[[38.17147223223255,-8.157743318492539],[38.17131582944883,-8.157213255610301],[38.1711138403421,-8.156653328170918],[38.17092649529782,-8.156276116002656],[38.1707775771411,-8.155974955049931],[38.17083023228357,-8.155959595936439],[38.17082045394487,-8.155828652996279],[38.17074858245295,-8.155804465104879],[38.17071733299836,-8.155725353208425],[38.17071749954739,-8.154804346996],[38.17240507127917,-8.15485232713576],[38.17241327796389,-8.154876333365415],[38.17231006239941,-8.15489852476692],[38.17231281143205,-8.154941181651157],[38.17234950391042,-8.154981934916519],[38.17238989475015,-8.154934357685285],[38.17241847169426,-8.154945384048686],[38.17245867711663,-8.155040099811359],[38.17240770187058,-8.155077689970485],[38.17238045472351,-8.155077702071875],[38.17241266374593,-8.155151032147167],[38.17242134606995,-8.155228258379415],[38.17244895784932,-8.155311133549173],[38.1725077532535,-8.155370417169785],[38.17274170126779,-8.15670093930947],[38.17268240904993,-8.156762219317738],[38.1727157540045,-8.156832684565734],[38.17277030353017,-8.156865260643698],[38.17293135463422,-8.157762823394622],[38.17147223223255,-8.157743318492539]]', NULL, '2026-04-07 10:52:14'),
(104, 'MMS24', 1, 1, '[[38.18151966692212,-8.150004289310122],[38.18079626203367,-8.15213556869163],[38.18071848745662,-8.152259258366932],[38.18059667969683,-8.152359283280346],[38.18048820702396,-8.152414487582064],[38.18036285972359,-8.152445159971723],[38.18027849030354,-8.152432897995698],[38.17901533816993,-8.151718464962975],[38.17989965505198,-8.149113202647225],[38.18151966692212,-8.150004289310122]]', NULL, '2026-04-07 10:52:14'),
(105, 'MMS25', 1, 5, '[[38.18038971816028,-8.149386940901088],[38.18045705799034,-8.14925524654346],[38.18054396207231,-8.149136167732419],[38.18058406916403,-8.149038356388534],[38.1807845972068,-8.148472755256964],[38.18094501619125,-8.148013470936519],[38.18109875796506,-8.147698770667294],[38.18121907776341,-8.147464870585502],[38.18132269424164,-8.14737130357845],[38.18151322132886,-8.14728623054705],[38.18168035345376,-8.147252189937518],[38.18180068561647,-8.14718838745569],[38.18187755682344,-8.147048045035985],[38.18195442384704,-8.146856672042963],[38.18205468790032,-8.146644032663659],[38.18212487443235,-8.146516447245437],[38.18278007725277,-8.146890584478273],[38.18257619630264,-8.14721805837711],[38.18243583198115,-8.147613563038231],[38.18221859716568,-8.148187681533397],[38.18181419732701,-8.149212587483575],[38.18151468239992,-8.150001098777555],[38.18038971816028,-8.149386940901088]]', NULL, '2026-04-07 10:52:14'),
(106, 'MMS26', 1, 5, '[[38.18195005556528,-8.146861341809856],[38.1818767769367,-8.147047089074015],[38.18180163875942,-8.147186482568923],[38.18168248194024,-8.147249703930747],[38.18151513705543,-8.147282982719222],[38.18132447415715,-8.147367354052273],[38.1812199498691,-8.14745857564603],[38.18094729793818,-8.147999887356358],[38.18057828569928,-8.149043797389213],[38.18053724776694,-8.149136980206036],[38.18045303047559,-8.149256187734604],[38.18039025293401,-8.14938568400581],[38.17990170090354,-8.149112163834229],[38.1810160563719,-8.145900228995231],[38.18212059769046,-8.146513658702071],[38.18195005556528,-8.146861341809856]]', NULL, '2026-04-07 10:52:14'),
(107, 'MMS27', 1, 1, '[[38.17989563777311,-8.149103658176442],[38.17802740120538,-8.148082530963116],[38.17887558673672,-8.14561693544812],[38.17904139503226,-8.14599066166903],[38.17920383097396,-8.146489856805298],[38.17926501726553,-8.14681372355102],[38.1793038830806,-8.146860726506217],[38.18044870021957,-8.147487140561955],[38.17989563777311,-8.149103658176442]]', NULL, '2026-04-07 10:52:14'),
(108, 'MMS28', 1, 1, '[[38.17720413150174,-8.15069230817836],[38.177187411954,-8.150653658821295],[38.17718484687582,-8.150607556841651],[38.1780288152671,-8.148080537669266],[38.17989407069103,-8.149107166035044],[38.17906371014445,-8.151565123588586],[38.17902002085853,-8.151659887684058],[38.17894791742962,-8.151687782482918],[38.17720413150174,-8.15069230817836]]', NULL, '2026-04-07 10:52:14'),
(109, 'MMS29', 1, 5, '[[38.17541327474181,-8.14573655168039],[38.17568465241573,-8.14600133713734],[38.17646417433276,-8.146700486759766],[38.17744521169736,-8.147594103620435],[38.1774828936417,-8.14766213929382],[38.1777375082183,-8.147808054352485],[38.17775633279648,-8.147749253380704],[38.17805241352607,-8.147909851148738],[38.17770487445051,-8.148954511932466],[38.17749946084839,-8.149567498406027],[38.17718851767832,-8.150501185153914],[38.17713157038352,-8.150629120646103],[38.17420152162323,-8.149017930560335],[38.17509914250397,-8.147375080165142],[38.17541327474181,-8.14573655168039]]', NULL, '2026-04-07 10:52:14'),
(110, 'MMS30', 1, 5, '[[38.17294051725881,-8.147515719347552],[38.17295992501932,-8.147383956609222],[38.17303166919715,-8.147139123201304],[38.17306031661722,-8.147090446662226],[38.17314376078541,-8.14688177081889],[38.17318343421051,-8.146874939432884],[38.17336588579208,-8.146354905186218],[38.1733957730665,-8.146346416684217],[38.17380276568211,-8.146573240794261],[38.17411437376272,-8.145714696672705],[38.17364098302347,-8.145459066773418],[38.17362162752077,-8.145240271000457],[38.17367157515804,-8.145071840070164],[38.17373404845969,-8.144967535885945],[38.17380520185903,-8.14488182839558],[38.17407007556465,-8.144897055388657],[38.17436046467756,-8.144870934910326],[38.17478561141644,-8.145111121907778],[38.17488596538222,-8.145240797332956],[38.17525003850748,-8.145591195209859],[38.17540794687468,-8.145743892062601],[38.17525603514901,-8.14654949571317],[38.17510394964482,-8.147372738903996],[38.17441402233735,-8.148641672022608],[38.17291430819604,-8.147786854420785],[38.17294051725881,-8.147515719347552]]', NULL, '2026-04-07 10:52:14'),
(111, 'MMS31', 1, 6, '[[38.17440543080104,-8.148640873089688],[38.17418532681265,-8.149041809129866],[38.17406817568002,-8.149043880950423],[38.17397610105259,-8.14906253739616],[38.173818501503,-8.149114376181704],[38.17340819711266,-8.149301003151642],[38.1732288578364,-8.149394317785562],[38.17309521990681,-8.149444849116732],[38.17304197762653,-8.149431083387736],[38.17297591149354,-8.149388879960732],[38.17300648662592,-8.149064368477607],[38.17297594038306,-8.148710102881298],[38.17291743702024,-8.148331379867049],[38.17288711027424,-8.148071625528031],[38.1729084515479,-8.147788408544814],[38.17287056703372,-8.147770879904776],[38.17284915720627,-8.148094795771595],[38.17285802611896,-8.14836346953572],[38.17291612252598,-8.148544487767564],[38.1729417995306,-8.148815430851034],[38.17290645401135,-8.149024319193996],[38.17287206246219,-8.149402964400087],[38.17284029214732,-8.149473797606257],[38.1727846061077,-8.149571086496731],[38.17257459557024,-8.149676399177856],[38.17246677425474,-8.149714151899595],[38.17223488758637,-8.149746770148097],[38.1721298228807,-8.14964883828129],[38.17199269363189,-8.14957029231622],[38.17193839714523,-8.149595167422405],[38.17164582718927,-8.149411474835063],[38.1713332393393,-8.149144044848468],[38.17142627749781,-8.148531023470069],[38.17171287118082,-8.14709741893883],[38.17176159027896,-8.146999302078775],[38.17185090690396,-8.146957990955402],[38.17184278785935,-8.146906349803588],[38.17180219058316,-8.146797903016868],[38.1717859516613,-8.146756589957523],[38.17183467083547,-8.146575847123644],[38.17189962822005,-8.14655519164144],[38.17189150907826,-8.146472565792367],[38.17186309078475,-8.146374447330771],[38.17191996956122,-8.146172136543218],[38.17309533362226,-8.146822300992577],[38.1729266456268,-8.147391811917446],[38.17288453192826,-8.14776867980928],[38.17440543080104,-8.148640873089688]]', NULL, '2026-04-07 10:52:14'),
(112, 'MMS32', 1, 5, '[[38.18329089759695,-8.144059744935605],[38.18358091202406,-8.144109258593828],[38.18399622180674,-8.144055332814975],[38.18413973801763,-8.144072529560633],[38.18470837026692,-8.144354974084901],[38.18482687454609,-8.144304286512812],[38.18493201685096,-8.144370662441405],[38.1840653126494,-8.145316475880124],[38.18378433039915,-8.145613555609671],[38.1834231264012,-8.146035715587267],[38.18314817064188,-8.146362751581153],[38.18291675172181,-8.146669225647617],[38.18277960029879,-8.146891318222039],[38.18199846983514,-8.146443129532027],[38.18283628290746,-8.143974028762456],[38.18329089759695,-8.144059744935605]]', NULL, '2026-04-07 10:52:14'),
(113, 'MMS33', 1, 5, '[[38.18101542236059,-8.145900083503522],[38.18160339073007,-8.144160032586898],[38.18166361418525,-8.14404960955316],[38.18173753670136,-8.144015639874691],[38.18283663601017,-8.143969337326576],[38.1819972351266,-8.146446123196883],[38.18101542236059,-8.145900083503522]]', NULL, '2026-04-07 10:52:14'),
(114, 'MMS34', 1, 5, '[[38.18330124504464,-8.14391696384847],[38.18292013779877,-8.143812246279644],[38.18170059753658,-8.143854946973955],[38.18195420585285,-8.143073548026148],[38.18382444181113,-8.143008236583855],[38.18355429989955,-8.143932473645478],[38.18330124504464,-8.14391696384847]]', NULL, '2026-04-07 10:52:14'),
(115, 'MMS35', 1, 5, '[[38.18354777925126,-8.143933419046206],[38.18383140421017,-8.142993913890024],[38.18613614020879,-8.142933814470393],[38.18615340787099,-8.143031755725818],[38.18565513185219,-8.143617379729038],[38.18521652496751,-8.144072852877697],[38.18475366272814,-8.144189085932826],[38.18438824097871,-8.143964391338246],[38.18392537752365,-8.14391016435775],[38.18354777925126,-8.143933419046206]]', NULL, '2026-04-07 10:52:14'),
(116, 'MMS36', 1, 5, '[[38.1804510686296,-8.147484649811078],[38.17931247893662,-8.14686203924012],[38.1792710905999,-8.146815823317061],[38.1792452847651,-8.146685537728512],[38.17921947875644,-8.146555252318633],[38.17921015031131,-8.146498778086032],[38.17904806314539,-8.14600023768654],[38.1788731829294,-8.145605087503915],[38.17934954781362,-8.144170498145357],[38.1794332213003,-8.144062195071958],[38.17977533690313,-8.143971380999576],[38.18024833026124,-8.143896492299495],[38.180817889368,-8.143845783084219],[38.1809881112436,-8.143848175834876],[38.1812987479159,-8.14400866426664],[38.18139729169041,-8.144006466749872],[38.18151989241674,-8.144079354990724],[38.18158630753361,-8.144111614687239],[38.1804510686296,-8.147484649811078]]', NULL, '2026-04-07 10:52:14'),
(117, 'MMS37', 1, 5, '[[38.17754453297409,-8.147555935054706],[38.1772487239534,-8.147280600887152],[38.17662160610831,-8.146690703926463],[38.17594249948239,-8.146081961524906],[38.17547968959475,-8.145666701135012],[38.17471069893976,-8.144877773184014],[38.17505799583099,-8.144877357678864],[38.17539610713467,-8.1448887367729],[38.17572743697445,-8.144922063925039],[38.17597078475533,-8.14495598734691],[38.1761324370355,-8.144984057135932],[38.17624390805845,-8.145000854184126],[38.17644320303388,-8.144979125520557],[38.1765909270031,-8.144917381970904],[38.1767963475927,-8.144804524466103],[38.17682676176713,-8.14478761083236],[38.17685249513443,-8.144808527543772],[38.17682541544149,-8.144853321610618],[38.17684722429278,-8.144871640910125],[38.17686277261326,-8.14497475431447],[38.17690833609853,-8.145061315557374],[38.17690282840857,-8.145156803054622],[38.17686474181755,-8.145220967376678],[38.17688898903883,-8.14530479368922],[38.17687822561693,-8.145395041120508],[38.1769170571695,-8.145451587919991],[38.17698283194084,-8.14544514083996],[38.17706161658841,-8.145325021319511],[38.17705250231488,-8.145245074655941],[38.17699810624423,-8.14518777268813],[38.17703002560828,-8.145164344973123],[38.17704708510429,-8.145117541947288],[38.17700713712105,-8.14502993551361],[38.17700523169648,-8.144888230620811],[38.17689593747877,-8.14482812595044],[38.17685979468865,-8.144779102997553],[38.17735466704234,-8.144590998539353],[38.17776174437206,-8.144472967818146],[38.17819096371998,-8.144369271801313],[38.17843715348778,-8.144299301028497],[38.17902544702225,-8.14415196642437],[38.17926324528662,-8.144099032864695],[38.17933695404969,-8.144139978155723],[38.17806193311861,-8.147906529686033],[38.17775331506393,-8.147738031016615],[38.17754453297409,-8.147555935054706]]', NULL, '2026-04-07 10:52:14'),
(118, 'MMS38', 1, 5, '[[38.1816678514376,-8.143844512382145],[38.18150536248731,-8.143893014105451],[38.18135117611445,-8.143874287720369],[38.18124502459951,-8.143842623712704],[38.18107072099055,-8.143750037398549],[38.18096056127484,-8.14366408887528],[38.18079902045865,-8.143736691961063],[38.18041097347108,-8.143742367236513],[38.18005778762899,-8.143785862077301],[38.17959240266482,-8.143873273012423],[38.17923569415068,-8.143976478878745],[38.17900189660972,-8.144023929536768],[38.17874997041743,-8.144087021358875],[38.17836909863385,-8.144197323985187],[38.17853747274494,-8.143184964635747],[38.18018160658319,-8.143103697587845],[38.18173657159865,-8.14307815356336],[38.18189653242954,-8.143138871295712],[38.1816678514376,-8.143844512382145]]', NULL, '2026-04-07 10:52:14'),
(119, 'MMS39', 1, 5, '[[38.17772278187855,-8.14437960218743],[38.17694879633235,-8.144627216598664],[38.17633461145665,-8.144902245819722],[38.1759843365108,-8.144838822086767],[38.17519068218014,-8.14475673582448],[38.17557750447608,-8.143214168000014],[38.17853069349167,-8.143200860355527],[38.17836310327533,-8.144202417174897],[38.17772278187855,-8.14437960218743]]', NULL, '2026-04-07 10:52:14'),
(120, 'MMS40', 1, 5, '[[38.17389607620999,-8.14479567794034],[38.17422761576819,-8.144059128511882],[38.17446840594651,-8.143210626880466],[38.17557134478956,-8.143214017731466],[38.17518428600671,-8.144772256572656],[38.17389607620999,-8.14479567794034]]', NULL, '2026-04-07 10:52:14'),
(121, 'MMS41', 1, 5, '[[38.17422217549546,-8.14406846399409],[38.17389994551678,-8.14479600654951],[38.17352671422215,-8.144767768410134],[38.17306326609742,-8.144465840334403],[38.17294702884942,-8.143915993395213],[38.17295499807639,-8.14381195958128],[38.17332882728651,-8.143450691917675],[38.17363123324611,-8.143235519206955],[38.17400678200173,-8.143267004063048],[38.17446078079458,-8.14323288765417],[38.17422217549546,-8.14406846399409]]', NULL, '2026-04-07 10:52:14'),
(122, 'VCS12', 1, 2, '[[38.18467312768664,-8.163573616778358],[38.18417800938166,-8.16531922491013],[38.18409410423087,-8.165327382018758],[38.18410156439442,-8.165055920456698],[38.18408388232234,-8.164501457595893],[38.1843927063862,-8.16450814006846],[38.18465513259255,-8.163567889501305],[38.18415142321179,-8.163493871888406],[38.18407342880789,-8.163406004876638],[38.18407362715527,-8.160130037042974],[38.18541049517603,-8.160116010386918],[38.18531615892942,-8.160460749422075],[38.18523293989414,-8.160725189921354],[38.18516441929508,-8.160912517969898],[38.18510244445509,-8.161154138382305],[38.1851154509206,-8.16142466564096],[38.18479967581905,-8.163068850616598],[38.18469404204572,-8.163298699294819],[38.18467312768664,-8.163573616778358]]', NULL, '2026-04-07 10:52:14'),
(123, 'VCS13', 1, 2, '[[38.18539460245626,-8.160122846468049],[38.1840788868845,-8.160116509613648],[38.18408125035651,-8.159984156064477],[38.18421778426913,-8.15998496656857],[38.18433291947942,-8.159932892795718],[38.18448631375272,-8.159797068691663],[38.18469792554995,-8.159498592485802],[38.18462281580766,-8.159371108385546],[38.18442679896151,-8.159453170923731],[38.1842730641215,-8.159487756408767],[38.18423624642787,-8.15958244916831],[38.184236564491,-8.159676939432773],[38.18406686892232,-8.159698112119237],[38.18405558800715,-8.157852747025684],[38.18653519197873,-8.157938821954179],[38.18645481505323,-8.15829465043456],[38.18637609985676,-8.158551572592756],[38.18634504091541,-8.158781233678596],[38.18625532903613,-8.158923468436628],[38.18600142865656,-8.15914759583099],[38.18577389606831,-8.159324329256885],[38.18552004283394,-8.159561950337267],[38.18539460245626,-8.160122846468049]]', NULL, '2026-04-07 10:52:14'),
(124, 'VCS15', 1, 2, '[[38.18233984855418,-8.172500985182438],[38.18232041107652,-8.16995864428909],[38.18243591312972,-8.169964861902864],[38.18246956698471,-8.170021964889195],[38.18277428920842,-8.170042099945276],[38.18283347600658,-8.170105378973513],[38.18339229815336,-8.170129141595053],[38.18352910109554,-8.170172279847783],[38.18367843430161,-8.170200202863743],[38.18375447263455,-8.170269270701443],[38.18376183287226,-8.170368716578016],[38.18374438949148,-8.17049247600668],[38.18307322722622,-8.172159526796431],[38.18299096720631,-8.172264913152334],[38.18273300587439,-8.172378181817502],[38.18233984855418,-8.172500985182438]]', NULL, '2026-04-07 10:52:14'),
(125, 'VCS16', 1, 2, '[[38.18336749197702,-8.169876288733136],[38.18289477563982,-8.169870614197833],[38.18254037133962,-8.169853707868347],[38.18225060720954,-8.169797275720603],[38.18212862063584,-8.169630511680065],[38.1821145557222,-8.169219226787083],[38.18219065954106,-8.169112858533747],[38.18228822113745,-8.169081268689277],[38.18229805672343,-8.16851013642099],[38.18240876618449,-8.168511218687666],[38.18270211522658,-8.16856108568063],[38.18276426129982,-8.168665478509341],[38.1828351497733,-8.168738766388268],[38.18291302699507,-8.168687141271596],[38.18288556472098,-8.168484843020735],[38.18291714071264,-8.168321684927749],[38.18295044212294,-8.168046468142427],[38.18326255163446,-8.16805738078125],[38.183492640518,-8.167837756579136],[38.18370541196295,-8.167854422278186],[38.18372298372677,-8.168053582683964],[38.18375402421234,-8.168489731816242],[38.1830396379247,-8.16891756130479],[38.18296174110188,-8.16906377315209],[38.18336749197702,-8.169876288733136]]', NULL, '2026-04-07 10:52:14'),
(126, 'VCS17', 1, 2, '[[38.18367796878596,-8.167633754237645],[38.18353492100043,-8.167742632073882],[38.18342602995902,-8.167886703055526],[38.18293957024833,-8.16779945175858],[38.18293394769398,-8.167488068986792],[38.18279982338953,-8.167097867945865],[38.18265590203256,-8.166982932407098],[38.18230098912102,-8.166954282608724],[38.18229836008929,-8.165611588111677],[38.18230983169671,-8.164190870703559],[38.182703531949,-8.16419906092557],[38.18269786586565,-8.164280596644007],[38.18287888980842,-8.164286022554597],[38.18287345616132,-8.164176379579558],[38.18318042280246,-8.164184608471906],[38.1832333438312,-8.164330681870123],[38.18337269039151,-8.164370863567273],[38.18342241278503,-8.164435273122132],[38.18355163800123,-8.164481270747752],[38.18402513495371,-8.164582056536085],[38.18404247645891,-8.165661922740913],[38.18400622765671,-8.165712956543507],[38.18395439145248,-8.16609839369723],[38.18369700218214,-8.166964689510024],[38.1837121049232,-8.167504527315183],[38.18367796878596,-8.167633754237645]]', NULL, '2026-04-07 10:52:14'),
(127, 'VCS18', 1, 2, '[[38.18402433240927,-8.162549841573405],[38.18321910054059,-8.162510101258507],[38.18311866568613,-8.162134760444747],[38.18294686597924,-8.162127285525484],[38.18293730607343,-8.16243682887054],[38.18228964277935,-8.162446725693801],[38.18227024711381,-8.162049136541059],[38.18227780184911,-8.161318351755744],[38.18289303817725,-8.161324533955597],[38.18297082682916,-8.161312167619641],[38.1830048573955,-8.161213235610576],[38.18299999907189,-8.161145206320375],[38.18288326376094,-8.160999850125304],[38.18278618780558,-8.160869965910491],[38.18278937444212,-8.160697361325017],[38.18279208874853,-8.16061431231341],[38.18267845245757,-8.160546696635752],[38.18255999952014,-8.16045134432964],[38.18229207514572,-8.160459628266917],[38.18227821208552,-8.160130041890177],[38.18369345509522,-8.160131693434888],[38.18374737155625,-8.160277025720983],[38.18400374054303,-8.160282739095727],[38.18402433240927,-8.162549841573405]]', NULL, '2026-04-07 10:52:14'),
(128, 'VCS19', 1, 2, '[[38.183695167407,-8.160128238320153],[38.18227450162505,-8.160135344018594],[38.18228636749596,-8.160043329882743],[38.18240051353351,-8.16001364029978],[38.182422990627,-8.15990305738968],[38.18239059145501,-8.159781145777426],[38.18236289890025,-8.159699904533804],[38.18227609312443,-8.159706190862382],[38.18227480513175,-8.158101302553014],[38.18240592632879,-8.158092421823941],[38.1826656904303,-8.15813228480276],[38.18271117697962,-8.158385178562842],[38.18252061410894,-8.158492260103058],[38.18271799150231,-8.158759073576313],[38.18287429878267,-8.15859489872415],[38.18318208912174,-8.158594792459443],[38.18328011086362,-8.158353465200666],[38.1833877281318,-8.158328087799326],[38.18342152130099,-8.158383486908097],[38.18335448711743,-8.158486221889978],[38.18340884911628,-8.1585431896073],[38.18367054278691,-8.15853172657162],[38.1837163570124,-8.15829489668545],[38.18342968049468,-8.15827518042991],[38.18350885415716,-8.158025080853951],[38.18369115546468,-8.157878733046688],[38.18400608796261,-8.157852851295596],[38.18399876162486,-8.158439248010582],[38.1838611849465,-8.158412310822152],[38.1838302110207,-8.158563552157307],[38.18401753254361,-8.158640956851462],[38.18401729906655,-8.159748789918954],[38.18367866506726,-8.159748790402046],[38.18359191577629,-8.160033301076817],[38.183695167407,-8.160128238320153]]', NULL, '2026-04-07 10:52:14'),
(129, 'VCS20', 1, 2, '[[38.18154586851286,-8.173319736767228],[38.18111929301714,-8.173319829850739],[38.18070352780245,-8.173312459860961],[38.18051901961006,-8.173860694912378],[38.18053523304412,-8.174234286481948],[38.1805872500742,-8.174230921838923],[38.18107531390901,-8.174243154386737],[38.18109397372299,-8.174654328978113],[38.18122393147752,-8.175019709958784],[38.18081410021109,-8.174992883633962],[38.18076526943508,-8.174829968229325],[38.18053154954174,-8.174599021475684],[38.18050961448171,-8.173859571603362],[38.18069197635903,-8.173308330381122],[38.1806169387779,-8.173253045163689],[38.18055010464035,-8.173131551964378],[38.18051768337394,-8.172998748609535],[38.18051254497385,-8.172887485522741],[38.18054409449493,-8.172815392842855],[38.1805626397107,-8.1726948347955],[38.18050535632342,-8.172550584159833],[38.18049239111888,-8.172446253673103],[38.18222301012901,-8.17249827036159],[38.18221330129429,-8.172555641997253],[38.18199969940595,-8.172598451209657],[38.18184141029221,-8.172748857567116],[38.18154586851286,-8.173319736767228]]', NULL, '2026-04-07 10:52:14'),
(130, 'VCS21', 1, 2, '[[38.1804986774308,-8.172438189950824],[38.18050869310502,-8.168955479838193],[38.18067223701544,-8.168967978116475],[38.18068444194633,-8.169038154330215],[38.18091881351945,-8.169041620366233],[38.18099698594361,-8.169102251640254],[38.18112259998346,-8.169187820932196],[38.18127151367552,-8.16925120290191],[38.18142283528975,-8.169249751602658],[38.18171772830961,-8.169245903217888],[38.1817574720615,-8.169371049411575],[38.18161859485922,-8.169405671585784],[38.18160911121063,-8.16951424565405],[38.18166087846097,-8.169523848992364],[38.18166315024951,-8.169605339852353],[38.18182137019753,-8.169604388469121],[38.18192157528574,-8.1696101818604],[38.18203673416412,-8.169828106249783],[38.18214685404976,-8.16991298231473],[38.18227897709783,-8.1699930256237],[38.18229208231015,-8.172507669490995],[38.1804986774308,-8.172438189950824]]', NULL, '2026-04-07 10:52:14'),
(131, 'VCS22', 1, 2, '[[38.18198112239737,-8.168225055984342],[38.18187888131438,-8.168574505341002],[38.18169291454482,-8.168851969630516],[38.18168308813586,-8.169072130406198],[38.18139412973305,-8.169077545309483],[38.18115914293317,-8.169029823997132],[38.1809682652453,-8.168876311577835],[38.18057176893592,-8.168780237994715],[38.1804944416496,-8.168734830590779],[38.18047191648417,-8.168609872045899],[38.18065780863343,-8.168290711887106],[38.18080549979886,-8.168286566469936],[38.18088906455353,-8.168261442639],[38.18087337064841,-8.168182979228652],[38.18074547859565,-8.168135686164117],[38.18088830145491,-8.167887328819917],[38.18105214844614,-8.167887349265202],[38.18119909914419,-8.16779395555036],[38.18116724122717,-8.167728960458223],[38.18103958878589,-8.16763551602743],[38.1810592435386,-8.16757877140345],[38.18119634360922,-8.167590950798832],[38.18130594170981,-8.167420924253788],[38.18139543875613,-8.167275074450844],[38.18153557599743,-8.16722634091336],[38.18182902664381,-8.167246930389641],[38.18200132753346,-8.167259684195255],[38.18202664914448,-8.167344428425316],[38.18191427360873,-8.167794132793901],[38.18183429134235,-8.167903826729356],[38.1817160511122,-8.167915992916903],[38.18166168917709,-8.167997275788887],[38.18200691674176,-8.168046011922694],[38.18198112239737,-8.168225055984342]]', NULL, '2026-04-07 10:52:14');
INSERT INTO `campos` (`id`, `nome`, `cultura_id`, `variedade_id`, `coordenadas_geojson`, `area_hectares`, `data_importacao`) VALUES
(132, 'VCS23', 1, 2, '[[38.18221934537551,-8.162050804352358],[38.18220736746442,-8.162528767070423],[38.18221537393995,-8.1641855802186],[38.18226775347539,-8.164190718580116],[38.18226561833433,-8.16587461114691],[38.18201950662993,-8.165838592858657],[38.18191975869821,-8.16566009069137],[38.18175773303984,-8.165703785085302],[38.18177775567556,-8.165838095409496],[38.18074133520729,-8.165827681270665],[38.18073608687646,-8.165567915147022],[38.180566086078,-8.165555537414274],[38.1805673897685,-8.165738070896634],[38.18074088969068,-8.165742394890845],[38.18074311078133,-8.165825760745056],[38.18047569908661,-8.165817532968626],[38.18047817430622,-8.165420179478094],[38.18046689627184,-8.163845652405001],[38.18128844695516,-8.163850655631585],[38.1816424446467,-8.163823722078677],[38.18186544039348,-8.163839204387372],[38.18203008985211,-8.164055208545182],[38.1820101136212,-8.164194486070604],[38.18219672296755,-8.164209030946529],[38.18219406855853,-8.162557790843177],[38.18207559772268,-8.162374018433598],[38.18184429830019,-8.162231324514467],[38.1818021970838,-8.161822751486097],[38.18122703284255,-8.161710712896971],[38.18128890673054,-8.161766927658716],[38.18142746833181,-8.16178737871025],[38.18144668605981,-8.161891854252216],[38.18147469232351,-8.161958519720692],[38.18181506487834,-8.161994386022121],[38.1818403463752,-8.162212407981578],[38.18175767261422,-8.16222916652369],[38.18175762776628,-8.162177195850017],[38.18161287787864,-8.162180050466969],[38.18153251008106,-8.162249997501464],[38.18160164559627,-8.16236582700812],[38.18164073900792,-8.162525767504187],[38.18149437785051,-8.162658156282607],[38.18146254631825,-8.162770793732633],[38.18092003623956,-8.162761962605394],[38.18072897084824,-8.162670079869025],[38.18045493776672,-8.16268534430552],[38.18045300390669,-8.162450258450278],[38.18069350466271,-8.162453356980311],[38.18076086227828,-8.162446491390963],[38.18077752978931,-8.162589905519157],[38.18079011116044,-8.162669342745893],[38.18074718524826,-8.162660262429803],[38.18071877548214,-8.162477821293725],[38.18075572868269,-8.16229527799518],[38.18080779548507,-8.162243831292121],[38.1808452513373,-8.162163911611707],[38.18076423985643,-8.162045498035912],[38.18076517389397,-8.162004091583405],[38.18073068173904,-8.161907910987697],[38.18068094057513,-8.16185851978533],[38.18059785916736,-8.16184890591454],[38.18054280595058,-8.161861434255066],[38.18058905192289,-8.161961898233251],[38.18061523692572,-8.162008645522791],[38.18064626644818,-8.162096745041481],[38.18064529133134,-8.162218032925209],[38.18060982000171,-8.162317918663959],[38.1805244249282,-8.162337019509135],[38.18046427966002,-8.162328714634516],[38.18046216530472,-8.16161394825594],[38.18221795663326,-8.161636250788112],[38.18221934537551,-8.162050804352358]]', NULL, '2026-04-07 10:52:14'),
(133, 'VCS24', 1, 2, '[[38.18113428688714,-8.160143250188431],[38.18121531353088,-8.16023082660493],[38.18126941160343,-8.160272340503859],[38.1812982177237,-8.160327336360318],[38.18184134664009,-8.160332158860516],[38.18190619455469,-8.16048741218946],[38.18178032866071,-8.160564882836708],[38.18148863213491,-8.16060122558416],[38.18139855671031,-8.160642426964715],[38.18096646492441,-8.160651634652298],[38.18096273241747,-8.160766113881705],[38.18116471881563,-8.161207892610673],[38.1822330136749,-8.161268197713015],[38.18223070728119,-8.161532375354358],[38.18045942754543,-8.161507377561833],[38.18045796121908,-8.15991872166293],[38.18130877143563,-8.159942172519097],[38.18113428688714,-8.160143250188431]]', NULL, '2026-04-07 10:52:14'),
(134, 'VCS25', 1, 2, '[[38.18046723950419,-8.159933868149924],[38.18046495165011,-8.159541905213757],[38.18048732021271,-8.159425405760421],[38.18069556140329,-8.159441437029745],[38.18072514755919,-8.159223569642073],[38.18052575579497,-8.159224468274562],[38.1805865656334,-8.15905868240395],[38.18071458136789,-8.158804582324903],[38.18081694438316,-8.158561108999052],[38.18092524074545,-8.15833177779981],[38.18090246226956,-8.158003185321384],[38.18088228240055,-8.157676762084353],[38.18209843205342,-8.15767005894678],[38.18221566133133,-8.157333235378402],[38.1827309885235,-8.157349260545596],[38.18268735102578,-8.15757433653851],[38.18249534833412,-8.15757239672397],[38.18243451623364,-8.157625353172847],[38.18233863848289,-8.157640775402669],[38.18232300766329,-8.157929903771667],[38.18237487778662,-8.157969106570983],[38.18236682935741,-8.158066596100621],[38.18222169203774,-8.158065089128055],[38.18224272518027,-8.160114075184788],[38.1820999601711,-8.160107120602568],[38.18205604596456,-8.159893989892957],[38.18196270657853,-8.15981000860975],[38.18184850898281,-8.159612136668398],[38.18166995177677,-8.15960420283388],[38.18163608532415,-8.159942843962648],[38.18046723950419,-8.159933868149924]]', NULL, '2026-04-07 10:52:14'),
(135, 'VCS26', 1, 2, '[[38.18045409580681,-8.173011075393719],[38.18019901268003,-8.173207908889331],[38.18021650230284,-8.17370579595112],[38.17999637231479,-8.173687518556282],[38.17989616789775,-8.173839633006029],[38.17992540174455,-8.174030591271478],[38.18004733456701,-8.174130057825712],[38.18023007458021,-8.17413515187885],[38.18024791463843,-8.174093208986502],[38.18047029363866,-8.174106152771266],[38.18044857588557,-8.174328167935158],[38.18046067341333,-8.174383806773486],[38.17997992586914,-8.174355462642742],[38.17971880850575,-8.174295592846333],[38.17969122668404,-8.174614259171939],[38.179805976392,-8.174704664009935],[38.18003494544919,-8.174721665206556],[38.18022120034723,-8.174802596326762],[38.1804807817096,-8.174863255298487],[38.18048077609787,-8.17518964515401],[38.18044729762438,-8.175289281310365],[38.18026562407095,-8.175266504232502],[38.18017969410843,-8.17523965082977],[38.18009412675713,-8.17535744273574],[38.17937108767013,-8.175161977883295],[38.17933238132292,-8.175079495238611],[38.17922219714303,-8.174951530334537],[38.17912453540801,-8.174908486670585],[38.17899199647065,-8.174889390432464],[38.17882251763575,-8.17489200188122],[38.17877110550249,-8.174822262622843],[38.17864043414086,-8.174856389556451],[38.17856215721208,-8.174984209099462],[38.17850923472952,-8.174932444073747],[38.1784824555009,-8.17246382262119],[38.18044440155423,-8.172503601804157],[38.18045409580681,-8.173011075393719]]', NULL, '2026-04-07 10:52:14'),
(136, 'VCS27', 1, 2, '[[38.18044768261701,-8.172510225259991],[38.17847527252007,-8.172454760424298],[38.17848153456624,-8.170415202918234],[38.17940546711475,-8.170496491814866],[38.18020946440553,-8.169048805164259],[38.18033782129309,-8.168891953047945],[38.18045730486937,-8.168884829957017],[38.18044768261701,-8.172510225259991]]', NULL, '2026-04-07 10:52:14'),
(137, 'VCS28', 1, 2, '[[38.17852256440223,-8.16608662679104],[38.17849646153005,-8.166021487192026],[38.17849839537765,-8.1639258797874],[38.17879966640329,-8.163212828389652],[38.17907856623845,-8.163527707632351],[38.17940939709717,-8.163708720910899],[38.17966762027389,-8.16380694213724],[38.17976327754535,-8.1638396387468],[38.18043861771003,-8.163869635824742],[38.18042958775955,-8.164786478263222],[38.18032377626691,-8.164843521013855],[38.18032757680702,-8.16492610461726],[38.18043826886382,-8.164960625272284],[38.18041675753793,-8.165616110811193],[38.18015114963317,-8.165610272200977],[38.18002437961053,-8.165362950216284],[38.17975717152073,-8.165326009369243],[38.17967378040543,-8.165328359285775],[38.1796651880703,-8.165270861839621],[38.17958358743501,-8.165268687478859],[38.17956204798337,-8.165439572759135],[38.17936801627643,-8.165465468818223],[38.17936256927845,-8.165558481309672],[38.1793078048406,-8.165661161010144],[38.17908954316399,-8.165657494365167],[38.1790394439894,-8.16581147622509],[38.17890415793316,-8.165908043320648],[38.17890331935338,-8.166120922360903],[38.17852256440223,-8.16608662679104]]', NULL, '2026-04-07 10:52:14'),
(138, 'VCS29', 1, 2, '[[38.17946168580884,-8.163598409427061],[38.17941588933135,-8.16352846868961],[38.17930127226958,-8.163508764843394],[38.17919992034761,-8.163442954177007],[38.17910801648879,-8.163360782854362],[38.17903609228183,-8.163290479522995],[38.17890374172808,-8.163105205083506],[38.17886757427782,-8.163072143468879],[38.17940126464947,-8.161726917208235],[38.18035594550661,-8.159573169273118],[38.18040830634807,-8.159558369746204],[38.18040370011746,-8.160941005499373],[38.18042679455419,-8.160996848526885],[38.18040418946173,-8.162879222822971],[38.18010877238714,-8.162858316970112],[38.18002027039388,-8.162889816802364],[38.18002818292972,-8.163054486634206],[38.18000425953132,-8.163399027652131],[38.17992327930556,-8.163438911534747],[38.1798666633219,-8.163559601503337],[38.1798279113874,-8.163602536322847],[38.17946168580884,-8.163598409427061]]', NULL, '2026-04-07 10:52:14'),
(139, 'VCS30', 1, 1, '[[38.17852748585722,-8.160377510870475],[38.17983186295476,-8.160379331124062],[38.17926322133263,-8.161653957483912],[38.17891617715802,-8.162473656496989],[38.17844881123786,-8.163558789769176],[38.17845636494557,-8.162478390539995],[38.17851147110262,-8.16237165961123],[38.17852748585722,-8.160377510870475]]', NULL, '2026-04-07 10:52:14'),
(140, 'VCS31', 1, 1, '[[38.17982245154018,-8.1603770295772],[38.17850181464749,-8.160374046695647],[38.1785148678646,-8.158020947435254],[38.18070417795744,-8.158069679014186],[38.1807737858766,-8.158110395592136],[38.18038712596077,-8.158415305689955],[38.18044241512879,-8.158588350522919],[38.18056402778207,-8.158620342327504],[38.18057683076011,-8.158670642017727],[38.17982245154018,-8.1603770295772]]', NULL, '2026-04-07 10:52:14'),
(141, 'VCS32', 1, 2, '[[38.17846386165101,-8.174953000917553],[38.17816550821628,-8.174911988539929],[38.17810454400481,-8.174134152689948],[38.1779721285371,-8.173362260618989],[38.17808410136993,-8.173352839337614],[38.17805759338837,-8.173206041269381],[38.17796296129769,-8.173225651744875],[38.17784236016703,-8.172640241436696],[38.17763235075163,-8.172076636598856],[38.17760166417802,-8.171658174261944],[38.1776206871241,-8.171221725649763],[38.17811406854428,-8.171217321531582],[38.17804291076207,-8.170974240164218],[38.17795478893256,-8.17073792638902],[38.17779240941351,-8.170321840936198],[38.17812371030309,-8.170342416783873],[38.17814047990844,-8.17039926498564],[38.17845274204021,-8.170420032441214],[38.17846386165101,-8.174953000917553]]', NULL, '2026-04-07 10:52:14'),
(142, 'VCS33', 1, 2, '[[38.17815381628456,-8.16602201791824],[38.1780482746013,-8.165901966163212],[38.17800288797912,-8.165740447036008],[38.17799490429129,-8.165567132103183],[38.17799179928544,-8.165384471842566],[38.1780577583024,-8.16501544957784],[38.1781239340124,-8.164753780070619],[38.17821918916822,-8.164485809746637],[38.17838177320218,-8.164117124291772],[38.17844936273888,-8.164086128303925],[38.17845105365626,-8.166037728645497],[38.17815381628456,-8.16602201791824]]', NULL, '2026-04-07 10:52:14'),
(143, 'VCS34', 1, 1, '[[38.17804950920535,-8.169454169777346],[38.17784994408844,-8.169786189160712],[38.17766363644775,-8.169798895040062],[38.17759462400527,-8.169767726410234],[38.17732941766675,-8.169649831435981],[38.17690673916008,-8.169438203282409],[38.17627348161953,-8.168897611484324],[38.17626384422914,-8.167611630075593],[38.17748507063871,-8.167621501260152],[38.17761127007901,-8.167890253633338],[38.17778912634712,-8.168241651701912],[38.17800861746936,-8.168527040603893],[38.1780748007859,-8.168687616061153],[38.1781167788376,-8.168871531555727],[38.17811724949442,-8.1691751411917],[38.17804950920535,-8.169454169777346]]', NULL, '2026-04-07 10:52:14'),
(144, 'VCS35', 1, 1, '[[38.17748436759554,-8.167612028215105],[38.17626582265122,-8.167609564951901],[38.17625476909283,-8.164933171307144],[38.17643799632308,-8.164936374892491],[38.17670481729689,-8.16534125699052],[38.17689998979215,-8.165605915161617],[38.17718830832532,-8.165761854022932],[38.17746482963391,-8.165903415366518],[38.17785956663756,-8.16610834730252],[38.17779448746658,-8.166222735262284],[38.1776322801669,-8.166445011821533],[38.17752382565592,-8.166755951747609],[38.17745869609173,-8.16721794270441],[38.17748436759554,-8.167612028215105]]', NULL, '2026-04-07 10:52:14'),
(145, 'VCS36', 1, 1, '[[38.17789209463555,-8.165908597737051],[38.17773597900475,-8.165897165413003],[38.17754196189212,-8.165778377791005],[38.17737509486507,-8.16569307540644],[38.17710636957788,-8.165573819555954],[38.17695899722606,-8.165471805569556],[38.17683155577696,-8.165308697163296],[38.17653815929248,-8.164873845038207],[38.17624256693336,-8.164539145560063],[38.17624115453696,-8.16373713141173],[38.17663420770938,-8.163736721789505],[38.17668731983942,-8.163805395321365],[38.17675954794114,-8.163805333107112],[38.17679271795036,-8.163792039217173],[38.17790155633326,-8.163795478309833],[38.17833309073617,-8.163800519120443],[38.17802863398153,-8.164620748631593],[38.17794933682242,-8.164893668979875],[38.1778256891996,-8.165315531424962],[38.17785904860205,-8.165712378684995],[38.17789209463555,-8.165908597737051]]', NULL, '2026-04-07 10:52:14'),
(146, 'VCS37', 1, 1, '[[38.17844857342392,-8.163557249039393],[38.17833484800396,-8.163787604268075],[38.17679842624975,-8.163786177728058],[38.17681671419992,-8.163737161834124],[38.17683145214006,-8.163641695022768],[38.176738388483,-8.163558177849351],[38.17665170942207,-8.16355635147328],[38.17660819290202,-8.163675669903427],[38.17662957244159,-8.163736022839696],[38.17624052483441,-8.163739024304512],[38.17623353724247,-8.160771056892624],[38.1784642034504,-8.160794067276633],[38.17844857342392,-8.163557249039393]]', NULL, '2026-04-07 10:52:14'),
(147, 'VCS38', 1, 1, '[[38.17846712427428,-8.16079394239352],[38.17623467231419,-8.16077230282689],[38.17623636903468,-8.157971136229374],[38.17846887918903,-8.158021523241827],[38.17846712427428,-8.16079394239352]]', NULL, '2026-04-07 10:52:14'),
(148, 'VCS39', 1, 3, '[[38.17394882449741,-8.16720898016497],[38.17620145427754,-8.167260220970288],[38.17620737060462,-8.169097160598037],[38.17617115415434,-8.169191849176615],[38.17611415685963,-8.16924515803665],[38.17558959158882,-8.169603205739438],[38.1753233331225,-8.169784826086879],[38.17521998699251,-8.169866061472208],[38.17507597957692,-8.169969728156664],[38.17493699434969,-8.17007650361351],[38.17458938530719,-8.170363677655226],[38.17443479152147,-8.170472960930246],[38.17411116813258,-8.170720244932392],[38.17405336330291,-8.170753880450782],[38.17402334179882,-8.170714882758366],[38.17394288373231,-8.170665083393375],[38.17394882449741,-8.16720898016497]]', NULL, '2026-04-07 10:52:14'),
(149, 'VCS40', 1, 3, '[[38.17394725003133,-8.167199948510076],[38.17394988710495,-8.165877798647184],[38.17433169010124,-8.165810626084332],[38.17469271278389,-8.165752582936273],[38.17508074856899,-8.165601307087895],[38.17554475979103,-8.165391495549931],[38.1759291320806,-8.165218155205924],[38.1762049279215,-8.1649490287419],[38.17620367218928,-8.16724844745078],[38.17394725003133,-8.167199948510076]]', NULL, '2026-04-07 10:52:14'),
(150, 'VCS41', 1, 3, '[[38.17620706464854,-8.164669124738644],[38.17604673266882,-8.164864865195018],[38.17590773166482,-8.164965990431552],[38.17573082831435,-8.16505210013357],[38.17552519715093,-8.165170167023266],[38.17530341279095,-8.165291077146959],[38.17514510215431,-8.165361397471482],[38.17497033836585,-8.165449570310303],[38.17476703722745,-8.165499459885513],[38.17457913836786,-8.165562548876705],[38.17442260973595,-8.165597847744094],[38.17418909175388,-8.16565428175321],[38.17394838869027,-8.165663810756897],[38.17393287487796,-8.163061995139422],[38.17620961512556,-8.163033257180919],[38.17620706464854,-8.164669124738644]]', NULL, '2026-04-07 10:52:14'),
(151, 'VCS42', 1, 3, '[[38.17393739127373,-8.16305624109535],[38.17391729161162,-8.16070817821638],[38.17619978573359,-8.160744827393723],[38.17621294150241,-8.16303176081214],[38.17393739127373,-8.16305624109535]]', NULL, '2026-04-07 10:52:14'),
(152, 'VCS43', 1, 3, '[[38.17392202866157,-8.16070453481392],[38.17392346374736,-8.157916871097376],[38.17619772896383,-8.157977909812278],[38.17620251296497,-8.16074123881235],[38.17392202866157,-8.16070453481392]]', NULL, '2026-04-07 10:52:14'),
(153, 'VCS44', 1, 3, '[[38.17210448989654,-8.172380707031929],[38.17197343132335,-8.172378339412038],[38.17196368078102,-8.168750214065852],[38.17391707116565,-8.168754516534175],[38.17392068497809,-8.170885672447678],[38.17217496903417,-8.17248183048445],[38.17212498262865,-8.1724465748863],[38.17210448989654,-8.172380707031929]]', NULL, '2026-04-07 10:52:14'),
(154, 'VCS45', 1, 3, '[[38.17392260439996,-8.168751897238094],[38.17196610754342,-8.168752186022491],[38.17194080921116,-8.165552018497117],[38.17390748113993,-8.16553965651276],[38.17392260439996,-8.168751897238094]]', NULL, '2026-04-07 10:52:14'),
(155, 'VCS46', 1, 3, '[[38.17051391553925,-8.16556157486983],[38.1707820551093,-8.165331901759359],[38.17098843420423,-8.165191909153851],[38.17117900447834,-8.165125638780893],[38.17128873335732,-8.165111025872179],[38.17129839618156,-8.16496026332736],[38.17137217453081,-8.164799683425585],[38.17145931377453,-8.16463259688722],[38.17157159343702,-8.16442389512151],[38.17164430335385,-8.164153802121875],[38.17167890410024,-8.163711564301021],[38.171686112869,-8.163456861604958],[38.17170991150478,-8.163232200953185],[38.17173826261331,-8.163110295802062],[38.17389142321412,-8.163070489628035],[38.17390877404365,-8.164344430190276],[38.17390161900492,-8.165537837220374],[38.17051391553925,-8.16556157486983]]', NULL, '2026-04-07 10:52:14'),
(156, 'VCS47', 1, 3, '[[38.17173927629789,-8.163105026469161],[38.17176753060055,-8.162725527069925],[38.17179887270675,-8.162455952506214],[38.17184074847223,-8.162071494213423],[38.17189058736528,-8.16164103184831],[38.17191715608445,-8.161227912619335],[38.17194827132824,-8.16095515060486],[38.17200118067132,-8.160715599240145],[38.17240326945527,-8.160758585942503],[38.17246864908105,-8.160699662380663],[38.17389375962272,-8.160703976158487],[38.17390999279071,-8.16306974165787],[38.17173927629789,-8.163105026469161]]', NULL, '2026-04-07 10:52:14'),
(157, 'VCS48', 1, 3, '[[38.17246408928859,-8.160702387848763],[38.17238211364967,-8.160505559383717],[38.1722962601991,-8.160094577308886],[38.17198998864976,-8.160066278955515],[38.17194698997448,-8.159892460623087],[38.17189594072855,-8.159599127910587],[38.17188078235829,-8.159328383921618],[38.1718560067857,-8.159009148185422],[38.17181663681497,-8.158710069104991],[38.17181066413096,-8.158435374075909],[38.17176697867247,-8.158155586723732],[38.17166634196273,-8.157865964888718],[38.17388834901865,-8.157913245051413],[38.17389191434537,-8.160702235381706],[38.17246408928859,-8.160702387848763]]', NULL, '2026-04-07 10:52:14'),
(158, 'VCS49', 1, 3, '[[38.17194300355612,-8.172642515357408],[38.17186915613161,-8.172677445584219],[38.17167837790239,-8.172415964921086],[38.17130661874671,-8.171843225741455],[38.17123324284668,-8.171743617696203],[38.17114518561875,-8.171656453161512],[38.17104243861583,-8.17162529982668],[38.16960398606681,-8.17118295195394],[38.1695550756931,-8.171083356501613],[38.16954043084057,-8.170909086319929],[38.16954572439464,-8.168730791539026],[38.17193216151522,-8.168739425762942],[38.17194300355612,-8.172642515357408]]', NULL, '2026-04-07 10:52:14'),
(159, 'VCS50', 1, 3, '[[38.16954106468347,-8.168723225272243],[38.16955993523921,-8.168558892737693],[38.16958957024595,-8.168404834323667],[38.16964615293773,-8.16806590462502],[38.16970541107623,-8.167815991834429],[38.1698077401727,-8.167531853749878],[38.16994799823344,-8.16723385901493],[38.17014843661009,-8.166846881019932],[38.17025979052894,-8.166629795243097],[38.17032392603371,-8.166334339441661],[38.17021654141133,-8.166229640217821],[38.17017381443426,-8.166178644180867],[38.17024727783806,-8.166004278700994],[38.17036101338049,-8.165761314320738],[38.17050231936234,-8.165563336836023],[38.17060137171475,-8.165567561348773],[38.17067773578263,-8.165564828548566],[38.17190721764512,-8.165568061660874],[38.17192729423436,-8.168738109861435],[38.16954106468347,-8.168723225272243]]', NULL, '2026-04-07 10:52:14'),
(160, 'VCS51', 1, 3, '[[38.16864988193195,-8.171014619684795],[38.16848352081995,-8.171014568044884],[38.16714773914108,-8.17099549001224],[38.1671624378356,-8.17089591716902],[38.16722608210496,-8.170715452859094],[38.16741719736483,-8.170442769203628],[38.16753035417712,-8.170298712597754],[38.16796010662252,-8.170311139622033],[38.168101101507,-8.170323316408462],[38.16830756739088,-8.1703372850315],[38.16841085873494,-8.170318166087643],[38.16855707682138,-8.170155727699463],[38.16869913191461,-8.16927201750472],[38.16876767037173,-8.169060434860405],[38.16888079773766,-8.168969728099253],[38.1691054907977,-8.168966479169159],[38.16935485388807,-8.168892563359785],[38.16944402608672,-8.168794083086139],[38.16954139546284,-8.168703026916406],[38.16954310753371,-8.171182609438503],[38.16864988193195,-8.171014619684795]]', NULL, '2026-04-07 10:52:14'),
(161, 'ERMS1', 1, 2, '[[38.01373270528106,-8.351532219069648],[38.01316001124162,-8.348735735500727],[38.01693001352964,-8.347507876081727],[38.01693550010815,-8.347628430395888],[38.01687193240321,-8.347865568265409],[38.01617587572261,-8.350039691022236],[38.01594055790053,-8.350118884945983],[38.01604551049231,-8.350405935564908],[38.01590045842435,-8.350547627337843],[38.0156831350077,-8.350892469695413],[38.01373270528106,-8.351532219069648]]', NULL, '2026-04-07 10:52:14'),
(162, 'ERMS2', 1, 2, '[[38.01109484190739,-8.352390897628975],[38.0108093709005,-8.351184718514817],[38.0102484654786,-8.351341245554726],[38.00990712575739,-8.349783026775109],[38.01310206942397,-8.34875976603504],[38.01367378783009,-8.351541532483589],[38.01109484190739,-8.352390897628975]]', NULL, '2026-04-07 10:52:14'),
(163, 'ERMS3', 1, 2, '[[38.00987214093509,-8.349817673834451],[38.01020483861027,-8.351354794069946],[38.00951407800203,-8.351588460153408],[38.00973235687288,-8.352693645612318],[38.00956751601698,-8.352790551982286],[38.0095699653049,-8.35287269261775],[38.00917017389779,-8.353005347981973],[38.00724371151429,-8.353648184282413],[38.00666789658057,-8.350865425395853],[38.00987214093509,-8.349817673834451]]', NULL, '2026-04-07 10:52:14'),
(164, 'ERMS4', 1, 2, '[[38.00429640750302,-8.354607534890098],[38.00373059057988,-8.351834486354011],[38.00665579326083,-8.350884934816621],[38.00722130729227,-8.353647162287086],[38.00429640750302,-8.354607534890098]]', NULL, '2026-04-07 10:52:14'),
(165, 'ERMS5', 1, 2, '[[38.00137768781727,-8.355546196419702],[38.00083594733223,-8.352796311596842],[38.0036960078867,-8.351843783598076],[38.00427206071871,-8.354606928285282],[38.00137768781727,-8.355546196419702]]', NULL, '2026-04-07 10:52:14'),
(166, 'ERMS6', 1, 2, '[[37.99699082577903,-8.357001220370448],[37.9966675430775,-8.355408487287834],[37.99842316904573,-8.35483860484334],[37.99875313650418,-8.354351720900217],[38.00013244209261,-8.35392178446966],[38.00034985595454,-8.352933980968524],[38.00080928024538,-8.352807352833786],[38.00136209517942,-8.355555297936842],[37.99699082577903,-8.357001220370448]]', NULL, '2026-04-07 10:52:14'),
(167, 'ERMS7', 1, 1, '[[38.01150512063407,-8.349220687074535],[38.0109122728834,-8.34632791326791],[38.01157358486181,-8.346101307614157],[38.01437030900519,-8.347449290204978],[38.01494597653046,-8.346675345301902],[38.015105655552,-8.34654309074098],[38.01610981711428,-8.346938967306537],[38.016899641747,-8.347441406415205],[38.01150512063407,-8.349220687074535]]', NULL, '2026-04-07 10:52:14'),
(168, 'ERMS8', 1, 1, '[[38.0108922381016,-8.346336530292323],[38.01149327222942,-8.349218839044475],[38.00864394415299,-8.350138265899457],[38.00804209493503,-8.34725710335787],[38.0108922381016,-8.346336530292323]]', NULL, '2026-04-07 10:52:14'),
(169, 'ERMS9', 1, 1, '[[38.00860217905392,-8.350151459080234],[38.00585362683869,-8.351070212548349],[38.00516120058423,-8.347714255550391],[38.00566075515775,-8.347525459315147],[38.00575267951795,-8.34800683309909],[38.00800609830956,-8.347277896576546],[38.00860217905392,-8.350151459080234]]', NULL, '2026-04-07 10:52:14'),
(170, 'ERMS10', 1, 1, '[[38.00340490094074,-8.35185849322774],[38.0027304375219,-8.34856508975743],[38.00515091534658,-8.347711512538623],[38.00584086372278,-8.351074411284127],[38.00340490094074,-8.35185849322774]]', NULL, '2026-04-07 10:52:14'),
(171, 'ERMS11', 1, 1, '[[38.00043968041681,-8.352826830355852],[38.00040689851489,-8.352780703618722],[38.00056837174286,-8.35182064707204],[38.00070207595381,-8.349212918266687],[38.00272303373993,-8.348562324931992],[38.00339194298908,-8.35186168459476],[38.00043968041681,-8.352826830355852]]', NULL, '2026-04-07 10:52:14'),
(172, 'ERMS12', 1, 1, '[[38.00575136267848,-8.347985111641398],[38.00552228293045,-8.346835517561058],[38.00561028488333,-8.346783526654068],[38.00686614594809,-8.346378112419524],[38.00706914573855,-8.346173909564868],[38.00764484199618,-8.345553034087098],[38.00871399086898,-8.344490558142814],[38.00886936168595,-8.344467873296432],[38.00989846275233,-8.345228981263734],[38.01157305492872,-8.346083570098981],[38.00575136267848,-8.347985111641398]]', NULL, '2026-04-07 10:52:14');

-- --------------------------------------------------------

--
-- Estrutura da tabela `culturas`
--

CREATE TABLE `culturas` (
  `id` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `culturas`
--

INSERT INTO `culturas` (`id`, `nome`) VALUES
(1, 'Amendoal regadio'),
(2, 'Olival regadio'),
(3, 'Amendoal Sequeiro'),
(4, 'Horta - vários');

-- --------------------------------------------------------

--
-- Estrutura da tabela `logs_sistema`
--

CREATE TABLE `logs_sistema` (
  `id` int(11) NOT NULL,
  `mensagem` varchar(255) NOT NULL,
  `tipo_alerta` enum('info','aviso','erro') NOT NULL DEFAULT 'info',
  `data_hora` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estrutura da tabela `registos_enchimento`
--

CREATE TABLE `registos_enchimento` (
  `id` int(11) NOT NULL,
  `tecnico_id` int(11) NOT NULL,
  `tratorista_id` int(11) NOT NULL,
  `trator_id` int(11) DEFAULT NULL,
  `local_enchimento` varchar(100) NOT NULL,
  `quantidade_lts` int(11) NOT NULL,
  `observacoes` text,
  `data_hora` datetime NOT NULL,
  `data_registo` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `registos_enchimento`
--

INSERT INTO `registos_enchimento` (`id`, `tecnico_id`, `tratorista_id`, `trator_id`, `local_enchimento`, `quantidade_lts`, `observacoes`, `data_hora`, `data_registo`) VALUES
(3, 12, 2, 1, 'Monte', 3000, '', '2026-03-31 08:28:00', '2026-03-31 07:28:37'),
(4, 12, 3, 1, 'Monte', 3000, '', '2026-03-31 08:38:00', '2026-03-31 07:38:57'),
(7, 13, 5, 1, 'Charca Canal', 3000, '', '2026-03-31 08:52:00', '2026-03-31 07:52:09'),
(8, 13, 6, 1, 'Charca Canal', 3000, '', '2026-03-31 10:39:00', '2026-03-31 09:39:10'),
(9, 13, 5, 1, 'Charca Canal', 3000, '', '2026-03-31 10:58:00', '2026-03-31 09:58:15'),
(10, 13, 3, 1, 'Charca Canal', 3000, '', '2026-03-31 11:09:00', '2026-03-31 10:09:53'),
(11, 13, 7, 1, 'Charca Canal', 3000, '', '2026-03-31 11:25:00', '2026-03-31 10:25:13'),
(12, 13, 2, 1, 'Charca Canal', 3000, '', '2026-03-31 11:43:00', '2026-03-31 10:43:06'),
(13, 13, 7, 1, 'Charca Canal', 3000, '', '2026-03-31 08:30:00', '2026-03-31 11:16:50'),
(14, 13, 6, 1, 'Charca Canal', 3000, '', '2026-03-31 08:42:00', '2026-03-31 11:18:11'),
(15, 13, 6, 1, 'Charca Canal', 3000, '', '2026-03-31 14:17:00', '2026-03-31 13:17:44'),
(16, 13, 7, 1, 'Charca Canal', 3000, '', '2026-03-31 14:48:00', '2026-03-31 13:48:44'),
(17, 13, 5, 1, 'Monte', 3000, '', '2026-03-31 14:59:00', '2026-03-31 14:07:26'),
(18, 13, 3, 1, 'Charca Canal', 3000, '', '2026-03-31 15:12:00', '2026-03-31 14:19:48'),
(19, 13, 2, 1, 'Charca Canal', 3000, '', '2026-03-31 15:21:00', '2026-03-31 14:21:29'),
(20, 13, 2, 1, 'Charca Canal', 3000, '', '2026-04-01 08:34:00', '2026-04-01 07:34:20'),
(21, 12, 6, 1, 'Monte', 3000, '', '2026-04-01 08:35:00', '2026-04-01 07:36:32'),
(22, 13, 7, 1, 'Charca Canal', 3000, '', '2026-04-01 08:45:00', '2026-04-01 07:46:03'),
(23, 13, 5, 1, 'Charca Canal', 3000, '', '2026-04-01 08:57:00', '2026-04-01 07:57:34'),
(24, 13, 3, 1, 'Charca Canal', 3000, '', '2026-04-01 09:20:00', '2026-04-01 08:20:50'),
(25, 13, 2, 1, 'Charca Canal', 3000, '', '2026-04-01 10:37:00', '2026-04-01 09:37:56'),
(26, 13, 6, 1, 'Charca Canal', 3000, '', '2026-04-01 10:50:00', '2026-04-01 09:54:08'),
(27, 13, 7, 1, 'Charca Canal', 3000, '', '2026-04-01 11:04:00', '2026-04-01 10:04:46'),
(28, 13, 5, 1, 'Charca Canal', 3000, '', '2026-04-01 11:39:00', '2026-04-01 10:39:15'),
(29, 13, 7, 1, 'Monte', 3000, '', '2026-04-01 15:21:00', '2026-04-01 14:22:24'),
(30, 13, 7, 1, 'Monte', 1500, '', '2026-04-01 15:21:00', '2026-04-01 14:37:35'),
(31, 13, 5, 1, 'Monte', 1500, '', '2026-04-01 15:37:00', '2026-04-01 14:37:49'),
(32, 12, 5, 1, 'Monte', 1500, '', '2026-04-02 08:20:00', '2026-04-02 07:27:36'),
(33, 12, 7, 1, 'Monte', 3000, 'Tratamento adubo foliar belona MM', '2026-04-02 08:44:00', '2026-04-02 07:46:59'),
(34, 12, 5, 1, 'Monte', 3000, 'Tratamento adubo foliar belona MM', '2026-04-02 10:59:00', '2026-04-02 09:59:49'),
(35, 12, 7, 1, 'Monte', 3000, 'Tratamento adubo foliar belona MM ', '2026-04-02 11:27:00', '2026-04-02 10:27:19'),
(36, 12, 5, 1, 'Monte', 3000, 'Tratamento adubo foliar belona MM', '2026-04-02 12:50:00', '2026-04-02 11:51:04'),
(37, 12, 7, 1, 'Monte', 3000, 'Tratamento adubo foliar belona MM ', '2026-04-02 14:24:00', '2026-04-02 13:24:20'),
(38, 12, 4, 1, 'Monte', 3000, 'Tratamento Antracnose com maxifruit e calfinish ', '2026-04-08 08:24:00', '2026-04-08 07:25:05'),
(39, 13, 7, 1, 'Charca Canal', 3000, '', '2026-04-08 08:35:00', '2026-04-08 07:38:00'),
(40, 13, 5, 1, 'Charca Canal', 3000, '', '2026-04-08 08:46:00', '2026-04-08 07:46:29'),
(41, 12, 2, 1, 'Monte', 3000, 'Tratamento Antracnose ', '2026-04-08 08:50:00', '2026-04-08 07:51:10'),
(42, 12, 3, 1, 'Monte', 3000, 'Tratamento Antracnose ', '2026-04-08 09:04:00', '2026-04-08 08:05:08'),
(43, 12, 10, 1, 'Monte', 3000, 'Tratamento Antracnose ', '2026-04-08 09:25:00', '2026-04-08 08:25:44'),
(44, 12, 11, 1, 'Monte', 3000, 'Tratamento Antracnose ', '2026-04-08 10:42:00', '2026-04-08 09:42:58'),
(45, 13, 5, 1, 'Charca Canal', 3000, '', '2026-04-08 11:06:00', '2026-04-08 10:07:03'),
(46, 12, 7, 1, 'Monte', 3000, 'Tratamento Antracnose ', '2026-04-08 11:08:00', '2026-04-08 10:08:44');

-- --------------------------------------------------------

--
-- Estrutura da tabela `registos_gps`
--

CREATE TABLE `registos_gps` (
  `id` bigint(20) NOT NULL,
  `tratorista_id` int(11) NOT NULL,
  `trator_id` int(11) NOT NULL,
  `trabalho_id` int(11) DEFAULT NULL,
  `latitude` decimal(10,8) NOT NULL,
  `longitude` decimal(11,8) NOT NULL,
  `velocidade_kmh` decimal(5,2) NOT NULL DEFAULT '0.00',
  `rumo_graus` int(3) NOT NULL DEFAULT '0',
  `estado_trator` enum('parado','em_trabalho','pausa') NOT NULL DEFAULT 'parado',
  `largura_trabalho` decimal(5,2) DEFAULT NULL,
  `dentro_limites` tinyint(1) NOT NULL DEFAULT '1',
  `data_hora_leitura` datetime NOT NULL,
  `data_hora_rececao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- --------------------------------------------------------

--
-- Estrutura da tabela `trabalhos_atribuidos`
--

CREATE TABLE `trabalhos_atribuidos` (
  `id` int(11) NOT NULL,
  `tratorista_id` int(11) NOT NULL,
  `trator_id` int(11) NOT NULL,
  `alfaia_id` int(11) NOT NULL,
  `campo_id` int(11) NOT NULL,
  `estado` enum('atribuido','em_curso','concluido') NOT NULL DEFAULT 'atribuido',
  `data_atribuicao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `velocidade_limite` decimal(5,2) NOT NULL DEFAULT '5.00'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `trabalhos_atribuidos`
--

INSERT INTO `trabalhos_atribuidos` (`id`, `tratorista_id`, `trator_id`, `alfaia_id`, `campo_id`, `estado`, `data_atribuicao`, `velocidade_limite`) VALUES
(233, 5, 1, 1, 160, 'em_curso', '2026-04-08 06:53:20', 5.00),
(234, 5, 1, 1, 159, 'em_curso', '2026-04-08 06:53:20', 5.00),
(235, 5, 1, 1, 158, 'em_curso', '2026-04-08 06:53:20', 5.00),
(236, 5, 1, 1, 153, 'em_curso', '2026-04-08 06:53:20', 5.00),
(237, 5, 1, 1, 154, 'em_curso', '2026-04-08 06:53:20', 5.00),
(238, 5, 1, 1, 155, 'em_curso', '2026-04-08 06:53:20', 5.00),
(239, 5, 1, 1, 156, 'em_curso', '2026-04-08 06:53:20', 5.00),
(240, 5, 1, 1, 151, 'em_curso', '2026-04-08 06:53:20', 5.00),
(241, 5, 1, 1, 150, 'em_curso', '2026-04-08 06:53:20', 5.00),
(242, 5, 1, 1, 149, 'em_curso', '2026-04-08 06:53:20', 5.00),
(243, 5, 1, 1, 148, 'em_curso', '2026-04-08 06:53:20', 5.00),
(244, 5, 1, 1, 152, 'em_curso', '2026-04-08 06:53:20', 5.00),
(245, 5, 1, 1, 157, 'em_curso', '2026-04-08 06:53:20', 5.00),
(259, 2, 1, 1, 153, 'em_curso', '2026-04-08 06:54:56', 5.00),
(260, 2, 1, 1, 158, 'em_curso', '2026-04-08 06:54:56', 5.00),
(261, 2, 1, 1, 160, 'em_curso', '2026-04-08 06:54:56', 5.00),
(262, 2, 1, 1, 159, 'em_curso', '2026-04-08 06:54:56', 5.00),
(263, 2, 1, 1, 154, 'em_curso', '2026-04-08 06:54:56', 5.00),
(264, 2, 1, 1, 155, 'em_curso', '2026-04-08 06:54:56', 5.00),
(265, 2, 1, 1, 156, 'em_curso', '2026-04-08 06:54:56', 5.00),
(266, 2, 1, 1, 157, 'em_curso', '2026-04-08 06:54:56', 5.00),
(267, 2, 1, 1, 152, 'em_curso', '2026-04-08 06:54:56', 5.00),
(268, 2, 1, 1, 151, 'em_curso', '2026-04-08 06:54:56', 5.00),
(269, 2, 1, 1, 150, 'em_curso', '2026-04-08 06:54:56', 5.00),
(270, 2, 1, 1, 149, 'em_curso', '2026-04-08 06:54:56', 5.00),
(271, 2, 1, 1, 148, 'em_curso', '2026-04-08 06:54:56', 5.00),
(272, 4, 1, 1, 153, 'em_curso', '2026-04-08 06:56:18', 5.00),
(273, 4, 1, 1, 158, 'em_curso', '2026-04-08 06:56:18', 5.00),
(274, 4, 1, 1, 160, 'em_curso', '2026-04-08 06:56:18', 5.00),
(275, 4, 1, 1, 154, 'em_curso', '2026-04-08 06:56:18', 5.00),
(276, 4, 1, 1, 159, 'em_curso', '2026-04-08 06:56:18', 5.00),
(277, 4, 1, 1, 155, 'em_curso', '2026-04-08 06:56:18', 5.00),
(278, 4, 1, 1, 156, 'em_curso', '2026-04-08 06:56:18', 5.00),
(279, 4, 1, 1, 157, 'em_curso', '2026-04-08 06:56:18', 5.00),
(280, 4, 1, 1, 152, 'em_curso', '2026-04-08 06:56:18', 5.00),
(281, 4, 1, 1, 151, 'em_curso', '2026-04-08 06:56:18', 5.00),
(282, 4, 1, 1, 150, 'em_curso', '2026-04-08 06:56:18', 5.00),
(283, 4, 1, 1, 149, 'em_curso', '2026-04-08 06:56:18', 5.00),
(284, 4, 1, 1, 148, 'em_curso', '2026-04-08 06:56:18', 5.00),
(285, 7, 1, 1, 160, 'em_curso', '2026-04-08 06:56:52', 5.00),
(286, 7, 1, 1, 158, 'em_curso', '2026-04-08 06:56:52', 5.00),
(287, 7, 1, 1, 153, 'em_curso', '2026-04-08 06:56:52', 5.00),
(288, 7, 1, 1, 154, 'em_curso', '2026-04-08 06:56:52', 5.00),
(289, 7, 1, 1, 159, 'em_curso', '2026-04-08 06:56:52', 5.00),
(290, 7, 1, 1, 155, 'em_curso', '2026-04-08 06:56:52', 5.00),
(291, 7, 1, 1, 148, 'em_curso', '2026-04-08 06:56:52', 5.00),
(292, 7, 1, 1, 150, 'em_curso', '2026-04-08 06:56:52', 5.00),
(293, 7, 1, 1, 151, 'em_curso', '2026-04-08 06:56:52', 5.00),
(294, 7, 1, 1, 149, 'em_curso', '2026-04-08 06:56:52', 5.00),
(295, 7, 1, 1, 152, 'em_curso', '2026-04-08 06:56:52', 5.00),
(296, 7, 1, 1, 157, 'em_curso', '2026-04-08 06:56:52', 5.00),
(297, 7, 1, 1, 156, 'em_curso', '2026-04-08 06:56:52', 5.00),
(325, 10, 1, 1, 152, 'em_curso', '2026-04-08 07:47:33', 5.00),
(326, 10, 1, 1, 157, 'em_curso', '2026-04-08 07:47:33', 5.00),
(327, 10, 1, 1, 151, 'em_curso', '2026-04-08 07:47:33', 5.00),
(328, 10, 1, 1, 156, 'em_curso', '2026-04-08 07:47:33', 5.00),
(329, 10, 1, 1, 150, 'em_curso', '2026-04-08 07:47:33', 5.00),
(330, 10, 1, 1, 155, 'em_curso', '2026-04-08 07:47:33', 5.00),
(331, 10, 1, 1, 154, 'em_curso', '2026-04-08 07:47:33', 5.00),
(332, 10, 1, 1, 159, 'em_curso', '2026-04-08 07:47:33', 5.00),
(333, 10, 1, 1, 149, 'em_curso', '2026-04-08 07:47:33', 5.00),
(334, 10, 1, 1, 148, 'em_curso', '2026-04-08 07:47:33', 5.00),
(335, 10, 1, 1, 153, 'em_curso', '2026-04-08 07:47:33', 5.00),
(336, 10, 1, 1, 158, 'em_curso', '2026-04-08 07:47:33', 5.00),
(337, 10, 1, 1, 160, 'em_curso', '2026-04-08 07:47:33', 5.00),
(338, 6, 1, 2, 140, 'em_curso', '2026-04-08 08:18:33', 5.00),
(339, 6, 1, 2, 139, 'em_curso', '2026-04-08 08:18:33', 5.00),
(340, 6, 1, 2, 145, 'em_curso', '2026-04-08 08:18:33', 5.00),
(341, 6, 1, 2, 146, 'em_curso', '2026-04-08 08:18:33', 5.00),
(342, 6, 1, 2, 144, 'em_curso', '2026-04-08 08:18:33', 5.00),
(343, 6, 1, 2, 143, 'em_curso', '2026-04-08 08:18:33', 5.00),
(357, 3, 1, 1, 148, 'atribuido', '2026-04-08 08:19:07', 5.00),
(358, 3, 1, 1, 150, 'atribuido', '2026-04-08 08:19:07', 5.00),
(359, 3, 1, 1, 149, 'atribuido', '2026-04-08 08:19:07', 5.00),
(360, 3, 1, 1, 151, 'atribuido', '2026-04-08 08:19:07', 5.00),
(361, 3, 1, 1, 152, 'atribuido', '2026-04-08 08:19:07', 5.00),
(362, 3, 1, 1, 157, 'atribuido', '2026-04-08 08:19:07', 5.00),
(363, 3, 1, 1, 156, 'atribuido', '2026-04-08 08:19:07', 5.00),
(364, 3, 1, 1, 155, 'atribuido', '2026-04-08 08:19:07', 5.00),
(365, 3, 1, 1, 159, 'atribuido', '2026-04-08 08:19:07', 5.00),
(366, 3, 1, 1, 154, 'atribuido', '2026-04-08 08:19:07', 5.00),
(367, 3, 1, 1, 153, 'atribuido', '2026-04-08 08:19:07', 5.00),
(368, 3, 1, 1, 158, 'atribuido', '2026-04-08 08:19:07', 5.00),
(369, 3, 1, 1, 160, 'atribuido', '2026-04-08 08:19:07', 5.00),
(370, 11, 1, 1, 152, 'em_curso', '2026-04-08 09:21:33', 5.00),
(371, 11, 1, 1, 157, 'em_curso', '2026-04-08 09:21:33', 5.00),
(372, 11, 1, 1, 151, 'em_curso', '2026-04-08 09:21:33', 5.00),
(373, 11, 1, 1, 156, 'em_curso', '2026-04-08 09:21:33', 5.00),
(374, 11, 1, 1, 150, 'em_curso', '2026-04-08 09:21:33', 5.00),
(375, 11, 1, 1, 155, 'em_curso', '2026-04-08 09:21:33', 5.00),
(376, 11, 1, 1, 148, 'em_curso', '2026-04-08 09:21:33', 5.00),
(377, 11, 1, 1, 149, 'em_curso', '2026-04-08 09:21:33', 5.00),
(378, 11, 1, 1, 154, 'em_curso', '2026-04-08 09:21:33', 5.00),
(379, 11, 1, 1, 159, 'em_curso', '2026-04-08 09:21:33', 5.00),
(380, 11, 1, 1, 153, 'em_curso', '2026-04-08 09:21:33', 5.00),
(381, 11, 1, 1, 158, 'em_curso', '2026-04-08 09:21:33', 5.00),
(382, 11, 1, 1, 160, 'em_curso', '2026-04-08 09:21:33', 5.00);

-- --------------------------------------------------------

--
-- Estrutura da tabela `tratores`
--

CREATE TABLE `tratores` (
  `id` int(11) NOT NULL,
  `nome_modelo` varchar(100) NOT NULL,
  `matricula` varchar(20) DEFAULT NULL,
  `ativo` tinyint(1) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `tratores`
--

INSERT INTO `tratores` (`id`, `nome_modelo`, `matricula`, `ativo`) VALUES
(1, 'RSeifert', NULL, 1),
(2, 'Maquisinga', NULL, 1);

-- --------------------------------------------------------

--
-- Estrutura da tabela `utilizadores`
--

CREATE TABLE `utilizadores` (
  `id` int(11) NOT NULL,
  `username` varchar(50) NOT NULL,
  `password` varchar(255) NOT NULL,
  `nome` varchar(100) NOT NULL,
  `tipo_perfil` enum('gestor','tratorista','tecnico') NOT NULL DEFAULT 'tratorista',
  `ativo` tinyint(1) NOT NULL DEFAULT '1',
  `data_criacao` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `utilizadores`
--

INSERT INTO `utilizadores` (`id`, `username`, `password`, `nome`, `tipo_perfil`, `ativo`, `data_criacao`) VALUES
(1, 'gestor', '$2y$10$Cm1pCIyw7SV15nSp54Ghd..YlHqnuGqCQGURQJ7zf8HETUDQHhGcK', 'Gestor Principal', 'gestor', 1, '2026-03-30 07:28:26'),
(2, 'T1', '$2y$10$eNSlIgy2PgJsKyjJ8qBvK.BpwtHytSio02ls.J0j9W.O8WzbWLC1C', 'José Luis', 'tratorista', 1, '2026-03-30 07:28:26'),
(3, 'T2', '$2y$10$yhEsQaHWE4mkZvIbKnyZ0ugqQLzOTDWhZewFAOewbOhq60Tk0yI4K', 'Jorge Tapiço', 'tratorista', 1, '2026-03-30 07:28:26'),
(4, 'T3', '$2y$10$bua9o4fBTjdFEucL0FLcF.HVzYLC9m6IoQlUOgkM632OXf3mQ.pDm', 'César Maia', 'tratorista', 1, '2026-03-30 07:28:26'),
(5, 'T4', '$2y$10$awVvbV6B5S1YQHxte1eMBe1VG.zdZgwJAmpiu8wC8k/Eu8DzmARbq', 'David', 'tratorista', 1, '2026-03-30 07:28:26'),
(6, 'T5', '$2y$10$AQJuIdGNEuw73B57cQmM6e4aAjlJgwPC09OcOtO2.XlLRe5lxeWRq', 'Francisco', 'tratorista', 1, '2026-03-30 07:28:26'),
(7, 'T6', '$2y$10$HuMslPJgY4ET6fCT4mJFYuRcYVRbTmChy0nvLI.xdtiy28fbHf86.', 'Tiago', 'tratorista', 1, '2026-03-30 07:28:26'),
(8, 'T7', '$2y$10$0nZifNmUIcp5KT//CyoDSOptiBOmJMOOJ8v8WqbIUZ2Z5jI0kNotS', 'Fábio', 'tratorista', 1, '2026-03-30 07:28:26'),
(9, 'T8', 'Trator8#', 'Joaquim Zé', 'tratorista', 1, '2026-03-30 07:28:26'),
(10, 'T9', '$2y$10$P4yQZQgiiWRFSU.XiWnoDuWBeqaj5QlWIpfh7l/xgBFN9e6PFXrlC', 'Armindo', 'tratorista', 1, '2026-03-30 07:28:26'),
(11, 'T10', '$2y$10$smwrpjeWmfGQpcO6vi4nBexUw5zVhTqMX8EAwrGRSB09z0U34e.12', 'Vicente', 'tratorista', 1, '2026-03-30 07:28:26'),
(12, 'tec1', '$2y$10$xH9IX1IXgKNzwzgOYdSNUuuUTT8sVUFL5zi38Shy.f4iNC230Mvwi', 'Soraia Gonçalves', 'tecnico', 1, '2026-03-31 04:29:12'),
(13, 'tec2', '$2y$10$Bp9jBdlto72TcgvK2fl2nuOco8lSkkKtD7bhVZ4Ll9/hhzk28dBT6', 'Luis António', 'tecnico', 1, '2026-03-31 04:29:12'),
(14, 'tec3', 'rsantos#', 'Rui Santos', 'tecnico', 1, '2026-03-31 04:29:12'),
(15, 'tec4', 'rmira#', 'Ricardo Mira', 'tecnico', 1, '2026-03-31 04:29:12'),
(16, 'tec5', 'afeliciano#', 'Ana Feliciano', 'tecnico', 1, '2026-03-31 04:29:12'),
(17, 'tec6', 'rsantinhos#', 'Rui Santinhos', 'tecnico', 1, '2026-03-31 04:29:12'),
(18, 'tec7', '$2y$10$SdwHFe07WISwz2PqVPp6p.41jPeUMvnl2/thzNYaEGlgqOiZz5h4q', 'Alexandre Rodrigues', 'tecnico', 1, '2026-03-31 04:29:12'),
(19, 'soraia', '$2y$10$3yD2GjKZzu4PmRNQ/0bV8eeZm3pHtViyxtCS8SKI3ldYMPsqXIgMy', '', 'gestor', 1, '2026-04-02 07:42:07'),
(20, 'ana', '$2y$10$mKhpN4YIsG8.ZKcr9XaLGum.saLdnI/r7Sa4M.V2MFN6U.yQXI6gC', '', 'gestor', 1, '2026-04-02 07:42:46');

-- --------------------------------------------------------

--
-- Estrutura da tabela `variedades`
--

CREATE TABLE `variedades` (
  `id` int(11) NOT NULL,
  `cultura_id` int(11) NOT NULL,
  `nome` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Extraindo dados da tabela `variedades`
--

INSERT INTO `variedades` (`id`, `cultura_id`, `nome`) VALUES
(1, 1, 'BELONA'),
(2, 1, 'LAURANE'),
(3, 1, 'PENTA'),
(4, 1, 'VAIRO'),
(5, 1, 'SOLETA'),
(6, 2, 'COMUM'),
(7, 4, 'VÁRIOS');

--
-- Índices para tabelas despejadas
--

--
-- Índices para tabela `alfaias`
--
ALTER TABLE `alfaias`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `campos`
--
ALTER TABLE `campos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cultura_id` (`cultura_id`),
  ADD KEY `variedade_id` (`variedade_id`);

--
-- Índices para tabela `culturas`
--
ALTER TABLE `culturas`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `logs_sistema`
--
ALTER TABLE `logs_sistema`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `registos_enchimento`
--
ALTER TABLE `registos_enchimento`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tecnico_id` (`tecnico_id`),
  ADD KEY `tratorista_id` (`tratorista_id`);

--
-- Índices para tabela `registos_gps`
--
ALTER TABLE `registos_gps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_trator_data` (`trator_id`,`data_hora_leitura`),
  ADD KEY `tratorista_id` (`tratorista_id`),
  ADD KEY `trabalho_id` (`trabalho_id`);

--
-- Índices para tabela `trabalhos_atribuidos`
--
ALTER TABLE `trabalhos_atribuidos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tratorista_id` (`tratorista_id`),
  ADD KEY `trator_id` (`trator_id`),
  ADD KEY `alfaia_id` (`alfaia_id`),
  ADD KEY `campo_id` (`campo_id`);

--
-- Índices para tabela `tratores`
--
ALTER TABLE `tratores`
  ADD PRIMARY KEY (`id`);

--
-- Índices para tabela `utilizadores`
--
ALTER TABLE `utilizadores`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `username` (`username`);

--
-- Índices para tabela `variedades`
--
ALTER TABLE `variedades`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cultura_id` (`cultura_id`);

--
-- AUTO_INCREMENT de tabelas despejadas
--

--
-- AUTO_INCREMENT de tabela `alfaias`
--
ALTER TABLE `alfaias`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de tabela `campos`
--
ALTER TABLE `campos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=173;

--
-- AUTO_INCREMENT de tabela `culturas`
--
ALTER TABLE `culturas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT de tabela `logs_sistema`
--
ALTER TABLE `logs_sistema`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `registos_enchimento`
--
ALTER TABLE `registos_enchimento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT de tabela `registos_gps`
--
ALTER TABLE `registos_gps`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de tabela `trabalhos_atribuidos`
--
ALTER TABLE `trabalhos_atribuidos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=383;

--
-- AUTO_INCREMENT de tabela `tratores`
--
ALTER TABLE `tratores`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de tabela `utilizadores`
--
ALTER TABLE `utilizadores`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT de tabela `variedades`
--
ALTER TABLE `variedades`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- Restrições para despejos de tabelas
--

--
-- Limitadores para a tabela `campos`
--
ALTER TABLE `campos`
  ADD CONSTRAINT `campos_ibfk_1` FOREIGN KEY (`cultura_id`) REFERENCES `culturas` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `campos_ibfk_2` FOREIGN KEY (`variedade_id`) REFERENCES `variedades` (`id`) ON DELETE SET NULL;

--
-- Limitadores para a tabela `registos_enchimento`
--
ALTER TABLE `registos_enchimento`
  ADD CONSTRAINT `registos_enchimento_ibfk_1` FOREIGN KEY (`tecnico_id`) REFERENCES `utilizadores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `registos_enchimento_ibfk_2` FOREIGN KEY (`tratorista_id`) REFERENCES `utilizadores` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `registos_gps`
--
ALTER TABLE `registos_gps`
  ADD CONSTRAINT `registos_gps_ibfk_1` FOREIGN KEY (`tratorista_id`) REFERENCES `utilizadores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `registos_gps_ibfk_2` FOREIGN KEY (`trator_id`) REFERENCES `tratores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `registos_gps_ibfk_3` FOREIGN KEY (`trabalho_id`) REFERENCES `trabalhos_atribuidos` (`id`) ON DELETE SET NULL;

--
-- Limitadores para a tabela `trabalhos_atribuidos`
--
ALTER TABLE `trabalhos_atribuidos`
  ADD CONSTRAINT `trabalhos_atribuidos_ibfk_1` FOREIGN KEY (`tratorista_id`) REFERENCES `utilizadores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `trabalhos_atribuidos_ibfk_2` FOREIGN KEY (`trator_id`) REFERENCES `tratores` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `trabalhos_atribuidos_ibfk_3` FOREIGN KEY (`alfaia_id`) REFERENCES `alfaias` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `trabalhos_atribuidos_ibfk_4` FOREIGN KEY (`campo_id`) REFERENCES `campos` (`id`) ON DELETE CASCADE;

--
-- Limitadores para a tabela `variedades`
--
ALTER TABLE `variedades`
  ADD CONSTRAINT `variedades_ibfk_1` FOREIGN KEY (`cultura_id`) REFERENCES `culturas` (`id`) ON DELETE CASCADE;
COMMIT;
