Grasshopper & GIS & Excel Interoperability

Name: Grasshopper & GIS & Excel Interoperability
Rating: 5.0 (1 reviews)

Rhino 7 downloadable course files

Created byWassef Dabboussi

Last updated 1/2023

English

English [Auto],

What you'll learn

Understand how to organize CAD files received from other consultants
Learn how to automatically add new layers in Rhino with a click of a button
Learn how to assign several geometries into new individual layers automatically with a click of a button
Extracting Areas from specific layers and integrating them into ExcelUnderstand the smart interoperability process between Grasshopper <> Excel <> GIS
Understand the smart interoperability process between Grasshopper <> Excel <> GIS

Course content

1 section • 14 lectures • 2h 57m total length

1- Installation8:54
Install and configure Grasshopper with GIS and Excel interoperability plugins for Rhino, including gps shp master and pi shp-1.2.12, and set up QGIS or ArcGIS for shapefile export.
2- Examples of Cadastral Maps3:58
3- Important Geometry Check9:59
Ensure clean, non-overlapping geometry when exporting from Rhino and Grasshopper to shapefiles, converting splines to polylines, and organizing layers by category for reliable GIS workflows.
4- Convert Splines to Polylines3:12
5- Organizing CAD Layers - Part 12:35
Organize CAD layers by creating individual layers for each plot boundary or road element, named by GIS attributes including plot IDs, and assign each item to its own layer.
6- Organizing CAD Layers - Part 234:27
Organize CAD layers in Rhino with Grasshopper by splitting geometries into road, buildings, and points, auto-creating per-element layers, and assigning geometries via attributes for quick shapefile export.
7- Exercise 114:10
Create separate layers for buildings and locations, copy the existing geometry layer, and separate buildings by single and double polylines. Then apply the same approach to locations in ten minutes.
8- Exercise 1 Solution14:40
Learn to organize geometry in Grasshopper by creating per-element layers for single and double polylines, using partitioning, grafting, and attribute creation to bake and name layers automatically.
9- Roads SHP Export33:14
Export road geometries from Grasshopper to shapefiles, assign a road id field, and join them with a large Excel dataset in a GIS like QGIS using a CSV as reference.
10- Spline Curve Test14:59
11- Plots SHP Export13:52
Export plots as shapefiles from Grasshopper for GIS by choosing polylines or polygons, joining Excel data via plot_id, and exporting to a dedicated shapefile folder with the correct CRS.
12- Buildings SHP Export10:02
Export building polygons from Grasshopper by converting double polylines to surfaces, extracting outer and inner edges, and joining with csv data to produce a filled polygon shapefile.
13- Exercise 27:05
Follow the same steps to export location points as shape files, copying prior scripts, and specify shape file name, IDs, and geometry type (polylines, polygons, or points).
14- Exercise 2 Solution6:35
Export point shapefiles and prepare location_id fields, then join the csv and excel data in QGIS to create a merged layer and GIS package including locations, buildings, plots, and roads.

Requirements

A basic knowledge in Grasshopper and GIS software (ArcGIS or QGIS) is recommended, in order to quickly understand the relationships between the components
It's not necessary to be advanced in GIS, a basic knowledge about how GIS layers work, and understanding the difference between Polygons / Polyline / Points is sufficient

Description

Are you interested in gaining Parametric competency to push your GIS tasks to the next level?

Are you ready to learn a very exciting and powerful tool that will make GIS exporting between CAD to GIS Software more controlled and easy to update?

This course will provide you with the necessary knowledge and ability to use select plugins within Grasshopper, that would make the interoperability process between CAD <> Excel <> GIS a more simplified and easy workflow.

Course content in details:

- A quick Introduction about cadastral plans

- Learn about important Geometry check and best practice check list

Understand how to organize the CAD layers into proper layers with several smart parametric methods:

- Learn how to automatically add new layers in Rhino with a click of a button
- Learn how to assign several geometries into new individual layers automatically with a click of a button
- Extracting Areas from specific layers and integrating them into Excel
- Understand the smart interoperability process between Grasshopper <> Excel <> GIS
We will apply the concept with several examples: Roads, Plots, Buildings and Locations, understanding the difference between Polylines, Polygons and Points in GIS.
- 2 Exercises involving the preparation of data inside of Grasshopper, exporting a SHP file and adding data from Excel will give you the opportunity to test your skills learned.

Whether you are an architect, urban planner, engineer, landscape architect, or a student of these fields, this course will be a great addition to your toolbox and will push your design abilities to a whole new level.

Alright, if you want to learn how to use this amazing parametric platform, get on board and let’s get started!

We will be using QGIS as a free open-source GIS software from qgis(.)org

Please make sure to install the following free plugins for Grasshopper from food4rhino(.)com:

GhShp

LunchBox

Human

Elefront

A detailed step-by-step installation guide of the important plugins is provided, as well as the installation files.

Who this course is for:

Disciplines including but not limited to: Architects, urban planners, engineers, landscape architects, or students from these fields