rbi6ddlZddlmZddlmZddlmZmZm Z ej ej e Zej ej eZej edddZdej ed zZej ed d Zej ed d Z ddlmZn#e$r ddlmZYnwxYwddZdZdZddZdS)N)Series) GeoDataFrame)assert_geoseries_equalgeom_almost_equals geom_equals geopandastestsdatazzip://z nybb_16a.zipnaturalearth_citiesznaturalearth_cities.shpnaturalearth_lowresznaturalearth_lowres.shp)mockFct|tsJt|dksJd}|r|D] }||jvsJn,|D])}|d|jDvsJ*t |jj d sJdS)zATests a GeoDataFrame that has been read in from the nybb dataset.)BoroCodeBoroName Shape_Leng Shape_Areac3>K|]}|VdSN)lower).0dfcols d/var/www/html/mdtn/previsions/meteo_cartes/venv/lib/python3.11/site-packages/geopandas/tests/util.py z#validate_boro_df..-s*"I"IU5;;=="I"I"I"I"I"I MultiPolygonN) isinstancerlencolumnsrrgeometry geom_typedropnaeqall)dfcase_sensitivercols rvalidate_boro_dfr(!s b, ' '''' r77a<<<<BGJ % %C"*$$$$$ % J JC99;;"I"Ibj"I"I"IIIIII "+' ( ( / / 1 1 4 4^ D D H H J JJJJJJrcJ|j|jpdSdS)zReturn srid from `df.crs`.Nr)crsto_epsg)r%s rget_sridr,1s& vv~~$1$ 1rc |5|jj}t||d|dd||jjdf|dd|fd}||fd| d Dd d d d S#1swxYwYd S) z Return a SpatiaLite connection containing the nybb table. Parameters ---------- `con`: ``sqlite3.Connection`` `df`: ``GeoDataFrame`` zCREATE TABLE IF NOT EXISTS nybb ( ogc_fid INTEGER PRIMARY KEY, borocode INTEGER, boroname TEXT, shape_leng REAL, shape_area REAL)z$SELECT AddGeometryColumn(?, ?, ?, ?)nybbrzSELECT CreateSpatialIndex(?, ?)z:INSERT INTO nybb VALUES(?, ?, ?, ?, ?, GeomFromText(?, ?))c3xK|]4}d|j|j|j|j|jr |jjndfV5dSr)rrrrr wkt)rrowsrids rrz$create_spatialite..Vsi  LLNN(+ >CL$$$      rF)indexN) r namer,executer!r"iatupper executemany itertuples)conr%geom_colsql_rowr2s @rcreate_spatialiter=8sX   ;#||      2 XtR\%8%8%:%:%>q%A%G%G%I%I J    57IJJJN      ==u=55      %                   sCC  C$'C$geomc $| d|d}d|d}nd}d} |}|dd|d |d }|||D]I\}} d |d }||| dj| d | d| d| dfJ ||dS#||wxYw)z Create a nybb table in the test_geopandas PostGIS database. Returns a boolean indicating whether the database table was successfully created Nzgeometry(MULTIPOLYGON, )z$ST_SetSRID(ST_GeometryFromText(%s), r zST_GeometryFromText(%s)zDROP TABLE IF EXISTS nybb;z CREATE TABLE nybb ( z z, borocode integer, boroname varchar(40), shape_leng float, shape_area float );zINSERT INTO nybb VALUES (z, %s, %s, %s, %s );rrrr)cursorr5iterrowsr0closecommit) r:r%r2r; geom_schema geom_insertrAsqlir1s rcreate_postgisrIesZ 7777 DTDDD  / 3444 % skkmm  FAs C NN O' O O % %            s B%C%%*D)F)Nr>)os.pathospandasrrrgeopandas.testingrrrpathabspathdirname__file__HERE PACKAGE_DIRjoin_TEST_DATA_DIR_NYBB_NATURALEARTH_CITIES_NATURALEARTH_LOWRESunittestr ImportErrorr(r,r=rIrrr\s""""""  wrwx0011goobgood3344 k;HH27<<???w||)+Dw||)+D  K K K K    * * * Z......s3C:: DD