Result for D709B1C6F8A5F3DC1C558D7EFF0CE1DAB5C3B908

Query result

Key Value
FileSize98240
MD5494A83BBE5F7A5885E0218D7DC3C4F50
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-14-ogr-fdw
PackageSectiondatabase
PackageVersion1.1.1-2
SHA-1D709B1C6F8A5F3DC1C558D7EFF0CE1DAB5C3B908
SHA-2561A19B52983DC3338571A4F2AA28B76BE562EA7914D3DC9CA1DAF9B77EEC0042B
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
FileName./usr/share/doc/postgresql-14-ogr-fdw/changelog.Debian.gz
FileSize1631
MD520B13F809F60AC775A9B1E0A7318F312
SHA-1637298717C2311BABE75C971487902FFCAC419CB
SHA-256E8AADA811337EA2082B94BC74A0FAF87D54EFF11345E9C7A802EE6A72307FEB1
SSDEEP48:XkNTxssNxJ209jzGkJ70uFGIzJRByL7IKi07RvJ2wy:25N7n5J70ozJRB6Xp7y
TLSHT14131EAA6D717D0D3B960E70621DEEE7F153ADD99B15B8C033088B7A014221A0A24915D
Key Value
FileName./usr/share/doc/postgresql-13-ogr-fdw/copyright
FileSize1620
MD5499B3FB5D2AAB1E6C06D1CCFBC800180
SHA-17F3316DC5C6DD7A5E955520CA0887D2C6ACC47C2
SHA-256A44FF01B48025CB7EB1CA15965214E09653E902221EE69DF88BD5380112C5D1E
SSDEEP24:gttzRRSoRhmKWgKrKUxrwNJHZH0yf3gtk1Hc1hMK9QH0sUv4kOk4/+/U3oq4sFig:s3qfxyJxl/El5QH0s5ANU3oWFig
TLSHT1B631C84FF64403632DE233E29854B8E9A7337489B0AB16C5F44EE2047B2A0ADC1FA464
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/14/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize12628
MD55D6FFF9A1F9934EC45D2E9A044A41177
SHA-1418D74F884A76CE0AAE04228ACC12759104ABFCA
SHA-256BCD0AF7AE7E7F12CEE7228E6D44EAD4A43369AF51786F5DABD4159BCE17F0F0D
SSDEEP192:kXaGIvhyq85cKtBYb7yKP5cKtUKtTduCnyzxUkkKN0STW1JMLR:kXaRIyJBOankYKN0mWW
TLSHT156421A0FB3FC8901E48D173C8CEA418FC2E6A5859F25D6E337A6AF2DAD9112D9C81751
Key Value
FileName./usr/lib/postgresql/14/bin/ogr_fdw_info
FileSize22464
MD5A05FC25148149CCA3237109D2CD0C9C2
SHA-1265582F4F8AEEA6BE41A3A036BC925E6266F36AC
SHA-25618A289A56FDCCAEC1FAC11BFCE2906158A9E6E974B7BCAB6562FCF3A81EF7F5D
SSDEEP384:m9cMumrm+xj77M9qEKsbRXhKvJgGObj27b+4HuYbRPT3DVbPCCLL/:Errrm+x7qqEgvqGO/2/Vr3DVbKC
TLSHT1E6A2B587F441A673C4C0223A685F8B1DB32397ACC39E7B43E01C55585F5A79B8DFAA42
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize68672
MD53412AAF2002774FFF646CF09FCA8A8D4
SHA-1577E0950584CAC6A506060C562D84D65F8422D3A
SHA-256EC4240ACBC75A0B42F9F9332BE67EFD5D58F776E6B72B6CDD72CF53CCC65B7DA
SSDEEP1536:bHfuKojL4TFqxGTNzP7UKuoO7m+aF8bJ2:bHf8X4hqxqNfUKuooieb0
TLSHT16E637D2E75A1C791D88C233E5CFF098E07ED66089E09966733E96B1D3C71248E971A7C
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_common.bc
FileSize18132
MD52F214829794220DF4F7532ED9C4398A9
SHA-1D9BD61C1E93794E1A56511EE2217375A4732A4D2
SHA-256C346F4F98CD5E8E721837969F925A1C3E901FC78EA6FD3C546A626DF5B78CFD3
SSDEEP384:kdcWI5r3Q5lBL1BP/+26QbXA3ZbkkyUWMHiYii/fdi:8cJ9Q5lR1t+2pTA3+Ri/fdi
TLSHT1FE82E82FB6E58795D188473D187F018E93A8F508DF1AD69337CC672C6871148EAF1539
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw.index.bc
FileSize10260
MD5CBDC24F75A0538197DA4EAD2B8318025
SHA-1CB5C1AC36EDBCC899BE3337D0107A0755B0F81EF
SHA-256C127F428582412532C0A340CF8AE442BBE4B56BCF2E7DA00B73DA606B668B14D
SSDEEP192:L79Go8Ga5tEJyVzkMiDwnfJ7WYSvBmPb1OlyzmpsxOieInTMSL2M:/9GdrEJizuARxb1OlyzmpsLeI7KM
TLSHT1DC228EC7F1C6443A6109EAC66CEF6CF9C1E1101703E86E83D856F886759A35F06ED4B4
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/14/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize7000
MD50C01C9334B02D2B096B3937DD28D066B
SHA-1B7644EB137666A5171B4229A73E37CF4997FE5CC
SHA-256F7A0A11D37B645DCE6CA377DA94CC9AB02196F2A0FEEEE17D41BD9FD31E13855
SSDEEP96:kI9XJxy8jtWHU/J7WzKC+E/Ehyq8+9HTn3rc1j+1xlKtZDy+u+gJP75voYqXWHoK:kQB/rC+Xhyq8+tr3rcpKlKtTJYP757g
TLSHT1DCE11A2F73D40553C18D073EACEE42CD232AB5089F5EF72772957A2CB97134AA990179
Key Value
FileName./usr/lib/postgresql/14/lib/bitcode/ogr_fdw/ogr_fdw_deparse.bc
FileSize26708
MD5652B77F412CC33A3A80A7E920FD26FC9
SHA-1371D07740B5148EAB96411B672930AF7AD69A2AE
SHA-256AEF189FF3070326DB2E82F2B099548D4F6CB9957FC15F268BF2077C1871CF5A6
SSDEEP768:u44c6rNC8FBnmtZ171KVupWMLXPClrKKQnTbIdyA4hF57fMeMpGp:Tk/HnmH1pKVuX7PClrKKQnTbIdyA4ZM4
TLSHT1ABC27D29F1B94693C9480B3C9C6F028953D6B90DEF08C29726AE673D7D72704CEE1679
Key Value
FileName./usr/lib/postgresql/14/lib/ogr_fdw.so
FileSize50788
MD5CA09362A1BC95C0FDF99D163893F1C27
SHA-1581845F735832DE0715ACC6A61150A9DFC5AEDA1
SHA-2560A8291F56084C93962AEC971DAA048C8648135B39070445D566FE11F9BC4BCF7
SSDEEP768:9gSjsU8hfBSilz0FldNfN+XR6KawwJDy/yKYudF3nSO6V2emTV7UgzTR6cIobK:rlkfBPEahtHyedYs3SoQgztIoK
TLSHT16F33E75BBC818E57C1D41275728A8B6CB72307A9D3DA2716C43843692FAA18FCD75FC2