Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97457 | 97457 | 6 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 4949X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5992285.036119999 | 2114103.37756 | 37.784480522922394 | -122.470429683488 | (37.7844805229224, -122.470429683488) | |||
| 20605 | 20605 | 23 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 729 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/30/2011 12:00:00 AM | 3 | 4x4 | 6003875.846919999 | 2107718.3128400003 | 37.7676120683604 | -122.429873853201 | (37.7676120683604, -122.429873853201) | ||
| 82272 | 82272 | 27 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 740 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2008 12:00:00 AM | 3 | 3X3 | 6003877.1873918 | 2107766.1695161 | 37.767743547109106 | -122.429872630659 | (37.7677435471091, -122.429872630659) | ||
| 126224 | 126224 | 28 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 742 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/15/2011 12:00:00 AM | 3 | 3x3 | 6003863.8671794 | 2107765.4342001 | 37.76774077377821 | -122.42991865118601 | (37.7677407737782, -122.429918651186) | ||
| 17231 | 17231 | 30 | Permitted Site 1 | Lagerstroemia indica :: Crape Myrtle 199 | 750 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1X1 | 6003777.42436 | 2107761.72523 | 37.7677256941011 | -122.430217381651 | (37.7677256941011, -122.430217381651) | |||
| 17593 | 17593 | 35 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 765 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003712.362269999 | 2107704.7999 | 37.767565705622296 | -122.430438361268 | (37.7675657056223, -122.430438361268) | |||
| 20763 | 20763 | 36 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 773 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6003693.31613 | 2107706.2481400003 | 37.7675686032223 | -122.430504342717 | (37.7675686032223, -122.430504342717) | |||
| 106390 | 106390 | 39 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 783 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003606.5955195995 | 2107701.1557949 | 37.7675497079099 | -122.430803934479 | (37.7675497079099, -122.430803934479) | |||
| 23112 | 23112 | 40 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 784 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1995 12:00:00 AM | 14 | 2x3 | 6003610.50181 | 2107749.59526 | 37.7676829322386 | -122.430793880335 | (37.7676829322386, -122.430793880335) | ||
| 21243 | 21243 | 41 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 795 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003608.499480001 | 2107706.26027 | 37.767563831432206 | -122.43079771324601 | (37.7675638314322, -122.430797713246) | |||
| 96931 | 96931 | 42 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 795 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003531.1175202 | 2107696.9891434 | 37.7675339906335 | -122.431064705472 | (37.7675339906335, -122.431064705472) | |||
| 21346 | 21346 | 43 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 797 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003580.94003 | 2107704.3456099997 | 37.7675570127652 | -122.43089290110001 | (37.7675570127652, -122.4308929011) | |||
| 82457 | 82457 | 44 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 795 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6003531.1175202 | 2107696.9891434 | 37.7675339906335 | -122.431064705472 | (37.7675339906335, -122.431064705472) | |||
| 17746 | 17746 | 51 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 811 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1990 12:00:00 AM | 18 | 3X3 | 6003382.24776 | 2107695.57838 | 37.767521680208205 | -122.431579525381 | (37.7675216802082, -122.431579525381) | ||
| 21094 | 21094 | 60 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 842 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1990 12:00:00 AM | 12 | 3X3 | 6003241.42575 | 2107728.73521 | 37.7676047379919 | -122.432068977808 | (37.7676047379919, -122.432068977808) | ||
| 19937 | 19937 | 65 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 854 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/05/1990 12:00:00 AM | 12 | 6x3.5 | 6003105.8355 | 2107716.44027 | 37.7675632909511 | -122.432537088438 | (37.7675632909511, -122.432537088438) | ||
| 9061 | 9061 | 66 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 854 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 5.5x3.5 | 6003138.2570065 | 2107725.378034 | 37.767589670380296 | -122.432425585191 | (37.7675896703803, -122.432425585191) | |||
| 16954 | 16954 | 74 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 888 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 6002936.546 | 2107706.34195 | 37.767525961893 | -122.433121916663 | (37.767525961893, -122.433121916663) | |||
| 125538 | 125538 | 75 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 888 14TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1995 12:00:00 AM | 40 | 6002921.0 | 2107736.0 | 37.7676065137922 | -122.433177807531 | (37.7676065137922, -122.433177807531) | |||
| 85245 | 85245 | 77 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 97X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | |||
| 143619 | 143619 | 78 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 97X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002876.5924018 | 2107716.5314312 | 37.7675505386543 | -122.433330016252 | (37.7675505386543, -122.433330016252) | |||
| 9078 | 9078 | 79 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 899 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | 3X3 | 6002864.319993401 | 2107660.1796498 | 37.767395114191295 | -122.433368437593 | (37.7673951141913, -122.433368437593) | |||
| 9288 | 9288 | 80 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 899 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002864.319993401 | 2107660.1796498 | 37.767395114191295 | -122.433368437593 | (37.7673951141913, -122.433368437593) | |||
| 128193 | 128193 | 81 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 899 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2001 12:00:00 AM | 8 | 3X3 | 6002864.319993401 | 2107660.1796498 | 37.767395114191295 | -122.433368437593 | (37.7673951141913, -122.433368437593) | ||
| 19455 | 19455 | 82 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002798.55883 | 2107703.57748 | 37.7675105430125 | -122.43359899801901 | (37.7675105430125, -122.433598998019) | |||
| 17266 | 17266 | 83 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1997 12:00:00 AM | 12 | 3X3 | 6002779.45804 | 2107702.26706 | 37.7675058611368 | -122.433664971386 | (37.7675058611368, -122.433664971386) | ||
| 17770 | 17770 | 84 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002751.01782 | 2107698.1488200002 | 37.767492939684296 | -122.43376304785102 | (37.7674929396843, -122.433763047851) | |||
| 20925 | 20925 | 85 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002730.58019 | 2107700.13974 | 37.7674972465285 | -122.433833881131 | (37.7674972465285, -122.433833881131) | |||
| 18670 | 18670 | 89 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002626.96421 | 2107691.82359 | 37.7674685320657 | -122.434191680018 | (37.7674685320657, -122.434191680018) | |||
| 19187 | 19187 | 90 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6002594.42208 | 2107692.49628 | 37.7674685320724 | -122.434304286835 | (37.7674685320724, -122.434304286835) | |||
| 18320 | 18320 | 91 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3X3 | 6002566.003169999 | 2107689.4236 | 37.767458482149294 | -122.43440236419399 | (37.7674584821493, -122.434402364194) | |||
| 18693 | 18693 | 92 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3X3 | 6002538.15272 | 2107688.43049 | 37.7674541744033 | -122.434498624009 | (37.7674541744033, -122.434498624009) | |||
| 18863 | 18863 | 93 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002517.65025 | 2107687.28581 | 37.767449867535504 | -122.43456945733699 | (37.7674498675355, -122.434569457337) | |||
| 17531 | 17531 | 95 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6002436.73331 | 2107684.77563 | 37.7674383813948 | -122.434849158187 | (37.7674383813948, -122.434849158187) | |||
| 17703 | 17703 | 96 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6002409.38596 | 2107682.72677 | 37.7674312030188 | -122.434943602286 | (37.7674312030188, -122.434943602286) | |||
| 17717 | 17717 | 98 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002352.6347900005 | 2107680.7629400003 | 37.7674225884029 | -122.435139756108 | (37.7674225884029, -122.435139756108) | |||
| 20835 | 20835 | 99 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 900X 14th St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6002314.25424 | 2107678.41928 | 37.767413973794795 | -122.43527234134501 | (37.7674139737948, -122.435272341345) | |||
| 140598 | 140598 | 105 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 923 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/02/1996 12:00:00 AM | 12 | 3X3 | 6002700.4016261 | 2107651.1308054 | 37.767360967419705 | -122.43393476112301 | (37.7673609674197, -122.433934761123) | ||
| 3462 | 3462 | 109 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 941 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6002569.29571 | 2107648.70327 | 37.767346860988 | -122.434388064079 | (37.767346860988, -122.434388064079) | |||
| 17850 | 17850 | 116 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 973 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 6002428.768680001 | 2107637.5526900003 | 37.7673082665764 | -122.434873329236 | (37.7673082665764, -122.434873329236) | |||
| 95758 | 95758 | 118 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 983 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/07/1997 12:00:00 AM | 8 | 3X3 | 6002330.8302335 | 2107630.7292246004 | 37.767283969912796 | -122.43521159584101 | (37.7672839699128, -122.435211595841) | ||
| 18856 | 18856 | 120 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 997 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002297.4140800005 | 2107635.5838200003 | 37.7672954017956 | -122.435327524665 | (37.7672954017956, -122.435327524665) | |||
| 22257 | 22257 | 125 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1032 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/14/1990 12:00:00 AM | 18 | 3X3 | 6002008.22654 | 2107658.0827 | 37.767340750994 | -122.436329391899 | (37.767340750994, -122.436329391899) | ||
| 21543 | 21543 | 126 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1034 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001930.03147 | 2107660.22402 | 37.7673421872283 | -122.43660001049801 | (37.7673421872283, -122.436600010498) | |||
| 20804 | 20804 | 129 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1046 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 6001838.94694 | 2107648.51377 | 37.767304857259 | -122.436914220126 | (37.767304857259, -122.436914220126) | |||
| 121440 | 121440 | 130 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1047 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | 6001815.633124299 | 2107601.5664375 | 37.7671746263475 | -122.436991497714 | (37.7671746263475, -122.436991497714) | |||
| 21707 | 21707 | 149 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1074 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 18 | 3X3 | 6001630.772609999 | 2107637.13692 | 37.7672617851356 | -122.437633449319 | (37.7672617851356, -122.437633449319) | ||
| 22180 | 22180 | 151 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1080 14th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/06/2005 12:00:00 AM | 6 | 3X3 | 6001590.292219999 | 2107634.83777 | 37.767253170535795 | -122.437773300197 | (37.7672531705358, -122.437773300197) | ||
| 20118 | 20118 | 155 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1992 12:00:00 AM | 12 | 3X3 | 6001544.03852 | 2107632.6582400003 | 37.767244555911496 | -122.437933128614 | (37.7672445559115, -122.437933128614) | ||
| 17828 | 17828 | 156 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1090X 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6001515.67353 | 2107632.19991 | 37.767241684394705 | -122.43803120597401 | (37.7672416843947, -122.438031205974) | |||
| 19293 | 19293 | 159 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1095 14th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6001550.4127 | 2107593.72089 | 37.7671380060373 | -122.437908292048 | (37.7671380060373, -122.437908292048) | |||
| 21167 | 21167 | 160 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 1095 14th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3X3 | 6001560.73807 | 2107593.50705 | 37.767138006039204 | -122.437872562892 | (37.7671380060392, -122.437872562892) | |||
| 9511 | 9511 | 161 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5240X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3x3 | 5991235.99739 | 2114119.3924 | 37.784463784314 | -122.474060130881 | (37.784463784314, -122.474060130881) | |||
| 9320 | 9320 | 163 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 9074 | 9074 | 164 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2790X 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 5991861.232316299 | 2096712.8875626998 | 37.7367063200182 | -122.470628807941 | (37.7367063200182, -122.470628807941) | |||
| 19286 | 19286 | 173 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.35161 | 2107126.41813 | 37.7658955935305 | -122.43539853871201 | (37.7658955935305, -122.435398538712) | |||
| 20544 | 20544 | 174 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 195X Castro St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002266.37223 | 2107147.365 | 37.7659531096791 | -122.435399965935 | (37.7659531096791, -122.435399965935) | |||
| 117989 | 117989 | 175 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5400X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 3X3 | 5990796.10602 | 2114048.44446 | 37.7842434899767 | -122.475576806045 | (37.7842434899767, -122.475576806045) | |||
| 9574 | 9574 | 176 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990964.24262 | 2114110.49658 | 37.784423613403504 | -122.474999649931 | (37.7844236134035, -122.474999649931) | |||
| 9525 | 9525 | 177 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 5340X California St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 65 | 3x3 | 5990912.96055 | 2114105.91561 | 37.7844080632129 | -122.47517673183799 | (37.7844080632129, -122.475176731838) | |||
| 98530 | 98530 | 188 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1990X Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6006778.49785 | 2106815.42312 | 37.765296895397604 | -122.419769861465 | (37.7652968953976, -122.419769861465) | |||
| 145714 | 145714 | 189 | Permitted Site 1 | Pittosporum undulatum :: Victorian Box 26 | 1990X Mission St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 4X4 | 6006778.46705 | 2106797.52493 | 37.7652477494393 | -122.419768697906 | (37.7652477494393, -122.419768697906) | |||
| 118724 | 118724 | 194 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 419X Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X3 | 6005567.0759942 | 2106542.8569591 | 37.7644801752938 | -122.423940505082 | (37.7644801752938, -122.423940505082) | |||
| 19818 | 19818 | 195 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 290X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106583.9788 | 37.7644417056271 | -122.433195386565 | (37.7644417056271, -122.433195386565) | ||
| 17800 | 17800 | 196 | Permitted Site 1 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 292X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/24/2011 12:00:00 AM | 3 | 3x3 | 6002892.1169 | 2106567.7025 | 37.764397014858 | -122.433194223505 | (37.764397014858, -122.433194223505) | ||
| 18704 | 18704 | 204 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2912 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/1994 12:00:00 AM | 20 | 2X3 | 5990598.496180001 | 2095837.8189400001 | 37.7342305047257 | -122.474930733974 | (37.7342305047257, -122.474930733974) | ||
| 21686 | 21686 | 205 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2918 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/02/1994 12:00:00 AM | 10 | 2X3 | 5990601.803119999 | 2095779.7077 | 37.734071137676295 | -122.474915060599 | (37.7340711376763, -122.474915060599) | ||
| 20959 | 20959 | 208 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2924 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/01/1994 12:00:00 AM | 7 | 3x3 | 5990600.55143 | 2095720.40284 | 37.7339082290639 | -122.4749150606 | (37.7339082290639, -122.4749150606) | ||
| 12865 | 12865 | 210 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2929 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/28/2006 12:00:00 AM | 3 | 2X3 | 5990521.9439 | 2095739.47468 | 37.7339560397287 | -122.475188219755 | (37.7339560397287, -122.475188219755) | ||
| 11430 | 11430 | 214 | Permitted Site 1 | Maytenus boaria :: Mayten 22 | 2933 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X3 | 5990522.122690001 | 2095686.58843 | 37.7338108378948 | -122.47518374203699 | (37.7338108378948, -122.475183742037) | |||
| 18108 | 18108 | 215 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2940 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990603.87201 | 2095662.9362299999 | 37.733750632784705 | -122.47489938720699 | (37.7337506327847, -122.474899387207) | ||
| 18299 | 18299 | 217 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2944 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2X3 | 5990605.54964 | 2095619.69203 | 37.733631992415106 | -122.47489043175501 | (37.7336319924151, -122.474890431755) | ||
| 12873 | 12873 | 221 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2955 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/2008 12:00:00 AM | 6 | 2X3 | 5990527.06047 | 2095552.3434400002 | 37.7334425214563 | -122.47515687389799 | (37.7334425214563, -122.475156873898) | ||
| 17208 | 17208 | 223 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 2956 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1995 12:00:00 AM | 20 | 2X3 | 5990609.51977 | 2095500.9447299999 | 37.733306172547 | -122.474868041348 | (37.733306172547, -122.474868041348) | ||
| 22150 | 22150 | 224 | Permitted Site 1 | Pittosporum crassifolium :: Karo Tree 108 | 2956 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3X4 | 5990611.41299 | 2095529.2809 | 37.733384086190796 | -122.474863563627 | (37.7333840861908, -122.474863563627) | |||
| 18602 | 18602 | 234 | Permitted Site 1 | Leptospermum laevigatum :: Australian Tea Tree 38 | 2994 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | 2X3 | 5990616.60068 | 2095284.10448 | 37.7327111945568 | -122.474827739114 | (37.7327111945568, -122.474827739114) | |||
| 20431 | 20431 | 235 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2994 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/31/1994 12:00:00 AM | 14 | 3X3 | 5990616.42942 | 2095306.68002 | 37.7327731713422 | -122.474829978418 | (37.7327731713422, -122.474829978418) | ||
| 11340 | 11340 | 237 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3007 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990538.44703 | 2095140.6475 | 37.732312768812896 | -122.47508746420799 | (37.7323127688129, -122.475087464208) | ||
| 86397 | 86397 | 239 | Permitted Site 1 | Ulmus pumila :: Siberian Elm 53 | 3010X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 90 | 2 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 98100 | 98100 | 240 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3010X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 18 | 5x5 | 5990623.3177 | 2095139.449 | 37.73231439650579 | -122.474793962374 | (37.7323143965058, -122.474793962374) | |||
| 21416 | 21416 | 245 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3030 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/25/1994 12:00:00 AM | 12 | 2x3 | 5990627.42638 | 2094968.5100900002 | 37.7318452796259 | -122.4747672858 | (37.7318452796259, -122.4747672858) | ||
| 12218 | 12218 | 246 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3039 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 2 | 5990544.75562 | 2094979.28403 | 37.7318700712305 | -122.47505387905599 | (37.7318700712305, -122.475053879056) | ||
| 12773 | 12773 | 251 | Permitted Site 1 | Acer saccharinum :: Silver Maple 273 | 3063 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 2 | 5990548.37754 | 2094874.7295400002 | 37.7315832009825 | -122.47503372794701 | (37.7315832009825, -122.475033727947) | |||
| 12253 | 12253 | 252 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3063 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2003 12:00:00 AM | 6 | 2 | 5990549.27758 | 2094856.00777 | 37.731531847902495 | -122.47502925021601 | (37.7315318479025, -122.475029250216) | ||
| 21075 | 21075 | 253 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3070 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/18/1994 12:00:00 AM | 10 | 2 | 5990634.6279 | 2094818.7355900002 | 37.7314344540416 | -122.474731461301 | (37.7314344540416, -122.474731461301) | ||
| 106654 | 106654 | 264 | Permitted Site 1 | Platanus x hispanica :: Sycamore: London Plane 15 | 3201X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 82798 | 82798 | 265 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 139213 | 139213 | 268 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3201X 19th Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/18/2006 12:00:00 AM | 6 | 3X3 | 5990532.43506 | 2093914.7774599998 | 37.728946491022604 | -122.475018795259 | (37.7289464910226, -122.475018795259) | ||
| 120852 | 120852 | 314 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3438X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/1995 12:00:00 AM | 18 | 2 | 5990580.98006 | 2092524.42255 | 37.7251317386157 | -122.474749535596 | (37.7251317386157, -122.474749535596) | ||
| 141431 | 141431 | 317 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3498X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 84908 | 84908 | 319 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3488X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/12/1999 12:00:00 AM | 4 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 83243 | 83243 | 321 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3484X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 100457 | 100457 | 323 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3482X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 3 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 88883 | 88883 | 328 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3446X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/24/2008 12:00:00 AM | 8 | 2 | 5990579.05408 | 2092494.4249099998 | 37.725049260991604 | -122.474754004974 | (37.7250492609916, -122.474754004974) | ||
| 88885 | 88885 | 370 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 116977 | 116977 | 371 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 50092 | 50092 | 372 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 6 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 102899 | 102899 | 373 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 122391 | 122391 | 374 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) | |
| 92695 | 92695 | 375 | Permitted Site 1 | Sequoia sempervirens :: Coast Redwood 116 | 3711X 19th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51718 | 5990365.2788562 | 2091006.8640877 | 37.720952400174 | -122.475384436189 | (37.720952400174, -122.475384436189) |
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");