Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53774 | 53774 | 129486 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 6012297.60436 | 2120565.6201 | 37.803361093695 | -122.40164698862199 | (37.803361093695, -122.401646988622) | ||||
| 166033 | 166033 | 129485 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012301.33061 | 2120559.21941 | 37.803343726885 | -122.40163364357099 | (37.803343726885, -122.401633643571) | ||||
| 43545 | 43545 | 129484 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012303.2887699995 | 2120555.11364 | 37.8033325627054 | -122.401626578498 | (37.8033325627054, -122.401626578498) | ||||
| 186348 | 186348 | 129483 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Greenwich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012307.75016 | 2120551.4086599997 | 37.8033226386787 | -122.401610879045 | (37.8033226386787, -122.401610879045) | ||||
| 176379 | 176379 | 129482 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6012315.37501 | 2120537.75286 | 37.803285568636 | -122.401583532467 | (37.803285568636, -122.401583532467) | ||||
| 175563 | 175563 | 129481 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 6012317.54236 | 2120532.7765200003 | 37.8032720257522 | -122.401575682271 | (37.8032720257522, -122.401575682271) | ||||
| 171814 | 171814 | 129480 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Greenwich St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | 6012320.77236 | 2120522.45554 | 37.8032438670795 | -122.401563778859 | (37.8032438670795, -122.401563778859) | ||||
| 64529 | 64529 | 129477 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | 6012514.7758 | 2120236.23138 | 37.8024687881724 | -122.40087229823901 | (37.8024687881724, -122.400872298239) | ||||
| 39739 | 39739 | 129479 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 6012506.1322099995 | 2120230.97584 | 37.8024538756 | -122.400901840066 | (37.8024538756, -122.400901840066) | ||||
| 152532 | 152532 | 129478 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 12 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012509.68294 | 2120230.66756 | 37.80245322719529 | -122.400889531035 | (37.8024532271953, -122.400889531035) | ||||
| 147602 | 147602 | 129471 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6012526.59847 | 2120207.76193 | 37.8023912773999 | -122.40082938436701 | (37.8023912773999, -122.400829384367) | ||||
| 132469 | 132469 | 129472 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6012528.94679 | 2120206.6635 | 37.8023883923599 | -122.400821180758 | (37.8023883923599, -122.400821180758) | ||||
| 174070 | 174070 | 129473 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | 6012532.2991 | 2120205.0438900003 | 37.8023841322847 | -122.400809466192 | (37.8023841322847, -122.400809466192) | ||||
| 137937 | 137937 | 129474 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 11 Filbert St | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 25 | 6012536.27851 | 2120200.91706 | 37.8023730229664 | -122.400795405292 | (37.8023730229664, -122.400795405292) | ||||
| 74619 | 74619 | 129475 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 19 | 6012586.0999300005 | 2120128.51859 | 37.8021770130129 | -122.40061790879999 | (37.8021770130129, -122.4006179088) | ||||
| 43299 | 43299 | 129476 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1077 Front St | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6012591.305319999 | 2120127.94056 | 37.8021757161919 | -122.4005998549 | (37.8021757161919, -122.4005998549) | ||||
| 24900 | 24900 | 249938 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 339 Filbert St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6011244.68883 | 2120032.5219400004 | 37.8018385261831 | -122.405253098256 | (37.8018385261831, -122.405253098256) | |||
| 137835 | 137835 | 129468 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1151 Lombard St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6006718.96895 | 2120094.36111 | 37.8017542606157 | -122.420918621021 | (37.8017542606157, -122.420918621021) | ||||
| 40391 | 40391 | 129467 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1331 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6006504.317480001 | 2119710.78815 | 37.8006889650949 | -122.42163415671301 | (37.8006889650949, -122.421634156713) | |||
| 188419 | 188419 | 129470 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 45 MacOndray Ln | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6008463.14234 | 2119145.61201 | 37.799247391416394 | -122.414815771241 | (37.7992473914164, -122.414815771241) | ||||
| 152713 | 152713 | 129469 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1085 Vallejo St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6008359.28826 | 2118585.88506 | 37.7977046844857 | -122.415135501808 | (37.7977046844857, -122.415135501808) | |||
| 93390 | 93390 | 33301 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1120 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/14/1996 12:00:00 AM | Permit Number 37453 | 6009052.27411403 | 2116787.86536385 | 37.7928066833324 | -122.412610401728 | (37.7928066833324, -122.412610401728) | ||
| 165701 | 165701 | 42597 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1950 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/2000 12:00:00 AM | 7 | Permit Number 42667 | 6005420.67346 | 2116544.61332 | 37.7919342879744 | -122.42515859980499 | (37.7919342879744, -122.425158599805) | ||
| 57626 | 57626 | 129464 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6005282.18317 | 2116523.47353 | 37.7918684189526 | -122.425636272008 | (37.7918684189526, -122.425636272008) | |||
| 54198 | 54198 | 129465 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005261.30695 | 2116522.05783 | 37.791863352156 | -122.425708403014 | (37.791863352156, -122.425708403014) | |||
| 136036 | 136036 | 129466 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1974 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6005243.67184 | 2116520.57545 | 37.791858285382105 | -122.425769315008 | (37.7918582853821, -122.425769315008) | |||
| 68399 | 68399 | 129463 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2451 Steiner St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 6002236.13059 | 2116512.00902 | 37.791664351087206 | -122.436174782264 | (37.7916643510872, -122.436174782264) | |||
| 8136 | 8136 | 2477 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2307X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x4 | 6003648.68016 | 2115921.80581 | 37.790123955413705 | -122.43124522668998 | (37.7901239554137, -122.43124522669) | |||
| 8966 | 8966 | 18882 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2323 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6003557.0695 | 2115907.1327400003 | 37.7900784748972 | -122.43156114415001 | (37.7900784748972, -122.43156114415) | |||
| 105136 | 105136 | 18878 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2305 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3X3 | 6003659.521319999 | 2115878.15996 | 37.7900047293604 | -122.43120460047501 | (37.7900047293604, -122.431204600475) | |||
| 69927 | 69927 | 123588 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 5994278.2202699995 | 2115268.8908700002 | 37.787795749172794 | -122.46361861929701 | (37.7877957491728, -122.463618619297) | |||
| 130969 | 130969 | 250332 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 141 27th Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5987387.77846 | 2115003.34197 | 37.786667192588894 | -122.487438428541 | (37.7866671925889, -122.487438428541) | |||
| 178473 | 178473 | 122182 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2 14th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5991497.785680001 | 2114857.01928 | 37.7865042639669 | -122.473208256238 | (37.7865042639669, -122.473208256238) | ||||
| 93449 | 93449 | 56335 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 354 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/07/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777757 | 5987487.44856113 | 2113581.55129815 | 37.782769173736206 | -122.486989143207 | (37.7827691737362, -122.486989143207) | |
| 33000 | 33000 | 138260 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 28 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5999060.2181 | 2113180.9681 | 37.7823372358083 | -122.446923566676 | (37.7823372358083, -122.446923566676) | |||
| 164558 | 164558 | 138264 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2600 GEARY BLVD | 32 | unknown : Yard 19 | Tree 1 | Private 1 | 1 | Width 0ft | 5999039.2359 | 2113177.9223 | 37.7823276740968 | -122.44699593627199 | (37.7823276740968, -122.446995936272) | |||
| 66262 | 66262 | 138270 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 218 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998383.8821 | 2112677.2272 | 37.7809154323836 | -122.44922707658199 | (37.7809154323836, -122.449227076582) | |||
| 105491 | 105491 | 31546 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 220 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/10/1995 12:00:00 AM | 6 | Permit Number 35095 | 5998394.38199367 | 2112672.66987383 | 37.7809035197163 | -122.44919042402901 | (37.7809035197163, -122.449190424029) | |
| 142319 | 142319 | 24738 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7700 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/09/1996 12:00:00 AM | 3 | 3X3 | 5983089.132019999 | 2112566.68135 | 37.7797252106941 | -122.502130088809 | (37.7797252106941, -122.502130088809) | ||
| 112441 | 112441 | 24808 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7117 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/22/1996 12:00:00 AM | 3 | 3X3 | 5984967.23631 | 2112432.54215 | 37.7794670623637 | -122.49562310699899 | (37.7794670623637, -122.495623106999) | ||
| 94727 | 94727 | 68575 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 7633 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/18/1993 12:00:00 AM | Permit Number 32467 | 5983299.26193695 | 2112364.72668983 | 37.779183045029896 | -122.501388226383 | (37.7791830450299, -122.501388226383) | ||
| 67487 | 67487 | 47082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 175 Beaumont Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/03/2002 12:00:00 AM | 5 | Permit Number 45068 | 5996827.60082146 | 2111762.20695793 | 37.778313889032205 | -122.45454486671998 | (37.7783138890322, -122.45454486672) | |
| 150971 | 150971 | 52086 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 550 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/19/2005 12:00:00 AM | 7 | Permit Number 48283 | 5982264.87127 | 2112012.82882 | 37.7781560348973 | -122.50494046388201 | (37.7781560348973, -122.504940463882) | |
| 88257 | 88257 | 47451 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | ||
| 108311 | 108311 | 47453 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | Permit Number 45359 | 5983034.2663237 | 2111680.83899779 | 37.7772897229163 | -122.502254315782 | (37.7772897229163, -122.502254315782) | ||
| 178121 | 178121 | 47450 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5049 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 7 | Permit Number 45359 | 5982925.588409999 | 2111676.1494 | 37.7772704608477 | -122.502629914355 | (37.7772704608477, -122.502629914355) | |
| 31114 | 31114 | 118441 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 5201 Anza St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5982477.73735 | 2111660.7356 | 37.7772018111581 | -122.504178007129 | (37.7772018111581, -122.504178007129) | |||
| 143583 | 143583 | 34718 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 626 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38373 | 5981358.16274912 | 2111480.6327423 | 37.7766413961782 | -122.508037533581 | (37.7766413961782, -122.508037533581) | ||
| 119851 | 119851 | 34725 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 114 Sutro Heights Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | Permit Number 38379 | 5981286.97907127 | 2111325.91865707 | 37.776212402307 | -122.508272287748 | (37.776212402307, -122.508272287748) | ||
| 69872 | 69872 | 50219 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2726 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2004 12:00:00 AM | 8 | 3x3 | Permit Number 46926 | 5987073.255969999 | 2111201.4718400002 | 37.776209992885 | -122.48824709613301 | (37.776209992885, -122.488247096133) |
| 60744 | 60744 | 59481 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 701 04th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05513 | 2110730.54303 | 37.7753593652253 | -122.461805741777 | (37.7753593652253, -122.461805741777) | ||
| 127621 | 127621 | 54526 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 4530 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2016 12:00:00 AM | 3 | Permit Number 777496 | 5981479.33824 | 2110998.9232400004 | 37.7753259029383 | -122.507582607669 | (37.7753259029383, -122.507582607669) | ||
| 59870 | 59870 | 98307 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 701 04th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2012 12:00:00 AM | 3 | Permit Number 768498 | 5994707.05848 | 2110712.1855099997 | 37.7753089605415 | -122.46180439880399 | (37.7753089605415, -122.461804398804) | ||
| 56497 | 56497 | 118789 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 718 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 5981995.4955 | 2110847.43445 | 37.7749403522663 | -122.505785898051 | (37.7749403522663, -122.505785898051) | |||
| 142094 | 142094 | 109138 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773583 | 5985365.401319999 | 2110729.9835 | 37.7748156320332 | -122.49412018624099 | (37.7748156320332, -122.494120186241) |
| 151013 | 151013 | 118250 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 759 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5985366.8002 | 2110712.8219999997 | 37.7747685933044 | -122.494114082166 | (37.7747685933044, -122.494114082166) | |||
| 145200 | 145200 | 109133 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 774 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773526 | 5985442.4 | 2110611.6 | 37.7744950899459 | -122.493845109753 | (37.7744950899459, -122.493845109753) |
| 123353 | 123353 | 44124 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 751 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2000 12:00:00 AM | Permit Number 43628 | 5981028.36208653 | 2110606.15983469 | 37.774220913121 | -122.509113438342 | (37.774220913121, -122.509113438342) | |||
| 25429 | 25429 | 119085 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 886 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5982037.396000001 | 2109722.65545 | 37.7718545033558 | -122.50555756428601 | (37.7718545033558, -122.505557564286) | |||
| 72687 | 72687 | 119095 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 6700 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5982534.89521 | 2109675.70682 | 37.7717548615052 | -122.503833231018 | (37.7717548615052, -122.503833231018) | |||
| 121074 | 121074 | 117519 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998904.0 | 2109014.0 | 37.7708868872166 | -122.447164026359 | (37.7708868872166, -122.447164026359) | ||||
| 136946 | 136946 | 244098 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1601 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5998815.2972 | 2108995.6351 | 37.770831393246496 | -122.44746952816901 | (37.7708313932465, -122.447469528169) | |||
| 26252 | 26252 | 227697 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 109 Fillmore St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003800.52049 | 2108768.8119 | 37.7704922173631 | -122.430209350707 | (37.7704922173631, -122.430209350707) | |||
| 22307 | 22307 | 246123 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 35 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/06/2017 12:00:00 AM | 3 | Width 0ft | Permit Number 779621 | 5998184.8878 | 2108385.4066 | 37.7691198159889 | -122.44960613908701 | (37.7691198159889, -122.449606139087) | |
| 32724 | 32724 | 227696 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 50 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6003774.74871 | 2108065.2472200003 | 37.7685589402651 | -122.43024829315 | (37.7685589402651, -122.43024829315) | |||
| 136797 | 136797 | 191395 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | 6010771.29847 | 2107917.19939 | 37.7685462418407 | -122.406037260315 | (37.7685462418407, -122.406037260315) | ||||
| 171831 | 171831 | 191396 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6010761.0499599995 | 2107917.30957 | 37.7685459711594 | -122.40607271698799 | (37.7685459711594, -122.406072716988) | ||||
| 159748 | 159748 | 191397 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 6010751.13717 | 2107916.6697400003 | 37.768543659889005 | -122.406106959582 | (37.768543659889, -122.406106959582) | ||||
| 49267 | 49267 | 191398 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 14 | 6010740.07849 | 2107915.77093 | 37.768540573414896 | -122.406145147482 | (37.7685405734149, -122.406145147482) | ||||
| 177899 | 177899 | 191399 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010727.66479 | 2107914.7241700003 | 37.7685370048986 | -122.406188011877 | (37.7685370048986, -122.406188011877) | ||||
| 154704 | 154704 | 191400 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6010721.657430001 | 2107914.21049 | 37.76853525842721 | -122.406208754734 | (37.7685352584272, -122.406208754734) | ||||
| 132758 | 132758 | 191401 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6010711.19096 | 2107913.74245 | 37.768533387842396 | -122.406244924566 | (37.7685333878424, -122.406244924566) | ||||
| 150156 | 150156 | 191402 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6010700.42675 | 2107913.45144 | 37.7685319866755 | -122.406282136733 | (37.7685319866755, -122.406282136733) | ||||
| 162968 | 162968 | 191403 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2100 Alameda St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6010692.2016199995 | 2107913.0668 | 37.7685304704432 | -122.40631055979601 | (37.7685304704432, -122.406310559796) | ||||
| 77293 | 77293 | 227685 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5997626.030809999 | 2107071.20572 | 37.765479368391 | -122.45144438204599 | (37.765479368391, -122.451444382046) | |||
| 32798 | 32798 | 227686 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1001 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997629.48637 | 2107046.8431599997 | 37.7654126728718 | -122.45143067278299 | (37.7654126728718, -122.451430672783) | |||
| 44170 | 44170 | 227687 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1003 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997630.84664 | 2107024.34604 | 37.7653509793933 | -122.45142434518401 | (37.7653509793933, -122.451424345184) | |||
| 36675 | 36675 | 186762 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 28 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984853.5932 | 2106716.1156 | 37.7637647274179 | -122.49559449238701 | (37.7637647274179, -122.495594492387) | |||
| 44625 | 44625 | 186760 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 26 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984860.8701 | 2106711.7495 | 37.7637531654529 | -122.495569002148 | (37.7637531654529, -122.495569002148) | |||
| 24102 | 24102 | 186759 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 25 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984850.1974 | 2106711.7495 | 37.7637525404811 | -122.495605915184 | (37.7637525404811, -122.495605915184) | |||
| 50007 | 50007 | 186756 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | |||
| 184000 | 184000 | 186754 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 20 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 0ft | 5984863.7808 | 2106693.8 | 37.763704051609004 | -122.49555761110202 | (37.763704051609, -122.495557611102) | |||
| 66007 | 66007 | 186752 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106688.9488 | 37.7636899929755 | -122.49560087776399 | (37.7636899929755, -122.495600877764) | |||
| 156319 | 156319 | 186749 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984860.385 | 2106678.2761 | 37.7636612284897 | -122.495568210877 | (37.7636612284897, -122.495568210877) | |||
| 70133 | 70133 | 186750 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 16 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984851.1676 | 2106678.2761 | 37.763660688738206 | -122.49560009051399 | (37.7636606887382, -122.495600090514) | |||
| 45882 | 45882 | 186748 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 0ft | 5984868.1469 | 2106676.3356 | 37.7636563549354 | -122.495541222153 | (37.7636563549354, -122.495541222153) | |||
| 73459 | 73459 | 186747 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 0ft | 5984869.1172 | 2106666.6331 | 37.76362977141179 | -122.495537150576 | (37.7636297714118, -122.495537150576) | |||
| 151432 | 151432 | 186745 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984852.3804 | 2106661.5394 | 37.763614805479 | -122.495594661337 | (37.763614805479, -122.495594661337) | |||
| 120269 | 120269 | 85386 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1239 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 49657 | 5981144.8 | 2106623.2 | 37.7632917298848 | -122.508414943002 | (37.7632917298848, -122.508414943002) | ||||
| 41740 | 41740 | 183278 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1255 42nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 0ft | 5983028.2339 | 2106536.9311 | 37.7631656789881 | -122.50189448779601 | (37.7631656789881, -122.501894487796) | |||
| 130724 | 130724 | 227681 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 145 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 5997959.25406 | 2106183.4369900003 | 37.7630608557823 | -122.450227846644 | (37.7630608557823, -122.450227846644) | |||
| 154916 | 154916 | 37082 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1268 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/15/2002 12:00:00 AM | 6 | Permit Number 44549 | 5982146.28824129 | 2106471.58463776 | 37.762934408685396 | -122.504939947841 | (37.7629344086854, -122.504939947841) | |
| 69434 | 69434 | 207099 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5990478.55232 | 2106260.78747 | 37.7628423007597 | -122.476106431162 | (37.7628423007597, -122.476106431162) | |||
| 174088 | 174088 | 207100 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990476.61635 | 2106239.9997799997 | 37.762785111079396 | -122.476111608564 | (37.7627851110794, -122.476111608564) | |||
| 37042 | 37042 | 207101 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990477.30542 | 2106226.48097 | 37.7627480320102 | -122.476108237903 | (37.7627480320102, -122.476108237903) | |||
| 176859 | 176859 | 191367 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 548 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6011194.69766 | 2105791.5268900003 | 37.762733297531206 | -122.404423107658 | (37.7627332975312, -122.404423107658) | |||
| 161309 | 161309 | 207102 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1325 18th Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5990480.890819999 | 2106148.89617 | 37.7625352128593 | -122.476090170539 | (37.7625352128593, -122.476090170539) | |||
| 93638 | 93638 | 31942 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1998 12:00:00 AM | Permit Number 39715 | 5980916.9213303 | 2106151.77480086 | 37.761983899941 | -122.50916807626999 | (37.761983899941, -122.50916807627) | ||
| 31036 | 31036 | 181438 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1319 48th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5981181.6009 | 2106068.5638 | 37.761771027502 | -122.508246492496 | (37.761771027502, -122.508246492496) | |||
| 52773 | 52773 | 183252 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1300 La Playa | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5980914.4873 | 2106074.2169999997 | 37.761770805091096 | -122.50917073482799 | (37.7617708050911, -122.509170734828) |
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");