Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6270 | 6270 | 98640 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6002237.13778 | 2120351.54005 | 37.8022067598879 | -122.43644622191002 | (37.8022067598879, -122.43644622191) | ||
| 6303 | 6303 | 98641 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002235.030730001 | 2120370.79549 | 37.802259510526596 | -122.436454892273 | (37.8022595105266, -122.436454892273) | ||
| 6347 | 6347 | 98618 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005334.04674 | 2118673.6419900004 | 37.797775167941 | -122.42560992276199 | (37.797775167941, -122.425609922762) | ||
| 6421 | 6421 | 42634 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1651 Union St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:52:00 PM | 3 | 5x5 | Permit Number 45045 | 6005069.31611 | 2118819.49736 | 37.7981606875253 | -122.42653635579398 | (37.7981606875253, -122.426536355794) |
| 6518 | 6518 | 97735 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1150 Francisco St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/22/2016 02:46:00 PM | 3 | 3x3 | Permit Number 50638 | 6005694.978999999 | 2120690.49004 | 37.8033333055591 | -122.424504530974 | (37.8033333055591, -122.424504530974) |
| 6568 | 6568 | 92750 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2049 Grove St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/02/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52971 | 5998090.3691 | 2110284.0117 | 37.774327490890705 | -122.450069934151 | (37.7743274908907, -122.450069934151) |
| 6762 | 6762 | 98635 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 3x3 | 6002251.83785 | 2120250.68488 | 37.8019306734253 | -122.436388130233 | (37.8019306734253, -122.436388130233) | ||
| 6782 | 6782 | 42639 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 1651 Union St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/2014 12:00:00 AM | 8 | 3x3 | Permit Number 42688 | 6005258.416780001 | 2118846.41372 | 37.798245281357204 | -122.425883928195 | (37.7982452813572, -122.425883928195) |
| 6818 | 6818 | 98620 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005340.01128 | 2118634.45898 | 37.797667918390005 | -122.42558649363998 | (37.79766791839, -122.42558649364) | ||
| 6913 | 6913 | 42637 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005203.48268 | 2118840.06651 | 37.7982247489172 | -122.42607356463999 | (37.7982247489172, -122.42607356464) |
| 6931 | 6931 | 98630 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002266.09398 | 2120152.5833099997 | 37.8016621223571 | -122.436331772404 | (37.8016621223571, -122.436331772404) | ||
| 6975 | 6975 | 98619 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005336.89801 | 2118653.3555400004 | 37.7977196276222 | -122.425598612003 | (37.7977196276222, -122.425598612003) | ||
| 6980 | 6980 | 98636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002249.0569400005 | 2120273.69699 | 37.8019937006086 | -122.436399401415 | (37.8019937006086, -122.436399401415) | ||
| 7033 | 7033 | 42641 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1651 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 22 | 5x5 | Permit Number 42688 | 6005090.06351 | 2118821.9865599996 | 37.798168695097296 | -122.426464740961 | (37.7981686950973, -122.426464740961) |
| 7085 | 7085 | 42636 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005181.30457 | 2118838.80185 | 37.7982200229931 | -122.426150217479 | (37.7982200229931, -122.426150217479) |
| 7173 | 7173 | 98621 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005341.92436 | 2118613.95929 | 37.797611739554 | -122.42557841412399 | (37.797611739554, -122.425578414124) | ||
| 7261 | 7261 | 98606 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 4.5x4.5 | 6003043.17178 | 2116866.41104 | 37.7926832667819 | -122.43340776527398 | (37.7926832667819, -122.433407765274) | ||
| 7275 | 7275 | 98612 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005312.4459 | 2118826.60748 | 37.7981939516456 | -122.42569556069598 | (37.7981939516456, -122.425695560696) | ||
| 7339 | 7339 | 97732 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005757.30775 | 2120698.05289 | 37.8033575908394 | -122.424289378073 | (37.8033575908394, -122.424289378073) | |
| 7354 | 7354 | 42635 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x5 | Permit Number 42688 | 6005113.3477300005 | 2118824.42387 | 37.7981767035488 | -122.426384344263 | (37.7981767035488, -122.426384344263) |
| 7387 | 7387 | 98089 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 2X Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6007160.90241 | 2115572.1732 | 37.789362361841505 | -122.41906838009899 | (37.7893623618415, -122.419068380099) | ||
| 7419 | 7419 | 97731 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1150 Francisco St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | Permit Number 50638 | 6005778.11415 | 2120709.05822 | 37.803388983478605 | -122.42421815984501 | (37.8033889834786, -122.424218159845) | |
| 7474 | 7474 | 81997 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50638 | 6005918.11487 | 2120722.35908 | 37.8034334081868 | -122.42373462766001 | (37.8034334081868, -122.42373462766) |
| 7476 | 7476 | 98608 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6002968.64851 | 2116857.31006 | 37.7926540495901 | -122.433664967757 | (37.7926540495901, -122.433664967757) | ||
| 7587 | 7587 | 98602 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003137.34298 | 2116882.04608 | 37.792731538790704 | -122.433083047059 | (37.7927315387907, -122.433083047059) | ||
| 7724 | 7724 | 98603 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003120.0075900005 | 2116875.00163 | 37.7927112131931 | -122.433142524628 | (37.7927112131931, -122.433142524628) | ||
| 7814 | 7814 | 98604 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003077.63265 | 2116870.32542 | 37.792695969686 | -122.43328880923401 | (37.792695969686, -122.433288809234) | ||
| 7911 | 7911 | 42632 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1651 Union St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 16 | 4x4 | Permit Number 42688 | 6005134.3142099995 | 2118828.07494 | 37.7981879136105 | -122.42631205408199 | (37.7981879136105, -122.426312054082) |
| 7989 | 7989 | 97733 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005736.8865 | 2120695.23683 | 37.8033487055393 | -122.42435984622801 | (37.8033487055393, -122.424359846228) | |
| 8022 | 8022 | 98629 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002271.7566599995 | 2120123.5232700002 | 37.8015826528763 | -122.43631009602801 | (37.8015826528763, -122.436310096028) | ||
| 8207 | 8207 | 98634 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 3500X Fillmore St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6002253.74096 | 2120233.67924 | 37.8018840885493 | -122.436380326794 | (37.8018840885493, -122.436380326794) | ||
| 8255 | 8255 | 98623 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002295.23154 | 2119980.02637 | 37.80118998188 | -122.43621858733299 | (37.80118998188, -122.436218587333) | ||
| 8271 | 8271 | 81998 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50638 | 6005939.397969999 | 2120724.9413900003 | 37.8034416999448 | -122.42366116024999 | (37.8034416999448, -122.42366116025) |
| 8363 | 8363 | 97734 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005715.837730001 | 2120693.51258 | 37.8033427825912 | -122.424432563629 | (37.8033427825912, -122.424432563629) | |
| 8365 | 8365 | 98605 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 2340 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 9 | 3x3 | 6003064.1459800005 | 2116869.6787900003 | 37.7926934290995 | -122.433335427386 | (37.7926934290995, -122.433335427386) | ||
| 8457 | 8457 | 98627 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6 | 6x6 | 6002279.94472 | 2120071.20683 | 37.801439470916 | -122.43627801543998 | (37.801439470916, -122.43627801544) | ||
| 8576 | 8576 | 97728 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1150 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | Permit Number 50638 | 6005878.13407 | 2120716.4935 | 37.8034150458325 | -122.423872565669 | (37.8034150458325, -122.423872565669) | |
| 8784 | 8784 | 98624 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3500X Fillmore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12 | 6x6 | 6002286.82962 | 2120018.90884 | 37.801296265561 | -122.436250445798 | (37.801296265561, -122.436250445798) | ||
| 8823 | 8823 | 98616 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005322.90286 | 2118744.78417 | 37.7979698765663 | -122.425653549774 | (37.7979698765663, -122.425653549774) | ||
| 8829 | 8829 | 98614 | DPW Maintained 3 | Vitex lucens :: Puriri tree 236 | 2501X Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 5 | 3x3 | 6005316.8578699995 | 2118791.40908 | 37.7980975551137 | -122.425677787418 | (37.7980975551137, -122.425677787418) | ||
| 8881 | 8881 | 97729 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 4 | 3x3 | Permit Number 50638 | 6005819.00921 | 2120706.70735 | 37.80338483759171 | -122.42407647347099 | (37.8033848375917, -122.424076473471) | |
| 9734 | 9734 | 173682 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9739 | 9739 | 173683 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 450x Raymond Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3x3 | 6008515.0 | 2088365.0 | 37.71473375007071 | -122.41245939537501 | (37.7147337500707, -122.412459395375) | |||
| 9776 | 9776 | 99552 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 200X Henry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 12/28/2016 06:02:00 AM | 3 | 3x3 | 6002211.6 | 2107376.8 | 37.7665799711801 | -122.435605827147 | (37.7665799711801, -122.435605827147) | |
| 10038 | 10038 | 96503 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | |||
| 10126 | 10126 | 97736 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1150 Francisco St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/2017 12:02:00 PM | 3 | 3x3 | Permit Number 50638 | 6005674.32361 | 2120686.81612 | 37.8033220514443 | -122.424575748272 | (37.8033220514443, -122.424575748272) |
| 10264 | 10264 | 92961 | DPW Maintained 3 | Tree(s) :: 17 | 2051 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369005 | -122.49227087024799 | (37.748848003369, -122.492270870248) | ||
| 10265 | 10265 | 92962 | DPW Maintained 3 | Tree(s) :: 17 | 2051 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 12/24/2009 12:00:00 AM | 3x3 | Permit Number 53120 | 5985698.5 | 2101265.4 | 37.748848003369005 | -122.49227087024799 | (37.748848003369, -122.492270870248) | ||
| 10282 | 10282 | 173941 | Undocumented 2 | Eucalyptus sideroxylon :: Red Ironbark 36 | 3750 18th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 3x3 | 6004590.0 | 2105440.0 | 37.7613967828987 | -122.42724138037701 | (37.7613967828987, -122.427241380377) | ||||
| 10289 | 10289 | 77643 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006923.4408599995 | 2093174.3728599998 | 37.7278498138936 | -122.41830128179899 | (37.7278498138936, -122.418301281799) | |
| 10290 | 10290 | 37814 | DPW Maintained 3 | Acacia baileyana :: Bailey's Acacia 42 | 450X Moscow St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 8 | 3x3 | Permit Number 40134 | 6003977.37565 | 2090552.2455 | 37.720483755714 | -122.428299091747 | (37.720483755714, -122.428299091747) |
| 10302 | 10302 | 76353 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006742.79477 | 2093189.9157 | 37.7278823207912 | -122.418926882581 | (37.7278823207912, -122.418926882581) | |
| 10418 | 10418 | 77647 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1300X Silliman St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 3x3 | 6006841.82551 | 2093150.82877 | 37.7277805724005 | -122.418581759638 | (37.7277805724005, -122.418581759638) | |
| 10426 | 10426 | 108779 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005562.18075 | 2088048.73923 | 37.7136992126121 | -122.422643108799 | (37.7136992126121, -122.422643108799) |
| 10557 | 10557 | 37839 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003658.0147400005 | 2090473.5929 | 37.720249717041504 | -122.42939741397 | (37.7202497170415, -122.42939741397) |
| 10598 | 10598 | 95755 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.901459999 | 2092257.0440599998 | 37.725134950402705 | -122.43024050589399 | (37.7251349504027, -122.430240505894) |
| 10629 | 10629 | 108781 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005591.90568 | 2088038.18998 | 37.7136719236049 | -122.422539619323 | (37.7136719236049, -122.422539619323) |
| 10658 | 10658 | 75132 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 148X Paris St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002992.1034699995 | 2092540.72564 | 37.725887878997504 | -122.431846767938 | (37.7258878789975, -122.431846767938) | |
| 10679 | 10679 | 43313 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50666 | 6003041.97819 | 2092624.14713 | 37.726119762901504 | -122.43168030790399 | (37.7261197629015, -122.431680307904) |
| 10694 | 10694 | 95758 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.8120900001 | 37.7250063806226 | -122.43033651031901 | (37.7250063806226, -122.430336510319) |
| 10784 | 10784 | 77645 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x4 | 6006883.8507199995 | 2093162.97754 | 37.727816296176705 | -122.41843733843201 | (37.7278162961767, -122.418437338432) | |
| 10794 | 10794 | 77662 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006681.78325 | 2093389.6875599998 | 37.728427415183894 | -122.419151965791 | (37.7284274151839, -122.419151965791) | |
| 10805 | 10805 | 76705 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 4 | 3x3 | 6003030.53484 | 2092605.75448 | 37.726068612152794 | -122.431718554264 | (37.7260686121528, -122.431718554264) | |
| 10838 | 10838 | 77663 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 4 | 3x3 | 6006674.085580001 | 2093407.54115 | 37.7284760037541 | -122.41917984297599 | (37.7284760037541, -122.419179842976) | |
| 10839 | 10839 | 95753 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.3656900001 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) |
| 10863 | 10863 | 99498 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 125 Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6002794.02408 | 2092508.7984200001 | 37.725788983259605 | -122.432529234659 | (37.7257889832596, -122.432529234659) | ||
| 10909 | 10909 | 77653 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006717.25868 | 2093269.9963900002 | 37.7281007670162 | -122.41902083923999 | (37.7281007670162, -122.41902083924) | |
| 10996 | 10996 | 77652 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006723.02825 | 2093252.77715 | 37.7280538116191 | -122.41899967279 | (37.7280538116191, -122.41899967279) | |
| 11025 | 11025 | 97251 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003227.5697 | 2092233.02297 | 37.7250563415646 | -122.43101082650499 | (37.7250563415646, -122.431010826505) |
| 11117 | 11117 | 97240 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003400.64895 | 2092179.59067 | 37.7249194341684 | -122.430408699814 | (37.7249194341684, -122.430408699814) |
| 11184 | 11184 | 76390 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006730.14725 | 2093235.82763 | 37.728007672797496 | -122.418973860459 | (37.7280076727975, -122.418973860459) | |
| 11215 | 11215 | 75214 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x5 | 6002868.59368 | 2092460.8085599998 | 37.725661442297294 | -122.432268027453 | (37.7256614422973, -122.432268027453) | |
| 11401 | 11401 | 97248 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003299.02479 | 2092188.3041400001 | 37.724937602283504 | -122.430760624301 | (37.7249376022835, -122.430760624301) |
| 11480 | 11480 | 95754 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464.56282 | 2092279.46461 | 37.7251972860232 | -122.43019487878999 | (37.7251972860232, -122.43019487879) |
| 11530 | 11530 | 77642 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006942.1040900005 | 2093179.9332599998 | 37.7278661320969 | -122.418237156514 | (37.7278661320969, -122.418237156514) | |
| 11692 | 11692 | 77644 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 10 | 4x5 | 6006907.53511 | 2093169.55905 | 37.7278357008551 | -122.41835592728 | (37.7278357008551, -122.41835592728) | |
| 11694 | 11694 | 75308 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 125 Excelsior Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 4x5 | 6002852.682680001 | 2092471.3085599998 | 37.725689370766204 | -122.43232378004 | (37.7256893707662, -122.43232378004) | |
| 11783 | 11783 | 75049 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6003005.92399 | 2092563.3958599998 | 37.7259509097926 | -122.431800609333 | (37.7259509097926, -122.431800609333) | |
| 11786 | 11786 | 76372 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006736.19364 | 2093210.27498 | 37.7279378512454 | -122.41895114628299 | (37.7279378512454, -122.418951146283) | |
| 11797 | 11797 | 37838 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/07/1998 12:00:00 AM | 3 | 4x6 | Permit Number 40134 | 6003644.26117 | 2090451.27602 | 37.720187661114295 | -122.429443364835 | (37.7201876611143, -122.429443364835) |
| 11942 | 11942 | 77664 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006642.942430001 | 2093520.0050400002 | 37.728783051183 | -122.419295481395 | (37.728783051183, -122.419295481395) | |
| 12050 | 12050 | 77660 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 6 | 3x3 | 6006693.80957 | 2093349.8856099998 | 37.728318804950796 | -122.419107568078 | (37.7283188049508, -122.419107568078) | |
| 12057 | 12057 | 77641 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 12 | 4x4 | 6006964.988919999 | 2093186.8525200002 | 37.7278864190206 | -122.418158533295 | (37.7278864190206, -122.418158533295) | |
| 12059 | 12059 | 76663 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 148X Paris St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6002979.0601 | 2092519.0806099998 | 37.725827707182 | -122.431890313086 | (37.725827707182, -122.431890313086) | |
| 12068 | 12068 | 77661 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 4 | 3x3 | 6006687.82384 | 2093371.1244700002 | 37.728376785155604 | -122.419129766951 | (37.7283767851556, -122.419129766951) | |
| 12092 | 12092 | 77648 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1300X Silliman St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 01/01/2011 12:00:00 AM | 3 | 3x3 | 6006817.147419999 | 2093142.9824700002 | 37.727757638780204 | -122.418666516263 | (37.7277576387802, -122.418666516263) | |
| 12191 | 12191 | 76334 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 3 | 3x3 | 6006750.61437 | 2093170.72103 | 37.7278300567077 | -122.41889848919399 | (37.7278300567077, -122.418898489194) | |
| 12201 | 12201 | 43311 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003068.93568 | 2092663.2521400002 | 37.7262286645003 | -122.431589908071 | (37.7262286645003, -122.431589908071) |
| 12260 | 12260 | 97249 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003279.34346 | 2092200.52554 | 37.7249700444293 | -122.43082953217301 | (37.7249700444293, -122.430829532173) |
| 12293 | 12293 | 75309 | DPW Maintained 3 | Melaleuca ericifolia :: Heath Melaleuca 184 | 125 Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 5 | 3x3 | 6002784.56496 | 2092514.51527 | 37.7258041440316 | -122.432562342276 | (37.7258041440316, -122.432562342276) | |
| 12330 | 12330 | 108783 | Permitted Site 1 | Arbutus unedo :: Strawberry Tree 61 | 2055 Sunnydale Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | FUF 1 | 01/06/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773821 | 6005623.18894 | 2088028.7554099998 | 37.7136477830893 | -122.42243082291901 | (37.7136477830893, -122.422430822919) |
| 12344 | 12344 | 43312 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/04/2008 12:00:00 AM | 6 | 3x3 | Permit Number 50666 | 6003053.84834 | 2092643.73268 | 37.7261742132654 | -122.43164067119899 | (37.7261742132654, -122.431640671199) |
| 12381 | 12381 | 75048 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 148X Paris St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 6 | 3x3 | 6003019.452409999 | 2092585.35122 | 37.7260119611657 | -122.431755409402 | (37.7260119611657, -122.431755409402) | |
| 12446 | 12446 | 95750 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.8443200001 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) |
| 12601 | 12601 | 77658 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 5 | 3x3 | 6006705.39704 | 2093310.53877 | 37.7282114196192 | -122.419064719886 | (37.7282114196192, -122.419064719886) | |
| 12657 | 12657 | 75213 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 125 Excelsior Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 10 | 4x5 | 6002883.607340001 | 2092451.48886 | 37.7256367037627 | -122.43221546119 | (37.7256367037627, -122.43221546119) | |
| 12687 | 12687 | 97250 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 301X Excelsior Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/07/2011 12:00:00 AM | 3 | 4x4 | Permit Number 767495 | 6003264.30376 | 2092207.6887700001 | 37.724988860924 | -122.430882033691 | (37.724988860924, -122.430882033691) |
| 12710 | 12710 | 37830 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/09/2007 12:00:00 AM | 3 | 6x6 | Permit Number 49480 | 6003635.85955 | 2090436.9204099998 | 37.7201477680848 | -122.429471383195 | (37.7201477680848, -122.429471383195) |
| 12734 | 12734 | 77659 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 299X Cambridge St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10/26/1984 12:00:00 AM | 8 | 3x3 | 6006700.09662 | 2093328.78928 | 37.7282612330662 | -122.41908433766599 | (37.7282612330662, -122.419084337666) | |
| 12861 | 12861 | 75133 | DPW Maintained 3 | Melaleuca linariifolia :: Flaxleaf Paperbark 155 | 125 Excelsior Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/08/1992 12:00:00 AM | 14 | 4x4 | 6002899.19862 | 2092441.61812 | 37.7256104849218 | -122.43216085884501 | (37.7256104849218, -122.432160858845) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");