hBddlZddlmZddlmZddlmZmZm Z ejjejje ZejjejjeZejj!edddZdejj!ed zZejj!ed d Zejj!ed d Z ddlmZddZdZdZddZy#e$r ddlmZYwxYw)N)Series) GeoDataFrame)assert_geoseries_equalgeom_almost_equals geom_equals geopandastestsdatazzip://z nybb_16a.zipnaturalearth_citiesznaturalearth_cities.shpnaturalearth_lowresznaturalearth_lowres.shp)mockcpt|tsJt|dk(sJd}|r|D]}||jvrJn,|D]'}|j d|jDvr'Jt |j jjjdjsJy)zATests a GeoDataFrame that has been read in from the nybb dataset.)BoroCodeBoroName Shape_Leng Shape_Areac3<K|]}|jywN)lower).0dfcols G/var/www/html/immo/lib/python3.12/site-packages/geopandas/tests/util.py z#validate_boro_df..-s"IU5;;="Is MultiPolygonN) isinstancerlencolumnsrrgeometry geom_typedropnaeqall)dfcase_sensitivercols rvalidate_boro_dfr'!s b, '' ' r7a<<BG %C"**$ $$ % JC99;"Ibjj"II II J "++'' ( / / 1 4 4^ D H H JJ JcX|j|jjxsdSy)zReturn srid from `df.crs`.r)crsto_epsg)r$s rget_sridr,1s% vvvv~~$1$ r(c |5|jj}t||jd|jdd||jj j djf|jdd|fd}|j|fd|jd Dd d d y #1swYy xYw) 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(?, ?))c3K|]W}d|j|j|j|j|jr|jj ndfYywr)rrrrrwkt)rrowsrids rrz$create_spatialite..VsT LLLLNNNN(+ CLL$$$ sAA F)indexN) rnamer,executer r!iatupper executemany itertuples)conr$geom_colsql_rowr2s @rcreate_spatialiter=8s  ;;##|    2 XtR\\%8%8%:%>%>q%A%G%G%I J  57IJN   ==u=5  %    s B=C  Cc | d|d}d|d}nd}d} |j}|jdd|d |d }|j||jD];\}} d |d }|j|| dj| d | d| d| df= |j |j y#j |j 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), rzST_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_insertr@sqlir1s rcreate_postgisrHes  /vQ7 r\s"  wwrwwx01ggoobggood34 k;H277<<??ww||)+Dww||)+D  K  * Z.Qs;D DD