Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two tables EMP and DEPT. Employees are belongs to the NEW YORK,DALLAS,CHICAGO,BOSTON areas.
I want to show a google map like this:
Employees need to be shown on google map respective location and his\her Sal.
Kindly help me.
EMP:
LOAD * INLINE [
EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO
7369,SMITH,CLERK,7902,17-Dec-1980,800,NULL,20
7499,ALLEN,SALESMAN,7698,20-Feb-1981,1600,300,30
7521,WARD,SALESMAN,7698,22-Feb-1981,1250,500,30
7566,JONES,MANAGER,7839,02-Apr-1981,2975,NULL,20
7654,MARTIN,SALESMAN,7698,28-Sep-1981,1250,1400,30
7698,BLAKE,MANAGER,7839,01-May-1981,2850,NULL,30
7782,CLARK,MANAGER,7839,09-Jun-1981,2450,NULL,10
7788,SCOTT,ANALYST,7566,09-Dec-1982,3000,NULL,20
7839,KING,PRESIDENT,NULL,17-Nov-1981,5000,NULL,10
7844,TURNER,SALESMAN,7698,08-Sep-1981,1500,0,30
7876,ADAMS,CLERK,7788,12-Jan-1983,1100,NULL,20
7900,JAMES,CLERK,7698,03-Dec-1981,950,NULL,30
7902,FORD,ANALYST,7566,03-Dec-1981,3000,NULL,20
7934,MILLER,CLERK,7782,23-Jan-1982,1300,NULL,10
];
LOAD * INLINE [
DEPTNO,DNAME,LOC
10,ACCOUNTING,NEW YORK
20,RESEARCH,DALLAS
30,SALES,CHICAGO
40,OPERATIONS,BOSTON
];
Used below link to create this file
Hi All, Please help me.
Do you have lattitude and longitude?
No. Thank you.
Well you need to supply the map coordinates to overlay this data on a map. Google city coordinates and create a table containing LOC, latitude and longitude which you can join to your second inline table.
LOC means Location. I am very new to this. Please help me. Thank you.
For every LOC you have to have latitude and longitude so it can be put on the map. For NY it is 40.7127840 -74.0059410 (you can use google for that).
I've used this guide for maps Step-by-Step Google Map API v3 integration.
It worked for me.
Create an inline table:
Locations:
LOAD * INLINE
[
LOC, Latitude, Longitude
NEW YORK, 123456.789012, -9876543.21098
DALLAS, 23456.789012, 9876543.21098
<and so on for other locations>
];
Then replace the numbers with the actual latitude and longitude. You will have to look this up yourself.
Is this your first model? I would consider dynamic mapping to be a rather advanced topic and you might be better off with simpler models until you have a firmer understanding.
Hi,
To plot values on map you need location details like Latitude and Longitude, with out this it is not possible and no meaning in using the maps.
Regards,
Jagan.
Please find the LOC details.
LOCATIONS:
LOAD * INLINE [
LOC,LATITUDE,LONGITUDE,SEA LEVEL
NEW YORK,40.80549384,-73.59809875,77 m
DALLAS,32.7766642,-96.7969879,138 m
CHICAGO,41.8781136,-87.6297982,181 m
BOSTON,42.3600825,-71.0588801,10 m
];