Subscribe to this thread
Home - General / All posts - Topology Overlays, options
dale

594 post(s)
#21-Jun-22 23:42

I'm working my way through the Topology Overlays bit of the manual and have just watched the video referenced Find Percentages of Open Space in ZIP Code Areas

The video shows an Options button that is no longer present in the current build. The options button, gave field options (sum, mean, etc) to pre set field conditions when running overlays. I understand the video shows the functions no longer present in the cutting edge builds.

Having searched the manual(s) I'm at a loss as to how to transfer fields mfd8 speak

Dimitri

7,066 post(s)
#22-Jun-22 06:06

That's an old video for a prior version, not the latest transform pane. See the user manual version of that example for how it's done using the latest version of the transform pane.

dale

594 post(s)
#22-Jun-22 07:03

Thanks, that is perfect.

I'm really enjoying working my way through the examples.

lionel

987 post(s)
#24-Jun-22 18:08

the video show also that

- user can easely convert a SELECT ( viewing mode) into a CREATE table easely by addin in SQL a line INTO <tablename> !! in this case result tab is use !

-that manifold return "Cannot add record, rejected by index 'Name_x'." if table name inside INTO is alreday here in the project pane !! in this case log tab is use !

-that for select null content in cell we use IS NULL

at Computed Fields (manifold.net)

GeomAreaGeo([Geom], 6378137.01, 0.08181919084262149, 0) 

Returns the geodetic area of an area object in square meters. Returns NULL for lines and points. I think only some projection give exact result ( conserve area)

Attachments:
createTABLE_usingINTO.png
SQL_select-to-Create.map


Book about Science , cosmological model , Interstellar travels

Boyle surface fr ,en

lionel

987 post(s)
#24-Jun-22 18:29

why the documentation say for return value for GeomArea <value> ?

- Does value mean all the column type like Floatx ( x=32,64 no float8 and no float16 !??) , INTy (y= 8,16,32,64) ?

- Can this <value> be store in a nvarchar column implicitly without use function CAST( )?

- What mean tolerance ( which unit? which range /scale ? ) if not set to zero ?

I ask this because when use C# code for extract text value from html page ; the convertion beetween " 23 45" ( all is node base in html ) to "2345" or 2345 is not easy and need code because API don't know howto interpret space !!

Attachments:
geomArea_Definition.png


Book about Science , cosmological model , Interstellar travels

Boyle surface fr ,en

adamw


10,126 post(s)
#25-Jun-22 07:55

GeomArea returns a FLOAT64 value. Nearly all functions that return a number use FLOAT64 as the return type.

Conversions from FLOAT64 to another numeric types are implicit, they do not have to be written explicitly. Conversions to non-numeric types, such as NVARCHAR, require writing a CAST.

The tolerance parameter is used when the area contains self-intersections or other irregularities -- then the area gets normalized first.

lionel

987 post(s)
#22-Jul-22 01:39

What is the type and value of <tolérance> paraméter ?

Type Boolean ?

Values : 1 or 0 ?

Thanks


Book about Science , cosmological model , Interstellar travels

Boyle surface fr ,en

adamw


10,126 post(s)
#22-Jul-22 07:40

Tolerance is a number, the units are the same as the XY of the geometry values to which the tolerance is applied. It's a distance limit. Locations closer than the tolerance are considered to be the same.

Manifold User Community Use Agreement Copyright (C) 2007-2021 Manifold Software Limited. All rights reserved.