topic Re: Shapefile joind with database... how do I manage it online? in ArcGIS Online Questions

Shapefile joind with database... how do I manage it online?

DuccioNotari — Fri, 01 Jun 2012 09:14:35 GMT

Hi everyboby!
I'm pretty new to web applications so maybe my question is easy, maybe impossible:
I have a single linear shapefile with it's symbology that derives from a joined database (very simple... value "yes"-red color value "no"- blue color)
is it possible to put it online?
I only managed to put online the shapefile alone, with no connection to the database.
I could put the DB in a clouding service to have it online, but how I connect it with the shape?

I need the shape to depend from the database, and I would like to have the results shown on the internet...
is it possible with arcgis Online or do I need to buy (!) and study Arcgis Server?
(I have arcInfo 10 and the publisher extension..if needed)
thanks!
M2

Re: Shapefile joind with database... how do I manage it online?

EricDaniel — Tue, 05 Jun 2012 20:46:21 GMT

Hi everyboby!
I'm pretty new to web applications so maybe my question is easy, maybe impossible:
I have a single linear shapefile with it's symbology that derives from a joined database (very simple... value "yes"-red color value "no"- blue color)
is it possible to put it online?
I only managed to put online the shapefile alone, with no connection to the database.
I could put the DB in a clouding service to have it online, but how I connect it with the shape?

I need the shape to depend from the database, and I would like to have the results shown on the internet...
is it possible with arcgis Online or do I need to buy (!) and study Arcgis Server?
(I have arcInfo 10 and the publisher extension..if needed)
thanks!
M2

I'm pretty sure you would need ArcGIS server to connect to geodatabase as you describe. I definitely think Esri needs to add this functionality to ArcGIS online or they will continue to lose people that can't afford an ArcGIS server license. This is actually a pretty heavy request on the http://ideas.arcgis.com/ site but is broken up into several different ideas that are asking for a similar functionality to this.

Re: Shapefile joind with database... how do I manage it online?

DuccioNotari — Wed, 06 Jun 2012 06:50:51 GMT

oh... 😞
so I'd probably need a non-esri solution...
I'll start searching, but normally I'd prefer to work on the same family of softwares!
Thanks wilbev!
M2

Re: Shapefile joind with database... how do I manage it online?

MikeMinami — Wed, 06 Jun 2012 17:02:53 GMT

If your goal is simply to symbolize features based on the yes/no field attribute, you can do this by symbolizing the shapefile inside the web map. If you need a set of related attributes of the shapefile features, you would need to add these directly to the shapefile as fields. This method would only support 1 to 1 relationships, really, unless you added multiple fields for multiple relationships.

Hope this helps,

Mike

Re: Shapefile joind with database... how do I manage it online?

DuccioNotari — Thu, 07 Jun 2012 07:08:55 GMT

Thanks Mike for the answer!
the problem is that I am trying to set up a "non professionist" package for a friend... the idea is that I create a project with arcmap that referr to a database, than he can edit the database and automatically get the changes in the map (he can see and print the map in arcreader). this works... locally.
it would be nice to show it online, but a shape is editable via access (or a similar program) only if it is inside a database and arcgis online doesn't like databases.
if the shape is outside the database (but connected to the editable fields of the DB) can be uploaded... but without the DB's informations!
doing it with arcmap would be easy, but I want my friend to do it alone (I'm not getting paid... and I can't work for him every time he needs it!)
now I want to try to export a csv file from the db... maybe it works!
I don't even know any other online map hosting services!
M2

Re: Shapefile joind with database... how do I manage it online?

MikeMinami — Thu, 07 Jun 2012 15:22:52 GMT

If you put all the attributes in the shapefile, the map viewer does allow editing of the features and attributes. So, it is possible that your friend can learn arcgis.com, they may be able to accomplish what they need on their own.

Thanks,

Mike

Re: Shapefile joind with database... how do I manage it online?

DuccioNotari — Thu, 07 Jun 2012 16:46:24 GMT

But I've already prepeared all the masks and the reports and the queries!!!
I know... I'm never satisfied!

I've tried to use csv files, but of course it works for point... not polylines!
Thanks Mike!
M2