trees
502 rows where qSpecies_id = 157 sorted by qAddress
This data as json, CSV (advanced)
| rowid | TreeID | qLegalStatus_id | qSpecies_id | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100050 | 226596 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1 Newburg St | 4 | Sidewalk: Property side : Pot | Tree | Private 2 | 4 | Width 4ft | 6002583.45295 | 2099992.19698 | 37.746324733318 | -122.433791792881 | (37.746324733318, -122.433791792881) | 2 | 7 | 5 | 63 | 22 | |||
| 105732 | 226597 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1 Newburg St | 10 | Sidewalk: Curb side : Pot | Tree | Private 2 | 4 | Width 4ft | 6002589.21192 | 2100000.55478 | 37.746348008668 | -122.433772476325 | (37.746348008668, -122.433772476325) | 2 | 7 | 5 | 63 | 22 | |||
| 172115 | 226615 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 10 Appleton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6005546.7514 | 2097096.07919 | 37.7385403572369 | -122.423339202051 | (37.7385403572369, -122.423339202051) | 2 | 7 | 7 | 28859 | 2 | |||
| 94851 | 207170 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 100 Vista Verde Ct | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 10ft | 5999209.02129 | 2096067.64396 | 37.7353567886676 | -122.445178028368 | (37.7353567886676, -122.445178028368) | 9 | 7 | 4 | 63 | 40 | |||
| 22290 | 207208 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Foerster St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 10ft | 5998074.52147 | 2093832.40927 | 37.7291545431359 | -122.448939436512 | (37.7291545431359, -122.448939436512) | 9 | 7 | 4 | 28861 | 40 | |||
| 48212 | 207207 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Foerster St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 10ft | 5998074.45641 | 2093829.28565 | 37.7291459626917 | -122.448939436512 | (37.7291459626917, -122.448939436512) | 9 | 7 | 4 | 28861 | 40 | |||
| 114075 | 207312 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Ridgewood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996777.2193 | 2094487.39183 | 37.7308786909777 | -122.453471564574 | (37.7308786909777, -122.453471564574) | 9 | 7 | 4 | 28861 | 40 | |||
| 150524 | 207313 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Ridgewood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996777.96593 | 2094453.90027 | 37.7307867739736 | -122.453466566151 | (37.7307867739736, -122.453466566151) | 9 | 7 | 4 | 28861 | 40 | |||
| 48283 | 246731 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 101 Ripley St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 8ft | 6008584.45337 | 2099107.91594 | 37.7442353941634 | -122.41297845991 | (37.7442353941634, -122.41297845991) | 2 | 7 | 7 | 28859 | 2 | |||
| 118829 | 207228 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1018 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5995061.38916 | 2090705.29182 | 37.7203954494648 | -122.459129669002 | (37.7203954494648, -122.459129669002) | 9 | 8 | 6 | 28861 | 24 | |||
| 96777 | 226608 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1035 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5997646.28955 | 2106916.84179 | 37.7650566843308 | -122.451363177783 | (37.7650566843308, -122.451363177783) | 15 | 5 | 11 | 29492 | 9 | |||
| 139784 | 177024 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 11 Athens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | 6005372.1534 | 2093185.8595 | 37.7277939084451 | -122.423664939183 | (37.7277939084451, -122.423664939183) | 9 | 7 | 6 | 28861 | 5 | ||||
| 36470 | 226579 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Carmel St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 9 | Width 3ft | 5998203.55994 | 2105386.43051 | 37.7608864542601 | -122.449325453422 | (37.7608864542601, -122.449325453422) | 15 | 5 | 11 | 29492 | 12 | |||
| 149302 | 226580 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 7 | Width 3ft | 5998192.72104 | 2105385.25186 | 37.7608825979841 | -122.449362855306 | (37.7608825979841, -122.449362855306) | 15 | 5 | 11 | 29492 | 12 | |||
| 136348 | 118586 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Point Lobos Ave | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 4ft | 5982415.39383 | 2112637.72046 | 37.7798806581888 | -122.504466068085 | (37.7798806581888, -122.504466068085) | 11 | 6 | 2 | 55 | 26 | |||
| 118009 | 226581 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 110 Santa Marina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006265.98852 | 2097494.29518 | 37.739674335789 | -122.420880685817 | (37.739674335789, -122.420880685817) | 2 | 7 | 7 | 28859 | 2 | |||
| 52012 | 226589 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1100 Duncan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999827.96585 | 2100023.61803 | 37.7462542624189 | -122.443322166684 | (37.7462542624189, -122.443322166684) | 2 | 7 | 5 | 63 | 22 | |||
| 10783 | 26837 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1100X Duncan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2x2 | |||||||||||||
| 157043 | 129496 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1101 Greenwich St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6007491.98236 | 2119862.03748 | 37.8011599004699 | -122.418227149773 | (37.8011599004699, -122.418227149773) | 5 | 1 | 1 | 28858 | 32 | ||||
| 33099 | 207299 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 111 Valdez Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996293.5704 | 2094296.85345 | 37.7303277824929 | -122.455129844261 | (37.7303277824929, -122.455129844261) | 9 | 7 | 4 | 28861 | 40 | |||
| 184373 | 207298 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 111 Valdez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996286.51947 | 2094316.70178 | 37.7303818767138 | -122.455155653911 | (37.7303818767138, -122.455155653911) | 9 | 7 | 4 | 28861 | 40 | |||
| 25723 | 40627 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1118 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/21/1999 12:00:00 AM | 7 | Permit Number 41628 | 6012181.11201 | 2103196.50544 | 37.755663016446 | -122.40082910469 | (37.755663016446, -122.40082910469) | 10 | 3 | 8 | 28856 | 29 | ||
| 6887 | 129495 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1136 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 7ft | 6007480.35855 | 2119354.0245 | 37.7997643702969 | -122.418231335218 | (37.7997643702969, -122.418231335218) | 5 | 1 | 1 | 28858 | 32 | |||
| 56051 | 207337 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 114 Melrose Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999331.40158 | 2095537.84421 | 37.7339090681372 | -122.444716847019 | (37.7339090681372, -122.444716847019) | 9 | 7 | 4 | 59 | 40 | |||
| 63729 | 207336 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 114 Melrose Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999335.46736 | 2095537.54616 | 37.7339084817781 | -122.444702769016 | (37.7339084817781, -122.444702769016) | 9 | 7 | 4 | 59 | 40 | |||
| 119722 | 207335 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 114 Melrose Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 5999338.03809 | 2095537.49274 | 37.7339084817987 | -122.444693877414 | (37.7339084817987, -122.444693877414) | 9 | 7 | 4 | 59 | 40 | |||
| 38311 | 226584 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 116 Franconia St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6010066.87681 | 2099747.40872 | 37.7460744052137 | -122.407897622203 | (37.7460744052137, -122.407897622203) | 2 | 7 | 7 | 28859 | 2 | ||||
| 130544 | 207229 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1162 Capitol Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 1ft | 5995089.68407 | 2091648.00851 | 37.7229855509323 | -122.459100089412 | (37.7229855509323, -122.459100089412) | 9 | 8 | 4 | 28861 | 24 | |||
| 41930 | 32472 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 117 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/10/1996 12:00:00 AM | 5 | Permit Number 36980 | 6000335.64895 | 2106187.47018 | 37.7632076377424 | -122.442009017113 | (37.7632076377424, -122.442009017113) | 15 | 5 | 5 | 28862 | 3 | |
| 94651 | 226603 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 12 Worth St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 3 | Width 4ft | 6000852.5389 | 2103221.37405 | 37.755092904721 | -122.440008578658 | (37.755092904721, -122.440008578658) | 2 | 4 | 5 | 28862 | 22 | |||
| 150117 | 191409 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 20th St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014316.15581 | 2104772.8809 | 37.7601102601985 | -122.39355571262 | (37.7601102601985, -122.39355571262) | 10 | 3 | 8 | 28856 | 29 | |||
| 46719 | 227702 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 San Jose Ave | 44 | Front Yard : Yard | Tree | Private 2 | 1 | 6004467.63219 | 2096063.70987 | 37.7356447417011 | -122.426996770882 | (37.7356447417011, -122.426996770882) | 2 | 7 | 5 | 28861 | 2 | ||||
| 142466 | 227701 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1201 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 1 | 6004423.64254 | 2096032.0928 | 37.7355554408308 | -122.427146608748 | (37.7355554408308, -122.427146608748) | 2 | 7 | 5 | 28861 | 2 | ||||
| 77620 | 207148 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1210 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 4ft | 5992391.03537 | 2107185.15973 | 37.7654910946525 | -122.469559175111 | (37.7654910946525, -122.469559175111) | 11 | 8 | 11 | 56 | 12 | |||
| 148804 | 31932 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1210 47th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/26/1995 12:00:00 AM | 7 | Permit Number 35348 | 5981508.8658 | 2106816.8909 | 37.7638449985622 | -122.507170151225 | (37.7638449985622, -122.507170151225) | 1 | 8 | 3 | 56 | 35 | |
| 180196 | 183715 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1226 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5983995.5254 | 2106803.3357 | 37.7639539248956 | -122.498568682419 | (37.7639539248956, -122.498568682419) | 1 | 8 | 3 | 56 | 35 | |||
| 78155 | 226578 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 124 Grattan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5998059.22981 | 2106534.17954 | 37.7640296270922 | -122.449907345362 | (37.7640296270922, -122.449907345362) | 15 | 5 | 11 | 29492 | 9 | |||
| 120383 | 207221 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 125 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 5999184.61823 | 2093461.48115 | 37.7281994846941 | -122.445075098264 | (37.7281994846941, -122.445075098264) | 9 | 7 | 4 | 28861 | 40 | ||||
| 110343 | 177027 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 127 Naples St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6004458.22384 | 2092761.54245 | 37.7265771958662 | -122.426794207588 | (37.7265771958662, -122.426794207588) | 9 | 7 | 6 | 28861 | 5 | |||
| 126928 | 183296 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1278 42nd Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 0ft | 5983073.0612 | 2106475.4841 | 37.7629995961897 | -122.501734901298 | (37.7629995961897, -122.501734901298) | 1 | 8 | 3 | 56 | 35 | |||
| 190252 | 24745 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 128X Point Lobos Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982364.70681 | 2112649.87562 | 37.7799110512252 | -122.504642314845 | (37.7799110512252, -122.504642314845) | 11 | 6 | 2 | 55 | 26 | ||
| 185376 | 249979 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 13 Napier Ln | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 0ft | 6011649.02488 | 2120183.73487 | 37.802276317051 | -122.403864545927 | (37.802276317051, -122.403864545927) | 3 | 1 | 10 | 308 | 23 | |||
| 188823 | 176997 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 131 Farragut Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 6ft | 5997268.75573 | 2087384.80149 | 37.7114048037631 | -122.451260209013 | (37.7114048037631, -122.451260209013) | 9 | 7 | 6 | 28861 | 25 | |||
| 34253 | 185771 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1325 Ortega St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5989890.4756 | 2102411.1303 | 37.7522380517247 | -122.477858926104 | (37.7522380517247, -122.477858926104) | 1 | 8 | 3 | 29491 | 35 | |||
| 138637 | 185770 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1325 Ortega St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 0ft | 5989884.1917 | 2102410.6066 | 37.7522362490762 | -122.477880618296 | (37.7522362490762, -122.477880618296) | 1 | 8 | 3 | 29491 | 35 | |||
| 166326 | 108497 | Permitted Site 7 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1339 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773641 | 5992378.78756 | 2106335.85187 | 37.7631584124216 | -122.469539706221 | (37.7631584124216, -122.469539706221) | 1 | 8 | 11 | 56 | 12 |
| 38178 | 207147 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1341 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5992375.35662 | 2106303.37048 | 37.7630690288235 | -122.469549207953 | (37.7630690288235, -122.469549207953) | 1 | 8 | 11 | 56 | 12 | |||
| 59545 | 207291 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 135 Pinehurst Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5993593.95913 | 2093848.07579 | 37.7289402994475 | -122.464430125662 | (37.7289402994475, -122.464430125662) | 9 | 8 | 4 | 59 | 40 | |||
| 52929 | 50406 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1361 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/2003 12:00:00 AM | 4 | Permit Number 47058 | 5981810.1658 | 2105846.3225 | 37.7611978374436 | -122.506056096797 | (37.7611978374436, -122.506056096797) | 1 | 8 | 3 | 56 | 35 | |
| 185494 | 207223 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 137 Marston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998550.7404 | 2093191.23092 | 37.7274212410962 | -122.447246987057 | (37.7274212410962, -122.447246987057) | 9 | 7 | 4 | 28861 | 40 | |||
| 129474 | 207332 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 139 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 10ft | 6000483.56606 | 2095198.09344 | 37.7330418734682 | -122.44070911276 | (37.7330418734682, -122.44070911276) | 9 | 7 | 5 | 63 | 40 | |||
| 74725 | 129494 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 14 Havens St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6007592.27134 | 2119390.32661 | 37.7998703454969 | -122.417846649312 | (37.7998703454969, -122.417846649312) | 5 | 1 | 1 | 28858 | 32 | ||||
| 146038 | 116713 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1400 Baker St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | 3x3 | 6000212.5605 | 2113848.1665 | 37.7842349565382 | -122.442984912867 | (37.7842349565382, -122.442984912867) | 15 | 6 | 11 | 29490 | 13 | |||
| 167243 | 116712 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1400 Baker St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6000214.6483 | 2113835.6397 | 37.7842006802156 | -122.44297678994 | (37.7842006802156, -122.44297678994) | 15 | 6 | 11 | 29490 | 13 | |||
| 22370 | 226631 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 141 Moffitt St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6002644.82708 | 2096800.89378 | 37.7375656387439 | -122.433351563933 | (37.7375656387439, -122.433351563933) | 2 | 7 | 5 | 63 | 7 | |||
| 33828 | 207294 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1414 Plymouth Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 3ft | 5995890.40227 | 2093395.38912 | 37.7278294397631 | -122.456458481978 | (37.7278294397631, -122.456458481978) | 9 | 7 | 4 | 28861 | 40 | |||
| 99383 | 207145 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1418 14th Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 5ft | 5991828.31268 | 2105750.01462 | 37.7615180292623 | -122.471400907553 | (37.7615180292623, -122.471400907553) | 1 | 8 | 4 | 56 | 12 | |||
| 36234 | 207142 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1419 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5991123.51551 | 2105737.38087 | 37.7614425437634 | -122.473837564856 | (37.7614425437634, -122.473837564856) | 1 | 8 | 4 | 56 | 12 | |||
| 5146 | 37433 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1419 Cabrillo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/1998 12:00:00 AM | 6 | Permit Number 39907 | 5991189.91551 | 2110613.34906 | 37.7748344845766 | -122.473963672883 | (37.7748344845766, -122.473963672883) | 11 | 6 | 2 | 54 | 26 | ||
| 171943 | 207220 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 143 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5999153.87241 | 2093460.82982 | 37.7281959413875 | -122.445181340549 | (37.7281959413875, -122.445181340549) | 9 | 7 | 4 | 28861 | 40 | ||||
| 2759 | 207270 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1439 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994256.24514 | 2105719.06013 | 37.7615731891695 | -122.463001505824 | (37.7615731891695, -122.463001505824) | 1 | 5 | 11 | 56 | 12 | |||
| 96366 | 207146 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1440 16th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 4ft | 5991174.2447 | 2105585.99091 | 37.7610298052998 | -122.473651071566 | (37.7610298052998, -122.473651071566) | 1 | 8 | 4 | 56 | 12 | |||
| 40625 | 207300 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 145 Hazelwood Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5996448.99813 | 2094535.96368 | 37.7309932376391 | -122.454609779812 | (37.7309932376391, -122.454609779812) | 9 | 7 | 4 | 28861 | 40 | |||
| 178002 | 207301 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 145 Hazelwood Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5996452.48883 | 2094524.36789 | 37.7309615985977 | -122.454596874545 | (37.7309615985977, -122.454596874545) | 9 | 7 | 4 | 28861 | 40 | |||
| 109938 | 207210 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 146 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5999095.98576 | 2093806.86087 | 37.7291427575169 | -122.445406326639 | (37.7291427575169, -122.445406326639) | 9 | 7 | 4 | 28861 | 40 | ||||
| 71830 | 226600 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1463 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003321.08221 | 2099703.03715 | 37.7455725970047 | -122.431220523219 | (37.7455725970047, -122.431220523219) | 2 | 7 | 5 | 63 | 22 | |||
| 30087 | 207222 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 147 Edna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 1ft | 5998739.60918 | 2093444.36182 | 37.728127069498 | -122.44661227435 | (37.728127069498, -122.44661227435) | 9 | 7 | 4 | 28861 | 40 | |||
| 66466 | 207218 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 147 Judson Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5999123.66307 | 2093458.31747 | 37.7281873186821 | -122.445285594449 | (37.7281873186821, -122.445285594449) | 9 | 7 | 4 | 28861 | 40 | ||||
| 123060 | 207219 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 147 Judson Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5999123.85922 | 2093459.79448 | 37.7281913854037 | -122.445285022505 | (37.7281913854037, -122.445285022505) | 9 | 7 | 4 | 28861 | 40 | ||||
| 132546 | 207269 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1477 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994263.39483 | 2105452.97226 | 37.7608429927301 | -122.462957472303 | (37.7608429927301, -122.462957472303) | 1 | 5 | 11 | 56 | 12 | |||
| 163221 | 183658 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1487 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981219.3285 | 2104945.928 | 37.7586908149842 | -122.508032687607 | (37.7586908149842, -122.508032687607) | 1 | 8 | 3 | 56 | 35 | |||
| 193119 | 183659 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1487 48th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5981220.5326 | 2104962.3842 | 37.7587360699481 | -122.508029744687 | (37.7587360699481, -122.508029744687) | 1 | 8 | 3 | 56 | 35 | |||
| 73127 | 207359 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 149 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 10ft | 5999079.15674 | 2093759.91373 | 37.7290128909307 | -122.445461131336 | (37.7290128909307, -122.445461131336) | 9 | 7 | 4 | 28861 | 40 | |||
| 2125 | 70374 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1494 42nd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 6 | 5983124.8306 | 2104978.8403 | 37.7588932768889 | -122.501445132559 | (37.7588932768889, -122.501445132559) | 1 | 8 | 3 | 56 | 35 | |||
| 112121 | 139036 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1501 BRODERICK ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000642.6462 | 2113889.2265 | 37.7843722084386 | -122.441499920001 | (37.7843722084386, -122.441499920001) | 15 | 6 | 11 | 29490 | 13 | |||
| 131002 | 139037 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1501 BRODERICK ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000646.8218 | 2113873.916 | 37.7843304076342 | -122.441484374883 | (37.7843304076342, -122.441484374883) | 15 | 6 | 11 | 29490 | 13 | |||
| 145099 | 139035 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1501 BRODERICK ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000637.7747 | 2113910.8003 | 37.7844311670031 | -122.441518322309 | (37.7844311670031, -122.441518322309) | 15 | 6 | 11 | 29490 | 13 | |||
| 189057 | 139038 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1501 BRODERICK ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000648.2136 | 2113864.1729 | 37.7843037348812 | -122.441478860369 | (37.7843037348812, -122.441478860369) | 15 | 6 | 11 | 29490 | 13 | |||
| 72087 | 226601 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1518 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003286.59929 | 2099387.77612 | 37.7447050093281 | -122.431317259697 | (37.7447050093281, -122.431317259697) | 2 | 7 | 5 | 63 | 22 | |||
| 110543 | 66621 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 153 25th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/15/1991 12:00:00 AM | 2 | Permit Number 29825 | 5988002.0511 | 2114993.09117 | 37.7866748512276 | -122.485312467165 | (37.7866748512276, -122.485312467165) | 11 | 6 | 1 | 55 | 33 | ||
| 123263 | 139033 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1535 BRODERICK ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000628.7276 | 2113990.1365 | 37.7846484883415 | -122.441555317265 | (37.7846484883415, -122.441555317265) | 15 | 6 | 11 | 29490 | 13 | |||
| 163204 | 139032 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1535 Broderick St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6000626.6398 | 2114005.447 | 37.784690408082 | -122.441563639416 | (37.784690408082, -122.441563639416) | 15 | 6 | 11 | 29490 | 13 | |||
| 181032 | 177021 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1538 Burrows St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | Width 4ft | 6006775.37088 | 2092172.25631 | 37.72508988269 | -122.41874212587 | (37.72508988269, -122.41874212587) | 9 | 7 | 7 | 309 | 5 | |||
| 191107 | 177001 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 154 Gillette Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6013011.29164 | 2086676.67622 | 37.7103492505861 | -122.396799956671 | (37.7103492505861, -122.396799956671) | 10 | 3 | 8 | 309 | 1 | |||
| 68131 | 227705 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1552 Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6005224.91638 | 2099272.18009 | 37.7444972677381 | -122.424606707457 | (37.7444972677381, -122.424606707457) | 2 | 7 | 5 | 63 | 22 | |||
| 147147 | 207163 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1557 07th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5993970.96623 | 2104931.68714 | 37.7593948306232 | -122.463931005519 | (37.7593948306232, -122.463931005519) | 1 | 5 | 4 | 56 | 12 | |||
| 55511 | 120286 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 157 24th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 5988329.9195 | 2114925.99705 | 37.786509724826 | -122.484173212945 | (37.786509724826, -122.484173212945) | 11 | 6 | 1 | 55 | 33 | ||||
| 136495 | 207314 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1570 07th Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994021.19813 | 2104903.51705 | 37.7593203775504 | -122.46375523572 | (37.7593203775504, -122.46375523572) | 1 | 5 | 4 | 56 | 12 | |||
| 184726 | 207315 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1570 07th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5994029.69886 | 2104725.63145 | 37.7588324395785 | -122.463712925326 | (37.7588324395785, -122.463712925326) | 1 | 5 | 4 | 56 | 12 | |||
| 146914 | 207143 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1617 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991127.14012 | 2104370.55559 | 37.7576898140615 | -122.473725315989 | (37.7576898140615, -122.473725315989) | 1 | 8 | 4 | 56 | 12 | |||
| 147958 | 207144 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1617 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 5991126.06401 | 2104353.71257 | 37.7576435052562 | -122.473727808906 | (37.7576435052562, -122.473727808906) | 1 | 8 | 4 | 56 | 12 | |||
| 78703 | 250091 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1620 Gough St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6005381.25743 | 2115289.65998 | 37.7884862737667 | -122.425205641527 | (37.7884862737667, -122.425205641527) | 13 | 9 | 1 | 28858 | 41 | |||
| 48168 | 177023 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1628 Burrows St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006643.54009 | 2092125.78314 | 37.7249548539585 | -122.419194556805 | (37.7249548539585, -122.419194556805) | 9 | 7 | 7 | 309 | 5 | |||
| 88643 | 177022 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1628 Burrows St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6006681.72637 | 2092138.27566 | 37.7249913061838 | -122.419063436538 | (37.7249913061838, -122.419063436538) | 9 | 7 | 7 | 309 | 5 | |||
| 177494 | 207282 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 163 Westwood Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5995118.51339 | 2093829.85755 | 37.7289780403896 | -122.459158347475 | (37.7289780403896, -122.459158347475) | 9 | 7 | 4 | 28861 | 40 | |||
| 40574 | 177028 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 164 Baltimore Way | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 6ft | 6002357.56159 | 2086195.52892 | 37.7084293823926 | -122.433587065817 | (37.7084293823926, -122.433587065817) | 9 | 7 | 6 | 28861 | 5 | |||
| 192217 | 41753 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1644 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/19/2000 12:00:00 AM | 4 | Permit Number 42182 | 6006856.27196 | 2116746.53055 | 37.7925696967985 | -122.420205749089 | (37.7925696967985, -122.420205749089) | 13 | 9 | 10 | 28858 | 32 | |
| 168108 | 207140 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 1682 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5990920.30999 | 2103955.39179 | 37.7565379030086 | -122.474410316087 | (37.7565379030086, -122.474410316087) | 1 | 8 | 4 | 56 | 12 | |||
| 113235 | 226630 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 17 Temple St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 6000001.75416 | 2105889.17936 | 37.7623695721306 | -122.443142420082 | (37.7623695721306, -122.443142420082) | 15 | 5 | 5 | 28862 | 3 | |||
| 9002 | 207358 | DPW Maintained 1 | Leptospermum scoparium :: New Zealand Tea Tree 157 | 171 Staples Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5998941.87178 | 2093762.17883 | 37.7290112721346 | -122.445935896945 | (37.7290112721346, -122.445935896945) | 9 | 7 | 4 | 28861 | 40 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );