Municipal Property Management: From Registers to a Map

A municipal property management system brings every parcel a municipality owns into one record, with its title, lease, allocation, unauthorised-use and document history, and shows that record on a map. Unlike a spreadsheet, it answers "which property is where, who is using it, under what contract and until when" from a single screen.

In many municipal property departments this information is still spread across Excel files, accounting records and filing cabinets. Below we look at what goes wrong in that set-up, what a GIS (geographic information system) based system changes, which data you can start with and how to phase the move.

Where municipal property tracking breaks down today

A familiar picture: the property department keeps a register that has grown over the years, with block and parcel numbers, neighbourhood, area and a few notes columns. Leases sit in another file, allocation decisions in another folder, and the map lives in the planning or GIS unit. This works while the portfolio is small. As it grows, the problems pile up.

Parcel data in several places, all slightly different

The same parcel appears in the register with one area, in accounting under another name, and on the map with a new number after a subdivision. Often only one person knows which version is current.

Lease end dates are missed

The end date sits in a spreadsheet column but reminds nobody. By the time an expired contract is noticed, the time needed for a new tender or eviction procedure may have passed, which means lost income and extra legal work.

Unauthorised use is spotted late

A list can't show which property is vacant, leased or occupied without permission. Occupation is often found through a complaint or a chance visit, and the later it is found, the harder it is to build the file for a use-and-occupation charge (ecrimisil in Turkish law).

Documents in folders, map out of step

Title deeds, contracts, council decisions and site photos live in physical files, so answering one question means a trip to the archive. And without a shared key between the map layer and the register, a simple question such as "do we own any vacant land in this neighbourhood?" turns into days of manual work.

Current state vs a GIS-based system

Current state	With a GIS-based system
Register in Excel, map in a separate program	Every block/parcel on the map; click it to see everything
Lease end date in a column, no reminder	Automatic alert before expiry
Vacant, leased and allocated properties filtered from a list	Each status shown as its own coloured layer
Occupation found by complaint or by chance	Site findings linked to the parcel with photo and location
Documents in physical folders	Deeds, contracts, decisions and photos attached to the record
Reports built by merging files by hand	Portfolio, income and vacancy reports from the system
No record of who changed what	Every change logged with user and date

What a GIS-based municipal property management system adds

Parcels on the map, data in one place

Each property is shown with its cadastral boundary. Clicking a parcel opens its block, parcel and sheet numbers, area, land use, ownership shares, any lease or allocation, and linked documents.

Layers and spatial queries

Zoning, leased, vacant and allocated properties and recorded occupations can be stacked as layers. Select a neighbourhood and the municipally owned vacant parcels appear with their areas in a few clicks, something a spreadsheet filter cannot do.

Contract expiry alerts

Once an end date is entered, the system alerts the relevant staff a set period beforehand and lists every contract nearing expiry, so tender or renewal preparation doesn't slip into the final week.

Tracking unauthorised-use cases

Field teams record the photo and location of an occupation on a mobile device, directly against the parcel. Each step, from finding and calculation to notification and collection, is visible. The calculation method is set by legislation and the institution's practice; the software doesn't decide it, it makes sure no case is lost.

Document archive and reports

Documents are stored against the property record, so a parcel's history can be read on screen. Portfolio, lease income, expiring contracts and open cases are available as ready-made reports for the council or senior management.

What data do you start with?

Most municipalities already have the data; it is just scattered.

• Existing registers: Excel exports are imported after block and parcel numbers are checked for consistency.
• Title and cadastral data: Parcel boundaries and title details can come from cadastral data the municipality holds or from the mapping unit.
• Map layers: Zoning, neighbourhood and road layers in formats such as Shapefile, GeoJSON and KML can be imported.
• Contracts: Dates, amounts and parties for leases and allocations, starting with active contracts.
• Documents: Scanned and matched to records gradually; there is no need to scan everything at once.

The slowest part is reconciling parcels that differ between the register and the map. Doing it early speeds up every later step.

Working alongside existing systems

A GIS-based property system doesn't have to replace existing software. In Turkey, the Ministry of Interior's e-Municipality information system includes a property module, and most municipalities run their own accounting and revenue software. The aim is to fill the gap in mapping and process tracking, not to replace them.

• Accounting: Accruals and collections can stay in accounting; the property system can read them to flag overdue leases.
• e-Municipality and other systems: Data can be exchanged as far as technical access and permissions allow, agreed with the IT unit at the outset.
• Mapping unit: Layers can be shared through standard formats.

Each connection is a separate piece of work. If a proposal promises "full integration", ask which system, which data and how often; our guide on how to evaluate a software proposal applies in the public sector too.

A phased rollout plan

1. Inventory and map: Clean the register and match parcels to the map.
2. Lease and allocation tracking: Enter active contracts and switch on expiry alerts. This usually shows its effect on income fastest.
3. Document archive: Scan leased and problem properties first, then the rest.
4. Occupation cases and fieldwork: Field teams start recording findings on mobile.
5. Reports and connections: Add management reports and data exchange with accounting.

Each phase starts once the previous one's data has settled. The same clean-up and phasing principles appear in moving from Excel to ERP, even though the subject differs.

Legislation, data protection and access control

In Turkey, leasing municipal property and charging for unauthorised use are largely governed by State Tender Law No. 2886, while Municipal Law No. 5393 sets out which property decisions the council or committee takes. The software records the process; it doesn't change the rules. For methods, deadlines and powers, rely on current legislation and your legal department.

Property records hold personal data such as tenant and owner names and contact details. Under KVKK, Turkey's data protection law:

• Each user sees only what their role requires.
• Who viewed or changed which record, and when, is logged.
• Any public version of the map excludes personal data.
• Hosting and back-ups follow the institution's security policy.
• Retention and deletion rules are set with the institution's data inventory.

Where to start

• Is there one up-to-date list of the property you own?
• Can you list every lease ending in the next six months within five minutes?
• Can you show your register's parcels on a map?
• Do you know which stage each open occupation case is at?
• Can you reach a parcel's deed, contract and photos without visiting the archive?

If two or more answers are "no", matching the inventory to the map is a sensible first step. Our GIS real estate management system page lists the modules and data formats. Bring a copy of your property register, and we can walk through a sample parcel together to see how the system would fit your institution.