---
# System prepended metadata

title: 'Reference : Airport and City Coding Directory (LOID)'

---

# Reference : Airport and City Coding Directory (LOID)

LOID is a table for airport and coding directory reference.

## :memo: Table of Contents
[ToC]

## LOID Design

![](https://i.imgur.com/E9EkOgb.jpg)


## REST APIs for Airport and City Coding Directory resource

- GET  /references/airport-and-city-coding-directory
```java
    public Paged<AirportCityCodingDirectory> retrievePagedAirportAndCityCodingDirectory(
        @Valid AirportCityCodingDirectoryFilterTO filter, Page page){
        return service.retrievePagedAirportAndCityCodingDirectory(filter,page);
    }
```
     
- POST /references/airport-and-city-coding-directory
```java
    public void createAirportAndCityCodingDirectory(
        @Valid @RequestBody AirportCityCodingDirectory airportCityCodingDirectory)
        throws EdgarException {
        service.createAirportAndCityCodingDirectory(airportCityCodingDirectory);
    }
```
- PUT  /references/airport-and-city-coding-directory
```java
    public void modifyAirportAndCityCodingDirectory(
        @Valid @RequestBody AirportCityCodingDirectory airportCityCodingDirectory)
        throws EdgarException {
        service.modifyAirportAndCityCodingDirectory(airportCityCodingDirectory);
    }
```
    
- DELETE /references/airport-and-city-coding-directory/{id}
```java
    public void deleteAirportAndCityCodingDirectory(
        @PathVariable("id") @NotNull Integer airportAndCityCodingDirectoryIdentifier)
        throws EdgarException {
        service.deleteAirportAndCityCodingDirectory(airportAndCityCodingDirectoryIdentifier);
    }
```



## LOID Filter


- AirportCityCodingDirectoryFilterTO 

         public class AirportCityCodingDirectoryFilterTO {

            private String cityCode;
            private String city;
            private String airportCode;
            private String airport;
            private String isoCountryCode;
            private LocalDate endDate;
            private List<String> sortBy;
        }

## LOID Model
- AirportCityCodingDirectory

        public class AirportCityCodingDirectory extends Entity {

        /*
         * locationId maps upon LOID.LOID
         */
        private String locationId;

        /*
         * city maps upon LOID.CITY
         */
        private String city;

        /*
         * stateCode maps upon LOID.STPC
         */
        private String stateCode;

        /*
         * isoCountyCode maps upon LOID.ISCC
         */
        private String isoCountryCode;

        /*
         * timeZone maps upon LOID.TMZO
         */
        private String timeZone;

        /*
         * standardTimeVariation maps upon LOID.STVC
         */
        private String standardTimeVariation;

        /*
         * airportCode maps upon LOID.APTC
         */
        private String airportCode;

        /*
         * airportName maps upon LOID.APTN
         */
        private String airportName;

        /*
         * numericCode maps upon LOID.NUCO
         */
        private String numericCode;

        /*
         * countryCode maps upon LOID.ISOC
         */
        private String countryCode;

        /*
         * iataZone maps upon LOID.IAZN
         */
        private Integer iataZone;

        /*
         * iataSubZone maps upon LOID.IASZ_CODE
         */
        private String iataSubzone;

        /*
         * typeOfLoid maps upon LOID.TYPE
         */
        private String typeOfLoid;

        /*
         * endDate maps upon LOID.ENDA
         */
        @NotNull
        @JsonFormat(pattern = "dd/MM/yyyy")
        private Date endDate;

        private String sequenceNumber;
        }


- Exception Translation to be added on front.

       
      REFERENCE_LOID_EXISTS("error.exception.reference_loid_exists")
   