select count(*) from sysobjects where id = object_id(N'[dbo].[sp_spatial_query]') and OBJECTPROPERTY(id, N'IsProcedure') = 1

exec sp_spatial_query 'hg_restricted_server()'

exec sp_spatial_query 'select HG_Version() from Master.dbo.HG_OneRow'

select default_schema_name from sys.database_principals where name ='dbo'

select 1 from MAPINFO.MAPINFO_MAPCATALOG

select count(*) from MAPINFO.MAPINFO_MAPCATALOG

select 1 from MAPINFO.MAPINFO_MAPCATALOG

select  RENDITIONTYPE, RENDITIONCOLUMN from MAPINFO.MAPINFO_MAPCATALOG

select  RENDITIONTYPE, RENDITIONCOLUMN from MAPINFO.MAPINFO_MAPCATALOG

EasyLoader    Version: 12.50.1
     Date: 2/23/2018  Time: 6:47:0
--------------------------------------------
Server: LinzLDS
User:   dbo

OPTIONS
  Server table process:         Replace
  Append all to one table:      False
  Grant public access to table: False
  Create Unique index:          True
  Create Spatial index:         True
  Exclusive Use:                True
  Load Symbology:               True
  Symbology Column Name:        MI_STYLE
--------------------------------------------
select 1 from MAPINFO.MAPINFO_MAPCATALOG

select 1 from dbo.ParcelPrim

sp_sw_drop_rtree 'dbo', 'ParcelPrim', 'sw_geometry', 'sw_member'

sp_sw_despatialize_column 'dbo', 'ParcelPrim', 'sw_geometry', 'sw_member'

drop table dbo.ParcelPrim

create table dbo.ParcelPrim( fid varchar(254),gml_id varchar(254),id int,appellation varchar(254),affected_surveys varchar(254),parcel_intent varchar(254),topology_type varchar(254),land_district varchar(254),titles varchar(254),survey_area float,calc_area float,MI_STYLE VARCHAR(254),MI_PRINX INTEGER PRIMARY KEY IDENTITY,SP_GEOMETRY geometry)
create table dbo.ParcelPrim( fid varchar(254),gml_id varchar(254),id int,appellation varchar(254),affected_surveys varchar(254),parcel_intent varchar(254),topology_type varchar(254),land_district varchar(254),titles varchar(254),survey_area float,calc_area float,MI_STYLE VARCHAR(254),MI_PRINX INTEGER PRIMARY KEY IDENTITY,SP_GEOMETRY geometry)

insert into dbo.ParcelPrim( fid,gml_id,id,appellation,affected_surveys,parcel_intent,topology_type,land_district,titles,survey_area,calc_area,MI_STYLE,SP_GEOMETRY) values ( ?,?,?,?,?,?,?,?,?,?,?,?,geometry::STGeomFromWKB (?, 2193))

52917 records loaded out of 52917 total records.

DROP INDEX SIndex_ParcelPrim_SP_GEOMETRY ON dbo.ParcelPrim

CREATE SPATIAL INDEX SIndex_ParcelPrim_SP_GEOMETRY ON dbo.ParcelPrim (SP_GEOMETRY) WITH (BOUNDING_BOX = (1372628.910000, 5082971.475000, 1554303.180000, 5240800.275000))


CREATE SPATIAL INDEX SIndex_ParcelPrim_SP_GEOMETRY ON dbo.ParcelPrim (SP_GEOMETRY) WITH (BOUNDING_BOX = (1372628.910000, 5082971.475000, 1554303.180000, 5240800.275000))
update statistics dbo.ParcelPrim

UPDATE dbo.ParcelPrim SET SP_GEOMETRY  = SP_GEOMETRY.MakeValid() WHERE SP_GEOMETRY.STIsValid() = 0

select VIEW_X_LL,VIEW_Y_LL,VIEW_X_UR,VIEW_Y_UR from MAPINFO.MAPINFO_MAPCATALOG

insert into MAPINFO.MAPINFO_MAPCATALOG (SPATIALTYPE, TABLENAME, OWNERNAME, SPATIALCOLUMN, DB_X_LL, DB_Y_LL, DB_X_UR, DB_Y_UR, COORDINATESYSTEM, SYMBOL, XCOLUMNNAME, YCOLUMNNAME, RENDITIONTYPE, RENDITIONCOLUMN, RENDITIONTABLE, VIEW_X_LL, VIEW_Y_LL, VIEW_X_UR, VIEW_Y_UR) values ( 17.2, 'ParcelPrim', 'dbo', 'SP_GEOMETRY', 1372628.910000, 5082971.475000, 1554303.180000, 5240800.275000, 'Earth Projection 8, 117, "m", 173, 0, 0.9996, 1600000, 10000000 Bounds (-30000000, -15000000) (30000000, 15000000)', '', 'NO_COLUMN', 'NO_COLUMN', 1, 'MI_STYLE', '' , 1441755.180000, 5104064.055000, 1483209.720000, 5149453.695000)

select VIEW_X_LL,VIEW_Y_LL,VIEW_X_UR,VIEW_Y_UR from MAPINFO.MAPINFO_MAPCATALOG

update MAPINFO.MAPINFO_MAPCATALOG SET  SPATIALTYPE  = 17.2, SPATIALCOLUMN = 'SP_GEOMETRY', DB_X_LL  = 1372628.910000, DB_Y_LL = 5082971.475000, DB_X_UR = 1554303.180000, DB_Y_UR = 5240800.275000, COORDINATESYSTEM = 'Earth Projection 8, 117, "m", 173, 0, 0.9996, 1600000, 10000000 Bounds (-30000000, -15000000) (30000000, 15000000)', SYMBOL = '', XCOLUMNNAME = 'NO_COLUMN', YCOLUMNNAME = 'NO_COLUMN', RENDITIONTYPE = 1, RENDITIONCOLUMN = 'MI_STYLE', RENDITIONTABLE = '', VIEW_X_LL  = 1441755.180000, VIEW_Y_LL = 5104064.055000, VIEW_X_UR = 1483209.720000, VIEW_Y_UR = 5149453.695000 where  TABLENAME  =  'ParcelPrim' and OWNERNAME =  'dbo'

ParcelPrim has been added to the to the MAPINFO.MAPINFO_MAPCATALOG

Upload complete for table NZTM_ParcelPrim
52917 records inserted
    Elapsed time: 00:01:32


1 table(s) uploaded successfully.
	Elapsed Time: 00:01:32
 Date: 2/23/2018  Time: 6:48:32
select 1 from MAPINFO.MAPINFO_MAPCATALOG

select count(*) from MAPINFO.MAPINFO_MAPCATALOG