Nicely done 
Now, how far away are you, and will you come and re-crimp mine? I just remembered that last time I pulled the headlining down in the back, the connector fell off the end of the wire .. which could be a large part of my problem! 
I think the connector type is called an "FME".
http://www.ebay.co.uk/itm/Coaxial-Connector-FME-male-Fits-RG58-LMR195-/280666949552?_trksid=p5197.m7&_trkparms=algo%3DLVI%26itu%3DUCI%26otn%3D5%26po%3DLVI%26ps%3D63%26clkid%3D4451642004992124988The sat-nav wiring is male to male in the loom (from roof to kick panel). The connector will need special tools to assemble. Another option is just to buy two connectors and a length of suitable coax, and just replace/bypass the whole lot. If can;t do it yourself, then any decent techie could probably make up it up for you.
The other thing I wondered about was using the phone cable instead (my car hasn't got, and never will have a built in government big brother Eschilon tracking device) The phone cable is female to female in the loom, so you would need two gender-benders, one for the roof end and one for the kick panel end. Can't see any on eBay, but RS do them I think.
Another option if you think your aerial base is fubar is to buy a Satnav aerial with an FME male connector on it - something like this.
http://www.ebay.co.uk/itm/GPS-Active-Antenna-FME-male-connector-2M-3M-5M-/380337248482?pt=LH_DefaultDomain_0&hash=item588dddd8e2Just a tip - if trying to repair the in car loom, don't just pull the aerial wiring out into the C pillar. Tie a bit of string to it first, and then pull the string through as you pull the cabels out. That way, you can repair the cable, tie it back to the string, and then use the string to pull the cable back up the C pillar and along the roof channel. With nothing to pull it through, its a git of a job.