Result for 4B94B9341A53E76BCBBFC76F75CADC4BCE9A4B99

Query result

Key Value
FileSize100740
MD5B5631B6F8E29B32B7E4D62AAEC3B6C23
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-14B94B9341A53E76BCBBFC76F75CADC4BCE9A4B99
SHA-256D9643112041C469FE4E38A6016E4289F8152BA09F0D9622B0A72413262625CF9
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
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw.index.bc
FileSize10056
MD5EA3E76BDAFD6AE8D077E5E9E48DF16C1
SHA-1110C038C662B4DEAF30338FDC17313E919878A1E
SHA-2565D3945B3ACF8A13620A735BD9CF9884823F169454139E9F1F60568F500527BB4
SSDEEP192:xew4gibCg9oTPXHuHRMvUflwCmkCFaiJ1XhD4jfCROEvi9ZWr:xkZegCfgjflYLJluzCrivI
TLSHT116227DCBF7C8565276A9E187E8CF8EBD0394005701F22BF26C987D23268611A15CE47C
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/stringbuffer_pg.bc
FileSize9836
MD52019A099E27B14917C713CE13240A7C4
SHA-1A2C9BFDD4EA4B4354DF9BE396FCC11A20F24173C
SHA-2560CED1701DFA0276587A964E0F3BFF8764FFD604C760993992B0BE9A336D5FDB3
SSDEEP192:km3YHr3IgEvKtTTADKxCOQGHZngwDguvEbTWugJMLB:kmqr37ErG8OQGHZn3BvsW4
TLSHT108124C1BB3A95690C248173D4CFB438FD2BDD1818F64A763B7E16E3CACB12375890462
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/ogr_fdw.so
FileSize63576
MD5E49B93901286F17D89F0D6DB05527067
SHA-1F35D25640898BFD3EA5A371DB83D7674C4460944
SHA-256BC6A60D997447C48E8618D13343841F3F855DBED0B6678AD12CECB60664E6EE2
SSDEEP768:ZhjXSIZbZb42svgRM2zgNTDsvXcsBCSZl13W1y2kzsBq80j/qG6Dg:3jX5ZbOXUXcsBCSZlc1+zRa
TLSHT17353098FBE3685A9C8F86A31807E9A758733AD357688095C7B6CF7180CF37508968774
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw_func.bc
FileSize5792
MD530B0D9F21429B903FA4A2B091B64458D
SHA-15C7986058906077E6DC8161ED6C37C4D096801FE
SHA-25613F8CF305A3006FA0F374E13930839A6E912A0A8F629F95DEB0176CE508623A5
SSDEEP96:k79cXSFkqzJ7W1HI7ewh0qffKtZDy+K4H31oLwoYqXWdEWoYmwgbLD:kJcqzF7h08KtT3lTgz
TLSHT1D7C14C2A73541A41C144073CDDBF01DEA3BAEA028F85E7472296BA2CEE7032FE850561
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/lib/postgresql/13/bin/ogr_fdw_info
FileSize31448
MD5C9062331FF4CDD1AE2E6CEDFA4B9953D
SHA-116B4B158D5FBF0D80E88E242FA5D7D44535033B7
SHA-256FD71FFAB23E32A303DE85015FE88584B9992B5448FD34D396E40256D2ACF0826
SSDEEP384:hGJmOmxG0tcY36cT/L+OyOnldQwatUv8hCixPipjMZGUdo8Rz4:hGQOmE0xb/L+cnz3IU0A1pj2dFRE
TLSHT1CDE2E60BAE6386BEC0F47A3281DB96B552379C6277404535BB6DF3087CF17618A36638
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/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_common.bc
FileSize15920
MD5CE5938241FBD4EE1011F5CCEA45821A6
SHA-151DF719D33C21C577727285957360BE030329A51
SHA-2566F812AC2351E879C5F6D73C704D72DD88BE1495066F6737D7F7EABCA973905AE
SSDEEP192:kU1DYbdch9V5vhVY86jVfvCbYzKtT6jnJpNz8q40GXYPIybC2O31icQGSRH4O8cQ:kU12e3kxnfd8qdlFk41YiiC5dS
TLSHT1FE622B1BF69597D1D989063E1D3F01DB87AAE608CF29834337D8332C6A7114CE9B1679
Key Value
FileName./usr/lib/postgresql/13/lib/bitcode/ogr_fdw/ogr_fdw.bc
FileSize64644
MD56E9B8463894745F847E4D39BA2D5B5EE
SHA-11AEA1CA95B65955621E2C481E196D361FD6E5983
SHA-256B1B287C2CF030BD2EF9909DC58BFB77E219C0E383399B7986FDF1F7EA224E2C3
SSDEEP1536:5TBff9M5Qps9YNQEMf2RIzDpU4Z/t9F8mJG:5TBff9M5QEYN3K2IpU4ZremU
TLSHT100537C5AB1A0C391D58C163E4CBF11C907B6B604DF04A6633798732C3D31298FAB2ABD
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/ogr_fdw_deparse.bc
FileSize24024
MD55A8B387B35B8F7AF982B66EFE2FAB08B
SHA-123EF3A59E18F6D005BBDAA4753818778FD90B13A
SHA-25605193E2D43F50B6475D96BE715FCED270BE5B2C30EF1CCA93CC18311C473612B
SSDEEP384:khitMWHOyOXwAlNcZVr3Aqc13Eg6WSUzUPckOEBrreW5Q:MveOAAlNU5AiWhzcnJreWG
TLSHT160B27D2CF6D55545C988173D9C7E039B4BE6E149FE0483936199633CAE32380EEB2B79
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
FileName./usr/share/doc/postgresql-13-ogr-fdw/changelog.Debian.s390x.gz
FileSize219
MD5BA27A2499C51F0D79DA3FDB45FB768CF
SHA-1884899F78EEA8F3934EA86666105ADA12524B2BB
SHA-25653F8AFA01A075A08966A6FE44D1F04A4A48F3A8D4F6CBDA155B791E5E529BAEB
SSDEEP6:XtByV1tmDXB7QrQ1nsnaVLEXVkdGclF059/4sPRJr1wR:XSDGaGnsnaVuVUt5oJru
TLSHT1DFD0235814D581F5D10025BB7C03A188E2DD7241D25754E104BD154079F4CA15C6C75D