Latest Contributions by JoeBorgione

V-  I guess I never thought of add database server in ArcCatalog as a direct connection.  But it makes sense. I'm still scratching my head with the whole management studio direction in the original post; but I've already learned something new today, so... ... View more

Hi Kim,  Thanks for your nice response. I am still struggling with my problem of Add Spatial Database Connection to MS SQL Server 2008 Management Studio. My PC has Microsoft Windows XP Pro that is linked to Microsoft NT4 LAN System.  My MS SQL Server 2008 Management Studio (SQL Server 2008 Express) is installed in my PC. I think that Personal ArcSDE can be done in Windows 7, not in Microsoft Windows XP Pro - Am I right in this guessing? I do not want ArcGIS Server Workgroup in my ArcSDE support for my SQL Server 2008 Express.    Is it possible to make a direct connection to a geodatabase in my MS SQL Server 2008 Management Studio (SQL Server 2008 Express) from my ArcGIS Catalog 10?  If it is possible, please tell me how to make such direct connection.  Please help and respond. Thanks, Scott Chang I've been following this thread from the sidelines and I'm more and more confused as it goes.  Selfishly, I'd like to add to the discussion just to see if I can clarify in my mind what your objective is. First; are you trying to connect to a SQl Server database through ArcSDE or are you trying to connect to a SQL Express database with Personal SDE? Second; Where/when/why does SQL Server Management Studio come into play with respect to ArcGIS?  The only thing I use it for is to actually manage the sql data base; back ups, restores, user permissions, triggers, schemas, etc.  In some cases I'll run an update query or a make table query to create tabular data, but as n interface, ArcMap really shines for that.  Perhaps I'm missing some cool functionality and if so, please enlightn me. Third; is there a specific reason you need to create a direct connection to a SQL Server Express database?  My SQL Server Express/Personal SDE data base is installed on my local machine; as I read through this passage on line, I don't see where a direct connection would be advantageous in the Personal SDE environment.  Now, if your Personal SDE/SQL Server Express database is installed on something other than your local machine, and the server machine does not have the power to run it, then I guess a direct connection might be warranted.  I've always thought that Personal SDE can run just fine on a Personal Computer. Fourth; as I type this, the machine I am using is a windows XP pro machine with Personal SDE and Sql Server Express installed and running without any problems.  In fact I use database replication from a SDE/Oracle parent database to this one, so no operating system issues that I'm aware of. The two esri folks responding to this thread have bailed me out more than once with SDE/SQL issues.  I consider them the de facto go-to forum members for these kinds of issues.  I'm sure we can work through a solution for you. ... View more

Hello, I am trying to work on a project where I need to find population data. One layer has population data of villages (polygon layer of villages, with population in attribute table) Another layer has a threath zone for a particular disaster (again a polygon layer) I have to find the population data of villages, only which comes under the threat zone.. (ie. if a particular threat zone covers part of a village, only part of the population data should be the output & not the entire population) Any suggestions, how I can select only part of population & not just display population of the entire village Regards, Kvijaykar When using population data in polygon form, you have to accept an assumption that the the population is evenly distributed across that polygon.  That may or may not be true, but it's just the nature of the beast. Typically, the approach I have taken in such analyses is to add a field to the population polygon called Original_Area and calculate it to the area field.  Then comes the geoprocessing step;  either clip, intersect etc with the threat polygons.  The resulting population polygon has the NEW area calculated as well as the ORIGINAL_AREA added before the geoprocess step.  Now, add field called ADJUSTED_POPULATION and calc it this way: (original_area / area) * population You'll have a proportioned population.  Again, this works nicely as long as you can live with the evenly distributed population assumption. Hope this helps- ... View more

I almost feel like the chicken farmer in Napolean Dynamite who so famously says " I don't understand a word you just said..." All seriousness aside; perhaps you could do a series of selections to isolate those polygons that have the correct 'decisions' and export them into their own feature class.  Dissolve them as such and then merge the dissolved features back together into one feature class... Hope this helps- ... View more

Hello All - I have a similar issue. I need to geocode from a table that uses a range of addresses for each record: Main | St | Odd | 3901 | 3999 Ideally, I'd like a single point (centroid of street segment with offset for odd/even side) that represents the range. Any thoughts? Thanks M. Quick and dirty:  add the low and high, divide by 2:  your example gets an address of 3950 Main St.  You might have to fiddle around a little to get even and odd, but if all you want is one location.... Hope this helps- ... View more

Doesn't the dissolve tool do that for you? ... View more

So what you're *really* saying is that going out for a tequila ought to be in my vexatious configuration toolkit, eh?  I'll have to jot that one down... - V Absolutely!  I'm thinking of working in a 'celebrate SDE' theme into my Cinco De Mayo bar-b-que.... 😉 ... View more

Kim and Vince; I think I just discovered the situation of my user and my user schema not matching; I just got back here and now my user can import, create, delete feature classes.  The Network Guy fessed up that the domain controller had a little problem yesterday so my permissions weren't being passed through sde to sql; at least that's how he explained it. That's what was driving me nuts; my user had all the right stuff including user mapping as suggested by Vince.  See attached jpg. The data bases that kept tossing the error yesterday are shown as vecc430 and vecc2012; I have succesfully imported two feature classes into vecc2012 as user/schema vecc. If I understand this correctly Kim: "If you have users who only edit data (they don't create data; some other user creates it and they just have rights to edit the data), those users don't have to have matching schemas. "  you mean that my editors do not need a schema consistant with thier user names, correct? I am about to test a few of my user logins for editing. As always, thanks for the insight, advice, and above all, patience! ... View more

Just an additional $00.02:  I make it a practice of scanning my data for and then deleting null geometries through the attribute table; look for the feature size (area or length) value that tips you off. ... View more

V & K- Big kahuna is just my term for the user that has the most rights; I actually use a one word user name, and all my subordinate users are one word as well.. (Sorry, an attempt at humor to hide my overwhelming frustration...) Inititially my default schema was dbo; isn't that the default if you don't specify one?  So I should check the user mapping and make sure it goes to my default schema instead of dbo? Or.... Perhaps either of you can answer another question about schemas:  I created one, owned by my user, that has the dataset permissions shown as 'Data Editor' in the link provided above for my other users.  I set each of them up with this schema as the default; it's called (drum roll) userschema.  Somewhere in my seemingly endless googling it was mentioned that users and their schemas need to have the same name; I think that was sql server 2005 though.  To me that flies in the face of having multiple users having the same default schema, right?  So the question is, should all of my (editor) users have their own personalized schema? (Ugggh; seems like a lot of redundant work and I only have a dozen or so users)...  Or should they just have a public schema and I take care of their permissions in a role like I did in sql server 2000? Thanks- ... View more

Try and see if you can export just a portion of your feature class just to if it shows up.  Also, just for the heck of it, try to create an emtpy feature class and use the data loader to load into it. I wonder if this is related to a known bug:  see this post of mine. My guess is Lance can get you an ftp site. ... View more

You are exporting a feature class to a file geodatabase right?  Not creating a layer file for symbology correct? Just a hunch; are you exporting the feature class to an open ArcCatlog session?  If so, often times you need to refresh the view (F5) and it will appear.  Or you can close that session of ArcCatalog and open a new one.  If that doesn't take care of you problem, maybe create a new geodatabase and try it again. Hope this helps- ... View more

Got to the bottom of it: for whatever reason, the SDE user was granted sysadmin rights in SQL.  Once I cleared that hurdle, I got the post install to work as expected.  Here's another tip:  Melanie W in tech support is awesome when it comes to SDE, Server and SQL Server.  She's helped me in the past and nailed this one in record time! ... View more