* I have a LIST containing SiteNames (this is a LIST i created named "mynewlist") * I have a FC that has a SiteName field I want to create a LIST / ARRAY of the data that is in the FC, where the List (mynewlist) and FC (Field "SiteName") are the same. For instance... I have 5 Sitenames in the LIST (# 1 above) I have 200 Sitenames in the FC (#2 above) I want a resulting LIST that is comprised of fields 1-9 from the FC where the LIST values are the same as the FC SiteName field. Think I have everything in order just need help with the actual query??? I don't even know if I can create a Query from a LIST and a FC....do I need to convert the list to something else first? arcpy . env . workspace = "C:\\Users\\xyz\\AppData\\Roaming\ESRI\\Desktop10.4\\ArcCatalog\\xyz@xyz.sde" myFCLayer = "BoatRampsWGS" #Set variables for the FC above var_SITENAME , var_WATERBODY , var_ACCESSAREA , var_BODYOFWATE = 'SITENAME' , 'WATERBODY' , 'ACCESSAREA' , 'BODYOFWATE' var_TYPE , var_NO_OFRAMPS , var_COUNTY , var_REGION = 'TYPE' , 'NO_OFRAMPS' , 'COUNTY' , 'REGION' var_Lat , var_Long = 'Lat' , 'Long' QueryBoatRamps = [ var_SITENAME , var_COUNTY , var_REGION , var_WATERBODY , var_BODYOFWATE , var_ACCESSAREA , var_TYPE , var_NO_OFRAMPS , var_Lat , var_Long ] # Build a query that will grab the records from the FC where the two SiteName fields are the same from the FC (BoatRampsWGS) and the LIST (myBoatRampList) RampQry = #Grab all the records from FC (BoatRampsWGS) where th4e Sitename is the same as the sitename in the LIST (myBoatRampList) # write these records to a new list BoatRampList = [ ] with arcpy . da . SearchCursor ( myFCLayer , QueryBoatRamps , RampQry ) as cursor : for row in cursor : varBoatRampsList = str ( '{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}' . format ( row [ 0 ] , row [ 1 ] , row [ 2 ] , row [ 3 ] , row [ 4 ] , row [ 5 ] , row [ 6 ] , row [ 7 ] , row [ 8 ] , row [ 9 ] ) ) BoatRampList . append ( varBoatRampsList )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Use list as input parameter to query FC

jaykapalczynski

I have a LIST containing SiteNames (this is a LIST i created named "mynewlist")
I have a FC that has a SiteName field

I want to create a LIST / ARRAY of the data that is in the FC, where the List (mynewlist) and FC (Field "SiteName") are the same.

For instance...

I have 5 Sitenames in the LIST (# 1 above)

I have 200 Sitenames in the FC (#2 above)

I want a resulting LIST that is comprised of fields 1-9 from the FC where the LIST values are the same as the FC SiteName field.

Think I have everything in order just need help with the actual query???

I don't even know if I can create a Query from a LIST and a FC....do I need to convert the list to something else first?

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> <SPAN class="string token">"C:\\Users\\xyz\\AppData\\Roaming\ESRI\\Desktop10.4\\ArcCatalog\\xyz@xyz.sde"</SPAN>
myFCLayer <SPAN class="operator token">=</SPAN> <SPAN class="string token">"BoatRampsWGS"</SPAN>

<SPAN class="comment token">#Set variables for the FC above</SPAN>
var_SITENAME<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SITENAME'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WATERBODY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ACCESSAREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BODYOFWATE'</SPAN>
var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION <SPAN class="operator token">=</SPAN> <SPAN class="string token">'TYPE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NO_OFRAMPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COUNTY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'REGION'</SPAN>
var_Lat<SPAN class="punctuation token">,</SPAN>var_Long <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Long'</SPAN>

QueryBoatRamps <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>var_SITENAME<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_Lat<SPAN class="punctuation token">,</SPAN>var_Long<SPAN class="punctuation token">]</SPAN>


<SPAN class="comment token"># Build a query that will grab the records from the FC where the two SiteName fields are the same from the FC (BoatRampsWGS) and the LIST (myBoatRampList)</SPAN>

RampQry<SPAN class="operator token">=</SPAN>&nbsp; <SPAN class="comment token">#Grab all the records from FC (BoatRampsWGS) where th4e Sitename is the same as the sitename in the LIST (myBoatRampList)</SPAN>



<SPAN class="comment token"># write these records to a new list</SPAN>
BoatRampList<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>myFCLayer<SPAN class="punctuation token">,</SPAN> QueryBoatRamps<SPAN class="punctuation token">,</SPAN> RampQry<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varBoatRampsList <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoatRampList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>varBoatRampsList<SPAN class="punctuation token">)</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

jaykapalczynski

THINK I GOT IT....one minute for testing

I had to fix the apostrophe

<SPAN class="keyword token">if</SPAN> string<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN> 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'fixing apostrophe in'</SPAN><SPAN class="punctuation token">,</SPAN> varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'to be queryable.'</SPAN> 
fn_name_qry <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"''"</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN> fn_name_qry 
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
fn_name_qry <SPAN class="operator token">=</SPAN> varQuery<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="comment token">#Set variables for the FC above</SPAN>
var_SITENAME<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SITENAME'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WATERBODY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ACCESSAREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BODYOFWATE'</SPAN>
var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION <SPAN class="operator token">=</SPAN> <SPAN class="string token">'TYPE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NO_OFRAMPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COUNTY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'REGION'</SPAN>
var_Lat<SPAN class="punctuation token">,</SPAN>var_Long <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Long'</SPAN>

QueryBoatRamps <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>var_SITENAME<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_Lat<SPAN class="punctuation token">,</SPAN>var_Long<SPAN class="punctuation token">]</SPAN>

BoatRampList<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Build a query that will grab the records from the FC where the two SiteName fields are the same from the FC (BoatRampsWGS) and the LIST (myBoatRampList)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">""</SPAN>
<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN> val <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>mynewMatchedlist<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; varQuery <SPAN class="operator token">=</SPAN> val
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> varQuery

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> string<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'fixing apostrophe in'</SPAN><SPAN class="punctuation token">,</SPAN> varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'to be queryable.'</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fn_name_qry <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"''"</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fn_name_qry&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fn_name_qry <SPAN class="operator token">=</SPAN> varQuery
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#RampQry="""SITENAME = '{}'""".format(varQuery)</SPAN>
&nbsp;&nbsp;&nbsp; RampQry<SPAN class="operator token">=</SPAN><SPAN class="string token">"""SITENAME = '{}'"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fn_name_qry<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#print RampQry</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>myLayer<SPAN class="punctuation token">,</SPAN> QueryBoatRamps<SPAN class="punctuation token">,</SPAN> RampQry<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varBoatRampsList <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoatRampList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>varBoatRampsList<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> BoatRampList<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

jaykapalczynski

THINK I GOT IT....one minute for testing

I had to fix the apostrophe

<SPAN class="keyword token">if</SPAN> string<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN> 
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">'fixing apostrophe in'</SPAN><SPAN class="punctuation token">,</SPAN> varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'to be queryable.'</SPAN> 
fn_name_qry <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"''"</SPAN><SPAN class="punctuation token">)</SPAN> 
<SPAN class="keyword token">print</SPAN> fn_name_qry 
<SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> 
fn_name_qry <SPAN class="operator token">=</SPAN> varQuery<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

<SPAN class="comment token">#Set variables for the FC above</SPAN>
var_SITENAME<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SITENAME'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WATERBODY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ACCESSAREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BODYOFWATE'</SPAN>
var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION <SPAN class="operator token">=</SPAN> <SPAN class="string token">'TYPE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NO_OFRAMPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COUNTY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'REGION'</SPAN>
var_Lat<SPAN class="punctuation token">,</SPAN>var_Long <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Long'</SPAN>

QueryBoatRamps <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>var_SITENAME<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_Lat<SPAN class="punctuation token">,</SPAN>var_Long<SPAN class="punctuation token">]</SPAN>

BoatRampList<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Build a query that will grab the records from the FC where the two SiteName fields are the same from the FC (BoatRampsWGS) and the LIST (myBoatRampList)</SPAN>
<SPAN class="keyword token">print</SPAN> <SPAN class="string token">""</SPAN>
<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN> val <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>mynewMatchedlist<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; varQuery <SPAN class="operator token">=</SPAN> val
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> varQuery

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> string<SPAN class="punctuation token">.</SPAN>find<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token"><></SPAN> <SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> <SPAN class="string token">'fixing apostrophe in'</SPAN><SPAN class="punctuation token">,</SPAN> varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'to be queryable.'</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fn_name_qry <SPAN class="operator token">=</SPAN> string<SPAN class="punctuation token">.</SPAN>replace<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"'"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"''"</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> fn_name_qry&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fn_name_qry <SPAN class="operator token">=</SPAN> varQuery
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#RampQry="""SITENAME = '{}'""".format(varQuery)</SPAN>
&nbsp;&nbsp;&nbsp; RampQry<SPAN class="operator token">=</SPAN><SPAN class="string token">"""SITENAME = '{}'"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>fn_name_qry<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#print RampQry</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>myLayer<SPAN class="punctuation token">,</SPAN> QueryBoatRamps<SPAN class="punctuation token">,</SPAN> RampQry<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varBoatRampsList <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoatRampList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>varBoatRampsList<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> BoatRampList<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

side tangent...

A tip

row <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'a'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'b'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'c'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'d'</SPAN><SPAN class="punctuation token">]</SPAN>

frmt <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN><SPAN class="string token">"{}, "</SPAN><SPAN class="operator token">*</SPAN>len<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN>row<SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># to account for unknown </SPAN>

<SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>frmt<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># snip off the extra comma and space</SPAN>
<SPAN class="number token">1</SPAN><SPAN class="punctuation token">,</SPAN> a<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> b<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> c<SPAN class="punctuation token">,</SPAN> d

<SPAN class="comment token"># alternative 2</SPAN>
<SPAN class="string token">", "</SPAN><SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"{}"</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> row<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>&nbsp; <SPAN class="comment token"># just saves the snip</SPAN>
<SPAN class="string token">'1, a, 3, b, 5, 6, 7, c, d'</SPAN>

<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

I am trying this but getting an error...

ERROR:

Traceback (most recent call last):
File "E:\ArcGISProjects\BoatRampFacilities\PythonScripts\PythonSync\PythonScripts\~6_30days ago.py", line 170, in <module>
for row in cursor:
RuntimeError: Underlying DBMS error [[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near 's'.] [DGIF_TEST.DBO.BoatRampsWGS]

LIST: CALLED "matched"

['Airfield Pond', 'American Legion', 'Anthony Ford #4', 'Aylett', 'Blackwater', 'Blackwater Bridge', "Carey's", "Carter's Wharf", 'Coopers', 'Deep Bottom']

I think I am getting the error because the value has an apostrophe????

Carey's

<SPAN class="comment token">#Set variables for the FC above</SPAN>
var_SITENAME<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE <SPAN class="operator token">=</SPAN> <SPAN class="string token">'SITENAME'</SPAN> <SPAN class="punctuation token">,</SPAN><SPAN class="string token">'WATERBODY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ACCESSAREA'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'BODYOFWATE'</SPAN>
var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION <SPAN class="operator token">=</SPAN> <SPAN class="string token">'TYPE'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'NO_OFRAMPS'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'COUNTY'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'REGION'</SPAN>
var_Lat<SPAN class="punctuation token">,</SPAN>var_Long <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Lat'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'Long'</SPAN>

QueryBoatRamps <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>var_SITENAME<SPAN class="punctuation token">,</SPAN>var_COUNTY<SPAN class="punctuation token">,</SPAN>var_REGION<SPAN class="punctuation token">,</SPAN>var_WATERBODY<SPAN class="punctuation token">,</SPAN>var_BODYOFWATE<SPAN class="punctuation token">,</SPAN>var_ACCESSAREA<SPAN class="punctuation token">,</SPAN>var_TYPE<SPAN class="punctuation token">,</SPAN>var_NO_OFRAMPS<SPAN class="punctuation token">,</SPAN>var_Lat<SPAN class="punctuation token">,</SPAN>var_Long<SPAN class="punctuation token">]</SPAN>

BoatRampList<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># Build a query that will grab the records from the FC where the two SiteName fields are the same from the FC (BoatRampsWGS) and the LIST (myBoatRampList)</SPAN>

<SPAN class="keyword token">for</SPAN> i<SPAN class="punctuation token">,</SPAN> val <SPAN class="keyword token">in</SPAN> enumerate<SPAN class="punctuation token">(</SPAN>matched<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; varQuery <SPAN class="operator token">=</SPAN> val
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> varQuery
&nbsp;&nbsp;&nbsp; RampQry<SPAN class="operator token">=</SPAN><SPAN class="string token">"""SITENAME = '{}'"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token">#print RampQry</SPAN>

&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>myLayer<SPAN class="punctuation token">,</SPAN> QueryBoatRamps<SPAN class="punctuation token">,</SPAN> RampQry<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varBoatRampsList <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoatRampList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>varBoatRampsList<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> BoatRampList‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

jaykapalczynski

I can hard code a sitename and get a return...just don't know how to get it to read the LIST and give me a record for each value in the LIST.

How do I replace my LIST with the variable "varQuery"

varQuery <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Airfield Pond"</SPAN>
RampQry<SPAN class="operator token">=</SPAN><SPAN class="string token">"""SITENAME = '{}'"""</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>varQuery<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">print</SPAN> RampQry

<SPAN class="comment token"># write these records to a new list</SPAN>
BoatRampList<SPAN class="operator token">=</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>myLayer<SPAN class="punctuation token">,</SPAN> QueryBoatRamps<SPAN class="punctuation token">,</SPAN> RampQry<SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; varBoatRampsList <SPAN class="operator token">=</SPAN> str<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'{0},{1},{2},{3},{4},{5},{6},{7},{8},{9}'</SPAN><SPAN class="punctuation token">.</SPAN>format<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BoatRampList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>varBoatRampsList<SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">del</SPAN> cursor
<SPAN class="keyword token">print</SPAN> BoatRampList‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Result:

['Airfield Pond,Sussex,1,Airfield Pond,AIRFIELD POND,AIRFIELD POND,R,1.0,32.90782387,-80.02724715']

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.