. We schedule a
number of jobs and Jitterbit executes the jobs and reports on success or
failure.
Note we are NOT loading spatial data, only tabular data, but I expect it's
possible to load geometry using WKT.
Regards,
Tom
---
Tom Glancy
Ecological
Your dbf file contains spaces (0x20) in the microrelie boolean and
macrorelie boolean fields. The representation of NULL in boolean fields is a
question mark (0x3f). Allowable characters in a boolean field are
Y,y,N,n,T,t,F,f,?
It looks like your dbf is broken.
Regards,
Tom
Willy-Bas
I agree with Rob - pgadmin can hide the geometry.
Try:
select char_length(asText(the_geom)) from TABLE where gid =
MISSING_GEOM_GID;
On a test here, the select returned 137999 even though pgadmin looked blank.
Or double-click the missing the_geom cell in pgadmin.
Regards,
Tom
Rob
---
Tom Glancy
Minnesota Department of Natural Resources
St. Paul, MN 55155-4025
---
Shane Wegner [EMAIL PROTECTED] 7/23/2008 10:50 AM
Hello all,
We have encountered a bit of a puzzle and are trying to
figure out why Postgis's azimuth
Greetings!
I have the same results as Kevin - TRUE in both cases...
Regards,
Tom
On Wed, 2008-10-15 at 17:23 +0100, Fred Lehodey wrote:
Hi,
I have the same results as David: (false)
postgis_full_version():
POSTGIS=1.3.3 GEOS=3.0.0-CAPI-1.4.1 PROJ=Rel. 4.6.0, 21 Dec
2007 USE_STATS
,SPHEROID[WGS
84,6378137,298.257223563,AUTHORITY[EPSG,7030]],AUTHORITY[EPSG,6326]],PRIMEM[Greenwich,0,AUTHORITY[EPSG,8901]],UNIT[degree,0.01745329251994328,AUTHORITY[EPSG,9122]],AUTHORITY[EPSG,4326]]
So I would use -s 4326
Regards,
Tom
---
Tom Glancy
It looks like there is a parenthesis missing - the closing parenthesis for
VALUES.
maybe try:
sSql='INSERT INTO hm_raster.hm_airphotos( file_ext, airphoto) VALUES
('.tif', lo_import( E''C:\\HM\\Data\\Flightmap.tif''));';
Tom
---
Tom Glancy
Ecological
Greetings,
This looks like WGS 84 (srid 4326) -- UTM zone 17S (srid 32317)
Here is the code:
select asText(Transform(geomFromText('POINT (-78.9856190700062
-2.90724299848327)', 4326), 32317))
results in:
POINT(723909.733375549 9678459.93445246)
There are small differences on the order of
You are missing a semicolon to end the SQL statement. Try
$sql = INSERT INTO processos (id, the_geom) VALUES
(1,(ST_PointFromText('POINT(-2 -62)',4291)));;
pg_query($con, $sql);
Regards,
Tom
---
Tom Glancy
Ecological Resources Division IT Manager
tom.gla