ağ problemlerinden dolayı oracle veritabanına ulaşmada problem yaşanıyorsa, yapılması gerekenler:
1. veri tabanını durdur : hizmetler > OracleServiceXE
2. Listener i durdur: hizmetler > Oraclexetnslistener
3. Listeneri başlat
4. veri tabanını başlat
listenerin veri tabanından önce başlatılması önemli
|
http://www.techonthenet.com/sql/
http://www.techonthenet.com/sql/like.php http://www.techonthenet.com/sql/delete.php
-------------------
select OBJECTID, YOL_ADI from KAYSERI_BELNET.GEOYOL WHERE YOL_ADI LIKE '%CADDE' OR YOL_ADI LIKE '%SOKAK' OR YOL_ADI LIKE '%BULVAR' OR YOL_ADI LIKE '%KÜME EVLER'
--------------------
http://www.1keydata.com/sql/sql-replace.html
http://www.mydigitallife.info/2007/04/23/how-to-find-and-replace-text-in-mysql-database-using-sql/ ------------- Another example:
SELECT REPLACE('www.mysql.com', 'w', 'Ww');
Above statement will return 'WwWwWw.mysql.com' as result.
------------
select ACIKLAMA, MAHALLE_ADI, MADI, ESKI_YOL_ADI, YOL_ADI from GEOYOL
WHERE MADI = '0' OR ESKI_YOL_ADI LIKE '%SOKAK' OR ESKI_YOL_ADI LIKE '%CADDE' OR ESKI_YOL_ADI LIKE '%BULVAR' OR ESKI_YOL_ADI LIKE '%KÜME EVLER' ----------------
---------------
Description
Changes existing data in a table.
Syntax
UPDATE { table_name | view_name } SET { column_name = expression } [ ,...n ] [ FROM { table_name | view_name } [ ,...n ] ] [ WHERE < search_condition > ]
Example
UPDATE table1 SET c1 = 9
UPDATE EXPORT
SET DENEME = '9' WHERE YOL_ADI = 'KÖSE SK.'
-----------
UPDATE KAYSERI_BELNET.GEOYOL
SET ACIKLAMA = '12345' WHERE MADI = '0' OR ESKI_YOL_ADI LIKE '%SOKAK' OR ESKI_YOL_ADI LIKE '%CADDE' OR ESKI_YOL_ADI LIKE '%BULVAR' OR ESKI_YOL_ADI LIKE '%KÜME EVLER' --------------
select YOL_ADI, OBJECTID, ACIKLAMA from GEOYOL
WHERE YOL_ADI NOT LIKE '%.' AND YOL_ADI NOT LIKE '%KAVŞAK' AND YOL_ADI NOT LIKE '%DÖNEMEÇ' AND YOL_ADI NOT LIKE '%KÜME EVLER' AND YOL_ADI <> 'BAĞLANTI Y. '
------------
UPDATE KAYSERI_BELNET.GEOYOL
SET ACIKLAMA = 'YOL_ADI düzeltilecek' WHERE YOL_ADI NOT LIKE '%.' AND YOL_ADI NOT LIKE '%KAVŞAK' AND YOL_ADI NOT LIKE '%DÖNEMEÇ' AND YOL_ADI NOT LIKE '%KÜME EVLER' AND YOL_ADI <> 'BAĞLANTI Y. ' ------------- select ESKI_YOL_ADI, YOL_ADI, OBJECTID, ACIKLAMA from GEOYOL WHERE ACIKLAMA = 'YOL_ADI düzeltilecek' or ACIKLAMA = 'YOL_ADI düzeltildi' ORDER BY ACIKLAMA
------------------
select * from GEOYOL
WHERE YOL_ADI LIKE ' %' OR ACIKLAMA LIKE ' %' OR ESKI_YOL_ADI LIKE ' %' OR TANITIM_KODU LIKE ' %' OR TASIT_YAYA LIKE ' %'
-----------------
select YOL_ADI, ACIKLAMA from GEOYOL
WHERE ACIKLAMA LIKE 'YOL_ADI%' ORDER BY ACIKLAMA DESC
select MAHALLE_ADI, YOL_ADI, OBJECTID, ACIKLAMA from GEOYOL
WHERE YOL_ADI LIKE '%CADDESİ%' select YOL_ADI, MAHALLE_ADI, OBJECTID, ACIKLAMA from GEOYOL WHERE YOL_ADI NOT LIKE '%.' AND YOL_ADI NOT LIKE '%KAVŞAK' AND YOL_ADI NOT LIKE '%DÖNEMEÇ' AND YOL_ADI NOT LIKE '%KÜME EVLER' AND YOL_ADI NOT LIKE '%MEYDANI' AND YOL_ADI NOT LIKE '%MEYDANI' AND YOL_ADI NOT LIKE '%ALT GEÇİT'
-----------------
select YOL_ADI, YOL_TPI from KAYSERI_BELNET.GEOYOL
WHERE YOL_ADI LIKE '% CD.'
UPDATE KAYSERI_BELNET.GEOYOL
SET YOL_TPI = 'CD.' WHERE YOL_ADI LIKE '% CD.'
---------------
select YOL_TPI, YOL_ADI from KAYSERI_BELNET.GEOYOL
WHERE YOL_TPI <> 'KÜME EVLER'
AND YOL_TPI <> 'BULV.' AND YOL_TPI <> 'CD.' AND YOL_TPI <> 'SK.' AND YOL_TPI <> 'MEYDAN' AND YOL_TPI <> '1' AND YOL_TPI <> '1000' AND YOL_TPI <> '500' AND YOL_TPI <> '700' AND YOL_TPI <> '800' AND YOL_TPI <> '900'
ORDER BY YOL_TPI
|
GEOSERVER_HOME C:\Program Files\GeoServer 2.0.0sistem değişkenlerinin eklenmiş olduğundan emin ol, kurulum sırasında eklenmeyen varsa sen ekle.
GEOSERVER_DATA_DIR C:\Program Files\GeoServer 2.0.0\data_dir
JAVA_HOME D:\Program Files\Java\jdk1.6.0_13
tablolar birleştirilirken veri alma işleminin hata oluşturmaması için objectID kolonu değerlerinin çakışmaması gerekir. birinin bittiği değerden diğerinin devam etmesi için excel de hazırlanan objectID değerleri Access e kopyala yapıştır yöntemi ile eklenir.
FeatureVerticesToPoints mah t:\SIL\MAH_NOKTA.SHP ALL
polygon ve polyline için.
| arcGISte çizdikten sonra netcade veriyi atıp, bağlantı yöneticisinde akıllandırdığımızda objectID kolonunu ekleyip, içini dolduruyor. aynı veriyi arcgise atıp güncellemeler yaptığımızda objectıd kolonunu silmeden netcade tekrar aktardığımızda problem oluyor. objectıd si dolu olmayan verileri netcade aktarmamış oluyor. |
http://webhelp.esri.com/arcgisdesktop/9.1/pdf/Geoprocessing_Quick_Guide.pdf SpatialJoin <target_features> <join_features> <out_feature_class> {JOIN_ONE_TO_ONE JOIN_ONE_TO_MANY} {KEEP_ALL KEEP_COMMON} {field_mapping} {INTERSECTS IS_WITHIN CONTAINS} {search_radius}
TableToDBASE <input_tables;input_tables...> <output_folder>
Ungenerate: Creates a text file of xy coordinates from a coverage. Ungenerate <in_cover> <out_generate_file> <LINE POINT POLY TIC LINK REGION.subclass ANNO.subclass> {NODES NO_NODES} {EXPONENTIAL FIXED}
CollapseDualLineToCenterline <in_cover> <out_cover> <maximum_width> {minimum_width} mahalle sınırlarından ilçe sınırı üretmek için kullanılır: Dissolve <in_cover> <out_cover> <dissolve_item> {POLY LINE NET REGION.subclass} SpatialJoin <target_features> <join_features> <out_feature_class> {JOIN_ONE_TO_ONE
Eliminate: Merges selected polygons with neighboring polygons that have the largest shared border between them or the largest area. Eliminate <in_cover> <out_cover> <info_express;info_express...> {NO_KEEP_EDGE KEEP_EDGE} {POLY LINE} {selection_file} {BORDER AREA} Simplify Line or Polygon: Removes small fluctuations or extraneous bends from a line or polygon, while preserving its essential shape. SimplifyLineOrPolygon <in_cover> <out_cover> <simplification_tolerance> {POINT_REMOVE BEND_SIMPLIFY} {NO_ERROR_CHECK ERROR_CHECK}
Transform <in_cover> <out_cover> {AFFINE PROJECTIVE SIMILARITY}
AddXY <in_cover> {POINT NODE}
Renode <in_cover> {from_item} {to_item}
Create <out_cover> {template_cover}
CreateFishnet <out_feature_class> <origin_coord> <y_axis_coord> <cell_width> <cell_height> <number_rows> <number_columns> {corner_coord} {LABELS NO_LABELS} {template}
AddXY <in_features> geometri yi kontrol eder: Check Geometry: Checks the validity of the geometries of features. CheckGeometry <in_features;in_features...> <out_table> • The Output table will have one record for each problem found. If no problems are found, the Output table will have no records. • The Output table has the following fields: • CLASS—The full path to and name of the feature class in which the problem was found. • FEATURE_ID—The Feature ID (FID) or Object ID (OID) for the feature with the geometry problem. • PROBLEM—A short description of the problem. • The PROBLEM field will contain one of the following: Short segment, Null geometry, Incorrect ring • For multipoint features, only the null geometry and empty part problems apply. • For point features, only the null geometry problem applies.
CopyFeatures <in_features> <out_feature_class> {configuration_keyword} {spatial_grid_1} {spatial_grid_2} {spatial_grid_3}
DeleteFeatures <in_features>
Feature to Point: Creates a point feature class based on an input polygon, line, or multipoint feature class. FeatureToPoint <in_features> <out_feature_class> {CENTROID INSIDE} • If the Input Features are polygons, the Centroid option will result in points which are at the center of gravity for that polygon. This may NOT actually be inside the polygon's area. To insure that the point created is inside the polygon's area, use the Inside option. • If the Input Features are lines and the Centroid option is used the output points will be coincident with the center of the feature's envelope (rectangular window that contain a specific feature). If the Inside option is used, the point on the line closest to the center of the feature's envelope will be used. • If the Input Features are multipoint and the Centroid option is used the output points will be coincident with the center of the feature's envelope (rectangular window that contain a specific feature). If the Inside option is used, the point (part of the multipoint) closest to the center of the feature's envelope will be used.
Feature Vertices to Points: Creates a point feature class from the vertex locations of the input features. FeatureVerticesToPoints <in_features> <out_feature_class>
MultipartToSinglepart <in_features> <out_feature_class> yolları kırmak için: SplitLine <in_features> <out_feature_class> Select Layer by Attribute: Creates, updates, or removes the selection on a layer or table view using an attribute query. SelectLayerByAttribute <in_layer_or_view> {NEW_SELECTION ADD_TO_SELECTION REMOVE_FROM_SELECTION SUBSET_SELECTION SWITCH_SELECTION CLEAR_SELECTION} {where_clause} • The input must be a feature layer or a table view. It cannot be a feature class or table. • This tool is not limited to working in ArcMap; it works on layers and table views in ArcCatalog and in scripts. The Make Feature Layer tool makes a layer for a feature class, and the Make Table View tool does the equivalent for a table. • If an extent or a definition query is present on the input layer or table view, only those features or rows that match the extent and/or definition query will be available to be selected. Select Layer by Location: Creates, updates, orv removes a selection on the input layer based on spatial relationships to select features. SelectLayerByLocation <in_layer> {INTERSECT WITHIN_A_DISTANCE COMPLETELY_CONTAINS COMPLETELY_WITHIN HAVE_THEIR_CENTER_IN SHARE_A_LINE_SEGMENT_WITH BOUNDARY_TOUCHES ARE_IDENTICAL_TO CROSSED_BY_THE_OUTLINE_OF CONTAINS CONTAINED_BY} {select_ • The input must be a feature layer or a table view. It cannot be a feature class or table. • This tool is not limited to working in ArcMap; it works on layers and table views in ArcCatalog and in scripts. The Make Feature Layer tool makes a layer for a feature class, and the Make Table View tool does the equivalent for a table. • If an extent or a definition query is present on the input layer or table view, only those features or rows that match the extent and/or definition query will be available to be selected. çevreleyenden bilgi al selectLayerByAttribute: mah_ıd si 100 olan mahalle seçilir, SelectLayerByLocation : seçili mahalle içindeki yollar seçilir (have their center in) CalculateField: yol un mahalle ID si 100 yazdırılır. alan hesaplaması: CalculateAreas <input_feature_class> <output_feature_class> • This tool is useful in determining a weight for intrazonal interaction. • The field F_AREA is created in the output feature class to store calculated Area values. If a field of this projeksiyon oluşturma: CreateSpatialReference {spatial_reference} {spatial_reference_template} {xy_domain} {z_domain} {m_domain} {template;template...} {expand_ratio} • Setting the Spatial Reference sets the coordinate system, spatial domains, and precision. The spatial domains and precision of the output spatial reference can be further modified using XY Domain, Z Domain, M Domain, Template XYDomains, and Grow XYDomain By Percentage. • Template XYDomains does not have to be in the same coordinate system as that specified in Spatial Reference or Spatial Reference Template. If they are different, the extents will be projected to match. Project:v Changes the coordinate system of your Input Dataset or Feature Class to a new Output Dataset or Feature Class with the newly defined coordinate system, including the datum and spheroid. Project <in_dataset> <out_dataset> <out_coordinate_system> {transform_method; • All input feature classes and/or feature layers are valid inputs to this tool. • If you have a feature class that does not have a defined projection and PRJ file, then use the DefineProject tool first. Project Raster: Transforms a raster dataset from one projection to another. rasterdan bir bölümü kesip almak için: Clip <in_raster> <rectangle> <out_raster> {in_template_raster} • The Clip tool allows you to extract a portion of a raster dataset based on a rectangular extent. • The minimum and maximum x and y extents allow you to define the clip extents for your output raster dataset. • The extent values must be in the same spatial coordinates and units as the raster dataset. Copy Raster: Converts a raster to a BMP, GIF, GRID, IMG, JPEG, JPEG2000, PNG, TIFF, or a geodatabase raster dataset, and can be used to load raster datasets into a raster catalog. CopyRaster <in_raster> <out_raster_dataset> {configuration_keyword} {background_value} {nodata_value} {NONE ONEBITTO8BIT} {NONE COLORMAPTORGB} {1_BIT 2_BIT 4_BIT 8_BIT_UNSIGNED 8_BIT_SIGNED 16_BIT_UNSIGNED 16_BIT_SIGNED 32_BIT_UNSIGNED 32_BIT_SIGNED 32_BIT_FLOAT 64_BIT} Copy Rows: Writes the rows from an input table, table view, feature class or feature layer to a new table.
CentralFeature <input_feature_class> <output_feature_class> <EUCLIDEAN DISTANCE MANHATTAN DISTANCE> {weight_field}{self_potential_weight_field}
ulaşım ile ilgili: • A Closest Facility layer can be made on a network currently added to the ArcMap table of contents or you can browse to a network dataset on disk. • Hierarchy options can only be set if the input analysis network has a hierarchy attribute. MakeODCostMatrixLayer <in_network_dataset> <out_network_analysis_layer> • An OD Cost Matrix layer can be made on a network currently added to the ArcMap Table of Contents or on a network dataset on disk. • Hierarchy options can only be set if the input analysis network has a hierarchy attribute. Make Route Layer: Makes a route network analysis layer and sets its navigation properties. • The Route layer can be made on a network currently added to the ArcMap Table of Contents or on a network dataset on disk. • Hierarchy options can only be set if the input analysis network has a hierarchy attribute. |
Bu hatayı verdikten sonra doldurması gereken kolonun tamamını doldurmuyor. ama veriler parça parça seçilerek doldurulmak istendiğinde aynı uyarı mesajını verse de seçilen verilerin ilgili kolonunu dolduruyor.
veriye ait tablodaki bilgiler etiket olarak yazdırıldığında, pan yapılması halinde yazılar ekranda uygun bir konumda gösterilmeye devam etmiyor. sabit olarak tek noktada kalıyor. arcGIS'ta ise etiketler ekranı takip ediyor.
