Revision of forest_info.sql

1 file changed, 1 insertion, 3 deletions

forest_info.sql

			@@ -1,4 +1,3 @@
1		-	```sql
2	1		create table test.zzz_forest_info_51 as
3	2		select
4	3		a.pnu,
			@@ -39,5 +38,4 @@ on left(a.pnu,5) = c.sgg_cd
39	38		left outer join comtn_map_admindistrict_emd d
40	39		on left(a.pnu,8) = d.emd_cd
41	40		left outer join comtn_map_admindistrict_ri e
42		-	on left(a.pnu,10) = e.ri_cd
43		-	```
	41	+	on left(a.pnu,10) = e.ri_cd

1 file changed, 43 insertions

forest_info.sql(檔案已創建)

		@@ -0,0 +1,43 @@
1	+	```sql
2	+	create table test.zzz_forest_info_51 as
3	+	select
4	+	a.pnu,
5	+	b.sid_nm,
6	+	c.sgg_nm,
7	+	d.emd_nm,
8	+	e.ri_nm,
9	+	substring(a.pnu,12, 4)::integer::varchar as bon,
10	+	substring(a.pnu,16, 4)::integer::varchar as bu,
11	+	trim(substring(a.jibun,0, length(a.jibun))) as jibun,
12	+	right(a.jibun, 1) as jimok,
13	+	a.area_hectare,
14	+	a.jukjung,
15	+	a.jukjung1,
16	+	a.jaebe,
17	+	a.jaebe1,
18	+	a.na_imsang,
19	+	a.na_yunggub,
20	+	a.na_kyunggub,
21	+	a.na_mildo,
22	+	a.to_jiri,
23	+	a.to_jihyung,
24	+	a.to_moam,
25	+	a.to_tosim,
26	+	a.to_yugi,
27	+	a.to_tosung,
28	+	a.to_geunsup,
29	+	a.to_geunmildo,
30	+	a.avg_height,
31	+	a.avg_slope,
32	+	a.avg_aspect,
33	+	a.label
34	+	from public.zzz_forest_info_51 a
35	+	left outer join comtn_map_admindistrict_sido b
36	+	on left(a.pnu,2) = b.sid_cd
37	+	left outer join comtn_map_admindistrict_sgg c
38	+	on left(a.pnu,5) = c.sgg_cd
39	+	left outer join comtn_map_admindistrict_emd d
40	+	on left(a.pnu,8) = d.emd_cd
41	+	left outer join comtn_map_admindistrict_ri e
42	+	on left(a.pnu,10) = e.ri_cd
43	+	```