#1rando FIG Working esemen at the Fit Working Week 2023, June 2023 In Orlando, Florida, USA IG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Presia Using Cadastral Records and Geospatial. 1Juneting Automated Land Use Taxes in Kano State, 281 Information System Adamu BALA (China) 1'3 and Zia-Ul-Haq Tukur BELLO1'2 (Nigeria) Presenter: Adamu BALA Protecting Our World, Conquering New Frontiers 1 Department of Geomatics, Ahmadu Bello University, Nigeria 2 Kano State Bureau for Land Management, Nigeria 3 China University of Geosciences, Wuhan, China, P.R. Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS OF GEOSCIEN UNIVERSITY OF GEOSCIE CHINA GEOSCIENC CIENCES Diamond Sponsors esri Trimble THE SCIENCE OF WHERE®#2** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers PRESENTATION OUTLINE ● ● INTRODUCTION MATERIALS AND METHODS RESULTS AND ANALYSES CONCLUSION Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 地质 UNIVERSITY NA UNIVER CHINA OF 大学 GEOSCIE Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#3FIG ** rando Working Week 2023 FIG WORKING WEEK 2023 INTRODUCTION 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers • Kano municipal is one of the most populous and commercial hubs in Nigeria. • A lot of business activities taking place in the area are spatially related to land records. • Land uses tax collections generate revenue to a government which leads to good governance. Cit Parcel Editor 372 00 202 374 408 409 410 411 375 419 578 N20 377 420 321 CB 12 928 29 431 415 410 432 433 398 018 019 563 665 67 60H OF BAD 6652 500 4905600 561 562C 663C 453 454 PIECE OF LAN 434 435 466 450 473 474 438 437 457 19-456 478 519 521 438 439 523 525 52729 531 459 480 478 520 440 441 522 524 532 402 401 479 480 530 443 CENTRE 442 533 C-51 C-52 403 404 401 402 445 444 446 447 405 460 483 484 634 535 530 407 408 435 486 449 501 503 505 67 509 571 448 537 538 409 470 487 488 5650 450 451 452 539 540 200 471 472 489 48 502 66 600 580 570 572 PIECE OF L 541 542 de OF LAND 30.0 49 493 495 497 40501 503 505 507 509 1115 517 543 544 575 575 577 581 509 0700 545 540 442 494 496 488 500 502 50506 508 510 512 514 510 518 574 576 578 580 582 584 547 548 PIECE OF LAME 地质 氣大学 Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS HD 中国 CHINA NA UNIVER UNIVERSITY ROSCIENCES#4FIG ** rando Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Introduction cont. ● Protecting Our World, Conquering New Frontiers Before now, existing methods of tax collection have been tedious, slow, time-consuming, and prone to errors and corruption, among other things. · This paper explained how the cadastral survey records were utilized to generate land use charges for various land use categories. Adoption of this new method of land use tax collection has since its inception witnessed an upward inflow of land revenue generation in the State. MV 中国 CHINA UNIVE 地质 UNIVERSITY GEOSCIE Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS#5** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers Introduction: study area ■ The Kano State is one of the 36 States in Nigeria. ■ The most populous state in the country (2006 Census). ■ The Kano state was created in 1967; covers area of 20,131km² and Kano metropolis has 8 LGAS. N..0.0.ZL 11°0'0"N MAP OF KANO STATE, NIGERIA Katsina 8°00'E Kaduna Kano 8°00'E 1:2,000,000 9°00'E 0 15 30 60 90 120 Jigawa Bauchi 9°00'E Kilometers 11°0'0"N 12°0'0"N 600E 1000E Niger Cameroon entral African Republ 600E 1000 Legend Local Govt_Boundary STATE BOUNDARY Source GIS Depatment, Kano State Bureau for Land Management 2023 1200°N 12'60'N 11°55'0' MAP OF KANO METROPOLIS, KANO STATE NIGERIA 8250 Dawakin Tofa 830 Ungogo Nassarawa Dala 836CE Mnjbr Gezawa Fagge Gwale Tofa Tarauni Укагаа Gado a250 Madobi Kanc Municipal Kumbotso 8300 8360 1:200,000 0 5 10 Kilometers Dawakin Kudu Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS Figure 1: Map of Kano State, Nigeria 中国 CHINA 地质 UNIVERSITY OF 大学 N.OS.Z N.0.0.2 11'550'N 11-180°N Katsina B150″E SCUE igawa Kaduna Bauchi 815E BOUE Legend Kano_Metropolis Local_Govt_Boundary 11150°N Source:GIS Depatment. Kano State Bureau for Land Management 2023 Figure 2: map of Kano Metropolis. esri Diamond Sponsors Trimble. THE SCIENCE OF WHERE®#6FIG ** rando Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers MATERIALS AND METHODS • Materials in the data capture for the conversion of the data from analogue to digital formats respectively: ✓ Survey Plans; ✓ Layout Composite Survey Plans; Intelligent Chat Sheets; Topographical Maps; High-Resolution Satellite Imagery; ✓ Scanners; ✔ Computer Sets; Digitizing Tablets; ✓ Printers; ✔Esri ArcGIS 10.5, Python IDLE (Pandas, Jupyter Notebook). Organized By FIG NSPS INTERNATIONAL FEDERATION OF SURVEYORS 的中国 NA UNIVER 地质 OF 大学 EOSCIENCES Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#7FIG ** rando Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers MATERIALS AND METHODS cont. • Methods of Data Sources, Acquisition, and Processing: ✓ Sources: ➤ Kano State Bureau for Land Management through the departments of Cadaster, Survey, and GIS ➤the majority of data were in analogue formats were acquired mostly from ground/field survey, aerial photographs (photogrammetry), generated as far back as the 1970s and maintained Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 的中国 地质 UNIVERSITY NA UNIVER OF 大学 GEOSCIE Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#8** rando FIG Working Week 2023 FIG WORKING WEEK 2023 METHODS cont. ✓ Processing: 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers The topo maps and layout composite survey plans were scanned with very high dots per inch pixel values. About fifty (50) thousand land parcels were captured and attributed. ➤Various land use categories were assigned different rates, ➤ domain table of values was created to incorporate these rates and to appropriately assign them according to their land use purpose, location, density, etc. Untitled ArcMap File Edit View Bookmarks Insert Selection Geoprocessing Customize Windows Help 1:12,500 144 Georeferencing L13.TIF Table Of Contents 4 x Layers Butm ☐ L16.TIF L15.TIF L13.TIF Snapping Page Text Editor AM3 Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 石 中国 地质 UNIVERSITY NA UNIVER Parcel Editor & 4±0; 4-INNE Create Features <Search> There are no templates to show. Construction Tools Select a template. 445308.201 1325119.233 Meters 5:13 DM ях Х ☑| AttributesCatalog Figure 3: Scanned Sheet of Composite Survey Plan 大学 Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble. OF GEOSCIE#9** rando FIG Working Week 2023 FIG WORKING WEEK 2023 METHODS cont. ✓ Processing: 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers ➤ A comprehensive geospatial template map was generated and served to every parcel location as a demand notice. ➤ Land use charges from 1999 to 2015 were classified as recovery and calculated cumulatively; the year 2016 upward to date (2023) were calculated independently. ➤ The entire attribution process conformed with the geospatial database schema based on the name of the plot owner, plot no., location, etc. Untitled-ArcMap File Edit View Bookmarks Insert Selection Geoprocessing Customize Windows Help @ a mo Table Of Contents 日 Layers Plot Parcel Plot Parcel ㅁ Butm ☐ L16.TIF L15.TIF L13.TIF + 1:2,000 444 FCE KANO NEW SITE RW Page Text▾ Snapping O Editor Parcel Editor ATGRA 84、新四中四区, Create Features X дх V 22 271 274 Georeferencing L13.TIF 22 30A <Search There are no templates to show. 275 PLA ROUND ду 270 273 787 331 33 3B 334 41 Attributes catalog $166 189 335 338 182 183 132 33 1212 2123 3 33 51 184 224 23 498 467 206 207 236 237 188 189 128 185 2039 228259 1280 89 94 190 191 210 2 280 231 20 ses 1723 192 193 212 213 232 233 148 47 174 175 104-108 108 110 184 186 234/235 196 197 106 107 109 111 218 27 236237 150 151 178 179 198 199 நடடுகம் 218 219 238 239 418 20 22 I 20 201 20 221 AGENT 199 28200 113 1123 mi 8204 158167 Construction Tools 8233 242 244 243 245 247 249 250 253 256 57 2-3 254 253 subl 220 Select a template. 158 159 132 136 B283 133 25 15- 19 19 17 16 15 444900.93 1324966.381 Meters 140 5:16 PM 2/22/2023 13 Type here to search 1/776 30 29 23 21 ALL105 T-13 2.8 27 < F Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS C 石 中国 Figure 4: Digitized and Attributed Survey Data in ArcMap 地质 大学 EOSCIENCES esri Diamond Sponsors Trimble. THE SCIENCE OF WHERE® UNIVERSITY OF#10** rando FIG Working Week 2023 FIG WORKING WEEK 2023 METHODS cont. 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers Untitled - ArcMap File Edit View Bookmarks Insert Selection Geoprocessing Customize Windows Help Qa 6 X+ 1:2,000 Traverse Template... Direction-Distance Direction: Distance: Add # Description: Straight Direction: 348-28-0 Distance: 35.07 4 Straight Direction: 81-56-0 Distance: 69.33 Straight Direction: 168-59-0 Distance: 36.18 6 Straight Direction: 259-13-0 Distance: 15.83 7 Straight Direction: 172-47-0 Distance: 37.64 8 Straight Direction: 167-4-0 Distance: 79.94 9 Straight Direction: 267-0-0 Distance: 44.9 10 Straight Direction: 347-40-0 Distance: 67.79 Straight Direction: 263-6-42 Distance: 60.215 Snapping OBO. | Parcel Editor 图图: Editor 中国 Page Text▾ X Start: 457988.838, 1325047.017 Edit... Closed Loop Adjust.. Endi Edit. Closure... Finish X Table Of Contents + X Create Features Дх <Search> 92 Plot Parcel Plot Parcel Construction Tools Polygon Rectangle Circle Figure 5: Scanned Sheet of Composite Survey Plan Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS Attributes Catalog Layers BUILDINGS Plot Parcel Edit Sketch Properties XZ N Finish Sketch 4 X Attributes Catalog thon Dict Parcell >> import arcpy >> arcpy.env.workspace = r'C:\Users\ZIA-UL-HAQ\Documents\FIG_2023\LUC\FIG_PAPER.gdb' I >> arcpy.AddField management ("Plot Parcel", "LUCS 2016", "DOUBLE",""," "NULLABLE", """) Result 'Plot Parcel'> C 石 中国 ㅁ X Executing: AddField Plot Parcel LUCS 2016 DOUBLE ###⠀ NULLABLE NON REQUIRED # Start Time: Thu Feb 23 03:29:57 2023 Adding LUCS 2016 to Plot Parcel... Succeeded at Thu Feb 23 03:29:58 2023 (Elapsed Time: 0.38 seconds) Figure 6: Result of Python Codes Used for Adding Attribute Field into the Database 地质 CHINA UNIVE UNIVERSITY OF ** esri Diamond Sponsors Trimble THE SCIENCE OF WHERE®#11** rando FIG Working Week 2023 FIG WORKING WEEK 2023 METHODS cont. 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers With the inspection of the topology error, the parcels were then migrated into the LUC_Fabric. Algorithms (i)-(iv) were made and subsequently transformed into python programming codes. LUC = GR+TR+PT+IMDC GR = Ground Rent .(i) = shape_Area(sqm) * Rate ...... ......... (ii) TR = Tenement Rate = Property Value * 0.12% (iii) ......... PT = Property Tax = Property Value * 0.15%....... ..(iv) ....... LUC is the total land use Charge for a particular year IMDC Infrastructure Maintenance Charges = are assigned fixed for residential areas, industries, and commercial land uses. 0.12% for TR and 0.15% for PT were assigned for commercial and industrial land use types. Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 的中国 地质 UNIVERSITY NA UNIVER OF 大学 GEOSCIE Diamond Sponsors esri® THE SCIENCE OF WHERE® Trimble#12** rando FIG Working Week 2023 FIG WORKING WEEK 2023 METHODS cont. 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers Table Of Contents 日 Layers 4 C:\Users\ZIA-UL-HAQ\Documents\FIG_2023 LUC_Folder\LUC_GDI LUC Dataset LUC Fabric LUC_Topology Area Errors Line Errors Point Errors LUC_Polygon ☐ + + C:\Users\ZIA-UL-HAQ\Desktop\Backup 10112022\ADMIN NIGERIA C:\Users\ZIA-UL-HAQ\Desktop\Backup 10112022\PRODUCTION\C C:\Users\ZIA-UL-HAQ\Desktop\Backup 10112022\PRODUCTION\ C:\Users\ZIA-UL-HAQ\Desktop\HDD\UTM C:\Users\ZIA-UL-HAQ\Desktop\Backup 10112022\Images_2022\ sers 714-III-HA\Desktop\HDD UTM SHEETS-SERIES\ Table 睢 7 Catalog Location: LUC Polygon_1 Home - ZIA-UL-HAQ\Desktop Folder Connections BOC Дх Table Of Contents X C\Users\ZIA-UL-HAQ\Desktop\Backup C\Users\ZIA-UL-HAQ\Desktop\Backup C\Users\ZIA-UL-HAQ\Desktop\Backup C\Users\ZIA-UL-HAQ\Desktop\Backup C\Users\ZIA-UL-HAQ\Desktop\HDD C\Users\ZIA-UL-HAQ\Desktop\HDD\U C:\Users\ZIA-UL-HAQ\Documents\FIG_ LUC_Folder BULUC_GDB.gdb LUC_Dataset LUC_Fabric LUC_Polygon_1 LUC_Topology LUC_Polygon Ду DYNTABLE.xlsx Na 日 Layers P_Fabric_Data_Topology Area Errors дх now Nian ▷ Page Text▾ Editor-70-* 1:+91 Topology Properties General Feature Classes Rules Errors Generate Summary Export To File... Rule Errors Exception^ Line Errors Boundary Must Be Covered By Plot Parcel 1, SPLIT_PARCEL_LINES_1 0 Point Errors Must Not Self-Overlap SPLIT PARCEL LINES_1 0 Beacon Name Must Not Self-Intersect • SPLIT PARCEL LINES_1 0 SPLIT PARCEL_LINES 1 Must Not Intersect Or Touch Interior SPLIT PARCEL LINES_1 0 Plot Parcel Must Be Single Part SPLIT PARCEL LINES_1 Total 0 0 OK Cancel Apply X Figure 7: Connection of Folder, geodatabase, Feature Class Dataset, and Topology in ArcMap Figure 8: Zero Error Topology used in the Data Processing Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 的中国 NA UNIVER 地质 中大学 Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#13** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Computation of land use charges as a medium for Land tax generation NB 1:250 14 IND-2008-12 ▷ Page Text▾ Snapping B Editor▾ Parcel Editor & A A KANO STATE GOVERNMENT BUREAU FOR LAND MANAGEMENT Kano Geographic Information Systems (KANGIS) Table Of Contents Дх 110 120 130 140 150 160 170 180 190 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 NAME OF ALLOTTEE HYUNG SUNG HYDRAULIC MACHINERY COMPANY ADDRESS OF ALLOTTEE LAND USE CHARGE NO. 502 UDB ROAD, KANO Green: Band_2 Blue: Band 3 DTT 141 New Data Frame COMPLETE 2022 ☐ MAJOR ROADS Plot Parcel NSR GSA ATTR ☐ Plot Parcel Original Source mosal130cm_minna.tif RGB Red: Band 1 Green: Band 2 Blue: Band 3 110 120 130 140 150 160 170 180 190 | 100 110 120 130 140 150 160 170 180 190 200 KA NO STATE GOVERNMENT BUREAU FOR LAND MANAGEMENT Kano Geographic Information Systems (KANGIS) DEMAND NOTICE PLEASE PAY WITHIN 7 DAYS NAME OF A ULO TTEE MYUNG BUNG HYDRAULIC MACHINERY COMPANY ADDRESS OF ALLOTTEE INC. 502 UD & ROAD, KANO UNIQUE IDENTIFIER NER 53570m 28495m LAND USE CHARGE LAND USE CHARGE 2023 == LAND USE CHARGE 2022 == LAND USE CHARGE 2021 N LAND USE CHARGE 2020 557.171.00 000 0.00 0.00 LAND USE CHARGE 2019 M 0.00 LAND USE CHARGE 2018 0.00 LAND USE CHARGE 2017 M 0.00 LANDUSE CHARGE 2016 0.00 FILE NUMBER IN-2008-12 PROPERTY CLASSIFICATION INDUSTRIAL LOCATION BOMPA PLOT NUMBER PIECE OF LAND PROPERTY SIZE (sqm) 11,358.55 PROPERTY VALUE 100,000,000.00 LAYOUT NAME BOM PAI IGA NASSARAWA LAST PAID YEAR TITLE DESCRIPTION STATUTORY DEBT RECOVERY Ground Rent Tenement Rant OTHER CHARGES Regrant Assignment Change of Purpose SUB-DIVISION Contravention 2022 Total Amount Payable Amount Pald Balance # = 0.00 0.00 0.00 0.00 0.00 0.00 0.00 CLIENT'S All Complaints on Demand No Should be forwarded to the Director General K.ANGICS With Donal 557,171.00 0.00 557,171.00 Bank Detall Account Name Kama Sia Lane! Read Tees Accoun Account Number 87453 Sort Code 301080000 Bank Name JaizBank Plc This is generated arXAGIS on Sunday, February 24 20:23:31:10 PM Figure 9: Automated Land Use Charge Computation Template/Map Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS KANDIES CF ES INDUSTRIAL Permanant Scrat a for Land Manageman MV 中国 NA UNIVER DEMAND NOTICE PLEASE PAY WITHIN 7 DAYS UNIQUE IDENTIFIER NSR 53570m 28495m 453367 453467 FILE NUMBER IND-2008-12 PROPERTY CLASSIFICATION INDUSTRIAL LOCATION BOMPAI LAND USE CHARGE 2023 = # LAND USE CHARGE 2022 = # LAND USE CHARGE 2021 = # LAND USE CHARGE 2020 = N LAND USE CHARGE 2019 = LAND USE CHARGE 2018 = # LAND USE CHARGE 2017 = % LAND USE CHARGE 2016 = # 557,171.00 0.00 0.00 0.00 0.00 0.00 PIECE 0.00 OF LAND 0.00 PLOT NUMBER PIECE OF LAND PROPERTY SIZE (sqm) 11.358.55 PROPERTY VALUE 100.000.000.00 LAYOUT NAME BOMPAI LGA NASSARAWA LAST PAID YEAR TITLE DESCRIPTION STATUTORY Total Amount Payable Amount Paid Balance DEBT RECOVERY Ground Rent Tenement Rent = # = # 0.00 0.00 Dantata Road Bom pa OTHER CHARGES Regrant = N 0.00 Assignment =# 0.00 Change of Purpose = N 0.00 Sub-Division = # 0.00 PIECE OF LAND Contravention 0.00 2022 #= # = 557,171.00 #= 0.00 557,171.00 453367 CLIENT'S All Complaints on this Demand Notice Issued. Should be Forwaded to the Director General KANGIS Within 7 Days 地质 大学 OF GEOSCI Bank Details 453567 453667 PIECE PECE OF LAND OF LAND 453467 453567 Land Related T Account Name Kano State Land Related Taxes Account Account Number 0001876653 Sort Code 301080000 Bank Name Jaiz Bank Plc This is generated at KANGIS on Sunday, February 26, 2023@5:53:18 PM Permanent Secretary 453667 aji KANGIS 453767 N 453767 INDUSTRIAL a for Land Management 1328411 Figure 10: Sample of Demand Notice Generated for Industrial Property for the Year 2023 Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#14** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Computation of land use charges as a medium for Land tax generation KANO STATE GOVERNMENT BUREAU FOR LAND MANAGEMENT Kano Geographic Information Systems (KANGIS) DEMAND NOTICE PLEASE PAY WITHIN 7 DAYS KANGIS KANO STATE GOVERNMENT BUREAU FOR LAND MANAGEMENT Kano Geographic Information Systems (KANGIS) DEMAND NOTICE PLEASE PAY WITHIN 7 DAYS KANGIS NAME OF ALLOTTEE MUHD ABDULKADIR ADDRESS OF ALLOTTEE UNIQUE IDENTIFIER 444336 444886 KMC_44975m_23523m LAND USE CHARGE NO. 390, ZARIA ROAD, KANO STATE FILE NUMBER RES-85-1566 PROPERTY CLASSIFICATION RESIDENTIAL LOCATION DUKAWUYA LAND USE CHARGE 2023 = N LAND USE CHARGE 2022 = N LAND USE CHARGE 2021 = N LAND USE CHARGE 2020 = # LAND USE CHARGE 2019 = N LAND USE CHARGE 2018 N LAND USE CHARGE 2017 = # LAND USE CHARGE 2016 17,145.25 17,145.25 17,145.25 17,145.25 17.145.25 17,145.25 N 9,252.26 17,145.25 182 181 137 DEBT RECOVERY 184 183 135 Ground Rent = N Tenement Rent = N 10,584.26 0.00 OTHER CHARGES 138 Regrant 186 = # 0.00 136 185 Assignment = N 0.00 Change of Purpose = N 0.00 Sub-Division = N 0.00 Contravention = N 0.00 PLOT NUMBER 183 PROPERTY SIZE (sqm) 1.394.73 PROPERTY VALUE 0.00 LAYOUT NAME DUKAWUYA LGA DALA LAST PAID YEAR TITLE DESCRIPTION STATUTORY 1998 Total Amount Payable Amount Paid Balance CLIENT'S All Complaints on this Demand Notice Issued. Should be Forwaded to the Director General KANGIS Within 7 Days 139,853.27 187 153 155 0.00 = N 139.853.27 444996 # = #= Bank Details Account Name Kano State Land Related Taxes Account Account Number 0001876653 Sort Code 301080000 Bank Name Jaiz Bank Plc This is generated at KANGIS on Tuesday, January 10, 2023@7:01:48 AM 444986 Dr. Zainab Ibrahim Braji 188 199 1323550 7N 449032 4499321 NAME OF ALLOTTEE UBA ADDRESS OF ALLOTTEE UNIQUE IDENTIFIER FGE 49776m 26806m 449632 449732 LAND USE CHARGE 10 POST OFFICE ROAD FILE NUMBER COM-2020-232 PROPERTY CLASSIFICATION COMMERCIAL LOCATION POST OFFICE ROAD LAND USE CHARGE 2023 = N LAND USE CHARGE 2022 = N LAND USE CHARGE 2021 = # LAND USE CHARGE 2020 = # LAND USE CHARGE 2019 = # LAND USE CHARGE 2018 = N LAND USE CHARGE 2017 = # LAND USE CHARGE 2016 = # 1,477,327.00 1,477,327.00 OF LAND Post Office Road 0.00 0.00 0.00 0.00 1326806 0.00 0.00 # = Ground Rent Tenement Rent 0.00 = # 0.00 PLOT NUMBER 005 PROPERTY SIZE (sqm) 13.059.82 PROPERTY VALUE 52.350,000.00 LAYOUT NAME POST OFFICE ROAD LGA FAGGE DEBT RECOVERY #= OTHER CHARGES Regrant = N 0.00 Assignment 0.00 Change of Purpose = # 0.00 Sub-Division = # 0.00 Contravention = N 0.00 LAST PAID YEAR 2021 TITLE DESCRIPTION 190 STATUTORY Total Amount Payable Amount Paid =N =N 2,954,654.00 =N 250,000.00 2,704,654.00 449632 RESIDENTIAL Permanent Secretary, Kano State Bureau for Land Management Balance CLIENT'S All Complaints on this Demand Notice Issued, Should be Forwaded to the Director General KANGIS Within 7 Days Bank Details 449732 449832 Account Name Kano State Land Related Taxes Account Account Number 0001876653 Sort Code 301080000 Bank Name Jalz Bank Plc This is generated at KANGIS on Sunday, February 26, 2023@6:35:37 PM con 449932 COMMERCIAL Dr. Zainab Ibrahim Braji Permanent Secretary, Kano State Bureau for Land Management Figure 11: Sample of Demand Notice Generated for Residential Property Recovery for Several Years. FIG Figure 12: Sample of Demand Notice Generated for commercial Property Recovery from 2022-2023 Years. 5 中国 CHINA UN UNIVERSITY OF GEOSCI Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble Organized By NSPS INTERNATIONAL FEDERATION OF SURVEYORS#15日 *** rando FIG Working Week 2023 Be Copy - FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Computation of land use charges as a medium for Land tax generation Book1 - Excel Tell me what you want to do... Table Tools File Home Insert Page Layout Formulas Data Review View Design Cut Times New Roma 14 AA Wrap Text General Paste I U A- Merge & Center - $ - %' Format Painter Clipboard Font Alignment Б Number A1 ✓ fxx mlsfNo 5 1 mlsfNo kangis FileNo plot No blockNo 3 COM-2019-35 D BASHIR SODANGI KJ 困 x Sign in Share >AutoSum ATP Conditional Format as Cell Formatting Table Styles Insert Delete Format Fill- ✓Clear Sort & Find & Styles Filter Select▾ Editing Cells addressOfCurrent Allottee titleOfCurrent Allottee curre E current Allottee 2 COM-2019-3 MLKN 03278 SANI ZANGO DAURA 3 RES-87-2443 KNML 07120 PIECE OF LAIRES-87-2443 NIMA BROTHERS LIMITED NO. 3 ARAKAN ROAD, KANO STATE. MM2 RIGASA JUNCTION, KADUNA. R OF O C-OF-O 4 RES-RC-82-5 <Null> 1111 (PLAN NO. 37) DR. SANI BAKO NO. 5 LAMIDO CRESCENT <Null> 5 RES-88-2853 <Null> NO. 185, KOKI QUARTERS <Null> 6 RES-2009-39: KNML 04961 PART A 7 RES-2018-18 KNML 07645 8 RES-94-826 KNML 03717 20D (PLAN NO. 11) PHASE 1 7 (PLAN NO. 2) 183 (PLAN NO. 14) 125 (PLAN NO. 12) 9 RES-82-806 KNML 03938 10 RES-95-1566 <Null> 11 RES-2000-68: KNML 05177 12 CON-RES-201 KNML 05657 12 1110 (PLAN NO. 37) (PLAN NO. 2) 2987 (PLAN NO. 31B) PIECE OF LAI CON-RES-2008-296 MUHAMMAD SANI UTAI AUWALU BARAU MUHAMMAD MUHAMMAD SANI UTAI AMINU MALALA MUHD ABDULKADIR MOHAMMED SANI UTAI MUHAMMAD SANI UTAI NO. 2, ABDULLAHI BAYERO ROAD, KANO STATE. C-OF-O NO.485, GORONDUTSE WRECA, KANO STATE. R-OF-O NO.10 MASALLACHI STREET OFF SOKOTO ROAD C-OF-O NO. 270 HOTORO TSAMIYAR BOKA BUS STOP, S. C-OF-O NO. 390, ZARIA ROAD, KANO STATE <Null> NO. 3 MASALLACI STREET OFF SOKOTO ROAD FAC-OF-O AHMAD DAKU CRESCENT FARM CENTRE ROAD, R-OF-O Figure 13: A Sample of GIS Attribute Data Converted to Excel Format. <Null> <Null> <Null> <Null> <Null> May June Year January February March 2016 42,125,253.25 47,258,129.35 47,584,365.27 11,232,522.55 52,954,354.26 2017 103,258,124.26 133,158,369.21 121,258,124.25 101,965,253.32 111,145,354.32 2018 162,543,252.15 172,358,125.32 185,353,655.23 169,354,663.15 149,326,523.25 2019 201,565,321.32 221,369,547.25 213,258,658.21 199,853,325.19 164,235,974.25 2020 149,857,354.25 168,258,456.32 108,023,254.21 72,129,354.27 56,542,542.36 2021 201,435,932.35 221,152,323.25 207,369,789.25 214,125,987.36 200,158,978.84 2022 125,963,125.24 198,528,325.14 156,235,321.14 139,325,125.01 137,325,241.20 2023 135,369,125.24 120483528.27 August September October November December TOTAL 64,157,369.60 53,512,324.27 41,825,821.32 43,254,125.35 42,546,198.23 35,456,874.25 31,354,125.24 513,261,462.93 135,425,432.21 122,148,365.29 163,396,357.12 175,125,369.32 176,128, 365.25 157,125,842.36 115,321,654.84 1,615,456,611.75 171,235,254.36 168,369,654.13 169,253,215.23 174,257,258.36 192,125,425.39 159,252,365.12 168,369,458.35 2,041,798,850.04 161,587,369.25 156,789,412.36 147,258,456.21 124555369.14 184258147.36 112,425,981.25 114254874.01 2,001,412,435.80 51,973,652.14 49,727,233.93 69,158,355.12 166,354,268.97 141,465, 298.57 195,367,194.81 209,458,365.14 1,438,315,330.09 190,000,789.27 177,259,374.69 174,597,125.28 102,654,369.21 101, 141, 125.39 106,021,215.02 112,601,665.07 2,008,518,674.98 151,252,369.21 158,255,245.21 145,085,243.22 124,758,369.21 119,842,365.24 177,185,369.31 157,588,453.35 1,791,344,552.48 255,852,653.51 Figure 14: Table of Land Use Charge Tax from the Year 2016 To 2023 (Source: Account Department, KSBLM). Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 的中国 地质 UNIVERSITY NA UNIVER 大学 GEOSCIE OF Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#16** Orlando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Computation of land use charges as a medium for Land tax generation GENERATED LAND USE CHARGES 2016-2022 250.000.000,00 200.000.000,00 150.000.000,00 100.000.000,00 50.000.000,00 January February March April May June July August September October November December 2016 2017 2018 2019 2020 2021 2022 Figure 15: Statistical Chart of Monthly Land Use Charge Tax from the Year 2016 to 2022. FIG CHINA UN 地质 UNIVERSITY ** OF GEOSCIENCES Diamond Sponsors Organized By NSPS INTERNATIONAL FEDERATION OF SURVEYORS esri THE SCIENCE OF WHERE® Trimble#17** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Computation of land use charges as a medium for Land tax generation Amount LAND USE CHARGE TAX DISTRIBUTION 2016-2023 2.500.000.000,00 2.000.000.000,00 1.500.000.000,00 1.000.000.000,00 500.000.000,00 Year 2022 2023 2016 2017 2018 2019 2020 2021 Figure 16: Statistical Chart of Annual Land Use Charge Tax from the Year 2016 to 2023. FIG CHINA UNIVERSITY 大学 OF Diamond Sponsors esri Trimble® THE SCIENCE OF WHERE® Organized By NSPS INTERNATIONAL FEDERATION OF SURVEYORS#18** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Analysis and discussion The analyses show an upward flow of land uses revenue from the year 2016 to 2022. The year 2017 marked the beginning of the increase, which significantly increased from #513,261,462.93 to #1,615,456,611.75, three times as much as the year 2016. The year 2017 witnessed a further increase in land use tax generation from #1,615,456,611.75 recorded in 2017 to #2,041,798,850.04 in 2018. There was a slight decrease from #2,041,798,850.04 in 2018 to 2,001,412,435.80 in 2019, resulting in a deficit of #40,386,414.24, however, it was an excellent result. 的中国 CHINA UNIVE 地质 大学 OF GEO esri Diamond Sponsors Trimble THE SCIENCE OF WHERE® Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS#19** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Analysis and discussion The 2020 recorded #1,438,315,330.09, an all-time low land use tax generation in comparison with the year of automation, (2017). This was of course due to the COVID- 19 pandemic and lockdown of all activities in the state, the nation and the entire globe. Interestingly, the first quarter of the year 2020 started very well. Importantly, with the declaration of ease on the lockdown in the state and the nation, the figures rose from September to December of the same year 2020. In 2021, the figures in land use tax revenue generation returned to # 2,008,518,674.98, this must have included some land use tax recovery that was defaulted in the 2020. 的中国 CHINA UNIVE 地质 UNIVERSITY GEOSCIE Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble Organized By FIG NSPS INTERNATIONAL FEDERATION OF SURVEYORS#20** rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers RESULTS AND ANALYSES: Analysis and discussion ✓ Finally, in 2022, the land use tax charges were reduced to less than two billion nairas to about #1,791,344,552.48. Despite this drop in the figures generated for the year 2022, it was very significant as most of the payments made were only for the current year 2022 with less recovery of the previous years' land use charges. ✓ The 2023 was just beginning, and only #255,852,653.51 amount was generated as of February 2023, which is statistically inadequate for any inference. ✓ It should be noted that enforcement for land use tax generation was not initiated in the year 2023 and this was due to proximity to the election period and the government was most probably avoiding the public threat of losing votes. 中国 CHINA UN 地质 UNIVERSITY 大学 OF ROSCIENCES esri Diamond Sponsors Trimble THE SCIENCE OF WHERE® Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS#21** rando FIG Working Week 2023 CONCLUSIONS FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers This paper has significantly demonstrated the digital power of geospatial tools in the conversion and processing of cadastral survey records for the automation of Land use tax generation in Kano state. Using cadastral record and GIS, Automated Land Use Charge Computation Template/Map; Geospatial Database for Land-Related Taxes; and Spatial Data Transformation/Conversion (Analogue to Digital) for Cadastral Records were achieved. The techniques show an upward inflow of land revenue generation from 2017 to 2023, while the year 2016 was used as a benchmark to show the magnitude of revenue generation before the start of this automation technique. Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 地质 C 石 中国 CHINA UNIV UNIVERSITY OF 大学 GEOSCIE esri Diamond Sponsors THE SCIENCE OF WHERE® Trimble#22** rando FIG Working Week 2023 FIG WORKING WEEK 2023 CONCLUSIONS cont. 28 May - 1 June 2023 Orlando Florida USA Protecting Our World, Conquering New Frontiers The findings revealed a rise in revenue generation at 400% increment from 2016 to 2023. The technique has proven to be very fast, efficient, and reliable for the computation of all land-related taxes using complex mathematical algorithms embedded in the python. It eliminated the difficulty in the identification of properties at their various locations for issuance of demand notices via the map/template. The same technique can be applied anywhere as far land use tax generation is concerned. Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS 的中国 地质 UNIVERSITY NA UNIVER OF 大学 Diamond Sponsors esri THE SCIENCE OF WHERE® Trimble#23rando FIG Working Week 2023 FIG WORKING WEEK 2023 28 May - 1 June 2023 Orlando Florida USA Thank you for listening Any P Protecting Our World, Conquering New Frontiers Organized By NSPS FIG INTERNATIONAL FEDERATION OF SURVEYORS WORK AND 地质。 OF ENCES CHINA 中国 地质大 UNIVERSITY 1952 FGEOSCIENCES CHINA U OF GEOSCIENCES Diamond Sponsors esri Trimble THE SCIENCE OF WHERE®