shrug-l: Copy fields
Mayo, Michele
Michele.Mayo@dep.state.fl.us
Thu, 23 Sep 2004 12:42:06 -0400
This is a multi-part message in MIME format.
------_=_NextPart_001_01C4A18C.42E971F0
Content-Type: text/plain;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
Hello Jason,
=20
It sounds like all you really need to do is make a copy of the =
shapefile's
.dbf, open it in Excel, then delete any fields that you don't need.
=20
Hope this helps,
Michele
=20
=20
Michele Mayo, GIS Systems Project Analyst
Florida DEP, Groundwater Regulatory Section
2600 Blair Stone Road MS 3580
Tallahassee, FL 32399
(850) 245-8658
michele.mayo@dep.state.fl.us
=20
=20
-----Original Message-----
From: Jason Houck [mailto:JHouck@drmp.com]=20
Sent: Thursday, September 23, 2004 11:34 AM
To: shrug-l@lists.dep.state.fl.us
Subject: shrug-l: Copy fields
=20
I have a polygon shapefile and an empty table. I am looking for a way =
to
copy all of the records in one field in the shapefile into one field in =
the
table. Does anyone know of a way to automate this. With a little over =
900
polygons, I would really like to avoid typing them in by hand.
=20
Thanks
=20
Jason M. Houck, MS
GIS Analyst, Water Resources Dept.
DRMP, Inc.
1505 East Colonial Dr.
Orlando, FL 32803
407-896-0594 (phone)
407-896-4836 (fax)
=20
------_=_NextPart_001_01C4A18C.42E971F0
Content-Type: text/html;
charset="US-ASCII"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<meta http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<title>Message</title>
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle19
{font-family:Tahoma;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-US link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Hello Jason,</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>It sounds like all you really need =
to do
is make a copy of the shapefile’s .dbf, open it in Excel, then =
delete any
fields that you don’t need.</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Hope this helps,</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'>Michele</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><b><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue;
font-weight:bold'>Michele Mayo</span></font></b><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>,
GIS Systems Project Analyst</span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>Florida</span></=
font><font
size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:blue'> DEP, Groundwater Regulatory </span></font><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>Section</span></=
font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>2600
Blair Stone Road</span></font><font size=3D2 color=3Dblue =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'> MS =
3580</span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>Tallahassee</spa=
n></font><font
size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:blue'>, </span></font><font size=3D2 color=3Dblue =
face=3DTahoma><span
=
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>FL</span></font>=
<font
size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;
color:blue'> </span></font><font size=3D2 color=3Dblue =
face=3DTahoma><span
=
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>32399</span></fo=
nt></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>(850)
245-8658</span></font></p>
<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
color=3Dblue
face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma;color:blue'>michele.mayo@dep=
.state.fl.us</span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 color=3Dblue face=3DTahoma><span =
style=3D'font-size:
10.0pt;font-family:Tahoma;color:blue'> </span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original =
Message-----<br>
<b><span style=3D'font-weight:bold'>From:</span></b> Jason Houck
[mailto:JHouck@drmp.com] <br>
<b><span style=3D'font-weight:bold'>Sent:</span></b> </span></font><font =
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>Thursday,
September 23, 2004</span></font><font size=3D2 face=3DTahoma><span
style=3D'font-size:10.0pt;font-family:Tahoma'> </span></font><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'>11:34 =
AM</span></font><font
size=3D2 face=3DTahoma><span =
style=3D'font-size:10.0pt;font-family:Tahoma'><br>
<b><span style=3D'font-weight:bold'>To:</span></b> =
shrug-l@lists.dep.state.fl.us<br>
<b><span style=3D'font-weight:bold'>Subject:</span></b> shrug-l: Copy =
fields</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> </span></font></p>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>I have a polygon shapefile =
and an
empty table. I am looking for a way to copy all of the records in =
one
field in the shapefile into one field in the table. Does =
anyone
know of a way to automate this. With a little over 900 polygons, I =
would
really like to avoid typing them in by hand.</span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> </span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 =
face=3DArial><span
style=3D'font-size:10.0pt;font-family:Arial'>Thanks</span></font></p>
</div>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> </span></font></p>
</div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><strong><b><font =
size=3D4 face=3DArial><span
style=3D'font-size:13.5pt;font-family:Arial'>Jason M. Houck, =
MS</span></font></b></strong></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><em><i><font size=3D3 =
face=3DArial><span
style=3D'font-size:12.0pt;font-family:Arial'>GIS Analyst, Water =
Resources Dept.</span></font></i></em></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><strong><b><font =
size=3D3 color=3Dred
face=3DArial><span =
style=3D'font-size:12.0pt;font-family:Arial;color:red'>DRMP,
Inc.</span></font></b></strong></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><strong><b><font =
size=3D3 color=3Dred
face=3DArial><span =
style=3D'font-size:12.0pt;font-family:Arial;color:red'>1505
East Colonial Dr</span></font></b></strong><strong><b><font =
color=3Dred
face=3DArial><span =
style=3D'font-family:Arial;color:red'>.</span></font></b></strong></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><strong><b><font =
size=3D3 color=3Dred
face=3DArial><span =
style=3D'font-size:12.0pt;font-family:Arial;color:red'>Orlando</span></fo=
nt></b></strong><strong><b><font
color=3Dred face=3DArial><span style=3D'font-family:Arial;color:red'>, =
</span></font></b></strong><strong><b><font
color=3Dred face=3DArial><span =
style=3D'font-family:Arial;color:red'>FL</span></font></b></strong><stron=
g><b><font
color=3Dred face=3DArial><span style=3D'font-family:Arial;color:red'> =
</span></font></b></strong><strong><b><font
color=3Dred face=3DArial><span =
style=3D'font-family:Arial;color:red'>32803</span></font></b></strong></p=
>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dred face=3DArial><span
style=3D'font-size:12.0pt;font-family:Arial;color:red'>407-896-0594 =
(phone)</span></font></p>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
color=3Dred face=3DArial><span
style=3D'font-size:12.0pt;font-family:Arial;color:red'>407-896-4836 =
(fax)</span></font></p>
<div>
<p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 =
face=3D"Times New Roman"><span
style=3D'font-size:12.0pt'> </span></font></p>
</div>
</div>
</body>
</html>
------_=_NextPart_001_01C4A18C.42E971F0--