Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▲ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 166031 | 166031 | 129493 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 660 Bay St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6007573.98162 | 2121316.69576 | 37.8051586397294 | -122.418046578505 | (37.8051586397294, -122.418046578505) | |||
| 181320 | 181320 | 129489 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2120 Jefferson St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5999042.28702 | 2121160.24008 | 37.80424517403429 | -122.44756015169901 | (37.8042451740343, -122.447560151699) | ||||
| 35498 | 35498 | 129498 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 6ft | 6007778.02269 | 2120584.45961 | 37.803159586216395 | -122.417288546245 | (37.8031595862164, -122.417288546245) | |||
| 162033 | 162033 | 129497 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 855 Chestnut St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 6ft | 6007750.73846 | 2120580.85704 | 37.803148159410604 | -122.417382708871 | (37.8031481594106, -122.417382708871) | |||
| 37571 | 37571 | 249979 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 0ft | 6011649.02488 | 2120183.7348700003 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | |||
| 33252 | 33252 | 129488 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3320 Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999321.62812 | 2120233.7842099997 | 37.801717336245105 | -122.44652677938801 | (37.8017173362451, -122.446526779388) | |||
| 182658 | 182658 | 129487 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3310 Baker St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999338.381580001 | 2120194.27566 | 37.8016098133151 | -122.446465960942 | (37.8016098133151, -122.446465960942) | |||
| 29934 | 29934 | 129496 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1101 Greenwich St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | ||||
| 176985 | 176985 | 34479 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 756 Union St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | 6 | 2x3 | Permit Number 38206 | 6009344.310190001 | 2119468.83873 | 37.800184363566 | -122.411789466237 | (37.800184363566, -122.411789466237) |
| 179233 | 179233 | 129494 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 14 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | ||||
| 67219 | 67219 | 129495 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1136 Havens St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | |||
| 134174 | 134174 | 71938 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 384 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/21/1995 12:00:00 AM | 4 | 6011634.93944 | 2119088.82833 | 37.7992691828709 | -122.403836198406 | (37.7992691828709, -122.403836198406) | ||
| 148538 | 148538 | 42630 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2634 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/2000 12:00:00 AM | 6 | Permit Number 42686 | 6004473.47116 | 2118249.9245 | 37.7965630841803 | -122.428557534402 | (37.7965630841803, -122.428557534402) | |
| 66041 | 66041 | 129492 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999690.83284 | 2117600.09007 | 37.794506995647 | -122.445059718941 | (37.794506995647, -122.445059718941) | |||
| 47869 | 47869 | 129491 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5999689.18555 | 2117591.31365 | 37.794482803901296 | -122.445064787505 | (37.7944828039013, -122.445064787505) | |||
| 175637 | 175637 | 129490 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2536 Baker St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5999691.42103 | 2117587.23687 | 37.794471737733105 | -122.44505675927401 | (37.7944717377331, -122.445056759274) | |||
| 47695 | 47695 | 41753 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.42020574908899 | (37.7925696967985, -122.420205749089) | |
| 46244 | 46244 | 250337 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 21 25th Ave North | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5987995.71435 | 2115876.11718 | 37.7890990187437 | -122.485399212222 | (37.7890990187437, -122.485399212222) | |||
| 76289 | 76289 | 250091 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1620 Gough St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | |||
| 181185 | 181185 | 66621 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 153 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/15/1991 12:00:00 AM | 2 | Permit Number 29825 | 5988002.0511 | 2114993.09117 | 37.7866748512276 | -122.48531246716499 | (37.7866748512276, -122.485312467165) | ||
| 40805 | 40805 | 122909 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2x 12th Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 5992095.78801 | 2114872.2732700002 | 37.7865807540814 | -122.471140447624 | (37.7865807540814, -122.471140447624) | ||||
| 155422 | 155422 | 120286 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 157 24th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988329.9195 | 2114925.99705 | 37.786509724826004 | -122.48417321294501 | (37.786509724826, -122.484173212945) | ||||
| 5541 | 5541 | 81381 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 822 Geary St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/08/2003 12:00:00 AM | 3x3 | 6007769.502 | 2114456.07002 | 37.7863320683098 | -122.41688358241899 | (37.7863320683098, -122.416883582419) | ||
| 185686 | 185686 | 139032 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1535 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000626.6398 | 2114005.4469999997 | 37.784690408082 | -122.441563639416 | (37.784690408082, -122.441563639416) | |||
| 189085 | 189085 | 139033 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1535 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000628.7276 | 2113990.1365 | 37.784648488341496 | -122.441555317265 | (37.7846484883415, -122.441555317265) | |||
| 184226 | 184226 | 139035 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000637.7747 | 2113910.8003 | 37.7844311670031 | -122.441518322309 | (37.7844311670031, -122.441518322309) | |||
| 53082 | 53082 | 139036 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.784372208438604 | -122.441499920001 | (37.7843722084386, -122.441499920001) | |||
| 29485 | 29485 | 139037 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000646.8218 | 2113873.9159999997 | 37.7843304076342 | -122.441484374883 | (37.7843304076342, -122.441484374883) | |||
| 26310 | 26310 | 139038 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1501 BRODERICK ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000648.2136 | 2113864.1729 | 37.7843037348812 | -122.441478860369 | (37.7843037348812, -122.441478860369) | |||
| 109500 | 109500 | 116713 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6000212.5605 | 2113848.1665 | 37.78423495653821 | -122.44298491286699 | (37.7842349565382, -122.442984912867) | |||
| 130678 | 130678 | 116712 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1400 Baker St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6000214.6483 | 2113835.6397 | 37.784200680215605 | -122.44297678993999 | (37.7842006802156, -122.44297678994) | |||
| 63394 | 63394 | 119482 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985642.69106 | 2113025.08426 | 37.781133543390204 | -122.49333012331499 | (37.7811335433902, -122.493330123315) | |||
| 37967 | 37967 | 117755 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 406 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 5983780.251180001 | 2113048.87393 | 37.781089749801204 | -122.499774894099 | (37.7810897498012, -122.499774894099) | |||
| 149892 | 149892 | 119481 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.19758 | 2112999.51907 | 37.781063436855604 | -122.493323027528 | (37.7810634368556, -122.493323027528) | |||
| 176931 | 176931 | 119480 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985643.02597 | 2112973.39807 | 37.7809916475781 | -122.493325155639 | (37.7809916475781, -122.493325155639) | |||
| 38348 | 38348 | 119479 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 426 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5985644.21808 | 2112952.33317 | 37.7809338791525 | -122.493319479205 | (37.7809338791525, -122.493319479205) | |||
| 159001 | 159001 | 117979 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 430 38th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5984095.97176 | 2112889.786 | 37.7806714622872 | -122.498670920289 | (37.7806714622872, -122.498670920289) | |||
| 145138 | 145138 | 24745 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 128X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982364.706809999 | 2112649.87562 | 37.779911051225206 | -122.50464231484501 | (37.7799110512252, -122.504642314845) | ||
| 27070 | 27070 | 118586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Point Lobos Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 5982415.39383 | 2112637.72046 | 37.779880658188794 | -122.50446606808501 | (37.7798806581888, -122.504466068085) | |||
| 34562 | 34562 | 34814 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 485 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/10/1998 12:00:00 AM | 5 | Permit Number 38705 | 5983755.240019999 | 2112575.55408 | 37.779788683805705 | -122.49982642326599 | (37.7797886838057, -122.499826423266) | |
| 151529 | 151529 | 118577 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 10ft | 5982502.68903 | 2112449.1000200002 | 37.7793678960656 | -122.504150104536 | (37.7793678960656, -122.504150104536) | |||
| 136022 | 136022 | 118580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 7900 Geary Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5982502.32297 | 2112445.62468 | 37.7793583322752 | -122.504151113367 | (37.7793583322752, -122.504151113367) | |||
| 33118 | 33118 | 118541 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.423690001 | 2112399.66579 | 37.779163567264 | -122.50817750438699 | (37.779163567264, -122.508177504387) | ||||
| 73614 | 73614 | 40348 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 501 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/17/1999 12:00:00 AM | 6 | Permit Number 41478 | 5984070.03891 | 2112340.8801599997 | 37.779162805435 | -122.498720071631 | (37.779162805435, -122.498720071631) | |
| 51466 | 51466 | 118540 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5981337.117190001 | 2112394.76177 | 37.7791500842164 | -122.50817820058701 | (37.7791500842164, -122.508178200587) | ||||
| 156575 | 156575 | 118539 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 8250 Geary Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5981337.09939 | 2112389.25007 | 37.7791349496719 | -122.508177852958 | (37.7791349496719, -122.508177852958) | ||||
| 67927 | 67927 | 41944 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 567 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | 7 | Permit Number 42302 | 5993743.34162 | 2111650.50193 | 37.7778298007164 | -122.465206260397 | (37.7778298007164, -122.465206260397) | |
| 71533 | 71533 | 117965 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984581.6879 | 2111733.75019 | 37.7775257966351 | -122.496905272636 | (37.7775257966351, -122.496905272636) | |||
| 117656 | 117656 | 117966 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984567.33243 | 2111733.70358 | 37.7775248274666 | -122.496954928801 | (37.7775248274666, -122.496954928801) | |||
| 173249 | 173249 | 117964 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5984595.13139 | 2111732.58098 | 37.7775233740539 | -122.496858681509 | (37.7775233740539, -122.496858681509) | |||
| 34662 | 34662 | 117967 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 4545 Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984550.3085 | 2111733.18458 | 37.7775224048599 | -122.497013781042 | (37.7775224048599, -122.497013781042) | |||
| 165009 | 165009 | 117857 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983829.36907 | 2111677.06691 | 37.777326048802294 | -122.499503563368 | (37.7773260488023, -122.499503563368) | |||
| 67977 | 67977 | 117858 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 600 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5983830.55841 | 2111665.32715 | 37.777293884605704 | -122.499498581311 | (37.7772938846057, -122.499498581311) | |||
| 69462 | 69462 | 119126 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 601 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5981603.35382 | 2111608.79109 | 37.777007725640104 | -122.507198870746 | (37.7770077256401, -122.507198870746) | |||
| 159331 | 159331 | 120006 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 658 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5986941.43179 | 2111450.92852 | 37.7768872385676 | -122.488721446125 | (37.7768872385676, -122.488721446125) | |||
| 61495 | 61495 | 41940 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 642 05th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767709 | 5994437.32362 | 2111135.33206 | 37.7764552768418 | -122.46276817075301 | (37.7764552768418, -122.462768170753) |
| 57870 | 57870 | 37592 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 639 11th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1998 12:00:00 AM | 4 | Permit Number 40020 | 5992524.028 | 2111081.26309 | 37.776196436129396 | -122.46938280754699 | (37.7761964361294, -122.469382807547) | |
| 65074 | 65074 | 67318 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 666 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1992 12:00:00 AM | 9 | Permit Number 30800 | 5993501.91813 | 2110961.7349 | 37.7759247065994 | -122.46599136010799 | (37.7759247065994, -122.465991360108) | |
| 25168 | 25168 | 118098 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3619 Balboa St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5984331.597680001 | 2111046.0676700003 | 37.7756229611607 | -122.497719616092 | (37.7756229611607, -122.497719616092) | |||
| 36376 | 36376 | 37433 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | ||
| 59000 | 59000 | 227698 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 517 Hickory St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6004312.97566 | 2110291.73585 | 37.7747028072132 | -122.428545336007 | (37.7747028072132, -122.428545336007) | |||
| 140281 | 140281 | 108494 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 734 11th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773785 | 5992601.40555 | 2110422.43493 | 37.7743919431152 | -122.469067180848 | (37.7743919431152, -122.469067180848) |
| 75063 | 75063 | 123520 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 5ft | 5994672.01997 | 2110241.5879900004 | 37.774014807441795 | -122.461891472498 | (37.7740148074418, -122.461891472498) | |||
| 161558 | 161558 | 123521 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 2808 Fulton St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 5994656.80881 | 2110239.6852599997 | 37.7740087073423 | -122.46194395210199 | (37.7740087073423, -122.461943952102) | |||
| 108882 | 108882 | 90815 | DPW Maintained 3 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3145 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985771.299330001 | 2110409.9607700002 | 37.7739606832472 | -122.49269254584101 | (37.7739606832472, -122.492692545841) | ||
| 74277 | 74277 | 67405 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 774 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/30/1992 12:00:00 AM | 9 | Permit Number 30904 | 5989782.793 | 2110097.20217 | 37.7733356814764 | -122.478793391379 | (37.7733356814764, -122.478793391379) | |
| 153673 | 153673 | 72284 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 828 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/20/1996 12:00:00 AM | 3 | 5982951.02608 | 2110145.8974099997 | 37.773070328481396 | -122.502428636033 | (37.7730703284814, -122.502428636033) | ||
| 177051 | 177051 | 207148 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992391.03537 | 2107185.15973 | 37.7654910946525 | -122.469559175111 | (37.7654910946525, -122.469559175111) | |||
| 186733 | 186733 | 226608 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1035 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5997646.28955 | 2106916.84179 | 37.765056684330794 | -122.451363177783 | (37.7650566843308, -122.451363177783) | |||
| 116109 | 116109 | 115788 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 3628 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2016 12:00:00 AM | 3 | Permit Number 777599 | 6002731.19846 | 2106518.35077 | 37.764252377203 | -122.433747267607 | (37.764252377203, -122.433747267607) | |
| 57932 | 57932 | 226588 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 350 Treat Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008565.829469999 | 2106391.50298 | 37.7642334332393 | -122.41355789668002 | (37.7642334332393, -122.41355789668) | |||
| 162170 | 162170 | 226587 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 352 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008561.06519 | 2106374.04513 | 37.7641852304909 | -122.413573140196 | (37.7641852304909, -122.413573140196) | |||
| 25103 | 25103 | 226578 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 124 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5998059.2298099995 | 2106534.17954 | 37.76402962709221 | -122.44990734536199 | (37.7640296270922, -122.449907345362) | |||
| 185161 | 185161 | 183715 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1226 39th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983995.5254 | 2106803.3357 | 37.7639539248956 | -122.49856868241899 | (37.7639539248956, -122.498568682419) | |||
| 35444 | 35444 | 31932 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1210 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/26/1995 12:00:00 AM | 7 | Permit Number 35348 | 5981508.8658 | 2106816.8909 | 37.763844998562206 | -122.507170151225 | (37.7638449985622, -122.507170151225) | |
| 155540 | 155540 | 226607 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 205 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997675.15136 | 2106444.92247 | 37.7637625662095 | -122.45122931550699 | (37.7637625662095, -122.451229315507) | |||
| 62306 | 62306 | 52667 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 226@ MARIPOSA Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/29/2006 12:00:00 AM | 4 | Permit Number 48748 | 6013989.6640800005 | 2106012.3733900003 | 37.7634954891429 | -122.39477170574301 | (37.7634954891429, -122.394771705743) | ||
| 163271 | 163271 | 32472 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 117 Lower Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1996 12:00:00 AM | 5 | Permit Number 36980 | 6000335.64895 | 2106187.4701799997 | 37.7632076377424 | -122.442009017113 | (37.7632076377424, -122.442009017113) | |
| 117257 | 117257 | 108497 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1339 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773641 | 5992378.78756 | 2106335.85187 | 37.7631584124216 | -122.46953970622101 | (37.7631584124216, -122.469539706221) |
| 186519 | 186519 | 32589 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1286 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/1996 12:00:00 AM | 4 | Permit Number 37058 | 5985555.6068 | 2106469.8118 | 37.763129529589705 | -122.493148331917 | (37.7631295295897, -122.493148331917) | |
| 136966 | 136966 | 207147 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1341 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5992375.35662 | 2106303.37048 | 37.7630690288235 | -122.469549207953 | (37.7630690288235, -122.469549207953) | |||
| 163757 | 163757 | 183296 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1278 42nd Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5983073.0612 | 2106475.4841 | 37.7629995961897 | -122.50173490129801 | (37.7629995961897, -122.501734901298) | |||
| 42565 | 42565 | 226630 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 17 Temple St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 3ft | 6000001.75416 | 2105889.17936 | 37.7623695721306 | -122.443142420082 | (37.7623695721306, -122.443142420082) | |||
| 155804 | 155804 | 226585 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 257 Capp St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007206.23744 | 2105617.20797 | 37.762030962987296 | -122.41820544911998 | (37.7620309629873, -122.41820544912) | |||
| 154647 | 154647 | 207152 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 731 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5992245.611880001 | 2105887.84431 | 37.761920604463796 | -122.469967690366 | (37.7619206044638, -122.469967690366) | |||
| 42942 | 42942 | 207270 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | |||
| 31099 | 31099 | 226629 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 54 Collingwood St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001984.40508 | 2105553.3896 | 37.761560425102 | -122.43626114684099 | (37.761560425102, -122.436261146841) | |||
| 37207 | 37207 | 207145 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | |||
| 179189 | 179189 | 207142 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1419 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5991123.51551 | 2105737.38087 | 37.7614425437634 | -122.473837564856 | (37.7614425437634, -122.473837564856) | |||
| 67505 | 67505 | 50406 | Permitted Site 1 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1361 46th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/06/2003 12:00:00 AM | 4 | Permit Number 47058 | 5981810.1658 | 2105846.3225 | 37.761197837443596 | -122.50605609679701 | (37.7611978374436, -122.506056096797) | |
| 73076 | 73076 | 207146 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1440 16th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5991174.2447 | 2105585.9909099997 | 37.7610298052998 | -122.47365107156601 | (37.7610298052998, -122.473651071566) | |||
| 168679 | 168679 | 226579 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5998203.55994 | 2105386.43051 | 37.7608864542601 | -122.44932545342199 | (37.7608864542601, -122.449325453422) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) | |||
| 69145 | 69145 | 207269 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1477 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5994263.394830001 | 2105452.9722599997 | 37.760842992730105 | -122.462957472303 | (37.7608429927301, -122.462957472303) | |||
| 150633 | 150633 | 207151 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 223 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994241.91079 | 2105279.16697 | 37.760364530923205 | -122.46301916490299 | (37.7603645309232, -122.463019164903) | |||
| 134189 | 134189 | 226586 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 195 Lexington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006490.36158 | 2105010.39 | 37.760324461620705 | -122.420638312212 | (37.7603244616207, -122.420638312212) | |||
| 168553 | 168553 | 191409 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1201 20th St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 6ft | 6014316.155809999 | 2104772.8809 | 37.760110260198495 | -122.39355571261999 | (37.7601102601985, -122.39355571262) | |||
| 33451 | 33451 | 191410 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 777 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6011870.78856 | 2104734.77484 | 37.7598694505299 | -122.402010442428 | (37.7598694505299, -122.402010442428) | |||
| 167267 | 167267 | 227704 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 752 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010109.25034 | 2104766.0690599997 | 37.7598569040934 | -122.408104977977 | (37.7598569040934, -122.408104977977) | |||
| 170261 | 170261 | 207163 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1557 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5993970.96623 | 2104931.68714 | 37.7593948306232 | -122.46393100551902 | (37.7593948306232, -122.463931005519) |
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");