Latest Contributions by IanKnight

I often feed my spatial data into SQL Server via batch loads from .CSV files or interactively via an Acess Forms front-end instead of via the ArcGIS client, so the SQL Server connectivity is great for that purpose but yes, I conceed that not being able to insert / update / delete into SQL Server directly via the ArcGIS client is going to be a stopper for some.   ... View more

Hi, If you are currently storing your data in an Access database, I would seriously consider moving that data into MS SQL Server Express, a freely downloadable lightweight version of SQL Server which can be run on a client PC like Access. ArcGIS connects-up to SQL Server Express very easily.  You can still use Access forms and reports to view and update your tables in SQL Server, Express by setting up an ODBC connection between the two.  If you later need to upscale onto a full-blown SQL Server solution for your data, that would then be easier too.  ... View more

Hi everyone, My name is Ian Knight, a B.Sc Geographical Sciences graduate from Bristol, UK who has spent the last 30 years in IT, and has eventually, at the age of 56, discovered the amazing world of GIS after reading about how GIS databases are used by the UK Forestry Commission to manage their woodlands.     I am currently learning to use the ArcGIS Pro product, and it's interface with the Microsoft SQL server database.  I am in the process of mapping-out the distribution of different species of tree within a local conservation area, and studying relationships to influencing factors such as terrain, drainage etc.  As well as being a good personal project to apply my ArcGIS training to, it also is a great opportunity to get outdoors and practice collecting data in the field with a GPS handheld device.   I would ideally love to pick up work in the GIS field, even if on a voluntary basis.  Finally, my favourite place is here:  -2.2213  51.6077 ... View more