10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
We have thousands of Video files and we need to prepare a table with few of it's parameters/values from their Mediainfo output. Here I have 3 sample mediainfo output text files named Vid1, Vid2 & Vid3 so on... (such we have thousands) and each file has exactly 3 lines.
$ ls... (6 Replies)
Discussion started by: prvnrk
6 Replies
2. Shell Programming and Scripting
Hi All,
I get ~1000 files everyday and the current unix script process one file at a time... like it unzips the file, loads into table . This process will repeat how many ever files were present in the directory. I was wondering can we process multiple files (like unzipping and loading X amount... (1 Reply)
Discussion started by: rajasony
1 Replies
3. Shell Programming and Scripting
multiple files to load into different tables,
I have a script show below, but this script loads data from txt file into a table,
but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder ,
can we load these files in diff tables (table 1, table2... (1 Reply)
Discussion started by: nani1984
1 Replies
4. Shell Programming and Scripting
multiple files to load into different tables,
I have a script show below, but this script loads data from txt file into a table,
but i have multiple input files(xyzload.txt,xyz1load.txt,xyz2load.txt......) in the unix folder ,
can we load these files in diff tables (table 1, table2... (0 Replies)
Discussion started by: nani1984
0 Replies
5. Shell Programming and Scripting
Hey gyuz,
I wanna calculate the number of mapped reads of a bam file in a region of interest. I used this code to do so :
samtools view input.bam chrname:region1 > region1.txt
This will store all the reads from given bam file within the region of interest in region1.txt
Now I have... (5 Replies)
Discussion started by: @man
5 Replies
6. UNIX for Dummies Questions & Answers
Hi,
I was just wondering how can i load a files from a log file in unix into a table. e.i.
a.log contains the ff:
text.dmp
text2.dmp
Table contains the ff:
col 1 filename
col 2 date created
Thank You! (1 Reply)
Discussion started by: lienyca
1 Replies
7. Shell Programming and Scripting
Hi everyone!!
I have a database table, which has file_name as one of its fields.
Example:
File_ID File_Name Directory Size
0001 UNO_1232 /apps/opt 234
0002 UNO_1234 /apps/opt 788
0003 UNO_1235 /apps/opt 897
0004 UNO_1236 /apps/opt 568
I have to... (3 Replies)
Discussion started by: ss3944
3 Replies
8. Shell Programming and Scripting
Hi All,
I need to load records from oracle table XYZ to a flat file say ABC.dat.
could any one tell me how do i do this in UNXI,
Regards
Ann (1 Reply)
Discussion started by: Haque123
1 Replies
9. Shell Programming and Scripting
Hi all,
How to load variable value into Oracle table? I have created a file validation shell script. After the validation completes, i need to update a Oracle table with the variable value...
Can someone help me how to do it? I have searched, but not able to get answer.
i have 4... (1 Reply)
Discussion started by: Amit.Sagpariya
1 Replies
10. Shell Programming and Scripting
Hi ,
Can you guys please help as I have list of files xaa, xab, xac.........xza for eg in which to perform load the 1st (xaa) and insert into table, then only proceed for the 2nd , 3rd and so forth.
In other words, before 1st one finished, 2nd one shall not load and insert to table, and so... (0 Replies)
Discussion started by: rauphelhunter
0 Replies
shp2pgsql(1) PostGIS shp2pgsql(1)
NAME
shp2pgsql - shapefile to postgis loader
SYNTAX
shp2pgsql [options] shapefile [schema.]table
DESCRIPTION
The shp2pgsql data loader converts ESRI Shape files into SQL suitable for insertion into a PostGIS/PostgreSQL database.
Version: 1.1.5 (2006/10/06)
USAGE
The <shapefile> is the name of the shape file, without any extension information. For example, 'roads' would be the name of the shapefile
comprising the 'roads.shp', 'roads.shx', and 'roads.dbf' files.
The <tablename> is the (optionally schema-qualified) name of the database table you want the data stored in in the database. Within that
table, the geometry will be placed in the 'geo_value' column by default.
OPTIONS
The loader has several operating modes distinguished by command line flags:
(Note that -a, -c, -d and -p are mutually exclusive.)
-d Drops the database table before creating a new table with the data in the Shape file.
-a Appends data from the Shape file into the database table. Note that to use this option to load multiple files, the files must have
the same attributes and same data types.
-c Creates a new table and populates it from the Shape file. This is the default mode.
-p Only produces the table creation SQL code, without adding any actual data. This can be used if you need to completely separate the
table creation and data loading steps.
-D Use the PostgreSQL "dump" format for the output data. This can be combined with -a, -c and -d. It is much faster to load than the
default "insert" SQL format. Use this for very large data sets.
-s <SRID>
Creates and populates the geometry tables with the specified SRID.
-g <geometry_column>
Specify the name of the geometry column (mostly useful in append mode).
-k Keep idendifiers case (column, schema and attributes). Note that attributes in Shapefile are usually all UPPERCASE.
-i Coerce all integers to standard 32-bit integers, do not create 64-bit bigints, even if the DBF header signature appears to warrant
it.
-S Generate simple Geometries instead of MULTIgeometries. Shape files don't differ between LINESTRINGs and MULTILINESTRINGs, so
shp2pgsql generates MULTILINESTRINGs by default. This switch will produce LINESTRINGs instead, but shp2pgsql will fail when it hits
a real MULTILINESTRING. The same works for POLYGONs vs. MULTIPOLYGONs.
-w Output WKT format, for use with older (0.x) versions of PostGIS. Note that this will introduce coordinate drifts and will drop M
values from shapefiles.
-W <encoding>
Specify the character encoding of Shapefile's attributes. If this option is used the output will be encoded in UTF-8.
-I Create a GiST index on the geometry column.
-N <policy>
Specify NULL geometries handling policy (insert,skip,abort).
-? Display version and usage information.
INSTALLATION
To compile the program from source, simply run "make" in the source directory. Then copy the binary in your shell search path (or wherever
you like). This text is also available as a man page in the ../doc/man/ directory, ready for copying it into the manual search path on
unixoid systems.
EXAMPLES
An example session using the loader to create an input file and uploading it might look like this:
# shp2pgsql shaperoads roadstable roadsdb > roads.sql
# psql -d roadsdb -f roads.sql
A conversion and upload can be done all in one step using UNIX pipes:
# shp2pgsql shaperoads roadstable roadsdb | psql -d roadsdb
AUTHORS
Originally written by Jeff Lounsbury <jeffloun@refractions.net>. Improved and maintained by Sandro Santilli <strk@refractions.net>.
Includes small contributions and improvements by others.
This application uses functionality from shapelib 1.2.9 by Frank Warmerdam <warmerda@gdal.velocet.ca> to read from ESRI Shape files.
SEE ALSO
pgsql2shp(1)
More information is available at http://postgis.refractions.net
shp2pgsql(1)