Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude ▼ | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73649 | 73649 | 184232 | Undocumented 2 | Tristania conferta :: 79 | 1500 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983211.3452 | 2104903.2019 | 37.75869067578329 | -122.50114033514299 | (37.7586906757833, -122.501140335143) | |||
| 152509 | 152509 | 69819 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/04/2001 12:00:00 AM | 5 | 5983899.4988 | 2104926.7311 | 37.7587956653789 | -122.49876216104799 | (37.7587956653789, -122.498762161048) | ||
| 32015 | 32015 | 184222 | Undocumented 2 | Tristania conferta :: 79 | 3521 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5983907.1382 | 2104926.4256 | 37.7587952746185 | -122.49873571831999 | (37.7587952746185, -122.49873571832) | |||
| 134454 | 134454 | 54141 | Permitted Site 1 | Tristania conferta :: 79 | 1432 38th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/2008 12:00:00 AM | 5 | 3x3 | Permit Number 51418 | 5984351.9621 | 2105403.8517 | 37.7601322321577 | -122.497232578221 | (37.7601322321577, -122.497232578221) | |
| 68784 | 68784 | 184807 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984672.982999999 | 2106530.3427 | 37.7632440693949 | -122.49620545091001 | (37.7632440693949, -122.49620545091) | |||
| 166802 | 166802 | 184808 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 0ft | 5984676.7802 | 2106518.9511 | 37.763213013686396 | -122.49619147733 | (37.7632130136864, -122.49619147733) | |||
| 180440 | 180440 | 184353 | Undocumented 2 | Tristania conferta :: 79 | 1251 Sunset Blvd | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 0ft | 5984679.818 | 2106506.8001 | 37.763179828394996 | -122.49618007420099 | (37.763179828395, -122.496180074201) | |||
| 31547 | 31547 | 187235 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 18 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984966.2222 | 2098610.2885 | 37.7415149514197 | -122.494607336605 | (37.7415149514197, -122.494607336605) | |||
| 132319 | 132319 | 187236 | Undocumented 2 | Tristania conferta :: 79 | 2401 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 0ft | 5984970.7155 | 2098606.6122 | 37.7415051202811 | -122.49459152958401 | (37.7415051202811, -122.494591529584) | |||
| 3094 | 3094 | 253300 | Undocumented 2 | Tristania conferta :: 79 | 844 33rd Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 5985769.0 | 2110141.0 | 37.773222058846 | -122.492680686455 | (37.773222058846, -122.492680686455) | ||||
| 59858 | 59858 | 107147 | Undocumented 2 | Tristania conferta :: 79 | 2466 34th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 5985833.5095 | 2098430.6846 | 37.7410725309134 | -122.49159537855301 | (37.7410725309134, -122.491595378553) | ||||
| 164064 | 164064 | 107146 | Undocumented 2 | Tristania conferta :: 79 | 2466 34th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 5985834.1864 | 2098423.2393 | 37.7410521276716 | -122.491592490194 | (37.7410521276716, -122.491592490194) | ||||
| 151871 | 151871 | 107145 | Undocumented 2 | Tristania conferta :: 79 | 2466 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5985834.5248 | 2098407.3335 | 37.7410084743792 | -122.491590149603 | (37.7410084743792, -122.491590149603) | ||||
| 96334 | 96334 | 109151 | Permitted Site 1 | Tristania conferta :: 79 | 727 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/29/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769036 | 5986896.6 | 2110966.4 | 37.7755542438819 | -122.48884090533001 | (37.7755542438819, -122.48884090533) |
| 159336 | 159336 | 38128 | Permitted Site 1 | Tristania conferta :: 79 | 2817 Lincoln Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/13/1998 12:00:00 AM | 6 | Permit Number 40292 | 5986952.8937 | 2107070.8859 | 37.764861536167395 | -122.48835982667299 | (37.7648615361674, -122.488359826673) | |
| 10436 | 10436 | 115660 | DPW Maintained 3 | Tristania conferta :: 79 | 2574 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | 6x10 | 5987719.8552 | 2097767.8758 | 37.739362692059295 | -122.48502454471901 | (37.7393626920593, -122.485024544719) | |||
| 59402 | 59402 | 82190 | Permitted Site 1 | Tristania conferta :: 79 | 1954 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 4 | 3x3 | Permit Number 49859 | 5989124.369 | 2102026.7679 | 37.751138201669 | -122.48048007964701 | (37.751138201669, -122.480480079647) | |
| 22563 | 22563 | 9064 | Permitted Site 1 | Tristania conferta :: 79 | 5530 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/25/2001 12:00:00 AM | 3 | 3X3 | 5989802.812000001 | 2112705.6659 | 37.7804989633648 | -122.478914967756 | (37.7804989633648, -122.478914967756) | ||
| 60940 | 60940 | 81428 | Permitted Site 1 | Tristania conferta :: 79 | 2015 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/29/2007 12:00:00 AM | 5 | 3x3 | Permit Number 49852 | 5990022.9826 | 2101627.3481 | 37.7500936819126 | -122.477343424721 | (37.7500936819126, -122.477343424721) | |
| 149440 | 149440 | 61393 | Permitted Site 1 | Tristania conferta :: 79 | 926 Taraval St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50349 | 5990253.2983 | 2099081.9773 | 37.743118118565505 | -122.47636107832199 | (37.7431181185655, -122.476361078322) | |
| 98092 | 98092 | 115300 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 99519 | 99519 | 115299 | Permitted Site 1 | Tristania conferta :: 79 | 177 Lomita Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 01/22/2016 12:00:00 AM | Permit Number 775793 | 5991298.7 | 2104254.5 | 37.757381090716 | -122.473123533862 | (37.757381090716, -122.473123533862) | |||
| 96238 | 96238 | 54270 | Permitted Site 1 | Tristania conferta :: 79 | 1240 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2015 12:00:00 AM | 3 | Permit Number 10023 | 5993331.28695265 | 2107027.13972063 | 37.765111509668706 | -122.466295599736 | (37.7651115096687, -122.466295599736) | ||
| 128303 | 128303 | 111994 | Permitted Site 1 | Tristania conferta :: 79 | 1244 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/22/2015 12:00:00 AM | 3 | 3x3 | 5993400.7 | 2107017.1 | 37.7650879480266 | -122.466054789326 | (37.7650879480266, -122.466054789326) | ||
| 96267 | 96267 | 115369 | Permitted Site 1 | Tristania conferta :: 79 | 720 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/28/2016 12:00:00 AM | 3 | Permit Number 777460 | 5993541.3 | 2110551.9 | 37.7748016816289 | -122.465825344597 | (37.7748016816289, -122.465825344597) | ||
| 20268 | 20268 | 25223 | DPW Maintained 3 | Tristania conferta :: 79 | 1951 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5993847.033 | 2092637.9106 | 37.7256320661895 | -122.46346745052 | (37.7256320661895, -122.46346745052) | |||
| 17475 | 17475 | 25279 | DPW Maintained 3 | Tristania conferta :: 79 | 1940 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5993856.5207 | 2092712.5569 | 37.7258375734043 | -122.463440067194 | (37.7258375734043, -122.463440067194) | |||
| 21220 | 21220 | 25224 | DPW Maintained 3 | Tristania conferta :: 79 | 1951 Ocean Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 5993865.4444 | 2092626.4035 | 37.7256015312656 | -122.463402969615 | (37.7256015312656, -122.463402969615) | |||
| 21434 | 21434 | 25225 | Permitted Site 1 | Tristania conferta :: 79 | 1949 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5993885.2366 | 2092618.1184 | 37.7255799226856 | -122.463333949193 | (37.7255799226856, -122.463333949193) | |||
| 17805 | 17805 | 25228 | Permitted Site 1 | Tristania conferta :: 79 | 1923 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 5994038.0508 | 2092538.029 | 37.7253688193969 | -122.462799879695 | (37.7253688193969, -122.462799879695) | |||
| 19401 | 19401 | 29568 | DPW Maintained 3 | Tristania conferta :: 79 | 1515 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5995262.4177 | 2092118.4741 | 37.7242872653999 | -122.458537028286 | (37.7242872653999, -122.458537028286) | |||
| 186887 | 186887 | 141089 | DPW Maintained 3 | Tristania conferta :: 79 | 100x JORDAN AVE | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 0ft | 5996248.2713 | 2112978.5918 | 37.7816205163369 | -122.456636959709 | (37.7816205163369, -122.456636959709) | |||
| 175607 | 175607 | 141094 | Undocumented 2 | Tristania conferta :: 79 | 188 Jordan Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5996267.5613 | 2113016.8335 | 37.7817266254142 | -122.456572992218 | (37.7817266254142, -122.456572992218) | |||
| 63684 | 63684 | 141092 | Undocumented 2 | Tristania conferta :: 79 | 192 Jordan Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5996267.8998 | 2112993.8208 | 37.781663458081205 | -122.45657015648099 | (37.7816634580812, -122.456570156481) | |||
| 152722 | 152722 | 141093 | Undocumented 2 | Tristania conferta :: 79 | 190 Jordan Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996268.2382 | 2113005.3272 | 37.781695071030796 | -122.456569818134 | (37.7816950710308, -122.456569818134) | |||
| 33384 | 33384 | 141091 | Undocumented 2 | Tristania conferta :: 79 | 194 Jordan Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5996268.2382 | 2112980.2839 | 37.78162630877429 | -122.456568006554 | (37.7816263087743, -122.456568006554) | |||
| 130755 | 130755 | 141090 | Undocumented 2 | Tristania conferta :: 79 | 196 Jordan Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5996268.5766 | 2112969.4544 | 37.78159659326921 | -122.456566052477 | (37.7815965932692, -122.456566052477) | |||
| 85477 | 85477 | 49069 | Permitted Site 1 | Tristania conferta :: 79 | 1298 Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/29/2015 12:00:00 AM | 3x3 | Permit Number 776020 | 5995836.31315767 | 2092013.47244835 | 37.724031921729704 | -122.45654557668001 | (37.7240319217297, -122.45654557668) | ||
| 38276 | 38276 | 141234 | Undocumented 2 | Tristania conferta :: 79 | 22 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5996538.8064 | 2114429.9137 | 37.7856221373365 | -122.455736793232 | (37.7856221373365, -122.455736793232) | |||
| 172375 | 172375 | 140639 | Undocumented 2 | Tristania conferta :: 79 | 468 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5996860.5832 | 2109999.5178 | 37.7734758965802 | -122.454303413235 | (37.7734758965802, -122.454303413235) | |||
| 30658 | 30658 | 140638 | Undocumented 2 | Tristania conferta :: 79 | 472 Stanyan St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5996864.7991 | 2109972.3061 | 37.7734014220919 | -122.45428686398199 | (37.7734014220919, -122.454286863982) | |||
| 31989 | 31989 | 140231 | Undocumented 2 | Tristania conferta :: 79 | 2227 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997121.9683 | 2110490.0939 | 37.774837877214104 | -122.45343467561199 | (37.7748378772141, -122.453434675612) | |||
| 21217 | 21217 | 17141 | DPW Maintained 3 | Tristania conferta :: 79 | 2065 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 5997139.5202 | 2109105.5449 | 37.7710372704709 | -122.453273982724 | (37.7710372704709, -122.453273982724) | |||
| 20627 | 20627 | 17139 | DPW Maintained 3 | Tristania conferta :: 79 | 2055 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 5997166.0096 | 2109107.6811 | 37.771044654167795 | -122.45318250978 | (37.7710446541678, -122.45318250978) | |||
| 182541 | 182541 | 246101 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997168.442000001 | 2108117.5543 | 37.7683261602514 | -122.45310260948 | (37.7683261602514, -122.45310260948) | |||
| 7117 | 7117 | 7106 | DPW Maintained 3 | Tristania conferta :: 79 | 2136 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5997200.5381 | 2109511.6187 | 37.7721557413798 | -122.453092239143 | (37.7721557413798, -122.453092239143) | |||
| 880 | 880 | 246102 | DPW Maintained 3 | Tristania conferta :: 79 | 1764 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | Width 0ft | 5997188.4287 | 2108119.9769 | 37.768333957535795 | -122.453033652641 | (37.7683339575358, -122.453033652641) | |||
| 129916 | 129916 | 140234 | Undocumented 2 | Tristania conferta :: 79 | 1 SHRADER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997242.3128 | 2110421.4899 | 37.7746564060011 | -122.45301342789601 | (37.7746564060011, -122.453013427896) | |||
| 156365 | 156365 | 114168 | Undocumented 2 | Tristania conferta :: 79 | 1x Shrader St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 5997246.1454 | 2110389.6791 | 37.774569281446794 | -122.452997873526 | (37.7745692814468, -122.452997873526) | |||
| 136567 | 136567 | 245936 | Undocumented 2 | Tristania conferta :: 79 | 188 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997210.9895 | 2107777.1744 | 37.76739400269 | -122.45293087030501 | (37.76739400269, -122.452930870305) | |||
| 39892 | 39892 | 246103 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997227.3423 | 2108124.3680000002 | 37.768348244409204 | -122.452899371868 | (37.7683482444092, -122.452899371868) | |||
| 65442 | 65442 | 245935 | Undocumented 2 | Tristania conferta :: 79 | 188 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997227.0394 | 2107780.5055 | 37.767404068786796 | -122.452875596673 | (37.7674040687868, -122.452875596673) | |||
| 49736 | 49736 | 246104 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997246.4205 | 2108126.7906 | 37.7683559895145 | -122.45283355738701 | (37.7683559895145, -122.452833557387) | |||
| 131386 | 131386 | 140649 | Undocumented 2 | Tristania conferta :: 79 | 109 Shrader St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997299.8022 | 2110011.7822 | 37.7735347493893 | -122.452784984309 | (37.7735347493893, -122.452784984309) | |||
| 63719 | 63719 | 246105 | Undocumented 2 | Tristania conferta :: 79 | 1764 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997266.71 | 2108130.1217 | 37.7683662985003 | -122.45276361872 | (37.7683662985003, -122.45276361872) | |||
| 149406 | 149406 | 247255 | Undocumented 2 | Tristania conferta :: 79 | 2027 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5997293.757 | 2109123.4893 | 37.77109538026679 | -122.45274177089199 | (37.7710953802668, -122.452741770892) | |||
| 16912 | 16912 | 10519 | Permitted Site 1 | Tristania conferta :: 79 | 1840 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/1990 12:00:00 AM | 50 | 5997331.1413 | 2108490.0928 | 37.76935837855329 | -122.45256673963301 | (37.7693583785533, -122.452566739633) | |||
| 54568 | 54568 | 140188 | Undocumented 2 | Tristania conferta :: 79 | 294 Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5997403.6344 | 2109575.9167 | 37.772343924669 | -122.452394356341 | (37.772343924669, -122.452394356341) | |||
| 153883 | 153883 | 246072 | Undocumented 2 | Tristania conferta :: 79 | 1827 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5997411.4623 | 2108451.7262 | 37.7692576354413 | -122.452286145637 | (37.7692576354413, -122.452286145637) | |||
| 67296 | 67296 | 140186 | Undocumented 2 | Tristania conferta :: 79 | 2098 FELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5997442.3009 | 2109546.1708 | 37.7722644652587 | -122.45225845928302 | (37.7722644652587, -122.452258459283) | |||
| 49535 | 49535 | 245967 | Undocumented 2 | Tristania conferta :: 79 | 142 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997407.2227 | 2107805.0347 | 37.7674817434178 | -122.452254140763 | (37.7674817434178, -122.452254140763) | |||
| 130320 | 130320 | 141068 | Undocumented 2 | Tristania conferta :: 79 | 516 Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997528.6902 | 2112557.7643 | 37.7805384665203 | -122.45217696844 | (37.7805384665203, -122.45217696844) | |||
| 187723 | 187723 | 141067 | Undocumented 2 | Tristania conferta :: 79 | 516 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997555.0871 | 2112560.1333 | 37.780546483262796 | -122.452085820488 | (37.7805464832628, -122.452085820488) | |||
| 3752 | 3752 | 7102 | DPW Maintained 3 | Tristania conferta :: 79 | 2080 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4X4 | 5997497.5881 | 2109552.6978 | 37.7722855537803 | -122.45206768793001 | (37.7722855537803, -122.45206768793) | |||
| 162458 | 162458 | 141066 | Undocumented 2 | Tristania conferta :: 79 | 516 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997568.2855 | 2112562.8407 | 37.780554673089206 | -122.452040356585 | (37.7805546730892, -122.452040356585) | |||
| 21260 | 21260 | 10511 | Permitted Site 1 | Tristania conferta :: 79 | 1800 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/10/2007 12:00:00 AM | 6 | 3X3 | 5997484.5237 | 2108509.319 | 37.7694199557275 | -122.452037587086 | (37.7694199557275, -122.452037587086) | ||
| 8199 | 8199 | 7101 | DPW Maintained 3 | Tristania conferta :: 79 | 2070 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/21/1994 12:00:00 AM | 6 | 4X4 | 5997541.7411 | 2109558.8408 | 37.7723049499053 | -122.451915402773 | (37.7723049499053, -122.451915402773) | ||
| 157125 | 157125 | 246161 | Undocumented 2 | Tristania conferta :: 79 | 654 Shrader St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5997590.7371 | 2108239.7458 | 37.768685860137296 | -122.45165075327299 | (37.7686858601373, -122.451650753273) | |||
| 23211 | 23211 | 10510 | DPW Maintained 3 | Tristania conferta :: 79 | 1793 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 1 | 5997601.0333 | 2108476.5582 | 37.7693366759731 | -122.451632224006 | (37.7693366759731, -122.451632224006) | |||
| 44322 | 44322 | 246159 | Undocumented 2 | Tristania conferta :: 79 | 664 Shrader St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | Width 0ft | 5997597.3994 | 2108195.8356 | 37.7685656755079 | -122.451624541219 | (37.7685656755079, -122.451624541219) | |||
| 187395 | 187395 | 248567 | Undocumented 2 | Tristania conferta :: 79 | 809 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997620.5658 | 2107720.8482 | 37.7672628081675 | -122.451510146252 | (37.7672628081675, -122.451510146252) | |||
| 52354 | 52354 | 141269 | Undocumented 2 | Tristania conferta :: 79 | 399 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997767.7852 | 2112527.4756 | 37.780468995132395 | -122.45134764442801 | (37.7804689951324, -122.451347644428) | |||
| 184369 | 184369 | 248527 | Undocumented 2 | Tristania conferta :: 79 | 65 Beulah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997684.7656 | 2107798.3724 | 37.7674793460156 | -122.451293681226 | (37.7674793460156, -122.451293681226) | |||
| 26560 | 26560 | 245957 | Undocumented 2 | Tristania conferta :: 79 | 850 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997681.1316 | 2107596.9911 | 37.7669261962578 | -122.451291725243 | (37.7669261962578, -122.451291725243) | |||
| 153341 | 153341 | 247346 | Undocumented 2 | Tristania conferta :: 79 | 1766 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997706.6931 | 2108542.6444 | 37.7695241821424 | -122.45127152038602 | (37.7695241821424, -122.451271520386) | |||
| 43577 | 43577 | 248528 | Undocumented 2 | Tristania conferta :: 79 | 55 Beulah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997696.5759 | 2107800.7951 | 37.7674866743633 | -122.45125300592599 | (37.7674866743633, -122.451253005926) | |||
| 178361 | 178361 | 248530 | Undocumented 2 | Tristania conferta :: 79 | 35 Beulah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5997722.0136 | 2107803.8234 | 37.7674964457612 | -122.45116523916799 | (37.7674964457612, -122.451165239168) | |||
| 162962 | 162962 | 141270 | Undocumented 2 | Tristania conferta :: 79 | 387 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997821.2558 | 2112535.5977 | 37.780494357868704 | -122.451163251255 | (37.7804943578687, -122.451163251255) | |||
| 63028 | 63028 | 248609 | Undocumented 2 | Tristania conferta :: 79 | 432 Frederick St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997733.2182 | 2107503.1141 | 37.7666714161881 | -122.451104796338 | (37.7666714161881, -122.451104796338) | |||
| 67682 | 67682 | 141271 | Undocumented 2 | Tristania conferta :: 79 | 381 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997841.2227 | 2112537.9666 | 37.7805020054221 | -122.45109434753999 | (37.7805020054221, -122.45109434754) | |||
| 52603 | 52603 | 248608 | Undocumented 2 | Tristania conferta :: 79 | 432 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 5997774.403 | 2107510.3819999998 | 37.7666937298525 | -122.450962870008 | (37.7666937298525, -122.450962870008) | |||
| 169388 | 169388 | 248514 | Undocumented 2 | Tristania conferta :: 79 | 25 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997781.3681 | 2107812.9082 | 37.767524788446 | -122.450960596024 | (37.767524788446, -122.450960596024) | |||
| 42835 | 42835 | 141272 | Undocumented 2 | Tristania conferta :: 79 | 365 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997908.5687 | 2112548.4577 | 37.7805346667324 | -122.450862123717 | (37.7805346667324, -122.450862123717) | |||
| 7899 | 7899 | 101329 | Undocumented 2 | Tristania conferta :: 79 | 2703 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 5997904.4066 | 2111642.2894 | 37.7780463265361 | -122.45081116588301 | (37.7780463265361, -122.450811165883) | |||
| 179514 | 179514 | 248512 | Undocumented 2 | Tristania conferta :: 79 | 19 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997839.8141 | 2107820.4790000003 | 37.767548921712496 | -122.450758985918 | (37.7675489217125, -122.450758985918) | |||
| 66752 | 66752 | 141273 | Undocumented 2 | Tristania conferta :: 79 | 363 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997942.7493 | 2112553.5341 | 37.780550561830395 | -122.450744243509 | (37.7805505618304, -122.450744243509) | |||
| 147204 | 147204 | 141457 | Undocumented 2 | Tristania conferta :: 79 | 1 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997940.1194 | 2111622.4489 | 37.77799389396429 | -122.450686192278 | (37.7779938939643, -122.450686192278) | |||
| 168765 | 168765 | 141458 | Undocumented 2 | Tristania conferta :: 79 | 9 Kittredge Ter | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997945.4102 | 2111586.3754 | 37.777895148355604 | -122.450665288127 | (37.7778951483556, -122.450665288127) | |||
| 44400 | 44400 | 141459 | Undocumented 2 | Tristania conferta :: 79 | 15 Kittredge Ter | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997948.2961 | 2111555.5927 | 37.7778107922486 | -122.450653084923 | (37.7778107922486, -122.450653084923) | |||
| 164892 | 164892 | 141477 | Undocumented 2 | Tristania conferta :: 79 | 25 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997952.6249 | 2111528.1769 | 37.777735763362 | -122.450636133087 | (37.777735763362, -122.450636133087) | |||
| 178192 | 178192 | 141511 | Undocumented 2 | Tristania conferta :: 79 | 29 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5997955.5108 | 2111504.1279 | 37.7776698962407 | -122.45062441553699 | (37.7776698962407, -122.450624415537) | |||
| 181815 | 181815 | 54243 | Permitted Site 1 | Tristania conferta :: 79 | 35 Kittredge Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 26 | Permit Number 9984 | 5997958.8776 | 2111479.5979 | 37.777602735942295 | -122.45061099973499 | (37.7776027359423, -122.450610999735) | ||
| 70689 | 70689 | 141274 | Undocumented 2 | Tristania conferta :: 79 | 361 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5997984.0367 | 2112557.9335 | 37.7805650047265 | -122.450601728745 | (37.7805650047265, -122.450601728745) | |||
| 49196 | 49196 | 141537 | Undocumented 2 | Tristania conferta :: 79 | 41 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 5997962.2445 | 2111456.5108 | 37.777539537476 | -122.450597687662 | (37.777539537476, -122.450597687662) | |||
| 178246 | 178246 | 141548 | Undocumented 2 | Tristania conferta :: 79 | 53 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5997966.0923 | 2111424.7661 | 37.7774525950111 | -122.450582087707 | (37.7774525950111, -122.450582087707) | |||
| 23274 | 23274 | 10492 | DPW Maintained 3 | Tristania conferta :: 79 | 1699 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/1992 12:00:00 AM | 10 | 3X3 | 5997918.2468 | 2108523.3453 | 37.7694833025616 | -122.450538376308 | (37.7694833025616, -122.450538376308) | ||
| 39652 | 39652 | 141470 | Undocumented 2 | Tristania conferta :: 79 | 22 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997989.6604 | 2111550.7829 | 37.7777999533719 | -122.450509645298 | (37.7777999533719, -122.450509645298) | |||
| 52683 | 52683 | 141478 | Undocumented 2 | Tristania conferta :: 79 | 28 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997993.9892 | 2111527.2149 | 37.777735489524105 | -122.450492971073 | (37.7777354895241, -122.450492971073) | |||
| 55003 | 55003 | 141512 | Undocumented 2 | Tristania conferta :: 79 | 36 KITTREDGE TER | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997995.4321 | 2111502.2039 | 37.777666898397 | -122.450486176086 | (37.777666898397, -122.450486176086) | |||
| 54005 | 54005 | 141275 | Undocumented 2 | Tristania conferta :: 79 | 371 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5998017.5405 | 2112562.333 | 37.7805790022371 | -122.450486140983 | (37.7805790022371, -122.450486140983) |
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");