JTS Google App Engine S119325

Size: px

Start display at page:

Download "JTS Google App Engine S119325"

たしろうかりこめ
4 years ago
Views:

1 JTS Google App Engine S119325

2 Google App Engine Google App Engine JTS JTS JTS Spatial Data Model Binary Predicates Spatial Analysis Methods Lucene

3 Buffer Within iswithindistance distance Lucene Google Local Search API

4 1 1.1 Google Maps[1] JavaScript Web Google App Engine (GAE)[2] GAE GAE Google 1.2 GAE Eclipse 3.5 (Galileo)[3] Google Plugin for Eclipse Google 3

5 1.3 [4] PostgreSQL[5] PostGIS[6] GoogleMaps GAE JTS 1.1: 4

6 2 Google App Engine 2.1 Google App Engine GAE Google Web Web [2] GAE 5

7 2.2 ( ) 2 [7] 1. Infrastructure as a Service( IaaS) Software as a Service(SaaS) 2. IaaS 6

8 2.3 GAE Web Web GAE App Server GAE [7] 2.1: GAE 7

9 3 JTS 3.1 JTS JTS Java Topology Suite Vivid Solutions 2 Java API JTS [8] 3.2 JTS Java API Spatial Data Model Spatial Data Model JTS 3.1: JTS Spatial Data Model Point LineString 8

10 3.2.2 Binary Predicates Binary Predicates True False 3.2: JTS Binary Predicates Within LineString Spatial Analysis Methods Spatial Analysis Methods Spatial Operation Spatial Operation Geometry 3.3: JTS Spatial Analysis Methods Buffer 9

11 4 4.1 ( 1 ) App Server ( 2 ) App Server ( 3 ) Datastore ( 4 ) ( 5 ) 6 ( 7 ) ( 8 ) ( 9 ) (10 ) 4.1: 10

12 Eclipse 3.5 (Galileo)[3] Java GAE Eclipse Google App Engine SDK for Java[9] appengine-java-sdk zip Eclipse Google Plugin for Eclipse 3.5[10] ~\workspace\project\war\web-inf\lib lucene-core zip lucene-snowball zip CSV commons-fileupload jar JTS jts-1.8.jar AppEngine API Java Data Object( JDO) 11

13 4.3 Google Maps API GEvent.addListener(map, click,onsmapclick); point.x point.y x y 12

14 4.4 Eclipse Google Eclipse ID appengine-web.xml war appengine-web.xml 4.2: appengine-web.xml application ID 4 version 4.5 [11]

15 4.5.1 ID ID ID ID ID 1/ ( ) 1000 Google Maps km m 14

16 STRING 4.1: ID STRING Double Double X Double Y Double : : : : : : : : : : : : ID STRING Double X Y GEOMETRY Bigtable Double

17 4.5.2 ( ) Lucene ID ID ID ID 4.2: Lucene ID STRING STRING ID STRING ID LIST [u 10894, u 10424,, u ] : : : : [u 10792, u 10174,,u ] : : : : [u 10242,u 11220,,u ] 4.2 ID, ID STRING SQL LIKE Bigtable 16

18 ID ID ID STRING : STRING ID STRING ID STRING ID STRING : : : : : STRING

19 4.5.3 ID ID ID ID ID ID ID ( ID) ID ID STRING STRING 4.4: ID INT STRING 1 INT 64 INT STRING :30/7:32/ /8:10 : : : : : : : : :20/10:21/ /11: :20/11:21/ /12: :20/12:21/ /13: :20/10:21/ /11:01 : : : : : : : : :30/19:31/ /20: ID STRING ID INT TIME Bigtable INT 7:30 : ( )

20 4.5.4 ID ID STRING 4.5: TEXT LINESTRING( , ,, ) : : LINESTRING( , ,, ) : : LINESTRING( ,, ) 4.5 ID STRING GEOMETRY LINESTRING Bigtable TEXT STRING TEXT STRING

21 4.5.5 Buffer JTSTestBuilder.bat 4.6: ID STRING TEXT POLYGON(( , )) : : POLYGON(( , )) : : POLYGON(( , )) 4.6 ID STRING TEXT : 20

22 4.6 CSV JavaSDK JDO Java Persistence API( JPA) JDO GAE JDO JDO POJO 21

23 4.3: PersistentCapable Persistent PrimaryKey 22

24 4.6.2 PersistenceManager 4.4: 1. String split CSV 2. trim 3. ( close ) 23

25 4.7 SQL SELECT ID FROM WHERE ID= AND day= 0 AND 10:59:00 ; SQL Bigtable ~\workspace\project\war\web-inf\lib xml datastore-indexes.xml <datastore-index kind="bus_org_13_23" ancestor="false"> <property name="id" direction="asc" /> <property name="weekday" direction="asc" /> <property name="time1" direction="asc" /> </datastore-index> bus_org_13_23 id weekday time

26 4.7.2 Python appcfg.py vacuum indexes Java SDK Python 1. Python Google App Engine SDK for Python 2. Eclipse app.yaml vacuum indexes.bat 3. vacuum indexes.bat app.yaml application ID version handlers [app.yaml] application: ApplicationID version: 9999 runtime: python api_version: 1 handlers: - url: / script: dummy 25

27 vacuum indexes.bat eclipse eclipse [vacuum off cd /D %~dp0 appcfg.py vacuum_indexes. pause eclipse vacuum indexes.bat (N/y/a) y 26

28 m m 200m 100m 500m m 200m 100m 500m ID PostgreSQL PostGIS DBMS PostgreSQL SQL SELECT FROM WHERE ST DWITHIN(, GeomFromText( POINT( ),SRID[4326]), [500m]) = TRUE WHERE GeomFromText() PostGIS () Geometry SRID POINT PostGIS () 27

29 Bigtable PostGIS : 1. Y Y 500M 4.6: 28

30 2. 1 X 500M 4.7: 3. X Y 500M 4.8: 29

31 4. 500M 500M 4.9: (1264 ) 30

32 Buffer Within 1. Buffer 2. Within 4.10: Buffer Within 31

33 iswithindistance 1. iswithindistance 4.11: iswithindistance 32

34 distance 1. distance : distance 33

35 ( :ms) 4.13: Buffer Within Buffer 3. iswithindistance 4. distance distance 34

36 4.8.2 ID ID SQL SELECT ID FROM WHERE LIKE %10731%11220% ; ID WHERE LIKE % 0 Bigtable LIKE 4.14: Lucene ID 35

37 Lucene fts fts ID ID 1. ID 4.15: 36

38 : 37

39 Lucene fts 4.17: Lucene indexof 38

40 Where = && = Lucene Lucene 1500ms 3000ms 250ms 1000ms Lucene 2 3 Lucene Bigtable 39

4.8.3 SQL SELECT ID FROM WHERE ID= 17720101 AND

41 4.8.3 SQL SELECT ID FROM WHERE ID= AND day= 0 AND 10:59:00 ; ID Bigtable ID (4.6 ) 4.18: 40

42 1. ID: :00 Where ID= && = 1 && 33 > : 4.19 ID

43 4.8 ID STRING STRING 4.8: ID INT STRING 1 INT 64 INT STRING :30/7:32/ /8:10 : : : : : : : : :20/10:21/ /11: :20/11:21/ /12: :20/12:21/ /13: :20/10:21/ /11:01 : : : : : : : : :30/19:31/ /20:19 / split / ID SQL SELECT AsText( ) FROM WHERE ID = WHERE AsText( ) GEOMETRY WKT PostgreSQL GEOMETRY LINESTRING BigTable TEXT AsText( ) 42

44 4.8.5 ( 4.20) 4.20: 43

45 4.9 JavaScript GoogleAPI URL : 1 44

46 4.22:

47 Google Local Search API Google Local Search API[12] Google Javascript Google+[13] Google Local Search API geometry.poly.containslocation (LatLng,Poly) 1km Google+ 46

48 4.23: 4.23 ATM 47

49 5 Google App Engine 5.1: 2108ms 71ms 1069ms 732ms 2296ms 210ms 172ms 104ms 88ms 45ms 107ms 52ms 5.1 GAE

50 6 API JTS GAE GAE JTS Google+ 49

51 7 50

52 [1] [2] [3] [4],2009 [5] [6] [7] SYSTEMS DVD Google App Engine BP [8] [9] [10] [11] [12] [13] 51

s

s073083 23 3 17 1 2 1.1.............................. 2 1.2.............................. 2 1.3.............................. 3 2 4 2.1........................... 4 2.2 Google App Engine........................