Revision 26486 tmp/trunk/servidor/WorkSpace_Servidor/Callejero/src/es/logex/callejero/core/Callejero.java
Callejero.java | ||
---|---|---|
3 | 3 |
*/ |
4 | 4 |
package es.logex.callejero.core; |
5 | 5 |
|
6 |
import java.awt.geom.Rectangle2D; |
|
6 | 7 |
import java.sql.Connection; |
7 | 8 |
import java.util.*; |
9 |
|
|
8 | 10 |
import org.apache.commons.logging.Log; |
9 | 11 |
import org.apache.commons.logging.LogFactory; |
10 | 12 |
import es.logex.utils.*; |
13 |
|
|
14 |
import java.sql.ResultSetMetaData; |
|
11 | 15 |
import java.sql.SQLException; |
12 | 16 |
import java.sql.Statement; |
13 | 17 |
import java.sql.ResultSet; |
... | ... | |
22 | 26 |
import org.gvsig.gpe.GPERegister; |
23 | 27 |
import org.gvsig.gpe.writers.GPEWriterHandler; |
24 | 28 |
|
29 |
import org.postgis.PGbox2d; |
|
30 |
import org.postgis.PGgeometry; |
|
31 |
import org.postgis.PGboxbase; |
|
32 |
|
|
25 | 33 |
/* logEx. Lógica Extrema s.l.* |
26 | 34 |
* Copyright (C) 2007 Lógica Extrema and Generalitat Valenciana. |
27 | 35 |
* |
... | ... | |
134 | 142 |
|
135 | 143 |
return map; |
136 | 144 |
} |
145 |
|
|
146 |
/** |
|
147 |
* Devuelve el extent máximo del callejero. En principio mira en la tabla de parcelas, pero quizás sería más riguroso mirar en todas las tablas |
|
148 |
* y devolver los máximos... |
|
149 |
* @return |
|
150 |
* @throws Exception |
|
151 |
*/ |
|
152 |
public Rectangle2D getMaxExtent() throws Exception{ |
|
153 |
ResultSet r = null; |
|
154 |
Statement s = null; |
|
155 |
PGbox2d pgBox = null; |
|
156 |
|
|
157 |
try { |
|
158 |
s = conn.createStatement(); |
|
159 |
r = s.executeQuery("SELECT EXTENT(the_GEOM) as bbox FROM parcelas"); |
|
160 |
|
|
161 |
if (r.next() ) { |
|
162 |
pgBox = (PGbox2d) r.getObject("bbox"); |
|
163 |
} |
|
164 |
|
|
165 |
Rectangle2D rec = new Rectangle2D.Double(pgBox.getLLB().x,pgBox.getLLB().y, pgBox.getURT().x, pgBox.getURT().y) ; |
|
166 |
return rec; |
|
167 |
|
|
168 |
} catch (SQLException e) { |
|
169 |
// TODO Auto-generated catch block |
|
170 |
e.printStackTrace(); |
|
171 |
throw e; |
|
172 |
} |
|
173 |
|
|
174 |
} |
|
137 | 175 |
|
138 | 176 |
} |
139 | 177 |
|
Also available in: Unified diff