GM Bus Stopping Points

Transport for Greater Manchester

@ukgov.bus_stopping_points

Table List

1 table(1.41 MB)

GM Bus Stopping Points

@ukgov.bus_stopping_points.gm_bus_stopping_points

1.41 MB
21106 rows
43 columns

atcocode AtcoCode	naptancode NaptanCode	commonname CommonName	shortcommonname ShortCommonName	landmark Landmark	street Street	indicator Indicator	bearing Bearing	nptglocalitycode NptgLocalityCode	localityname LocalityName	parentlocalityname ParentLocalityName	gridtype GridType	easting Easting	northing Northing	longitude Longitude	latitude Latitude	stoptype StopType	busstoptype BusStopType	timingstatus TimingStatus	notes Notes	administrativeareacode AdministrativeAreaCode	creationdatetime CreationDateTime	modificationdatetime ModificationDateTime	revisionnumber RevisionNumber	modification Modification	status Status
1800WKH4032		Churchlands Lane		CHURCHLANDS LA	COPELAND DRIVE	Churchlands La	S	E0029368	Standish	Wigan	U	356697	410685	-2.655676	53.59095	BCT	HAR	OTH		83	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		new	del
1800SBT0641		High Street			High St	on		E0057786	Manchester City Centre	Manchester	U	384219	398501	-2.239274	53.48299	TXR				83	Tue Sep 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 31 2019 14:34:30 GMT+0000 (Coordinated Universal Time)	1	rev	act
1800SBT0351		Peter Street			Peter St	on		E0057786	Manchester City Centre	Manchester	U	383740	397932	-2.246462	53.47786	TXR				83	Tue Sep 14 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Jul 31 2019 14:47:41 GMT+0000 (Coordinated Universal Time)	1	rev	act
1800SG44991	MANJMGMW	A34 Bridge	A34 Bridge	HOUSE 61	ETCHELLS RD	adj	E	N0075002	Heald Green		U	385992	386275	-2.212008	53.37315	BCT	MKD	TIP	INDICATOR AMENDED	83	Mon Feb 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Feb 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	1	rev	act
1800SGH2781		A34 Roundabout (to def rte)		HANDFORTH BYPAS	STANLEY ROAD	Handforth Bypas	S	E0028438	Gillbent	Cheadle Hulme	U	386832	384681	-2.199316	53.35884	BCT	HAR	OTH		83	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		new	del
1800SGH2782		A34 Roundabout (to def rte)		HANDFORTH BYPAS	STANLEY ROAD	Handforth Bypas	N	E0028438	Gillbent	Cheadle Hulme	U	386832	384681	-2.199316	53.35884	BCT	HAR	OTH		83	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		new	del
1800WAH1041		A6027 (eastbd)(to def rte)		CHORLEY ROAD	A6027	Chorley Road	NE	E0028276	Cooper Turning	Four Gates	U	363732	408572	-2.549153	53.57249	BCT	HAR	OTH	NAME AMENDE	83	Mon Mar 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2	rev	del
1800WAH1051		A6027 (westbound)(to def rte)		CHORLEY ROAD	A6027	Chorley Rd	SW	E0028276	Cooper Turning	Four Gates	U	363730	408552	-2.549181	53.57231	BCT	HAR	OTH	NAME AMENDED	83	Mon Mar 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	Mon Mar 29 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2	rev	del
1800WAH1091		A6027 R'about (to def rte)		A6027	BURNDEN WAY	A6027	NW	N0075079	Middlebrook	Horwich	U	364618	409235	-2.53585	53.57851	BCT	HAR	OTH		83	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		new	del
1800WAH1092		A6027 R'about (to def rte)		A6027	BURNDEN WAY	A6027	SE	N0075079	Middlebrook	Horwich	U	364618	409235	-2.53585	53.57851	BCT	HAR	OTH		83	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Nov 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)		new	del


CREATE TABLE gm_bus_stopping_points (
  "atcocode" VARCHAR,
  "naptancode" VARCHAR,
  "platecode" VARCHAR,
  "cleardowncode" VARCHAR,
  "commonname" VARCHAR,
  "commonnamelang" VARCHAR,
  "shortcommonname" VARCHAR,
  "shortcommonnamelang" VARCHAR,
  "landmark" VARCHAR,
  "landmarklang" VARCHAR,
  "street" VARCHAR,
  "streetlang" VARCHAR,
  "crossing" VARCHAR,
  "crossinglang" VARCHAR,
  "indicator" VARCHAR,
  "indicatorlang" VARCHAR,
  "bearing" VARCHAR,
  "nptglocalitycode" VARCHAR,
  "localityname" VARCHAR,
  "parentlocalityname" VARCHAR,
  "grandparentlocalityname" VARCHAR,
  "town" VARCHAR,
  "townlang" VARCHAR,
  "suburb" VARCHAR,
  "suburblang" VARCHAR,
  "localitycentre" BIGINT,
  "gridtype" VARCHAR,
  "easting" BIGINT,
  "northing" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "stoptype" VARCHAR,
  "busstoptype" VARCHAR,
  "timingstatus" VARCHAR,
  "defaultwaittime" VARCHAR,
  "notes" VARCHAR,
  "noteslang" VARCHAR,
  "administrativeareacode" BIGINT,
  "creationdatetime" TIMESTAMP,
  "modificationdatetime" TIMESTAMP,
  "revisionnumber" BIGINT,
  "modification" VARCHAR,
  "status" VARCHAR
);