Problem

 User would like to create a new street group from a list of NE_ID’s which have been queried outside of the TMA forms.

Solution

 Please first test the script on your test system before applying it to live, just in case something unexpected happens. Run all scripts in SQLPlus as the highways table owner.

1 – Create a new temporary table using the script below:
create table temp_streets_tab (NE_ID number(9) not null);
2 – Populate the above temporary table with the NE ID’s of the streets you want to add to a new street group.
3 – Create a new street group using the Street Groups form in the Atlas application, but don’t add any streets.
4 – Edit the following script by replacing the value <ENTER STREET GROUP NAME HERE> with the name of the new street group created above and then run it:
select tsg_id from TMA_STREET_GROUPS where TSG_NAME = '<ENTER STREET GROUP NAME HERE>';
5 - Edit the following script by replacing the value <ID NUMBER> to be the id of the new street group found above, then run it in SQLPlus as the highways table owner:
declare
  cursor new_group_membs is
    select ne_id
    from   temp_streets_tab;
  l_tab_streets nm3type.tab_number;
  l_group_id number := <ID NUMBER>;
begin
  open new_group_membs;
  fetch new_group_membs bulk collect into l_tab_streets;
  close new_group_membs;
  tma_street_group_utils.bulk_add_members_to_group(pi_delete_existing => false,
                                                   pi_tsg_id => l_group_id,
                                                   pi_ne_id_tab => l_tab_streets);
  commit;
end;
6 – Your new street group should now be populated with the data. Clear the data from the temporary table using the script below:
Truncate table temp_streets_tab;

See Also

Product TechNotes and FAQs

External Links

Bentley Technical Support KnowledgeBase

Bentley LEARN Server

Comments or Corrections?

Bentley's Technical Support Group requests that you please confine any comments you have on this Wiki entry to this "Comments or Corrections?" section. THANK YOU!