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.
User avatar
bernd
Posts: 3877
Joined: Sun Sep 08, 2013 8:07 pm
Location: Zürich, Switzerland

Re: Civil Engineering Design functions

Postby bernd » Tue May 17, 2016 11:35 am

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 604 times
User avatar
microelly2
Posts: 2363
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Postby microelly2 » Tue May 17, 2016 4:14 pm

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 585 times
User avatar
microelly2
Posts: 2363
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Postby microelly2 » Tue May 17, 2016 6:56 pm

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 567 times
User avatar
microelly2
Posts: 2363
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Postby microelly2 » Wed May 18, 2016 4:51 pm

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 533 times
Jee-Bee
Posts: 617
Joined: Tue Jun 16, 2015 10:32 am
Location: Netherlands

Re: Civil Engineering Design functions

Postby Jee-Bee » Wed May 18, 2016 5:00 pm

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
Posts: 2363
Joined: Tue Nov 12, 2013 4:06 pm
Contact:

Re: Civil Engineering Design functions

Postby microelly2 » Wed May 18, 2016 8:27 pm

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: 29
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Postby serviteur » Thu May 19, 2016 12:40 pm

@ 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
Attachments
PLAN_MASSE_Coordonnées.jpg
PLAN_MASSE_Coordonnées.jpg (847.46 KiB) Viewed 489 times
serviteur
Posts: 29
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Postby serviteur » Thu May 19, 2016 1:03 pm

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

Re: Civil Engineering Design functions

Postby microelly2 » Thu May 19, 2016 6:28 pm

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 454 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: 29
Joined: Thu Nov 13, 2014 5:54 pm

Re: Civil Engineering Design functions

Postby serviteur » Thu May 19, 2016 6:41 pm

@ 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.