Latest Contributions by FrancisMoisan

‎04-27-2018

Hi Joe, Instead of using the ArcGIS Tool, I made my own export to kml tool in python. In my code there is a section for point, polygon and line (base on what the tool receive as input). I'm not a programmer so the code is not very clean. It's not perfect and I can't bring attribut to kml in my code. The only thing that works is the geometry I draw in flex viewer is exporter to KML nicely. And the selected object can be exported too (but no attribut).

‎11-30-2017

Hi, we have a arcgis server with many services. Our client use one of our MapServer service to find record (ArcGIS REST Services Directory). That works fine but the result (in json or HTML) return the attributes alias. Is it possible to return the real attributes names, not the alias?

‎11-09-2017

Hi I have a Locator style file to use for building Locator for our organisation. We need to geocode canadian style adresses. I have difficulty to understand the style file and I need to do some adjustment to the postal code mapping. I'm using the "Single house addresses (points)". If I try to geocode an addresse, the postal code is not used. For the same city, I have 2 identical addresses except the postal code (this is due to city fusion). So I need to find the right addresse with the right postal code. But it's not working. ANy idea?

‎11-02-2017

Hi! I need to do some update an attribute on a SDE feature class (versioned). The feature class is within a FeatureDataset. I want to do a simple calculate field on a specific version of my data (the user will chose the version). But It fail every time. I can do this on the DEFAULT version only. I try something like this edit = arcpy.da.Editor(workspace) edit.startEditing(False, True) #Creating a feature layer (no selection, all the data) arcpy.MakeFeatureLayer_management(fc,_mon_feature_layer) #Changing the version arcpy.ChangeVersion_management(_mon_feature_layer, 'TRANSACTIONAL', _ma_version_cible) Any Idea?

‎10-07-2016

Hi! I have the same problem. The first time I run my script, the KMZ is fine but the second time the KMZ wrap the world. When I unzip de kMZ, the coordinate of the geometry use bad decimal delimiter. First run : -72.5123508930792,46.02718407088821,0 -72.89026165964782,45.9512204096942,0 -73.00197113196214,45.60643088717575,0 Second run : -72,5123508930792,46,02718407088821,0 -72,89026165964782,45,9512204096942,0 -73,00197113196214,45,60643088717575,0 I have to close arcmap, and then open it back and then it works fine for the first run and the second run is bad geometry... I try to change the windows local setting to (decimal delimiter) to point and the tool works fine But I can't change my local setting permanently. I have to use a comma as a decimal delimiter (french canada). So I try the python "locale" to change the setting on the fly but with no success. Any idea? Thanks! Francis

‎12-09-2015

Hi! I use a python script to change attribute alias name in an SDE database (sql server). It goes very well except for some particular attribute. If my attribute name is "VOCATION" and my alias is going to be "Vocation", the alias is not change. It look like a case not sensitive problem. Any Idea? I run the python script within FME (python caller). I use arcpy.AlterField_management for changing alias.

‎05-01-2015

Even with a distance... the limit seem to be 10 km. Even if I write a distance of 100000 meter (100 km) There is no result returned... I use the Canada style locator. I will try with the USA locator style... Francis

‎05-01-2015

Hi! We have a geocoding service on a road feature class and the geocoding works well to locate an adresse but when i try the "Inverse geocoding", if my coordinate is more than 10 km away from any road, I have no return from the service (rest or arcmap). Any search distance limit on a geocoding service? Any idea on how to manage the distance? thank you!

‎09-26-2014

Thanks, No the code snippet is the Oracle version of my query. Oracle data where store in native Oracle. It was so easy... SDE means using arcgis and I don't like it... I must validate millions of data with spatial join and performance is not good. I was using FME to perform sql query (both spatial or not) in Oracle and it was very fast... I want to reproduce this in MSSQL server with ArcSDE data but can't find a way...

‎09-26-2014

Hi! We store our spatial data into a SDE geodatabase (with sde geometry) into a MSSQL server 2008 database. I need to create a SQL query with spatial relation but need to perform the query onto the database wichi I think will be faster than a tool from ArcGIS. I can do it with model builder or Python but very slow and need to write a table down into the database. I just need to analyse and return a count of the result... When I was using Oracle my query was : SELECT * FROM [my_points] pts, [my_area] poly WHERE CODE_MUN NOT LIKE 'NR%' and sdo_inside(pts.geoloc,poly.geom) = 'TRUE' and pts.CODE_MUN <> poly.MUS_CO_GEO How to do this into MSSQL server with sdebinary. Any idea? thanks!

‎01-06-2011

Hi, Ive created a vb macro that will create a text file at the seme place as my mxd file. The text file contain some information about my mxd like the name of the mxd. I need to had the rotation of the active dataframe but I can't find the way to do that. I suppose it's simple but I can't get it. Any Help on how to get the maprotation to a text string? tnx

Online Status	Offline
Date Last Visited	‎11-11-2020 02:23 AM

My Ideas

Latest Contributions by FrancisMoisan

Re: problem with LayerToKML_conversion tool in python

Rest service on mapserver find and alias

Locator canada style addresse

calculate field on sde versioned data

Re: problem with LayerToKML_conversion tool in python

arcpy and attribute alias

Re: Inverse geocoding

Inverse geocoding

Re: MSSQL server and Spatial query on ArcSDE Database

MSSQL server and Spatial query on ArcSDE Database

Get Map rotation

Re: problem with LayerToKML_conversion tool in py...