ChHSSKrSSKJr SSKJr SSKJrJrJ r \RR\RR\ 55r\RR\RR\55r\RR!\SSS5rS\RR!\S 5-r\RR!\S S 5r\RR!\S S 5rSSKJr SSjrSrSrSSjrg!\a SSKJr Nf=f)N)Series) GeoDataFrame)assert_geoseries_equalgeom_almost_equals geom_equals geopandastestsdatazzip://z nybb_16a.zipnaturalearth_citiesznaturalearth_cities.shpnaturalearth_lowresznaturalearth_lowres.shp)mockc[U[5(de[U5S:XdeSnU(aUHnX0R;aMe O0UH*nUR 5SUR5;aM*e [ UR R5R5RS5R5(deg)zATests a GeoDataFrame that has been read in from the nybb dataset.)BoroCodeBoroName Shape_Leng Shape_Areac3@# UHoR5v M g7fN)lower).0dfcols gC:\Users\julio\OneDrive\Documentos\Trabajo\Ideas Frescas\venv\Lib\site-packages\geopandas/tests/util.py #validate_boro_df..-s"IjU;;==js MultiPolygonN) isinstancerlencolumnsrrgeometry geom_typedropnaeqall)dfcase_sensitivercols rvalidate_boro_dfr(!s b, ' '' ' r7a<<BGC**$ $$C99;"Ibjj"II II "++'' ( / / 1 4 4^ D H H J JJ JcdURb#URR5=(d S$g)zReturn srid from `df.crs`.r)crsto_epsg)r%s rget_sridr-1s% vvvv~~$1$ r)c ^U URRn[U5mURS5 URSSUTURR 5R SR545 URSSU45 SnURUU4SjURSS 955 S S S 5 g !,(df  g =f) 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(?, ?))c3># UH]nSURURURURUR(aURR OST4v M_ g7fr)rrrrr wkt)rrowsrids rr$create_spatialite..VsU 6CLLLLNNNN(+ CLL$$$6sA%A(F)indexN) r namer-executer!r"iatupper executemany itertuples)conr%geom_colsql_rowr3s @rcreate_spatialiter?8s ;;##|    2 XtR\\%8%8%:%>%>q%A%G%G%I J  57IJN   ==u=5  % s B;C Cc Ub SUS3nSUS3nOSnSnUR5nURS5 SUS US 3nURU5 UR5H;upS US 3nURUU SRU S U SU SU S45 M= UR 5 UR 5 g!WR 5 UR 5 f=f)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)cursorr7iterrowsr1closecommit) r<r%r3r= geom_schema geom_insertrBsqlir2s rcreate_postgisrJes /vQ7 r^s"  wwrwwx01ggoobggood34 k;H277<<??ww||)+Dww||)+D  K  * Z.Qs;D D! D!