I have a Google fusion table that contains about 50k rows with kml data. When I bring up the map view in the fusion tables UI I only see data for about a few thousand rows.
When I do a spatial query to return data that fits within the boundaries, I don't get any results for rows after the first few thousand.
I looked at my kml and it appears to be correct. Is there some limitation that I am running into or should I be looking at something else. If needed I can provide the table id if someone wants to look at it.
KML does not need to be geocoded.
KML can sometimes have very large files, even if only 50K rows. If your original file was very large, (>100 MB), you may be encountering performance issues. I'd recommend making the file smaller (simpler) and start again.
If you are running into an issue with more than 500 items for a given map tile, more items will appear as you zoom in. (Because more map tiles are used to cover the same area.)
-Rebecca