Re: [mapguide-users] Shapefile with 200+ fields
Avoid varchar(max) make sure you have a Primary Key and spatially index...ogr2ogr will index and primary key for you On Aug 26, 2016 3:20 PM, "BMason" wrote: > We can select 10 or so of the most important columns to display and we are > doing this but users want to see all 200 of them, not just 10. So I > guess > that we are forced to use something like SQL server. > > > > -- > View this message in context: http://osgeo-org.1560.x6. > nabble.com/Shapefile-with-200-fields-tp5282394p5282498.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Shapefile with 200+ fields
Ogr2ogr works well for conversion as well as quantum gis On Aug 26, 2016 3:20 PM, "BMason" wrote: > We can select 10 or so of the most important columns to display and we are > doing this but users want to see all 200 of them, not just 10. So I > guess > that we are forced to use something like SQL server. > > > > -- > View this message in context: http://osgeo-org.1560.x6. > nabble.com/Shapefile-with-200-fields-tp5282394p5282498.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Shapefile with 200+ fields
We can select 10 or so of the most important columns to display and we are doing this but users want to see all 200 of them, not just 10. So I guess that we are forced to use something like SQL server. -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Shapefile-with-200-fields-tp5282394p5282498.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Shapefile with 200+ fields
If you can't change/convert the SHP file (200+ fields? Really?) and the file is read-only, perhaps you could try using an OGR provider connection to a VRT file (http://www.gdal.org/drv_vrt.html) pointing to the SHP file and in the VRT file, only select out the columns/properties of interest. That property list should then reflect in any class definition we get from the OGR feature source. - Jackie -- View this message in context: http://osgeo-org.1560.x6.nabble.com/Shapefile-with-200-fields-tp5282394p5282400.html Sent from the MapGuide Users mailing list archive at Nabble.com. ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
Re: [mapguide-users] Shapefile with 200+ fields
Is it necessary two have 200 fields in a SHP file? Normally at that point you are better with a spatial database On Aug 25, 2016 6:56 PM, "BMason" wrote: > Hello, I have a polygon shapefile with 200+ fields. Most fields are > empty. > When selecting one polygon to view using the selection panel in mapguide, > it is too slow to be of any use. Is there a limitation with mapguide and > shapefile fields? Is using REST a better option? If so, is there any > documentation to help us implement it? thankyou > > > > -- > View this message in context: http://osgeo-org.1560.x6. > nabble.com/Shapefile-with-200-fields-tp5282394.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > ___ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users ___ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users