[SQL] pobierz, plaintext 
USE [DWH_NL_REF]
GO
/****** Object:  Table [dbo].[REF_Postcode_NL]    Script Date: 03/09/2016 11:35:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[REF_Postcode_NL](
	[id] [float] NULL,
	[postcode] [nvarchar](255) NULL,
	[postcode_id] [float] NULL,
	[pnum] [float] NULL,
	[pchar] [nvarchar](255) NULL,
	[minnumber] [float] NULL,
	[maxnumber] [float] NULL,
	[numbertype] [nvarchar](255) NULL,
	[street] [nvarchar](255) NULL,
	[city] [nvarchar](255) NULL,
	[city_id] [float] NULL,
	[municipality] [nvarchar](255) NULL,
	[municipality_id] [float] NULL,
	[province] [nvarchar](255) NULL,
	[province_code] [nvarchar](255) NULL,
	[lat] [float] NULL,
	[lon] [float] NULL,
	[rd_x] [float] NULL,
	[rd_y] [float] NULL,
	[location_detail] [nvarchar](255) NULL,
	[changed_date] [datetime] NULL,
	[geographypoint]  AS ([geography]::STGeomFromText(((('POINT('+CONVERT([varchar](20),[lon],(0)))+' ')+CONVERT([varchar](20),[lat],(0)))+')',(4326)))
) ON [PRIMARY]
GO
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23082, N'1185XE', 11858869, 1185, N'XE', 2, 14, N'even', N'Bovenkerkerweg', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2841851341781, 4.8429645934418, 117863.198857142, 477493.264714285, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23083, N'1185XJ', 11858874, 1185, N'XJ', 163, 471, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2906822356276, 4.844411817959, 117967.36141081, 478215.397416216, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23084, N'1185XK', 11858875, 1185, N'XK', 9, 49, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.2884812295665, 4.843539868722, 117906.036648148, 477970.957222222, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
INSERT [dbo].[REF_Postcode_NL] ([id], [postcode], [postcode_id], [pnum], [pchar], [minnumber], [maxnumber], [numbertype], [street], [city], [city_id], [municipality], [municipality_id], [province], [province_code], [lat], [lon], [rd_x], [rd_y], [location_detail], [changed_date]) VALUES (23085, N'1185XL', 11858876, 1185, N'XL', 51, 99, N'odd', N'Wimbledonpark', N'Amstelveen', 1050, N'Amstelveen', 362, N'Noord-Holland', N'NH', 52.288406240247, 4.8437956701478, 117923.427, 477962.483, N'postcode', CAST(0x0000A30900DBDAD0 AS DateTime))
[SQL] pobierz, plaintext