[postgis] Re: Adobe Illustrator to SQL
greenwoodmap
rich at greenwoodmap.com
Wed Feb 27 05:22:56 PST 2002
It sounds like when you exported from AI to AutoCAD you ended up
with a "block". That's AutoCAD speak for a group of objects. If you
have AutoCAD, use the "explode" command to un-group the block.
Lacking AutoCAD, look for block related options in the AI export
options.
Rich
Rich at GreenwoodMap.com
--- In postgis at y..., "thebanker95065" <thebanker95065 at y...> wrote:
> Hello Everyone,
>
> I have an Adobe Illustrator (AI) file that I would like to
translate
> into SQL. Specifically, the AI file is a map. It has various
> layers, for example a "telephones" layer. I want to get a set of
> points into the database such that I can make a query at a
location
> and find the nearest telephone.
>
> So what I've done is select the telephones layer and export it as
a
> dwg file. I then use ArcView to translate the dwg file into an
ESRI
> shape file, and then use the PostGis translator to turn it into
SQL.
>
> The problem I have is that the telephones on the map are actually
> icons, which translate into MultiLine entities. It wouldn't be so
> bad if each telephone icon was a seperate entity (by which I mean
> that each one will eventually turn into a single SQL entry), but
the
> final SQL file I get has only one entity, a giant MultiLine, which
> includes ALL of the telephone icons.
>
> I can tell from the Shape file itself that I have 23 PolyLineZ
shapes
> (this is the correct number, there are 23 phones I am interested
in).
>
> Why, then, are all 23 PolyLineZ shapes going into a single SQL
entry?
>
> Thanks for your help.
------------------------ Yahoo! Groups Sponsor ---------------------~-->
Tiny Wireless Camera under $80!
Order Now! FREE VCR Commander!
Click Here - Only 1 Day Left!
http://us.click.yahoo.com/nuyOHD/7.PDAA/yigFAA/PhFolB/TM
---------------------------------------------------------------------~->
To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
More information about the postgis-users
mailing list