spatialite-sys 0.2.0

SQLite format 3�

@  %%
%-�#
y�`~�}�{�y�y�xxx
s

vK%%
[tablesqlite_stat1sqlite_stat1CREATE TABLE sqlite_stat1(tbl,idx,stat)�##
�]tableCenterlinesCenterlinesCREATE TABLE Centerlines(PRIMARYINDEX INTEGER PRIMARY KEY, Geometry BLOB, ACCURACY_STATUS TEXT, ACCURACY_STATUS_V TEXT, BKCL TEXT, BKCL_V TEXT, END_INT INTEGER, LANES REAL, MAP_CLASSNAME TEXT, MAP_LABEL TEXT, MAP_MAPTIP TEXT, SEG_CLASS TEXT, SEG_CLASS_V TEXT, SEG_DIREC TEXT, SEG_ID REAL, SEG_JURIS TEXT, SEG_LENGTH REAL, SEG_OWNER TEXT, SEG_OWNER_V TEXT, SEG_SURF TEXT, SEG_SURF_V TEXT, SEG_TYPE TEXT, SEG_TYPE_V TEXT, SEG_WIDTH INTEGER, START_INT INTEGER, STR_CODE TEXT, STR_RNAME TEXT)�X//
�_tableAssessmentParcelsAssessmentParcelsCREATE TABLE AssessmentParcels(PRIMARYINDEX INTEGER PRIMARY KEY, Geometry BLOB, FOLIO TEXT, GISLINK INTEGER, HOUSE INTEGER, LEGAL_ID TEXT, LEGAL_LONG1 TEXT, LEGAL_LONG2 TEXT, LEGAL_TYPE TEXT, LOT_DESC TEXT, LOT_SIZE TEXT, LSTATUS TEXT, LSTATUS_V TEXT, NOTE TEXT, PLAN TEXT, PLAN_NUMBER TEXT, POSTAL_CODE TEXT, PRCL_KEY TEXT, PRCL_TYPE TEXT, PRCL_TYPE_V TEXT, STREET TEXT, UNIT TEXT, WSTATUS TEXT, WSTATUS_V TEXT, ZONING TEXT)�P%%
�ctableHouseNumbersHouseNumbersCREATE TABLE HouseNumbers(PRIMARYINDEX INTEGER PRIMARY KEY, Geometry BLOB, TEXT_HALIGN INTEGER, TEXT_HEIGHT REAL, TEXT_LABEL TEXT, TEXT_ROTATION REAL, TEXT_VALIGN INTEGER)�E--
�=tablegeometry_columnsgeometry_columnsCREATE TABLE geometry_columns (f_table_name TEXT,f_geometry_column TEXT,geometry_type INTEGER,coord_dimension INTEGER,srid INTEGER,geometry_format TEXT)�
++
�qtablespatial_ref_sysspatial_ref_sysCREATE TABLE spatial_ref_sys(srid INTEGER PRIMARY KEY,sr_name TEXT, auth_name TEXT,auth_srid INTEGER,srtext TEXT )

~Q~Q�,
�GUTM83-10PROJCS["NAD_1983_UTM_Zone_10N",GEOGCS["GCS_North_American_1983",DATUM["D_North_American_1983",SPHEROID["GRS_1980",6378137,298.257222101]],PRIMEM["Greenwich",0],UNIT["Degree",0.017453292519943295]],PROJECTION["Transverse_Mercator"],PARAMETER["False_Easting",500000],PARAMETER["False_Northing",0],PARAMETER["Central_Meridian",-123],PARAMETER["Scale_Factor",0.9996],PARAMETER["Latitude_Of_Origin",0],UNIT["Meter",1]]
���� #


CenterlinesGeometry
FGF&/


AssessmentParcelsGeometry
FGF!
%


HouseNumbersGeometry

FGF
~���j?~�(�<



ffffVEA M�TA980
g
(�
<



����PEA�3�TA870
g
(�<



3333OEA��̌.�TA830
g
(�<



����SEA`8�TA882
g
/�<



ffffDEA������TA1150@E-�@
6�q<


ffff*IA���Yo�TA@���1121@vl�

pd~�}�|R{?z/yx
v�u�t�s�r�qwpd��8�\�#%'

�G�L=Afff�.�TA����Q=Afffv7�TA=
ף=Aq=
�7�TA\���=Aq=
�.�TA�G�L=Afff�.�TA83852.000
�
�106253LOT 13, BLOCK 3, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH50.00 115.002039V9S 1R6HUNTER STREETRS-1A��4�\�#%'

q=
׉=A\�•.�TA�(\��=AfffV7�TA����Q=Afffv7�TA�G�L=Afff�.�TAq=
׉=A\�•.�TA83851.000
�
�106250LOT 12, BLOCK 3, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH50.00 115.002039V9S 1R6HUNTER STREETRS-1A�'�3�\�5#%-

����HA���i0�TA��QHAR�e5�TA�z��GAfff�5�TA�GA�G�0�TA����HA���i0�TA84915.000
�105475LOT 21, DISTRICT LOT 96-G, NEWCASTLE RESERVE, SECTION 1, NANAIMO DISTRICT, PLAN 7828LANDWIDTH/DEPTH65.50  99.007828V9S 5E2CHURCHILL AVENUERS-1A��1�\�#%'

)\���=AR�u.�TAR���=A\��57�TA�(\��=AfffV7�TAq=
׉=A\�•.�TA)\���=AR�u.�TA83850.000
�	�106249LOT 11, BLOCK 3, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH50.00 115.002039V9S 1R6HUNTER STREETRS-1A��.�\�	#%'

��Q�>AH�zT.�TA
ףp>AR�7�TAR���=A\��57�TA)\���=AR�u.�TA��Q�>AH�zT.�TA83849.000
��106248LOT 10, BLOCK 3, DISTRICT LOT 96G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH50.00 115.002039V9S 1R6HUNTER STREETRS-1A��,�\�	#%'

����@>A=
�3.�TAffffE>AR��6�TA
ףp>AR�7�TA��Q�>AH�zT.�TA����@>A=
�3.�TA83848.000
��106246LOT 9, BLOCK 3, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH50.00 115.002039V9S 1R6HUNTER STREETRS-1A��+�\�1%-

�(\��HA{�0�TA{�G�HA3335�TA�p=
HHA��(L5�TA��QEHA
ףP0�TA�(\��HA{�0�TA84918.000
�105474LOT 2, DISTRICT LOT 96G, NEWCASTLE RESERVE, SECTION 1, NANAIMO DISTRICT, PLAN 7837LAND65.50 111.007837V9S 5E1CHURCHILL AVENUERS-1A��&�\�#%'

�p=
�>A=
��-�TA�z��>Aq=
�6�TAffff�>Aq=
�6�TA��Q��>A=
�.�TA�p=
�>A=
��-�TA83918.000
�z106244LOT 16, BLOCK 8, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH52.00 115.002039V9S 1R5HUNTER STREETRS-1A��$�\�	#%'

��(\?AH�z�-�TA?A{��6�TA�z��>Aq=
�6�TA�p=
�>A=
��-�TA��(\?AH�z�-�TA83917.000
�p106242LOT 15, BLOCK 8, DISTRICT LOT 96G, NANAIMO DISTRICT, PLAN 2039LANDWidth/Depth52.00 115.002039V9S 1R5HUNTER STREETRS-1A�� �\�#'

�z�N?AH�z�-�TA��QS?A{�w6�TA?A{��6�TA��(\?AH�z�-�TA�z�N?AH�z�-�TA83915.001
��f128492LOT 14, BLOCK 8, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH52    1152039V9S 1R5HUNTER STREETRS-1A���\�#%'

�p=
�?AR��-�TA=
ף�?A{�W6�TA��QS?A{�w6�TA�z�N?AH�z�-�TA�p=
�?AR��-�TA83915.000
��\106239LOT 13, BLOCK 8, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH52.00 115.002039V9S 1R5HUNTER STREETRS-1A�@���+#''

����?A��Q86�TA=
ף�?A{�W6�TA�p=
�?AR��-�TA��(\�?A\��u-�TA�z�@A\��U-�TAףp=@A��Q6�TA����?A��Q86�TA83914.000
��R106237LOTS 11 & 12, BLOCK 8, DISTRICT LOT 96G, SECTION 1, PLAN 2039, NANAIMO DISTRICTLANDWIDTH/DEPTH104.00 115.002039V9S 1R5HUNTER STREETRS-1A�;���#'/

�z�@A\��U-�TAL@Afff6-�TA�@AH�z-�TAR���@Aq=
�5�TA�(\�P@A����5�TAףp=@A��Q6�TA�z�@A\��U-�TA83912.000
Ʋk116402LOTS 9 AND 10, BLOCK 8, DISTRICT LOT 96-G, NANAIMO DISTRICT, PLAN 2039LANDWIDTH/DEPTH115.00 107.002039V9S 4Z5SUNDERLAND AVENUERS-1A�'��\�3#%-

��Q�DA�Q��.�TA��Q��DA�(\�3�TA�Q�gDA=
��3�TA�z�dDA)\�B/�TA��Q�DA�Q��.�TA85749.000
� o107296LOT 1, DISTRICT LOT 96G, NEWCASTLE RESERVE, SECTION 1, NANAIMO DISTRICT, PLAN 14412LANDWidth/Depth60.00 108.0014412V9S 5B4MILLSTONE AVENUERS-1A
w
~�}�|�{�z�y�x	w
�{�cd!5
#�#3333�@A�����TA3333�>Afff��TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALDUFFERIN STDUFFERIN ST
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL
r@b�]�_�CITYCityPAVEDPavedSINGLESingle Lane�360��]�$!5
#�#����
CA ��TA3333CA������TAffff�BA������TA�BA3333��TA�����BA333��TA���̶BAfff��TAffff�BA`��TAhBA������TA����4BA333��TABAfff���TA�����AA���ٱ�TA3333�@A�����TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALDUFFERIN STDUFFERIN ST
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL
l@g��1�ACITYCityPAVEDPavedSINGLESingle Lane�360��!d!5
)�#�����@A�����TA�����@Afff���TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALSUNDERLAND AVESUNDERLAND AVE
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL�@V�/��CITYCityPAVEDPavedSINGLESingle Lane�1087�� �!5
)�#�����@Afff���TA�����@A333~�TAffff�@A n�TAORTHOPHOTOORTHOPHOTO REFERENCEZLOCALSUNDERLAND AVESUNDERLAND AVE
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL�@VjT��*OCITYCityPAVEDPavedSINGLESingle Lane�1087��d!5
)�#ffff�@A n�TA�����@AfffFW�TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALSUNDERLAND AVESUNDERLAND AVE
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL�@V�&؀`oCITYCityPAVEDPavedSINGLESingle LaneZ1087�vfd!5
�
#�����CA��̬��TA����
CA ��TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALOAKLEY STOAKLEY ST
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCALk@FD�j8�@CITYCityPAVEDPavedSINGLESingle Lane�828�,d!5
'!�9';
#3333NA���99�TA�KA����:�TAORTHOPHOTOORTHOPHOTO REFERENCE�NEIGHBOURHOODCYPRESS STCYPRESS ST
CLASS: NEIGHBOURHOOD COLLECTOR
OWNER: City
TYPE: Single Lane
SURFACE: PavedNEIGHBOURHOODNEIGHBOURHOOD COLLECTOR@dy+�CITYCityPAVEDPavedSINGLESingle Lane!�318�	�!5
!�
#�KA����:�TA����tJA��̬;�TA����EJA����;�TAORTHOPHOTOORTHOPHOTO REFERENCE�LOCALCYPRESS STCYPRESS ST
CLASS: LOCAL
OWNER: City
TYPE: Single Lane
SURFACE: PavedLOCALLOCAL@S�W�C��CITYCityPAVEDPavedSINGLESingle Lane�318
������+spatial_ref_sys1-geometry_columns3%HouseNumbers6/AssessmentParcels14
#Centerlines8