Result for E3C6E3F8A70FDC64FA0610193064D0F102C41029

Query result

Key Value
FileSize96208
MD55D7BB62DECF071AAC47D44B84EA0E59C
PackageDescriptionPostgreSQL foreign data wrapper for OGR OGR is the vector half of the GDAL spatial data access library. It allows access to a large number of GIS data formats using a simple C API for data reading and writing. Since OGR exposes a simple table structure and PostgreSQL foreign data wrappers allow access to table structures, the fit seems pretty perfect. . This implementation currently has the following limitations: * Only non-spatial query restrictions are pushed down to the OGR driver. PostgreSQL foreign data wrappers support delegating portions of the SQL query to the underlying data source, in this case OGR. This implementation currently pushes down only non-spatial query restrictions, and only for the small subset of comparison operators (>, <, <=, >=, =) supported by OGR. * Spatial restrictions are not pushed down. OGR can handle basic bounding box restrictions and even (for some drivers) more explicit intersection restrictions, but those are not passed to the OGR driver yet. * OGR connections every time Rather than pooling OGR connections, each query makes (and disposes of) two new ones, which seems to be the largest performance drag at the moment for restricted (small) queries. * All columns are retrieved every time. PostgreSQL foreign data wrappers don't require all columns all the time, and some efficiencies can be gained by only requesting the columns needed to fulfill a query. This would be a minimal efficiency improvement, but can be removed given some development time, since the OGR API supports returning a subset of columns.
PackageMaintainerDebian GIS Project <pkg-grass-devel@lists.alioth.debian.org>
PackageNamepostgresql-13-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-1+b1
SHA-1E3C6E3F8A70FDC64FA0610193064D0F102C41029
SHA-25642967B246BDC5E690A795D3685E9F08148E5C53A305378FE3334A48D13468202
hashlookup:children-total15
hashlookup:trust50

Network graph view

Children (Total: 15)

The searched file hash includes 15 children files known and seen by metalookup. A sample is included below:

Key Value
FileNameogr_fdw--1.0--1.1.sql
FileSize299
MD51EF554C616399D0FB6F06EA3F98F8207
RDS:package_id285120
SHA-130C012FEA931EA588C3F6A149ED4824C112DE8AB
SHA-256AA6E1255A8A15EA871B2BA23E9A48A4C44F694AEDC97C360A09146030F14DD93
SSDEEP6:ecUhTaUxCii752Jr6AgFeBzUhTCxCijw52JZzAgFeB5:ecURxZoFFeBzU0/l7zFFeB5
TLSHT12EE0CD0BAD675523D292BF349402C9BF4F13038F446BE95050BB741C8E5380C8B25EEB
insert-timestamp1662198435.8497121
sourcedelta.db
Key Value
FileNameogr_fdw.control
FileSize152
MD5408F173AC888FA17C052E673078E59A0
RDS:package_id285118
SHA-1ABDA8467690571C922AFF0388ABD42855D6818F7
SHA-256163D3B61CC6DC3415543E755617DDC9579E6E42149687D2AA0A0A0C5A43773A0
SSDEEP3:SJFAYT8XqgSZVQisnqBCv2DB4AGNRKmVVERNwoCEHBYjQCvcTpdFR1n:SJFzT8XqgSZVgD2GNRKm/ErwoXHBYcPv
TLSHT158C08C2113AA84A20814BF28D9000020DEA43AB82212242712C8888C3BA0789B241B09
insert-timestamp1662198435.5457163
sourcedelta.db
Key Value
FileName./usr/share/lintian/overrides/ruby-narray-miss
FileSize63
MD572EE11F9626FF424B93B5AF1F353BCBA
RDS:package_id293681
SHA-18B1072FD9A6A5C0ACC44BD875330A469DF2C4A09
SHA-256571DA562A54CEA577DAF5A18A413B8A1D02E78769BCB1E7254E9153B260D8C58
SHA-512B914B2C5B4B7400CB7BA0AD16C21E7F68BF2D612FC7E71D07E92D8D03BE24BB17C5F0BD8CBF70377651AF16C5E5BDE3EE10050BC446709E95947716C501BF79F
SSDEEP3:SLfELcAGAI+GAWZGOrtRogPvvn:SALccI+G1Zrnv
TLSHT169A002544D11155A575277107F311705627B617196A442406128154A7406FB422D262E
insert-timestamp1728263316.5318696
mimetypetext/plain
sourcesnap:2ZmiMNpbuanFwhJ4sSt9y1DaYHITLCyb_103
Key Value
FileName./usr/lib/postgresql/13/bin/ogr_fdw_info
FileSize18228
MD541F3DD17CA8CC143949287B12F17171E
SHA-15829E65F6B3946BF74972AE5A024EA32CF7F81A6
SHA-2569A16E9DAA7C71119538299799EBB4932A75F9939F5BA41FD31652AB0DF788CF4
SSDEEP384:b89cQLmrm/lekHN6/oLa7hAOJ5MxGlKa4+MSQWEqI+lDVbPCM9I:Kjqrm/leUYzAOJ5MxG0a4+MSQWEqI+lM
TLSHT1D782E6836243C8B3D9C1BA3974674E018379D39EDDA74BD3605826640F8EAA7EDF4B50
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1585
MD583C3310E2A14F704F922D940954E2AF2
SHA-12D7DA18BF5A42B2CE51EE8F9A31D961F94A85307
SHA-256F45A09F7287DAEA7BE98FDA0D1D7F8CC58594145B6321D3283309006210E29C5
SSDEEP48:XJy/LznL9R1sC9GUBih1TfrKmyJg7hZdms1xT0x:efxHvGUBihVFGSt0x
TLSHT187310A2C3F7A52D76ABA1CECAFF6053E9712435843606059E452A9B55338B0981CFFA4
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64524
MD50A543362C90B6BCA7B9232777D803B31
SHA-1885BA8114D59978238BEF5A7EA27686819BA3729
SHA-256CEE343D9F30A00F28D7F31E1477F8284E199AB6544DF6A1862F06D41FB1BC018
SSDEEP768:KPVYKHQxASAGyWyheo4fV9dKzAlyFSCPDmHUdKk6ICrh9oyFZt5o5e68o3eJ2:N7OlhCdSFnDiUKzr4yFZt5o5F81J2
TLSHT172536D2E75108681E84C273E5CBF2ACD07F6A644CF0696177799976C3C31348EA72ABC
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize24068
MD5B8705C24A5E52790253F94677777AA76
SHA-18C8FF8A2C56A073982AF11BEBE6F2541CA5C16C5
SHA-2567614D0E7AA95C9DDAAC624627A6D3A5EBECA1168A33F63ABEB734E7F34D63E79
SSDEEP384:khO7qsQFgoUTKL07Wn1F1Ypor3hUWT6sB8WNJVcGwaqhLYCtRB5Q5:Mq5tTKg7W1vKY9WWN0jhLYgRBG5
TLSHT124B27C3FF1A18252C94C173D58BF02D717E2B548EF20938B565AA73C7DB2284AB32275
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize6140
MD50572FE51084AC9E89DF07EC61BE1CE17
SHA-14E0448BE67C54D21BD50176A87B3A6984D00364E
SHA-2565850986B8102A6A42BBF64B031667C8E97EC3F27D1447F44CA202A33D24F680D
SSDEEP96:kn9XJxc21QJ7WEN/+/Eh7yV9HTn3ZHVrnwIKtZDy+uMgJP7yoYqXWri5oYmwgb1i:k9+/V5h7yVtr3/wIKtTfYP79tgc
TLSHT1BAC1191B73A405D2C69E073E9CAE81CE1736B2088F56A71777557A2CBEF021FA4005B7
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.armhf.gz
FileSize220
MD563265ADEC2F986AC28851B2608E3362B
SHA-1934A52E15436E402AE9924E7842283C1E9EDB6E7
SHA-256A51B8059EFACA817517E888833925C4046F74256A5E077440493F5950AED28EB
SSDEEP6:XtxsOY2UCm/7ivgnDWeb6+2dM5//EAYLJ:X2Cm/71W2Qdw/EAYLJ
TLSHT187D023D052C64527D333E872388C3C2430C69B31C3C15C0040901613E43E33FC0C5118
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize10620
MD5F28E3639ACB66C5E9A245B8780ED52BE
SHA-1A116444BA4EC9D0E4CD52993385FE0000A8EEB03
SHA-2565C4DADBAADBF2E233AA13D9B42414663B44126670142A1A5E422479B0EE7E2D9
SSDEEP192:kFOvh7yKcWYb7rTf+KtTvuCnyzxUkkKNWTWPJML:kFeU3XrTfjnkYKNyW
TLSHT19222391FB3AC8A41D1491F3C8CE7419DC2AAB4848F30E7A777A61B2CAEF102E58D1156
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize16116
MD55672C889EC7FB047AAC8C4C37D3BA365
SHA-1A093ADA3922E3564095C07DDE0771DBFAFA8A86C
SHA-256B305B3D78D16E67957E3F85B4DFFDEBB8B7FFAEDB74857ACE90793E0C0580B6E
SSDEEP384:ksZUYr315Fx1L/+26QbXA3ZbkkyUYMfWYii/9dW:pyC15LF+2pTA3pWRi/9dW
TLSHT12572E72BBA918791D694463E187F018F97B9F508CF17D2933B9C773C6970144EAB087A
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize42460
MD5BDF5D7213B65DEBE7D283C8562181907
SHA-1AAF028DC5122AABEF84916EAE76B6E1B4A3EE786
SHA-2561723D937356476E4074AB26FF59B803F654FE45729AE8A2A1C33438008255AC7
SSDEEP768:IuI2tU8VDS7BosqerRlObU/FsaIgiYKKjST1JW8Mo1nny5t4lICijBzTR6YIobK:7g8D44sRwbU/GaFiYhGT28D9nyoABzB6
TLSHT160134AD7F10B1633C48A13720BE30E060661519AD5952FD37528E97B4F2E698ECA9FF4
Key Value
FileNameogr_fdw--1.1.sql
FileSize767
MD5117BF214A9335C66AB3A7A7CD81D993B
RDS:package_id285120
SHA-13A2503FBEACD0C4038357414816667E81AF7B531
SHA-2567ED528C0611FFD669276F6E38F047C9CFE9E0CDC2E348245C1D49D241A955780
SSDEEP12:UtjGFoUEeBNFY/9UOeSxdcSewsncDS/WuAMVsEURxZoFFeBzU0/l7zFFeB5:qyto7ezSeDGS/WFb9p8eBIyl3eB5
TLSHT14A014C0F596DE1238391BE78A406887FDB12434E4817AAC0909B651C5EC6A094725FFA
insert-timestamp1662198435.6775877
sourcedelta.db
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10232
MD5720DC4AC70430C7B338359C6EDAC8CFD
SHA-1996F8B62DAE967BEB24CEEC3837AD17A7E2BE315
SHA-25650B020270AF68835740F42B68D6FE724C2EAFE5B3CDEA0425A8C9712C1F62386
SSDEEP192:e4SApJH0Y1R5Ibi2IUxojFPUv9WhhyVOYZRFIWkVXkGA5IIEywpfp:SKt1RmW22q9WhhyVOYZRFIWkVXlpdzp
TLSHT15B226DD7D764120A6203D1E8CD6F2FFC85F2142B93B129ABE058B42239E971D50DD47E
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464