GPKGGeometryMetadataDao

Objective-C

@interface GPKGGeometryMetadataDao : GPKGBaseDao

Swift

class GPKGGeometryMetadataDao : GPKGBaseDao

Geometry Metadata Data Access Object

  • Query range tolerance

    Declaration

    Objective-C

    @property (nonatomic) double tolerance;

    Swift

    var tolerance: Double { get set }
  • Index geometries using geodesic lines

    Declaration

    Objective-C

    @property (nonatomic) BOOL geodesic;

    Swift

    var geodesic: Bool { get set }
  • Features projection

    Declaration

    Objective-C

    @property (nonatomic, strong) PROJProjection *projection;

    Swift

    var projection: PROJProjection! { get set }
  • Initialize

    Declaration

    Objective-C

    - (instancetype)initWithDatabase:(GPKGConnection *)database;

    Swift

    init!(database: GPKGConnection!)

    Parameters

    database

    database connection

    Return Value

    new Geometry Metadata DAO

  • Initialize

    Declaration

    Objective-C

    - (instancetype)initWithDatabase:(GPKGConnection *)database
                         andGeodesic:(BOOL)geodesic
                       andProjection:(PROJProjection *)projection;

    Swift

    init!(database: GPKGConnection!, andGeodesic geodesic: Bool, andProjection projection: PROJProjection!)

    Parameters

    database

    database connection

    geodesic

    index geodesic geometries flag

    projection

    feature projection

    Return Value

    new Geometry Metadata DAO

  • Create geometry metadata

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)
        createMetadataWithGeoPackageName:(NSString *)geoPackageName
                            andTableName:(NSString *)tableName
                                   andId:(NSNumber *)geomId
                             andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func createMetadata(withGeoPackageName geoPackageName: String!, andTableName tableName: String!, andId geomId: NSNumber!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGGeometryMetadata!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    geomId

    Geometry id

    envelope

    Geometry Envelope

    Return Value

    geometry metadata

  • Create geometry metadata

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)
        createMetadataWithGeoPackageId:(NSNumber *)geoPackageId
                          andTableName:(NSString *)tableName
                                 andId:(NSNumber *)geomId
                           andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func createMetadata(withGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andId geomId: NSNumber!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGGeometryMetadata!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    geomId

    Geometry id

    envelope

    Geometry Envelope

    Return Value

    geometry metadata

  • Populate geometry metadata

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)
        populateMetadataWithGeoPackageId:(NSNumber *)geoPackageId
                            andTableName:(NSString *)tableName
                                   andId:(NSNumber *)geomId
                             andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func populateMetadata(withGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andId geomId: NSNumber!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGGeometryMetadata!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    geomId

    Geometry id

    envelope

    Geometry Envelope

    Return Value

    geometry metadata

  • Delete geometry metadata

    Declaration

    Objective-C

    - (BOOL)deleteMetadata:(GPKGGeometryMetadata *)metadata;

    Swift

    func delete(_ metadata: GPKGGeometryMetadata!) -> Bool

    Parameters

    metadata

    metadata

    Return Value

    true if deleted

  • Delete geometry metadata by name

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageName:(NSString *)name;

    Swift

    func delete(byGeoPackageName name: String!) -> Bool

    Parameters

    name

    geometry metadata name

    Return Value

    true if deleted

  • Delete geometry metadata by GeoPackage id

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageId:(NSNumber *)geoPackageId;

    Swift

    func delete(byGeoPackageId geoPackageId: NSNumber!) -> Bool

    Parameters

    geoPackageId

    GeoPackage id

    Return Value

    true if deleted

  • Delete geometry metadata by GeoPackage name and table name

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageName:(NSString *)name
                      andTableName:(NSString *)tableName;

    Swift

    func delete(byGeoPackageName name: String!, andTableName tableName: String!) -> Bool

    Parameters

    name

    GeoPackage name

    tableName

    table name

    Return Value

    true if deleted

  • Delete geometry metadata by GeoPackage id and table name

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageId:(NSNumber *)geoPackageId
                    andTableName:(NSString *)tableName;

    Swift

    func delete(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> Bool

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    true if deleted

  • Delete geometry metadata by GeoPackage name, table name, and geometry id

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageName:(NSString *)name
                      andTableName:(NSString *)tableName
                             andId:(NSNumber *)geomId;

    Swift

    func delete(byGeoPackageName name: String!, andTableName tableName: String!, andId geomId: NSNumber!) -> Bool

    Parameters

    name

    GeoPackage name

    tableName

    table name

    geomId

    geometry id

    Return Value

    true if deleted

  • Delete geometry metadata by GeoPackage id, table name, and geometry id

    Declaration

    Objective-C

    - (BOOL)deleteByGeoPackageId:(NSNumber *)geoPackageId
                    andTableName:(NSString *)tableName
                           andId:(NSNumber *)geomId;

    Swift

    func delete(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andId geomId: NSNumber!) -> Bool

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    geomId

    geometry id

    Return Value

    true if deleted

  • Create of update geometry metadata

    Declaration

    Objective-C

    - (BOOL)createOrUpdateMetadata:(GPKGGeometryMetadata *)metadata;

    Swift

    func createOrUpdate(_ metadata: GPKGGeometryMetadata!) -> Bool

    Parameters

    metadata

    geometry metadata

    Return Value

    true if created or updated

  • Update geometry metadata

    Declaration

    Objective-C

    - (BOOL)updateMetadata:(GPKGGeometryMetadata *)metadata;

    Swift

    func update(_ metadata: GPKGGeometryMetadata!) -> Bool

    Parameters

    metadata

    geometry metadata

    Return Value

    true if updated

  • Check if geometry metadata exists

    Declaration

    Objective-C

    - (BOOL)existsByMetadata:(GPKGGeometryMetadata *)metadata;

    Swift

    func exists(by metadata: GPKGGeometryMetadata!) -> Bool

    Parameters

    metadata

    geometry metadata

    Return Value

    true if exists

  • Get geometry metadata by metadata

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)metadataByMetadata:(GPKGGeometryMetadata *)metadata;

    Swift

    func metadata(by metadata: GPKGGeometryMetadata!) -> GPKGGeometryMetadata!

    Parameters

    metadata

    geometry metadata

    Return Value

    geometry metadata

  • Get geometry metadata by GeoPackage name, table name, and id

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)metadataByGeoPackageName:(NSString *)geoPackageName
                                          andTableName:(NSString *)tableName
                                                 andId:(NSNumber *)id;

    Swift

    func metadata(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andId id: NSNumber!) -> GPKGGeometryMetadata!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    id

    id

    Return Value

    geometry metadata

  • Get geometry metadata by GeoPackage id, table name, and id

    Declaration

    Objective-C

    - (GPKGGeometryMetadata *)metadataByGeoPackageId:(NSNumber *)geoPackageId
                                        andTableName:(NSString *)tableName
                                               andId:(NSNumber *)id;

    Swift

    func metadata(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andId id: NSNumber!) -> GPKGGeometryMetadata!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    id

    id

    Return Value

    geometry metadata

  • Query for geometry metadata

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    Return Value

    result set

  • Query for all table geometry metadata geometry ids

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageName:(NSString *)geoPackageName
                                   andTableName:(NSString *)tableName;

    Swift

    func queryIds(byGeoPackageName geoPackageName: String!, andTableName tableName: String!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    Return Value

    result set

  • Query for all table geometry metadata

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                                  andColumns:(NSArray<NSString *> *)columns;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andColumns columns: [String]!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    columns

    queried columns

    Return Value

    result set

  • Query for geometry metadata count

    Declaration

    Objective-C

    - (int)countByGeoPackageName:(NSString *)geoPackageName
                    andTableName:(NSString *)tableName;

    Swift

    func count(byGeoPackageName geoPackageName: String!, andTableName tableName: String!) -> Int32

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    Return Value

    count

  • Query for the bounds of the feature table index

    Declaration

    Objective-C

    - (GPKGBoundingBox *)boundingBoxByGeoPackageName:(NSString *)geoPackageName
                                        andTableName:(NSString *)tableName;

    Swift

    func boundingBox(byGeoPackageName geoPackageName: String!, andTableName tableName: String!) -> GPKGBoundingBox!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    Return Value

    bounding box

  • Query for the bounds of the feature table index

    Declaration

    Objective-C

    - (GPKGBoundingBox *)boundingBoxByGeoPackageId:(NSNumber *)geoPackageId
                                      andTableName:(NSString *)tableName;

    Swift

    func boundingBox(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> GPKGBoundingBox!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    bounding box

  • Query for geometry metadata

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    result set

  • Query for all table geometry metadata geometry ids

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageId:(NSNumber *)geoPackageId
                                 andTableName:(NSString *)tableName;

    Swift

    func queryIds(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    result set

  • Query for all table geometry metadata

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                                andColumns:(NSArray<NSString *> *)columns;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andColumns columns: [String]!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    columns

    queried columns

    Return Value

    result set

  • Query for geometry metadata count

    Declaration

    Objective-C

    - (int)countByGeoPackageId:(NSNumber *)geoPackageId
                  andTableName:(NSString *)tableName;

    Swift

    func count(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> Int32

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    count

  • Get the query SQL for a GeoPackage id and table name

    Declaration

    Objective-C

    - (NSString *)querySQL;

    Swift

    func querySQL() -> String!

    Return Value

    SQL

  • Get the query SQL args for a GeoPackage id and table name

    Declaration

    Objective-C

    - (NSArray *)querySQLArgsWithGeoPackageId:(NSNumber *)geoPackageId
                                 andTableName:(NSString *)tableName;

    Swift

    func querySQLArgs(withGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> [Any]!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    SQL args

  • Query for all geometry metadata matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                              andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all table geometry metadata ids matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageName:(NSString *)geoPackageName
                                   andTableName:(NSString *)tableName
                                 andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func queryIds(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all table geometry metadata matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                                  andColumns:(NSArray<NSString *> *)columns
                              andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andColumns columns: [String]!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    columns

    queried columns

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all geometry metadata count matching the bounding box in the same projection

    Declaration

    Objective-C

    - (int)countByGeoPackageName:(NSString *)geoPackageName
                    andTableName:(NSString *)tableName
                  andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func count(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> Int32

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    count

  • Query for all geometry metadata matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                            andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all table geometry metadata ids matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageId:(NSNumber *)geoPackageId
                                 andTableName:(NSString *)tableName
                               andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func queryIds(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all table geometry metadata matching the bounding box in the same projection

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                                andColumns:(NSArray<NSString *> *)columns
                            andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andColumns columns: [String]!, andBoundingBox boundingBox: GPKGBoundingBox!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    columns

    queried columns

    boundingBox

    bounding box

    Return Value

    result set

  • Query for all geometry metadata count matching the bounding box in the same projection

    Declaration

    Objective-C

    - (int)countByGeoPackageId:(NSNumber *)geoPackageId
                  andTableName:(NSString *)tableName
                andBoundingBox:(GPKGBoundingBox *)boundingBox;

    Swift

    func count(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andBoundingBox boundingBox: GPKGBoundingBox!) -> Int32

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    boundingBox

    bounding box

    Return Value

    count

  • Query for all geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                                 andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all table geometry metadata ids matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageName:(NSString *)geoPackageName
                                   andTableName:(NSString *)tableName
                                    andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func queryIds(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all table geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                                  andColumns:(NSArray<NSString *> *)columns
                                 andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andColumns columns: [String]!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    columns

    queried columns

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all geometry metadata count matching the envelope

    Declaration

    Objective-C

    - (int)countByGeoPackageName:(NSString *)geoPackageName
                    andTableName:(NSString *)tableName
                     andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func count(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> Int32

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    count

  • Query for all table geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageName:(NSString *)geoPackageName
                                andTableName:(NSString *)tableName
                                 andDistinct:(BOOL)distinct
                                  andColumns:(NSArray<NSString *> *)columns
                                 andEnvelope:(SFGeometryEnvelope *)envelope
                                  andOrderBy:(NSString *)orderBy
                                    andLimit:(NSString *)limit;

    Swift

    func query(byGeoPackageName geoPackageName: String!, andTableName tableName: String!, andDistinct distinct: Bool, andColumns columns: [String]!, andEnvelope envelope: SFGeometryEnvelope!, andOrderBy orderBy: String!, andLimit limit: String!) -> GPKGResultSet!

    Parameters

    geoPackageName

    GeoPackage name

    tableName

    table name

    distinct

    distinct flag

    columns

    queried columns

    envelope

    geometry envelope

    orderBy

    order by

    limit

    limit

    Return Value

    result set

  • Query for all geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                               andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all table geometry metadata ids matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryIdsByGeoPackageId:(NSNumber *)geoPackageId
                                 andTableName:(NSString *)tableName
                                  andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func queryIds(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all table geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                                andColumns:(NSArray<NSString *> *)columns
                               andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andColumns columns: [String]!, andEnvelope envelope: SFGeometryEnvelope!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    columns

    queried columns

    envelope

    geometry envelope

    Return Value

    result set

  • Query for all table geometry metadata count matching the envelope

    Declaration

    Objective-C

    - (int)countByGeoPackageId:(NSNumber *)geoPackageId
                  andTableName:(NSString *)tableName
                   andEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func count(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andEnvelope envelope: SFGeometryEnvelope!) -> Int32

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    envelope

    geometry envelope

    Return Value

    count

  • Query for all table geometry metadata matching the envelope

    Declaration

    Objective-C

    - (GPKGResultSet *)queryByGeoPackageId:(NSNumber *)geoPackageId
                              andTableName:(NSString *)tableName
                               andDistinct:(BOOL)distinct
                                andColumns:(NSArray<NSString *> *)columns
                               andEnvelope:(SFGeometryEnvelope *)envelope
                                andOrderBy:(NSString *)orderBy
                                  andLimit:(NSString *)limit;

    Swift

    func query(byGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!, andDistinct distinct: Bool, andColumns columns: [String]!, andEnvelope envelope: SFGeometryEnvelope!, andOrderBy orderBy: String!, andLimit limit: String!) -> GPKGResultSet!

    Parameters

    geoPackageId

    GeoPackage id

    tableName

    table name

    distinct

    distinct flag

    columns

    queried columns

    envelope

    geometry envelope

    orderBy

    order by

    limit

    limit

    Return Value

    result set

  • Get the query SQL for an envelope, GeoPackage id, and table name

    Declaration

    Objective-C

    - (NSString *)querySQLWithEnvelope:(SFGeometryEnvelope *)envelope;

    Swift

    func querySQL(with envelope: SFGeometryEnvelope!) -> String!

    Parameters

    envelope

    geometry envelope

    Return Value

    SQL

  • Get the query SQL args for an envelope, GeoPackage id, and table name

    Declaration

    Objective-C

    - (NSArray *)querySQLArgsWithEnvelope:(SFGeometryEnvelope *)envelope
                          andGeoPackageId:(NSNumber *)geoPackageId
                             andTableName:(NSString *)tableName;

    Swift

    func querySQLArgs(with envelope: SFGeometryEnvelope!, andGeoPackageId geoPackageId: NSNumber!, andTableName tableName: String!) -> [Any]!

    Parameters

    envelope

    geometry envelope

    geoPackageId

    GeoPackage id

    tableName

    table name

    Return Value

    SQL args

  • Get GeoPackage id for the GeoPackage name

    Declaration

    Objective-C

    - (NSNumber *)geoPackageIdForGeoPackageName:(NSString *)name;

    Swift

    func geoPackageId(forGeoPackageName name: String!) -> NSNumber!

    Parameters

    name

    GeoPackage name

    Return Value

    GeoPackage id

  • Get the geometry metadata geometry id

    Declaration

    Objective-C

    + (NSNumber *)idWithResultSet:(GPKGResultSet *)resultSet;

    Swift

    class func id(with resultSet: GPKGResultSet!) -> NSNumber!

    Parameters

    resultSet

    result set

    Return Value

    id