권남

사용자 도구

사이트 도구

추적:
database:mysql:geospatial

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

다음 판 		이전 판
마지막 판 양쪽 다음 판
database:mysql:geospatial [2021/01/22 17:48]
kwon37xi 만듦 		database:mysql:geospatial [2021/01/22 17:51]
kwon37xi
줄 1: 줄 1:
 ====== MySQL Geospatial ====== ====== MySQL Geospatial ======
   * [[database:mysql|MySQL]] 위치 정보 조회   * [[database:mysql|MySQL]] 위치 정보 조회
 +  * [[https://dev.mysql.com/doc/refman/8.0/en/spatial-types.html|MySQL :: MySQL 8.0 Reference Manual :: 11.4 Spatial Data Types]]
 +  * [[https://dev.mysql.com/doc/refman/5.7/en/spatial-analysis-functions.html|MySQL :: MySQL 5.7 Reference Manual :: 12.17 Spatial Analysis Functions]]
   * [[https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry|Well-known text representation of geometry - WKT]]   * [[https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry|Well-known text representation of geometry - WKT]]
 +  * [[http://www.gisdeveloper.co.kr/?p=994|[GIS] WKT(Well-Known Text) Geometry – GIS Developer]] 
 +  
 ===== POLYGON 안에 POINT가 속하는지? ===== ===== POLYGON 안에 POINT가 속하는지? =====
 * [[https://stackoverflow.com/questions/25491938/mysql-spatial-query-to-find-whether-a-latitude-longitude-point-is-located-withi|geospatial - MySQL: Spatial Query to find whether a latitude/longitude point is located within a given boundary - Stack Overflow]] * [[https://stackoverflow.com/questions/25491938/mysql-spatial-query-to-find-whether-a-latitude-longitude-point-is-located-withi|geospatial - MySQL: Spatial Query to find whether a latitude/longitude point is located within a given boundary - Stack Overflow]]
줄 10: 줄 13:
              ST_GEOMFROMTEXT('POLYGON((100.49503326416016 13.766897133254545, 100.55940628051758 13.746555203977,100.56266784667969 13.72170897580617, 100.48885345458984 13.739051587150175,              ST_GEOMFROMTEXT('POLYGON((100.49503326416016 13.766897133254545, 100.55940628051758 13.746555203977,100.56266784667969 13.72170897580617, 100.48885345458984 13.739051587150175,
              100.49503326416016 13.766897133254545))'))              100.49503326416016 13.766897133254545))'))
-As geoFenceStatus+As geoFenceStatus;
 </code> </code>
  
 ===== 참조 ===== ===== 참조 =====
   * [[https://stackoverflow.com/questions/25491938/mysql-spatial-query-to-find-whether-a-latitude-longitude-point-is-located-withi|geospatial - MySQL: Spatial Query to find whether a latitude/longitude point is located within a given boundary - Stack Overflow]]   * [[https://stackoverflow.com/questions/25491938/mysql-spatial-query-to-find-whether-a-latitude-longitude-point-is-located-withi|geospatial - MySQL: Spatial Query to find whether a latitude/longitude point is located within a given boundary - Stack Overflow]]
 +  * [[https://mysqlserverteam.com/upgrading-to-mysql-8-0-with-spatial-data/|Upgrading to MySQL 8.0 with Spatial Data | MySQL Server Blog]]
 +  * [[https://mysqlserverteam.com/detecting-incompatible-use-of-spatial-functions-before-upgrading-to-mysql-8-0/|Detecting Incompatible Use of Spatial Functions before Upgrading to MySQL 8.0 | MySQL Server Blog]]
 +  * [[https://mysqlserverteam.com/geography-in-mysql-8-0/|Geography in MySQL 8.0 | MySQL Server Blog]]
database/mysql/geospatial.txt · 마지막으로 수정됨: 2021/01/22 17:54 저자 kwon37xi

문서 도구

별도로 명시하지 않을 경우, 이 위키의 내용은 다음 라이선스에 따라 사용할 수 있습니다: CC Attribution-Share Alike 4.0 International
CC Attribution-Share Alike 4.0 International Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki