Latest Contributions by JacobBoyle

Are you trying to hit the attribute table directly?  You can make life a lot easier on yourself if you use a Versioned View. You can create a view that pulls the data for the system tables that ArcSDE uses to keep track of changes to a view that you can then use.  If you do this, you won't have to compress your data after every edit. http://resources.arcgis.com/en/help/main/10.1/index.html#/Creating_versioned_views_from_ArcGIS_Desktop/006z000000vr000000/ ... View more

Please reply to this opening post to submit questions and comments about the Public Maps Gallery (PMG) template version 1.4. The link you provide to download the software does not work, I get a permissions error. ... View more

OK, I've checked every service I am searching against.  Only 2 fail, this one and another point layer.  Both produce the error until i switch the Field All value to true.  Then everything is right as rain. 😄 Robert, thanks for your help and thanks for writing these great tools! ... View more

Well, the search tool works when I set the Fields All= to true, and for any feature class where I set that to false, the queries do not work.  the workaround I am trying right now is doing the follofing for the field options: <field name="SHAPE" gridfieldonly="true" gridfield="false"/>     <field name="SHAPE.area" gridfieldonly="true" gridfield="false"/>     <field name="SHAPE.len" gridfieldonly="true" gridfield="false"/> This is hiding the fields I do not want to see. ... View more

Robert, I am able to query against the data in the REST Robert i changed the following <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>SRC Land Data</name>    <url>http://pit-arcgis/arcgis/rest/services/Land/PA_Land_Data/MapServer/8</url>    <expressions>     <expression alias="Agreement Number" textsearchlabel="Search Agreement Number:">      <values>       <value prompt="Example: 061853" >AGMT_NUM = '[value]'</value>      </values>     </expression>     <expression alias="Lessor" textsearchlabel="Search Lessor:">      <values>       <value prompt="Example: Bob Smith">upper(LESSOR) = upper('[value]')</value>      </values>     </expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select Land Data</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>AGMT_NUM</titlefield>    <fields all="true"> and that fixed it... ... View more

Robert, I am able to query against the data in the REST ... View more

Yes, the spatial search doesn't work either. We upgraded the server this weekend (10.0--> 10.1), I made sure all the services are pointing to the right sources.  Other layers I search work from the same server. ... View more

It is a text field. ... View more

I'm having the same error, here's a copy of my code.  I'm not sure what exactly is causing the issue. <layer>    <definitionexpression></definitionexpression>    <enableexport>true</enableexport>    <name>SRC Land Data</name>    <url>http://pit-arcgis/arcgis/rest/services/Land/PA_Land_Data/MapServer/10</url>    <expressions>     <expression alias="Agreement Number" textsearchlabel="Search Agreement Number:">      <values>       <value prompt="Example: 061853" >upper(AGMT_NUM) like upper('%[value]%')</value>      </values>     </expression>     <expression alias="Lessor" textsearchlabel="Search Lessor:">      <values>       <value prompt="Example: Bob Smith">upper(LESSOR) = upper('[value]')</value>      </values>     </expression>    </expressions>    <graphicalsearchlabel>Use one of the graphical search tools to select Land Data</graphicalsearchlabel>    <spatialsearchlayer>true</spatialsearchlayer>    <titlefield>AGMT_NUM</titlefield>    <fields all="false">     <field name="AGMT_NUM" alias="Agreement Number" gridfield="true"/>     <field name="LESSOR" alias="Lessor" gridfield="true" />     <field name="LEASE_DATE" gridfield="true" alias="Lease Date" dateformat="MM/DD/YYYY" />     <field name="LEASE_YEAR" gridfield="true" alias="Lease Year" />     <field name="EXPR_DATE" alias="Expiration Date" gridfield="true" dateformat="MM/DD/YYYY" />     <field name="CALC_ACRES" alias="Calculated Acreage" gridfield="true" />     <field name="NET_ACRES" alias="Net Acreage" gridfield="true" />     <field name="GROSS_ACRES" alias="Gross Acreage" gridfield="true" />     <field name="RIGHTSSHORT" alias="Rights Short" gridfield="true" />     <field name="LEASETYPE" alias="Lease Type" gridfield="true" />     <field name="RIGHTSHELD" alias="Rights Held" gridfield="true" />     <field name="LEASESTATUS" alias="Lease Status" gridfield="true" />    </fields>    <links/>    <zoomscale usegeometry="true" zoompercent="2"></zoomscale>   </layer> any light you can shed on my issue, I'd appriciate. ... View more

I can't find a link right now, but I am almost certain I read that Maplex will become a base function at 10.1 at all levels. ... View more

Let me see if I understand this correctly. The SDE user should not be used to do normal GIS tasks like, building map documents and such? Should each GIS user have their own username and password and work from the SDE that way? Thanks Yes, you should not be using SDE as a working account, SDE is meant to be used as administrative account only. You have 2 options, you can inherit user names and passwords from your windows authentication you use in house, or you can setup user names and passwords in the database, both have their benefits and disadvantages. ... View more

How many users do you have connecting as SDE?  In an ideal world, the the number of users that hold the SDE password is quite limited.  The SDE user should not ever own spatial data, and should only be used to administer the ArcSDE installation. Sadly, the scenario where people work from SDE seems to happen a lot more than I personally first thought.  I think there's still a disconnect between IT and GIS still.  I really hope that the changes that are coming in 10.1 will go a long way towards bringing GIS more into the general IT fold. I also think that this is symptom of GISers being jack of all trades. ... View more

you can use the SDEMON command to kill a connection by Process ID (PID).  Remember, case counts! sdemon �??o kill �??t {all | <pid>} [�??D <database_name>] [-s <datasource>] -i <direct_connect_string> �??u <user_name> �??p <password> ... View more

Looking forward to playing with this all on my test box over the holidays, the changes they made to the printing on the server side look great. now if we could only get a simple way to edit related tables. ... View more