U
U
un1t2018-12-13 14:49:13
GIS
un1t, 2018-12-13 14:49:13

FIAS how to filter out irrelevant records?

I unloaded the database by filtering by actstatus and livesstatus , however, there are a lot of duplicates in the database.
There are many settlements with the same name and which have the same parent.
For example, the city of Sertolovo. FIAS contains two entries. How do you understand that
1) this is one and the same region.
2) one of the records is not relevant?
Sertolovo

[
  {
    "currstatus": 0,
    "extrcode": "0000",
    "livestatus": 1,
    "plaincode": 47005002000,
    "aoguid": "79b806cd-e36c-48fc-b82c-8cbb5cfd9450",
    "autocode": 0,
    "streetcode": "0000",
    "startdate": "2014-04-30",
    "terrifnsfl": "",
    "parentguid": "db8758d6-b8ea-453d-a75f-8f2d3ff49fb0",
    "aoid": "b4789f6b-9dd9-471c-b311-a6227b6a11d6",
    "enddate": "2079-06-06",
    "plancode": "0000",
    "aolevel": 4,
    "ctarcode": "000",
    "shortname": "г",
    "terrifnsul": "",
    "okato": 41450000000,
    "offname": "Сертолово",
    "ifnsul": 4703,
    "formalname": "Сертолово",
    "actstatus": 1,
    "centstatus": 0,
    "ifnsfl": 4703,
    "sextcode": "000",
    "oktmo": 41612102001,
    "updatedate": "2015-09-15",
    "operstatus": 21,
    "previd": "61c65587-dac8-42b9-9150-576310ab05ad",
    "nextid": "",
    "areacode": "005",
    "placecode": "000",
    "citycode": "002",
    "postalcode": "",
    "regioncode": 47,
    "code": 4700500200000
  },
  {
    "currstatus": 0,
    "extrcode": "0000",
    "livestatus": 1,
    "plaincode": 47000000001,
    "aoguid": "5a86f05b-b29e-4313-ab41-43474c72de97",
    "autocode": 0,
    "streetcode": "0000",
    "startdate": "2015-11-11",
    "terrifnsfl": "",
    "parentguid": "6d1ebb35-70c6-4129-bd55-da3969658f5d",
    "aoid": "5a86f05b-b29e-4313-ab41-43474c72de97",
    "enddate": "2079-06-06",
    "plancode": "0000",
    "aolevel": 6,
    "ctarcode": "000",
    "shortname": "г",
    "terrifnsul": "",
    "okato": 41450000000,
    "offname": "Сертолово",
    "ifnsul": 4700,
    "formalname": "Сертолово",
    "actstatus": 1,
    "centstatus": 0,
    "ifnsfl": 4700,
    "sextcode": "000",
    "oktmo": 41612102,
    "updatedate": "2015-11-26",
    "operstatus": 10,
    "previd": "",
    "nextid": "",
    "areacode": "000",
    "placecode": "001",
    "citycode": "000",
    "postalcode": 188650,
    "regioncode": 47,
    "code": 4700000000100
  }
]

Answer the question

In order to leave comments, you need to log in

1 answer(s)
R
Rsa97, 2018-12-13
@un1t

Zhemchuzhnikova is a village in the Menshekolodezsky rural settlement of the Dolgorukovsky district of the Lipetsk region.
Zhemchuzhnikova is a village in the Bolsheboevsky rural settlement of the Dolgorukovsky district of the Lipetsk region.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question