trees
3,267 rows where qSpecies_id = 67 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 88838 | 54479 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 108 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 9 | Permit Number 10271 | 6012495.87675 | 2095234.91266 | 37.7338197321998 | -122.399181702273 | (37.7338197321998, -122.399181702273) | 10 | 3 | 8 | 58 | 1 | ||
| 164554 | 188871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1081 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6012231.21273 | 2103354.37093 | 37.7560992748753 | -122.400666929043 | (37.7560992748753, -122.400666929043) | 10 | 3 | 8 | 28856 | 29 | |||
| 60319 | 222160 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Fountain St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6000360.36109 | 2101597.05955 | 37.7506049001065 | -122.441594108599 | (37.7506049001065, -122.441594108599) | 2 | 4 | 5 | 28862 | 22 | |||
| 125540 | 54553 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.398188716748 | (37.7349720434069, -122.398188716748) | 10 | 3 | 8 | 58 | 1 | ||
| 20911 | 188282 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | 10 | 3 | 8 | 58 | 1 | |||
| 42689 | 188281 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 11 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6017931.86479 | 2094462.1595 | 37.7319993514708 | -122.380333977027 | (37.7319993514708, -122.380333977027) | 10 | 3 | 8 | 58 | 1 | |||
| 110392 | 205733 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 110 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5993382.37885 | 2094831.43589 | 37.7316281652932 | -122.465232966631 | (37.7316281652932, -122.465232966631) | 9 | 8 | 4 | 59 | 40 | |||
| 52176 | 222350 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1100 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6003152.94655 | 2101762.46438 | 37.7512177718843 | -122.431948938994 | (37.7512177718843, -122.431948938994) | 2 | 4 | 5 | 28862 | 22 | |||
| 71686 | 43362 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1100X Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | 4 | 3x9 | Permit Number 43112 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) | 2 | 4 | 5 | 28862 | 22 |
| 69122 | 51863 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1105 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 48085 | 6002530.44355674 | 2102366.89187427 | 37.752842076313 | -122.434144824059 | (37.752842076313, -122.434144824059) | 2 | 4 | 5 | 28862 | 22 | ||||
| 41642 | 188868 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1106 De Haro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6012179.40591 | 2103244.12838 | 37.7557936834398 | -122.40083835062 | (37.7557936834398, -122.40083835062) | 10 | 3 | 8 | 28856 | 29 | |||
| 146646 | 188867 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1106 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6012179.64918 | 2103256.10379 | 37.7558265788599 | -122.40083835062 | (37.7558265788599, -122.40083835062) | 10 | 3 | 8 | 28856 | 29 | |||
| 104076 | 175633 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1108 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011834.59323 | 2089743.09488 | 37.7187034559781 | -122.401082217992 | (37.7187034559781, -122.401082217992) | 10 | 7 | 8 | 309 | 39 | |||
| 37261 | 204581 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 111 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5999358.22229 | 2095479.77537 | 37.7337511552818 | -122.444619947753 | (37.7337511552818, -122.444619947753) | 9 | 7 | 4 | 59 | 40 | |||
| 141737 | 205871 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 111 Monticello St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 6ft | 5991654.88774 | 2089307.44903 | 37.7163608911211 | -122.470802959995 | (37.7163608911211, -122.470802959995) | 9 | 8 | 6 | 64 | 24 | |||
| 54849 | 222349 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1111 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002538.00771 | 2102275.75195 | 37.7525922570527 | -122.434112151168 | (37.7525922570527, -122.434112151168) | 2 | 4 | 5 | 28862 | 22 | |||
| 132801 | 222348 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1111 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002538.51722 | 2102256.44198 | 37.7525392653814 | -122.434109008926 | (37.7525392653814, -122.434109008926) | 2 | 4 | 5 | 28862 | 22 | |||
| 49535 | 188849 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6010631.69356 | 2110389.62029 | 37.7753271309641 | -122.406694404849 | (37.7753271309641, -122.406694404849) | 8 | 2 | 9 | 28853 | 34 | |||
| 170806 | 188850 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1112 Harrison St | 2 | : | Tree | Private 2 | 12 | Width 3ft | 6010617.59281 | 2110376.13956 | 37.7752893270638 | -122.406742232588 | (37.7752893270638, -122.406742232588) | 8 | 2 | 9 | 28853 | 34 | |||
| 63512 | 222347 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1115 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002540.8587 | 2102223.22289 | 37.7524481865431 | -122.434098537223 | (37.7524481865431, -122.434098537223) | 2 | 4 | 5 | 28862 | 22 | |||
| 177709 | 42671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.92747 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | 5 | 1 | 1 | 28858 | 32 | |
| 21777 | 66859 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | 1 | 8 | 3 | 29491 | 35 | ||
| 43442 | 205675 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Ortega St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 5990487.22136 | 2102483.87825 | 37.7524724142928 | -122.47580061943 | (37.7524724142928, -122.47580061943) | 1 | 8 | 4 | 56 | 12 | |||
| 45082 | 205673 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Ortega St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 5990453.79637 | 2102486.41595 | 37.7524774441927 | -122.475916392748 | (37.7524774441927, -122.475916392748) | 1 | 8 | 4 | 56 | 12 | |||
| 167068 | 205674 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Ortega St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 5990467.03481 | 2102486.1364 | 37.7524774441906 | -122.475870592067 | (37.7524774441906, -122.475870592067) | 1 | 8 | 4 | 56 | 12 | |||
| 23402 | 105461 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 55032 | 105463 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 147202 | 105462 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 153864 | 105459 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 166132 | 105460 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 WALLER ST | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.7696231224597 | -122.443262808274 | (37.7696231224597, -122.443262808274) | 15 | 5 | 11 | 29492 | 9 | |||
| 13010 | 247253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.7695922091358 | -122.443239243804 | (37.7695922091358, -122.443239243804) | 15 | 5 | 11 | 29492 | 9 | |||
| 43012 | 247519 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 5 | : | Tree | Private 2 | 10 | Width 3ft | 6000008.96236 | 2108515.32213 | 37.7695807157979 | -122.443306122774 | (37.7695807157979, -122.443306122774) | 15 | 5 | 11 | 29492 | 9 | |||
| 47223 | 247252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 2 | : | Tree | Private 2 | 8 | Width 3ft | 6000037.64512 | 2108520.16776 | 37.7695956562448 | -122.443207258529 | (37.7695956562448, -122.443207258529) | 15 | 5 | 11 | 29492 | 9 | |||
| 79620 | 247251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 1 | : | Tree | Private 2 | 9 | Width 3ft | 6000047.76346 | 2108521.63198 | 37.7696002535789 | -122.443172364836 | (37.7696002535789, -122.443172364836) | 15 | 5 | 11 | 29492 | 9 | |||
| 124354 | 247254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1118 Waller St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6000018.05631 | 2108518.06338 | 37.7695887611508 | -122.443274864147 | (37.7695887611508, -122.443274864147) | 15 | 5 | 11 | 29492 | 9 | |||
| 186467 | 48734 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | 15 | 5 | 5 | 28862 | 3 | |||
| 172932 | 222478 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6001753.94319 | 2096593.95124 | 37.7369468404176 | -122.436416959794 | (37.7369468404176, -122.436416959794) | 2 | 7 | 5 | 63 | 7 | |||
| 70387 | 205817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5998664.62429 | 2093222.76421 | 37.7275143308076 | -122.446855559853 | (37.7275143308076, -122.446855559853) | 9 | 7 | 4 | 28861 | 40 | ||||
| 76256 | 205815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998671.29704 | 2093222.7898 | 37.7275147822741 | -122.446832494046 | (37.7275147822741, -122.446832494046) | 9 | 7 | 4 | 28861 | 40 | ||||
| 188353 | 205816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 112 Marston Ave | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 5998668.99118 | 2093222.65534 | 37.7275142813492 | -122.446840455715 | (37.7275142813492, -122.446840455715) | 9 | 7 | 4 | 28861 | 40 | ||||
| 166750 | 205775 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1123 Bosworth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 1ft | 6000939.14491 | 2095727.15465 | 37.7345204866211 | -122.439171966334 | (37.7345204866211, -122.439171966334) | 9 | 7 | 5 | 63 | 40 | |||
| 123161 | 175697 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1138 Bacon St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 2ft | 6008123.31948 | 2092096.90182 | 37.7249587777237 | -122.414077067227 | (37.7249587777237, -122.414077067227) | 9 | 3 | 7 | 309 | 28 | |||
| 151006 | 121972 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991188.53985 | 2114632.1143 | 37.78586882698 | -122.474261742007 | (37.78586882698, -122.474261742007) | 11 | 6 | 2 | 54 | 26 | |||
| 170777 | 222430 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6001045.5618 | 2105677.49861 | 37.7618478106457 | -122.439517110848 | (37.7618478106457, -122.439517110848) | 15 | 5 | 5 | 28862 | 3 | |||
| 45883 | 125838 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Leroy Pl | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008325.43827 | 2116645.82165 | 37.7923758470246 | -122.415115235581 | (37.7923758470246, -122.415115235581) | 5 | 1 | 10 | 28858 | 21 | |||
| 130865 | 125839 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Leroy Pl | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008323.23734 | 2116659.17104 | 37.7924123774867 | -122.415123796229 | (37.7924123774867, -122.415123796229) | 5 | 1 | 10 | 28858 | 21 | |||
| 138696 | 125840 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Leroy Pl | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6008320.5619 | 2116673.51568 | 37.7924516139938 | -122.415134069189 | (37.7924516139938, -122.415134069189) | 5 | 1 | 10 | 28858 | 21 | |||
| 148411 | 125841 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Leroy Pl | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6008319.99153 | 2116681.90431 | 37.7924746150586 | -122.415136636746 | (37.7924746150586, -122.415136636746) | 5 | 1 | 10 | 28858 | 21 | |||
| 168757 | 125837 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 114 Leroy Pl | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6008328.08599 | 2116630.12257 | 37.7923328899977 | -122.415104962639 | (37.7923328899977, -122.415104962639) | 5 | 1 | 10 | 28858 | 21 | |||
| 187196 | 125857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1148 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007410.78308 | 2119548.4108 | 37.8002941896961 | -122.418485883829 | (37.8002941896961, -122.418485883829) | 5 | 1 | 1 | 28858 | 32 | |||
| 171601 | 222246 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1149 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 5997700.29974 | 2106538.60043 | 37.7640212220263 | -122.451149091478 | (37.7640212220263, -122.451149091478) | 15 | 5 | 11 | 29492 | 9 | |||
| 154744 | 66170 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/05/1990 12:00:00 AM | Permit Number 29242 | 6009342.82621351 | 2096790.80066071 | 37.7379156423933 | -122.41019259909 | (37.7379156423933, -122.41019259909) | 10 | 7 | 7 | 28859 | 2 | ||
| 93728 | 204580 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 115 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5999331.38497 | 2095480.98556 | 37.7337529467263 | -122.444712818957 | (37.7337529467263, -122.444712818957) | 9 | 7 | 4 | 59 | 40 | |||
| 151221 | 42471 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 115 Melrose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2000 12:00:00 AM | Permit Number 42613 | 5999341.906982 | 2095474.8798527 | 37.7337367823313 | -122.444676002661 | (37.7337367823313, -122.444676002661) | 9 | 7 | 4 | 59 | 40 | ||
| 8725 | 60817 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1150 Quintara St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/28/1983 12:00:00 AM | 3 | Permit Number 20495 | 5989806.3915 | 2101102.4889 | 37.7486399870467 | -122.478054033081 | (37.7486399870467, -122.478054033081) | 1 | 8 | 3 | 29491 | 35 | |
| 105393 | 183608 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1150 Quintara St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5989802.0405 | 2101102.8236 | 37.7486406534958 | -122.478069103094 | (37.7486406534958, -122.478069103094) | 1 | 8 | 3 | 29491 | 35 | |||
| 155482 | 183609 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1150 Quintara St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 0ft | 5989796.6853 | 2101103.1583 | 37.7486412616545 | -122.478087645581 | (37.7486412616545, -122.478087645581) | 1 | 8 | 3 | 29491 | 35 | |||
| 162129 | 222346 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002547.76398 | 2102147.08874 | 37.7522395321526 | -122.434069215723 | (37.7522395321526, -122.434069215723) | 2 | 4 | 5 | 28862 | 22 | |||
| 21349 | 200220 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6014047.4712 | 2090254.411 | 37.7202306272165 | -122.393468896776 | (37.7202306272165, -122.393468896776) | 10 | 3 | 8 | 58 | 1 | |||
| 16704 | 30848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1153 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/16/1995 12:00:00 AM | 14 | Permit Number 34697 | 6002549.89906 | 2102133.17334 | 37.7522014449412 | -122.434060837652 | (37.7522014449412, -122.434060837652) | 2 | 4 | 5 | 28862 | 22 | |
| 168413 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6011908.79849 | 2103025.72201 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | 10 | 3 | 8 | 28856 | 29 | |||
| 38162 | 222321 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009455.13668 | 2102439.70905 | 37.7534325970537 | -122.410202998284 | (37.7534325970537, -122.410202998284) | 2 | 4 | 7 | 28859 | 19 | |||
| 62485 | 65261 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/26/1989 12:00:00 AM | Permit Number 28060 | 6009449.44831989 | 2102437.73284005 | 37.7534268519722 | -122.410222530405 | (37.7534268519722, -122.410222530405) | 2 | 4 | 7 | 28859 | 19 | ||
| 112326 | 125848 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1156 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6008008.91714 | 2118589.10669 | 37.7976938341652 | -122.416348113498 | (37.7976938341652, -122.416348113498) | 5 | 1 | 10 | 28858 | 21 | |||
| 124289 | 222400 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Caselli Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 5ft | 6000348.37213 | 2104909.38661 | 37.759699060486 | -122.441873275228 | (37.759699060486, -122.441873275228) | 2 | 4 | 5 | 28862 | 3 | |||
| 35656 | 205826 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Jules Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5994471.11499 | 2090695.81427 | 37.7203354745885 | -122.461169353905 | (37.7203354745885, -122.461169353905) | 9 | 8 | 6 | 28861 | 24 | |||
| 87988 | 205827 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Jules Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5994470.95616 | 2090706.48365 | 37.7203647610097 | -122.461170675902 | (37.7203647610097, -122.461170675902) | 9 | 8 | 6 | 28861 | 24 | |||
| 92246 | 175638 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Schwerin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008956.41307 | 2087314.52628 | 37.7118741275743 | -122.410859536636 | (37.7118741275743, -122.410859536636) | 9 | 7 | 8 | 309 | 39 | |||
| 153680 | 175675 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Vienna St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 4ft | 6004698.05977 | 2092737.85191 | 37.7265257042768 | -122.425963417494 | (37.7265257042768, -122.425963417494) | 9 | 7 | 6 | 28861 | 5 | |||
| 188991 | 175674 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 116 Vienna St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 4ft | 6004710.86363 | 2092757.34918 | 37.7265799630845 | -122.4259205423 | (37.7265799630845, -122.4259205423) | 9 | 7 | 6 | 28861 | 5 | |||
| 186704 | 44402 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1162 Munich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/23/2001 12:00:00 AM | 7 | Permit Number 43756 | 6001306.88514 | 2087104.50261 | 37.7108655531865 | -122.437283363033 | (37.7108655531865, -122.437283363033) | 9 | 7 | 6 | 28861 | 5 | |
| 93132 | 188869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1164 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6012189.44152 | 2103014.30234 | 37.7551631912308 | -122.400787498439 | (37.7551631912308, -122.400787498439) | 10 | 3 | 8 | 28856 | 29 | |||
| 97875 | 220842 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 117 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6010257.61368 | 2100212.62196 | 37.7473624556225 | -122.407270864857 | (37.7473624556225, -122.407270864857) | 2 | 7 | 7 | 28859 | 2 | |||
| 41349 | 43584 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/20/2000 12:00:00 AM | Permit Number 43245 | 6005148.55344947 | 2099289.0817491 | 37.7445393628941 | -122.424871957382 | (37.7445393628941, -122.424871957382) | 2 | 7 | 5 | 63 | 22 | ||
| 141001 | 10874 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 170151 | 10875 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/03/1991 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | ||
| 183819 | 10880 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 188377 | 10883 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.7329900490522 | -122.381698823278 | (37.7329900490522, -122.381698823278) | 10 | 3 | 8 | 58 | 1 | |||
| 136736 | 175637 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011646.28852 | 2089340.42458 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | 10 | 7 | 8 | 309 | 39 | |||
| 101506 | 69213 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/31/1994 12:00:00 AM | Permit Number 33264 | 6008095.60945385 | 2101082.12715709 | 37.7496286841094 | -122.414808474137 | (37.7496286841094, -122.414808474137) | 2 | 4 | 7 | 28859 | 19 | ||
| 117528 | 220945 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6008084.12741 | 2101107.52625 | 37.7496977791506 | -122.414849976942 | (37.7496977791506, -122.414849976942) | 2 | 4 | 7 | 28859 | 19 | |||
| 184574 | 205869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 118 Lakeview Ave | 1 | : | Tree | Private 2 | 6 | Width 3ft | 5997252.76199 | 2089357.29362 | 37.7168198961062 | -122.451457665965 | (37.7168198961062, -122.451457665965) | 9 | 8 | 6 | 28861 | 24 | |||
| 156976 | 217683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 118 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5992809.5901 | 2097716.9477 | 37.7395180108806 | -122.467422941938 | (37.7395180108806, -122.467422941938) | 1 | 8 | 4 | 59 | 40 | |||
| 60678 | 175733 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1183 Munich St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 6001131.65449 | 2087116.65406 | 37.710888955334 | -122.437889869445 | (37.710888955334, -122.437889869445) | 9 | 7 | 6 | 28861 | 5 | |||
| 47646 | 222316 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1184 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009203.66279 | 2102279.76779 | 37.752979335133 | -122.411061355306 | (37.752979335133, -122.411061355306) | 2 | 4 | 7 | 28859 | 19 | |||
| 80275 | 222317 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1184 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6009203.64315 | 2102300.55451 | 37.7530364097089 | -122.411062891358 | (37.7530364097089, -122.411062891358) | 2 | 4 | 7 | 28859 | 19 | |||
| 147209 | 55323 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | 10 | 7 | 8 | 309 | 39 | ||
| 75551 | 116703 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 119 Trumbull St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6004176.22677 | 2094340.06252 | 37.7308955119201 | -122.427881490641 | (37.7308955119201, -122.427881490641) | 9 | 7 | 6 | 28861 | 5 | ||||
| 149258 | 220992 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1192 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001929.17496 | 2100648.95659 | 37.7480908911891 | -122.436101194336 | (37.7480908911891, -122.436101194336) | 2 | 4 | 5 | 28862 | 22 | |||
| 185615 | 125836 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Golden Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 5ft | 6008214.16509 | 2116540.37994 | 37.7920800761809 | -122.415492776366 | (37.7920800761809, -122.415492776366) | 5 | 1 | 10 | 28858 | 21 | |||
| 73254 | 106702 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 HILL ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 5x5 | 6006261.1 | 2103486.1 | 37.756126192255 | -122.421322975472 | (37.756126192255, -122.421322975472) | 2 | 4 | 5 | 28859 | 19 | |||
| 74003 | 220964 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Hill St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006167.77637 | 2103486.22095 | 37.7561212624045 | -122.421645729193 | (37.7561212624045, -122.421645729193) | 2 | 4 | 5 | 28859 | 19 | |||
| 189356 | 220965 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006182.97124 | 2103487.11814 | 37.7561245826867 | -122.421593243841 | (37.7561245826867, -122.421593243841) | 2 | 4 | 5 | 28859 | 19 | |||
| 99472 | 188278 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6017724.20983 | 2094242.07575 | 37.7313835847835 | -122.381036596687 | (37.7313835847835, -122.381036596687) | 10 | 3 | 8 | 58 | 1 | |||
| 135531 | 188279 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6017754.54552 | 2094265.39597 | 37.7314492919381 | -122.380933340095 | (37.7314492919381, -122.380933340095) | 10 | 3 | 8 | 58 | 1 | |||
| 156418 | 188280 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 12 Lillian St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017796.93346 | 2094324.7108 | 37.7316144983135 | -122.380790917192 | (37.7316144983135, -122.380790917192) | 10 | 3 | 8 | 58 | 1 | |||
| 172422 | 220869 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Alma St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 5998060.25576 | 2106223.73939 | 37.7631772955295 | -122.44988142239 | (37.7631772955295, -122.44988142239) | 15 | 5 | 11 | 29492 | 9 | |||
| 115972 | 222479 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001753.48392 | 2096571.75813 | 37.7368858771861 | -122.436416959778 | (37.7368858771861, -122.436416959778) | 2 | 7 | 5 | 63 | 7 | |||
| 184589 | 204508 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 3ft | 5995837.30654 | 2096190.27976 | 37.7355004850657 | -122.456844092381 | (37.7355004850657, -122.456844092381) | 9 | 7 | 4 | 59 | 40 | |||
| 124525 | 175593 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 120 Farragut Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5997391.38544 | 2087332.13149 | 37.7112672047814 | -122.450832575961 | (37.7112672047814, -122.450832575961) | 9 | 7 | 6 | 28861 | 25 |
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) );