This is a list of 193 zip codes and their geometries that do not import in QGIS.
This is a list of 999 Census Block Groups and their geometries that do import in QGIS.
This is the Add MSSQL Layer tbl in QGIS. It shows what the table displays when I try to import them both.
What would cause one table to be able to import, but not the other?
I am having this problem where I can't import shapefiles from SQL to QGIS. I am using zip codes in Florida as my shapes. I wrote a query in sql to give me certain zip codes and their geometries for certain counties in FL. This was put into a new table in sql consisting of nearly 200 zip codes. When I try to import this into QGIS, it wont import. The MSSQL import table doesnt allow me to select this table. However, if I change the query to include only 20 zip codes, it will allow me to select and import the table. So does QGIS have a limit to the amount of shapes it can import? I have other tables in sql that have more than 1000 shapes and they import, but not this one of 200 zip codes.