Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▲ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 111626 | 111626 | 18789 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018114.760056 | 2094395.2295851002 | 37.7318256648951 | -122.379697013742 | (37.7318256648951, -122.379697013742) | |||
| 23034 | 23034 | 4896 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.5453599999 | 37.731812362636205 | -122.37972428526699 | (37.7318123626362, -122.379724285267) | ||
| 16623 | 16623 | 4897 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018099.28954 | 2094405.0263599998 | 37.731851711585996 | -122.37975117949 | (37.731851711586, -122.37975117949) | |||
| 150679 | 150679 | 188268 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 75 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6018091.56 | 2094271.94508 | 37.731485870056794 | -122.379768659608 | (37.7314858700568, -122.379768659608) | |||
| 169436 | 169436 | 188282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | |||
| 186015 | 186015 | 188266 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 9 Navy Rd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6018074.33224 | 2093577.4379099999 | 37.7295779385535 | -122.379779984755 | (37.7295779385535, -122.379779984755) | |||
| 93259 | 93259 | 1875 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6018011.4321332 | 2094063.1260405 | 37.7309080736078 | -122.380031174991 | (37.7309080736078, -122.380031174991) | |||
| 13724 | 13724 | 4898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | |||
| 107304 | 107304 | 6392 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Espanola St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017974.4315502 | 2094113.8790238 | 37.7310453900638 | -122.380162619042 | (37.7310453900638, -122.380162619042) | |||
| 151181 | 151181 | 188277 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017947.7669400005 | 2094045.54207 | 37.7308562789814 | -122.380250056804 | (37.7308562789814, -122.380250056804) | |||
| 156788 | 156788 | 188281 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017931.86479 | 2094462.1595 | 37.7319993514708 | -122.380333977027 | (37.7319993514708, -122.380333977027) | |||
| 92349 | 92349 | 18800 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017918.7507593 | 2094507.5509584 | 37.732123263915 | -122.380382469104 | (37.732123263915, -122.380382469104) | |||
| 173403 | 173403 | 188276 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017913.92599 | 2094045.4475 | 37.7308541521008 | -122.38036704510901 | (37.7308541521008, -122.380367045109) | |||
| 77478 | 77478 | 1883 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 31 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017903.7063488 | 2094083.9229994998 | 37.7309592343941 | -122.38040504951401 | (37.7309592343941, -122.380405049514) | |||
| 132195 | 132195 | 188269 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017903.32503 | 2094505.0176099997 | 37.7321154566611 | -122.380435623808 | (37.7321154566611, -122.380435623808) | |||
| 104491 | 104491 | 18806 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 6017853.002840099 | 2094472.3604 | 37.73202300947629 | -122.380607331399 | (37.7320230094763, -122.380607331399) | |||
| 114616 | 114616 | 18805 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 54 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017853.002840099 | 2094472.3604 | 37.73202300947629 | -122.380607331399 | (37.7320230094763, -122.380607331399) | |||
| 57326 | 57326 | 188275 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6017837.50464 | 2094055.5042299998 | 37.7308775488575 | -122.380631947623 | (37.7308775488575, -122.380631947623) | |||
| 117399 | 117399 | 1885 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | |||
| 120586 | 120586 | 1887 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | |||
| 139305 | 139305 | 1886 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017815.3331022 | 2094109.8571584 | 37.7310255677831 | -122.380712375821 | (37.7310255677831, -122.380712375821) | |||
| 76612 | 76612 | 188280 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017796.93346 | 2094324.7108 | 37.7316144983135 | -122.380790917192 | (37.7316144983135, -122.380790917192) | |||
| 173409 | 173409 | 188274 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6017787.78599 | 2094078.1936 | 37.73093710554829 | -122.38080541156499 | (37.7309371055483, -122.380805411565) | |||
| 90340 | 90340 | 1879 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45X Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/2003 12:00:00 AM | 12 | 3X4 | 6017774.309034999 | 2094355.975399 | 37.731699096095205 | -122.380871307769 | (37.7316990960952, -122.380871307769) | ||
| 112165 | 112165 | 1881 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 45X Lillian St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6017774.309034999 | 2094355.975399 | 37.731699096095205 | -122.380871307769 | (37.7316990960952, -122.380871307769) | |||
| 121358 | 121358 | 1890 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 50 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X4 | 6017765.907514 | 2094082.2550293999 | 37.730947049926705 | -122.380881332108 | (37.7309470499267, -122.380881332108) | |||
| 174367 | 174367 | 188273 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017757.59248 | 2094104.7507200001 | 37.7310083597514 | -122.380911642168 | (37.7310083597514, -122.380911642168) | |||
| 29710 | 29710 | 188279 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017754.54552 | 2094265.3959700002 | 37.7314492919381 | -122.380933340095 | (37.7314492919381, -122.380933340095) | |||
| 100999 | 100999 | 18812 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 90 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017743.9455674 | 2094518.0196352 | 37.732142361857704 | -122.380987543086 | (37.7321423618577, -122.380987543086) | |||
| 170266 | 170266 | 188270 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017725.6269 | 2094584.88968 | 37.7323249627215 | -122.381055522912 | (37.7323249627215, -122.381055522912) | |||
| 131987 | 131987 | 188278 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017724.20983 | 2094242.07575 | 37.7313835847835 | -122.381036596687 | (37.7313835847835, -122.381036596687) | |||
| 18712 | 18712 | 10788 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 51550 | 51550 | 10783 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 124174 | 124174 | 10789 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200X Hudson Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x4 | 6017715.991199099 | 2094753.0263542 | 37.7327861010711 | -122.381100521913 | (37.7327861010711, -122.381100521913) | |||
| 145848 | 145848 | 1894 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 79 Beatrice Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017701.0374377 | 2094273.2748058997 | 37.7314679721847 | -122.381118877186 | (37.7314679721847, -122.381118877186) | |||
| 74495 | 74495 | 188272 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017665.18673 | 2094248.3668099998 | 37.7313976007006 | -122.381241089926 | (37.7313976007006, -122.381241089926) | |||
| 23289 | 23289 | 1876 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017644.79908 | 2094278.9873799998 | 37.731480553283795 | -122.381313702976 | (37.7314805532838, -122.381313702976) | |||
| 115809 | 115809 | 1898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 95 Beatrice Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6017638.107152401 | 2094354.0127633999 | 37.73168618881321 | -122.38134205350401 | (37.7316861888132, -122.381342053504) | |||
| 141879 | 141879 | 1899 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 95 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017638.107152401 | 2094354.0127633999 | 37.73168618881321 | -122.38134205350401 | (37.7316861888132, -122.381342053504) | |||
| 134730 | 134730 | 188271 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 15 Beatrice Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017623.688490001 | 2094312.3334299999 | 37.731570949541705 | -122.381389005013 | (37.7315709495417, -122.381389005013) | |||
| 112115 | 112115 | 10874 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 123132 | 123132 | 10875 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1991 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
| 139639 | 139639 | 10880 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 142103 | 142103 | 10883 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
| 94125 | 94125 | 10850 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017356.4574634 | 2095156.0177673001 | 37.7338727832056 | -122.382371560842 | (37.7338727832056, -122.382371560842) | |||
| 15035 | 15035 | 108029 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1308 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6017326.2062 | 2092992.2495 | 37.727929830314295 | -122.382325662572 | (37.7279298303143, -122.382325662572) | |||
| 159084 | 159084 | 188262 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Hudson Ave | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017323.3407 | 2095203.1701099998 | 37.7340004248815 | -122.38248933632 | (37.7340004248815, -122.38248933632) | |||
| 65832 | 65832 | 188261 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1339 Hudson Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6017310.47324 | 2095140.94746 | 37.7338288630114 | -122.382529495567 | (37.7338288630114, -122.382529495567) | |||
| 71140 | 71140 | 199908 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1216 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6017309.9205 | 2093127.3901 | 37.7283000004206 | -122.38239136164302 | (37.7283000004206, -122.382391361643) | |||
| 137007 | 137007 | 188260 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1339 Hudson Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017298.63225 | 2095158.3595200002 | 37.7338760189594 | -122.38257164497699 | (37.7338760189594, -122.382571644977) | |||
| 167184 | 167184 | 188259 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1339 Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017275.09944 | 2095200.58275 | 37.733990655538605 | -122.38265594291599 | (37.7339906555386, -122.382655942916) | |||
| 185560 | 185560 | 188263 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Hudson Ave | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017270.30063 | 2095300.86237 | 37.7342657383686 | -122.382679509676 | (37.7342657383686, -122.382679509676) | |||
| 80380 | 80380 | 10885 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1270X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/01/1997 12:00:00 AM | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 90366 | 90366 | 10893 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1270X Hudson Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | |||
| 111747 | 111747 | 10892 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1270X Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | |||
| 114441 | 114441 | 10886 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1270X Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/16/1999 12:00:00 AM | 6 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | ||
| 143778 | 143778 | 10891 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1270X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017265.0162454005 | 2095327.7862917 | 37.734339374173004 | -122.382699652574 | (37.734339374173, -122.382699652574) | |||
| 46636 | 46636 | 188264 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1322 Hudson Ave | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017261.07145 | 2095318.2805299999 | 37.7343130553028 | -122.382712629894 | (37.7343130553028, -122.382712629894) | |||
| 73774 | 73774 | 122801 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1219 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6017253.657000001 | 2093097.6354 | 37.728215191839794 | -122.382583799411 | (37.7282151918398, -122.382583799411) | |||
| 172798 | 172798 | 199923 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1398 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6017238.3952 | 2092867.7981 | 37.7275832604461 | -122.382620574427 | (37.7275832604461, -122.382620574427) | |||
| 37850 | 37850 | 188258 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1339 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017221.786780001 | 2095299.6637400002 | 37.7342597668734 | -122.382847155894 | (37.7342597668734, -122.382847155894) | |||
| 18186 | 18186 | 105551 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1398X HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6017214.0 | 2092838.0 | 37.7275000929711 | -122.382702837059 | (37.7275000929711, -122.382702837059) | |||
| 16440 | 16440 | 105549 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017207.7562 | 2092857.3745 | 37.72755294661221 | -122.38272576976802 | (37.7275529466122, -122.382725769768) | |||
| 14668 | 14668 | 105550 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1200 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6017193.2263 | 2092868.7457 | 37.727583366960204 | -122.382776791229 | (37.7275833669602, -122.382776791229) | |||
| 131410 | 131410 | 188265 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1328 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017184.66383 | 2095498.6044299998 | 37.7348039673342 | -122.382989344098 | (37.7348039673342, -122.382989344098) | |||
| 66583 | 66583 | 199918 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1208 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6017172.7159 | 2092880.7849 | 37.7276152910588 | -122.382848534061 | (37.7276152910588, -122.382848534061) | |||
| 163016 | 163016 | 199968 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6017172.3791 | 2092782.1982 | 37.7273445726468 | -122.382842840519 | (37.7273445726468, -122.382842840519) | |||
| 164101 | 164101 | 103999 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1201 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6017169.9617 | 2092803.1151 | 37.727401872803 | -122.382852652572 | (37.727401872803, -122.382852652572) | |||
| 169575 | 169575 | 199974 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1415 Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6017164.7983 | 2092702.5998 | 37.7271255921495 | -122.382863510542 | (37.7271255921495, -122.382863510542) | |||
| 187530 | 187530 | 199919 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1208 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6017156.1904 | 2092897.3103 | 37.727659753516896 | -122.38290681304599 | (37.7276597535169, -122.382906813046) | |||
| 56462 | 56462 | 199969 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400 Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6017155.9541 | 2092761.9827 | 37.727288157333206 | -122.38289821602301 | (37.7272881573332, -122.382898216023) | |||
| 92908 | 92908 | 111565 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 102564 | 102564 | 111564 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 103371 | 103371 | 111566 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x HAWES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6017154.0 | 2092794.0 | 37.7273759626121 | -122.382907198656 | (37.7273759626121, -122.382907198656) | ||||
| 64787 | 64787 | 199970 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400 Hawes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6017142.6877 | 2092741.1355 | 37.7272301819921 | -122.382942628131 | (37.7272301819921, -122.382942628131) | |||
| 82991 | 82991 | 103997 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1410X Hawes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | |||
| 91218 | 91218 | 103995 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1410X Hawes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | |||
| 91997 | 91997 | 103998 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1410X Hawes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | |||
| 139140 | 139140 | 103996 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1410X Hawes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6017134.59054 | 2092698.10151 | 37.7271115716676 | -122.38296762653 | (37.7271115716676, -122.38296762653) | |||
| 146684 | 146684 | 111567 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1400x Hawes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6017125.6309 | 2092720.9201 | 37.727173731995 | -122.38300018763 | (37.727173731995, -122.38300018763) | |||
| 23906 | 23906 | 199914 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1220 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6017119.8344 | 2092922.0985 | 37.7277258082427 | -122.38303422196002 | (37.7277258082427, -122.38303422196) | |||
| 13636 | 13636 | 10904 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X4 | 6017110.58947 | 2095748.7321799998 | 37.7354866750771 | -122.38326285221001 | (37.7354866750771, -122.38326285221) | |||
| 148429 | 148429 | 199946 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1215 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6017105.5123 | 2092851.5899 | 37.727531414033606 | -122.38307882885401 | (37.7275314140336, -122.383078828854) | |||
| 14242 | 14242 | 10905 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1336 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6017099.8174 | 2095796.95321 | 37.735618485109995 | -122.38330345120899 | (37.73561848511, -122.383303451209) | |||
| 65566 | 65566 | 199977 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1221 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6016917.6728 | 2092649.1528 | 37.7269651801144 | -122.38371410933901 | (37.7269651801144, -122.383714109339) | |||
| 167233 | 167233 | 199955 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1226 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016917.6728 | 2092728.4751 | 37.7271829836155 | -122.383719629667 | (37.7271829836155, -122.383719629667) | |||
| 32046 | 32046 | 199916 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1255 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6016905.5541 | 2092999.2174 | 37.7279257189991 | -122.383780366921 | (37.7279257189991, -122.383780366921) | |||
| 155384 | 155384 | 199949 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1234 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016872.5031 | 2092757.6701 | 37.7272606504521 | -122.383877814405 | (37.7272606504521, -122.383877814405) | |||
| 183520 | 183520 | 199956 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1238 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016851.5709 | 2092773.0939 | 37.7273018440116 | -122.38395125115 | (37.7273018440116, -122.38395125115) | |||
| 36014 | 36014 | 199973 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1241 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016820.1725 | 2092720.7632 | 37.7271564183257 | -122.384056153817 | (37.7271564183257, -122.384056153817) | |||
| 163345 | 163345 | 59679 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1246 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/23/1981 12:00:00 AM | 7 | Permit Number 19105 | 6016818.5199 | 2092798.4329 | 37.7273695927226 | -122.384067273223 | (37.7273695927226, -122.384067273223) | ||
| 184958 | 184958 | 199906 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1280 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016815.2148 | 2093150.1501 | 37.728335156345 | -122.38410318146299 | (37.728335156345, -122.384103181463) | |||
| 126896 | 126896 | 199907 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1280 Revere Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016798.1385 | 2093163.3704 | 37.728370512569605 | -122.38416313584999 | (37.7283705125696, -122.38416313585) | |||
| 150492 | 150492 | 199932 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1250 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016791.5283 | 2092818.2635 | 37.7274225513541 | -122.384161964499 | (37.7274225513541, -122.384161964499) | |||
| 187119 | 187119 | 102739 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1249 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016779.4097 | 2092749.4074 | 37.7272328159816 | -122.384199065737 | (37.7272328159816, -122.384199065737) | |||
| 39372 | 39372 | 199931 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1254 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6016771.1469 | 2092830.9330000002 | 37.7274562124229 | -122.38423330568999 | (37.7274562124229, -122.38423330569) | |||
| 152720 | 152720 | 199926 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1258 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6016753.5197 | 2092848.5602 | 37.727503638607295 | -122.384295470701 | (37.7275036386073, -122.384295470701) | |||
| 148321 | 148321 | 199971 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1255 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6016740.2994 | 2092779.7041 | 37.7273138422776 | -122.38433638024901 | (37.7273138422776, -122.384336380249) | |||
| 184039 | 184039 | 199924 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1262 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016730.9349 | 2092862.3314 | 37.727540202809 | -122.384374505972 | (37.727540202809, -122.384374505972) | |||
| 69012 | 69012 | 199922 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1266 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6016715.5112 | 2092875.0009 | 37.727574137895395 | -122.384428708392 | (37.7275741378954, -122.384428708392) |
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");