Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154 | 154 | 830 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1384 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:15:00 PM | 3 | 5.5x6.5 | 5981549.5887 | 2105676.5499 | 37.7607163481902 | -122.506944712409 | (37.7607163481902, -122.506944712409) | ||
| 163 | 163 | 29943 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 242 Broad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/28/2017 12:23:00 PM | 3 | 3x3 | 5994593.32204167 | 2088106.90572275 | 37.7132339790874 | -122.460559423837 | (37.7132339790874, -122.460559423837) | ||
| 628 | 628 | 251337 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2230 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/26/1996 12:00:00 AM | 3x3 | 5992640.0 | 2093746.0 | 37.728604988221896 | -122.46772058248399 | (37.7286049882219, -122.467720582484) | |||
| 2333 | 2333 | 253025 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1754 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/11/2017 12:00:00 AM | 3 | 5993444.58369 | 2103545.63859 | 37.7555587516047 | -122.465650780273 | (37.7555587516047, -122.465650780273) | |||
| 2988 | 2988 | 118173 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3221 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/13/2008 12:00:00 AM | 2 | Width 3ft | 5985542.20124 | 2111089.15517 | 37.7758121588594 | -122.49353507754299 | (37.7758121588594, -122.493535077543) | ||
| 4788 | 4788 | 253430 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 501X Madrid St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/25/2017 04:04:00 PM | 3 | 3x3 | 6002703.0 | 2090930.0 | 37.721448793681 | -122.43273116699801 | (37.721448793681, -122.432731166998) | ||
| 9327 | 9327 | 122854 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3000X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/08/2016 01:40:00 PM | 3 | 3x3 | 5996648.0 | 2087344.0 | 37.7112572095529 | -122.453402744961 | (37.7112572095529, -122.453402744961) | ||
| 11259 | 11259 | 25305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 300 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/07/1996 12:00:00 AM | 12 | 3X3 | 5999583.38871 | 2091602.23425 | 37.7231171747905 | -122.443563033915 | (37.7231171747905, -122.443563033915) | ||
| 12474 | 12474 | 28305 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1818 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/05/2003 12:00:00 AM | 3 | 6000543.0489 | 2093613.5897099997 | 37.7286945803894 | -122.440389867794 | (37.7286945803894, -122.440389867794) | |||
| 12988 | 12988 | 904 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1179 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/22/2016 12:00:00 AM | 3 | 2X2 | 6003419.3756099995 | 2094263.29224 | 37.7306418725253 | -122.430492572378 | (37.7306418725253, -122.430492572378) | ||
| 17358 | 17358 | 4165 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3770 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2016 12:00:00 AM | 3 | 3X3 | Permit Number 774303 | 6005421.09901 | 2100523.30385 | 37.747943645176704 | -122.424017300779 | (37.7479436451767, -122.424017300779) | |
| 17728 | 17728 | 10153 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 978 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2016 06:51:00 AM | 3 | 3x4 | 6005672.85931 | 2103292.97405 | 37.7555627312558 | -122.423343584439 | (37.7555627312558, -122.423343584439) | ||
| 18209 | 18209 | 10188 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1148 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/05/2016 12:00:00 AM | 3 | 2x4 | 6005734.612380001 | 2102244.83146 | 37.75268825965679 | -122.423055527089 | (37.7526882596568, -122.423055527089) | ||
| 18648 | 18648 | 10186 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1130 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/2015 04:47:00 AM | 3 | 4x5 | 6005723.69305 | 2102361.07491 | 37.753006821117296 | -122.423101549889 | (37.7530068211173, -122.423101549889) | ||
| 18695 | 18695 | 16874 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 269 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/21/2015 08:43:00 AM | 3 | 3X3 | 6005705.9301 | 2110300.3269 | 37.7748051262311 | -122.423727430112 | (37.7748051262311, -122.423727430112) | ||
| 18818 | 18818 | 10127 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 892 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3x3 | 6005646.424 | 2103793.6441599997 | 37.7569359627397 | -122.42347059841002 | (37.7569359627397, -122.42347059841) | |||
| 19486 | 19486 | 10095 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 727 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/28/2016 05:21:00 AM | 3 | 2X2 | 6005664.2360000005 | 2104708.85405 | 37.759449920391 | -122.423474060781 | (37.759449920391, -122.423474060781) | ||
| 19508 | 19508 | 90355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 745 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993230.153419999 | 2111367.69142 | 37.777023672198794 | -122.46696097646699 | (37.7770236721988, -122.466960976467) | ||
| 19807 | 19807 | 93394 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3077 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996268.61185 | 2111428.40102 | 37.777365269924296 | -122.456454460594 | (37.7773652699243, -122.456454460594) | ||
| 20345 | 20345 | 5583 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1069 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6005153.43733 | 2102137.63056 | 37.752361098006894 | -122.42505770847299 | (37.7523610980069, -122.425057708473) | |||
| 20752 | 20752 | 27680 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 320 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/22/2014 06:28:00 AM | 3 | 3x3 | 6005461.15776 | 2107102.0666400003 | 37.7660096518439 | -122.42434662439501 | (37.7660096518439, -122.424346624395) | ||
| 21046 | 21046 | 10125 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 876 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/11/2015 02:57:00 PM | 3 | 3x3 | 6005640.441980001 | 2103866.83654 | 37.757136594295396 | -122.423496489872 | (37.7571365942954, -122.423496489872) | ||
| 21052 | 21052 | 16925 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 512 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 25 | 6004419.62206 | 2110173.45228 | 37.7743840640969 | -122.42816799305099 | (37.7743840640969, -122.428167993051) | ||||
| 21836 | 21836 | 10190 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1160 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2015 09:38:00 AM | 3 | 2x2 | 6005734.23383 | 2102203.6860700003 | 37.7525752625596 | -122.42305391193001 | (37.7525752625596, -122.42305391193) | ||
| 21922 | 21922 | 10107 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 799X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/02/2014 06:59:00 AM | 3 | 3x4 | 6005682.50344 | 2104371.2203900004 | 37.7585238884792 | -122.423386880525 | (37.7585238884792, -122.423386880525) | ||
| 22211 | 22211 | 10150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 966 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/2012 12:00:00 AM | 3 | 3x3 | 6005669.65476 | 2103355.68664 | 37.7557347445795 | -122.423359124725 | (37.7557347445795, -122.423359124725) | ||
| 22422 | 22422 | 7875 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1050 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/18/2014 02:38:00 PM | 3 | 4X4 | 6006070.45315 | 2113764.9909599996 | 37.7843388199314 | -122.422712735214 | (37.7843388199314, -122.422712735214) | ||
| 22997 | 22997 | 12121 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1400X La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6016540.00349 | 2094984.34395 | 37.733356269266295 | -122.38518235797899 | (37.7333562692663, -122.385182357979) | |||
| 23024 | 23024 | 2316 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2263 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5 | 6009682.41451 | 2104184.36513 | 37.7582357681755 | -122.409540144857 | (37.7582357681755, -122.409540144857) | ||||
| 23088 | 23088 | 29 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3X3 | 6003854.77769 | 2107764.13441 | 37.7677366901162 | -122.42994999788799 | (37.7677366901162, -122.429949997888) | |||
| 23242 | 23242 | 1673 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 5994963.861330001 | 2111486.70203 | 37.7774503572538 | -122.460972213003 | (37.7774503572538, -122.460972213003) | ||||
| 23334 | 23334 | 8279 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1601 Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3x3 | 6015771.79311 | 2097687.24817 | 37.740735369454605 | -122.388026849781 | (37.7407353694546, -122.388026849781) | |||
| 29751 | 29751 | 219429 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 900x Kirkham St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 4ft | 5992085.46562 | 2105232.9931400004 | 37.7601132972171 | -122.47047387378099 | (37.7601132972171, -122.470473873781) | |||
| 58391 | 58391 | 182082 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1109 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/04/2017 12:00:00 AM | 3 | Width 0ft | 5989746.1732 | 2098995.6798 | 37.7428517447762 | -122.47810825386001 | (37.7428517447762, -122.47810825386) | ||
| 64285 | 64285 | 180415 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1132x Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | Width 3ft | 6003554.97456 | 2094355.58631 | 37.7309029717957 | -122.43003036762899 | (37.7309029717957, -122.430030367629) | |||
| 64598 | 64598 | 123720 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | Width 3ft | 5995264.25203 | 2111440.07761 | 37.7773396195467 | -122.459929691175 | (37.7773396195467, -122.459929691175) | ||
| 78430 | 78430 | 90143 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 342 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5994483.16529 | 2111468.25725 | 37.7773720407512 | -122.462633748637 | (37.7773720407512, -122.462633748637) | ||
| 78479 | 78479 | 122863 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2900X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 5996824.0 | 2087575.0 | 37.7119015691826 | -122.45281111027501 | (37.7119015691826, -122.452811110275) | |||
| 78607 | 78607 | 89592 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4617 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984322.41803 | 2111726.32769 | 37.777490220874 | -122.497801611618 | (37.777490220874, -122.497801611618) | ||
| 78696 | 78696 | 89608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4215 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985569.57732 | 2111771.09823 | 37.7776861810077 | -122.493490635217 | (37.7776861810077, -122.493490635217) | ||
| 78777 | 78777 | 25313 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 131 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/24/1998 12:00:00 AM | 3 | 3X3 | 6000709.1204 | 2091674.68705 | 37.723380252154605 | -122.439676803494 | (37.7233802521546, -122.439676803494) | ||
| 79386 | 79386 | 89701 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2015 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992461.7466589995 | 2112025.799575 | 37.7787862776475 | -122.469667031742 | (37.7787862776475, -122.469667031742) | ||
| 79745 | 79745 | 89696 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2101 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992083.25787 | 2112006.9207200003 | 37.778712558544996 | -122.470974985133 | (37.778712558545, -122.470974985133) | ||
| 79807 | 79807 | 90353 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 833 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5992966.98928 | 2111358.80702 | 37.7769840852214 | -122.467870688698 | (37.7769840852214, -122.467870688698) | ||
| 81338 | 81338 | 29886 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1332 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6005784.3311963 | 2101201.415557 | 37.7498260853424 | -122.422809442933 | (37.7498260853424, -122.422809442933) | |||
| 81699 | 81699 | 90315 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2223 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2013 12:00:00 AM | 3 | 3x3 | 5988645.63956 | 2111200.47975 | 37.776298880204 | -122.48280778540399 | (37.776298880204, -122.482807785404) | ||
| 83003 | 83003 | 22765 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/1997 12:00:00 AM | 6 | 4X4 | 6002010.254376 | 2112254.96617 | 37.7799627627699 | -122.436651458736 | (37.7799627627699, -122.436651458736) | ||
| 83604 | 83604 | 93385 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3156 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995879.45321 | 2111435.47315 | 37.7773623389565 | -122.457801190599 | (37.7773623389565, -122.457801190599) | ||
| 83975 | 83975 | 90374 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 341 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5994576.425455 | 2111424.277156 | 37.77725665365 | -122.462307943077 | (37.77725665365, -122.462307943077) | ||
| 85182 | 85182 | 90139 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 236 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5994897.044563 | 2111475.9309630003 | 37.7774169377561 | -122.46120257165899 | (37.7774169377561, -122.461202571659) | ||
| 85717 | 85717 | 89409 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2020 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992384.83285 | 2112073.6126 | 37.7789131134856 | -122.46993658655899 | (37.7789131134856, -122.469936586559) | ||
| 85908 | 85908 | 89598 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4417 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5984943.344959999 | 2111748.4465099997 | 37.777587333707 | -122.49565528309999 | (37.777587333707, -122.4956552831) | ||
| 86323 | 86323 | 21844 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 217X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2000 12:00:00 AM | 3 | 3X3 | 5994893.74214 | 2111425.45184 | 37.777278145464294 | -122.461210335739 | (37.7772781454643, -122.461210335739) | ||
| 87763 | 87763 | 8934 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4630 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2002 12:00:00 AM | 3 | 2X2 | 5992661.51426 | 2112807.7475 | 37.7809448378746 | -122.46903288589701 | (37.7809448378746, -122.469032885897) | ||
| 87987 | 87987 | 90154 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 638 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775919 | 5993572.64081 | 2111433.85169 | 37.7772250922406 | -122.465781024081 | (37.7772250922406, -122.465781024081) | |
| 88106 | 88106 | 89406 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2016 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992454.35988 | 2112065.560542 | 37.778895023507204 | -122.469695480685 | (37.7788950235072, -122.469695480685) | ||
| 89034 | 89034 | 90380 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 101 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5995315.581431 | 2111451.352271 | 37.7773735286818 | -122.459752944165 | (37.7773735286818, -122.459752944165) | ||
| 89638 | 89638 | 22703 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1410 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/19/2001 12:00:00 AM | 6 | 3X3 | 6003133.70477 | 2112422.88036 | 37.7804875932729 | -122.432776943127 | (37.7804875932729, -122.432776943127) | ||
| 89845 | 89845 | 90210 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2326 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988313.82257 | 2111246.42734 | 37.77640572777071 | -122.483958988115 | (37.7764057277707, -122.483958988115) | ||
| 90058 | 90058 | 90371 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 399X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5994452.72009 | 2111411.69669 | 37.7772149871382 | -122.462734963613 | (37.7772149871382, -122.462734963613) | ||
| 91662 | 91662 | 89403 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1920 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992698.73667 | 2112085.38755 | 37.77896358458921 | -122.468851534899 | (37.7789635845892, -122.468851534899) | ||
| 91755 | 91755 | 93388 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3155 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995895.97504 | 2111374.7132900003 | 37.777196457569104 | -122.457739638948 | (37.7771964575691, -122.457739638948) | ||
| 92071 | 92071 | 89399 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1732 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5993250.39877 | 2112105.36057 | 37.7790502810604 | -122.466944583124 | (37.7790502810604, -122.466944583124) | ||
| 92130 | 92130 | 90148 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 560 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993848.25237 | 2111446.61829 | 37.777276040241794 | -122.464828530497 | (37.7772760402418, -122.464828530497) | ||
| 92169 | 92169 | 86485 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1674 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/2016 10:49:00 AM | 3 | 3x3 | 5987816.321957 | 2103904.0922479997 | 37.7562167246282 | -122.48514111531401 | (37.7562167246282, -122.485141115314) | ||
| 92244 | 92244 | 12608 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5993288.45121 | 2114872.37286 | 37.786649939560796 | -122.46701416661199 | (37.7866499395608, -122.467014166612) | |||
| 92626 | 92626 | 93390 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3101X Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996089.01666 | 2111400.13498 | 37.777277346682894 | -122.45707368998 | (37.7772773466829, -122.45707368998) | ||
| 92825 | 92825 | 25288 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 110X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/06/1996 12:00:00 AM | 10 | 3x3 | 6000890.43944 | 2091777.01619 | 37.7236715433472 | -122.43905734896299 | (37.7236715433472, -122.439057348963) | ||
| 93068 | 93068 | 90137 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 200 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995004.121864 | 2111479.789375 | 37.7774336935409 | -122.460832438394 | (37.7774336935409, -122.460832438394) | ||
| 93907 | 93907 | 90403 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 65 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/06/2015 02:18:00 PM | 3 | 3x3 | 6006281.002548001 | 2109118.418506 | 37.7715923352501 | -122.42165416864701 | (37.7715923352501, -122.421654168647) | ||
| 94375 | 94375 | 90152 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 612 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993667.15597 | 2111439.38045 | 37.7772457242278 | -122.46545447029699 | (37.7772457242278, -122.465454470297) | ||
| 95005 | 95005 | 90923 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5985467.79642 | 2111768.32537 | 37.7776726131943 | -122.493842520581 | (37.7776726131943, -122.493842520581) | ||
| 95107 | 95107 | 89416 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2130 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992026.51525 | 2112059.36737 | 37.778853280818 | -122.471175100136 | (37.778853280818, -122.471175100136) | ||
| 95934 | 95934 | 90156 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 700 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993383.45561 | 2111430.5438099997 | 37.7772050950409 | -122.466435230265 | (37.7772050950409, -122.466435230265) | ||
| 96304 | 96304 | 89600 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4335 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985191.65818 | 2111758.32829 | 37.777629004290205 | -122.494797025483 | (37.7776290042902, -122.494797025483) | ||
| 96573 | 96573 | 90364 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 537 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993970.172866001 | 2111402.29422 | 37.7771613668446 | -122.46440355258301 | (37.7771613668446, -122.464403552583) | ||
| 97045 | 97045 | 5037 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 5355 Diamond Heights Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1997 12:00:00 AM | 3 | 3X3 | 6001868.9723963 | 2098685.9233744 | 37.7426974440588 | -122.436168914431 | (37.7426974440588, -122.436168914431) | ||
| 97331 | 97331 | 90147 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 540 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993869.1864599995 | 2111446.17872 | 37.7772760402416 | -122.464756081382 | (37.7772760402416, -122.464756081382) | ||
| 97385 | 97385 | 93386 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3181 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995776.62857 | 2111357.14376 | 37.7771413594108 | -122.45815122183201 | (37.7771413594108, -122.458151221832) | ||
| 97981 | 97981 | 89577 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4801X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983707.84723 | 2111706.4900599997 | 37.7773997054666 | -122.49992611559901 | (37.7773997054666, -122.499926115599) | ||
| 98157 | 98157 | 90211 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2349X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/10/2008 12:00:00 AM | 3 | 3x3 | 5988326.615747 | 2111197.527168 | 37.77627220634061 | -122.48391114694901 | (37.7762722063406, -122.483911146949) | |
| 99292 | 99292 | 89404 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1926 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992675.04364 | 2112084.25544 | 37.7789591072669 | -122.46893341544799 | (37.7789591072669, -122.468933415448) | ||
| 100104 | 100104 | 93384 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3130 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5995978.76387 | 2111448.33896 | 37.7774033698964 | -122.45745857585399 | (37.7774033698964, -122.457458575854) | ||
| 100265 | 100265 | 89705 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1945X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/08/2008 12:00:00 AM | 3 | 3x3 | 5992682.1024279995 | 2112033.696052 | 37.7788206927431 | -122.46890531620701 | (37.7788206927431, -122.468905316207) | ||
| 100693 | 100693 | 93395 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3037 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996439.20977 | 2111447.84823 | 37.777428459351796 | -122.455865716415 | (37.7774284593518, -122.455865716415) | ||
| 100815 | 100815 | 89607 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4225 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5985540.508119999 | 2111770.83497 | 37.777683757686894 | -122.493591174643 | (37.7776837576869, -122.493591174643) | ||
| 101199 | 101199 | 90135 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 126 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995236.784291999 | 2111488.444802 | 37.77747084326629 | -122.460028215119 | (37.7774708432663, -122.460028215119) | ||
| 101206 | 101206 | 93355 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2800 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/21/2008 12:00:00 AM | 3 | 3x3 | 5997683.2 | 2111662.6 | 37.7780894288895 | -122.451577860296 | (37.7780894288895, -122.451577860296) | ||
| 101719 | 101719 | 89405 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 1932 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992650.02375 | 2112083.7442099997 | 37.778956257991794 | -122.469019931283 | (37.7789562579918, -122.469019931283) | ||
| 101853 | 101853 | 89576 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4825 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5983661.38159 | 2111702.27488 | 37.7773854048537 | -122.500086541243 | (37.7773854048537, -122.500086541243) | ||
| 102213 | 102213 | 90354 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 829 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993063.797275 | 2111369.278291 | 37.777018426175395 | -122.467536564508 | (37.7770184261754, -122.467536564508) | ||
| 102876 | 102876 | 93397 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3001 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/09/2008 12:00:00 AM | 3 | 3x3 | 5996549.73479 | 2111464.41413 | 37.777480287642796 | -122.455484573833 | (37.7774802876428, -122.455484573833) | ||
| 103475 | 103475 | 89698 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2045 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/07/2008 12:00:00 AM | 3 | 3x3 | 5992248.56439 | 2112009.3415 | 37.7787287645821 | -122.470403307178 | (37.7787287645821, -122.470403307178) | ||
| 103694 | 103694 | 93375 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2990 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2008 12:00:00 AM | 3 | 3x3 | 5996712.7 | 2111574.1 | 37.777790806063706 | -122.454928753706 | (37.7777908060637, -122.454928753706) | ||
| 104876 | 104876 | 90141 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 314 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5994652.343543 | 2111467.083765 | 37.7773785603676 | -122.462048424974 | (37.7773785603676, -122.462048424974) | ||
| 105470 | 105470 | 24672 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4411 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/2003 12:00:00 AM | 3 | 3X3 | 5993331.5014 | 2112728.6564700003 | 37.7807663635721 | -122.466709338612 | (37.7807663635721, -122.466709338612) | ||
| 105817 | 105817 | 29733 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 622 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/19/2006 12:00:00 AM | 6 | 3x3 | 6010024.1062535 | 2119210.3696422 | 37.799512783441 | -122.409418845912 | (37.799512783441, -122.409418845912) | ||
| 107621 | 107621 | 93389 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 3119 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2008 12:00:00 AM | 3 | 3x3 | 5996027.98106 | 2111395.2245400003 | 37.7772603585752 | -122.45728447514401 | (37.7772603585752, -122.457284475144) | ||
| 108044 | 108044 | 122872 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2701X Alemany Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 1 | 3x3 | 5997494.0 | 2087981.0 | 37.7130547225267 | -122.45052466448799 | (37.7130547225267, -122.450524664488) | |||
| 108828 | 108828 | 90358 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 641 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993649.072925 | 2111390.418014 | 37.7771102435984 | -122.46551346702499 | (37.7771102435984, -122.465513467025) |
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");