|
POST
|
Thanks for the tips. I actually determined the person who held this position before renamed the database I'm trying to connect to, which is a no-no. This is explains why I can connect to all the other databases but I can't connect to the server for just this one... The database I'm trying to connect to is a test database which is a copy of a production database we have. When they made a copy of the production database and "restored" it to create the new test database in SQL Management Studio, they renamed it to indicate it was the test database. We are on a 2012 server box with MSSQL 2014 but I am very much still learning all about this ArcGIS Server/SDE stuff so I'll have a look at the links you provided. Thanks!
... View more
09-27-2017
11:02 AM
|
0
|
0
|
3427
|
|
POST
|
I answered my own question as to why this is happening only to one of our database tables. The database I'm trying to connect to is a testing database - it's a copy of our production database. This means, the person working with this data (before I came into this position) made a copy of the production database, and then "restored" the new copy where they renamed it to something to indicate it was the test database during the restoration process. You cannot rename geodatabases and have them work in ArcGIS as per documentation here: Methods to move a geodatabase in SQL Server—Help | ArcGIS Desktop I determined this problem by looking in SQL Management Studio at the test database's "SDE_table_registry" table, where I found the "database_name" field contains the original name of the copied database and not the name of the test database that the table is held in. So for example, if I copy MyDatabase and rename it to MyDatabaseTest, the SDE_table_registry table will still contain "MyDatabase" in the "database_name" field.
... View more
09-27-2017
10:58 AM
|
2
|
2
|
3427
|
|
POST
|
I have an authorized license of ArcServer running that doesn't expire until 2018. I am attempting to make a database connection in ArcMap and I get this: Thing is, I was able to make database connections from ArcMap about a month ago no problem, and I haven't touched the Server to upgrade or authorize or do any of that kind of thing at all over the past month. This also is only happening when I try to connect to one specific database on our SQL Server, the other ones connect no problem. When I insert the current keycodes file, the operation fails and gives me this error: I don't understand why it will not connect to this database. Anybody have any ideas? Using Desktop 10.5, ArcGIS Server 10.4.1, and somehow our SDE geodatabases (the ones I can connect to) are 10.3.1 when I look at "Upgrade status" in the database properties dialogue box.
... View more
09-27-2017
08:08 AM
|
0
|
8
|
4177
|
|
POST
|
I take it I could create the GP tool in python. I guess I would need to figure out how to strip the fields from the polygon geometry of the shapefile and then populate with new fields that match what will be in the final ArcSDE database, so it would need to happen before importing it into the database. So really, I'd need to create two tools probably; one to strip the fields and then one to import it.
... View more
09-22-2017
04:58 AM
|
0
|
0
|
1253
|
|
POST
|
0down votefavorite So I will be creating a web application in .NET. It will have an MVC structure. It's a data entry application where someone will be inputting a bunch of a stuff from a datasheet and we'll suck it into some database tables that are part of an ArcSDE database. Some of this data will be "manufactured" with conditional statements based on what they input into the form, and here is where geoprocessing comes into play. The user will input a piece of information into the form and if it is of a certain value, we will pull spatial data from the database and do some geoprocessing. It'd just be a buffer and an intersect, pretty simple stuff to do using arcpy...but I need to integrate this into .NET somehow. Can you do geoprocessing inside of .NET? Do you have to call out to a python script? I've read a bunch of stuff on ArcObjects SDK for .NET seems to be all about creating add-ins for desktop applications and that's not what I want to do at all. We're not creating add-ins, we're not creating a end-user web mapping application. I just want to be able to do some geoprocessing in the background, return a value based on the result, and save it to a database table. If this is possible, what version of .NET Framework/Core is compatible with ArcObjects SDK for .NET?
... View more
09-22-2017
04:44 AM
|
0
|
1
|
1126
|
|
POST
|
So, I'm using the Create Random Points tool to create random points along roadways. These points should be 500 meters apart. I set the tool this way, yet I still wind up with points that are much closer than 500m from each other. All of my roads are merged into ONE row of the attribute table, as in all the lines are one feature, they are not separate lines with separate records, therefore, the tool should not be acting as if they are separate (thus allowing points to wind up within the minimum distance specified). Even if I trace the roadway with the measure tool (which shouldn't be how the tool works anyways as the distance is linear), there are many points that are well within the 500m from each other. I don't understand why the tool is doing this. Is there a way to fix it? I was wondering if the tool calculates the minimum distance away from the last point it placed, rather than from all points it has placed, thus making it 500 meters from the last point it put down even though it could be right next to a point it put down two iterations ago? That would render the tool useless, so I doubt that's how it works, but that's all I can come up with to explain why this is happening. Attached a picture to show how close it is placing points.. Attribute table of roadways:
... View more
09-15-2017
09:46 AM
|
0
|
1
|
1184
|
|
POST
|
I have very little experience with .NET (C#) and I'm wondering if it's possible to allow a user to upload their shapefile and then the back-end would save it to our ArcSDE database. We don't need to display their shapefile or do anything with mapping procedures, we literally just need them to upload their file and have it save to our database with all the geometry information (so I could open it up in ArcGIS for Desktop for instance). How would you go about doing something like that? All we would need is the geometry, we would want to ignore anything the user may have put in the shapefile's attribute table. We'd populate the ArcSDE geodatabase with their shapefile geometry and their answers to the fields in the web application. To be clear, here is a scenario: User has a polygon shapefile that represent buildings. The attribute table contains an attribute on whether it's residential or commercial property. There is a field in the web application in which they can attach and upload their shapefile. There are also fields where the user is asked the square footage of the building and it's street address. The end product would be an ArcSDE geodatabase containing the polygon geometry and only attributes of square footage and street address.
... View more
09-13-2017
09:23 AM
|
0
|
2
|
1383
|
|
POST
|
I have very little experience with .NET (C#) and I'm wondering if it's possible to allow a user to upload their shapefile and then the back-end would save it to our ArcSDE database. We don't need to display their shapefile or do anything with mapping procedures, we literally just need them to upload their file and have it save to our database with all the geometry information (so I could open it up in ArcGIS for Desktop for instance). How would you go about doing something like that? All we would need is the geometry, we would want to ignore anything the user may have put in the shapefile's attribute table. We'd populate the ArcSDE geodatabase with their shapefile geometry and their answers to the fields in the web application. To be clear, here is a scenario: User has a polygon shapefile that represent buildings. The attribute table contains an attribute on whether it's residential or commercial property. There is a field in the web application in which they can attach and upload their shapefile. There are also fields where the user is asked the square footage of the building and it's street address. The end product would be an ArcSDE geodatabase containing the polygon geometry and only attributes of square footage and street address.
... View more
09-13-2017
09:20 AM
|
1
|
1
|
1929
|
|
POST
|
Thanks, I figured that out recently We also fixed the most recent issue concerning the mime error. It had to do with our editing software; needed to switch to Dreamweaver because for some reason it didn't appreciate that I was editing on my local file in Notepad++
... View more
07-07-2017
04:31 AM
|
0
|
0
|
1547
|
|
POST
|
I'm trying to update a web app we have and when I change the query.where statement to acquire more states, I get a mime type error in the development tool consoles of multiple browsers. This is the current query.where statement and it renders the map just fine: query.where = "STATE_ABBR = 'GA' OR STATE_ABBR = 'IA' OR STATE_ABBR = 'KY'" I'd like to add more states to the where statement like so: query.where = "STATE_ABBR = 'GA' OR STATE_ABBR = 'IA' OR STATE_ABBR = 'KY' OR STATE_ABBR = 'MO'"
Unforunately, when I change this in notepad ++, save the new html file, and refresh in the browser to the see the results, I get this error in the development tool console: "Refused to execute script from <myURLhere> because its MIME type (text/plain) is not executable, and strict MIME type checking is enabled." I'm very unclear as to why the current map renders fine, but if I change the query it breaks. I don't know what MIME types are or how to fix such an issue. Insight would be appreciated.
... View more
07-06-2017
08:45 AM
|
0
|
2
|
1856
|
|
POST
|
Sadly, that does not work. Thanks for the help though. I don't actually think it's a query problem anymore... I've reviewed the error I get in the inspector on the webpage and I get "Refused to execute script from 'https://myURLhere.org/" because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled." I have no idea what this error means or if it's even something I can fix. The <script> tags should mean that it's read as javascript (i've also specified type=text/javascript just in case). I don't get why it can read the JS for the current webmap fine but if I change something in the query it can't read the JS for the webmap anymore. I'm editing the HTML doc in notepad++ and then refreshing the browser after I've saved it to view changes.
... View more
07-06-2017
08:23 AM
|
0
|
0
|
1992
|
|
POST
|
Sadly, that does not work. Thanks for the help though. I don't actually think it's a query problem anymore... I've reviewed the error I get in the inspector on the webpage and I get "Refused to execute script from 'https://myURLhere.org/" because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled." I have no idea what this error means or if it's even something I can fix. The <script> tags should mean that it's read as javascript (i've also specified type=text/javascript just in case). I don't get why it can read the JS for the current webmap fine but if I change something in the query it can't read the JS for the webmap anymore. I'm editing the HTML doc in notepad++ and then refreshing the browser after I've saved it to view changes.
... View more
07-06-2017
08:20 AM
|
0
|
0
|
1992
|
|
POST
|
**EDIT** I no longer think this a query issue. I have viewed the error in the browser's developer tools and get this: "Refused to execute script from 'https://myURLhere.org' because its MIME type ('text/plain') is not executable, and strict MIME type checking is enabled. I have no idea what this error means or if it's even something I can fix. The <script> tags should mean that it's read as javascript (i've also specified type=text/javascript just in case). I don't get why it can read the JS for the current webmap fine but if I change something in the query it can't read the JS for the webmap anymore. I'm editing the HTML doc in notepad++ and then refreshing the browser after I've saved it to view changes. ----- I'm taking over a project for a colleague who left for another position, but know very little about ArcGIS API for Javascript. He's already made a map, and it seems to work just fine how he's written it, but whenever I try to add state abbreviations to the query, it's breaks the map and nothing shows up but the base map. I have a feeling it has to do with how the query is written, but it's strange because I don't get how it's showing anything at all if the query is the problem. Currently the query looks like this: query.where = "STATE_ABBR = 'GA' OR STATE_ABBR = 'IA' OR STATE_ABBR = 'KY'..." It goes on like that for a while with more state abbreviations listed. I've seen the query.where statement help page where it says to use this type of quotation format: "STATE_ABBR = ' "GA" ' " OR STATE_ABBR = ' " IA " ' " etc. but all that breaks the map and makes the state abbreviations into non-strings which is the opposite of what I'd want. I've also tried putting the definition of queryTask before the definition of query and the where clause based on the help pages but it doesn't work. This is how the whole query is set up and executed (please note, the where clause and queryTask.execute are never encased in function executeQueryTask() which I've also tried to no avail): var query = new Query(); query.where = "STATE_ABBR = 'GA' OR STATE_ABBR = 'IA' OR STATE_ABBR = 'KY' OR STATE_ABBR = 'MO' OR STATE_ABBR = 'TX' OR STATE_ABBR = 'VA' OR STATE_ABBR = 'NE' OR STATE_ABBR = 'OK' OR STATE_ABBR = 'OH' OR STATE_ABBR = 'AR' OR STATE_ABBR = 'DE' OR STATE_ABBR = 'NJ' OR STATE_ABBR = 'SC' OR STATE_ABBR = 'MS' OR STATE_ABBR = 'TN'"; query.returnGeometry = true; query.outFields = ["STATE_NAME", "STATE_ABBR"]; var queryTask = new QueryTask("https://fakeurl/rest/services/BaseLayers/USAStatesGeneralized/MapServer/0"); queryTask.execute(query, showResults);
... View more
07-06-2017
06:49 AM
|
0
|
4
|
2987
|
|
POST
|
We've tried it on 10.4 and 10.5. I'll have to figure out where to find the SDE info, is there an easy way to check that? Sorry for the noob question.
... View more
06-19-2017
12:52 PM
|
0
|
0
|
7068
|
|
POST
|
While I have yet to try my credentials on another machine, I only really need one type of authentication to work and we know the username/password combinations for specific databases does work on other machines. I think it has to be a network problem with my specific computer (which is why we went through the re-registration of my machine to make sure IT wasn't blocking it and double-checked that it's getting through the firewall). We even turned the firewall off altogether to see if that would fix it, but it didn't. We use our windows authentication to get into the SSMS, but then made additional logins for access to databases in a specific manner (read only, read & write, etc.) - so if I want to connect to a database in a read-only manner, I could use the specific login info with database authentication to access it on our server (this is my limited understanding anyway). I might try creating a new login, but I mostly don't want to mess with too much right now as I'm brand new to this job and don't have a good grasp on how they've got this thing setup... don't want to break anything
... View more
06-19-2017
12:50 PM
|
0
|
0
|
7068
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 06-18-2020 10:31 AM | |
| 2 | 09-16-2025 02:17 PM | |
| 3 | 09-12-2025 09:26 AM | |
| 1 | 08-16-2023 05:11 PM | |
| 1 | 02-27-2024 06:48 AM |
| Online Status |
Offline
|
| Date Last Visited |
09-16-2025
02:16 PM
|