to_char - tarih formatı

CREATE OR REPLACE FUNCTION planbesbin.fn_bmk()
RETURNS trigger AS
$$
BEGIN

SELECT ('BMK=' || TO_CHAR(s.bsmtarih, 'DD.MM.YYYY') || '/' || s.bsmsayi )
INTO NEW.bmk

FROM
planbesbin.mnip_sinir s
,
planbesbin.mnip_cizgi c



WHERE
st_intersects (ST_StartPoint(NEW.poly), s.poly)
AND ST_Disjoint (ST_EndPoint(NEW.poly), s.poly)

AND NEW.mnip_kod = 80101 AND NEW.detay1= '1'

;
RETURN NEW;
END;
$$
LANGUAGE 'plpgsql';

----------------------


CREATE TRIGGER tg_bmk_BEFORE
BEFORE INSERT OR UPDATE ON planbesbin.mnip_cizgi
FOR EACH ROW EXECUTE PROCEDURE planbesbin.fn_bmk();


CREATE TRIGGER tg_bmk_AFTER
AFTER INSERT OR UPDATE ON planbesbin.mnip_cizgi
FOR EACH ROW EXECUTE PROCEDURE planbesbin.fn_bmk();

TRIGGER - bmk

CREATE OR REPLACE FUNCTION planbesbin.fn_bmk()
RETURNS trigger AS
$$
BEGIN

SELECT ('BMK=' || s.bsmtarih ||'/'|| s.bsmsayi)
INTO NEW.bmk

FROM
planbesbin.mnip_sinir s
,
planbesbin.mnip_cizgi c



WHERE
st_intersects (ST_StartPoint(NEW.poly), s.poly)
AND ST_Disjoint (ST_EndPoint(NEW.poly), s.poly)

AND NEW.mnip_kod = 80101 AND NEW.detay1= '1'

;
RETURN NEW;
END;
$$
LANGUAGE 'plpgsql';

----------------------


CREATE TRIGGER tg_bmk_BEFORE
BEFORE INSERT OR UPDATE ON planbesbin.mnip_cizgi
FOR EACH ROW EXECUTE PROCEDURE planbesbin.fn_bmk();


CREATE TRIGGER tg_bmk_AFTER
AFTER INSERT OR UPDATE ON planbesbin.mnip_cizgi
FOR EACH ROW EXECUTE PROCEDURE planbesbin.fn_bmk();

Piton scripting

http://darrylmcleod.com/wp-content/uploads/2016/06/Python-Scripting-for-ArcGIS.pdf

Oracle giriş

http://yukselveysel.blogspot.com.tr/p/oracle-11g-r2-database-olusturmaknetca.html

buffer, offset, reverse, yol kalınlık

create table planbesbin.mnip_yol_kalinlik as
select
objectid, fonksiyon, fonksiyon_tip, mnip_kod, abs(cizgikalinligi) as cizgikalinligi,
st_buffer
(
(
ST_OffsetCurve
(ST_Reverse(poly),
abs(cizgikalinligi)/2) --offset miktarı abs(cizgikalinligi)/2)
),
(abs(cizgikalinligi)/2), -- buffer miktarı
'endcap=flat join=round'
),
ST_Length (poly) as uzunluk
FROM planbesbin.mnip_cizgi
where
cizgikalinligi is not null
and ST_Length (poly) > 0
and pasif is null
;

st_buffer, abs(absolute value),

-- DROP TABLE planbesbin.mnip_cizgi_alan;
create table planbesbin.mnip_cizgi_alan
as
SELECT objectid, fonksiyon, fonksiyon_tip, st_buffer(poly, abs(cizgikalinligi), 'endcap=flat join=round') as poly, mnip_kod, cizgikalinligi,
ada_cizgikalinligi, enerjinakil_gerilim, mania_yukseklik, tunel_genislik,
yayayolu_genislik, bmk, pasif, detay1, islem, detay2
FROM planbesbin.mnip_cizgi
where cizgikalinligi is not null
;

alan tipini değiştir

ALTER TABLE planlama.uip ALTER COLUMN objectid TYPE integer USING (objectid::integer);
ALTER TABLE public.uygulama ALTER COLUMN ncgeomvali TYPE integer USING (ncgeomvali::integer);
ALTER TABLE public.uygulama ALTER COLUMN alan TYPE integer USING (alan::integer);

createCenterlines

http://www.ian-ko.com/ET_GeoWizards/UserGuide/createCenterlines.htm

spatial trigger

kaynak:
http://gis.stackexchange.com/questions/49252/postgis-trigger-doesnt-work

---------------------------------------------
CREATE OR REPLACE FUNCTION fn_ilceadi()
RETURNS trigger AS
$$
BEGIN

SELECT i."ADI"
INTO NEW.ilce
FROM admin."KBBSILCE" i
WHERE ST_Intersects(st_centroid(NEW.poly), i.poly);

RETURN NEW;
END;
$$
LANGUAGE 'plpgsql';


---------------------------------------------

CREATE TRIGGER tg_ilceadi
BEFORE INSERT OR UPDATE ON planbesbin.mnip_alan
FOR EACH ROW EXECUTE PROCEDURE fn_ilceadi();

spatial trigger

CREATE OR REPLACE FUNCTION fn_ilceadi()
RETURNS trigger AS
$$
BEGIN

SELECT i."ADI"
INTO NEW.ilce
FROM admin."KBBSILCE" i
WHERE ST_Intersects(st_centroid(NEW.poly), i.poly);

RETURN NEW;
END;
$$
LANGUAGE 'plpgsql';

----------------------


CREATE TRIGGER tg_ilceadi
BEFORE INSERT OR UPDATE ON planbesbin.mnip_alan
FOR EACH ROW EXECUTE PROCEDURE fn_ilceadi();

ST_SymDifference

http://postgis.net/docs/ST_SymDifference.html

st_difference

http://postgis.net/docs/ST_Difference.html

ST_Force_2D(poly)

select ST_Force_2D(poly) from admin.bmk_union_point

st_makeline

create table admin.line as
SELECT
grup_id,
ST_MakeLine(poly) AS poly
FROM admin.bmk_point
where grup_id is not null
GROUP BY grup_id
;

alan hesapla, st_area

select a.alan, round(st_area((poly::geometry))::numeric,3) from planbesbin.mnip_alan a


update planbesbin.mnip_alan a
set alan = (st_area((poly)))

hem geometrik hem de ortak kolonlu 3 tablo sorgu

SELECT
distinct (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE"), count (*), sum(st_area(p.poly))
FROM
planbesbin.mnip_alan p, admin."KBBSILCE" i, planbesbin.mnip_kod k
WHERE
st_intersects(st_centroid(p.poly), i.poly)
and k.mnip_kod = p.mnip_kod
group by (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE")
order by (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE")

centroidi içine düşen poligonun bilgisini aldırma, st_centroid, geom

update planbesbin.mnip_alan p
set mahalle = m."ADI"
from admin."KBBSMAHALLE" m
where st_intersects(st_centroid(p.poly), m.poly)

netcad indirme

http://portal.netcad.com.tr/display/HELP/Indirilebilir+Dosyalar?from=JoFuBg

st_intersects, count, sum_area

SELECT
distinct (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE"), count (*), sum(st_area(p.poly))
FROM
planbesbin.mnip_alan p, admin."KBBSILCE" i, planbesbin.mnip_kod k
WHERE
st_intersects(p.poly, i.poly)
and k.mnip_kod = p.mnip_kod
group by (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE")
order by (i."ADI", p.mnip_kod, k."TABLENAME", k."DOMAINNAME", k."VALUE")

srid set eder, dönüşüm uygulamaz

ALTER TABLE planbesbin."MNIP_BOGAZICI_SINIRLARI"  ALTER COLUMN "POLY" TYPE geometry(polygon, 5256) USING ST_SetSRID("POLY",5256);

bir tablodaki farklı geometri tiplerini listeler

SELECT (ST_GeometryType("POLY")), COUNT("POLY") FROM planbesbin."MNIP_ADA_KENARI" 

GROUP BY st_geometrytype

CREATE EXTENSION postgis;

http://gis.stackexchange.com/questions/21182/how-to-create-a-new-postgis-database-for-usage-with-qgis-under-windows


CREATE EXTENSION postgis;

You must copy the latest ST_GEOMETRY and dependent libraries to the PostgreSQL software location

Problem:
Create Enterprise Geodatabase Error

https://geonet.esri.com/thread/56840

SOLUTION:
Place the ST_Geometry libraries in the PostgreSQL lib directory

Geodatabase creation in PostgreSQL relies on the presence of the ST_Geometry library. You must place the appropriate library in the lib directory where PostgreSQL is installed before you can create a geodatabase. ST_Geometry libraries can be found in the DatabaseSupport folder of your ArcGIS client installation.

Since this tutorial assumes your PostgreSQL installation is on a Windows server, you will use the ST_Geometry library found in the Windows64 folder.
Steps:

In Windows Explorer, navigate to the location of the Windows ST_Geometry library in your ArcGIS client installation directory.

The default location for ArcGIS for Desktop on 64-bit Windows operating systems is C:\Program Files (x86)\ArcGIS\Desktop\DatabaseSupport\PostgreSQL\Windows64; on 32-bit Windows operating systems, it is C:\Program Files\ArcGIS\Desktop\DatabaseSupport\PostgreSQL\Windows64.
Copy st_geometry.dll from this location.
Navigate to the PostgreSQL lib directory on the database server and paste the library to that location.

On Windows, the default location is C:\Program Files\PostgreSQL\9.0\lib.

Bir Klasörün İçeriğini Bir Metin Dosyası Listesi Biçiminde Oluşturma

C:\müzikler>dir/s> liste.txt

Artık Yeni Şeyler Söyleme Zamanı

Netcad, Netcad TILE, Postgresql, PostGIS, Arcgis Server 10,

Parcel Editor

soldaki 2 karakteri calculate eder

left( [Name], 2)

mahalledeki en uzun yolu bulma

Teaching Hydrology

http://serc.carleton.edu/dev/geoinformatics/index.html

				Geoinformatics Modules for Teaching Hydrology Hydrology education involves teaching the description, explanation, and prediction of the occurrence, distribution and movement ...
				View on serc.carleton.edu	Preview by Yahoo

 

download archydro

http://downloads.esri.com/archydro/archydro/

Hydrologic analysis sample applications

http://webhelp.esri.com/arcgisdesktop/9.3/index.cfm?TopicName=Hydrologic%20analysis%20sample%20applications

Index: Data Models

data models

		40585 - Data Models Software:
		View on support.esri.com	Preview by Yahoo

 

kayseri de taşıt sayısı değişimi

ArcGIS for Desktop Free Trial

http://www.esri.com/software/arcgis/arcgis-for-desktop/free-trial

Free 60-day Trial Registration

THE GEOGRAPHY OF TRANSPORT SYSTEMS

http://people.hofstra.edu/geotrans/index.html

"Plateia" Prota ile Türkiye'de!

http://civil3dsayfam.blogspot.com/2012/11/plateia-prota-ile-turkiyede.html

Autodesk'in en büyük yazılım partnerlerinden CGS plus tarafından geliştirilmekte olan Plateia, şehir içi yollardan otoyollara kadar her tip yolun tasarım ve iyileştirme projeleri için geliştirilmiş olan ve Civil 3D platformunda çalışan profesyonel bir yol tasarımı yazılımıdır.

civil3d

http://civil3dsayfam.blogspot.com/

Autopath


yol modelleme vs.

Netcad verisi Düzenleme

Netcad den citysurfe macera (kanal)

ncz verisi netcad spatiale aktarıldı.

veriyi shp olarak kaydedicez.

VERİMİZ ITRF .

ed50 ye donusturmek için geomediayı kullanıcaz.

koordinat dönüşümü.

çalışma alanının geoworkspace in koordinat sistemini ed50 yaptık.

vektörel veriyi shp olarak dışarı yazdığımızda veri ed50 ye dönüşmüş olacak.

verinin kontrolünü yapalım.

projeksiyon tamam.

veride hangi tabakaların yer aldığını görücez.

AYNI SONUCU İKİ FARKLI PROGRAMDA ELDE ETTİK.

veriyi veri tabanına atalım.

MAPBUiLDER

verinin tamamı veri tabanına gitti.

mapbuilder in oluşturduğu indeksi sildik. yenisini yapıcaz.

cbno lazım.

CBNO ALDIRMA İŞLEMİ yapılıyor.

citysurfe tabloyu ekleme.

citysurf te sakla uygula sonrası değişiklikler etkin olacak.

Netcad den Citysurfe Macera (Baca)

NetCAD verisini geomedia da düzenleyip,
oracle spatiale atıcaz. citysurfte göstericez.


veri ITRF te.

dwg yi geomediada ed50 koordinat sisteminde görüntüledik.


DAİRE ŞEKLİNDE OBJELERİN MERKEZİNİ BULDUK.


shp olarak yazdık.

veri tabanına atıcaz.


mapbuilder index oluşturuyor. ancak biz yenisini oluşturucaz.