IpjU 3SSKrSSKrSSKrSSKrSSKrSSKJrJrJrJrJ r SSK J r SSK J r SSKJr SSKJr SSKrSSKJrJrJrJrJrJrJr SSKJrJrJrJ r J!r!J"r"J#r#J$r$J%r%J&r&J'r'J(r( SS K)J*r*J+r+J,r,J-r- SS K.J/r/J0r0J1r1 SS K2J3r3J4r4 SS K5J6r6J7r7J8r8J9r9J:r:J;r;Jr>SSK?r@SSKArBSS KCJDrD SSKEJFrFJGrGJHrHJIrIJJrJJKrK SSKLrLSSKMJNrN SSKOJPrP SSKQJRrRJSrS \>R"S5 \V"5rW\S:a\4R"S/5r4\V"SS9rW\>R"SS\>R"S\R"SS9S5r\\RS5r^Sr_\>RRS S!\>R"S"S\RR\R"5R5S&:HS'S(9S)5rfS*rgS+rh\>RRS,S-/SS.4/SS4/5S/5ri\>RRS0S1S2/S3/S49S55rjS6rkS7rlS8rmS9rn\>RR\ (+=(a S:\"5;S;S(9S<5roS=rpS>rq\>RRS?S/S@//5SA5rrSBrs\>RRS?S/SCSD//5SE5rt\>RRt\>RR\8(+SFS(9SG55ru\>RRtSH5rv\>RRSI5\>RRtSJ55rx\>RRSKSS/5\>RRSLSS/5SM55ry\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRSKSS/5\>RRSLSS/5\>RRtSP5555rz\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRSKSS/5\>RRSLSS/5\>RRSQ5\>RRtSR55555r{\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRSKSS/5\>RRSLSS/5\>RRSI5\>RRtSS55555r|\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRSKSS/5\>RRSLSS/5\>RRSI5\>RRtST55555r}\>RRSU\"SVSWSWSXSSWSY5\"SVSZSWS[SSWSY5\R/\"SVSWSWSXSSWSY\ "\"SWS\95S]9\"SVSZSWS[SSWSY5\R//5\>RRt\>RR\(+S^S(9S_555r\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRS`\BGR"Sa5\BGR"Sb5\R4\GR"Sa5\GR"Sb5\R4/5\>RRSKSS/5\>RRSLSS/5\>RRSI5\>RRtSc555555r\>RRSN\6Vs/sH oSO:wdM UPM sn5\>RRSKSS/5\>RRSLSS/5\>RRtSd5555r\>RRt\>RRSe/SfQ5Sg55rShrSirSjrSkrSlrSmr\>RRSn/SoQ5Sp5r\>RRSqSr/4SsStSu/4SvSw/4/5Sx5rSyrSzr\>RRS{S|SS/S}.S~S/5S5rSr\>RRS\LR"SS5Sw/4\LGR""SSSS[5StSu/4\LGR$"SS/SS/SS/SS/SS/SS/45/SQ4\LGR&"\LR"SS5\LGR""SSSS[5/5/SQ4/5S5rSrSr\>RRS/SQ\GR."/SQ\GR0S9/5S5r\RR\S:SS(9S55rSr\>RRSS[S/5S5rSr\>RRS/SQ5\>RRSS[S/5S55rSrSrSrSrSrSrSr\;\>RRS3\6Vs/sH oS:wdM UPM snS3/S49S55r\;\>RRS3S/S3/S49S55r\>RRS S!\>R"S"S\:S9S#S$/5S5r\>RRS/SQ5\>RRtS55r\>RRSN\65\>RRtS55r\>RRS5\>RRSSS/5\>RRSN\6S/-Vs/sH oS:wdM UPM sn5\>RRtS5555r\>RRtS5r\>RRSN\6Vs/sH oS;dM UPM sn5\>RRS/S4S/\GR04S/\GR\4S/\4/5\>RRtS555rSr\>RRtS5r\>RRSSS/SWS//5\>RRSN\65\>RRtS555r\>RRS/SQ5\>RRtS55r\>RRSNSS/5\>RRtS55r\>RRtS5r\>RRSN\65\>RRtS55r\>RRSSS/5\>RRtS55r\>RRtS5rSr\>RRtS5r\>RRSSSS/S4SSS/S4SSSS/S4SSSS/S4SSS/S4SSSS/S4/5\>RRtS55r\>RRSSSSS/S4SSSSS/S4SSSSS/S4SSSSS/S4SSSSS/S4SSS|SS/S4SSSS/S4SSSSS/S4SSSS/S4SSSS/S4SSSS/S4SSS|S/S|4SSSS/S4SOSSSS/S4SOSSSS/S4SOSSSS/S4SOSSSS/S4SOSSSS/S4/5\>RRtS55r\>RRS/SQ5\>RRtS55r\>RRtS5r\>RRSN\6Vs/sH oSO;dM UPM sn5\>RRtS55r\>RRtS5r\>RRSN\6Vs/sH oS;dM UPM sn5\>RRSS\LR"SWSW5/\LR"SWSW5S/S\LR"SWSWS5/SS//5\>RRtS555r\>RRS5\>RRt\=S555r\>RRSN/SQ5\>RRtS55rSr\>RRtS5r\>RRSSS\R//SQ\"S5\"S5S/\"SSWSW5\"SSS5S/\"SSWSWS\ GRS]9\"SSSSZ\ GRS]9S//SQSS/SS/S//SQ\ "SW5\ "S5// 5\>RRSNS/5\>RRtS555r\>RRtS5r\>RRSSSS/4SGSGS/4GSGSGS/4GSGSGS/4GSGS GS /4GS GS GS /4GSGSGS/4/5\>RRtGS55r\>RRSN\65\>RRGSGSSSS/4GSGSSS/4GSGSSGS/4GSGSSGS/4GSGS SGS/4GSGS SGS /4GSGSSGS/4GSSSSGS/4GSSSSS/4GSSSSS/4GSSSGSS/4/ 5\>RRtGS 555r\>RRGS!/GS"Q5\>RRGS#5GS$55rGS%rGS&rGS'rGS(r\>RRtGS)5r\>RRGS*/GS+Q5\>RRtGS,55r\>RRGS*GS-GS./5\>RRGS/SWS0GS0S0GS0SW0/5\>RRtGS1555r\>RRGS*GS-GS./5\>RRtGS255r\>RR\$(+GS3S(9GS45r\<\>RR\GS5:GS6S(9\>RRSN\65GS7555r\<\>RR\GS5:GS6S(9\>RRSN\65GS8555r\RRt\>RRGS:S:GS;/5\>RR\ (+=(a S:\"5;S;S(9GS<555r\>RRGS=5\>RRGS>GS?GS@/5GSA55rGSBr\>RRGS>SGSC/5GSD5r\>RRGS>GS?GS@/5GSE5rGSFrGSGr\>RRSNGSHGSI/5GSJ5r\<\>RRSNGSHGSI/5GSK55rGSLrGSMrGSNrGSOr\>RRtGSP5r\>RRt\>RRS:\"5;GSQS(9GSR55r\>RRtGSS5r\>RRtGST5r\>RRt\>RR\8(+SFS(9GSU55rg!\Ta GNqf=fs snfs snfs snfs snfs snfs snfs snfs snfs snfs snfs snf(VN)datedatetimetime timedeltatimezone)Decimal)BytesIO)Path)ZipFile)__gdal_version__ list_drivers list_layers read_infoset_gdal_config_options vsi_listtree vsi_unlink) GDAL_GE_37 GDAL_GE_311 GDAL_GE_312 GDAL_GE_314HAS_ARROW_WRITE_API HAS_PYARROW HAS_PYPROJ PANDAS_GE_15 PANDAS_GE_22 PANDAS_GE_23 PANDAS_GE_30 SHAPELY_GE_21)DataLayerErrorDataSourceError FeatureError GeometryError) PANDAS_GE_20read_dataframewrite_dataframe)DRIVERS_NO_MIXED_DIMENSIONSDRIVERS_NO_MIXED_SINGLE_MULTI)ALL_EXTSDRIVERSGDAL_HAS_PARQUET_DRIVER START_FIDrequires_arrow_write_apirequires_gdal_geosrequires_pyarrow_apirequires_pyproj)from_wkt) is_bool_dtypeis_datetime64_dtypeis_float_dtypeis_integer_dtypeis_object_dtypeis_string_dtype)Point)assert_geodataframe_equal)assert_index_equalassert_series_equal geopandaszESRI ShapefileF)PROMOTE_TO_MULTIsessionT)marks)scopeparamscUR$N)param)requests [/var/www/html/pdf-tiff/venv/lib/python3.13/site-packages/pyogrio/tests/test_geopandas_io.py use_arrowrI]s ==)autousecSUR;aURS5OSnU(aO[(a [(d8URR S5(a[ R"S5 gggg)NrIFr,z2GDAL>=3.8 and pyarrow required for Arrow write API) fixturenamesgetfixturevaluerrnodeget_closest_markerpytestskip)rGrIs rHskip_if_no_arrow_write_apirShsl '.. .  ,  $$ LL + +,F G G HI H*5 rJc## [RRSS5nS[RS'Sv U(aU[RS'g[RS g7f)NPYOGRIO_USE_ARROW1)osenvironget)originals rHuse_arrow_contextr[ysKzz~~148H&)BJJ"# *2 &' JJ* +sA%A'c[USSS9ng)z?Check if SpatiaLite is available by running a simple SQL query.zselect spatialite_version();SQLITE)sql sql_dialectN)r$)test_gpkg_nulls_s rHtest_spatialite_availablerbs; ArJzencoding, arrow)utf-8Frc)cp1252F)NFcUS- n[USUS9nURS5 URS5 SSS5 [X1US9n[U5S:XdeURR 5S S /:XdeUR R 5S /:XdeURR 5S /:Xdeg!,(df  N=f) zW"Test reading CSV files with different encodings. Arrow only supports utf-8 encoding. test.csvwencoding näme,city Wilhelm Röntgen,Zürich NrirInämecityZürichWilhelm Röntgen)openwriter$lencolumnstolistronäme)tmp_pathriarrowcsv_pathcsvdfs rHtest_read_csv_encodingr}s *$H hh /3 .! ./ 0 u EB r7a<< ::   7F"3 33 3 77>>  { ** * 88?? !3 4 44 4 0 /s #B<< C zUTF-8z(test requires non-UTF-8 default platformreasoncFUS- n[US[R"5S9nURS5 URS5 SSS5 U(a,[R "[ SS9 [X!S 9nSSS5 g[X!S 9n[U5S :XdeURR5S S /:XdeURR5S /:XdeURR5S/:Xdeg!,(df  N=f!,(df  g=f)zVerify that read defaults to platform encoding; only works on Windows (CP1252). When use_arrow=True, reading an non-UTF8 fails. rfrgrhrjrkNz; please use_arrow=FalsematchrIrmrnrorprq) rrlocalegetpreferredencodingrsrQraisesr r$rtrurvrorw)rxrIrzr{r|s rHtest_read_csv_platform_encodingrs*$H hf&A&A&C D .! ./ E ]] ,  >B   H :2w!||zz  "w&7777ww~~I;...xx %7$8888! E D   s#D/ D D D c[U5n[(aURS:Xde[U5S:XdeURR 5/SQ:Xdeg)N EPSG:4326)pop_est continentnameiso_a3 gdp_md_estgeometry)r$rcrsrtrurv)naturalearth_lowres_all_extr|s rHtest_read_dataframersX 3 4Bzvv$$$ r7c>> ::   #  rJc@[USUS9n[U5S:Xdeg)Nrmrrr$rt)naturalearth_lowres_vsirIr|s rHtest_read_dataframe_vsirs$ /2i HB r7c>>rJzcolumns, fid_as_index, exp_len)NFr=r=cz[UUUUS9n[U5[RLde[ U5U:Xdeg)N)ru fid_as_indexrI)r$typepd DataFramert)no_geometry_filerurrIexp_lenresults rH test_read_layer_without_geometryrsD ! F <2<< '' ' v;' !! !rJz!naturalearth_lowres, expected_ext).gpkgr).shprnaturalearth_lowres)indirectc`URU:Xde[U5n[U5S:Xdeg)Nr)suffixr$rt)r expected_extr|s rH test_fixture_naturalearth_lowresrs3  % % 55 5 + ,B r7c>>rJc[XSS9n[U[R5(de[U[R 5(aeg)NFrI read_geometry)r$ isinstancerrgp GeoDataFramerrIr|s rHtest_read_no_geometryrsD # B b",, ' '' '"boo... ..rJc [R"[SS9 [U/SSUS9nSSS5 g!,(df  g=f)Nz^at least one of read_geometry or return_fids must be True or columns must be None or non-emptyrFrurrrIrQr ValueErrorr$)rrIras rH(test_read_no_geometry_no_columns_no_fidsrsA  #        s1 ?cTUS- n[R"[SSS5[SSS5/SS9n[X25 [ U5nUR SR R(de[ USSUS9nUR SR R(aeg)N test.gpkgrrmrrrT)force_2d max_featuresrI)rrr7r%r$ilocrhas_zrxrIfilenameexpectedr|s rHtest_read_force_2drs+%H1a.%1a.1{HH'  !B 771:   $ $$ $   B wwqz""((( ((rJc[SS05 [R"[SS9 [ XS9 SSS5 [SS05 g!,(df  N=f![SS05 f=f)NOGR_GEOJSON_MAX_OBJ_SIZEg{Gz?z:Failed to read GeoJSON data; .* GeoJSON object too complexrr)rrQrr r$)naturalearth_lowres_geojsonrIs rHtest_read_geojson_errorr'sdD!;T BC ]] O  6 L  !;T BC   !;T BCs!&A AA AAA(LIBKMLzINeeded GDAL driver (version) not available to read .kml attribute columnscj[XS9nSUR;deUSRSS:Xdeg)zTest reading a .kml file with an attribute column. Attribute columns (="Simpledata" elements in the .kml) can be read with the "LibKML" driver or with the "KML" driver starting from GDAL 3.14 r formationrTonN)r$rur)kml_filerIgdfs rHtest_read_kml_simpledatar3s@  7C #++ %% % {   #u ,, ,rJcUS- n[R"[SS5/SS9nU(a URR S5Ul[ UUSS9 [R"[SS5/SS9nU(a URR S5Ul[ XBS S S 9 [ R"[U5SS /S S //5(deUSS .n[R"[SS9 [U40UD6nSSS5 [WU5 [U4SS 0UD6n[Xd5 [U4SS0UD6n[Xd5 g!,(df  NM=f)Nrrrrstrlayer1)layerrmlayer2T)rappendr7)rIrzMore than one layer foundrr)rrr7ruastyper%np array_equalrrQwarns UserWarningr$r8)rxrIr expected1 expected2kwargsr|s rHtest_read_layerrDsO+%H%1+KHI&--44U;  %1+KHI%--44U; IxE >>H7 3h5HI   %a 8F k)D E H / / Fb),  ; ;F ;Bb,  4 4V 4Bb, F Es 5 E  Ec[R"[SS9 [USUS9 SSS5 g!,(df  g=f)Nz!Layer 'wrong' could not be openedrwrongrrI)rQrrr$rrIs rHtest_read_layer_invalidrps+ ~-P Q2'YW R Q Q / =rucolc[XUS9nUbSU;aSUR;de[URR5(de[ (a'URRR S:XdegURRR S:Xdeg[UR5S:Xdeg)N)rurIrdatetime64[ms]datetime64[ns]rm)r$rur2rdtyper#rrt) datetime_filerurIr|s rHtest_read_datetime_columnsrus  ) LB%7* """"266<<0000 <66<<$$(88 8866<<$$(88 882::!###rJcR URS:Xa![(d[R"S5 [ U5nURn[ XS9nSUR ;deUSSS:XdeUSSS;deUSS R5S S/:XdeUSSR5S S /:XdeUSS R5/:XdeUSS beUSS beSUR ;deUSS S:XdeUSS S:XdeUSS R5SS/:XdeUSSR5SS/:XdeUSS R5/:XdeUSS beUSS beSUR ;deUSS S:XdeUSS S:XdeUSS R5SS/:XdeUSSR5/SQ:XdeUSS R5/:XdeUSS beUSS S/:XdeUS:Xa SnSnS S /nO"SnSnU(aS[R/nOS S /nSUR ;deUSS S:XdeUSS U:XdeUS S U:XdeUSS S S :XdeUSS :XaUSS SUS:XdeO&[R"USS S5(deUS:XaUSSS S /:XdeUSS /:XdeO:USSR5S S /:XdeUSS R5/:Xde[R"USS 5(de[R"USS 5(deUS:XaSnSnOSnSnS!UR ;deUSS"S!:XdeUSS"U:XdeUS S"U:XdeUS:Xa/US!S SS /:XdeUS!S/SQ:XdeUS!S /:XdeOeU(dSS/OSS /nUS!S R5U:XdeUS!SR5/SQ:XdeUS!S R5/:Xde[R"US!S 5(deUS!S S/:Xdeg )#9Test reading a geojson file containing fields with lists..parquetESkipping test for parquet as the GDAL Parquet driver is not availablerlist_intfieldsrm ogr_types)OFTIntegerListOFTInteger64Listrr=N list_double OFTRealListg?@@ list_string OFTStringListstring1string2)string3string4r.geojson OFTStringOFSTJSONrOFSTNonelist_int_with_null ogr_subtypeslist_string_with_null) rr*rQrRrr$rurvrnanrisna) list_field_values_filesrIinforrexp_type exp_subtypeexp_list_int_with_null_value exp_values rHtest_read_list_typesrsD%%3!  ** *  Q #I II I * a ' ' )aV 33 3 * a ' ' )aV 33 3 * a ' ' )R // / * a (( ( * a (( ( FNN ** * >!  -- -  Q = 00 0 -  # * * ,c :: : -  # * * ,c :: : -  # * * , 22 2 -  # ++ + -  # ++ + FNN ** * >!  -- -  Q ? 22 2 -  # * * ,I0F FF F -  # * * ,0J JJ J -  # * * , 22 2 -  # ++ + -  #t ++ +  ()4y$& ,/= (,-q6 ( 6>> 11 1 >!  4 44 4  Q 8 ++ +   "k 11 1 & ' *1 - 22 2#A&!+*+A.q15QRS5TTTTwwv23A6q9:::: *+A.1a&888*+A."444*+A.557Aq6AAA*+A.5572=== 776./2 3 33 3 776./2 3 33 3  # "fnn 44 4 >!  7 77 7  Q 8 ++ +   "k 11 1 -.q1i5FFFF-.q15OOOO-.q1R777,5YO9d:K -.q188:iGGG-.q188:>XXXX-.q188:b@@@ 7761215 6 66 6 ) *1 -" 55 5rJrrcURS:Xa![(d[R"S5 U(a^U(aW[ U5S:XaHURS:Xa8SnUR R [RRUS95 [XUS9nUcSO [ U5S -n[ UR5U:Xdeg) rrrrzyThis fails with 'pyarrow.lib.ArrowInvalid: ArrowArray struct has 1 children, expected 0 for type extension'r~rIruNrm) rr*rQrRrtrO add_markermarkxfailr$ru)rGr rIru error_msgr exp_columnss rHtest_read_list_types_columnsrs%%3>&,557)9L M MM M  '' ' *  # #v -- - * a ' ' )Y 66 6 * a ' ' )Y 66 6 * a ' ' )Y 66 6 6>> )) ) ,  % % // / ,  " ) ) +aa0@PQBR/S SS S ,  " ) ) +aa0@PQBR/S SS S ,  " ) ) +aa0@PQBR/S SS S 6>> )) ) ,  % % // / ,  "AA&6 66 6 ,  "AA&6 66 6 ,  "AA&6 66 6rJcS S[RS[4Sjjn[XS9nU"XBSS9 US- n[ XEUS9 [XRS9nU"XbSS9 g ) z=Test roundtripping a GeoJSON file containing many data types.Fr|rIcSUR;de[USR5(deUSR5S/:XdeSUR;de[ USR5(deUSR5S/:XdeSUR;de[ USR5(deUSR5S/:XdeSUR;de[ USR5(deUSR5S/:XdeS UR;deU(a\[US R5(deUS R5[R"S 5R5/:XdeOM[US R5(deUS R5[R"S 5/:XdeU(aU(a [(aVS UR;de[US R5(deUS R5[S S S 5/:XdeSUR;de[USR5(deUSR5[R"S5/:XdeSUR;deU(aU(a>[USR5(deUSS R5/SQ:XdeO-[ USR5(deUSS S:XdeSUR;deU(aU(a>[USR5(deUSS R5/SQ:XdeO-[ USR5(deUSS S:XdeSUR;deU(d0[USR5(deUSS /SQ:Xdeg[ USR5(deUSS S:Xdeg)zFunction to validate the data of many_data_types_geojson_file. Depending on arrow being used or not there are small differences. int_colrm float_colg?str_colstringbool_colTdate_colz 2020-01-01time_col r datetime_colz2020-01-01T12:00:00 list_int_colrz[1 2 3] list_str_col)rrcz ['a' 'b' 'c']list_mixed_col)rmrNTz[1, 'a', None, True]N)rur4rto_listr3r6r1r5r Timestamprr2rrrv)r|rI after_writes rHvalidate_resultDtest_roundtrip_many_data_types_geojson_file..validate_resultHs BJJ&&&9 3 34444)}$$&1#---bjj(((bo334444+&&(SE111BJJ&&&r)}223333)}$$&8*444RZZ'''R ^112222*~%%'D6111RZZ''' "2j>#7#788 88j>))+ \0J0O0O0Q/RR RR'r*~';';<< <<j>))+ \0J/KK KK +++ ++"2j>#7#788 88j>))+RA/?? ??+++"2n#5#;#;<<<<.!))+ =R0S/TTTT+++i"2n#5#;#;<< <<n%a(//1Y> >>"2n#5#;#;<< <<n%a(I5 55+++i"2n#5#;#;<< <<n%a(//1_D DD"2n#5#;#;<< <<n%a(O; ;;2::---"2&6#7#=#=>> >>&'*.BB BB#2&6#7#=#=>> >>&'*.DD DDrJr)r7zwritten.geojsonTN)F)rrboolr$r%)rxmany_data_types_geojson_filerIr8read_gdftmp_file read_back_gdfs rH+test_roundtrip_many_data_types_geojson_filer?Bsd AEBLLAETAEH:PHHU;++HH)<#8AMM$?rJz;ignore: Non-conformant content for record 1 in column datescSS/n[R"[R"U5SS9nURR S5nURR S5n[ (aURRS5ngg)N2023-01-01 11:00:01.1112023-06-01 10:00:01.111datesrAustralia/SydneyUTCms)rSeries to_datetimedt tz_localize tz_convertr#as_unit)rxrIrC naive_col localised_colutc_cols rH test_write_datetime_mixed_offsetrQsq '(A BE "../g>ILL,,-?@M))%0G|**$$T*rJdatetime_as_stringmixed_offsets_as_utcc [R"5nSnU(d9[(d.U(a [(a[R "[ SS9nSnOLU(aE[(d:[(d/[R"[[R"S5S9nSnU [UUUUS9n[R"S/SS 9nU(a=[UR R"5(de[%UR U5 OU(a=[UR R"5(de[%UR U5 O}['UR 5(deUR R(S [R*"S S S S S S 5:XdeUR R(S R,S:XdeSSS5 g!,(df  g=f)zTest writing/reading a column with a datetime far in the past. Dates from before 1678-1-1 aren't parsed correctly by pandas < 3.0, so they stay strings. Reported in https://github.com/geopandas/pyogrio/issues/553. Fz6Error parsing datetimes, original strings are returnedrTz8Casting from timestamp[ms] to timestamp[ns] would resultrIrRrSz1670-01-01T09:00:00r0rDrirm rGN) contextlib nullcontextrrrQrrr#r Exceptionreescaper$rrHr6r0rr:r2rr6unit)geojson_datetime_long_agorIrSrRhandleroverflow_occuredr| exp_dates_strs rHtest_read_datetime_long_agorasv$$&G llI ,, W   << -- ))VW     %1!5   #8"9O "2??#8#899 99  ? &r'<'<====#BOO]C+2??;;;;++A.",,tQ1aQR2SSSS++A.33t;;;/ s &D(G G%extrctSS[R/n[(a%[R"USS9R S5nO[R"U5n[ R"U[SS5/S-S.S S 9nUS U3- n[XxUS 9 [UUUUS 9n U(aUS:Xa[S:aURRRS5n U(aUU RS5R R#SS5n [RU S'[%U RU 5 gU(d[%U RU 5 ggU(a['U RR(5(deU(aS[S:aIURRS5R R#SS5n [RU S'O[R*"USS9n [%U RU 5 g[-U RR(5(de[/X5 g)zNTest writing/reading a column with naive datetimes (no time zone information).2020-01-01T09:00:00.123z2020-01-01T10:00:00ISO8601formatrGrmr=rCrrrtestrrUrr= rrFr TrrCrDN)rrr#rrIrMrrr7r%r$r rCrJrKrrreplacer:r6rrHr2r8) rxrbrRrSrI dates_rawrCr|fpathr exp_dates dates_strs rHtest_write_read_datetime_no_tzrts+,A266JI|y;CCDIy) eAqk]Q%67[ B cU| #EB3  -1 FSG^(8:(E HHKK++E2 !((/33;;CEI66IaL  i 8%  i 8& v||112222 )J6.22::3DI66IaL )':IFLL)4"6<<#5#56666!&-rJz6ignore: Non-conformant content for record 1 in column cU(aF[S:a<US;a6URR[RR SS95 SS[ R/n[(a%[R"USS9RS 5nO[R"U5n[R"U[S S 5/S -S ./S QSS9n[UR R"[R$5(deUSU3- n ['XUS9 [)U UUUS9n U R R"R*R-S5(a4U R R/UR R"5U lU(a~US;ax[S:anUR15n XR R35R R/[45U l[7U R U R SS9 gU(Ga[9U R R"5(deU(a][S:aSUR R/S5R4R;SS5n [ RU R<S'Oz[S:a[UV s/sH%n [R2"U 5(dM U SSPM' sn [ R/-n [R>"U SS 9n O[R>"USS 9n [7U R U SS9 g[7U R UR SS9 gs sn f)!zzWrite and read file with all equal time zones. This should result in the result being in pandas datetime64 dtype column. r= rr .geojsonlz:Wrong datetimes read in GeoJSON with GDAL < 3.10 via arrowr~2020-01-01T09:00:00.123-05:002020-01-01T10:00:00-05:00rerfrGrmr=rh)rrr=r)indexrrjrrU, pytz.FixedOffset(-300)].fgbrrkF) check_indexrrmrnrr=rrNrCrD) r rOrrQrrrrr#rrIrMrrr7rrCrDatetimeTZDtyper%r$rendswithrcopynotnarr:r6rorrH)rGrxrbrRrSrIrprCr|rqrdf_exprsxs rHtest_write_read_datetime_tzrs% 2s>W7W   KK  S   12MrvvVI|y;CCDIy) eAqk]Q%67  B bhhnnb&8&8 9 99 9 cU| #EB3  -1 F||''(CDD||**288>>: S--2BZ2Oll002399@@E FLL&,,EJ v||112222 )J6.22::3DI "INN1   ))2BAbhhqk3BBbffXMI )':I )':IFLL)GFLL"((F Cs 0M McSS[R/n[R"[R"U5SS9nUR R S5nUR[5nU(a_URRSS5n U RRSS 5n [S :aU RRS S 5n O[U(aBUR RS 5n [(aU R RS5n OURS5n [ R""U[%SS5/S-S.SS9n USU3- n ['XUS9 [)U UUUS9n U(Gar[S:GagUS;aUR RS 5n [(aU R RS5n U(aU[+U R,R.5(deU R[5RRSS5n [R0"U R,S5(de[3U R,R5S5U R5S55 gUS;a_[R0"U R,S5(de[3U R,R5S5UR5S55 gU(a'[+U R,R.5(deOcU(a6[7U R,R.[R85(deO&[;U R,R.5(de[R0"U R,S5(de[3U R,R5S5U R5S55 g)zLTest with localized dates across a different summer/winter time zone offset.rArBrCrDrErmrnz.111000z.111rrrrFrGch[R"U5(a[R"U5$S$rE)rrr6rs rHDtest_write_read_datetime_tz_localized_mixed_offset..zs !bll1o>$>rJrmr=rhrrirjrrUrkrxrNrr)rrrrHrIrJrKrrror slicerLr#rMapplyrrr7r%r$r6rCrrr:headrrr5)rxrbrRrSrIrp dates_naive dates_localdates_local_offsets_strrrr|rqr dates_utcs rH2test_write_read_datetime_tz_localized_mixed_offsetr^s+,ErvvNI))BNN95GDK..,,-?@K)005+//77SA MM)))V< i '! ++Ar2I NN--e4 <! ,,T2I+11 >  E!QK=1+<=; B cU| #EB3  -1 F% 2 + +$11%8I|%LL006 !&v||'9'9::::%,,S155==c3G 776<<?++ ++  1 1! 4innQ6G H  % %776<<?++ ++  1 1! 46M6R6RST6U V v||112222 &,,,,b.@.@AAAAv||112222 776<<? # ## # ))!,innQ.?@rJc[R"S5[R"S5[R/n[R "U[ SS5/S-S.SS9nUSU3- n[XgUS 9 [UUUUS 9nU(Ga6[S :Ga+US ;aUR5n [R"US S9U l [(a*U RRRS5U l U(a:U RR!S5R"R%SS5U l [R&U R(S'[+X5 gUS;aVUR5n U RR!S5U l [,(dSU R(S'[+X5 gU(a[/URR05(deURR3S5n [S:aU R"R5SS5n [7URU 5 gU(a[9URR0[R:5(de[R"URS S9n [(aU RRS5n [7URU 5 g[=URR05(de[+X5 g)z-Test with dates with mixed time zone offsets.z2023-01-01 11:00:01.111+01:00z2023-06-01 10:00:01.111+05:00rmr=rhrrirjrrUrkrxTutcrGrrmrnrrCNrcv[R"U5(aURSS9$[R$)N milliseconds)timespec)rr isoformatrrrs rHr;test_write_read_datetime_tz_mixed_offsets..s'bhhqkkakk>k:UrvvUrJrrr)rr6rrrrr7r%r$r rrIrCr#rJrMrrroNAlocr8rr6rmaprr:rrr5) rxrbrRrSrIrCr|rqrrrsrrs rH)test_write_read_datetime_tz_mixed_offsetsrsQ 45 45  E eAqk]Q%67[ B cU| #EB3  -1 F% 2 + +WWYF>>%T:FL|%||66t< !%||2259==EEc3O %'UUFJJz " %f 5  % %WWYF!<<..u5FL<)- :& %f 5 v||112222HHLL U  i '! ++Ar2IFLL)4 &,,,,b.@.@AAAANN2886 <! ,,T2IFLL)4v||112222!&-rJrCirmrlirwhourstzinfoz3before GDAL 3.11, datetimes weren't handled as wellc&[R"U[SS5/[U5-S.S[S9nUS- n[ X4US9 [ UUSSS9nUR5nUS RcX[R"URSS 9Ul [(a(URRRS 5US 'O[(a[ (dUR"SR%['[)SS95S9UR"S'[R"UR5US '[(a(URRRS 5US '[ (dS UR"S'[+XV5 g )zHTest writing a column with datetimes with and without time zone offsets.rmrhrrrrrFrUrNrrGrC)rmrCrrr)rrr7rtr#r%r$rrrrIrCr#rJrMrrrrorrr8)rxrCrIr|rqrexp_dfs rH(test_write_read_datetime_tz_offsets_NonersD, eAqk]SZ%?@  B { "EB3   " FWWYF Qx~~fll> <$lloo55d;F7O < %+ZZ %;%C%C  23&D&FJJz "!nnV\\:F7O|"(,,//"9"9$"?w W7W  ii6/FFF7O%llR\\-BBF7O|"(,,//"9"9$"?w!&1% 2s>O7O)) /1Lbff U w "&1v||112222 )J6 ii6/FFF7O!ii02MrvvVF7O )+"(,,"2"2"8"8B"?w &,,,,b.@.@AAAA6<<%%(()-TTTT&,,,,b.@.@AAAAf-rJcSS[R/n[(a%[R"USS9R S5nO[R"U5n[ R"U[SS5/S-S.S S 9nURRRS ;deUS U3- n[XxUS 9 [UUUUS9n U(aUS:Xa[S:aU(ac[U RR5(de[R "SS[R/SS9n [#U RU 5 g[#U RURR$R'S55 gU(a[U RR5(deU(aS[S:aIURR)S5R*R-SS5n [RU S'O;[R "USS9n [S:aU R*R-SS5n [#U RU 5 gU RRRS ;de[/X5 g)z1Test writing/reading a column with UTC datetimes.z2020-01-01T09:00:00.123Zz2020-01-01T10:00:00ZrerfrGrmr=rhrri)datetime64[ms, UTC]datetime64[ns, UTC]rjrrUrrkrdz2020-01-01T10:00:00.000rCrDNrrmrnrrZz+00)rrr#rrIrMrrr7rCrrr%r$r r6rHr:rJrKrrror8) rxrbrIrRrSrprCr|rqrrss rHtest_write_read_datetime_utcrs,-CRVVLI|y;CCDIy) eAqk]Q%67[ B 88>>  "P PP P cU| #EB3  -1 FSF]'7*'D "6<<#5#566 66 *,ErvvNI  i 8  bhhkk.E.Ed.K L v||112222 )J6.22::3DI66IaL )':I)+%MM11#u= FLL)4||!!&&*XXXX!&-rJzext, use_arrow, expected_result))rFerror)rF supported)ryFr)rFsecond_column_dropped)rTr)rTsecond_column_overwrites_first)ryTr)rTrc [R"SS/SS/[SS5[SS5/S.5n[R"USSS 9nUS U3- nUS :Xa-[ R "[S S 9 [XVUS9 SSS5 g[XVUS9 [XbS9nSUR;deSUR;deUS:Xa5S UR;de[USUSSS9 [US US SS9 gUS:Xa$[USUSSS9 S UR;degUS:Xa3[USUS RS5SS9 S UR;deg[SU<35e!,(df  g=f)aTest writing and reading a file with column names that only differ in casing. Probably never a good idea to use multiple columns with the same name but different casing, but at least this test documents the current behaviour. With arrow, this never seems to be supported. rmrr=rr)rCOLrrrrtest_duplicate_columnsrrrrNrrF check_dtyperrz$Unhandled value for expected_result=)rrr7rrrQrrYr%r$rur:renameAssertionError)rxrbrIexpected_resultr|rrrs rH#test_write_read_column_names_casingrs, A1vE!QKq!3MN B //"z{ CC23%88H'! ]]9E 2 CY ?3 CY7 H :F  '' ' FNN "" "+%&&&F5M2e9%HF5M2e9%H 3 3F5M2e9%HFNN*** < <F5M2e9+;+;E+BPUVFNN***DO3EFGG-3 2 s 2 E** E8cUS- n[R"SSS/05n[X25 [X!SS9nUSR 5R 5(deg)Nz!test_null_values_no_geometry.gpkgrFr)rrr%r$rallrs rHtest_read_null_valuesrs\==H||UT4L12HH' U KB e9>>    ! !! !rJcUSSS.n[U40UD6n[UR[R"SS55 [U4SS0UD6n[UR[R"SS55 [U4SS0UD6n[R "SS/SS 9nU[ UR- n[URU5 g) Nr)rI skip_featuresrrrFTr=fidrD)r$r9r|r RangeIndexIndexr+r)rrIrr| fids_expecteds rHtest_read_fid_as_indexr s$q! LF 3 >v >Brxxq!!45 3 R% R6 RBrxxq!!45 #    B HHaV%0MY:AABBMrxx/rJc[U/SSUS9nUce[U5S:Xde[UR5S:Xdeg)NFTrrr)r$rtrurrIr|s rHtest_read_fid_as_index_onlyr4sM   B >> r7c>> rzz?a  rJcZ[XSS9n[U5S:Xde[XSS9n[U5S:XdeURSRS:Xde[UUSS9n[U5S :Xde[[ URR 55R /S Q55S:Xde[UUS S9n[U5S :XdeURR5S :deURR5S:de[XSS9n[U5S:Xdeg)NrrIwhererziso_a3 = 'CAN'rmrCANziso_a3 IN ('CAN', 'USA', 'MEX')r=rUSAMEXz+POP_EST >= 10000000 AND POP_EST < 100000000K逖zISO_A3 = 'INVALID') r$rtrrsetunique differencerminmaxrs rHtest_read_whererAs3 3PR SB r7c>> #@P B r7a<< 771:   %% % #/ B r7a<< s299##%&112GH IQ NN N #; B r7b== ::>> x '' ' ::>> i '' ' #@T B r7a<1A B +  C B ]]:] ; +  < ; C B < ;s C. C C C!c@[USS/US9n[U5S:Xdeg)Nz "iso_a3" = 'CAN' r)rrurIrrrs rHtest_read_where_ignored_fieldrws. &  B r7a<rrwPANCRI)i67rcU(a.[S:a$URS:Xa[R"SS9 [ XUS9n[ R "URU5(deg)Nr=rrr3GDAL bug: https://github.com/OSGeo/gdal/issues/8347r~r)r rrQrr$rrr)rrIrrr|s rHtest_read_bboxrsR  y ( ' . .' 9 QR 3t TB >>"))X . .. .rJc[UUSSS9n[U5S:Xde[R"URS/5(deg)NL2ZDSELECT * from naturalearth_lowres where iso_a3 not in ('USA', 'RUS'))rIrr^rmrr$rtrrrrs rHtest_read_bbox_sqlrsG # ! R  B r7a<< >>"))eW - -- -rJc[UUSSS9n[U5S:Xde[R"URS/5(deg)Nriso_a3 not in ('USA', 'RUS'))rIrrrmrrrs rHtest_read_bbox_wherersG # !,  B r7a<< >>"))eW - -- -rJmaskr7)r coordinatesz({"type": "Point", "coordinates": [0, 0]}rc~[R"[SS9 [XUS9 SSS5 g!,(df  g=f)Nz+'mask' parameter must be a Shapely geometryrrIrr)rrIrs rHtest_read_mask_invalidr s+ z)V W*dK X W Wrc [R"[SS9 [UUS[R "SS5S9 SSS5 g!,(df  g=f)Nz!cannot set both 'bbox' and 'mask'rrrr)rIrr)rQrrr$shapelyr7rrIs rHtest_read_bbox_mask_invalidrs= z)L M "tR(   N M Ms "A Az mask,expectedrrrrrg@*3`h@gؒD|I@g@gu tI@g@NRd_@gmPBRI@g`}<@g hWI@g ΃ @g.WlI@)DEUBELNLDg5)rrIRLcU(a.[S:a$URS:Xa[R"SS9 [ XUS9n[ U5[ U5:Xde[ R"URU5(deg)Nrrrr~r ) r rrQrr$rtrrr)rrIrrr|s rHtest_read_maskrsiB  y ( ' . .' 9 QR 3t TB r7c(m ## # >>"))X . .. .rJc [UU[R"SSSS5SS9n[U5S:Xde[R "UR S/5(deg) Nrrrrr)rIrr^rmrr$r boxrtrrrrs rHtest_read_mask_sqlrsV # [[r4 , R  B r7a<< >>"))eW - -- -rJc [UU[R"SSSS5SS9n[U5S:Xde[R "UR S/5(deg) Nrrrrr)rIrrrmrrrs rHtest_read_mask_wherersV # [[r4 ,,  B r7a<< >>"))eW - -- -rJfids)rmrrwrc[XSUS9n[U5S:Xde[R"XRR 5(deg)NT)rrrIr=)r$rtrrr|values)rrrIr|s rHtest_read_fidsr sD #TY B r7a<< >>$ 0 00 0rJcSn[U5n[R"[SUS3S9 [ XSS9nSSS5 g!,(df  g=f)Nizerror applying filter for z fidsrTrrI)rangerQrrr$)rnb_fidsrras rH"test_read_fids_arrow_max_exceptionr%sDG >D z+EgYe)T U .T J V U Us ? A rz#GDAL >= 3.8.0 does not need to warncURS;a[R"[SS9nO[R "5nU [ US/SS9n[U5S:XdeSSS5 g!,(df  g=f)N)rrz=Using 'fids' and 'use_arrow=True' with GDAL < 3.8 can be slowrTr"rm)rrQrrrWrXr$rt)rr^r|s rH%test_read_fids_arrow_warning_old_gdalr(%se #))1FF,, Q  ((*  7rdd S2w!|| s A** A8cUS- n[R"[SSS5[SSS5/SS9n[X!5 [ US/S9n[ X2R SS5 [ USS/S9n[R"URR[R"UR SSRR55(deg) Nrrrmrr)rT)rr) rrr7r%r$r8rrrrrr r)rxrrr|s rHtest_read_fids_force_2dr*8s+%H1a.%1a.1{HH' s +Bb--"34 4qc :B >> G,,X]]2A->-G-G-N-NO   rJrc 8URn[U5RUSRSS9n[XUS9n[ U5[ U5:XdeUS;nUS:HnUS:Xa"U(dU/SQR S5U/SQ'[ UUUS U(+US 9 g) NTdroprrIrxryr+)rrrrFcheck_less_precisecheck_index_typer normalizerr$r reset_indexrtrr8)rrIrrbrr|is_jsonis_jsonss rHtest_read_skip_featuresr8Js % , ,C23 mn  $  #I B r7c(m ## #..Gk!HI/1 +/ &- *+ "K rJc[R"[SS9 [USUS9 SSS5 g!,(df  g=f)Nz'skip_features' must be >= 0rr/rrs rH test_read_negative_skip_featuresr;os+ z)G H*" R I H Hr)rrwr+rdc URn[U5RX3U-RSS9n[UUUUS9n[ U5[ U5:XdeUS;nUS:Hn[ U5S:XaLU(dEUSR S5US'US R S5US 'US R S5US '[ UUUS U(+US 9 g) NTr-)rrrIrxryrrr#rrFr0r4) rrIrrrbrr|r6r7s rHtest_read_max_featuresr>ts & , ,C23 ml: < $  ##!  B r7c(m ## #..Gk!H 8})!) 5 < = 0rr:)rrIrrs rHtest_read_negative_max_featuresr@s+ z)F G*yQ H G Grcr[R"[SS9 [SUS9 SSS5 [R"[SS9 [SUS9 SSS5 [R"[SS9 [SUS9 SSS5 g!,(df  Ng=f!,(df  NL=f!,(df  g=f)NzNo such file or directoryrznon-existent.shprz!does not exist in the file systemz/vsizip/non-existent.zipzzip:///non-existent.zip)rQrr r$rs rHtest_read_non_existent_filerBs .I J)Y? K .Q R1YG S .Q R0IF S R K J S R S Rs# B B2 B( B B%( B6cSn[XSUS9n[UR5S:Xde[U5S:XdeSn[XSUS9n[U5S:Xde[UR5S:XdeURS RS :XdeS n[XSUS9n[UR5S:Xde[U5S :XdeURR 5/S Q:XdeSn[XSUS9n[UR5S:Xde[U5S :XdeURR 5/SQ:XdeSn[XSUS9n[U5S:Xde[UR5S:XdeUR R5S:deUR R5S:deSn[XSUS9n[U5S :Xdeg)NGSELECT iso_a3 AS iso_a3_renamed, name, pop_est FROM naturalearth_lowresOGRSQLr^r_rIrr6SELECT * FROM naturalearth_lowres WHERE iso_a3 = 'CAN'rmrrrzdSELECT * FROM naturalearth_lowres WHERE iso_a3 IN ('CAN', 'USA', 'MEX')r=rzSELECT * FROM naturalearth_lowres WHERE iso_a3 IN ('CAN', 'USA', 'MEX') ORDER BY name)rrrzpSELECT * FROM naturalearth_lowres WHERE POP_EST >= 10000000 AND POP_EST < 100000000rrrz:SELECT * FROM naturalearth_lowres WHERE ISO_A3 = 'INVALID') r$rtrurrrvrrrrrIr^r|s rH test_read_sqlrIs TC #(i B rzz?a   r7c>> CC #(i B r7a<< rzz?a   771:   %% % 7C #(i B rzz?a   r7a<< 99   !6 66 6 C #(i B rzz?a   r7a<< 99   !6 66 6 CC #(i B r7b== rzz?a   ::>> x '' ' ::>> i '' ' GC #(i B r7a< >> >rJc Sn[UUSSS/SSUS9n[UR5S:Xde[U5S :XdeURR 5S S /:Xdeg) NrDrErOrz iso_a3_renamed IN ('CRI', 'PAN')r)r^r_rurrrIr=rrrrPrHs rH test_read_sql_columns_where_bboxrSst SC # !6*0  B rzz?a   r7a<<   # # %% 77 7rJc >Sn[UUSSSUS9n[UR5S:Xde[U5S:XdeURR 5S/:XdeSn[UUSSUS 9n[U5S:XdeSn[UUSSUS 9n[U5S :Xdeg) NzSELECT * FROM naturalearth_lowres WHERE iso_a3 IN ('CAN', 'MEX', 'USA') ORDER BY namermrE)r^rrr_rIrrz)SELECT * FROM naturalearth_lowres LIMIT 1r=)r^rr_rI)r^r_rrIr)r$rtrurrvrHs rHtest_read_sql_skip_maxrU"s C #   B rzz?a   r7a<< 99   % (( ( 5C #   B r7a<< 5C #   B r7a<D8#E  D D$' D58 E Ez ext, fid_column, fid_param_value))rrN)rFIDN).sqliteogc_fidN)r fid_customrl)r FID_customrl)rjogc_fid_customrnc<[R"US/0[R"SS5/SS9n0nUbX6S'USU3- n[ XW4SU0UD6 UR 5(de[ US US 9nUR5nURUS0S 9n [X5 g) aTest to specify FIDs to save when writing to a file. Saving custom FIDs is only supported for formats that actually store the FID, like e.g. GPKG and SQLite. The fid_column name check is case-insensitive. Typically, GDAL supports using a custom FID column for these file formats via a `FID` layer creation option, which is also tested here. If `fid_param_value` is specified (not None), an `fid` parameter is passed to `write_dataframe`, causing GDAL to use the column name specified for the FID. rrz epsg:4326rNrrjrIT)rrI)ru) rrr r7r%existsr$r5rr8) rxrb fid_columnfid_param_valuerI input_gdfrpath output_gdf expected_gdfs rHtest_write_custom_fidsrws. aSW]]1a%8$9{IF"'u SEl "DICyCFC ;;===49MJ'')J##Z,?#@Lj7rJc [U40[D6nUSU3- nUS:Xa [XEUSS9 O [XEUS9 UR5(de[U5nURR R 5n[U[;a[U5S/:XdeO[U5SS1:XdeUS;nUS :Hn [UUUSU(+U S 9 g) NrjrFrI spatial_indexr MultiPolygonPolygonrxryr0) r$ NE_KWARGSr%rprrrr)r'listrr8) rxrrbrIrs output_path result_gdfgeometry_typesr6r7s rHtest_write_dataframers2@i@ItC5\)K f} iu   )D       ,J((--446Ns|44N#'7777>"~y&AAAA..Gk!H"K rJzignore:.*No SRS set on layer.* write_geodf.xlsxrc [USS9nU(a[R"U5nUSU3- nUS:XaURS5nUS:wa [UOSn[ XgXXS9 UR 5(de[U5n [U [R5(deUS ;n US ;av[U [R5(ae[U[R5(a[R"U5n[RRXSU S 9 g [R"U[R"S [U55S S9n [U U SU S 9 g )zTest writing a (geo)dataframe without a geometry column. FlatGeobuf (.fgb) doesn't seem to support this, and just writes an empty file. F)rrjrz.dbfrXLSX)rIdriver)rryr)rrr)r2rNr)r$rr with_suffixr)r%rprrrtestingassert_frame_equalrrepeatrtr8) rGrxrrrbrIinput_dfrr result_dfrinput_none_geom_gdfs rHtest_write_dataframe_no_geomrsE1GH??8,tC5\)K f}!--f5 !G^WS\FHYN      {+I i . .. .??K ((i9999 h 0 0||H-H %% %[ & !oo ryys8}=4  "  "#  rJc[U5nURS5nUS- n[X4US9 [U5n[UR[ R 5(de[XSRSS95 g)Nrtest.shprTr-) r$ set_indexr%rr|rrr8r5)rxrrIrsrrs rHtest_write_dataframe_indexr8sp23I##H-IZ'KIi@ ,J j&& 6 66 6j*?*?T*?*JKrJryzcolumns, dtypecol_int col_float col_objectc[R"/X#SS9nUSU3- n[XVUS9 UR5(de[ XdS9n[ (aSOSnU(a U[ LaUSRS5US'[XuUS 9 g ) zTest writing dataframe with no rows. With use_arrow, object type columns with no rows are converted to null type columns by pyarrow, but null columns are not supported by GDAL. Added to test fix for #513. r)rrurrrjrTFrrr2N) rrr%rpr$r#r#rr8) rxrbrurrIrrr|r2s rHtest_write_empty_dataframerFs"GdSHD,&HH)< ??     6B ,|tUf_!),!7!>!>u!Eb=MNrJc[R"SS/0[S/5SS9nUS- n[R"5 [R "S[ 5 [(d[R"SS S 9 [X5 SSS5 UR5(de[U5n[X15 g!,(df  N<=f) Nrrz POINT EMPTYrrrrignorez'crs' was not provided.)message) rrr0warningscatch_warnings simplefilterrrfilterwarningsr%rpr$r8)rxrrr|s rHtest_write_empty_geometryrisaSzHm_4MSWXH+%H  "g{3z  # #H6O P+ # ??     !Bb+ # "s AB;; C c[R"SS/0[SS5/SS9nUS- n[X#US9 UR 5(de[ X1S9n[ (d4[(ad[RRR(a;U(a4URRS:XdeUSRS5US'O URR[:Xde[!XB5 g) zTest pandas object columns with all None values. With use_arrow, such columns are converted to null type columns by pyarrow, but null columns are not supported by GDAL. Added to test fix for #513. object_colNrrrrrr)rrr7r%rpr$rrroptionsfuture infer_stringrrrr#r8)rxrIrrrs rHtest_write_None_string_columnrzs //<$0E!QK=d SC+%HCY7 ??   >J "***;*;*H*H $$**e333 -44U;L$$**f444j.rJcategorical_datafoobarrc[R"U[SS5/[U5-S.SSS9nUR SS05nUSUU3- n[ XVS US 9 [ XcS 9nSUR;deUR5nUS ;a8[US5(a%USR [R5US'[Xx5 g )zWrite and read a GeoDataFrame with a categorical column. The categorical data type is not preserved when written to any of the tested file formats, but the data itself should be preserved. rcat_colrrrrrcategorytest_my_layerrrrxN) rrr7rtrr%r$rurr4rint32r8) rxrrbrI original_gdf category_gdfrtrrvs rHtest_write_read_categoryrs??'q! ,<(==   L && :'>?L i[. .DLjIND 6F  && & $$&L '',<\)=T,U,U".y"9"@"@"J Yf3rJ data_dtype)rr#floatc^[R"//S.SSS9RSU05nURSS05nUSUS3- n[XES US 9 [ XRS 9nSUR ;deUS ;a[ (a U(aS O[nOUnURSU05n[Xh5 g)zWrite and read a GeoDataFrame with an empty categorical column. This specific test was added because such columns gave an error with arrow, as reported in this issue: https://github.com/geopandas/pyogrio/issues/620. rrrrrrrrrrr)rr#rN) rrrr%r$rurr#r8) rxrrIrrrtrexpected_dtypervs rH!test_write_read_categorical_emptyrs //B'*+  fi $%::y*56L i[. .DLjIND 6F  && &&&".,9&#::y.9:Lf3rJz .geojsonsc[R"/SS9nUSU3- n[X4US9 UR5(de[R "[ SS9 [XBS9nSSS5 g!,(df  g=f)Nrrrjrz7 not recognized as( being in)? a supported file format.r)rrr%rprQrrYr$)rxrbrIrrras rH+test_write_read_empty_dataframe_unsupportedrso 5HD,&HH)< ??    S  8 9   s  A++ A9c4[U5nUS- n[UUSSUS9 UR5(de[R"[ U5SS//5(de[UUSSUS9 [R"[ U5SS/SS//5(deg)NrfirstT)rpromote_to_multirIr{second)r$r%rprrr)rxrrIrsrs rH)test_write_dataframe_gpkg_multiple_layersrs23I+%H  ??    >>+h/7N2K1L M MM M  >>H > "X~$>?   rJcU(aLURS5(a6URR[RR SS95 [ U5nUSU3- n[XVUS9 UR5 [[ U55S:Xde[XVUSS9 [[ U55S :Xdeg) Nrz.Bugs with append when writing Arrow to GeoJSONr~rjrrT)rIrib) startswithrOrrQrrr$r%rprt)rGrxrrbrIrsrs rHtest_write_dataframe_appendr sS^^J//   KK  %U  V 23ID,&HI9= OO ~h' (C // /I9TJ ~h' (C // /rJrzc0[U5nUS- n[UUUU(aSOSS9 UR5SLdeUS- nUR5ULdeUS- n[UUUSU0S 9 UR5SLdeUS - nUR5ULdeg) Nz test1.shpYESNO)rI SPATIAL_INDEXTz test1.qixz test2.shprz)rI layer_optionsz test2.qix)r$r%rp) rxrrzrIr| outfilename1index_filename1 outfilename2index_filename2s rH!test_write_dataframe_gdal_optionsr s + ,Bk)L ,e$     D (( (,O  ! ! #} 44 4k)L & 6     D (( (,O  ! ! #} 44 4rJc[U5nUS- n[R"[SS9 [ X4USS9 SSS5 g!,(df  g=f)N test.geojsonz#unrecognized option 'SPATIAL_INDEX'rTryr$rQrrr%)rxrrIr| outfilenames rH)test_write_dataframe_gdal_options_unknownr7 sA + ,B^+K z)N O9DQ P O Os ? A cSSKnURU5nUR5nURS5 UR 5nUVs/sHoUSPM sn$s snf)Nrz2SELECT name FROM sqlite_master WHERE type='table';)sqlite3connectcursorexecutefetchall)rtrconrrress rH_get_gpkg_table_namesrA sQ //$ C ZZ\F NNGH __ F$ %fsFf %% %s Ac[U5nUS- n[X4US9 S[U5;deUS- n[X4USS9 S[U5;deUS- n[UUUSS 0S 9 S[U5;deg) Nztest_default.gpkgrgpkg_ogr_contentsztest_no_contents.gpkgr)rIADD_GPKG_OGR_CONTENTSztest_no_contents2.gpkgadd_gpkg_ogr_contentsF)rIdataset_options)r$r%r)rxrrIr|test_default_filenametest_no_contents_filenametest_no_contents_filename2s rH)test_write_dataframe_gdal_options_datasetrK s + ,B$'::BC "78M"N NN N (+B B Yd &;N  44 4 [ !/ 26L LL LrJzUext, promote_to_multi, geometry_type, expected_geometry_types, expected_geometry_typec [U40[D6nUSU3- n US:Xa US;a[R"[SS9n O[ R "5n U  [UU UUUS9 SSS5 U R5(de[U 5n US:Xa[S:aS nS /n[U RRR55n X:Xde[U 5S U:Xdeg!,(df  N=f) Ntest_promote_layer_geom_typer)r|r7z+A geometry of type MULTIPOLYGON is insertedrrIrrrr<r{r)r$r}rQrRuntimeWarningrWrXr%rpr rrrrr) rxrrbrrrrrIrsrctxrurs rH5test_write_dataframe_promote_to_multi_layer_geom_typer sF2@i@I;C5AAK g~-+??ll "O $$&   -'          ,J f})W4"0#1"2J//44;;=>N  44 4 [ !/ 26L LL L% s C,, C:z;ext, promote_to_multi, geometry_type, expected_raises_match))rFr{Mismatched geometry type)rFr|r)rNr7r)rNr|r)rNr7zNCould not add feature to layer at index|Error while writing batch to OGR layerc [U40[D6nUSU3- n[R"[[ 4US9 [ UUUUUS9 SSS5 g!,(df  g=f)Nrjrr)r$r}rQrr!rr%) rxrrbrrexpected_raises_matchrIrsrs rH=test_write_dataframe_promote_to_multi_layer_geom_type_invalidr s\42@i@ItC5\)K  n5=R S  -'   T S Ss A Ac[U40[D6nUS- n[R"[SS9 [ X4USS9 SSS5 g!,(df  g=f)Nrz,Geometry type is not supported: NotSupportedr NotSupportedrIr)r$r}rQrr"r%)rxrrIr|rs rH,test_write_dataframe_layer_geom_type_invalidr sN + 9y 9B.(H K   X   s A Ac[R"SS5[R"SS/5[R"SSSS5[R"[R"SS5[R"SS5/5[R "[R"SS/5[R"SS/5/5[R "[R"SSSS5[R"SSSS5/5/n[R"S /S Q0US S 9nUS U3- nUS:Xa [XEUSS9 O [XEUS9 [U5SS:Xde[U5n[XdSS9 g)Nrrrrmrmrmr)rr)r=r=r=r)rrr@@@rrrjrFryrrrT)check_geom_type) r r7 LineStringr MultiPointMultiLineStringr{rrr%rr$r8)rxrbrIrr|rrs rH test_write_dataframe_truly_mixedr sJ  aFF+, Aq!QGMM!Q/q!1DEF    0 173E3EvvFV3W X  gkk!Q15w{{1aA7NOP H  ./(  BD,&H f} O : X  /9 << < H %Ff$?rJc R[R"S/SQ0[R"SS5[R"SS/5[R "SSSS5/SS9nS n[ R"[[4US 9 [X S - US 9 SSS5 g!,(df  g=f) NrrrrrrrrmrrzCould not add feature to layer at index 1: Attempt to write non-point \(LINESTRING\) geometry to point shapefile.|Error while writing batch to OGR layer: Attempt to write non-point \(LINESTRING\) geometry to point shapefile.rrr) rrr r7rrrQrr!rr%)rxrIr|msgs rH(test_write_dataframe_truly_mixed_invalidr  s   MM!Q    / 0 KK1a #  B G  n5S Az1YG B A As B B&geomscUSU3- n[R"SSS/0USS9n[XTUS9 [U5n[ Xe5 g)Nrjrrrrrr)rrr%r$r8)rxr rbrIrr|rs rH.test_write_dataframe_infer_geometry_with_nullsr 8 sKD,&H %#s,u+ NBBI6 H %Ff)rJz=ignore: You will likely lose important projection informationc[U5nURURS:HRSS9R S5nUS- n[ XEUS9 UR 5(de[U5nURR5nUSS:XdeUS S :XdeUS S :XdeURRUR5(deg) NBelgiumTr-z,+proj=aea +lat_1=49.5 +lat_2=51.5 +lon_0=4.3rrlat_1gH@lat_2gI@lon_0g333333@) r$rrr5to_crsr%rprto_dictequals)rxrrIr|rrrs rHtest_custom_crs_iorL s 3 4B rww)#$ $  > ? *$HH)< ??     !B &&.. C w<4   w<4   w<3   66== & && &rJ) .gpkg.zipz.shp.zipz.shzcUS:Xa![(d[R"S5 [U5nUSU3- n[ XEUS9 UR 5(de[U5nUR RR5n[U[;a[U5S/:XdeO[U5SS1:Xde[XdSS9 g ) zBRun a basic read and write test on some extra (zipped) extensions.rz&.gpkg.zip support requires GDAL >= 3.7rjrr{r|FrN)rrQrRr$r%rprrrr)r'r~rr8)rxrrbrIrsrrrs rHtest_write_read_zipped_extrg s k** <=23ItC5\)KIi@       ,J((--446Ns|44N#'7777>"~y&AAAAjeLrJcSSS[R"5S[R/nUVs/sHn[R "SS5PM nn[ R"X1S.SS9nUS- n[XE5 [U5n[U5[U5:Xde[R"UVs/sH%owS[R4;a [U5OSPM' snS S 9n[US U5 gs snfs snf) Nrjrrmr)rmixed epsg:31370riztest_write_mixed_column.gpkgrrD)rnowrrr r7rrr%r$rtrrHrr:) rx mixed_valuesrar test_gdfrruvaluers rH#test_write_read_mixed_column_valuesr! sCHLLND"&&AL*6 7,QW]]1a ,E 72 H;;KH* ,J x=C O ++ +yyJVW,T266N2U <,W H 7+X6 8 Xs !C31,C8chUS- n[R"SS5nX3U/SS[R/SS[R/S.n[R "USS9n[ XRUS9 [U5n[U5[U5:XdeUS SS:Xde[R"US S 5(de[R"US S 5(deUS SS:Xde[R"US S 5(de[R"US S 5(deg) Nztest_write_nan.gpkgrrrj)rfloat64 object_strrrirr#rmrr$) r r7rrrrr%r$rtrr)rxrIrgeom test_datarrs rHtest_write_read_nullr' s022K ==A D&rvv&tRVV,I yl;HHY? ,J x=C O ++ + i  #s ** * 77:i(+ , ,, , 77:i(+ , ,, , l #A && 00 0 77:l+A. / // / 77:l+A. / // /rJobject_col_data)rrNtest1test2iir)sfoosbarN{iA)r+rNc^USU3- n[R"SS5nU/[U5-US.n[R"US[ S9n[ XtUS9 [U5n[U5[U5:Xde[(d4[(a+[RRR(aSOSn S n [US[5(aHU(a [ (a6["(aS OS n UV s/sHn [R$"U 5PM n n OU(a['US5[(La6["(aS OS n UV s/sHn [R$"U 5PM n n O[US[*5(aSn Un O[US[,5(a6Sn [(a[.R0OS n UV s/sH ocU OU PM n n O5[US[25(aSn UV s/sHn [5U 5PM n n U cMU n U S:Xa[.R0OS n UV s/sH&n U bU [.R0LaU O [7U 5PM( n n USR8R:U :Xde[-US5W :Xdeg s sn fs sn fs sn fs sn fs sn f)zTest writing and reading a pandas object dtype column with different value types. Remark: how some types are handled depends a bit on the file format being used. test_write_objectr)rrizrrrr#Nrrrrr#r)r r7rtrrr#r%r$rrrrrrrrrr#r6rrbytesr~rrrrrrr)rxr(rbrIrr%r&rr str_dtyperr  expected_data nan_values rHtest_write_read_object_columnr2 s2066K ==A DFS11%Iye6BHHY? ,J x=C O ++ + ->-K-K   N/!$h//kk&2\ !7L ;JJ/e,/ J  " #t +2>-CSN>MNoUR\\%0oMNM *E 2 2%N+M *D 1 1%N".,DICRCR%] 5? M*G 4 4&N7FGeU5\MG"'50BFFd ) (%266/Is5z I(  l # ) ) . .. @@ @  <( )] :: :CK O H  s= J J J ;J%3-J*cUup#SUR3n[X!S9n[U5S:Xde[XTUS9 [XAS9n[U5S:Xde[ U5 g![ U5 f=f)N/vsimem/rr)rr$rtr%r)rrIrtramem_pathinputrs rHtest_write_read_vsimemr7 sq%GD$))%H 4 5E u:  9=>6{c!!!8 8s $A A-zwkt,geom_typeszPoint Z (0 0 0)z 2.5D PointzPoint ZzLineString Z (0 0 0, 1 1 0)z2.5D LineString LineString Zz(Polygon Z ((0 0 0, 0 1 0, 1 1 0, 0 0 0))z 2.5D Polygon Polygon ZzMultiPoint Z (0 0 0, 1 1 0)z2.5D MultiPointz MultiPoint Zz2MultiLineString Z ((0 0 0, 1 1 0), (2 2 2, 3 3 2))z2.5D MultiLineStringMultiLineString ZzOMultiPolygon Z (((0 0 0, 0 1 0, 1 1 0, 0 0 0)), ((1 1 1, 1 2 1, 2 2 1, 1 1 1)))z2.5D MultiPolygonMultiPolygon Zz&GeometryCollection Z (Point Z (0 0 0))z2.5D GeometryCollectionGeometryCollection ZcUS- n[R"[U/5SS9nUH#n[XTX6S9 [ U5n[ Xu5 M% g)Nztest.fgbrrr)rrr0r%r$r8)rxwkt geom_typesrIrr geom_typer|s rHtest_write_geometry_z_typesrA sJ.*$H //8SE? DC T H %!"* rJz4test_descr, exp_geometry_type, mixed_dimensions, wktz 1 Point Zz1 LineString Zz 1 Polygon Zz1 MultiPoint Zz1 MultiLineString Zz1 MultiLinePolygon Zz1 GeometryCollection ZzPoint Z + Pointz Point (0 0)zPoint Z + NonezPoint Z + LineString ZzPoint Z + LineStringzLineString (0 0, 1 1)cLUS:XaOUS;a[R"SUSU35 [S:aUS:XaSnOUS:XaS nOUS:XaSnOUS :XaSn0nU/[U5-US '[ [U55Vs/sHn[ U5PM snUS '[ R"U[U5S S 9n USU3- n US:Xa?U RU RR5U RR-)n U(a>[U[;a-[R"[ SS9 [#XUS9 SSS5 g[#XUS9 [%U 5n U SU:Xde['U 5n US:XaS U l[+X5 gs snf!,(df  g=f)Nr)r<rzext z doesn't support r<r:r8r;r9 test_descridxrrrjrz0Mixed 2D and 3D coordinates are not supported byrrrry)rQrRr rtr#rrrr0rrris_emptyr)r&rr r%rr$rr8) rxrbrCexp_geometry_typemixed_dimensionsr>rI column_datarDrrr rs rH test_write_geometry_z_types_autorI. sl f}  C C KK$se#45F4GH I g %!$77$2!"&66$/!!N2$7!"k1$4!K!+ s3x 7K .3CHo>os#c(o>K //+ ; OCD,&H f}gg ))+cll.C.CCDEGCL,GG ]] E  CY ?  ; X D  $5 55 5)J k$ c.5?  sF8 F F#z!on_invalid, message, expected_wkt))warnzyInvalid WKB: geometry is returned as None. IllegalArgumentException: Points of LinearRing do not form a closed linestringN)raisez4Points of LinearRing do not form a closed linestringN)rNN)fixNzPOLYGON ((0 0, 0 1, 0 0))z.ignore:Non closed ring detected:RuntimeWarningcUS:Xa![(d[R"S5 US:Xa.[R"[R R US9nOEUS:Xa[R"US9nO*US;a[R"5nO[SU35eSnUS - n[US 5nURU5n SSS5 U [UUUS 9n UcU RRS beO)U RRS R U:XdeSSS5 g!,(df  Nn=f!,(df  g=f) NrLz.on_invalid=fix not available for Shapely < 2.1rKrrJ)rLrzunknown value for on_invalid: a>{ "type": "FeatureCollection", "features": [ { "type": "Feature", "properties": {}, "geometry": { "type": "Polygon", "coordinates": [ [ [0, 0], [0, 1] ] ] } } ] }rrg)rI on_invalidr)rrQrRrr errors GEOSExceptionrrWrXrrrrsr$rrr>) rxrIrNr expected_wktr^invalid_geojsonrfrar|s rHtest_read_invalid_poly_ringrT s' U== DEW-- < >77 8 , =9 8 - .{{&&(^,<<<<9 8s B B%cx[XS9n[R"S/SS0/S.[R"SS5/SS9n[ (a"U(aUS R [5US '[X#5 [XS S 9n[R"S/S/S .[R"SS5/SS9n[X#5 g) NrA bottom_levelB) top_levelintermediate_levelrrrrbr)rIFLATTEN_NESTED_ATTRIBUTES)raintermediate_level_bottom_level) r$rrr r7rrr#r8)nested_geojson_filerIr|rs rHtest_read_dataset_kwargsrf s + AB$2C#8"9 --1%&  H{y*22F)G)N)Nv)V%&b+ E B03u --1%&  Hb+rJc~[R"[SS9 [XSS9 SSS5 g!,(df  g=f)Nz$does not support open option INVALIDrr)rIINVALID)rQrrr$rs rH test_read_invalid_dataset_kwargsri s) n,R S*O T S Src US- n[R"/SQSS9[R"/SQSS9[R"/SQSS9[R"/S QS S9[R"/S QS S9S .n[R"U[R "SS5/S-SS9n[ XBUS9 [U5nUR5nUSRS5US'USRS5US'USRS5US'USRS5US'SURS'[XV5 g)Nztest_nullable_dtypes.gpkgrint64r)rmrNInt64)g?Ng333333?Float32)TFNboolean)rNrr+)col1col2col3col4col5rr=rrrrpr#rqfloat32rrrsr)rmrs) rrHrrr r7r%r$rrrr8)rxrIrtr&rsrurs rHtest_write_nullable_dtypesru s) 1 1D )73 ,g6 *)< -Y? *(; IW]]1a01A5<IIy9%J~~H'..y9HV'..y9HV'..y9HV'..u5HV"HLLj3rJ metadata_type)dataset_metadatalayer_metadatametadatacSU0n[U5nUS- n[XV4SU0X$0D6 US:XaSOUn[U5UU:Xdeg)NlevelrrIryrx)r$r%r)rxrrvrIryr|r metadata_keys rHtest_metadata_ior}9 s_ 'H + ,B+%HBSIS-9RS'4 'B# L X | , 88 8rJrwrxrykeyc[U5n[R"[SS9 [ XPS- 4SU0X#0D6 SSS5 g!,(df  g=f)Nzmust be a stringrrrIr)rxrrvryrIr|s rHtest_invalid_metadatarJ sM + ,B z); < ;& 2; @M?X  = < . s R]]8-DrJ)rIarrow_to_pandas_kwargsr#) rQ importorskiprrr7r%r$rrrrrr8)rxrr|rs rH test_read_dataframe_arrow_dtypesrp s  "+%H  c uQ{D&9{ BB!  D F fUm))2== 9 99 95M((3F5Mf)rJ)r=rr=z+Arrow bool value bug fixed in GDAL >= 3.8.3cUSU3- n0nUS:XaSUS'[R"/SQ[SS5/S-S.S S 9n[XB40UD6 [ US S 9n[ XTUS :gS9 g)NrjrFrzTFTFTrrr,rrriTrrrrV)rxrbrrr|rs rHtest_arrow_bool_roundtripr sz D,&H F f}"' 5E!QK=STCTU  B B+F+ H 5FfcVmDrJcTUSU3- n[R"/SQ[SS5/S-S.SS9n[X25 US;aL[R "[ [R"S 5S 9 [US S 9 SSS5 [US /S 9 g[US S 9ng!,(df  N%=f)Nrjrrrrrri>rrzLGDAL < 3.8.3 does not correctly read boolean data values using the Arrow APIrTrr) rrr7r%rQr RuntimeErrorrZr[r$)rxrbrr|ras rHtest_arrow_bool_exceptionr s D,&H 5E!QK=STCTU  B B!  ]] ))   8t 4  x4< 8t 4  s / B B'c RSnSnUS- n[R"X"/S[SS5/0SS9n[XCUS9 [ US S9nUce[ 5 [ R"[S S 9 [ US S9nS S S 5 S S S 5 g !,(df  N=f!,(df  g =f) z9Test if arrow can be enabled via an environment variable.CP1252ÿrrrrrirhrdN-non-UTF-8 encoding is not supported for Arrowr) rrr7r%r$r[rQrr)rxritextrXr|rras rH+test_arrow_enable_with_environment_variabler sH D;&I $ U1a[MB TBBH5I 9F      ]] M y8> >rJc[U5n[5n[R"[SS9 [ UR S5USSS9 SSS5 [SSS9/:Xdeg!,(df  N=f) Nz2driver must be provided to write to in-memory filerrmrjrr4rr)r$r rQrrr%rrrr|rs rH!test_write_memory_driver_requiredr se + ,B YF B   F4vF    K 8B >> >   A$$ A2 OpenFileGDBc[U5n[5n[R"[SU3S9 [ X#USS9 SSS5 [ SSS9/:Xdeg!,(df  N=f)Nz/writing to in-memory file is not supported for rrjrr4rr)r$r rQrrr%rrrr|rs rH$test_write_memory_unsupported_driverr* sb + ,B YF KF8T  6@   K 8B >> >   s A A%c [U5n[5n[R"[SS9 [ UR S5X1SSS9 SSS5 [SSS 9/:Xdeg!,(df  N=f) Nz+append is not supported for in-memory filesrrmrjT)rrrr4rrr$r rQrNotImplementedErrorr%rrrs rH$test_write_memory_append_unsupportedr9 sf + ,B YF #P   FPTU   K 8B >> >   rc[U5n[S5n[R"[SS9 [ UR S5USSS9 SSS5 [SS S 9/:Xdeg!,(df  N=f) Ns0000z5writing to existing in-memory object is not supportedrrmrrjrr4rrrrs rH&test_write_memory_existing_unsupportedrH sh + ,B W F E   F9FK    K 8B >> >  s A%% A3cn[U5n[R"[SS9 [ US- S5n[ UR S5U5 SSS5 SSS5 [R"[SS9 [US- S5nUR SS5n[ UR S5U5 SSS5 SSS5 SSS5 [S S S 9/:Xdeg!,(df  N=f!,(df  N=f!,(df  NQ=f!,(df  NZ=f!,(df  Nc=f) zEVerify that writing to an open file handle is not currently supportedz3writing to an open file handle is not yet supportedrrwbrmNztest.geojson.ziprgr4rr) r$rQrrrrr%rr r)rxrr|rSzs rHtest_write_open_file_handlerV s + ,B #X (^+T 2a BGGAJ *3  #X X 22C 8A, A.-9   K 8B >> >3 2  -,9 8  s^C3C"C3:D& DD9DD&" C0 ,C33 D D D D# D&& D4gpkggeojsonc `Uup4USU3- n[R"XD/S[SS5/0SS9n[XeUS9 [R "[ 5 [U5 SSS5 [XSS9nURSU:XdeXtRSU:Xdeg!,(df  ND=f)auVerify that we write non-UTF data to the data source IMPORTANT: this may not be valid for the data source and will likely render them unusable in other tools, but should successfully roundtrip unless we disable writing using other encodings. NOTE: FlatGeobuff driver cannot handle non-UTF data in GDAL >= 3.9 NOTE: pyarrow cannot handle non-UTF-8 characters in this way test.rrrrirhN) rrr7r%rQrUnicodeDecodeErrorr$rur)rxrb encoded_textrirrr|rs rHtest_non_utf8_encoding_iorn s"NHuSE]*K $ U1a[MB TBBh7 ) *{# +K ;F >>!  $$ $ <  q !T )) ) + *s  B B-c pUup4USU3- n[R"XD/S[SS5/0SS9n[XeUS9 [R "[ 5 [U5 SSS5 [R "[SS9 [XSS S 9 SSS5 g!,(df  N;=f!,(df  g=f) NrrrrrirhrrTrl) rrr7r%rQrrr$r)rxrbrrirrr|s rH)test_non_utf8_encoding_io_arrow_exceptionr s"NHuSE]*K $ U1a[MB TBBh7 ) *{# + I  {F   + *  s B B' B$' B5c (Uup4US- n[R"XD/S[SS5/0SS9n[XeUS9 [ XRS9nUR SU:XdeXtR SU:XdeURS5R5 URU5RS 5nU(a-[R"[S S 9 [ US S9 SSS5 O6[ US S9n U R SU:XdeXR SU:Xde[ XSUS9nUR SU:XdeXtR SU:Xde[ XRUS9nUR SU:XdeXtR SU:Xdeg!,(df  N{=f)Nrrrrrirhrz.cpgz ISO-8859-1zCThe file being read is not encoded in UTF-8; please use_arrow=FalserTFrl)rIENCODING)rrr7r%r$rurrunlinkencodedecoderQrr ) rxrrIrirrr|rmiscodedbads rH#test_non_utf8_encoding_io_shapefiler s!NHZ'K $ U1a[MB TBBh7 K =F >>!  $$ $ <  q !T )) )F#**,{{8$++L9H ]] W  ;$ 7   [E:{{1~)))}##A&(222Ki PF >>!  $$ $ <  q !T )) )Kx PF >>!  $$ $ <  q !T )) )%  s F Fc[R"[SS9 [USSUS9 SSS5 g!,(df  g=f)zZProviding both encoding parameter and ENCODING open option (even if blank) is not allowed.zc Uup#US- n[R"X3/S[SS5/0SS9n[R"[ SS9 [ XTUSS 0S 9 S S S 5 g !,(df  g =f) zdProviding both encoding parameter and ENCODING layer creation option (even if blank) is not allowed.rrrrrizKcannot provide both encoding parameter and "ENCODING" layer creation optionrrr)rirN)rrr7rQrrr%)rxrrirrr|s rH4test_encoding_write_layer_option_collision_shapefiler sp"NHZ'K $ U1a[MB TB     hz2>N    s A A,c jSnUS- nSn[R"XDS[SS5/0SS9n[XSUS9 [ US US US 3US 9nUR SU:XdeXdR SU:Xde[ US US US 3UUS 9nUR SU:XdeXdR SU:Xdeg)Nrru中文rrrrirhzselect * from test where "z" = ''rK)r^rirI)rrr7r%r$rur)rxrIrirmandarinr|rs rH$test_non_utf8_encoding_shapefile_sqlr sHZ'KH  Z%1+7[ BBh7 )(6(1 EF >>!  (( (   " "1 % 11 1 )(6(1 E F >>!  (( (   " "1 % 11 1rJc [SS5[SS5[SS5/n[R"USS9nUS - n[X4S S US 9 [ XAS 9n[ R "URRU5(deg)Nrw(r<rrr tmp_layerrrrrIr r7rrr%r$rrrr)rxrIpointsrrgdf_ins rH$test_write_kml_file_coordinate_orderrszBmU2r]E"bM :F //6{ ;CZ'K EYK =F >>&//00& 9 99 9rJz>LIBKML driver is not available and is needed to append to .kmlc [SS5[SS5[SS5/n[R"USS9nUS - n[X4S S US 9 [S S5[SS5[SS5/n[R"USS9n[UUS S USS9 [ XASS9n[ R "URRX%-5(deg)zAppend features to an existing KML file. Appending is only supported by the LIBKML driver, and the driver isn't included in the GDAL ubuntu-small images, so skip if not available. rwrrrrrrrrrrrrrrVrlr/T)rrrIr)rIrNr)rxrIrrr points_append gdf_appendgdf_in_appendeds rHtest_write_kml_appendrsBmU2r]E"bM :F //6{ ;CZ'K EY 1a[%2,b" >M-[IJ %[PTUO >>/22996;Q R RR RrJc [SS5[SS5[SS5/n[R"USS9nUS - n[UUS S S US 9 [ XAS9n[ R "URRU5(de[SS5[SS5[SS5/n[R"USS9n[UUS S S US S9 [ XAS9n[ R "URRX&-5(deg)NrwrrrrrrrrrrT)rrRFC7946rIrFPrr<nx)rrrrIrr) rxrIrrrrrrrs rH&test_write_geojson_rfc7946_coordinatesr=sBmU2r]E"bM :F //6{ ;C^+K  K =F >>&//00& 9 99 92r]E"cNE#sODM-[IJ%[FO >>/22996;Q R RR RrJc dUS- nUR5 [R"S/SQ0[S5Vs/sHn[R "X35PM snSS9n[ XBSSUS 9 UR5(deUR5(de[X!S 9n[XE5 g s snf) zTest to overwriting an existing corrupt OpenFileGDB. Test added in context of https://github.com/geopandas/pyogrio/issues/598 ztest.gdbidrr=rr test_layerrrrN) mkdirrrr#r r7r%rpis_dirr$r8)rxrIrXrrr<s rH(test_write_openfilegdb_overwrite_corruptrbs:%I OO // /4Qx8x!'--%x8  C  l=I            i=Hc,9s B- c [R"/SQ[SS5[SS5[SS5/S.SS9nUS- n[X#US 9 [ X1S 9n[ XB5 g ) z= Simple test verifying the Parquet driver works if available rrrmr)rrrriz test.parquetrNrV)rxrIrrrs rHtest_parquet_driverr}s^ //a U1a[%1+'NO  C^+KC : K =Ff*rJ)rWrrWrZrrrrrrdecimalrior pathlibr zipfiler numpyrpyogrior r rrrrrpyogrio._compatrrrrrrrrrrrrpyogrio.errorsrr r!r"pyogrio.geopandasr#r$r% pyogrio.rawr&r'pyogrio.tests.conftestr(r)r*r+r,r-r.r/rQr;rpandasrgeopandas.arrayr0pandas.api.typesr1r2r3r4r5r6r shapely.geometryr7geopandas.testingr8pandas.testingr9r: ImportErrorrdictr}unionfixturerFrIrScontextmanagerr[rbr parametrizer}skipifrupperrrrrrrrrrrrrrrrr%r?rrQrartrrrrrr6 fromisoformatrrrrrrrrrrrrrr rrr|GeometryCollectionrrrr"rkr r%r(r*r8r;r>r@rBrIrMrQrSrUr[r^rhrwrrrr#r#rrrrrrrrrrrrrrrrrr r rrr!r'rr2r7rArIrTrYr\rfrirur}rrrrrrrrrrrrrrrrrrrrrrrr)rbs0rHrs >>    XWKK    (&;K  F w$A$G$G %!e,I   T!56  J J  ,, Wd*>? 55. !'')W4 59 92   $'7"dAUTU&W " "')*# $   / ")* DO6 6 V -  -)-XX T2w$78 $9 $ u6pT2 M/J$KL.M.:%%(I7&7D%%R@&R@jA%%+&+-t}=/%?6<@>6L..b J6M JK-t}=/%?TU%%@G&V@>L @GF J6M JK-t}=/%?A%%EA&@>LEAP J6M JK-t}=/%?A%%C.&@>LC.L  T1aQ6 2 T1aQ6 2 FF T1aQ6(9STCU:V W T1aQ6 2 FF %%O @$. &($.N J6M JK LL8 9 LL4 5 FF  " "#B C  " "#> ? FF -t}=/%?A%%W.&@>L,W.t J6M JK-t}=/%?%%1.&@>L1.h%%%  %H &%HP "0(  "J" !:;T<T  !2& UEN+ w' / /.. !Q02LL   tR 5'* S!S" %u~6 OO&(9:&(9:&(:;&(:;&(:;&(9:   "   & &tR('++c1c2*FG  "  !4/54/&..*bhhz.R!ST1U1KK !*O  $2s)4!5!HS ,7"c3&48&RR G9x . ? 8 #L/HSwSH/# $ 2  2.G90E/F222 Wd*BC  * *F& %%8& 8<)%%"&*"J<=u 6G90D V0Dv 0D VW%%2 &X7>2 j%% L& L S{"2I> UI 'BIN T9~y&A9M T9~y&A9M T>NI+F R T7^Y$?K T9~&6G %^Y$?K $ N#3Y? $ N#3Y? $(8.I $.!17; $ N#3Y?  NI#> J y>9"=yI y>9"=yI ~ 'BIN y>9"=yI%0%%'M&12'MTA  %% &!" ,%% Y& Y Nv ? *%%+&+,+): i):(;< >53P2QR    7 8  >53P2QR !   A B   #  a    % "  5 6  It.?-OP 9e.?-FG $   *,= >   #   $&7 8  M,/`%%2/&a/*d2/j'  LM);N );X*,=" ,FP %%4&42G%% 9& 9+=?O*PQ A   %% &R +=?O*PQ%% 5&R 5  $-NO*P*,y )V)E* E( !*W)5* 58==,%%%'89O6 6 VE :& ED@AIv#67?8B?2 ?$4m#DE ?F ?Iv#67 ?8 ? ??0 34*5*8 34G5G")*X   (2:%% :& :%% LN" KS & SB%%!S&!SH%%-&-4%%(I +& +gq  f!Kj!KP!K^!KP!K`!KL0l!WJ!Tn !Ov!Os$6Ae; Ae Ae  Ae Ae  Ae Ae 6 Ae Ae  Ae# (Ae# Ae( Ae( ) Ae- 6Ae- 8 Ae2Ae2/ Ae7 <Ae7 D Ae< DAe< E< Af F Af eAe e Ae