??????????? ???????????? (DBMS of Geographic Information Systems, GIS)

1
???????????????????????(DBMS of Geographic
Information Systems, GIS)

• ?????????
• ???????D964020002
• ???D964020006
• ???D964020008

2
1. What is GIS?

• Geographic Information Systems GIS
• ????????????????????????
• ????????????????
• ???????????????????????????
• ?????????????????????????
• ???????????????????????????????,??????,???????????
  ???????

3
2. GIS?????
? ??????? ? ??????? ? ???? ?
???? ? ?????
??? (next page)
4
(No Transcript)
5
3. ???????????

• ???????????(Spatial data)
• ????(Point feature)?????(Line feature)?????(Area
  or polygon feature)?
• ???????????(Attribute data)
• ??????????
• ????,?????????????????????????,??????????????????
  ?,???????????????????????????????????

6
??????.?.?
7
?????????(vector)????(raster)
8
???????
??
??
??
??
9
4. GIS????????(DBMS)???Geo-relational Data Model
?Geo-database Data Model
10
Geo-database data model?GIS???????????????,???????
???????????????,?????????????????????(???),???????
?????????????????????
11
5. GIS?????

• GIS???????????????,?????????????? (spatial
  data)??????(attribute data)?????

12
????? (Spatial Database)

• ???????????,??????????
• ??????GIS??ArcView ?MapInfo?MajorGIS
• ????????????????????????????????,?????????????????
  ?????,????????(spatial database),?????????????????
  ???????????,????SDE?????????

13
?????????????????????
14
??????????????????????
15
????????????????????
16
6. GIS????????????

• ???????????????????,???????????????????????????,??
  ??????????????????,???????????????????????????????
  ?????,???????????

17
(No Transcript)
18
SQL??????

• ?????????????????????????????,????????????????????
  ????,???????????

19
?????? activecar_carno

• select max(tracking.ReID) AS
  ReID,tracking.CarNo AS CarNo
• from tracking where (now() lt
  (tracking.C_TIME interval 20 minute)) group
  by tracking.CarNo order by tracking.ReID
  desc

20
(No Transcript)
21
?????? activecar

• select tracking.ReID AS
  reid,tracking.Re_time AS Re_time,tracking
  .C_TIME AS C_TIME,tracking.C_STATUS AS
  C_STATUS,tracking.C_SNNO AS
  C_SNNO,tracking.C_EWNO AS
  C_EWNO,tracking.C_SPEED AS
  C_SPEED,tracking.C_EGO AS
  C_EGO,tracking.CarNo AS carno
• from (tracking join activecar_carno
  on((tracking.ReID activecar_carno.ReID)))
  group by tracking.CarNo

22
(No Transcript)
23
??????VB??

• Rs_Static.Open "select from TRACKING where
  C_STATUS 'A' and carno'" Text_Carno _ "'
  and c_time between '" Start_time "' and '"
  End_time "' order by c_time ", cn, 1, 3

24
??????
25
Thank you!!

• ????!! ??????!!