POST
|
Well, shorthand and interruptions, my apologies *_id is an auto_increment primary key. So from the rest of your comment, it is not going to work as I don't have any geometry type columns. Additionally, when I dump the mysql to csv with 64-bit integers, ArcGIS seems to read the CSV file just fine and creates all the requisite data points on the map, even thought the lat/long are coming in as varchars. And no, I didn't design the system, I just got tasked with clean up they system. Thanks for the help. I think I understand my problem, but without a complete redesign there doesn't seem to be any way to make things work directly in the current environment.
... View more
10-23-2017
01:21 PM
|
0
|
1
|
516
|
POST
|
Literally.. I have 3 tables.. in which one table has both a lat and a long column create table cdbw ( create table cdbdc ( create table cdbdd ( latitude vchar(48), company_id int ai pk, worker_id int ai pk, longitude vchar(48), company_name varchar (64), worker_last varchar(64), company_id int, .... worker_first varchar(64), worker_id int, ) ; .... .... ); ) ; lat/long are in digital degrees. select a.latitude, a.longitude, b.company_name , c.worker_last, c.worker_first .. <remaining 30 fields from a> from cdbw a inner join cdbdc b on a.company_id = b.company_id inner join cdbdd c on a.worker_id = c.worker_id where b.company_id is not null and c.worker_id is not null In both cases, using mysql_fdw for live updates or static tables in loaded from CSV files, I can connect to postgresql and select against the table. Yet, ArcMap connects, but doesn't see the tables.
... View more
10-23-2017
12:27 PM
|
0
|
3
|
516
|
POST
|
No problem, I'm just prohibited from sharing in an open forum.. so I understand.
... View more
10-23-2017
11:16 AM
|
0
|
5
|
516
|
POST
|
send me an email and I'll share outside of the forum .. mike@thirdrockwater.com
... View more
10-23-2017
10:20 AM
|
0
|
7
|
516
|
POST
|
I've tried it 2 different ways.. Initially, I used the mysql_fdw to make the data available to postgresql from mysql .. and later, I just did an sql query to create a csv file to import into postgresql. In both cases, the arcmap use owned the tables and usage/select on all three tables. In both cases, ArcGIS Desktop did not see any tables in postgresql. Now, the quirk in my environment might be that there are NO enterprise servers anywhere, this is strictly an ArcMap only environment
... View more
10-23-2017
10:04 AM
|
0
|
9
|
1019
|
POST
|
That's essentially what I was doing. I could see all the data needed in standard PostgreSQL tables and query the tables from the command line as the ArcMap user, but when the ArcMap client connected to PostgreSQL, it didn't see the tables and the message in the error log said "Can't connect to geodatabase". So how are you getting it to work ?
... View more
10-23-2017
09:22 AM
|
0
|
11
|
1019
|
POST
|
Based on an answer to another question I asked in a different group, what I'm trying to do is impossible. In order for ArcGIS Desktop (aka ArcMap) to connect to PostgreSQL, I need to create the geospatial database in PostgreSQL, which has to be via ArcGIS Desktop. The kicker is, for it to work you need at least 1 Enterprise level version of ArcGIS. I don't have one and neither does my customer. So replicating 3 tables from MySQL into PostgreSQL to display via ArcMap will never work.
... View more
10-23-2017
06:21 AM
|
0
|
13
|
1019
|
POST
|
Thanks. That also tells me that what I'm trying to do is impossible without at least one enterprise license, which save me a lot of work.
... View more
10-23-2017
06:16 AM
|
0
|
0
|
1273
|
POST
|
Trying to use ArcGIS Desktop ( aka ArcMap advanced) to create the geospatial db in PostgreSQL. Everything goes well until I get down to needing to provided the Authorization file.. everything I see says it should be named arcgis_server.* ... in my install .. there is no such file. So the questions are .. where is it on Win10 and what is it called ?
... View more
10-20-2017
02:38 PM
|
0
|
3
|
2316
|
POST
|
Any pointers to documents talking about such a division? At this point, the data consists of a lat/long pair, plus details on the installation at that location.
... View more
10-20-2017
01:23 PM
|
0
|
0
|
1019
|
POST
|
C:\Users\mhm\AppData\Local\ESRI has DefaultDomain* Desktop 10.5 FontEnginev6 Local Caches rasterproxies but none have ErrorReports and yes, I have unhidden everything. Additionally a search for ErrorReports doesn't find anything Win10 ArcGIS Desktop 10.5
... View more
10-19-2017
03:55 PM
|
0
|
1
|
6743
|
POST
|
Where do the logs get put on Windows 10 for arcGIS Desktop? I'm getting a connection to the database, but suspect that I don't have the right level of permissions in the database
... View more
10-19-2017
03:32 PM
|
1
|
4
|
17396
|
POST
|
At this point, just trying to get a sign off on the last item on the statement of work. Once that is done and we get paid, it will be time to re-engineer the entire solution. Already have a team working on an estimate to see how much code will have to be changed to support PostgreSQL instead of MySQL. Part of the problem is we really don't have any PostgreSQL experts on the team.
... View more
10-19-2017
01:05 PM
|
0
|
0
|
1019
|
POST
|
Ok.. looks like I've messed up on the roles and grants. ArcMap connects (says it is connected) yet doesn't see the postgres native tables I've created. So at this, point ArcMap is not able to see either FDW tables nor local tables. Both can be seen when local to the database. Implication being I've messed up with the postgres roles and grants
... View more
10-19-2017
11:56 AM
|
0
|
0
|
1157
|
POST
|
Not quite. The customer application functions against MySQL and handles everything but mapping. At this point, I'm attempting to use a foreign data wrapper (mysql_fdw) to allow Postgresql to access the data from MySQL. From the command line using psql, I can query all the data via the user that ArcMap is connecting with. ArcMap doesn't see any available tables (maybe ArcMap only looks for geodatabase tables? ), but, at this point, it is looking more and more like I don't have Postgresql setup properly as pgadm doesn't see the tables either. The real noobie question is do I really have a geospatial database. Three tables all interrelated, one of which has a lat/long pair. Interestingly enough, ArcMap is able to digest a CVS file dumped from a view of the three tables. Mike
... View more
10-15-2017
06:57 AM
|
0
|
2
|
1157
|
Title | Kudos | Posted |
---|---|---|
1 | 10-19-2017 03:32 PM |
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:24 AM
|