Civil Engineering Design functions

Have some feature requests, feedback, cool stuff to share, or want to know where FreeCAD is going? This is the place.
Forum rules
Be nice to others! Read the FreeCAD code of conduct!
User avatar
bernd
Veteran
Posts: 12849
Joined: Sun Sep 08, 2013 8:07 pm
Location: Zürich, Switzerland
Contact:

Re: Civil Engineering Design functions

Post by bernd »

serviteur wrote: Cant you help me how to write X,Y Coordinates from Excel LibreOffice ?
@ bernd
How I cant write Point cloud file from my X,Y Coordinates (above) to Import Point Cloud?
To import a sample point cloud:
- download from the following post the file terrain-points-fc.asc.txt, viewtopic.php?f=13&t=12796&p=103467#p103467
- remove the .txt from the file
- Start FreeCAD -- Change to workbench points
- Menue Points --> import point cloud --> terrain-points-fc.asc
- Menue View --> Standard views --> Axonomoetric
- Menue View --> Standard views --> Fit all

To import your point cloud, the file should have the same format than terrain-points-fc.asc
If you have the points in three columns in LibreOffice (see screen for terrain-points-fc.asc), you can export them from LibreOffice by:

File --> save as --> deactivate automatic file extension (use asc) --> activate filter preference --> put in some file name (mypoints.asc) --> save --> a pop up comes up --> change span separator from comma to space and click ok.
For me the file has the same format than terrain-points-fc.asc


@microelly2:
great new tool, gives more flexibility ...
screen.png
screen.png (123.39 KiB) Viewed 2904 times
User avatar
microelly2
Veteran
Posts: 4688
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Post by microelly2 »

serviteur wrote:
X,Y Coordinates:

Points x y
1 782607.851 409756.495
2 782622.452 409737.725
3 782590.627 409712.374
4 782572.710 409732.011
5 782581.262 409734.580
6 782598.350 409749.528
what do these data mean?
Is there a function to calculate Latitude and Longitude


Another question/idea:
If we have the data in a libre office sheet we can select, copy and past it into a FreeCAD multiline text widget and then process it.
This is more comfortable than the way through a file.
Attachments
bn_999(002).png
bn_999(002).png (44.37 KiB) Viewed 2885 times
User avatar
microelly2
Veteran
Posts: 4688
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Post by microelly2 »

I added a TextEdit widget.
If there are data in it, these data (instead of the file) are processed
Syntax: lat,lon-Values separated by spaces
Attachments
bn_999(003).png
bn_999(003).png (36.43 KiB) Viewed 2867 times
User avatar
microelly2
Veteran
Posts: 4688
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Post by microelly2 »

Once working on the geodata wb I have added a new feature: import gpx-tracks

https://en.wikipedia.org/wiki/GPS_Exchange_Format
I use my Garnim Etrex to record gpx tracks (this is possible with smartphones too)
The new dialog loads the tracks into a FreeCAD document with osm data.

so walking along important lines can generate topological models. post processing these data will be subject of the reconstruction wb.

A short demo of my afternoon trip: https://youtu.be/j-vXr3iZ15Q
Attachments
bn_999(005).png
bn_999(005).png (96.16 KiB) Viewed 2833 times
Jee-Bee
Veteran
Posts: 2566
Joined: Tue Jun 16, 2015 10:32 am
Location: Netherlands

Re: Civil Engineering Design functions

Post by Jee-Bee »

microelly2 wrote:Once working on the geodata wb I have added a new feature: import gpx-tracks
Can this work together with OpenStreetMap?? Would be nice even if i don't have any idea what to do with it ...
microelly2 wrote:I use my Garnim Etrex to record gpx tracks (this is possible with smartphones too)
Garmin eTrax i expect ;)
User avatar
microelly2
Veteran
Posts: 4688
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Post by microelly2 »

Jee-Bee wrote:
microelly2 wrote:Once working on the geodata wb I have added a new feature: import gpx-tracks
Can this work together with OpenStreetMap?? Would be nice even if i don't have any idea what to do with it ...
Yes, the data in the background buildings and the (blue) highways are from osm.
in the top view the ways map to the track,
(in this photo not because the ways are 2D and the track 3D)

What you can do with it:
Buy a farm, load the geodata of the area of your farm into FreeCAD
The run with the gpx tracker through your garden and track your new ways and the silhouettes of your wished buildings.
Load the tracks into FreeCAD.
Design your village on top of the tracks with the arch wb.
... :lol:

microelly2 wrote:I use my Garnim Etrex to record gpx tracks (this is possible with smartphones too)
Garmin eTrax i expect ;)
It's realy etrex
Image
serviteur
Posts: 69
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Post by serviteur »

@ microelly2

serviteur wrote:

X,Y Coordinates:

Points x y
1 782607.851 409756.495
2 782622.452 409737.725
3 782590.627 409712.374
4 782572.710 409732.011
5 782581.262 409734.580
6 782598.350 409749.528



what do these data mean?
Is there a function to calculate Latitude and Longitude
Data is X,Y Coordinates of this Sketch of the terrain (red color) in 2D only

microelly2 wrote:
I use my Garnim Etrex to record gpx tracks (this is possible with smartphones too)
I have T-Mobile Galaxy Note 3, how to to record gpx tracks?


Excuse me for my bad English; I am French
Last edited by serviteur on Thu Apr 09, 2020 2:54 am, edited 1 time in total.
serviteur
Posts: 69
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Post by serviteur »

X,Y Coordinates
Attachments
X,Y_Coordinates_Nsimalen.csv
(155 Bytes) Downloaded 72 times
Capture_openOffice_Excel.png
Capture_openOffice_Excel.png (72.2 KiB) Viewed 2782 times
User avatar
microelly2
Veteran
Posts: 4688
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Post by microelly2 »

hello serviteur

1. I still want to know where your xy coordinates come from.

https://de.wikipedia.org/wiki/Schweizer ... oordinaten ?

how I have to fill the form to find the place of your map: https://tools.retorte.ch/ ?
when I use your data I come to a place neer aalen in germany :o
bn_999(008).png
bn_999(008).png (527.81 KiB) Viewed 2754 times

I assumed that you have wgs 84 coordinates and my script uses these,
if your xy coordinates are already distances in km the script can be simpler but I need to know what the data mean.


2. T-Mobile Galaxy Note 3

I think you have to install a gps tracker app
something like: http://www.locationof.com/phones/samsun ... ote-3-lte/ (I dont know whether this app is good :roll: )
the tracker writes files *.gpx which you can move to your computern and import with my script.
serviteur
Posts: 69
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Post by serviteur »

@ microelly2
hello serviteur

1. I still want to know where your xy coordinates come from.

My xy coordinates come from Yaounde, Cameroon (central Africa)

if your xy coordinates are already distances in km the script can be simpler but I need to know what the data mean.
Data give xy coordinates of skech terrain.
Post Reply