arcgis server, SQL server and smce

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

arcgis server, SQL server and smce

SantiagoPatinoGomez
Hi all,
I have a a couple of questions I have relating to Ilwis Open Source and SMCE :
- My organisation uses ESRI gis software and SQL server database. I have used Smce in the past and I remember having to export shapefiles to then import to ILWIS them to be able to use them as criteria layers. Is this still necessary? Is there a way to have smce read inputs directly from Sql server, or from arcgis server somehow?  I need to determine of we would need to develop a solution for importing data into Ilwis (maybe with arcpy, or  in c# - I understand ilwis is written in c#) ?
- I there a limit to the size of input data for criteria trees? We deal with a rather large area, the State of Queensland, and I need to determine if I'll need a strategy of processing smaller regions.
I want to use smce for natural hazards response and resilience, and I am on the process of developing a proposal to my Managers. There are many aspects to consider, and I wanted to find out about the technical issues with gis and database software, and what would be the best strategy  and whether I will need some extra development to go from arcgis gdb on sql server to ilwis, then the actual smce processing, and then maybe back to esri formats for presentation.
I hope all is well over in NL, best regards,
Reply | Threaded
Open this post in threaded view
|

Re: arcgis server, SQL server and smce

schouwenburg
Yes. From SqlServer you still have to do an export and then an import in shape, we do have a direct connection to a postgres/gis database but not to sql server.

I don't think there is a limit to the size of the criteria trees but I don’t know how practical it is to have them very large. Anyway I am not an expert in the SMCE, my colleague, who programmed it, is back from holidays next week. Maybe you could ask him.

Martin Schouwenburg
[hidden email]

-----Original Message-----
From: Ilwis [mailto:[hidden email]] On Behalf Of SantiagoPatinoGomez
Sent: maandag 10 augustus 2015 23:54
To: [hidden email]
Subject: [Ilwis] arcgis server, SQL server and smce

Hi all,
I have a a couple of questions I have relating to Ilwis Open Source and SMCE
:
- My organisation uses ESRI gis software and SQL server database. I have used Smce in the past and I remember having to export shapefiles to then import to ILWIS them to be able to use them as criteria layers. Is this still necessary? Is there a way to have smce read inputs directly from Sql server, or from arcgis server somehow?  I need to determine of we would need to develop a solution for importing data into Ilwis (maybe with arcpy, or in c# - I understand ilwis is written in c#) ?
- I there a limit to the size of input data for criteria trees? We deal with a rather large area, the State of Queensland, and I need to determine if I'll need a strategy of processing smaller regions.
I want to use smce for natural hazards response and resilience, and I am on the process of developing a proposal to my Managers. There are many aspects to consider, and I wanted to find out about the technical issues with gis and database software, and what would be the best strategy  and whether I will need some extra development to go from arcgis gdb on sql server to ilwis, then the actual smce processing, and then maybe back to esri formats for presentation.
I hope all is well over in NL, best regards,




--
View this message in context: http://ilwis.forum.52north.org/arcgis-server-SQL-server-and-smce-tp4025816.html
Sent from the 52° North - ILWIS Community Forum mailing list archive at Nabble.com.
_______________________________________________
Ilwis mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/ilwis
http://ilwis.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
_______________________________________________
Ilwis mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/ilwis
http://ilwis.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
Reply | Threaded
Open this post in threaded view
|

Re: arcgis server, SQL server and smce

SantiagoPatinoGomez
Thank you.
I suppose i can do exports from sql server to postgis easily i hope...? I will investigate with arcgis and python.

I kind of like the idea of postgres but the organisation has already sql server and arcgis and arcpy and which are pretty good too especially for mapping and web mapping 
I think i will run an smce for an area and evaluate performance. 

Thank you



Sent from my iPhone

On 12 Aug 2015, at 8:53 pm, schouwenburg [via 52° North - ILWIS Community Forum] <[hidden email]> wrote:

Yes. From SqlServer you still have to do an export and then an import in shape, we do have a direct connection to a postgres/gis database but not to sql server.

I don't think there is a limit to the size of the criteria trees but I don’t know how practical it is to have them very large. Anyway I am not an expert in the SMCE, my colleague, who programmed it, is back from holidays next week. Maybe you could ask him.

Martin Schouwenburg
[hidden email]

-----Original Message-----
From: Ilwis [mailto:[hidden email]] On Behalf Of SantiagoPatinoGomez
Sent: maandag 10 augustus 2015 23:54
To: [hidden email]
Subject: [Ilwis] arcgis server, SQL server and smce

Hi all,
I have a a couple of questions I have relating to Ilwis Open Source and SMCE
:
- My organisation uses ESRI gis software and SQL server database. I have used Smce in the past and I remember having to export shapefiles to then import to ILWIS them to be able to use them as criteria layers. Is this still necessary? Is there a way to have smce read inputs directly from Sql server, or from arcgis server somehow?  I need to determine of we would need to develop a solution for importing data into Ilwis (maybe with arcpy, or in c# - I understand ilwis is written in c#) ?
- I there a limit to the size of input data for criteria trees? We deal with a rather large area, the State of Queensland, and I need to determine if I'll need a strategy of processing smaller regions.
I want to use smce for natural hazards response and resilience, and I am on the process of developing a proposal to my Managers. There are many aspects to consider, and I wanted to find out about the technical issues with gis and database software, and what would be the best strategy  and whether I will need some extra development to go from arcgis gdb on sql server to ilwis, then the actual smce processing, and then maybe back to esri formats for presentation.
I hope all is well over in NL, best regards,




--
View this message in context: http://ilwis.forum.52north.org/arcgis-server-SQL-server-and-smce-tp4025816.html
Sent from the 52° North - ILWIS Community Forum mailing list archive at Nabble.com.
_______________________________________________
Ilwis mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/ilwis
http://ilwis.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines
_______________________________________________
Ilwis mailing list
[hidden email]
http://list.52north.org/mailman/listinfo/ilwis
http://ilwis.forum.52north.org
Please respect our mailing list guidelines:
http://52north.org/resources/mailing-lists-and-forums/guidelines


If you reply to this email, your message will be added to the discussion below:
http://ilwis.forum.52north.org/arcgis-server-SQL-server-and-smce-tp4025816p4025817.html
To unsubscribe from arcgis server, SQL server and smce, click here.
NAML


Unless stated otherwise, this email, together with any attachments, is intended for the named recipient(s) only and may contain privileged and confidential information. If received in error, you are asked to inform the sender as quickly as possible and delete this email and any copies of this from your computer system network.

If not an intended recipient of this email, you must not copy, distribute or take any action(s) that relies on it; any form of disclosure, modification, distribution and/or publication of this email is also prohibited.
 
Unless stated otherwise, this email represents only the views of the sender and not the views of Queensland Reconstruction Authority.