20240710 13315600 1.0 TRUE CreateFeatureclass E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA sislic Point E:\DDA\SISLIC\Staging.gdb\sislic No No "{B286C06B-0879-11D2-AACA-00C04FA33C20};-450359962737.049 -450359962737.049 10000;-100000 10000;-100000 10000;0.001;0.001;0.001;IsHighPrecision" # 0 0 0 # TruncateTable E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic Append E:\DDA\SISLIC\Staging.gdb\sislic E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic "Use the field map to reconcile field differences" "ufempreendimento "UFEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,UFEMPREENDIMENTO,0,8000;tipolicenca "TIPOLICENCA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,TIPOLICENCA,0,8000;situacao "SITUACAO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,SITUACAO,0,8000;dataemissao "DATAEMISSAO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAEMISSAO,-1,-1;datavencimento "DATAVENCIMENTO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAVENCIMENTO,-1,-1;descricaotipologia "DESCRICAOTIPOLOGIA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DESCRICAOTIPOLOGIA,0,8000;outrosmunicipios "OUTROSMUNICIPIOS" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,OUTROSMUNICIPIOS,0,8000;porteempreendimento "PORTEEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,PORTEEMPREENDIMENTO,0,8000;potencialpoluidor "POTENCIALPOLUIDOR" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,POTENCIALPOLUIDOR,0,8000;latitude "LATITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LATITUDE,-1,-1;longitude "LONGITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LONGITUDE,-1,-1;ano "ANO" true true false 4 Long 0 10,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,ANO,-1,-1" # # # NOT_UPDATE_GEOMETRY AddField E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic NOMEEMPREENDIMENTO Text # # # # NULLABLE NON_REQUIRED # AddField E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic NUMEROPROCESSO Text # # # # NULLABLE NON_REQUIRED # AddField E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic NOMEEMPREENDEDOR Text # # # # NULLABLE NON_REQUIRED # TruncateTable E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic Append E:\DDA\SISLIC\Staging.gdb\sislic E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic "Use the field map to reconcile field differences" "ufempreendimento "UFEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,UFEMPREENDIMENTO,0,8000;tipolicenca "TIPOLICENCA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,TIPOLICENCA,0,8000;situacao "SITUACAO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,SITUACAO,0,8000;dataemissao "DATAEMISSAO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAEMISSAO,-1,-1;datavencimento "DATAVENCIMENTO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAVENCIMENTO,-1,-1;descricaotipologia "DESCRICAOTIPOLOGIA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DESCRICAOTIPOLOGIA,0,8000;outrosmunicipios "OUTROSMUNICIPIOS" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,OUTROSMUNICIPIOS,0,8000;porteempreendimento "PORTEEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,PORTEEMPREENDIMENTO,0,8000;potencialpoluidor "POTENCIALPOLUIDOR" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,POTENCIALPOLUIDOR,0,8000;latitude "LATITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LATITUDE,-1,-1;longitude "LONGITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LONGITUDE,-1,-1;ano "ANO" true true false 4 Long 0 10,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,ANO,-1,-1;nomeempreendimento "nomeempreendimento" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NOMEEMPREENDIMENTO,0,8000;numeroprocesso "numeroprocesso" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NUMEROPROCESSO,0,8000;nomeempreendedor "nomeempreendedor" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NOMEEMPREENDEDOR,0,8000" # # # NOT_UPDATE_GEOMETRY TruncateTable E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic Append E:\DDA\SISLIC\Staging.gdb\sislic E:\DDA\10.10.12.10(1).sde\ibama_prd.geo.D02_DDA\ibama_prd.geo.sislic "Use the field map to reconcile field differences" "ufempreendimento "UFEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,UFEMPREENDIMENTO,0,8000;tipolicenca "TIPOLICENCA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,TIPOLICENCA,0,8000;situacao "SITUACAO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,SITUACAO,0,8000;dataemissao "DATAEMISSAO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAEMISSAO,-1,-1;datavencimento "DATAVENCIMENTO" true true false 8 Date 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DATAVENCIMENTO,-1,-1;descricaotipologia "DESCRICAOTIPOLOGIA" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,DESCRICAOTIPOLOGIA,0,8000;outrosmunicipios "OUTROSMUNICIPIOS" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,OUTROSMUNICIPIOS,0,8000;porteempreendimento "PORTEEMPREENDIMENTO" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,PORTEEMPREENDIMENTO,0,8000;potencialpoluidor "POTENCIALPOLUIDOR" true true false 8000 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,POTENCIALPOLUIDOR,0,8000;latitude "LATITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LATITUDE,-1,-1;longitude "LONGITUDE" true true false 8 Double 8 38,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,LONGITUDE,-1,-1;ano "ANO" true true false 4 Long 0 10,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,ANO,-1,-1;nomeempreendimento "nomeempreendimento" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NOMEEMPREENDIMENTO,0,8000;numeroprocesso "numeroprocesso" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NUMEROPROCESSO,0,8000;nomeempreendedor "nomeempreendedor" true true false 255 Text 0 0,First,#,E:\DDA\SISLIC\Staging.gdb\sislic,NOMEEMPREENDEDOR,0,8000" # # # NOT_UPDATE_GEOMETRY Esta camada armazena dados sobre processos de licenciamento ambiental obtidos através da API do IBAMA, disponível em http://ws.ibama.gov.br/ws_pnla/ibama/licenciamentos.php. O processo de atualização envolve a consulta da API, seguida de filtragem por tipologias definidas para o Diagnóstico de Delitos Ambientais (DDA). Somente os atributos essenciais são mantidos, e registros são gerados para cada ano em que uma atividade esteve ativa. Os dados são então convertidos para pontos geográficos e inseridos na camada "sislic" no banco de dados. Essa camada é crucial para o monitoramento, gestão e fiscalização dos processos de licenciamento ambiental, assegurando conformidade com as regulamentações vigentes. DDA PAMGIA Sislic Licenciamento Camada de dados de licenciamento ambiental disponíveis no SISLIC do IBAMA. CODEX sislic_dda /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2OzkZ 4ikcS5XqxbvV8ZwM4z3xWTZXPkSbWxsbr7VrggjI6UCQUUVBdXH2eMHALE4AzQMnpjzRxY3uFz61 mNqMxXA2qc9QKrO7SMWdiSe5oFc1zfW4P38/QGqr36q7NEhye7H+lUKmt2iV/wB6m70phciZi7lm 6k5NJWotvZMxIZT7bulNl+wpGVABP+zyfzoAzaUknqelJRQIKKKKACiip4bSWYjA2r/eNAEcMfmy hM4z3xWhHp8YzvLOfbgVPBAkKBVGT3bHJqbgD0FIdiulrFED+5Bz3PNSiFAQRGq46YAqGW4kd9ls of8AvE9BVhN2wb8bu+3pQMha1ilGCqjH90YNQNpiknbIQOwIq90Y+9RXCzFAYGwwPfuKAM99PnX7 oDD2NQRxNJL5Y4b0NayJcZUtKMdxtANPEEQYMEG4d+9ArGT9mdZxG3OeuzmpRYTb8qdo7EnB/StX AznHNFAWKAgvSChkXb0+bnP6UJp44WQKR/eUkGr9FAyk+mRn7rsD781PAjQosZGVA+9n+lTUUAQ3 OBGGJ+6c9cE+wqXOQDijYpYMQMjoaWgAoAAGBRRQAUUUUAFFFFAHPVZtrx4PlI3J6elVqKZJrR6h C4O/KH35rNnl86Zn5wTx9KjooGFFFFAgooooAKKKKAClBwCOOfakqzbRPuDNEWjPXjtQBXAyRk4H rSd62bmMTWx2LuIHyjNY1Ay/pyRuH3KCwxjNaJIHUgVgpI8bbkYqfUVdSP7TamR5C0g6ZPSkBfV1 3FAw3dcd8VWv4i8QbeFVeoPenLPFCpMpQS/xbepqjcziaUuqErjaCR0oAsWNxHHGYyTkHOQCc1ca XaMiN2+gqpaW48g53o7e5Bq2Rgbec/XOaBkc32khGiC+6mnSRNKqHdskXnjkVKG9QRS0AFFFFABR RRQAUUUUAFFFJuHr+VAC0UA5ooAKKKKACiiigAooooA589TjpSVcuktjFvgIBBwQD1qnTJCiiigA ooooAKKKKACiiigB8RCyqSQAD1IzWhPeQiIrESXxgFRjFZlFAzZtIkihBHVhk8nn86gvYFkYOmTI eMAjpUNutvK673cyZ5DdDWkkUcf3EC/SkBSt7FQu6UZY9F7CrqRJGm1VAX0pWC9TTd5XAYHP4UDB 0jwuUUgHgEU8YxxjFMDDJ5C+xoHzEkevUcUAKyKASFGfpSg46KaTBz1z6ilJbHQUAByRgD86UHHB /OgNnrjNKfegAopg2k/Lj3Ip9AB0pM+xpGx1IyP5VGbqBW2mVc0AS7h60jMMcHFOooATaO4BPvS0 UUAIQDRtHvmlJAGScAUiurruUgj1FABu9eKUEHoaKacEjA59aAHUm4ZxkZpMY6/MKdgEUAITijP+ yaNo9KWgDnqKKKZIUUUUAFFFFABRRRQAUUUUAFXF06RkDb05Gap1uRIEjjUYOF6+tA0UBpsoYHcu Aex5rT3ADk4+tLWde3LrMI1cqoHJHWkMsm7tyGBkHHHINMivEYj5NiE4DZ6mso9Tzn3qdmhNmigf vd3NArl64M0L+aDuj4yvcCnJNFMPlPzDt3qjBPdJt2q7p6YyDTrt41nyqAOMHIPf0NAGluGRtI57 U4k+g/OoUkE0Bkj5PZTxzVezuHndlcjIHBFAypcXBmbAyEHQU43jmEI0aNjuRWmLaEEN5alvXFSF QylSAQe1AjOtb5I0EboFHqv9a0FcMoYZwehqL7Hb/wDPIVJsCqNoxjtQMqajv8pWVjszhgKqWiwt IVm7/d9M1pnAjYyIcDr3yKxSRvJA4z0oEze4wADx9aOpyrfhUNssawJgnBGQGPNT8GgYZPpS9RSZ x1/OmMCeFOO/saAFcI6FW5B4pwIAwBj8KYoYD1x6U/B7mgBOGYjPGOlOoAA6UUAFJg9mNLRQAmfU H8qNw9/ypaKAOeooopkhRRRQAUUUUAFFFFABRRRQAVdspp3mVA2VAwcjoKpqpdgo6k4FbyqsaBQA AKBoryJdljtlQKfQcimpp0QOXZnP5VaOWyOgp1IZB9jt/wDnkKbJbwLBIRGowDg4qzTTwcDvQBiR zyxAqjkA9u1R1ttawOMGNfqODVB9OmU/KVYfXFMViCO4kjjaMNhW/MUK3kyK8cgYj0GK1PsVvsC+ WPr3qu2mqclJCOeARQFiIalNgcJ78danF6zTogKYPUqCcU0aXxzLz7LUlvZ+RJljuJHBx0pAW8AD kmmhAV5zz70AZOQfxp2fWgYDkc1A9lA7bimPYcA1MzBPmJwO9KCGGVII9RQAiIsahVGAKGGORwad TX+7QAuCev5Um1R2pdy4zkfnSct7CgBCAcnJx7U7pwBS9KQDjk80AAOec5FLTc44NO69KACiiigA ooooA56iiimSFFFFABRRRQAUUUUAFORGkcIoyScCm1pafEFUytjJ4XPpQBPDaxQEEDLgcmph3JHf rSrzk0N0/GkULRSYx0/KlBzQAUh+8KWmnB4HNADqKaSwHY/pS5I6j8qAFpF7/WlzmmBgM9evoaAH 1BNP5Mib1HltwW9DUu8ejf8AfJqO4iE8Oz16EjoaAJhyMiiqdjIw3wOfmTp9KuUAMeNHUqyjB61Q jd7B3VkLRZ4NaVRyxLKuHXI9M0ARJexP90NjuccCrAIYcEEVEsMap5WwBCOnrWddwC2cGNz83buK ANVeecfQ049KwC7nqzH8auWd2VIic/Keh9KBXNIc85z6UtIBtGM0tAxCOcg4NIQc5H6U6igBgY7i CPpTugyajeaJGO6RenPNLGQygqQVPOR3oAdyO/4U6kI7jqKTevfGaAMCiiimSFFFFABRRRQAUUUU AFaum5+znP8Ae4rKrWszGtqnB9+KBot0jHCk+nNIM5xnjHFLjPc0hi0hGaM84HJpPmzgkD8KAAZP U06kzj1+tG4etAC0i/dH0pMgkCnUAIR36Ghfug+tB6getKBgYFABRRSE4BNAGbcq9vdfaEPyk/5F X4pkljDqRz29KbND50XlsMDsQeRUVlE0JdG9cg+ooEWtw7HJpCWx0FRy3MMX3nGfQcmqNxqBkUpG CoPfPNAzQklSBd0jf/XrGmlM0rOe/T2FMZmY5Ykn3NJTEFFFFAi7p8hNwQzE5XAya1KwYpDFKrjs a3QQQCOhpDQtULq/2HZCQSOrUuoTSRhUQ4DA5NZlAMCcnJq7YXDLIIiSVbp7GqVPjd4nEi8EdDim I3TnIHSmnKnC5xWfZ3DNO3mMTuGfyrS3r/epFHP0ValsJYwSvzgdcVVpkhRRRQAUUUUAFFFFABVi 2uTA2Dyh6+1V6KAN5SpAYLwehpRkZAxjtWZbXvlhY5eUHQ+laKSJjO8EHkHNIodyMDGPekOd2GPF NNxCGGZU/wC+qrzX8KnC5c+1AFxRhaWoLa6S4BwNrDsamznoaAGvz/nvTycDmmnhfr1pcACgBDk8 joP1pcn04o3D1pMgdAcfSgBST6UgHOOw5p2Qab90+x60AOqCeHzQRvK56EVPRmgCmmnQgclm/Gq1 +kUTJHGoHGTWjI6RIZGGMfrWLJI0sjO3UmgTGUUUUxBRRRQAVq2E4eHYT8yfyrKoBI6GgZavXM0n mLzGPlB96q1ZS4RbNoSmWJyDVagQUueMUlFAFixz9qXHvTHL+a+4kHccjNOMM9tiXoOzA5q4LeO7 UTMDlhzzQMubT3I568VlX8Plz7geH5rXpGVXXDAEehpDOforVn0+NwTH8jfpVZtOmVSQVb2B5pis U6KUgqSCMEdqSgQUUUUAFFFFABRRRQAUUUUAFX9OZ8uB90Dp71Qq9p9wkZMb4G48GgZo5bOCBzQA cjJ560DJwcDFKOeaQxcc5ooooAaRlh7daAVLfKc+uKilDSo6L1II56UlrbtbxkEjcTzjpQBPtHp1 ppdIotzEKvWhpFSNnbgKOax7i4adueFH3RQA+7uzcHaBhB29arUUUyQooooAKKKKACiiigAooooA KKKKALlncYPlOMxtxg9jV1baSPKxTsqZyB6VjggHkZFaEF8qwhZMsw4z60DNCiiikMKKKKAIZreK UEsgLY61iVq39z5aeWh+dhyfQVlUxMKKKKBBRRRQAUUUUAFFFFABRRRQBs2redArk5PQ1NuAyCRm qOmOdsidhg1oUihAc9iDS0hyCDjNIGGMkEfWgCJMpcup6P8AMv8AWp6YFVgCQCR37imiQicxnkbc igCHUf8Aj1/EVk1uzIJomjIOCOtYVMTCiiigQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB0NFFFIo KKKjnkEUDv6Dj60AYkjmSRmY5JNNoopkhRRRQAUUUUAFFFFABRRRQAUUUUAbdtEIoFAGCRk/Wpqg tZFngDDqODzU20ds/nSKAjJANLTNpJPzHg0Yx1JK+9AC5APA+pqMpiZXzzjGPXmpqhlmSGLe3PPA Hc0ASswRSzHAHU1gfebgdTxUk1xJO2XbjsOwp1p/x9x4GeaYi1aWLK4kmA46LVa9CrduF+p+tbJI AyelYMshllZz3NIGMooopiCiiigAooooAKKKKACiiigAooooA6AHI96WmqDyT3qC+cpathsE8Uig mvooh8p3t6A1QubxrhQu3ao5xnOarUUxBRRRQIKKKKACiiigAooooAKKKKACiiigC3p8hW5C54YY Na1YMT+XKj+hBrcWRWAIOQRkGkNAn3Qe55pSe3UmmovyDP5U4AL/APXNAxuCB941Fe7fsj5x7VM4 3L14rEnkMkzksSMnH0oEyOrenEfaTnGdpxVSlBIIIJBHcUxGvfSeXbMO7fKKx6c7vIcuxY+5ptAw ooooEFFFFABRRRQAUUUUAFFFFABRRRQBuyzCFCz9hx71jzzvOwZ8cdAKKKQ2RUUUUxBRRRQAUUUU AFFFFABRRRQAUUUUAFFFFABWjpsrHdEegGR7UUUDNCkOMcnFFFIZm3l2pUxRHI/ib1qjRRTJCiii gAooooAKKKKACiiigAooooAKKKKACiiigAooooA//9k=