Result for 825CA71D3EA0229BB545E10DFED7115CEA683183

Query result

Key Value
FileSize97328
MD572AAF45312DB05173F5F6DC856F8842D
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.0-1
SHA-1825CA71D3EA0229BB545E10DFED7115CEA683183
SHA-256CBBD366C47498D0B446823DE0EA1CE3C5E38B6A157CB2CA12DC7D22339824328
hashlookup:children-total14
hashlookup:trust50

Network graph view

Children (Total: 14)

The searched file hash includes 14 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
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize18132
MD593A93129A87E29E2A44095B5F4704EC2
SHA-15B3317D69A29CA93A49D3C2A7D83AC88DA60DBFC
SHA-2564AEBC9E2E6158A5E93D2FABAE720F9AB15545B54A95C7B7E22D107871162C8E6
SSDEEP384:kmcWI5r3Q5lBL1Bd/+26QbXA3ZbkkyUKMHiYii/hdi:bcJ9Q5lR1T+2pTA3iRi/hdi
TLSHT17F82D72FB6E58795D188473D187F028E93A8F908DF1AD6933BCC672C6871148EAF1539
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
FileNamesnap-hashlookup-import/usr/share/lintian/overrides/libhdf4-0-alt
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/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize67408
MD5F91E507EF096090F72E29F6E7F32F17F
SHA-15CECCEAC20BD25C97DCF45E34A7B4B71218D868E
SHA-25692B433BE50D3AC345DB68D70B7A58B8C60301D8EC6BD205401C1D4B8C40BE563
SSDEEP1536:hzQ3apSJdHd1H4unGKUqxc4yLZE1YGF8HJ:hzQ3apSJhdmuGKUqxmOPeH
TLSHT194636C2E3520C791E888273E5CBF1A8D07EAA604CF0696577799972D3C31344E9B1ABC
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize25504
MD546AA9F4C5C5CBCE35C87D0398662825E
SHA-1FC83C580783AEB5EEA7B18C324DE4727D3DE8F4D
SHA-25682DB98C1E3ACE6023177E68EC1CAE584219924F11937CCA7216EBE2BC373400C
SSDEEP384:klO7qsQFgoUD307WuwdtWr3rIgDjfQWNJVcGwaqhLYCrB5QZ:Uq5tDk7jwdtI8gDjoWN0jhLYUBGZ
TLSHT1A7B26C2FF5B14612C94C073C9CBF028B16E6B948EE288387679D673D7C725449A72678
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize12628
MD584E5EC310A3DD51DE10F7AC8C0F62C14
SHA-1124FFE9213BE8FDAFE635E7B49CBAA97079DFB49
SHA-256CF3EFAFC0458A7762AF75B4510B3587924B3B72546F21FCE621358DC83891448
SSDEEP192:kQaGIvhyq85cKtBYb7yKP5cKt6KtTvuCnyzxUkkKN0IvTW1JML3:kQaRIyJBO+nkYKN0I7WI
TLSHT16542190FB3FC8901E48D173D8CEA418FC2E5A5859F25D6E337A6AF2DAD9112D8C81751
Key Value
FileName./usr/lib/postgresql/13/lib/ogr_fdw.so
FileSize50644
MD5FFDF886BBCB55D9A1E819FC0F309CFA8
SHA-1E463435831BC6038E6639F70E2B3F4E203CEADB4
SHA-256FD0E666F89B5C1243447DC7CD34CB0373E46C70F18B37D3E21EBBAD3A1E9BE38
SSDEEP768:4L6U8pDSrp9D16H6I8IfVXaHg5NxvnVLjTtjCi59Jf4bR49Hpcr553D3yQkZBQzY:+YDUH6Hr3qsnDCi5SRoGfeRQzBIoK
TLSHT11933F895B8818E57C5C4127577AA8E68B33303B8D2DE3BA6CC1883652EA710FCD77E51
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.gz
FileSize1531
MD5BB1F73C9C547BA5937B8C85DE0B5261F
SHA-1909565F4A19E1251BBFB8405575B7DF832C3F60A
SHA-256DE88B285B27D97593EAC7EE1204BF1957EB89FE96FCA610778A6E0F7F8C73380
SSDEEP24:XIS1fX06dPb7fZft+H1P3ox8+pafYysZuAqAtS+niZL2P4Ad7Xe3iTkEH6MKbV3X:XIcHRft+HBYxd6Y6d07XeizHs3X
TLSHT14C31B599588D42B179AAA913850F494B6F6A6C43BEC30549E2F8034E90B8B6F4B69021
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/bin/ogr_fdw_info
FileSize22316
MD5670ECB5B8604311537B0BD95C35314F6
SHA-178DF9827A3C64639B27352C55FAE7771F3AECB2C
SHA-256B8C9CF72E8684EAE588D3C934A96FB0EAD0B28E051DAAC63E423802234EFCD42
SSDEEP384:a9ctrmrmXxj77M9qEKsbRXhSJl6SBYGthVpS/D/9b4YFXDVbPCfGD:YnrmXx7qqEYJlHBYE7pOO+XDVbK
TLSHT140A2A487F440A673C8C0223AA44F9B19732397ACC3DE7743E40C25685F5A79B8DFAA15
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize7000
MD5C3DFF448CEF2C16BDED7343A00D7DB3A
SHA-1E66BBCA30A7539645CBCC2D471B620B23E1AF030
SHA-256CCE754B328ADDEBC14768625127DA15E9C96EC5D9EE15F30F28B871032F226B5
SSDEEP96:k99XJxc21AJ7WzKC+E/Ehyq8+9HTn3rc1j+FxkKtZDy+uMgJP7coYqXWHoYmwgbM:kXyrC+Xhyq8+tr3rcpGkKtTfYP7ug
TLSHT1EBE12B2F73D40652C58D073EACEE82CD232AB5089F5EE71772957B3CB8B134A599017A
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10224
MD53EB2A0793526F7C3BB27BA696E688F5C
SHA-1A4E312785345CAE4044427333861453575D51327
SHA-2561E6F16F05B505BE3AFCE8139D9655E7EF4C421A754BC12883B44DAA0AEDBF6E0
SSDEEP192:l97IILs1EqBx4inuzr7NihtXIYY4EuRqnFGGrth4/3dte8DRH7:j7gEqBx4i87N4IYlEgqnFG/7p
TLSHT123228CD6E3DCD9624853E29286AB7DF902E0162F028049DFEE793E0FB9D634945DF460
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464