Baselight
Sign In

TPO Trees (Groups, Areas And Woodlands)

City of Bradford Metropolitan District Council

@ukgov.tpo_trees_groups_areas_and_woodlands11

Table 1
@ukgov.tpo_trees_groups_areas_and_woodlands11.table_1

  • 574.08 KB
  • 2821 rows
  • 109 columns
  • Only the first 100 columns are shown
unisdeliveufrm_tptree_polyobjectid

UNISDELIVEUFRM TPTREE POLYOBJECTID

unisdeliveufrm_tptree_polykeyval

UNISDELIVEUFRM TPTREE POLYKEYVAL

unisdeliveufrm_tptree_polycreatedby

UNISDELIVEUFRM TPTREE POLYCREATEDBY

unisdeliveufrm_tptree_polymodifiedby

UNISDELIVEUFRM TPTREE POLYMODIFIEDBY

unisdeliveufrm_tptree_polydate_created

UNISDELIVEUFRM TPTREE POLYDATE CREATED

unisdeliveufrm_tptree_polydate_modified

UNISDELIVEUFRM TPTREE POLYDATE MODIFIED

unisdeliveufrm_tptree_polystatus

UNISDELIVEUFRM TPTREE POLYSTATUS

unisdeliveufrm_tptree_polytransaction_type

UNISDELIVEUFRM TPTREE POLYTRANSACTION TYPE

unisdeliveufrm_tptree_polysymbol

UNISDELIVEUFRM TPTREE POLYSYMBOL

unisdeliveufrm_tptree_polymap_area

UNISDELIVEUFRM TPTREE POLYMAP AREA

unisdeliveufrm_tptree_polyx

UNISDELIVEUFRM TPTREE POLYX

unisdeliveufrm_tptree_polyy

UNISDELIVEUFRM TPTREE POLYY

unisdeliveufrm_tptree_polycaseno

UNISDELIVEUFRM TPTREE POLYCASENO

unisdeliveufrm_tptree_polytreetype

UNISDELIVEUFRM TPTREE POLYTREETYPE

unisdeliveufrm_tptree_polytnum

UNISDELIVEUFRM TPTREE POLYTNUM

unisdeliveufrm_tptree_polyrefval

UNISDELIVEUFRM TPTREE POLYREFVAL

unisdeliveufrm_tptree_polytptreecat

UNISDELIVEUFRM TPTREE POLYTPTREECAT

unisdeliveufrm_tptree_polycatnos

UNISDELIVEUFRM TPTREE POLYCATNOS

unisdeliveufrm_tptree_polylabel

UNISDELIVEUFRM TPTREE POLYLABEL

unisdeliveufrm_tptree_polytpstatus

UNISDELIVEUFRM TPTREE POLYTPSTATUS

unisdeliveufrm_tptree_polylatitude

UNISDELIVEUFRM TPTREE POLYLATITUDE

unisdeliveufrm_tptree_polylongitude

UNISDELIVEUFRM TPTREE POLYLONGITUDE

unisdeliveufrm_tptree_polymap_x

UNISDELIVEUFRM TPTREE POLYMAP X

unisdeliveufrm_tptree_polymap_y

UNISDELIVEUFRM TPTREE POLYMAP Y

unisdeliveufrm_tptree_polydescript

UNISDELIVEUFRM TPTREE POLYDESCRIPT

unisdeliveufrm_tptree_polyaddress

UNISDELIVEUFRM TPTREE POLYADDRESS

unisdeliveufrm_tptree_polydaterem

UNISDELIVEUFRM TPTREE POLYDATEREM

unisdeliveufrm_tptree_polyse_anno_cad_data

UNISDELIVEUFRM TPTREE POLYSE ANNO CAD DATA

shapearea

SHAPEAREA

shapelen

SHAPELEN

uni73livetptreekeyval

UNI73LIVETPTREEKEYVAL

uni73livetptreepkeyval

UNI73LIVETPTREEPKEYVAL

uni73livetptreeu_version

UNI73LIVETPTREEU VERSION

uni73livetptreetptreecat

UNI73LIVETPTREETPTREECAT

uni73livetptreecatnos

UNI73LIVETPTREECATNOS

uni73livetptreetpkeyval

UNI73LIVETPTREETPKEYVAL

uni73livetptreetreetype

UNI73LIVETPTREETREETYPE

uni73livetptreetnum

UNI73LIVETPTREETNUM

uni73livetptreecomments

UNI73LIVETPTREECOMMENTS

uni73livetptreemapnorth

UNI73LIVETPTREEMAPNORTH

uni73livetptreemapeast

UNI73LIVETPTREEMAPEAST

uni73livetptreecreatedd

UNI73LIVETPTREECREATEDD

uni73livetptreeupdatedd

UNI73LIVETPTREEUPDATEDD

uni73livetptreeupdateby

UNI73LIVETPTREEUPDATEBY

uni73livetptreesituat

UNI73LIVETPTREESITUAT

uni73livetptreedaterem

UNI73LIVETPTREEDATEREM

uni73livetptreedaterepdue

UNI73LIVETPTREEDATEREPDUE

uni73livetptreedaterep

UNI73LIVETPTREEDATEREP

uni72livecncodelistname

UNI72LIVECNCODELISTNAME

uni72livecncodecodevalue

UNI72LIVECNCODECODEVALUE

uni72livecncodeu_version

UNI72LIVECNCODEU VERSION

uni72livecncodecodetext

UNI72LIVECNCODECODETEXT

uni72livecncodecodecat

UNI72LIVECNCODECODECAT

uni72livecncodehistoric

UNI72LIVECNCODEHISTORIC

uni72livecncodextratext

UNI72LIVECNCODEXTRATEXT

uni73livetpapplkeyval

UNI73LIVETPAPPLKEYVAL

uni73livetpapplu_version

UNI73LIVETPAPPLU VERSION

uni73livetpapplrefval

UNI73LIVETPAPPLREFVAL

uni73livetpappltpstatus

UNI73LIVETPAPPLTPSTATUS

uni73livetpappltpapptype

UNI73LIVETPAPPLTPAPPTYPE

uni73livetpapplprkeyval

UNI73LIVETPAPPLPRKEYVAL

uni73livetpappladdress

UNI73LIVETPAPPLADDRESS

uni73livetpapplmapeast

UNI73LIVETPAPPLMAPEAST

uni73livetpapplmapnorth

UNI73LIVETPAPPLMAPNORTH

uni73livetpappldescript

UNI73LIVETPAPPLDESCRIPT

uni73livetpappldaterec

UNI73LIVETPAPPLDATEREC

uni73livetpapplofficer

UNI73LIVETPAPPLOFFICER

uni73livetpapploffcost

UNI73LIVETPAPPLOFFCOST

uni73livetpapplward

UNI73LIVETPAPPLWARD

uni73livetpapplparish

UNI73LIVETPAPPLPARISH

uni73livetpapplrequreason

UNI73LIVETPAPPLREQUREASON

uni73livetpappldatedraft

UNI73LIVETPAPPLDATEDRAFT

uni73livetpappltargetdate

UNI73LIVETPAPPLTARGETDATE

uni73livetpapplcommitted

UNI73LIVETPAPPLCOMMITTED

uni73livetpappldconfirmed

UNI73LIVETPAPPLDCONFIRMED

uni73livetpapplserveddate

UNI73LIVETPAPPLSERVEDDATE

uni73livetpappltotcost

UNI73LIVETPAPPLTOTCOST

uni73livetpapplconsexp

UNI73LIVETPAPPLCONSEXP

uni73livetpapplordtype

UNI73LIVETPAPPLORDTYPE

uni73livetpapplapprovyn

UNI73LIVETPAPPLAPPROVYN

uni73livetpappllastlett

UNI73LIVETPAPPLLASTLETT

uni73livetpapplordexp

UNI73LIVETPAPPLORDEXP

uni73livetpapplconschng

UNI73LIVETPAPPLCONSCHNG

uni73livetpapplordschng

UNI73LIVETPAPPLORDSCHNG

uni73livetpappldatewith

UNI73LIVETPAPPLDATEWITH

uni73livetpappltpneilett

UNI73LIVETPAPPLTPNEILETT

uni73livetpapplneiconyn

UNI73LIVETPAPPLNEICONYN

uni73livetpappllastprntd

UNI73LIVETPAPPLLASTPRNTD

uni73livetpapplackyn

UNI73LIVETPAPPLACKYN

uni73livetpappltpreasend

UNI73LIVETPAPPLTPREASEND

uni73livetpappltpmckeyval

UNI73LIVETPAPPLTPMCKEYVAL

uni73livetpapplcreatedd

UNI73LIVETPAPPLCREATEDD

uni73livetpapplupdatedd

UNI73LIVETPAPPLUPDATEDD

uni73livetpapplupdateby

UNI73LIVETPAPPLUPDATEBY

uni73livetpapplmodified

UNI73LIVETPAPPLMODIFIED

uni73livetpappldatestadv

UNI73LIVETPAPPLDATESTADV

uni73livetpappldateexpiry

UNI73LIVETPAPPLDATEEXPIRY

uni73livetpappldateadvprt

UNI73LIVETPAPPLDATEADVPRT

uni73livetpapplsnprnt

UNI73LIVETPAPPLSNPRNT

uni73livetpappladprnt

UNI73LIVETPAPPLADPRNT

uni73livetpappltpsslacode

UNI73LIVETPAPPLTPSSLACODE

uni73livetpappltp_rpt

UNI73LIVETPAPPLTP RPT

uni73livetpappltp_rpr

UNI73LIVETPAPPLTP RPR

uni73livetpappltp_pol

UNI73LIVETPAPPLTP POL

uni73livetpappltp_cnc

UNI73LIVETPAPPLTP CNC

corpdatatpo_web_lookupobjectid

CORPDATATPO WEB LOOKUPOBJECTID

corpdatatpo_web_lookupkeyval

CORPDATATPO WEB LOOKUPKEYVAL

corpdatatpo_web_lookuprefval

CORPDATATPO WEB LOOKUPREFVAL

corpdatatpo_web_lookupfrefval

CORPDATATPO WEB LOOKUPFREFVAL

35ZZZZZTDHXC098datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE16565.184417905435586ZZZZZRDHXC617GROU0002AG1G1CONFManor House, Leeds Road, Eccleshill, BradfordManor House Gardens Bradford West Yorkshire ZZZZZTDHXC098ZZZZZRDHXC617"G1GROU435586417905Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Sep 10 2012 13:55:33 GMT+0000 (Coordinated Universal Time)danspeTREETYPEGROU"GroupFZZZZZRDHXC617-0002ACONFTPOIYDW2IDH20000Manor House Gardens Bradford West Yorkshire 417877435599Manor House, Leeds Road, Eccleshill, BradfordTue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)10ECCLNULLFri Apr 10 1953 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jun 04 1953 00:00:00 GMT+0000 (Coordinated Universal Time)Fri Apr 10 1953 00:00:00 GMT+0000 (Coordinated Universal Time)YSat Oct 10 1953 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Nov 12 2012 10:12:32 GMT+0000 (Coordinated Universal Time)joerich
52ZZZZZTDHXC081datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE1769.198413051434742ZZZZZRDHXC1860845G1G1CONFLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, BradfordZZZZZTDHXC081ZZZZZRDHXC186!G1434780413046Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans_roisZZZZZRDHXC186#0845CONFTPOLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, Bradford413046434780Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Apr 11 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YWed Jul 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:36:25 GMT+0000 (Coordinated Universal Time)joerich
53ZZZZZZDHXT342datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE1203.145413038434827ZZZZZRDHXC1860845G2G2CONFLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, BradfordZZZZZZDHXT342ZZZZZRDHXC186!G2434827413038Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans-anscZZZZZRDHXC186#0845CONFTPOLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, Bradford413046434780Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Apr 11 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YWed Jul 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:36:25 GMT+0000 (Coordinated Universal Time)joerich
54ZZZZZZDHXT341datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE1165.326413027434900ZZZZZRDHXC1860845G3G3CONFLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, BradfordZZZZZZDHXT341ZZZZZRDHXC186!G3434900413027Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans-anscZZZZZRDHXC186#0845CONFTPOLand at Lynfield Mount Hospital, Heights Lane, Daisy Hill, Bradford413046434780Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Apr 11 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Jan 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YWed Jul 24 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:36:25 GMT+0000 (Coordinated Universal Time)joerich
55ZZZZZTDHXC078datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE1129.914400900437052ZZZZZRDHXC8510878G1G1CONFStanburyChurch, Main Street, Stanbury, KeighleyZZZZZTDHXC078ZZZZZRDHXC851!G1437056400902Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans_roisZZZZZRDHXC851#0878CONFTPOStanburyChurch, Main Street, Stanbury, Keighley400906437076Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Apr 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YTue Apr 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:41:11 GMT+0000 (Coordinated Universal Time)joerich
56ZZZZZZDHXT340datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE136.535400905437067ZZZZZRDHXC8510878G2G2CONFStanburyChurch, Main Street, Stanbury, KeighleyZZZZZZDHXT340ZZZZZRDHXC851!G2437067400905Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans-anscZZZZZRDHXC851#0878CONFTPOStanburyChurch, Main Street, Stanbury, Keighley400906437076Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Apr 08 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YTue Apr 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:41:11 GMT+0000 (Coordinated Universal Time)joerich
57ZZZZZTDHXC076datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE1168.02418601436374ZZZZZRDHXC1730879G1G1CONF43 Park Road Eccleshill Bradford West Yorkshire BD10 8AX ZZZZZTDHXC076ZZZZZRDHXC173"G14 Sycamore436374418601Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Tue May 22 2012 09:38:28 GMT+0000 (Coordinated Universal Time)danspeZZZZZRDHXC173$0879CONFTPOHJXAA2DH9100043 Park Road Eccleshill Bradford West Yorkshire BD10 8AX 418615436371Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)10ECCLNULLTue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Dec 05 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 15 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YTue Apr 15 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:41:22 GMT+0000 (Coordinated Universal Time)joerich
58ZZZZZSDHXC407datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE16454.471412382437185ZZZZZRDHXC5131087W2W2CONFCHERRYLand at former Nab Wood Middle School, New Close Road, Nab WoodZZZZZSDHXC407ZZZZZRDHXC513!W2437278412446Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans_roisZZZZZRDHXC513#1087CONFTPOLand at former Nab Wood Middle School, New Close Road, Nab Wood412595437271CHERRYTue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Aug 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Aug 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)27600YSat Feb 12 2005 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 12:54:36 GMT+0000 (Coordinated Universal Time)joerich
59ZZZZZYDHXT468datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE13977.001412537437238ZZZZZRDHXC5131087W3W3CONFCHERRYLand at former Nab Wood Middle School, New Close Road, Nab WoodZZZZZYDHXT468ZZZZZRDHXC513!W3437238412537Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans-anscZZZZZRDHXC513#1087CONFTPOLand at former Nab Wood Middle School, New Close Road, Nab Wood412595437271CHERRYTue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Aug 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Oct 05 2004 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Aug 12 2004 00:00:00 GMT+0000 (Coordinated Universal Time)27600YSat Feb 12 2005 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 12:54:36 GMT+0000 (Coordinated Universal Time)joerich
1ZZZZZTDHXC075datatrans-anscdatatrans-anscWed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)Wed May 07 2008 00:00:00 GMT+0000 (Coordinated Universal Time)1NONE143.98415586439229ZZZZZSDHXC1620884G1G1CONF3 Station Road, BaildonZZZZZTDHXC075ZZZZZSDHXC162!G1439235415631Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)Mon Feb 19 2007 00:00:00 GMT+0000 (Coordinated Universal Time)datatrans_roisZZZZZSDHXC162#0884CONFTPO3 Station Road, Baildon415617439233Tue Jan 01 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Oct 17 2002 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Feb 12 1901 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Apr 17 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Thu Oct 17 2002 00:00:00 GMT+0000 (Coordinated Universal Time)YThu Apr 17 2003 00:00:00 GMT+0000 (Coordinated Universal Time)Tue Nov 13 2012 11:42:15 GMT+0000 (Coordinated Universal Time)joerich

CREATE TABLE table_1 (
  "unisdeliveufrm_tptree_polyobjectid" BIGINT,
  "unisdeliveufrm_tptree_polykeyval" VARCHAR,
  "unisdeliveufrm_tptree_polycreatedby" VARCHAR,
  "unisdeliveufrm_tptree_polymodifiedby" VARCHAR,
  "unisdeliveufrm_tptree_polydate_created" TIMESTAMP,
  "unisdeliveufrm_tptree_polydate_modified" TIMESTAMP,
  "unisdeliveufrm_tptree_polystatus" BIGINT,
  "unisdeliveufrm_tptree_polytransaction_type" VARCHAR,
  "unisdeliveufrm_tptree_polysymbol" BIGINT,
  "unisdeliveufrm_tptree_polymap_area" DOUBLE,
  "unisdeliveufrm_tptree_polyx" BIGINT,
  "unisdeliveufrm_tptree_polyy" BIGINT,
  "unisdeliveufrm_tptree_polycaseno" VARCHAR,
  "unisdeliveufrm_tptree_polytreetype" VARCHAR,
  "unisdeliveufrm_tptree_polytnum" VARCHAR,
  "unisdeliveufrm_tptree_polyrefval" VARCHAR,
  "unisdeliveufrm_tptree_polytptreecat" VARCHAR,
  "unisdeliveufrm_tptree_polycatnos" DOUBLE,
  "unisdeliveufrm_tptree_polylabel" VARCHAR,
  "unisdeliveufrm_tptree_polytpstatus" VARCHAR,
  "unisdeliveufrm_tptree_polylatitude" VARCHAR,
  "unisdeliveufrm_tptree_polylongitude" VARCHAR,
  "unisdeliveufrm_tptree_polymap_x" DOUBLE,
  "unisdeliveufrm_tptree_polymap_y" DOUBLE,
  "unisdeliveufrm_tptree_polydescript" VARCHAR,
  "unisdeliveufrm_tptree_polyaddress" VARCHAR,
  "unisdeliveufrm_tptree_polydaterem" VARCHAR,
  "unisdeliveufrm_tptree_polyse_anno_cad_data" VARCHAR,
  "shapearea" BIGINT,
  "shapelen" BIGINT,
  "uni73livetptreekeyval" VARCHAR,
  "uni73livetptreepkeyval" VARCHAR,
  "uni73livetptreeu_version" VARCHAR,
  "uni73livetptreetptreecat" VARCHAR,
  "uni73livetptreecatnos" DOUBLE,
  "uni73livetptreetpkeyval" VARCHAR,
  "uni73livetptreetreetype" VARCHAR,
  "uni73livetptreetnum" VARCHAR,
  "uni73livetptreecomments" VARCHAR,
  "uni73livetptreemapnorth" BIGINT,
  "uni73livetptreemapeast" BIGINT,
  "uni73livetptreecreatedd" TIMESTAMP,
  "uni73livetptreeupdatedd" TIMESTAMP,
  "uni73livetptreeupdateby" VARCHAR,
  "uni73livetptreesituat" VARCHAR,
  "uni73livetptreedaterem" VARCHAR,
  "uni73livetptreedaterepdue" VARCHAR,
  "uni73livetptreedaterep" VARCHAR,
  "uni72livecncodelistname" VARCHAR,
  "uni72livecncodecodevalue" VARCHAR,
  "uni72livecncodeu_version" VARCHAR,
  "uni72livecncodecodetext" VARCHAR,
  "uni72livecncodecodecat" VARCHAR,
  "uni72livecncodehistoric" VARCHAR,
  "uni72livecncodextratext" VARCHAR,
  "uni73livetpapplkeyval" VARCHAR,
  "uni73livetpapplu_version" VARCHAR,
  "uni73livetpapplrefval" VARCHAR,
  "uni73livetpappltpstatus" VARCHAR,
  "uni73livetpappltpapptype" VARCHAR,
  "uni73livetpapplprkeyval" VARCHAR,
  "uni73livetpappladdress" VARCHAR,
  "uni73livetpapplmapeast" DOUBLE,
  "uni73livetpapplmapnorth" DOUBLE,
  "uni73livetpappldescript" VARCHAR,
  "uni73livetpappldaterec" TIMESTAMP,
  "uni73livetpapplofficer" VARCHAR,
  "uni73livetpapploffcost" VARCHAR,
  "uni73livetpapplward" VARCHAR,
  "uni73livetpapplparish" VARCHAR,
  "uni73livetpapplrequreason" VARCHAR,
  "uni73livetpappldatedraft" TIMESTAMP,
  "uni73livetpappltargetdate" TIMESTAMP,
  "uni73livetpapplcommitted" TIMESTAMP,
  "uni73livetpappldconfirmed" TIMESTAMP,
  "uni73livetpapplserveddate" TIMESTAMP,
  "uni73livetpappltotcost" VARCHAR,
  "uni73livetpapplconsexp" VARCHAR,
  "uni73livetpapplordtype" VARCHAR,
  "uni73livetpapplapprovyn" VARCHAR,
  "uni73livetpappllastlett" VARCHAR,
  "uni73livetpapplordexp" TIMESTAMP,
  "uni73livetpapplconschng" VARCHAR,
  "uni73livetpapplordschng" VARCHAR,
  "uni73livetpappldatewith" TIMESTAMP,
  "uni73livetpappltpneilett" VARCHAR,
  "uni73livetpapplneiconyn" VARCHAR,
  "uni73livetpappllastprntd" VARCHAR,
  "uni73livetpapplackyn" VARCHAR,
  "uni73livetpappltpreasend" VARCHAR,
  "uni73livetpappltpmckeyval" VARCHAR,
  "uni73livetpapplcreatedd" TIMESTAMP,
  "uni73livetpapplupdatedd" TIMESTAMP,
  "uni73livetpapplupdateby" VARCHAR,
  "uni73livetpapplmodified" VARCHAR,
  "uni73livetpappldatestadv" VARCHAR,
  "uni73livetpappldateexpiry" VARCHAR,
  "uni73livetpappldateadvprt" VARCHAR,
  "uni73livetpapplsnprnt" VARCHAR,
  "uni73livetpappladprnt" VARCHAR
);

Share link

Anyone who has the link will be able to view this.