SpatialSQL/CreateAndPopulateSampleLinesAndPointsTables.sql at master · MikeOlkinSwsc/SpatialSQL · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65

/****** Object:  Table [dbo].[SampleLines]    Script Date: 5/7/2018 11:24:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SampleLines](
	[OBJECTID] [int] NOT NULL,
	[SHAPE] [geometry] NULL,
	[AssetID] [varchar](10) NULL,
	[F_NODE] [varchar](10) NULL,
	[T_NODE] [varchar](10) NULL,
	[Feature] [varchar](20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[SamplePoints]    Script Date: 5/7/2018 11:24:49 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SamplePoints](
	[OBJECTID] [int] NOT NULL,
	[SHAPE] [geometry] NULL,
	[AssetID] [varchar](10) NULL,
	[Feature] [varchar](20) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (1, 0xC9080000011400F6287C4F8F164140E17A187FF5454100F6281C78C2164180EB513E7CF94541, N'P01', N'M01', N'M002', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (2, 0xC9080000011400F6281C78C2164180EB513E7CF9454100AE47B107EE1641C0CCCC423EF54541, N'P02', N'M02', N'M03', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (3, 0xC9080000011400AE47B107EE1641C0CCCC423EF5454100AE476193F11641A099992388EE4541, N'P03', N'M03', N'M14', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (4, 0xC9080000011400AE476193F11641A099992388EE4541003333737BC31641400AD7FD8AEA4541, N'P04', N'M04', N'M05', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (5, 0xC90800000114003333737BC31641400AD7FD8AEA4541001F85EB09A11641E051B8A44AEF4541, N'P05', N'M05', N'M06', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (6, 0xC90800000114001F85EB09A11641E051B8A44AEF4541008FC215E9BD1641A0703DA088F34541, N'P06', N'M06', N'M07', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (7, 0xC90800000114008FC215E9BD1641A0703DA088F3454100D7A3D0CD8E16418014AEC17BF44541, N'P07', N'M07', N'M01', N'Pipe')
GO
INSERT [dbo].[SampleLines] ([OBJECTID], [SHAPE], [AssetID], [F_NODE], [T_NODE], [Feature]) VALUES (8, 0xC90800000114001F85EB09A11641E051B8A44AEF454100F6287C4F8F164140E17A187FF54541, N'P08', N'M06', N'M01', N'Pipe')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (1, 0xC9080000010C00F6287C4F8F164140E17A187FF54541, N'M01', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (2, 0xC9080000010C00AE47B107EE1641C0CCCC423EF54541, N'M03', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (3, 0xC9080000010C00F6281C78C2164180EB513E7CF94541, N'M02', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (4, 0xC9080000010C001F85EB09A11641E051B8A44AEF4541, N'M06', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (5, 0xC9080000010C008FC215E9BD1641A0703DA088F34541, N'M07', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (6, 0xC9080000010C0033330301EC1641C0CCCCB867EE4541, N'M04', N'Manhole')
GO
INSERT [dbo].[SamplePoints] ([OBJECTID], [SHAPE], [AssetID], [Feature]) VALUES (7, 0xC9080000010C003333737BC31641400AD7FD8AEA4541, N'M05', N'Manhole')
GO
ALTER TABLE [dbo].[SampleLines]  WITH CHECK ADD  CONSTRAINT [A_g746_ck] CHECK  (([SHAPE].[STSrid]=(2249)))
GO
ALTER TABLE [dbo].[SampleLines] CHECK CONSTRAINT [A_g746_ck]
GO
ALTER TABLE [dbo].[SamplePoints]  WITH CHECK ADD  CONSTRAINT [A_g747_ck] CHECK  (([SHAPE].[STSrid]=(2249)))
GO
ALTER TABLE [dbo].[SamplePoints] CHECK CONSTRAINT [A_g747_ck]
GO