20220223 10364200 1.0 TRUE Map Sub Permits Table from SQL <div style='text-align:Left;'><p>This dataset shows the subpermits associated with each permit application. <b>Please note data is updated nightly and subject to change as applications are received and reviewed.</b><br /></p>Attribute Information:</div><div style='text-align:Left;'><br /><table border='0' cellpadding='0' cellspacing='0' style='border-collapse:collapse; width:602pt;' width='804'><tbody><tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; width:202pt;' width='270'>Field Name<font> </font></td> <td style='border-left:none; width:400pt;' width='534'>Description</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>GNMasterProjectID</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>For internal use.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>GNCommonID</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>For internal use.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>PR_RecordID</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>For internal use.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>SPR_RecordID</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>For internal use.</td> </tr> <tr height='38' style='height:28.2pt;'> <td height='38' style='height:28.2pt; border-top:none;'>ApplicationNumber</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The permit application tracking number that the subpermit is connected to.  This field can be used to join this table to the main permitting table.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>SubPermitNumber</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>Identification number for the subpermit.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>PermitTypeCode</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The subpermit type code by category, such as mechanical, electrical, etc. </td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>PermitTypeDesc</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The subpermit type description by category, such as mechanical, electrical, etc. </td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>IssueDate</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The date the City of Bend issued the subpermit.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>ExpirationDate</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The date that the subpermit expires.</td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>PermitStatusCode</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The current status code for the subpermit. Updated nightly. </td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>PermitStatusDesc</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>The current status description for the subpermit. Updated nightly. </td> </tr> <tr height='21' style='height:15.6pt;'> <td height='21' style='height:15.6pt; border-top:none;'>LegacyID</td> <td style='border-top:none; border-left:none; width:400pt;' width='534'>For internal use.</td> </tr></tbody></table></div><div style='text-align:Left;'><br /></div><div style='text-align:Left;'>For questions regarding permitting applications, please visit <b>The City of Bend Online Permit Center or call 541-388-5580</b>. For questions related to the data please email <b>GIS@bendoregon.gov</b>. <br /></div>Sub PermitsCommunity DevelopmentTable /9j/4AAQSkZJRgABAgAAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCACFAMgDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD5/ooooAKKKKACiiigAooooAKKK9D+G/wyn8YTfb78vb6PE2Cw4adh1VfQep/AeybSV2Bx+i+HtX8RXX2bSbCa6kH3tg+Vf95jwPxNelaV8AtYuED6pqtrZ552RIZmH1+6PyJr2PSrrw5pF+nhbSmtoLmKEy/ZIV5VRgEsfU5HU5PWvLb/AMW+PfFnjfVvDnh25trJLGaZMqApKI+zcWbJzkj7uOtZc8ntoOxa/wCGfLHZj/hILjd6/Zlx+W6sXVPgDq9uhfS9WtbzHOyZDCx+nLD88Vu+LfFni74feGvD+nS3FreapdJcLcXLhpTkMNhUnHID9welYVz4w+J3gMWs+vKtxaT42rchGycZI3J8wb60Jz7hoea634c1jw5dfZ9X0+a1c/dLjKv/ALrDg/gay6+wr+40PWLe00nWBbO+pQ+ZHaTc7wACdvuM9ue4rwP4lfDCbwjIdS00vPo8jYyeWtyegb1HofwPvUal9GDR5zRRRWggooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKAN7wb4am8WeKLTSYyVjdt88g/gjHLH+g9yK95+Ini2DwB4atNF0ONI7+ePyrWNBnyYxxvx3PYepyecVz/wA0dU07VdadfnklFrGT2VQGb8yy/8AfNVfDMP/AAnnxr1PWbkeZY6Ux8lTyvynbH+oZ/qKxk7y12QzP+E+n3+mfFm7tdU3fbhYu825tzbn8t+T6/Nz71qfDf8A5Lj4v/3rv/0oWr2hf8nHa9/16f8AskVUfhv/AMlx8X/713/6ULQ3e/oA7488ap4W/wB+b/0KKrv7QH/IuaT/ANfbf+gGqXx6/wCQl4W/3pv5xVd/aA/5FzSf+vtv/QDSj9kDE+MEVzPeeC4bNmW6kg2QlW2kOTGFwe3OOa7P4eeLF8a6He6B4hhVtUtVMN3DIuPOT7pYjsc8H0OD3rmfiQMeKPh6P9qP/wBDiqTxxH/whPxc0XxNb/u7XUW8u6A4BOQrk/8AAWU/UZo3SQHlXjfwxL4R8U3WlsWaEHzLeQ/xxH7p+o5B9wa56vfPj9o6S6Npmsov7yCY27kd1YEjP0K/+PV4HWsHdXEwoooqgCiiigAooooAKKKKACiiigAooooAKKKKACiiigD6W+Dv7j4WpLH98yzufqDj+gryn4eeL9c8L2eptpHh99S89laWYRuwj2g4ztHuTzXpHwH1BLnwde6eSDJa3ZJX/YdQR+oasr4QS/8ACPeOPEnhW4O195aIN/F5bEcfVWB+grHbmGR/CMnVdT13xhdXpv8AXdjr9hQhWYEAg88c7QoxwMc1xfhvxfrWj+PNZ1iz0Rrq+uzN51pscmLdIGbgDPBGOa77wva29j+0NrsFrCkMItmYIgwAWETHj6kmq/w3/wCS4+L/APeu/wD0oWi+7Aq/GW6mvofBN3cQmCaeJ5ZIiDmNm8kleeeCcVsftAf8i7pP/X23/oBqn8ev+Ql4W/3pv5xVb/aA/wCRf0j/AK+m/wDQKF9kCp8Sv+Rq+H3+/H/6HFWn8fokPhDTZiB5i34UH2Mbk/8AoIrM+JX/ACNXw+/34/8A0OKrHxpmbWNb8N+FbZszXE/mOB/DuIRT/wCh/lSW6A2/iqftHwgkml5kxbPz/eLLn+Zr5pr6M+Od9HY+BLbT0IDXNyiqv+wgJP67fzr5zq6XwgwooorQQUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAd78JPFKeGvGMcdzIEsr8C3lJPCtn5GP0PH0Y13vxX0O+0DxDZePtFU+ZAyi7AHccBj/skfIfw9a8Fr374X/Ei11vTk8MeInjN1s8mGSflblMY2Nn+LHHPX69c5qz5kNGZ8P9bg8SfG7UdXtkZIrqx3BG6qQsQI/Agipvhv/wAlx8X/AO9d/wDpQtdZ4b+GMHhTx3LrWmXA/s6W3eP7M+S8TMVOAe68HryPevOdF8T2Xgn4w+J73WIrlYZ5rmNPLjyfmmDBsEjggdR6ip0d7dgNz49f8hLwt/vTfziq3+0B/wAi/pH/AF9N/wCgVz/xf1+x8R23hPVdMkd7aRrkKXQqcq0YPB9xXTfHi1uLzRtFgtYJZ5nu2CxxIWYnZ2AoX2QMX4tXiadrHgi+kVmjtkEzKvUhWjJx+Vanw20y98W+Lr34gavEURmaOwjPQcbcj2Vflz3JJ7V0viH4eQeL7zQJ9SnaO0sLcrNbqMNKTt+XPYcHPf8AnXO/E34jWnhzTW8M+HWjW82eTI8HC2iYxtGP4sce31pJ3VkM4D4weKU8ReMDbW0gey04GCNgeGfPzsPxAH/Aa89oorZKysSFFFFMAooooAKKKKACiiigAooooAKKKKACiiigAooooAKASDkHBFFFAHp3hH40azoUcdnq0Z1SzXhWZsTIP97+L8efevSoviT8PPFNssWpvApP/LHUrbO38cFf1r5noqHTTHc+oZJPhdNZWkEl14ea3syzW8ZuExGWOWwM9yBUmqfF3wbpiMV1M3kg6R2kZcn8Thf1r5aopeyXVhc9Q8W/GrWNbjktNHiOl2jcGQNmZx/vfw/hz715gSWJJJJPJJpKKtJLYQUUUUwCiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA//2Q==