kdclaw3 · September 10, 2024 14:41
diff --git a/mapLayers.sql b/mapLayers.sql
 -- add work layer group if not exists
 INSERT INTO systemlookup
 (id, org, [type], [name])
 SELECT 
    id + 'work_layer_group' id,
    id as org,
    'MAP_LAYER_GROUP' [type],
    'Work' [name]
 FROM org o
 where id = '${orgId}'
 and not exists (
 	select 1 from systemlookup s
 	where o.id = s.org
 	and s.[type] = 'MAP_LAYER_GROUP'
 	and s.[name] = 'Work'
 );

 --add the mapwork layers for the layer id
 INSERT INTO mapworklayer
 	([id], [org], [mapId], [name], [status], [styleSpec], [zoomStart], [displayOrder], [layerGroup], [icon])
 VALUES
 --Canceled
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: Canceled','Canceled','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAF6ElEQVRoge2YaWwUZRjHSYTtQndmWii05ei5ZxeWbmd3C4nKadTEA4+IIQgCiaLGgIl+8QOiQNGK3Ak28MGY4BUhEjQQC0QklMsDsUKBcpa22xZaWs6y7PzMO7OUFpCrLW3Nfvjnnbz7vjPP7zneeWa74Vb4P6hbRxsQBXFHI6J0ePoQrRF3x3uaaETc9+8VzS3rIksBpwJ2+bocsjGX1WxdlwBxKGCTr8veSUG0a8a4FMhUIFWGVAtYZWoDFra/aKLkjTguvNufi+8ksn9qPF8+2Ys9AYuxJ12CVMnY62g9XLf79riQS0YbLBPyyoT9CvjiwRbHybGxrFxkonBjIrW7ndQXWVn/dRJPzjRRMMZsRMYbT9gfR6NX5uoQcc9m980yntX+ICJt0hXoJ9EQMFP8wUOUr0mCNS54tC/aY304UWSjumwIjcez4ZSX34symZEXw9qRPcAeB4ttVK/PYNNsEyWP94D+FkiLpGR7gWgR6Slhlznnt1D1RCyhZ/py7r2+FBcqBE9bCVf6OD45gRMT+8AxFc7lQoUPanMp3etk3gIzP443EXohAXYPpabew6bNvTmc1xvtxUSOjJQpVWON5zjvLd3uDcSuQIbCPy+b+GmVieBuGxxXCQmvV/u4cCSbZfmSrotHsqEmgHZK1cdDu+x8OC+G1Z9aqFibQuMBD1rQZ0SsTOX8Pg9zFyjkPd+dkDDe1sYgTTUhUilHoWaywsGCBIr/GERDlQfO5kIwAEE/jSe8/LIlTZe4FtG4BnKgyMb7s7rzzRe9aShxc/Wk8bvYJ+5x+bTKlp2ZfLE0gdXPmilWexmREc9uk4iIfM2SuWqTqB2nUPJNX6qL7YYBFT7CZTlN0o2u9OkS101z1QFKd9nJz+/JpnUDoMqvr7lpb10uJX+6eDuvF989bTbqxdksI1oFYldo9MgUju/OhsUSZ/Y50SpyDG9GjG1hjJiPRKJprlzlfOlQju5xcPrAYGNN+S32Bv1cKPdSvM9F+cwkSIyFDKl1IE35ma4QHqpQOF/i56JkQuUqVAVaGHA7XVtHhREZgtcjcct11T6oz4WvnGjP9UPLiTO6AnE8twpkkAQ58Vz5wcHlWpXwDQ++W5B7nqvyof3hQXspEVIs9w+iF5pL4XDAzK+Te1K/3QUNw1qkTLuoLEdX+GLAcNorSTCwNSCi0OwKWyeYWb6qJ8f2OfSUajeAGyNZ50c7mI02IQkGtQZENHpWidpZAzh52K0XoSjQLgtydc4gQmUewpXtmE7tCmI32u/KNy3s3xBPwyEXVPq7IIjDqJHy13rx1w8S9SVO/ZzveiD2CMj0WP7+UTYi8gBBtLMCxNtGIDaFo2/FsGuTmcYyp378UhuAMw9AjcPgpAoTk9EGWvQ26a5BWnw02USjKFMzLoa/82PYsc7Ktq1DKdpsp2izTR93CG1pW+2MaPtOB7/9ZKX+qQRItqBZJXBI4JL06NzYttwaRLwMRVuQKYE1ljqPzPTn0siamsIjk82MmNSDEZNMjJpiYswUE6PbQOI+Y6eaeCyih1838cKrMez1xUJKxBb7XYIIgMtumdXeGFaPk7g0JxXyMrgyO4Nvl7iYW2Bn0Yr+LF6RxOIVySz5PJmlBW2nZREtL0hm4cpkVhX0p2xBKnycDvlpFE51kJ/rpHRwvyagW4M4FBo8MtOeNjFtQR8ayrz6V55W44MqNSLfg1EwMoomsk6FsyqffD8C9ZVRbPMPBHvsbUDSJUJqHH8VpLG3ZDBXgiqc9ukNHOJal+/BqLIZTI34OFMpPTacbRsDnBmXDKm3AdFElxmIh61DgOF6JMJVKuEqX6cQIT8Es2FSEuEbTrKWEUmxoAXi0X52ozUaKRXuRNIuBdCO56BNvLkjbglik9Cy49BmDERbmIE2P71z6bMMtI9S0Ub30fvA/04tMYofbeIfwE4qqziC7/geiYCIhlFssHUyWSPjnUC6srp1tAFREHc0IkqHpw/RGnF3vKeJRsTd8d4lGhF3x3s0GhG34YR/AR6FljiuULpsAAAAAElFTkSuQmCC'),
 --Complete
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: Complete','Complete','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGd0lEQVRoge2Ye3BU5RmH005NpWMZq1MLRgSS7Cab3T2by2ZDwoiA4dKpDMUWNIZs9uzuOWVNSFt1Qi7unWwIkJIiJEQtjY6t+I8tvdgpglhtiQzViqVGEJgk5LJB7lO1wSFP55xdIwLKJTEJzv7xmz1z5jvfvs97O+934gTZw1dBcaNtQAxEjkXEM+rpI8RqRB59TwuxiMhD8YxblVHyoHf60Tn8pDp8pDh86Jx+DJIfo+xFkNwRjX0QL2nOAKmOAFq7X5VybZACGGXfWANxq9I7fSTba5havJKp1gAp9iC5rlLuf2QW5SvzqV+/iPp1C/m5dx4zpJmY7MUYJB9JxUGmWoNo7DWkOf2D+wkjA/Jp6igySB5M8mNYXOXkla4gt7SKVGeIeT+10tgwjr1bb+LD1mT6X5vC3565mYKSOLJsMzDIASwlHvJKK8h2lZMuV6l7Gc/T1UJdE4jOGSBJrOW2gjXc5VrGxoZk/vGijld2/oD8cg/3VjzM/td1DBxKhMNG6BR479U78ATiyBHnkCKFaHlhKa07zPyi/k4WlC0kobCWJLEOvbTyywSJppHkJcURINdVxsJHiljsXk5wwyL2b7sJOr8DPRk4A4ux+e6nvzMXTmVCjxlO5NDxpoY1q2+g8GcWHB6JI/+eBb138PZf4tn4RA5LA8uZuVwkwyFjkLxqPV1Nul0ViFKwiWIIe+U9/H7zjXT8M5X+zml83J4OfVl8cCiduvpbqFt7i3rN0WwGurLgfQsHdmvx13yTzfU3c2BrMh+1maA3k7PtJga6LITfMRNaO565khZBqkYn1Q43SKQmEsVV5LlWsMK7gD8+m0rP7luhSwPHMyGcDWEL/e3p7HnpdlVn2zOg1zwI0rZLQ6XnG/xu83jYlwwdJuiJPMeJLAgb2PfqBNY3JjDflUe6KKodTm3XwwESKT43GruX4opC9j3/PT5+a1LE+B4z545kDko1utc8CDB476iFg7u1rF49ju1bE6AvW11z0bMnc+h4Ixl34OvMdc1QW7heurKOdlkQnTNIxk8qePDhHJ5qSuD0Xi10CSrEQHfWxcYoNdFzAUh3Fv89aOLwnhSOtRkiay71bDibgU4jnW9MpWLdfUwoCJFsC2AaGkjkYaU7ZS2rouHxJNpe/hbnujJVD59vwBfpk3X0RCJD+NNIXHJdXyacNLPtpYUU+MqwPFRFmsMb7WRDAJlcVIOlxM1rO/OhL42BrogBVwty5fcyQU3RdLr/M53iYCmTi4LXDhJpgT6mSVYcVdM5sMcCp8zqn1wJwLXq3JGIOKVXoeRVLiYtHQKIMjYoLz5r+V08u+lrhN9KUlPjywK4ULwvcPpgDvbQQ9w5FJBUuw+t6KfuyUWcaktSi1Ap0OsOJCUKsqHlx9Chg25hxCAGhjUiDr86jnhr8zn852/T/64WerOvX5DHgrPZ/8I4PnpHE+nz1yuIu2Y27/1hHP97d4RBjgmcOZSDY9hSK5RH+4tx0J4IZ6bBCQscHwF9mMFAdx7yqpJraL+SG6N67SPVsZIkW5Ciivt4elMi2/+URusrRnbt0LJrh0b9bVX08vDq9aje/vsUdv5Vzw8rXSQUhtCKPtKcPoToEKnMf4ouA+JH7wyoXUvnCGByPorZNp1c623MsN7I3dYbuNsazywxnnvEeGYPg5R98u3xzInq+4445jrHI9hFkmx1aGx+0hwKiO8KQGQ/RmcViUsWMKdkJutaltC0RWRNSxFrmnNZ25hIQ9PtNDRNoKFpIr/cNJH1zcOnx6Pa0DyRjc3fpfHJSTQ+M5/mLUt54rkHKHAXkrDEgda2AlMU6JIgBrkGQSrHXDiZ6lA8ZzuMcFo5bygHJ2WgM4+gstUBk3AGHDPBcRO//q0ZwZqPTizDKCtfZD4HJNkWJKekgpbncundOwW6TXBUOSClQ1gByopuPoLqzYA+xZHpnDwgsH1bLj+qLiGx+LMN4DMgk4sCTC+rZP+b86DfGNmgdwzpA70arWV1LiYVfgHIlKIAecsr+VdrPpxJgz5TJK3Gik7rOdthRqq9+N0Sd+F8ZXZVU73Bzq+eX0zjbx4YU3pqyxLWPf0g88sfVdvx54J88qFBmXyVdqcRfWNLNr8KoHdGbD3/+HtJEJ3DS4roUyM0piRGfpWvkpcBuX4VN9oGxEDkWEQ8o54+QqxG5NH3tBCLiDz63hViEZFH36OxiMgRJ/wfScuGoxHLMMEAAAAASUVORK5CYII='),
 --In Progress
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: In Progress','In Progress','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGPElEQVRoge2Za1CU1xnH/VCJZoxCLBXQ+l5gF8ULLLtAv6SZtMm3fMnHdFoSBPb2BqOmmU6NvWhLbKwmapyiZpIPkkxNnFxotZ3E6BBjFBIvXHbf3QWW+2XRCBaljkPg1znv7pqomGgEFjv74T8w75xz3uf3PM95znPenaFrCv8PmhFrA+IgWjwiSszTR4/vES32ntbjEdG+v1e8mmxIdyv43Aq6S8HrlA35XApNmoJfjHPLhu4JEL9LRXcqeB0yHkcYpFlTCUw3EO83jNYdKt4ShcZiCb9T4fOyRbz/fCKfbU6hY1c6HTtkPt2YxsvO+bxrT8Uv5pTKeIpl/A4Vn0v9ej1tCkCuM94tPBt+5lktoa+V8a9VaXalc/y5VPZuT6C6KpmLJzMZ+jSDQ/sW8Lg2k/LiJCMyLWtUfGsVGsskPJpkrKW7I++KrDvpIMKDfns63qdUzpSlULNzFm3/TuPyJ9l0rTfTvEGlvcbEQHAZI6050Gmh7pjKuo0JVJTMo9mdzuUPVtJ11MQ/X76fj9cm4S2SabGrtGjqZIKIRSORcCqcWb2IL36TQvPGdIIVEt6P5jLYoTDWa+Nk+WJq/rQYOm1wMR96bTBQQPBMJpu33Me+dXMJblIY9eTyn75lVP8rkdOvpdD6oomjaxZx2JFmFIpABOZ2ge4IxOdU8dlVjr6QyME3Eug7ZTIMHmnPgX4bw8Ecdmyba+i/wRw4l8dYtxXO59NUa2Zj+X1UbnuAriqJq/6V0GflqpjbbWVIz6Z86zzW22fT6JZpc6dPLEh0TwQc6fhXy3g2pVL/5gL8NQsZ7loBF/IhlAehfK62Wzh2WDIk/qfPdg3Ed8LE+t//gLffeJBhTxajHZZwtMTcgXxGQrkcO6bwekUyrz6TyMHSFKNUC01MRIxNLdPgkGnYsBDf28lcOGsKG9BrY7Qr95oMo/ts1wCuPTuXT0utmS1bZvNx1ULozzPG3DR3sICm00tYs2k2FVoSAVc4xSYEJOBSadAk9j8/h6rd8xioXwLdYW+O9VhvNkZ4ufcGkB4rl1uyaf0iky99y8NjxpsbyuNKpwX9dCZ1O1UaCyW8pXeZWtH8DNhVvGUy/9iVSPWRBYx05xoe/qYB36boOHrDkSH0dSTGHddvg8F8ho+spPXPGfiejXQH33GAfieIt1imaY3KYPVyRvotjN7w4tsFudNniELgzaFts4nGVdL3BxElUOiw80e8vyGJC6eWwcWC61JmMjQajcxgOD3b/2qioeguQPyucL/03m+TqNg9i/Y6s5EakwVwozhvY6TFQvtLdxkR0ewJNb2eQY8viyudOcYGvedAPKJrtcuEKs181bGCsR7LlEGMTSSIaEWEGrck4z+UyCX/UujLuwdBXGGQuhfn0/jeHIb0JUadv2cjUv+XH+KpeoBL/ikG+dLGV8HciQJROfVSImcOJTDSnglDPzH6IqO/mmwNF0BPHl1bzXdefqODxXU04FTxliqcfWE+tXvn8NlBE8erszlxxMyJIybj70mhoxOrmqiOm6n90ET97xS8T4cLj98l06xJ+MRBHbnYfSuI+EjQ5FaMyUHnYj53SRQWZbDiVz/mocJZPFw4k4cLE3ikKIGfFyXwswmQWOfRVQk8FtFPi2fyRMksqkpTabWrYRCnRMvtgIgraJ1LYuuTD7KzLJmuyiVcObCcnn3LqNy7nPK/mXmlIo3tFSlsr0hlx+5Udu6ZOL0a0a49qbyyJ4W9r6XhedPEpXeyGHhnKfv/mM2vn8zlwxITwWekyD1pHJA2TeWUW+IXv7wfR3kil8SlR9zyQlboj8o2dQoJiY1vhQtWtr31ELmFj/BWSRad2uJbgxhfNp5VOLk/A299FiM9otMV9wvRYkdlm1r1Rd7bb6UtUMAnH+Vz9g+Z+EokdPctQBpWSQSeU6HOAlcLjAXGxEIx1lhEDNvgnIXubSbqb6hk14EY36XWqQzXZsNQXjiVQtNIF22MduSO2xFfB2J8EVyt0L07k/MHsjj39+ml8weyCFUupXl9ulHFbgkSLcFGwyj2i316yuu6+XAcF0RcLY1Jjukp7zinfPzHUH2aaUasDYiDaPGIKDFPHz2+R7TYe1qPR0SLvXf1eES02Hv0biPyP/wNs1cWI4b+AAAAAElFTkSuQmCC'),
 --On Hold
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: On Hold','On Hold','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGU0lEQVRoge2Ye1BU1x3H19fyZg0aBSk+EFjjC/bJo8iy9y44GZukzUz+y9hoxhmTThoLArt7V8SaSoCCqFXE0XSSTtIZTWqjtpNoTGNMfEyMTmJGmCgWeWNUHJvWaIOfzrkXiCbEiBIWO/vHd/bOnXPO/j6/3+/8zu9cnUGR+H+Qzt8GBECUQEQkv6ePIbBHFP972hCIiHIvnnGqivRKhHllQjwywW5JlXgOV2QixTivU9NwB4nwSoR6XQR5ZPRuTcEqiItIRR5uIE5V4V6Z0e4cdAUudMsl9G4Xk5U0counsbRqBiu2WiiuNbG4bCbJz08nOs9MhCIzslBGV6DNFdC96xmGBuSb1BESnh+rZBOzIou4EgexJU6CvLmkrDSxcV0Qn+2M4urhJK4fjOeDl8fz5DMjSXh2mhqZiSUycSXZRPuyiFIc6lqRQoqmgUbsrkBCvC5GFOWi+8184hUrFTVRHHh7Cn8/lI6xLBdTWRb1R41wegY0JMO5FBoOTGVVyWgSn4tHr+Sy7i0H7783k9L1D5DmM6LLy2GEez6hSs6PCdKbRhJBHhdxvnTSVpvIrJxH/h9NfP52BJyNhTYLj68180ilmavNduiyQZsVLqXSdNzI78v1POr5CY9UpXP2VCq0JHFqTzjlL0/Htd7BQz4r0QU2NToiagPZSwMCCfa4GOHO4RcvxLPzpSAaP07iq2Y7/21MgU4L/25I4cUqA6WVBvWZ8zZutFjgCzufH01i1e+C2FYZSf2uafynfi60W7jemEJ3q5X2OhOlFZFk/mo8Bm82wUruYINoe0LnziVuhYMlFbN4489xdB6OgaaZcMEG7TbosHO90cSxvXGqxDPt1j6QukOJeIpH89dtY+HkDBDwIlodNrgo1kih7r3JVG+OJiN/ChN7ioLQoIBoG9vJmCKJh0vNnNw+ge7j8ZoBbVa6m819Uo1ut/YB9L07b+fM0STKy0N4581Y6BSG9zO3K5WmY0ZWluhJzZ+mVjNxHt1JRftBkBBvDuMVBwt8sWzeMo4rnxihWfPmjVbLd40RXm77FkirhS/PJHP2IyMX6mZrY/qb22GDpmRajyWydIsF3TIXowplxt4biDZZVKcHfdmU10zk9L4oulvMqodvNuB26h0nCoGYR8c3keh3XIeIjI2/HMwguzqL6JVOQj1aZtwTiG65VvP3fSjSIZkbLZoBAwUZyDvUFDVzrs7K/A1Z6PLluweJ8MrqqT21IJknVk/l1PFk6LKrf3InAHer7mZNXDKpTvt5zTx0ebJaku8KJFQ0fV4Xj5VM5bVNY+g8kaimxo8F8G1x3kxXg4UFG+8xIqJj1RdJeF+1cuWUUd2EYoPedyBBRZJacl/YYYfG2dCaMmQQNwY1Ih6ZILfM8+uTaNxj4Fr9DPXguz9BPC6eq0rg9BthfCXSq+M+Bvl1dQINb4ZzrW6IQb4wc/mslZ8NFsiy6im07B4F/0yEK2lwyQ4Xh0Bf2vi6zc5jmx3o8rS7z52DeJ09FxsBkcPIQhcPr3mI2pfGs+9vRo78Yy6H9idxaH+i+ntY6N3B1ZEefXYwgf17jaSV/RRdnkutoOoJ7xM2iq5Y2PtDID5ZbdhE1Qr2SIxzz2POkjlkPjmJrIXBOBaOwbFQj3ORHnmRHmkQJNZxLdaT06MFi0fhWhLKhDyL2nmPKRQfMO4QJNLnwuBxYHjaiL0gkZIdaazZ40DZMY81W1Oo2phAdc0kqmuiqa6JYd3mGNbXDp429OgPtTFsqp3Ixq2xlG83U7Y7k4pdGSwodRC2SCYs7yag/kDCfDk84MlizlNRFK+O4OvGZLgs7ho9zVynkHXo1CFkgQsmuGjilT9lMPeXEuOWCVtvAyJa5knF2dS+PovzJ5Kg1aQZ325Wb3PqouriQ6R2IUuPI81cqbeyb28qmRUORhTc2hHfAqLLl5j8WyefnkyHq2Ix0X4LCD+rrUf/EtdnM4/XfreRvBVkuUTcKidHjtnhsqnPE8NGXSauNVl4dFOWCvK9ERH91YRiJ0tfyWTt7nTW7MwYVqrclcHK1zOY82K2Wo6/F6T3Q0OwaBgLh6f0RRLhHs3Wm6+//YKEuLXoDEcFF/We8rcFuX+l87cBARAlEBHJ7+ljCOwRxf+eNgQiovjfu4ZARBT/ezQQEUVzwv8AXh2hmsqgS/AAAAAASUVORK5CYII='),
 --Pending
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: Pending','Pending','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGe0lEQVRoge2Ye1BU1x2AyTTVmIwzmSaZkWa0mga0Ii4iSCe2TZMmbTOTh50kbew0tumkrTGtdWraZjRj2yR2GElQBFnY97JZiSzsi+WlCGG5d++uoISUhxUQRNgFH7HjoyOp8nXuXTBBg6mCPDr7xzd75+65Z37f+Z1z7u/cKINo4/+BqMkOICIiRjJim/TpY4isEXHyR9oQyYh486OiFwoUDGIhBp8DnehAO4Te58AkOTH6ij7TbjqISC50Phca0amg9zkx+V0YJfsUExEKFPRiEVqfh1yhhJxaN3pfMZrKLHZaV2NzrUasWYtY9Svyi15kY+bzvLXnrxh9djSCmxzBg04qUSSH+zNMiMiV4G1DFGIQ3sdUayZPNGORrBgDpWhK/0JO5p343p/JWeEBzn8wjwrdbFa9HMW69Ocw+11YAzbyxDwMXhP62t1Kf4arsnvrRXwudFIZu8RqDPu2U1aUSIuoort9NfaGPdgCORyti+Nc01wutcVBZzxNldH8aXMUf85Zg/FAKYc7NnLk4LfIz1uEuuh3qIUKjAf2YQ54bqHIZ6aRPO/1VdnkVWzB7s+gWnqFlrK7GGicBT0J7N63AevejQwGV8LJBAgmwccpdNY/SGrql0jLfQJP7d+50P1DPjl8H77C29hb8X2K63eQ5XmLd11pGMQiZWO4kbV0QyKyhFYqxVT0M9ymWfQ2LGYw+BD/6UqAvkQudCSQnnGvgnzNiWQGe5bDyRUcCcTyt60zMe/4Cl1lC7n4T1kykYFOFYRSONOWwta02ax9MwmdN5+8uvLxFVE6E23o/BVYvHmUeH6NVJJAR83dfNK+APoTIJQM/SkMdCUgls5BLJujXMv3h0VapRg2bbkdm2Y2Fw8tYLBzafi5vhVwMhG6v4G//B5ydfPYlPU0qYVvK5uCvF2PW0ZkmRzBjm3vJlpsczjrjw4HEEzi8vHEKyhBh5IU5Osr906soD0Qy7Zts6h03Q/9yUqba549k0J74AFe2xzFG+pnMUrydu3EIMpZKRijiORG57WQbnySAst8zjTEwLF4RWKwd/m1wchrIniVSO9yzrerOFq3kFOtS8JtPu/Z/mQGjsZxRJpLcc06srzlaATX2ESG56fOX45RsJK/ewmS63Yu9SyDEykjArgew+0IhjND36eZ+Nx2oWVwKpFjHT/HVZeB2WdFJ8jVgG1sIjlCKRb/HroOr4JjsQz2hAO4UZH//V6iAr0qznY9gqc+HbW3+OZFDPIi89nZ7niTbOszBFtWwulPJb5I4Ga5fDwMoYWKUPnBbWR7PWMRcSr1UuZ7z6LNiOJ4/QJlatwqgauhN46L3Q9RWv8O2WPJiFZwoBWcVAd+Q1/jfAY646A3aTqK2NEIDuo/fJXBjkXQHT9hEoPjKRI+SzgpK/spR1x3caEl5soLbtqJ6HwuPMUv0Gybyfmmr0PfNBXRii5KPC/Qar+DC80PTqxIMI4BWeTgmEWcSkbc7mdoskUx2PY1OPdN+HgFnJ4A/qWCk9+mouFddt2oyHClaZLsGPzFaMRi9pRvoNIRj7diCWLVEnz7Y/Htj1F+JZmq8cU/RF3VXHzVS9ntTUMtlKOpdSjvNbPfjnHEsfo6Ima/QzlfawQnZr+b7Eo9q17/Act+cg/fWXMHD6/5Mg+vmcEjL83gey/N4NFxQO7nsV/O4PEhHn0xiqfW3c1W29uYDlSiqXUqHzTyAnJF/AUiZr+T3Bora3e+wuvq55Eafkvr0U1IH/0Rbf53Sd05n+3qr7JDPYcd6mgycqLZmTt+ZA6RlRtNRva95BrmUS2uprntNT5qXU96wQZ+nLqZ1GIDloB99KllqStBXWXiqQ2LWb/5Nv7dHgenE6B3qXJwoj9pAklWCkyCKuiPhxPxZOpULPvF47yRvx1rvXt0Ea1YjEnIY+/+x2iT7udydzyEVEoBRygx3PFEEpLL/aGBDKrobVzMB/tXYvW+o8SqH00k2+vmPcnCuZ4fwZlF4Q56VFOHU7FwKpl9DWnsqhlZSI4QUXvdWHwW+jqehlAM9MaHZaYKoVguHU+m7GDaNRXxyKkl2DGJ+dR8uIXG5nUcalrPoabfTxkam1+l7h9/oMCvVbbjUUXk46T8p1Iw1jqmLHqh8Jrj7ygiRWhq7YrQVEIzFFM4E9cVmb5ETXYAERExkhHbpE8fQ2SNiJM/0oZIRsTJH11DJCPi5I9oJCNieBD+C17SWY6gALbtAAAAAElFTkSuQmCC'),
 --Ready
 (replace(newid(),'-',''),'${orgId}','${mapId}','Status: Ready','Ready','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGQElEQVRoge2Ya1BUZRjHrSm6OJUzXYxypvICmsa6y4Kad0wtL1z2AvYhZ6wPNX3oQzPVxIemppwxu3Hfy1kQ1MRbBV5AMzctLss5Z3dBuZQogsACYjpj2kgpv+acXUk0GhUEbPbDfzi7vO/L83v+z/ue52WEIBn4P2jEUAcQBJGCjhiGvHyE4B6Rhj7TQtAR6eazYhcTVKmfZRM22YRVMqqyy0ayPSYcsrH3uOHoiP3KAN1+EItkVKU8qyDu4QYiJqiyKxmXE8mUzGRWGLG5zVgOLiJl87Ns2aXh55KZlBycwaYCHW9nTebDb+eorlgkE5miCZs7Ebts6llPGBSQnuANPRLEeLJdy1knxpIrx+PwJmHdNxtr+r2U5Y/ibMkEzh8Yy/fCwyS8dgdvpE4ix2tmvddIrhSHw7Uce0Wcfy2pt7u3HkQ2Y/UkkSa/jHAghqLvRlNbOpamhjlsqzGzxbOMBjmcc4fDuFgfAcc1VO97ineT7+QdYTKOqiRqGxfzq+c5Nm14hMxCHelSIkLly+RUJt5CkCvKSKl1+8+LWeeczXb3EpziDGqLH6CrMhRadHztnMlG5yy626KhUw8+PZyexnE5jDVrQvhUGMcO10LONT/PX3XjKNt+P3v3TaKwcilpe+axtigGIXAw3MheuiEQ9RRyJ5FTMJkduffQ6g2n2xfNX41ToT2S88em8mXqKFXKMyej6G6JhM5ojlSE8dHqe8hLeYjG4rFc+FUDvki6jk+FNj1n6nWs/uxBXv8kFJsrnnWHVgwsiLqYZMDmXUGeK5ade/SUFz3NsQOj+bN+EnTooS0KOqLpatRSWjRGlfKsBHgZpK58Askf3MV2+ygueMLpDgDQHgWdUdCkwVU8Blt2KO9bwlhd4D8UFA2YIwpMpmhgi3M2tdse42z5M/4AfHouNet6pAatBBcA6PnuZDRHK8JYu/Y+fih8Ejqi1DHXzD0zTR33TvLdJNsn4fCYcbhNCJLiSkI/QTxm7OWxfJE3jq0bH+WMNxyUUvLp6W6NvDYYZU/4rgJpjeTcUQ0NUjin6qb4x/zb3I4ouho01JeNp7BkJqkVZixiP0Eu16fNk4RDjGNT/hO4CkZxsUWnZvjKAP5Ll8cp+0GZR/s/TvQ57lQUjcfn8p13KTlSPDZRicfQPxDlRZfrMdB4ZAY0RdAdCOBGQa7/O53fnRYdZ5ui2VG5hIwK5QS72T2ibDLZyBc7Z5G5ORxfnRZORfcqmVuhS81+4dOoULurXiK9fyAmtV9Ky5+II+UumuXxamncKoCrRauWCyf07Kpa0j8Qq2hU5ZRm0VEZRldDhLpBb0sQi2hEPDwHjk2GE1MHDaJ7IEFskgmrbGL39xEcKXyQ8zXh6ovv9gOR/SA7i6ZQs/V+tQFUXoK3rSO7iqdQ981IvyODCeLTcqE5amAcsclmCneHUb31Drrrx8Pv0+F0NPw2CDqjh85pFB9eQprrBkEud5rZbqPamlgkM/k/6NlX+Dg/7Z1IqTOCsv1hlO2foP4sV+QcWLkCkvaPo+zHiWwsX0yGmKgePIJsIMdjwCFfda3uCyRHuVt7TOrkHK+RjIPLiHtfizYplDkr72XuyruZuzKE+atCWLAqhJgBkLLOC6+GsDCgmFfuZPmbI/m4YC6OqhU9IOu81wGiAFjK4ng9S8t79imUHppHTdOLlNYsRNgcyZq08XxleYIUy+OkWEJJtYaSZhs4pQeUYQslNWs0tpwxOF3TqW5YSNWRGD7/ZhHmz5axek88ud7/KK3cqkQyS5az7O1HeSt5JH8cjYBTSqeqVS9O6t1jMNWu/G0dtGvhpJYMYTraVQtI3hbL+kPGvkGskolsMY69Tg315RO4dEILPp3awNEW6YdRFh8stQVAlET6tLRW6jiwfzobypaq/4Wx9wWS7jKS547nrG8WnFYWUCC0fpDhoE4N/KZjb/VL15xkvUCUdjlPjqe94Xlo0/gz0TKM5NNwsTnyXzviXiAW0UC2lMCP1Yuo/GU+cl3MsJL3l/lU1C4g3xOrnmJ9gijXSeWXVtFAVoW/aRxOygrE5Afoff3tE8Q/2TDMZFRjuw6Q21cjhjqAIIgUdMQw5OUjBPeINPSZFoKOSEOfXSHoiDT0GQ06IvmT8DeUXAXYvDktEAAAAABJRU5ErkJggg==');
	-- add work layer group if not exists
	INSERT INTO systemlookup
	(id, org, [type], [name])
	SELECT
	id + 'work_layer_group' id,
	id as org,
	'MAP_LAYER_GROUP' [type],
	'Work' [name]
	FROM org o
	where id = '${orgId}'
	and not exists (
	select 1 from systemlookup s
	where o.id = s.org
	and s.[type] = 'MAP_LAYER_GROUP'
	and s.[name] = 'Work'
	);

	--add the mapwork layers for the layer id
	INSERT INTO mapworklayer
	([id], [org], [mapId], [name], [status], [styleSpec], [zoomStart], [displayOrder], [layerGroup], [icon])
	VALUES
	--Canceled
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: Canceled','Canceled','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAF6ElEQVRoge2YaWwUZRjHSYTtQndmWii05ei5ZxeWbmd3C4nKadTEA4+IIQgCiaLGgIl+8QOiQNGK3Ak28MGY4BUhEjQQC0QklMsDsUKBcpa22xZaWs6y7PzMO7OUFpCrLW3Nfvjnnbz7vjPP7zneeWa74Vb4P6hbRxsQBXFHI6J0ePoQrRF3x3uaaETc9+8VzS3rIksBpwJ2+bocsjGX1WxdlwBxKGCTr8veSUG0a8a4FMhUIFWGVAtYZWoDFra/aKLkjTguvNufi+8ksn9qPF8+2Ys9AYuxJ12CVMnY62g9XLf79riQS0YbLBPyyoT9CvjiwRbHybGxrFxkonBjIrW7ndQXWVn/dRJPzjRRMMZsRMYbT9gfR6NX5uoQcc9m980yntX+ICJt0hXoJ9EQMFP8wUOUr0mCNS54tC/aY304UWSjumwIjcez4ZSX34symZEXw9qRPcAeB4ttVK/PYNNsEyWP94D+FkiLpGR7gWgR6Slhlznnt1D1RCyhZ/py7r2+FBcqBE9bCVf6OD45gRMT+8AxFc7lQoUPanMp3etk3gIzP443EXohAXYPpabew6bNvTmc1xvtxUSOjJQpVWON5zjvLd3uDcSuQIbCPy+b+GmVieBuGxxXCQmvV/u4cCSbZfmSrotHsqEmgHZK1cdDu+x8OC+G1Z9aqFibQuMBD1rQZ0SsTOX8Pg9zFyjkPd+dkDDe1sYgTTUhUilHoWaywsGCBIr/GERDlQfO5kIwAEE/jSe8/LIlTZe4FtG4BnKgyMb7s7rzzRe9aShxc/Wk8bvYJ+5x+bTKlp2ZfLE0gdXPmilWexmREc9uk4iIfM2SuWqTqB2nUPJNX6qL7YYBFT7CZTlN0o2u9OkS101z1QFKd9nJz+/JpnUDoMqvr7lpb10uJX+6eDuvF989bTbqxdksI1oFYldo9MgUju/OhsUSZ/Y50SpyDG9GjG1hjJiPRKJprlzlfOlQju5xcPrAYGNN+S32Bv1cKPdSvM9F+cwkSIyFDKl1IE35ma4QHqpQOF/i56JkQuUqVAVaGHA7XVtHhREZgtcjcct11T6oz4WvnGjP9UPLiTO6AnE8twpkkAQ58Vz5wcHlWpXwDQ++W5B7nqvyof3hQXspEVIs9w+iF5pL4XDAzK+Te1K/3QUNw1qkTLuoLEdX+GLAcNorSTCwNSCi0OwKWyeYWb6qJ8f2OfSUajeAGyNZ50c7mI02IQkGtQZENHpWidpZAzh52K0XoSjQLgtydc4gQmUewpXtmE7tCmI32u/KNy3s3xBPwyEXVPq7IIjDqJHy13rx1w8S9SVO/ZzveiD2CMj0WP7+UTYi8gBBtLMCxNtGIDaFo2/FsGuTmcYyp378UhuAMw9AjcPgpAoTk9EGWvQ26a5BWnw02USjKFMzLoa/82PYsc7Ktq1DKdpsp2izTR93CG1pW+2MaPtOB7/9ZKX+qQRItqBZJXBI4JL06NzYttwaRLwMRVuQKYE1ljqPzPTn0siamsIjk82MmNSDEZNMjJpiYswUE6PbQOI+Y6eaeCyih1838cKrMez1xUJKxBb7XYIIgMtumdXeGFaPk7g0JxXyMrgyO4Nvl7iYW2Bn0Yr+LF6RxOIVySz5PJmlBW2nZREtL0hm4cpkVhX0p2xBKnycDvlpFE51kJ/rpHRwvyagW4M4FBo8MtOeNjFtQR8ayrz6V55W44MqNSLfg1EwMoomsk6FsyqffD8C9ZVRbPMPBHvsbUDSJUJqHH8VpLG3ZDBXgiqc9ukNHOJal+/BqLIZTI34OFMpPTacbRsDnBmXDKm3AdFElxmIh61DgOF6JMJVKuEqX6cQIT8Es2FSEuEbTrKWEUmxoAXi0X52ozUaKRXuRNIuBdCO56BNvLkjbglik9Cy49BmDERbmIE2P71z6bMMtI9S0Ub30fvA/04tMYofbeIfwE4qqziC7/geiYCIhlFssHUyWSPjnUC6srp1tAFREHc0IkqHpw/RGnF3vKeJRsTd8d4lGhF3x3s0GhG34YR/AR6FljiuULpsAAAAAElFTkSuQmCC'),
	--Complete
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: Complete','Complete','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGd0lEQVRoge2Ye3BU5RmH005NpWMZq1MLRgSS7Cab3T2by2ZDwoiA4dKpDMUWNIZs9uzuOWVNSFt1Qi7unWwIkJIiJEQtjY6t+I8tvdgpglhtiQzViqVGEJgk5LJB7lO1wSFP55xdIwLKJTEJzv7xmz1z5jvfvs97O+934gTZw1dBcaNtQAxEjkXEM+rpI8RqRB59TwuxiMhD8YxblVHyoHf60Tn8pDp8pDh86Jx+DJIfo+xFkNwRjX0QL2nOAKmOAFq7X5VybZACGGXfWANxq9I7fSTba5havJKp1gAp9iC5rlLuf2QW5SvzqV+/iPp1C/m5dx4zpJmY7MUYJB9JxUGmWoNo7DWkOf2D+wkjA/Jp6igySB5M8mNYXOXkla4gt7SKVGeIeT+10tgwjr1bb+LD1mT6X5vC3565mYKSOLJsMzDIASwlHvJKK8h2lZMuV6l7Gc/T1UJdE4jOGSBJrOW2gjXc5VrGxoZk/vGijld2/oD8cg/3VjzM/td1DBxKhMNG6BR479U78ATiyBHnkCKFaHlhKa07zPyi/k4WlC0kobCWJLEOvbTyywSJppHkJcURINdVxsJHiljsXk5wwyL2b7sJOr8DPRk4A4ux+e6nvzMXTmVCjxlO5NDxpoY1q2+g8GcWHB6JI/+eBb138PZf4tn4RA5LA8uZuVwkwyFjkLxqPV1Nul0ViFKwiWIIe+U9/H7zjXT8M5X+zml83J4OfVl8cCiduvpbqFt7i3rN0WwGurLgfQsHdmvx13yTzfU3c2BrMh+1maA3k7PtJga6LITfMRNaO565khZBqkYn1Q43SKQmEsVV5LlWsMK7gD8+m0rP7luhSwPHMyGcDWEL/e3p7HnpdlVn2zOg1zwI0rZLQ6XnG/xu83jYlwwdJuiJPMeJLAgb2PfqBNY3JjDflUe6KKodTm3XwwESKT43GruX4opC9j3/PT5+a1LE+B4z545kDko1utc8CDB476iFg7u1rF49ju1bE6AvW11z0bMnc+h4Ixl34OvMdc1QW7heurKOdlkQnTNIxk8qePDhHJ5qSuD0Xi10CSrEQHfWxcYoNdFzAUh3Fv89aOLwnhSOtRkiay71bDibgU4jnW9MpWLdfUwoCJFsC2AaGkjkYaU7ZS2rouHxJNpe/hbnujJVD59vwBfpk3X0RCJD+NNIXHJdXyacNLPtpYUU+MqwPFRFmsMb7WRDAJlcVIOlxM1rO/OhL42BrogBVwty5fcyQU3RdLr/M53iYCmTi4LXDhJpgT6mSVYcVdM5sMcCp8zqn1wJwLXq3JGIOKVXoeRVLiYtHQKIMjYoLz5r+V08u+lrhN9KUlPjywK4ULwvcPpgDvbQQ9w5FJBUuw+t6KfuyUWcaktSi1Ap0OsOJCUKsqHlx9Chg25hxCAGhjUiDr86jnhr8zn852/T/64WerOvX5DHgrPZ/8I4PnpHE+nz1yuIu2Y27/1hHP97d4RBjgmcOZSDY9hSK5RH+4tx0J4IZ6bBCQscHwF9mMFAdx7yqpJraL+SG6N67SPVsZIkW5Ciivt4elMi2/+URusrRnbt0LJrh0b9bVX08vDq9aje/vsUdv5Vzw8rXSQUhtCKPtKcPoToEKnMf4ouA+JH7wyoXUvnCGByPorZNp1c623MsN7I3dYbuNsazywxnnvEeGYPg5R98u3xzInq+4445jrHI9hFkmx1aGx+0hwKiO8KQGQ/RmcViUsWMKdkJutaltC0RWRNSxFrmnNZ25hIQ9PtNDRNoKFpIr/cNJH1zcOnx6Pa0DyRjc3fpfHJSTQ+M5/mLUt54rkHKHAXkrDEgda2AlMU6JIgBrkGQSrHXDiZ6lA8ZzuMcFo5bygHJ2WgM4+gstUBk3AGHDPBcRO//q0ZwZqPTizDKCtfZD4HJNkWJKekgpbncundOwW6TXBUOSClQ1gByopuPoLqzYA+xZHpnDwgsH1bLj+qLiGx+LMN4DMgk4sCTC+rZP+b86DfGNmgdwzpA70arWV1LiYVfgHIlKIAecsr+VdrPpxJgz5TJK3Gik7rOdthRqq9+N0Sd+F8ZXZVU73Bzq+eX0zjbx4YU3pqyxLWPf0g88sfVdvx54J88qFBmXyVdqcRfWNLNr8KoHdGbD3/+HtJEJ3DS4roUyM0piRGfpWvkpcBuX4VN9oGxEDkWEQ8o54+QqxG5NH3tBCLiDz63hViEZFH36OxiMgRJ/wfScuGoxHLMMEAAAAASUVORK5CYII='),
	--In Progress
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: In Progress','In Progress','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGPElEQVRoge2Za1CU1xnH/VCJZoxCLBXQ+l5gF8ULLLtAv6SZtMm3fMnHdFoSBPb2BqOmmU6NvWhLbKwmapyiZpIPkkxNnFxotZ3E6BBjFBIvXHbf3QWW+2XRCBaljkPg1znv7pqomGgEFjv74T8w75xz3uf3PM95znPenaFrCv8PmhFrA+IgWjwiSszTR4/vES32ntbjEdG+v1e8mmxIdyv43Aq6S8HrlA35XApNmoJfjHPLhu4JEL9LRXcqeB0yHkcYpFlTCUw3EO83jNYdKt4ShcZiCb9T4fOyRbz/fCKfbU6hY1c6HTtkPt2YxsvO+bxrT8Uv5pTKeIpl/A4Vn0v9ej1tCkCuM94tPBt+5lktoa+V8a9VaXalc/y5VPZuT6C6KpmLJzMZ+jSDQ/sW8Lg2k/LiJCMyLWtUfGsVGsskPJpkrKW7I++KrDvpIMKDfns63qdUzpSlULNzFm3/TuPyJ9l0rTfTvEGlvcbEQHAZI6050Gmh7pjKuo0JVJTMo9mdzuUPVtJ11MQ/X76fj9cm4S2SabGrtGjqZIKIRSORcCqcWb2IL36TQvPGdIIVEt6P5jLYoTDWa+Nk+WJq/rQYOm1wMR96bTBQQPBMJpu33Me+dXMJblIY9eTyn75lVP8rkdOvpdD6oomjaxZx2JFmFIpABOZ2ge4IxOdU8dlVjr6QyME3Eug7ZTIMHmnPgX4bw8Ecdmyba+i/wRw4l8dYtxXO59NUa2Zj+X1UbnuAriqJq/6V0GflqpjbbWVIz6Z86zzW22fT6JZpc6dPLEh0TwQc6fhXy3g2pVL/5gL8NQsZ7loBF/IhlAehfK62Wzh2WDIk/qfPdg3Ed8LE+t//gLffeJBhTxajHZZwtMTcgXxGQrkcO6bwekUyrz6TyMHSFKNUC01MRIxNLdPgkGnYsBDf28lcOGsKG9BrY7Qr95oMo/ts1wCuPTuXT0utmS1bZvNx1ULozzPG3DR3sICm00tYs2k2FVoSAVc4xSYEJOBSadAk9j8/h6rd8xioXwLdYW+O9VhvNkZ4ufcGkB4rl1uyaf0iky99y8NjxpsbyuNKpwX9dCZ1O1UaCyW8pXeZWtH8DNhVvGUy/9iVSPWRBYx05xoe/qYB36boOHrDkSH0dSTGHddvg8F8ho+spPXPGfiejXQH33GAfieIt1imaY3KYPVyRvotjN7w4tsFudNniELgzaFts4nGVdL3BxElUOiw80e8vyGJC6eWwcWC61JmMjQajcxgOD3b/2qioeguQPyucL/03m+TqNg9i/Y6s5EakwVwozhvY6TFQvtLdxkR0ewJNb2eQY8viyudOcYGvedAPKJrtcuEKs181bGCsR7LlEGMTSSIaEWEGrck4z+UyCX/UujLuwdBXGGQuhfn0/jeHIb0JUadv2cjUv+XH+KpeoBL/ikG+dLGV8HciQJROfVSImcOJTDSnglDPzH6IqO/mmwNF0BPHl1bzXdefqODxXU04FTxliqcfWE+tXvn8NlBE8erszlxxMyJIybj70mhoxOrmqiOm6n90ET97xS8T4cLj98l06xJ+MRBHbnYfSuI+EjQ5FaMyUHnYj53SRQWZbDiVz/mocJZPFw4k4cLE3ikKIGfFyXwswmQWOfRVQk8FtFPi2fyRMksqkpTabWrYRCnRMvtgIgraJ1LYuuTD7KzLJmuyiVcObCcnn3LqNy7nPK/mXmlIo3tFSlsr0hlx+5Udu6ZOL0a0a49qbyyJ4W9r6XhedPEpXeyGHhnKfv/mM2vn8zlwxITwWekyD1pHJA2TeWUW+IXv7wfR3kil8SlR9zyQlboj8o2dQoJiY1vhQtWtr31ELmFj/BWSRad2uJbgxhfNp5VOLk/A299FiM9otMV9wvRYkdlm1r1Rd7bb6UtUMAnH+Vz9g+Z+EokdPctQBpWSQSeU6HOAlcLjAXGxEIx1lhEDNvgnIXubSbqb6hk14EY36XWqQzXZsNQXjiVQtNIF22MduSO2xFfB2J8EVyt0L07k/MHsjj39+ml8weyCFUupXl9ulHFbgkSLcFGwyj2i316yuu6+XAcF0RcLY1Jjukp7zinfPzHUH2aaUasDYiDaPGIKDFPHz2+R7TYe1qPR0SLvXf1eES02Hv0biPyP/wNs1cWI4b+AAAAAElFTkSuQmCC'),
	--On Hold
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: On Hold','On Hold','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGU0lEQVRoge2Ye1BU1x3H19fyZg0aBSk+EFjjC/bJo8iy9y44GZukzUz+y9hoxhmTThoLArt7V8SaSoCCqFXE0XSSTtIZTWqjtpNoTGNMfEyMTmJGmCgWeWNUHJvWaIOfzrkXiCbEiBIWO/vHd/bOnXPO/j6/3+/8zu9cnUGR+H+Qzt8GBECUQEQkv6ePIbBHFP972hCIiHIvnnGqivRKhHllQjwywW5JlXgOV2QixTivU9NwB4nwSoR6XQR5ZPRuTcEqiItIRR5uIE5V4V6Z0e4cdAUudMsl9G4Xk5U0counsbRqBiu2WiiuNbG4bCbJz08nOs9MhCIzslBGV6DNFdC96xmGBuSb1BESnh+rZBOzIou4EgexJU6CvLmkrDSxcV0Qn+2M4urhJK4fjOeDl8fz5DMjSXh2mhqZiSUycSXZRPuyiFIc6lqRQoqmgUbsrkBCvC5GFOWi+8184hUrFTVRHHh7Cn8/lI6xLBdTWRb1R41wegY0JMO5FBoOTGVVyWgSn4tHr+Sy7i0H7783k9L1D5DmM6LLy2GEez6hSs6PCdKbRhJBHhdxvnTSVpvIrJxH/h9NfP52BJyNhTYLj68180ilmavNduiyQZsVLqXSdNzI78v1POr5CY9UpXP2VCq0JHFqTzjlL0/Htd7BQz4r0QU2NToiagPZSwMCCfa4GOHO4RcvxLPzpSAaP07iq2Y7/21MgU4L/25I4cUqA6WVBvWZ8zZutFjgCzufH01i1e+C2FYZSf2uafynfi60W7jemEJ3q5X2OhOlFZFk/mo8Bm82wUruYINoe0LnziVuhYMlFbN4489xdB6OgaaZcMEG7TbosHO90cSxvXGqxDPt1j6QukOJeIpH89dtY+HkDBDwIlodNrgo1kih7r3JVG+OJiN/ChN7ioLQoIBoG9vJmCKJh0vNnNw+ge7j8ZoBbVa6m819Uo1ut/YB9L07b+fM0STKy0N4581Y6BSG9zO3K5WmY0ZWluhJzZ+mVjNxHt1JRftBkBBvDuMVBwt8sWzeMo4rnxihWfPmjVbLd40RXm77FkirhS/PJHP2IyMX6mZrY/qb22GDpmRajyWydIsF3TIXowplxt4biDZZVKcHfdmU10zk9L4oulvMqodvNuB26h0nCoGYR8c3keh3XIeIjI2/HMwguzqL6JVOQj1aZtwTiG65VvP3fSjSIZkbLZoBAwUZyDvUFDVzrs7K/A1Z6PLluweJ8MrqqT21IJknVk/l1PFk6LKrf3InAHer7mZNXDKpTvt5zTx0ebJaku8KJFQ0fV4Xj5VM5bVNY+g8kaimxo8F8G1x3kxXg4UFG+8xIqJj1RdJeF+1cuWUUd2EYoPedyBBRZJacl/YYYfG2dCaMmQQNwY1Ih6ZILfM8+uTaNxj4Fr9DPXguz9BPC6eq0rg9BthfCXSq+M+Bvl1dQINb4ZzrW6IQb4wc/mslZ8NFsiy6im07B4F/0yEK2lwyQ4Xh0Bf2vi6zc5jmx3o8rS7z52DeJ09FxsBkcPIQhcPr3mI2pfGs+9vRo78Yy6H9idxaH+i+ntY6N3B1ZEefXYwgf17jaSV/RRdnkutoOoJ7xM2iq5Y2PtDID5ZbdhE1Qr2SIxzz2POkjlkPjmJrIXBOBaOwbFQj3ORHnmRHmkQJNZxLdaT06MFi0fhWhLKhDyL2nmPKRQfMO4QJNLnwuBxYHjaiL0gkZIdaazZ40DZMY81W1Oo2phAdc0kqmuiqa6JYd3mGNbXDp429OgPtTFsqp3Ixq2xlG83U7Y7k4pdGSwodRC2SCYs7yag/kDCfDk84MlizlNRFK+O4OvGZLgs7ho9zVynkHXo1CFkgQsmuGjilT9lMPeXEuOWCVtvAyJa5knF2dS+PovzJ5Kg1aQZ325Wb3PqouriQ6R2IUuPI81cqbeyb28qmRUORhTc2hHfAqLLl5j8WyefnkyHq2Ix0X4LCD+rrUf/EtdnM4/XfreRvBVkuUTcKidHjtnhsqnPE8NGXSauNVl4dFOWCvK9ERH91YRiJ0tfyWTt7nTW7MwYVqrclcHK1zOY82K2Wo6/F6T3Q0OwaBgLh6f0RRLhHs3Wm6+//YKEuLXoDEcFF/We8rcFuX+l87cBARAlEBHJ7+ljCOwRxf+eNgQiovjfu4ZARBT/ezQQEUVzwv8AXh2hmsqgS/AAAAAASUVORK5CYII='),
	--Pending
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: Pending','Pending','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGe0lEQVRoge2Ye1BU1x2AyTTVmIwzmSaZkWa0mga0Ii4iSCe2TZMmbTOTh50kbew0tumkrTGtdWraZjRj2yR2GElQBFnY97JZiSzsi+WlCGG5d++uoISUhxUQRNgFH7HjoyOp8nXuXTBBg6mCPDr7xzd75+65Z37f+Z1z7u/cKINo4/+BqMkOICIiRjJim/TpY4isEXHyR9oQyYh486OiFwoUDGIhBp8DnehAO4Te58AkOTH6ij7TbjqISC50Phca0amg9zkx+V0YJfsUExEKFPRiEVqfh1yhhJxaN3pfMZrKLHZaV2NzrUasWYtY9Svyi15kY+bzvLXnrxh9djSCmxzBg04qUSSH+zNMiMiV4G1DFGIQ3sdUayZPNGORrBgDpWhK/0JO5p343p/JWeEBzn8wjwrdbFa9HMW69Ocw+11YAzbyxDwMXhP62t1Kf4arsnvrRXwudFIZu8RqDPu2U1aUSIuoort9NfaGPdgCORyti+Nc01wutcVBZzxNldH8aXMUf85Zg/FAKYc7NnLk4LfIz1uEuuh3qIUKjAf2YQ54bqHIZ6aRPO/1VdnkVWzB7s+gWnqFlrK7GGicBT0J7N63AevejQwGV8LJBAgmwccpdNY/SGrql0jLfQJP7d+50P1DPjl8H77C29hb8X2K63eQ5XmLd11pGMQiZWO4kbV0QyKyhFYqxVT0M9ymWfQ2LGYw+BD/6UqAvkQudCSQnnGvgnzNiWQGe5bDyRUcCcTyt60zMe/4Cl1lC7n4T1kykYFOFYRSONOWwta02ax9MwmdN5+8uvLxFVE6E23o/BVYvHmUeH6NVJJAR83dfNK+APoTIJQM/SkMdCUgls5BLJujXMv3h0VapRg2bbkdm2Y2Fw8tYLBzafi5vhVwMhG6v4G//B5ydfPYlPU0qYVvK5uCvF2PW0ZkmRzBjm3vJlpsczjrjw4HEEzi8vHEKyhBh5IU5Osr906soD0Qy7Zts6h03Q/9yUqba549k0J74AFe2xzFG+pnMUrydu3EIMpZKRijiORG57WQbnySAst8zjTEwLF4RWKwd/m1wchrIniVSO9yzrerOFq3kFOtS8JtPu/Z/mQGjsZxRJpLcc06srzlaATX2ESG56fOX45RsJK/ewmS63Yu9SyDEykjArgew+0IhjND36eZ+Nx2oWVwKpFjHT/HVZeB2WdFJ8jVgG1sIjlCKRb/HroOr4JjsQz2hAO4UZH//V6iAr0qznY9gqc+HbW3+OZFDPIi89nZ7niTbOszBFtWwulPJb5I4Ga5fDwMoYWKUPnBbWR7PWMRcSr1UuZ7z6LNiOJ4/QJlatwqgauhN46L3Q9RWv8O2WPJiFZwoBWcVAd+Q1/jfAY646A3aTqK2NEIDuo/fJXBjkXQHT9hEoPjKRI+SzgpK/spR1x3caEl5soLbtqJ6HwuPMUv0Gybyfmmr0PfNBXRii5KPC/Qar+DC80PTqxIMI4BWeTgmEWcSkbc7mdoskUx2PY1OPdN+HgFnJ4A/qWCk9+mouFddt2oyHClaZLsGPzFaMRi9pRvoNIRj7diCWLVEnz7Y/Htj1F+JZmq8cU/RF3VXHzVS9ntTUMtlKOpdSjvNbPfjnHEsfo6Ima/QzlfawQnZr+b7Eo9q17/Act+cg/fWXMHD6/5Mg+vmcEjL83gey/N4NFxQO7nsV/O4PEhHn0xiqfW3c1W29uYDlSiqXUqHzTyAnJF/AUiZr+T3Bora3e+wuvq55Eafkvr0U1IH/0Rbf53Sd05n+3qr7JDPYcd6mgycqLZmTt+ZA6RlRtNRva95BrmUS2uprntNT5qXU96wQZ+nLqZ1GIDloB99KllqStBXWXiqQ2LWb/5Nv7dHgenE6B3qXJwoj9pAklWCkyCKuiPhxPxZOpULPvF47yRvx1rvXt0Ea1YjEnIY+/+x2iT7udydzyEVEoBRygx3PFEEpLL/aGBDKrobVzMB/tXYvW+o8SqH00k2+vmPcnCuZ4fwZlF4Q56VFOHU7FwKpl9DWnsqhlZSI4QUXvdWHwW+jqehlAM9MaHZaYKoVguHU+m7GDaNRXxyKkl2DGJ+dR8uIXG5nUcalrPoabfTxkam1+l7h9/oMCvVbbjUUXk46T8p1Iw1jqmLHqh8Jrj7ygiRWhq7YrQVEIzFFM4E9cVmb5ETXYAERExkhHbpE8fQ2SNiJM/0oZIRsTJH11DJCPi5I9oJCNieBD+C17SWY6gALbtAAAAAElFTkSuQmCC'),
	--Ready
	(replace(newid(),'-',''),'${orgId}','${mapId}','Status: Ready','Ready','{"layout":{"icon-size":["interpolate",["linear"],["zoom"],0,0,14,0.6],"icon-pitch-alignment":"map"},"paint":{},"type":"symbol"}','14','100','${mapId}work_layer_group','data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAADIAAAAyCAYAAAAeP4ixAAAACXBIWXMAABYlAAAWJQFJUiTwAAAGQElEQVRoge2Ya1BUZRjHrSm6OJUzXYxypvICmsa6y4Kad0wtL1z2AvYhZ6wPNX3oQzPVxIemppwxu3Hfy1kQ1MRbBV5AMzctLss5Z3dBuZQogsACYjpj2kgpv+acXUk0GhUEbPbDfzi7vO/L83v+z/ue52WEIBn4P2jEUAcQBJGCjhiGvHyE4B6Rhj7TQtAR6eazYhcTVKmfZRM22YRVMqqyy0ayPSYcsrH3uOHoiP3KAN1+EItkVKU8qyDu4QYiJqiyKxmXE8mUzGRWGLG5zVgOLiJl87Ns2aXh55KZlBycwaYCHW9nTebDb+eorlgkE5miCZs7Ebts6llPGBSQnuANPRLEeLJdy1knxpIrx+PwJmHdNxtr+r2U5Y/ibMkEzh8Yy/fCwyS8dgdvpE4ix2tmvddIrhSHw7Uce0Wcfy2pt7u3HkQ2Y/UkkSa/jHAghqLvRlNbOpamhjlsqzGzxbOMBjmcc4fDuFgfAcc1VO97ineT7+QdYTKOqiRqGxfzq+c5Nm14hMxCHelSIkLly+RUJt5CkCvKSKl1+8+LWeeczXb3EpziDGqLH6CrMhRadHztnMlG5yy626KhUw8+PZyexnE5jDVrQvhUGMcO10LONT/PX3XjKNt+P3v3TaKwcilpe+axtigGIXAw3MheuiEQ9RRyJ5FTMJkduffQ6g2n2xfNX41ToT2S88em8mXqKFXKMyej6G6JhM5ojlSE8dHqe8hLeYjG4rFc+FUDvki6jk+FNj1n6nWs/uxBXv8kFJsrnnWHVgwsiLqYZMDmXUGeK5ade/SUFz3NsQOj+bN+EnTooS0KOqLpatRSWjRGlfKsBHgZpK58Askf3MV2+ygueMLpDgDQHgWdUdCkwVU8Blt2KO9bwlhd4D8UFA2YIwpMpmhgi3M2tdse42z5M/4AfHouNet6pAatBBcA6PnuZDRHK8JYu/Y+fih8Ejqi1DHXzD0zTR33TvLdJNsn4fCYcbhNCJLiSkI/QTxm7OWxfJE3jq0bH+WMNxyUUvLp6W6NvDYYZU/4rgJpjeTcUQ0NUjin6qb4x/zb3I4ouho01JeNp7BkJqkVZixiP0Eu16fNk4RDjGNT/hO4CkZxsUWnZvjKAP5Ll8cp+0GZR/s/TvQ57lQUjcfn8p13KTlSPDZRicfQPxDlRZfrMdB4ZAY0RdAdCOBGQa7/O53fnRYdZ5ui2VG5hIwK5QS72T2ibDLZyBc7Z5G5ORxfnRZORfcqmVuhS81+4dOoULurXiK9fyAmtV9Ky5+II+UumuXxamncKoCrRauWCyf07Kpa0j8Qq2hU5ZRm0VEZRldDhLpBb0sQi2hEPDwHjk2GE1MHDaJ7IEFskgmrbGL39xEcKXyQ8zXh6ovv9gOR/SA7i6ZQs/V+tQFUXoK3rSO7iqdQ981IvyODCeLTcqE5amAcsclmCneHUb31Drrrx8Pv0+F0NPw2CDqjh85pFB9eQprrBkEud5rZbqPamlgkM/k/6NlX+Dg/7Z1IqTOCsv1hlO2foP4sV+QcWLkCkvaPo+zHiWwsX0yGmKgePIJsIMdjwCFfda3uCyRHuVt7TOrkHK+RjIPLiHtfizYplDkr72XuyruZuzKE+atCWLAqhJgBkLLOC6+GsDCgmFfuZPmbI/m4YC6OqhU9IOu81wGiAFjK4ng9S8t79imUHppHTdOLlNYsRNgcyZq08XxleYIUy+OkWEJJtYaSZhs4pQeUYQslNWs0tpwxOF3TqW5YSNWRGD7/ZhHmz5axek88ud7/KK3cqkQyS5az7O1HeSt5JH8cjYBTSqeqVS9O6t1jMNWu/G0dtGvhpJYMYTraVQtI3hbL+kPGvkGskolsMY69Tg315RO4dEILPp3awNEW6YdRFh8stQVAlET6tLRW6jiwfzobypaq/4Wx9wWS7jKS547nrG8WnFYWUCC0fpDhoE4N/KZjb/VL15xkvUCUdjlPjqe94Xlo0/gz0TKM5NNwsTnyXzviXiAW0UC2lMCP1Yuo/GU+cl3MsJL3l/lU1C4g3xOrnmJ9gijXSeWXVtFAVoW/aRxOygrE5Afoff3tE8Q/2TDMZFRjuw6Q21cjhjqAIIgUdMQw5OUjBPeINPSZFoKOSEOfXSHoiDT0GQ06IvmT8DeUXAXYvDktEAAAAABJRU5ErkJggg==');