Reports - danmarksmiljoeportal/rotter GitHub Wiki

Afsluttede rotteanmeldelser

A chart showing the monthly report of rat occurrence incidents by each authority. This report helps us track the frequency of rat occurrences per authority on a monthly basis.

Database

  • Results come from table: [report].[AnmeldelseMaaned]

Access

Recalculate Logic

  • No results were manually imported
  • Results are calculated periodically for each RA from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Rotter: Retrieves RA that involve rotters
  • Andre dyr: Retrieves RA that involve other animals

Results

  • Return total number of RA that have no parent, are not deleted and are completed, grouped by month and year for each municipality

Andel af kommuner med kloakrottebekæmpelse i hovedledningerne

A chart showing the annual report about sewer extermination

Database

  • Results come from table: [report].[KloakBekaempelse]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are calculated periodically for each RA from 2015 to the current year.

Filters

År (year)

  • "Fra år": from year (2007 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubbmission

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Results

Return the number of municipalities that report sewer extermination (KloakBekaempelse) as true in their YearlySubmission (Indberetning), grouped by year.

Bekæmpelsesmetoder

A chart showing the development of different Extermination Methods given to Rat Occurrences over yearly periods.

Database

Recalculate Logic

  • No results were manually imported
  • Results are calculated periodically for each RA from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2015 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Results

Return total count of RA for 5 Extermination Methods (Bekaempelsestypes)

  • Elektriske fælder
  • Andet ( f.eks. skydevåben, hund m.m.)
  • Levende fangende fælder
  • Udlægning af gift
  • Smækfælder

That RA records is grouped by year and apply filter with:

  • Have no parent, are not deleted and are completed, grouped by year for each municipality.
  • Bekaempelsesudfoerende in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma') or Bekaempelsesudfoerende = null

With Hele landet, we will sum total of all municipality

Gebyr for den kommunale rottebekæmpelse

A table showing information about the status ActionPlanFeeCharged (HandlingsplanOpkraevesGebyr) of YearlySubmission (Indberetning)

Database

  • Results come from table: [dbo].[Indberetning]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are calculated periodically for each RA from 2015 to the current year.

Filters

Kommune (municipality)

  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2007 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubbmission

Results

Return the percentage of municipalities that report an ActionPlanFeeCharged as true in their YearlySubmission, grouped by year. Also, return the status of the filtered municipalities regarding the action plan fee charged in their YearlySubmission for that year.

Hvem varetager bekæmpelsen

A chart showing summary of RA that extermination conducted by R1 users, R2 users or municipalities

Database

  • Results come from table: [report].[HvemVaretagerBekaempelsen]

Access

Recalculate Logic

  • That have records which manually imported at 2018
  • Results are calculated periodically for each RA from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2019 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Vis for (Display for) That filter for three zones or everywhere

  • Landzone: Land zone
  • Byzone: Urban zone
  • Sommerhusområde: Cottage area
  • Overalt: Everywhere (zone in RA is null or equals to three zones above)

Results

Return total count of RA for three ExterminationPerformedBy (Bekaempelsesudfoerende) types with filtered zones and municipality:

  • Kommunal bekæmpelses: That ExterminationPerformedBy not in ('Privat bekæmpelse (R1-autorisation)', 'Privat bekæmpelse (R2-autorisation)')
  • R1-autoriseret - bekæmpelsesfirma: That ExterminationPerformedBy equal 'Privat bekæmpelse (R1-autorisation)'
  • R2-autoriseret - bekæmpelse på egen ejendom: That ExterminationPerformedBy equal 'Privat bekæmpelse (R2-autorisation)'

That RA records is grouped by year and apply filter with:

  • Have no parent, are not deleted and are completed
  • Animal = Rotte (Dyr)

Indikatorer for den Kommunale Rottebekæmpelse

A chart showing the performance of municipality managed Rotteanmeldelse activities.

Database

  • Results come from table: [report].[Effektiv]

Access

Recalculate Logic

  • No results were manually imported
  • Locked results (meaning they are locked for change): 2015, 2016, 2017
  • Results calculated recurringly: 2018, 2019, 2020, 2021

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross the entire country
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

Anmeldelsesdato til første besøg INDE (dage gns) per municipality(m)/year(y) AVERAGE number of days across RA it took between the date that a Rotteanmeldelse (RA) was reported (Anmeldelsesdato) until the first date that a visit was done ( earliest related Opfoelgningsdatoer) WHERE the visit was indoors (IsIndendoers=TRUE) AND had at least one visit (count (Opfoelgningsdatoer>=1) AND was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0)).

Anmeldelsesdato til første besøg INDE (dage gns) per year(y) for the whole country AVERAGE number of days across RA it took between the date that a Rotteanmeldelse (RA) was reported (Anmeldelsesdato) until the first date that a visit was done (earliest related Opfoelgningsdatoer) WHERE the visit was indoors (IsIndendoers=TRUE) AND had at least one visit (count (Opfoelgningsdatoer>=1) AND was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0)).

Anmeldelsesdato til første besøg UDE (dage gns) per municipality(m)/year(y) AVERAGE number of days across RA it took between the date that a Rotteanmeldelse (RA) was reported (Anmeldelsesdato) until the first date that a visit was done (earliest related Opfoelgningsdatoer) WHERE the visit was indoors (IsIndendoers=FALSE) AND there was at least one visit (count of Opfoelgningsdatoer>=1) AND was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0).

Anmeldelsesdato til første besøg UDE (dage gns) per year(y) for the whole country AVERAGE number of days across RA it took between the date that a Rotteanmeldelse (RA) was reported (Anmeldelsesdato) until the first date that a visit was done (earliest related Opfoelgningsdatoer) WHERE the visit was indoors (IsIndendoers=FALSE) AND there was at least one visit (count of Opfoelgningsdatoer>=1) AND was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0).

Gennemsnitlige besøg per anmeldelse per municipality(m)/year(y) AVERAGE number of visits (count of related Opfoelgningsdatoer) of each RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Gennemsnitlige besøg per anmeldelse per year(y) for the whole country AVERAGE number of visits (count of related Opfoelgningsdatoer) of each RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Antal steder med kun ét besøg (pct) - Gift per municipality(m)/year(y) Result is NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: Count total number of RA WHERE just one visit (=where COUNT of related Opfoelgningsdatoer=1) AND RA.Bekæmpelsestyper IN ("Udlægning af gift") and RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: Count total number of RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA.Bekæmpelsestyper IN ("Udlægning af gift") AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Antal steder med kun ét besøg (pct) - Gift per year(y) for the whole country Result is NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: Count total number of RA WHERE just one visit (=where COUNT of related Opfoelgningsdatoer=1) AND RA.Bekæmpelsestyper IN ("Udlægning af gift") and RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: Count total number of RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA.Bekæmpelsestyper IN ("Udlægning af gift") AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Antal steder med kun ét besøg (pct) - Fælder per municipality(m)/year(y) Result is d NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: COUNT total number of RA WHERE RA has just one visit (COUNT of related Opfoelgningsdatoer=1) AND RA.Bekæmpelsestyper IN {"Smækfælder" OR "Levende fangende fælder" OR "Elektriske fælder"} (i.e. just one or more of these to be included) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: COUNT total number of RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA.Bekæmpelsestyper IN {"Smækfælder" OR "Levende fangende fælder" OR "Elektriske fælder"} (i.e. just one or more of these to be included) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Antal steder med kun ét besøg (pct) - Fælder per year(y) for the whole country Result is d NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: COUNT total number of RA WHERE RA has just one visit (COUNT of related Opfoelgningsdatoer=1) AND RA.Bekæmpelsestyper IN {"Smækfælder" OR "Levende fangende fælder" OR "Elektriske fælder"} (i.e. just one or more of these to be included) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: COUNT total number of RA WHERE one or more visit (=where COUNT of related Opfoelgningsdatoer>0) AND RA.Bekæmpelsestyper IN {"Smækfælder" OR "Levende fangende fælder" OR "Elektriske fælder"} (i.e. just one or more of these to be included) AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0).

Technical Note

  • We exclude records with 0 visits (=where COUNT of related Opfoelgningsdatoer=0) from both numerator and denominator, as we will assume these are unclean records.

Orientering of giftudlægning (pct) per municipality(m)/year(y) Result is NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: COUNT RA WHERE "Ejer, lejer eller dennes repræsentant informeret om giftudlægning"([BeboereInformeret])=TRUE AND RA.Bekæmpelsestyper IN "Udlægning af gift" AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: COUNT RA WHERE RA.Bekæmpelsestyper IN "Udlægning af gift" RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND municality=(m) AND year=(y) AND the RA is not deleted (IsDeleted=0).

Orientering om giftudlægning (pct) per year(y) for the whole country Result is NUMERATOR / DENOMINATOR AS PCT (*100) NUMERATOR: COUNT RA WHERE "Ejer, lejer eller dennes repræsentant informeret om giftudlægning"([BeboereInformeret])=TRUE AND RA.Bekæmpelsestyper IN "Udlægning af gift" AND RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND RA is not deleted (IsDeleted=0). DENOMINATOR: COUNT RA WHERE RA.Bekæmpelsestyper IN "Udlægning af gift" RA was managed by municipalities ([Bekaempelsesudfoerende] in ('Kommunal bekæmpelse - eget personale','Kommunal bekæmpelse - bekæmpelsesfirma',NULL)) AND year=(y) AND the RA is not deleted (IsDeleted=0).

Kommunal rottebekæmpelse udlicitering eller eget personale

A table showing information about the status ExterminationPerformedBy (Bekaempelsesudfoerende) of YearlySubmission (Indberetning)

Database

  • Results come from table: [report].[Bekaempelsesudfoerende]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2017
  • Results calculated recurringly: 2018 to current

Filters

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubbmission

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Results

Return total count of all municipality's yearlysubmission of three types below:

  • Egen rottebekæmpelse
  • Udliciteret bekæmpelse
  • Egen og udliciteret bekæmpelse

when grouped by year

Kommunale handlingsplaner

A table showing some of the latest information about municipalities' action plans ("handlingsplaner").

Database

  • Results come from table: [dbo].[Indberetning]

Access

Data Logic All data for this report is extracted from [dbo].[Indberetning] We get data per municipality (m) for each row.

  • "Kommune" = (m)
  • "Link til handlingsplan" = get all [dbo].[Indberetning] related to (m) where [HandlingsplanLink] is NOT NULL. Select among these the one belonging to [Indberetning] which has highest value for [Aar]. Show value from [HandlingsplanLink]. "Begrænsning på den private bekæmpelse" = get all get all [dbo].[Indberetning] related to (m) where [RestriktionPrivatFirma] is NOT NULL. Select among these the one belonging to [Indberetning] which has highest value for [Aar].
    • Show value "Nej" if [RestriktionPrivatErhverv] = FALSE AND [RestriktionPrivatFirma] = FALSE
    • Show value "Ja" if [RestriktionPrivatErhverv] = TRUE OR [RestriktionPrivatFirma] = TRUE
  • "Senest revideret" = get all [dbo].[Indberetning] related to (m) where [HandlingsplanRevisionsDato] is NOT NULL. Select among these the one belonging to [Indberetning] which has highest value for [Aar]. Show value from [HandlingsplanRevisionsDato].

Kommunernes og forsyningernes kloakrottebekæmpelse

A chart showing statistical data on the use of traps and poison for rat extermination of municipalities

Database

  • Results come from table: [report].[KloakMidler]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are re-calculated from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubmission (Indberetning)

Results

Return total count of filtered municipality of three types below:

  • Kilogram gift
  • Rottespærer
  • Elektroniske aflivningsfælder

when grouped by year

Rotteanmeldelser (indendørs udendørs)

A chart showing statistical data on the location where rats were found, indicating whether it was indoors or outdoors

Database

  • Results come from table: [report].[AnmeldelseAar]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Results

Return the total count of RA that shows the locations where rats were found in the filtered municipality: InDoor Or OutDoor

Rotteanmeldelser (rotter andre dyr)

A chart showing statistical data on the RA indicating whether Rotte was found or another animal was found.

Database

  • Results come from table: [report].[AnmeldelseAar]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

A chart showing data on the RA indicating whether Rotte was found or another animal was found.

Rotteanmeldelser fordelt på ejendomstyper

A chart showing statistical data on the property type of RA

Database

  • Results come from table: [RotteanmeldelserPerEjendomstype]

Access

Recalculate Logic

  • No results were manually imported
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

A chart showing the total count of each property type defined in RA

Rotteanmeldelser inkl. rotter registreret ved kampagnebesøg i landzone landbrugsejendomme i byzone

A chart showing statistical data on the IsSupervision (IsTilsyn) of RA

Database

  • Results come from table: [report].[AnmeldelseAar]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

A chart showing the total count of IsSupervision (IsTilsyn) status of RA

  • Rotteanmeldelser fra kampagne: IsSupervision = true
  • Rotteanmeldelser fra andet end kampagne: IsSupervision = false

Rottespærrer på kommunale institutioner

A chart showing the rat extermination of organizations of municiplaities

Database

  • Results come from table: [Report].[Rottespaerer]

Access

Recalculate Logic

  • No results were manually imported
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubmission (Indberetning)

Results

Return data of filterd municipality with grouped by year:

  • Procent kommunalt ejede institutioner i kommunen, hvor der er monteret rottespærrer
    • Percentage of municipally owned institutions in the municipality where rat barriers are installed
  • Procent kommunalt ejede institutioner i hele landet, hvor der er monteret rottespærrer
    • Percentage of municipally owned institutions nationwide where rat barriers are installed
  • Antal kommunalt ejede institutioner, m.v.
    • Number of municipally owned institutions, etc.
  • Antal rottespærrer i brug på kommunale institutioner
    • Number of rat barriers in use at municipal institutions

Rottespærrer på private, statslige og regionale institutioner m.v.

A chart showing the private rat extermination of organizations of municiplaities

Database

  • Results come from table: [report].[RottespaererPrivate]

Access

Recalculate Logic

  • No results were manually imported
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2018 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year of YearlySubmission (Indberetning)

Results

Return data of filterd municipality with grouped by year:

  • Procent private, statslige, og regionale institutioner, m.v. i hele landet, hvor der er monteret rottespærrer
    • Percentage of private, state, and regional institutions, etc., nationwide where rat barriers are installed
  • Procent private, statslige, og regionale institutioner, m.v. i kommunen, hvor der er monteret rottespærrer
    • Percentage of private, state, and regional institutions, etc., in the municipality where rat barriers are installed
  • Antal private, statslige, og regionale institutioner, m.v. der takker nej til kommunens tilbud om opsætning af rottespærrer
    • Number of private, state, and regional institutions, etc., that decline the municipality's offer to install rat barriers
  • Antal rottespærrer i brug på private, statslige, og regionale institutioner, m.v. i kommunen
    • Number of rat barriers in use at private, state, and regional institutions, etc., in the municipality
  • Antal private, statslige, og regionale institutioner, m.v. i kommunen
    • Number of private, state, and regional institutions, etc., in the municipality

Udviklingen i brug af gift (brutto)

A chart showing the gross quantity of poison used for rat extermination by the municipality

Database

  • Results come from table: [report].[GiftForbrugPerStyrke]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2007 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

Return quantity of poison with each strength level. We have four strength levels of poison, and three factors: Municipality, R1 user, and R2 user.

Udviklingen i brug af gift (netto)

A chart showing the net quantity of poison used for rat extermination by the municipality

Database

  • Results come from table: [report].[GiftForbrugPerStyrke]

Access

Recalculate Logic

  • That have records which manually imported from 2007 to 2014
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2020 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Results

Return quantity of poison with each strength level after deducting the amount returned. We have four strength levels of poison, and three factors: Municipality, R1 user, and R2 user.

Årsager til rotteanmeldelse

A chart showing statistical data on the reason type of RA

Database

  • Results come from table: [report].[RotteanmeldelserPerAarsagType]

Access

Recalculate Logic

  • No results were manually imported
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

År (year)

  • "Fra år": from year (2015 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Vis for (Display for) That filter for three zones or everywhere

  • Landzone: Land zone
  • Byzone: Urban zone
  • Sommerhusområde: Cottage area
  • Overalt: Everywhere (zone in RA is null or equals to three zones above)

Results

Return total count of each reason type with filtered municipality and zones. That RA records is grouped by year and apply filter with:

  • Have no parent, are not deleted and are completed

Årsager til rotteanmeldelse detaljeret

A chart showing statistical data on the reasons of RA

Database

  • Results come from table: [report].[RotteanmeldelserPerAarsag]

Access

Recalculate Logic

  • No results were manually imported
  • Results are recalculated periodically, covering data from 2015 to the current year.

Filters

Kommune (municipality)

  • "Hele landet" calculates values accross all municipalities
  • 98 municipalities in dropdown

Årsagstype

  • ReasonType (aarsagtype) with 4 value in dropdown

År (year)

  • "Fra år": from year (2015 - current year)
  • "Til år": to year ("Fra år" - current year)
  • The year an RA belongs to depends on its anmeldelsesdato i.e. which year it is within: 1/1-{year} to 31/12-{year}

Vis som (Display as)

  • Absolut: Displays the total count as an absolute number.
  • Procent: Displays the total count as a percentage.

Vis for (Display for) That filter for three zones or everywhere

  • Landzone: Land zone
  • Byzone: Urban zone
  • Sommerhusområde: Cottage area
  • Overalt: All areas (RA zone is either null or includes the above three zones)

Results

Returns the total count of each reason based on the filtered municipality, zones, and reason type. RA records are grouped by year and filtered to:

  • Exclude any records with parents
  • Exclude deleted records
  • Only include completed records