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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 118517 | 118517 | 431 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2010X Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5989200.24086 | 2114740.63501 | 37.786051407249 | -122.481148573701 | (37.786051407249, -122.481148573701) | ||
| 22063 | 22063 | 855 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 378 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/16/1995 12:00:00 AM | 6 | 3X3 | 6008306.24694 | 2095178.0824099998 | 37.7334293112951 | -122.41366253820401 | (37.7334293112951, -122.413662538204) | ||
| 17386 | 17386 | 857 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 400X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/24/2015 09:50:00 AM | 3 | 3x3 | 6008157.97396 | 2095088.68273 | 37.7331755118234 | -122.41416883853701 | (37.7331755118234, -122.414168838537) | ||
| 12419 | 12419 | 981 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1604 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/15/2003 12:00:00 AM | 6 | 3X3 | 6001745.7594099995 | 2092854.52102 | 37.7266787581039 | -122.436177732017 | (37.7266787581039, -122.436177732017) | ||
| 141065 | 141065 | 1200 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 87032 | 87032 | 1201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 95862 | 95862 | 1202 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3099X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5996220.7283 | 2087044.1157099998 | 37.7104092959015 | -122.454857840965 | (37.7104092959015, -122.454857840965) | |||
| 78480 | 78480 | 5014 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5313 Diamond Heights Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | ||
| 80001 | 80001 | 5015 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5313 Diamond Heights Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/1997 12:00:00 AM | 3 | 2 | 6001578.667721 | 2098979.6063858 | 37.7434873306528 | -122.437193725781 | (37.7434873306528, -122.437193725781) | ||
| 88812 | 88812 | 5035 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5343 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001794.1836781 | 2098779.6603168 | 37.742950574320204 | -122.43643421934401 | (37.7429505743202, -122.436434219344) | ||
| 89081 | 89081 | 5038 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5361 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001904.577984599 | 2098640.1233312 | 37.7425737107311 | -122.43604252412399 | (37.7425737107311, -122.436042524124) | ||
| 54781 | 54781 | 6305 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1797X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/10/1997 12:00:00 AM | 9 | 3X3 | 6002532.11938 | 2112833.28187 | 37.781580315205396 | -122.434887466275 | (37.7815803152054, -122.434887466275) | ||
| 104103 | 104103 | 7871 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1001 Franklin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 3 | 3X3 | 6006017.92474 | 2113680.1220400003 | 37.7841028269903 | -122.42288843164101 | (37.7841028269903, -122.422888431641) | ||
| 142012 | 142012 | 8890 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4300 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/01/1996 12:00:00 AM | 3 | 3X3 | 5993676.36815 | 2112846.77323 | 37.7811105766569 | -122.46552487036199 | (37.7811105766569, -122.465524870362) | ||
| 138537 | 138537 | 10053 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 425 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X2 | 6005568.8374122 | 2106507.5213951 | 37.7643832516565 | -122.42393189992501 | (37.7643832516565, -122.423931899925) | ||
| 16928 | 16928 | 10096 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 737 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2011 12:00:00 AM | 3 | 3x3 | 6005665.871 | 2104659.8313700003 | 37.7593154078879 | -122.42346492097602 | (37.7593154078879, -122.423464920976) | ||
| 92901 | 92901 | 10154 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 986 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3x3 | 6005675.0599084 | 2103229.8800101 | 37.755389613891 | -122.423331489083 | (37.755389613891, -122.423331489083) | ||
| 85469 | 85469 | 10201 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1233 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/30/2006 12:00:00 AM | 3 | 3X3 | 6005829.840660599 | 2101789.0505836997 | 37.7514421637243 | -122.422693823491 | (37.7514421637243, -122.422693823491) | ||
| 21694 | 21694 | 10206 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1274 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2010 12:00:00 AM | 3 | 2X2 | 6005768.7769 | 2101585.68354 | 37.7508803192719 | -122.422890537479 | (37.7508803192719, -122.422890537479) | ||
| 9186 | 9186 | 10962 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1431 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1998 12:00:00 AM | 3 | 3X4 | 6016563.2925523 | 2096760.0557493 | 37.7382333059102 | -122.385225528118 | (37.7382333059102, -122.385225528118) | ||
| 117525 | 117525 | 12095 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1261X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/1996 12:00:00 AM | 6 | 3X3 | 6017141.6501925 | 2094501.7221284 | 37.732064349457005 | -122.383068698568 | (37.732064349457, -122.383068698568) | ||
| 16106 | 16106 | 12141 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6016374.05041 | 2095443.42618 | 37.7346076354195 | -122.38578809634899 | (37.7346076354195, -122.385788096349) | |||
| 16692 | 16692 | 12234 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1570 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 3X3 | 6015728.02305 | 2096056.7839799998 | 37.7362560216982 | -122.38806443872 | (37.7362560216982, -122.38806443872) | ||
| 14268 | 14268 | 12235 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1574 La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1997 12:00:00 AM | 6 | 3X3 | 6015715.635319999 | 2096065.54177 | 37.736279382483204 | -122.38810787958201 | (37.7362793824832, -122.388107879582) | ||
| 78031 | 78031 | 12721 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1535 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 3X3 | 5990655.40582 | 2114718.61196 | 37.7860754253896 | -122.476112538286 | (37.7860754253896, -122.476112538286) | ||
| 128791 | 128791 | 12775 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1842 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/1997 12:00:00 AM | 20 | 6 | 5989652.1071 | 2114741.09637 | 37.786078932501 | -122.47958528952 | (37.786078932501, -122.47958528952) | ||
| 108155 | 108155 | 12781 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1914 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/04/1997 12:00:00 AM | 40 | 3X3 | 5989486.1909300005 | 2114733.67338 | 37.786048911885096 | -122.48015876501101 | (37.7860489118851, -122.480158765011) | ||
| 22225 | 22225 | 15638 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3620 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/30/2015 12:00:00 AM | 3 | 3X3 | Permit Number 774763 | 6005333.2664 | 2097101.2564 | 37.7385425216055 | -122.42407769940901 | (37.7385425216055, -122.424077699409) | |
| 78080 | 78080 | 15703 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4260 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2009 12:00:00 AM | 3 | 3X3 | 6003241.43292 | 2093747.9611099998 | 37.7292168076411 | -122.431070980005 | (37.7292168076411, -122.431070980005) | ||
| 13082 | 13082 | 15846 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5256 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/11/2015 12:00:00 AM | 6 | 3x3 | Permit Number 775938 | 5999899.043409999 | 2088666.4410599999 | 37.7150741519211 | -122.442261231071 | (37.7150741519211, -122.442261231071) | |
| 125649 | 125649 | 15854 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5319 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999668.720480001 | 2088318.36983 | 37.714105297270606 | -122.443032341019 | (37.7141052972706, -122.443032341019) | ||
| 142815 | 142815 | 15859 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5367 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5999657.0 | 2088324.0 | 37.7141200881786 | -122.44307325545601 | (37.7141200881786, -122.443073255456) | ||
| 79600 | 79600 | 15934 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5775 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/1995 12:00:00 AM | 6 | 3X3 | 5997641.29025 | 2086713.63365 | 37.7095832536665 | -122.449924299561 | (37.7095832536665, -122.449924299561) | ||
| 9415 | 9415 | 15943 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5810X MISSION ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 5997175.0 | 2086632.0 | 37.7093324147693 | -122.451529986796 | (37.7093324147693, -122.451529986796) | |||
| 84568 | 84568 | 15970 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5919X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996671.773019999 | 2086351.2464599998 | 37.708532699460896 | -122.45324895592199 | (37.7085326994609, -122.453248955922) | ||
| 108782 | 108782 | 15977 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5937 Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1995 12:00:00 AM | 6 | 3X3 | 5996505.5077599995 | 2086284.06053 | 37.7083386912237 | -122.453818737586 | (37.7083386912237, -122.453818737586) | ||
| 86022 | 86022 | 17243 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 10X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 6 | 3X34 | 5993969.30173 | 2088537.74626 | 37.7143810447114 | -122.462747471174 | (37.7143810447114, -122.462747471174) | ||
| 88818 | 88818 | 18610 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 615 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778725 | 5992407.5548851 | 2088503.1314627 | 37.7141959284164 | -122.468142922603 | (37.7141959284164, -122.468142922603) | |
| 13984 | 13984 | 21894 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2068 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2003 12:00:00 AM | 3 | 2X3 | 6015677.89854 | 2105976.47682 | 37.7634906462863 | -122.388930084758 | (37.7634906462863, -122.388930084758) | ||
| 14801 | 14801 | 22531 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 6619 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/2015 08:00:00 AM | 3 | 3X3 | 6012836.07271 | 2089639.80613 | 37.7184756630977 | -122.397613243265 | (37.7184756630977, -122.397613243265) | ||
| 111482 | 111482 | 22572 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 790X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 3 | 4X4 | 6006221.944519999 | 2112852.52787 | 37.7818419658886 | -122.422123780993 | (37.7818419658886, -122.422123780993) | ||
| 127549 | 127549 | 22596 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 810X Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 3 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
| 90153 | 90153 | 22597 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 810X Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 3 | 4x4 | 6006111.721580001 | 2112834.13473 | 37.7817852453704 | -122.42250379427601 | (37.7817852453704, -122.422503794276) | ||
| 89102 | 89102 | 22603 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 888 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/1997 12:00:00 AM | 6 | 4X4 | 6005725.0 | 2112755.0 | 37.781546136890796 | -122.423836042859 | (37.7815461368908, -122.423836042859) | ||
| 100477 | 100477 | 22696 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003467.66311 | 2112468.72246 | 37.780632399020796 | -122.431624898149 | (37.7806323990208, -122.431624898149) | ||
| 144092 | 144092 | 22698 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1390 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/1997 12:00:00 AM | 6 | 3X3 | 6003367.49805 | 2112454.4444 | 37.7805875170515 | -122.43197039694701 | (37.7805875170515, -122.431970396947) | ||
| 89793 | 89793 | 22701 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003258.39673 | 2112440.37761 | 37.7805427074609 | -122.432346825159 | (37.7805427074609, -122.432346825159) | ||
| 88088 | 88088 | 22706 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003033.98605 | 2112410.1866099997 | 37.7804470833639 | -122.433121009687 | (37.7804470833639, -122.433121009687) | ||
| 140627 | 140627 | 22707 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003000.316869999 | 2112401.14844 | 37.7804203568686 | -122.433236841096 | (37.7804203568686, -122.433236841096) | ||
| 99395 | 99395 | 22708 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6002966.72006 | 2112394.81869 | 37.780401071007795 | -122.43335261565399 | (37.7804010710078, -122.433352615654) | ||
| 124395 | 124395 | 22709 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1420 Turk St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/08/2001 12:00:00 AM | 6 | 3X3 | 6002934.09844 | 2112391.17322 | 37.780389210721005 | -122.433465208396 | (37.780389210721, -122.433465208396) | ||
| 97651 | 97651 | 22731 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1560 Turk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/21/1997 12:00:00 AM | 6 | 3X3 | 6002579.60353 | 2112492.8275 | 37.780648209102395 | -122.43469884150801 | (37.7806482091024, -122.434698841508) | ||
| 142207 | 142207 | 22732 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1560 Turk St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/07/2005 12:00:00 AM | 3 | 3X3 | 6002579.60353 | 2112492.8275 | 37.780648209102395 | -122.43469884150801 | (37.7806482091024, -122.434698841508) | ||
| 123865 | 123865 | 22743 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1575 Turk St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/19/2001 12:00:00 AM | 6 | 3x3 | 6002621.38954 | 2112212.2211 | 37.7798801065849 | -122.43453421421499 | (37.7798801065849, -122.434534214215) | ||
| 119660 | 119660 | 22779 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1800 TURK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/14/2007 12:00:00 AM | 3 | 3X3 | 6001307.0 | 2112192.0 | 37.7797498835349 | -122.439079810753 | (37.7797498835349, -122.439079810753) | ||
| 49590 | 49590 | 23252 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 780X Turk St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/11/1997 12:00:00 AM | 3 | 4X4 | 6006324.392990001 | 2112868.49551 | 37.7818915869358 | -122.42177049090598 | (37.7818915869358, -122.421770490906) | ||
| 108610 | 108610 | 25213 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2435 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3x3 | 5991877.560959999 | 2094367.52877 | 37.7302674980365 | -122.47040159900601 | (37.7302674980365, -122.470401599006) | ||
| 81259 | 81259 | 25214 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2425 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 5991946.77441 | 2094328.2654 | 37.7301636922535 | -122.47015946302601 | (37.7301636922535, -122.470159463026) | ||
| 83094 | 83094 | 25216 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2407 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992037.104280001 | 2094247.85119 | 37.7299481166344 | -122.46984133141399 | (37.7299481166344, -122.469841331414) | ||
| 123793 | 123793 | 25217 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2395 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5992118.57098 | 2094231.7213 | 37.7299085366508 | -122.469558520109 | (37.7299085366508, -122.469558520109) | ||
| 89750 | 89750 | 25218 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2375 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992176.95374 | 2094185.34049 | 37.7297845605248 | -122.469353311194 | (37.7297845605248, -122.469353311194) | ||
| 126639 | 126639 | 25219 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2355 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992261.18749 | 2094144.32187 | 37.7296768009835 | -122.469059124236 | (37.7296768009835, -122.469059124236) | ||
| 114109 | 114109 | 25220 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2335 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992314.3392900005 | 2094095.02735 | 37.729544521444396 | -122.468871788642 | (37.7295445214444, -122.468871788642) | ||
| 94099 | 94099 | 25285 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 3X3 | 5992640.87111 | 2093746.9102599998 | 37.728607537869294 | -122.46771763720699 | (37.7286075378693, -122.467717637207) | ||
| 123841 | 123841 | 25286 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2232X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 6 | 2X3 | 5992636.99947 | 2093738.93892 | 37.7285854269889 | -122.467730442067 | (37.7285854269889, -122.467730442067) | ||
| 11064 | 11064 | 25312 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 163 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/26/1996 12:00:00 AM | 3 | 3X3 | 6000515.96101 | 2091667.5202400002 | 37.7233495775944 | -122.440344004183 | (37.7233495775944, -122.440344004183) | ||
| 92289 | 92289 | 25458 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993547.93552 | 2088545.97374 | 37.7143793578368 | -122.464204465034 | (37.7143793578368, -122.464204465034) | ||
| 77490 | 77490 | 25459 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 120 Randolph St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/15/2003 12:00:00 AM | 3 | 3X3 | 5993585.96467 | 2088543.99773 | 37.714376124024504 | -122.464072878916 | (37.7143761240245, -122.464072878916) | ||
| 20624 | 20624 | 25466 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 446 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/13/2015 12:00:00 AM | 6 | 3X3 | 5992823.9205 | 2088555.2969999998 | 37.714363200126904 | -122.466707603629 | (37.7143632001269, -122.466707603629) | ||
| 79330 | 79330 | 26039 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 6 | 3X3 | 5996279.3875 | 2088089.20515 | 37.713282233928 | -122.454730559713 | (37.713282233928, -122.454730559713) | ||
| 113312 | 113312 | 26041 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 9 | 3X3 | 5996239.04821 | 2088090.4012099998 | 37.7132832040965 | -122.454870071763 | (37.7132832040965, -122.454870071763) | ||
| 83999 | 83999 | 26042 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 10 | 3X3 | 5996190.731819999 | 2088089.91613 | 37.7132791004475 | -122.455037033861 | (37.7132791004475, -122.455037033861) | ||
| 107773 | 107773 | 26043 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 3X3 | 5996178.64561 | 2088089.5286700001 | 37.7132773431944 | -122.455078779743 | (37.7132773431944, -122.455078779743) | ||
| 98617 | 98617 | 26044 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 32 Broad St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/1997 12:00:00 AM | 7 | 3X3 | 5996138.5208 | 2088089.89027 | 37.7132760340232 | -122.45521749021002 | (37.7132760340232, -122.45521749021) | ||
| 113119 | 113119 | 26066 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 252 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/1997 12:00:00 AM | 12 | 3X3 | 5994485.32272 | 2088110.77616 | 37.7132383925183 | -122.46093298415701 | (37.7132383925183, -122.460932984157) | ||
| 76812 | 76812 | 26075 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 279 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/19/2003 12:00:00 AM | 12 | 3X3 | 5994244.197480001 | 2088053.67853 | 37.7130677382333 | -122.46176225203001 | (37.7130677382333, -122.46176225203) | ||
| 19942 | 19942 | 26077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 261 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 02:44:00 PM | 3 | 3X3 | 5994378.441000001 | 2088053.8388 | 37.7130759052536 | -122.461298276453 | (37.7130759052536, -122.461298276453) | ||
| 79471 | 79471 | 26094 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 21 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5996391.73364 | 2088029.79177 | 37.71312554209 | -122.454337965939 | (37.71312554209, -122.454337965939) | ||
| 113738 | 113738 | 26400 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 272 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/31/1997 12:00:00 AM | 12 | 3X3 | 5994293.52025 | 2088114.03225 | 37.7132362944599 | -122.46159615030899 | (37.7132362944599, -122.461596150309) | ||
| 12406 | 12406 | 27090 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 725 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X3 | 6006149.91754 | 2093595.5123 | 37.7289625981285 | -122.42100526258801 | (37.7289625981285, -122.421005262588) | |||
| 65536 | 65536 | 27147 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1745 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6011162.37541 | 2095219.4125700002 | 37.7337027663166 | -122.40379095103201 | (37.7337027663166, -122.403790951032) | |||
| 21591 | 21591 | 27507 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1398 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6005804.30319 | 2100875.6461400003 | 37.7489327240794 | -122.42271723090799 | (37.7489327240794, -122.422717230908) | |||
| 9396 | 9396 | 27585 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2295X Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/09/2000 12:00:00 AM | 6 | 3X3 | 6009694.1199724 | 2103987.6509207003 | 37.7576962911825 | -122.40948577896401 | (37.7576962911825, -122.409485778964) | ||
| 10929 | 10929 | 28307 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/2003 12:00:00 AM | 3 | 6000526.74804 | 2093584.98162 | 37.7286151010044 | -122.440444169789 | (37.7286151010044, -122.440444169789) | |||
| 21230 | 21230 | 28488 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1056 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2004 12:00:00 AM | 12 | 3X3 | 6005699.27295 | 2102829.0400099996 | 37.754290366819 | -122.423219261259 | (37.754290366819, -122.423219261259) | ||
| 14663 | 14663 | 28516 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 117 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6010207.243969999 | 2112381.64795 | 37.7807730152091 | -122.40830321374901 | (37.7807730152091, -122.408303213749) | |||
| 128535 | 128535 | 28571 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 145812 | 145812 | 28572 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 82363 | 82363 | 28573 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1220X Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995089.2906 | 2091962.0897099997 | 37.72384792002239 | -122.459124181231 | (37.7238479200224, -122.459124181231) | ||
| 78972 | 78972 | 28575 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 120407 | 120407 | 28576 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 86549 | 86549 | 28577 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 114325 | 114325 | 28578 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3X3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 82629 | 82629 | 28579 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1250 Capitol Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/2003 12:00:00 AM | 3 | 3x3 | 5995113.87864 | 2092090.3781400002 | 37.7242015827796 | -122.45904846962799 | (37.7242015827796, -122.459048469628) | ||
| 9493 | 9493 | 29077 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2275 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 5 | 3x3 | 6009685.8295 | 2104144.07057 | 37.7581253197533 | -122.40952549043001 | (37.7581253197533, -122.40952549043) | ||
| 21524 | 21524 | 29079 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2261 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/08/2006 12:00:00 AM | 3 | 3x3 | 6009682.37784 | 2104210.24464 | 37.7583068254181 | -122.40954209818199 | (37.7583068254181, -122.409542098182) | ||
| 97282 | 97282 | 29732 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 600X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 3 | 3x3 | 6010124.763619999 | 2119212.75369 | 37.7995249687162 | -122.40907070216998 | (37.7995249687162, -122.40907070217) | ||
| 80373 | 80373 | 29737 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 644 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6009876.05646 | 2119220.3393 | 37.7995318614036 | -122.409931857518 | (37.7995318614036, -122.409931857518) | ||
| 77386 | 77386 | 29759 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 699X Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 3x3 | 6009685.79902 | 2119118.10904 | 37.7992404975665 | -122.41058299614099 | (37.7992404975665, -122.410582996141) | |||
| 78942 | 78942 | 29941 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2007 12:00:00 AM | 3 | 3x3 | 5995006.35114609 | 2088101.46141456 | 37.7132427835292 | -122.459131469448 | (37.7132427835292, -122.459131469448) |
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");