Hello All,
I have two X (Longitude) and Y (Latitude) values of each attribute. The first X & Y shows for the pickup location whereas the second one is for the drop off location. How can I get MITAB format file that shows pickup and dropoff in different colors? Also, I want to measure a direct distance between them. I tried AttributeProjector but it gives me only one x and Y attribute. Here is the sample of my data:
Best answer by takashi
Hi @gsgoraya,
e.g.
Hi @gsgoraya,
e.g.
Hi @gsgoraya,
e.g.
Thank you Takashi. It works for me. I really appreciate your help.
Gurpreet
Hi @gsgoraya,
e.g.
Hello Takashi,
I tried to write on GeoMedia Warehouse, but seems to me it is not written accordingly. Here is the translation log:
Hello Takashi,
I tried to write on GeoMedia Warehouse, but seems to me it is not written accordingly. Here is the translation log:
Hi @gsgoraya, from the log, seems the Geometry parameter in the writer feature type is set to fm0_none, although the feature geometry is point. Try changing the parameter to fm0_point. In addition, the parameter setting for ExpressionEvaluator is not completed (the properties button is red). Set the math expression appropriately.
Hi @gsgoraya,
e.g.
Hello @
Takashi,
Thank you for the advise. I changed geometry from fm0_none to fm0_Point. The process is failing. I tried about 3 to 4 times but no luck. I have attached log file and expression couple other screenshots. Sorry to bother you.
Gurpreet
Hello @
Takashi,
Thank you for the advise. I changed geometry from fm0_none to fm0_Point. The process is failing. I tried about 3 to 4 times but no luck. I have attached log file and expression couple other screenshots. Sorry to bother you.
Gurpreet
Hi @gsgoraya, according to this part of the log
GeoMedia Writer: Writing to Existing GeoMedia Warehouse version 5
Table TRAPEZE_DATS_TRIP_DATA_2015 exists, appending features...
GeoMedia Writer: Failed to determine Geometry field name for 'TRAPEZE_DATS_TRIP_DATA_2015' table
A fatal error has occurred. Check the logfile above for details I guess that the destination GeoMedia table exists and the schema of the table does not match the writer feature type configuration. If you will create a new table or overwrite the existing table in the destination GeoMedia dataset, try setting 'YES' to the 'Drop Table' parameter in the writer feature type.
Hi @gsgoraya, according to this part of the log
GeoMedia Writer: Writing to Existing GeoMedia Warehouse version 5
Table TRAPEZE_DATS_TRIP_DATA_2015 exists, appending features...
GeoMedia Writer: Failed to determine Geometry field name for 'TRAPEZE_DATS_TRIP_DATA_2015' table
A fatal error has occurred. Check the logfile above for details I guess that the destination GeoMedia table exists and the schema of the table does not match the writer feature type configuration. If you will create a new table or overwrite the existing table in the destination GeoMedia dataset, try setting 'YES' to the 'Drop Table' parameter in the writer feature type.
@takashi, Thank you for all your help. I was able to write the file.
Hi @gsgoraya, according to this part of the log
GeoMedia Writer: Writing to Existing GeoMedia Warehouse version 5
Table TRAPEZE_DATS_TRIP_DATA_2015 exists, appending features...
GeoMedia Writer: Failed to determine Geometry field name for 'TRAPEZE_DATS_TRIP_DATA_2015' table
A fatal error has occurred. Check the logfile above for details I guess that the destination GeoMedia table exists and the schema of the table does not match the writer feature type configuration. If you will create a new table or overwrite the existing table in the destination GeoMedia dataset, try setting 'YES' to the 'Drop Table' parameter in the writer feature type.
@takashi, sorry to bother you again. Can I change the pickup and drop off points' color and draw polylines between them in FME? Thank you in advance.
goraya
Hello @
Takashi,
Thank you for the advise. I changed geometry from fm0_none to fm0_Point. The process is failing. I tried about 3 to 4 times but no luck. I have attached log file and expression couple other screenshots. Sorry to bother you.
Gurpreet
Hi @gsgoraya,
Which points should be connected to form a polyline?
Hi @gsgoraya,
Which points should be connected to form a polyline?
Hi @takashi , thank you for your response. As you see in the sample spreadsheet, every row has unique bookingid. I want to create polylines between the pickup and dropoffs. So I can see the trend where these persons were picked up and where did they go. That is why I also want to label all pick up with one color and the drop off with the other color. Let me know if you have any other questions. Thanks
Goraya
