# Creating artificial coordinate system to plot garden experiment? [closed]

I am trying to map plant death in a garden experiment. The location of the garden doesn't matter, I just care about each plant in relation to the others. They were all planted on a grid system. My data looks like this:

``````Column Row Plant State
1      1   3333  Alive
1      2   3334  Alive
2      2   3337  Alive
2      3   3338  Alive
3      1   3339  Alive
3      2   3340  Alive
``````

I want each plant to be a point on the grid with the column functioning as the X and the row as the Y coordinates. I'll then use symbology to change the point colors to reflect the state of the plant.

My questions:

1. Is this at all reasonable/feasible to do with GIS?
2. If it is, how do I create an artificial coordinate system that would work for my purposes?
3. If not, what program would you recommend (that would ideally take an .xlxs or .xls file)?

I can use either ArcGIS or QGIS so please give recommendations for which would be easier.

## closed as too broad by PolyGeo♦Jul 3 '16 at 5:06

Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

• Given that "The location of the garden doesn't matter" then, although this could be tackled with a GIS, this does not seem to be a GIS problem. – PolyGeo Jun 15 '16 at 23:34
• You can make an excel file like in the table and then import it in ArcGIS and choose to diplay the points by assuming that the coordinates are the column(x) and row(y) in which you find each plant. So, for example plant 3333's coords will be 1,1. – Nikos Jun 16 '16 at 1:32
• ArcGis or QGIS? QGIS is cheaper... but it depends on what you're trying to do with these records after you've imported them, ArcGis comes with a huge range of well documented tools to interrogate the data, if you need these tools price and ease of use is not the concern. In ArcGis I would make an event layer, in QGIS I would make a virtual dataset from the CSV - search on those terms and decide which is easier. – Michael Stimson Jun 16 '16 at 4:00
• @Barrett has the right answer; I've done this before using total data station data points to create a map of an archaeological site. If at some point you care about the physical location of the garden, you can use rubbersheeting to adjust the locations of your points to make them line up with their actual location – crld Jun 16 '16 at 21:28
• As per the Tour there should be only one question asked per question so, if you need more than the current answers provide, can you edit your question to focus it on the single remaining issue from the tree (two too many) originally asked, please? – PolyGeo Jul 3 '16 at 5:22