Latest Contributions by KimberlyGarbade

At first glance not sure you need the "," after line 10, since line 11 is commented out.   ... View more

Can you fill us in on what an optimal version of your envisioned application would be? I.E. does it only update the data once a day in a stand alone database at midnight and that is all it needs to do, or is that what it does now, but optimally it would be better if a user on a smart phone could trigger the update from the field?  When the data is updated do you want apps across the enterprise to be able to see it real time, or is it just used for one purpose and is fine on an isolated stand-alone computer? Stuff like that... ... View more

@JayCary Thank you for getting back to me.  The status information you requested is below: Can you please advise how I can set them to "Resolved" from this point? Is there a workflow document you could point me to online that would walk me through using the Error Inspector to Resolve errors? ... View more

I don't want to waste your time. So if you think I'm off base please ignore at will (and even I'm a little iffy on this), but.... Maybe the Union and Intersect tools are honoring setting in your input features (parcels and historic districts) related to X,Y Tolerance and X,Y Resolution and those are creating polygons so small that they are discarded by the tools, but the Select by Location tool is seeing an overlap.  Quick way to test this is to compare the vertices of the 37 Broad St parcel to the historic district parcel's vertices in that area.  If they are identical and the projection is indeed the same it might just be a bug.  You could try a different "Relationship" in your Select Layer by Location function... maybe "Intersect (DBMS)", but why that would matter I'm not sure.   ... View more

When you use the Create Enterprise Geodatabase tool it will give you the option to either have a user named SDE own the SDE schema, or have dbo own the SDE schema.    A note here is that you should set up a user other than SDE to actually own data (I.E. Feature Classes, tables, etc.). ... View more

If you run a select query on the states table in SSMS or Toad, is there only a single record referring to state 0?   ... View more

When you ran a check on your model in model builder did it tell/show you were the model is broken? ... View more

In most cases the questions give you keywords describing the analysis tools to use.  Look for words that describe actions and search the ArcGIS Pro help or Google using those (add "Esri" or "ArcGIS" to your search or you'll just get a definition for the word "label").  The instruction to remove original and interim files refers to the fact that when you are using geoprocessing tools they use inputs files (feature classes, shapefiles, csv, whatever the tool takes) and they either create new output files, or alter the original file.  I think what the questioner is asking is that you only leave the asked for files (the files that are the answers to the questions) in the final file geodatabase. Another hint is that its more common to select a subset from a set to create a new set than it is to select existing features and deleted them.  Deleting has its place for sure, but think about the effect of deleting counties from the Counties feature class if you weren't doing it to a copy of the original data. ... View more

You could try  https://pro.arcgis.com/en/pro-app/2.8/tool-reference/cartography/set-control-point-at-intersect.htm If the problem is that the boundaries do not match and one will "Show around" the other, you could do a bunch of things.  Using topology to edit the boundaries so they are shared would be a good one.  Drastic solutions would include editing COPIES of one or the other or both files. If you want to convert your admin polygons to lines and edit them by deleting the island boundary parts I would probably use Union and Polygon to Line and then edit at will, but you'll lose your polygon topology in favor of a good looking map..    ... View more

MB_ is the reference (name) assigned to the records returned by the query encased in parenthesis directly preceding it.  You can think of it as a variable that can be referenced (It is referenced before it is "set" when the code says "Select MB_.GDB_ARCHIVE_OID From"). In this case you are selecting the GDB_ARCHIVE_OID field from the result set of the query: (SELECT GDB_ARCHIVE_OID, ROW_NUMBER() OVER (PARTITION BY OBJECTID ORDER BY gdb_from_date DESC) rn, gdb_is_delete FROM Buildings WHERE (gdb_branch_id = 0 AND gdb_from_date <= '12.31.9999 23:59:59.000')) Partition is to complicated to go into here, but its used to perform calculations on subsets.  Here's a link:https://www.sqlshack.com/sql-partition-by-clause-overview/ DESC just tells the query (subquery in this case) to order the returned records in descending order "rn" and 'gdb_is_delete" are fields returned by the query being referenced by MB_ Looks like this query is getting all existing (non-deleted) buildings from a FC base table name "Buildings" in the Default version (gdb_branch_id = 0); and its using three select statements to do it... To me its some pretty heady stuff, but might point me to the answer to a question I have, which is how to I pull a reference to just my existing features from a branch versioned (BV) database.  Sort of an "versioned view" for BV...  Can you share where you found the SQL code?   ... View more

So many things it could be.... do you mind if I ask you a bunch of questions (some depend on you having SQL Server Management Studio).  Forgive me if some of them seem silly. 1) What version of SDE was used to create your database (below is an image of a query that will tell you) and what version of Esri client (either ArcMap or ArcGIS Pro) are you using? 2) Is the data you are editing registered as versioned?  3) Did you add the windows authorized account your using to the database using SQL server tools or Esri's "Create Database User" tool....both?  4) Is your windows authorized login a member of your SQL Server instance's sysadmin fixed server role?  5) If you look at the database tables in SQL Server does dbo own the SDE schema (the tables will say "SDE_" in the name)? It seems like your windows authorized login has the permissions required by SQL Server to create records in the database (I.E. add features, create versions), but your Esri client doesn't know how to handle them, almost like your are editing the table directly in SQL Server and not through an Esri desktop product. ... View more

How far outside the historic district is the parcel that gets selected?  ... View more

I stole this from this link about 2/3 of the way down https://www.esri.com/about/newsroom/arcuser/prolabel/#:~:text=In%20the%20Label%20Class%20pane%2C%20change%20Line%20spacing,line%20spacing%20of%20-2%20for%20all%20map%20labels. "On the ribbon, click the expander button in the Text Symbol group. The Label Class pane opens. On the Symbol tab, click the Formatting button. On the map, you can see that some of the labels are stacking, and that’s a good thing. However, their stacking could be tighter. The default space between lines of text is designed for paragraphs, not for maps. Text on a map almost always benefits from condensed line spacing because this makes it more obvious which label goes with which point. In the Label Class pane, change Line spacing to -2. This property is also known as leading. I usually use a default line spacing of -2 for all map labels. For larger fonts, you may want to decrease the leading even more" ... View more