Search DaniWeb - poi

Poi based on latitude and longitude 13 Years Ago by newbie14 Dear All, I have a big table of poi's based on latitude and longitude. So then based on … I would like to find the nearest point in my poi table. Can I use some mysql functionality to do to…] Below is my table. [CODE]CREATE TABLE IF NOT EXISTS `poi` ( `poiID` int(11) NOT NULL auto_increment, `type` varchar(50) NOT… Re: Poi based on latitude and longitude 13 Years Ago by almostbob … the already defined calculator to calculate the distance from each poi to the current point, and select those less than the… you the source of how they plot points in their poi set closest to the user's location Re: Poi based on latitude and longitude 13 Years Ago by newbie14 Dear Urtrivedi, Below is some sample data from table poi. So for instance my input now is long 100.295 … Re: Poi based on latitude and longitude 13 Years Ago by urtrivedi … a.*,get_poi_distance(100.295, 6.234,`long`,`lat`) distance FROM `poi` a WHERE 1 order by distance limit 2 [/code] I… Re: Poi based on latitude and longitude 13 Years Ago by almostbob you have a functional calculator for distance, you have a max value for distance [code=sql]SELECT a.*,get_poi_distance(100.295, 6.234,`long`,`lat`) distance FROM `poi` a WHERE get_poi_distance <= $input_max_distance[/code] this code sample not guaranteed, you have to look up the syntax for the sql version in use, its an idea Re: Poi based on latitude and longitude 13 Years Ago by almostbob the calculator at poi friend is in metres less than 1km, in km > 1 km, but that seems to be an output convenience to make it easier to read /1000 or*1000 in the code if they are willing to give it would not be hard Re: Poi based on latitude and longitude 13 Years Ago by newbie14 Dear Bob, I have tried to ask the poi friend people but not answer yet. So just would like to ask you the distance calculated via the mysql method is it in km or metres? Re: Poi based on latitude and longitude 13 Years Ago by jjc_Mtl Usually, it's a good idea to make a first selection like this [CODE] SELECT * FROM POI WHERE ABS(rowLat - pLat)< 1 AND ABS(rowLong - pLong)<1 [/CODE] and apply the Distance function only on the small selection. < 1 means difference must be lower than 1 degree; you must adjust the value to your needs 0.1 degree for example. Re: Poi based on latitude and longitude 13 Years Ago by jjc_Mtl … MBR.bottom properties to select your points: [CODE] SELECT * FROM POI WHERE (pLong > MBR.Left) AND (pLong < MBR.right… POI API Implementation problem 12 Years Ago by Vish0203 ….. I'm trying to read a .docx file using apache poi api methods.. But i'm facing a few problems.. Can… this code?? package apiole; import java.io.*; import org.apache.poi.xwpf.extractor.XWPFWordExtractor; public class Apiole { public static void main… Re: POI API Implementation problem 12 Years Ago by Vish0203 yes, file exists.. I got it! I need to import org.apache.poi.xwpf.usermodel.XWPFDocument XWPFDocument class is defined in this. Re: Adding image in doc file using Apache POI 10 Years Ago by arindam.r.chowdhury.7 … code got some issue this works fine.. I have used poi 3.10 to generate word doc and to insert pic….XWPFHeaderFooterPolicy; import org.apache.poi.xwpf.usermodel.Document; import org.apache.poi.xwpf.usermodel.ParagraphAlignment; import org.apache.poi.xwpf.usermodel.UnderlinePatterns; import… Re: Adding image in doc file using Apache POI 10 Years Ago by arindam.r.chowdhury.7 …; import org.apache.poi.xwpf.usermodel.ParagraphAlignment; import org.apache.poi.xwpf.usermodel.UnderlinePatterns; import org.apache.poi.xwpf.usermodel.XWPFDocument;… import org.apache.poi.xwpf.usermodel.XWPFParagraph;… Adding image in doc file using Apache POI 11 Years Ago by subhraakasuny … some text and images in it. I am using Apache POI for this.I am able to create and add text….exceptions.InvalidFormatException; import org.apache.poi.util.Units; import org.apache.poi.xwpf.usermodel.ParagraphAlignment; import org.apache.poi.xwpf.usermodel.UnderlinePatterns; import… Install Apache POI with Elipse 15 Years Ago by evandana … this file: [url]http://mirrors.devlib.org/apache/poi/release/bin/poi-bin-3.2-FINAL-20081019.tar.gz[/url] from… poi.apache.org, and don't know what to do next…Java:* [code] import org.apache.poi.poifs.filesystem.*; import org.apache.poi.hwpf.*; import org.apache.poi.hwpf.extractor.*; import java.io.*; … Apache Poi for doc 14 Years Ago by shivarocks … tried googling and i got to know about "apache poi". this is working great for opening a doc file… import="java.io.*,java.io.*,org.apache.poi.hwpf.HWPFDocument,org.apache.poi.hwpf.extractor.WordExtractor" %> <% File file… Re: Apache Poi for doc 14 Years Ago by shivarocks … one .doc file content into another .doc file using poi in jsp but i want to write some text into… a .doc file using poi, so please can anyone help me in doing that …,org.apache.poi.hwpf.HWPFDocument,org.apache.poi.hwpf.usermodel.CharacterRun,org.apache.poi.hwpf.usermodel.Range,org.apache.poi.poifs.filesystem.… Re: Install Apache POI with Elipse 15 Years Ago by peter_budo … file and you will get 3 JAR files (poi-3.2-FINAL-20081019.jar, poi-contrib-3.2-FINAL-20081019.jar and…-20081019.jar, most of the times you will need only poi and poi-scratchpad) plus other documentation. Then you have to attach… Replace table column value in Apache POI 13 Years Ago by jamojo …XWPFDocument; import org.apache.poi.xwpf.usermodel.XWPFParagraph; import org.apache.poi.xwpf.usermodel.XWPFTable; import org.apache.poi.xwpf.usermodel.XWPFTableCell; …import org.apache.poi.xwpf.usermodel.XWPFTableRow; public… How to install Apache POI 18 Years Ago by parthiban Hi all, I have download Apache POI(2.5.1) to convert a Excel file to XML … three Executable JAR files 1.poi-2.5.1-final 2.poi-contrib-2.5.1 3.poi-scratch-2.5.1 Please… using poi filesystem problem 17 Years Ago by hidash_in hi, i want some help about POI file system. is it possible to open the word and excel file using poi file system. i have created ta new excel and word file using poi. but i am struggling to open the files using poi. plz help me. God Never Fails. Good Friday. Advance Thanks Hidash.. Re: Install Apache POI with Elipse 13 Years Ago by audaykum hi can you please tell me hoe you got the code you've mentioned to compile and run. Im using poi API for the first time. I need to convert powerpoint to image. Can you help me out with that? Re: Install Apache POI with Elipse 13 Years Ago by peter_budo 1) Bad idea to reopen old thread 2) Little search and less excuses of being new and you would have found [URL="http://mail-archives.apache.org/mod_mbox/poi-user/200809.mbox/%3C19575440.post@talk.nabble.com%3E"]this code[/URL] Re: Install Apache POI with Elipse 12 Years Ago by mbajaj_92 Plz Give me a Link from Where To Download The APache POI for Creating and editing Excel Files through JAVA.... ive dwnloaded the zip files from various Sources but there is No jra file in those zip files..... plz post the exact Link From where i can directly dwnload the file..... Thnx Re: Install Apache POI with Elipse 12 Years Ago by peter_budo [Here](http://lmgtfy.com/?q=Apache+POI+download) Re: Replace table column value in Apache POI 13 Years Ago by peter_budo OK, looking at POI code XWPFTableCell consists of number of XWPFParagraphs of which you … Re: Using APACHE POI with Eclipse? 10 Years Ago by Traevel …/) is an alternate solution to your problem. It uses POI and many others, but combines them into a single API…> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>…3.11</version> </dependency> for POI or <dependency> <groupId>org.apache.… Error in POI 16 Years Ago by SylviaCrissy … am reading an excel worksheet and done some modifications using poi and saved the new file into different location.while writing… How to install Apache POI 14 Years Ago by Ronik hello sir m find a apache poi jar file what m confuse where to put this jar file so plz help me nd send a mail me procedure of use a poi jar file set class path and other details. plz send me on my mail id <snip> reading image from excel using POI 6 Years Ago by subhraakasuny … same time mapping that image with particular cell using apche POI. I have two questions actually: 1. Is there any way… excel cell so that I can read the image using POI as a cell property? 2. If above point is not…