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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57235 | 57235 | 175648 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | |||
| 67405 | 67405 | 175650 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990453.87404 | 2090277.7472299999 | 37.718955561137705 | -122.475024995517 | (37.7189555611377, -122.475024995517) | |||
| 180905 | 180905 | 175649 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | |||
| 185753 | 185753 | 175651 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008001 | (37.7189698369625, -122.47492674008) | |||
| 29157 | 29157 | 175654 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | ||||
| 36921 | 36921 | 175655 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5989994.06268 | 2089291.6225400001 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | ||||
| 44701 | 44701 | 175656 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990014.1272599995 | 2089314.5953099998 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | ||||
| 53937 | 53937 | 175653 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | ||||
| 56400 | 56400 | 175657 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5990127.49163 | 2089397.98883 | 37.716521041479204 | -122.476088939347 | (37.7165210414792, -122.476088939347) | ||||
| 168076 | 168076 | 175652 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | 5988848.344219999 | 2089725.7642299999 | 37.717346774709505 | -122.480534235175 | (37.7173467747095, -122.480534235175) | ||||
| 40895 | 40895 | 123901 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 10th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 4ft | 5992691.28495 | 2114901.15699 | 37.7866944866565 | -122.469082295037 | (37.7866944866565, -122.469082295037) | |||
| 61838 | 61838 | 123902 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 10th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5992691.42698 | 2114893.08742 | 37.786672338047296 | -122.469081216144 | (37.7866723380473, -122.469081216144) | |||
| 74411 | 74411 | 123904 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 10th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 4ft | 5992691.51284 | 2114864.9761799998 | 37.786595157288204 | -122.469078872446 | (37.7865951572882, -122.469078872446) | |||
| 165612 | 165612 | 123903 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 10th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 5992691.069 | 2114886.79849 | 37.7866550496941 | -122.46908199679 | (37.7866550496941, -122.46908199679) | |||
| 37815 | 37815 | 245947 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Beulah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5997917.0355 | 2107832.895 | 37.7675874329446 | -122.450492783652 | (37.7675874329446, -122.450492783652) | |||
| 129948 | 129948 | 185124 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Crestlake Dr | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989228.6057 | 2096039.1748 | 37.7347038927408 | -122.479681556653 | (37.7347038927408, -122.479681556653) | |||
| 148129 | 148129 | 185069 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Crestlake Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5989172.3574 | 2096041.2974 | 37.7347064531394 | -122.47987617925699 | (37.7347064531394, -122.479876179257) | |||
| 161218 | 161218 | 205761 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Malta Dr | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5999812.15419 | 2095813.64108 | 37.7346937644012 | -122.443074544653 | (37.7346937644012, -122.443074544653) | |||
| 169081 | 169081 | 205760 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Malta Dr | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 6ft | 5999813.178859999 | 2095831.7198 | 37.7347434627438 | -122.443072299967 | (37.7347434627438, -122.443072299967) | |||
| 175588 | 175588 | 175590 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Moneta Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 4ft | 5997972.2511 | 2088063.0023700001 | 37.7133072440178 | -122.448877579363 | (37.7133072440178, -122.448877579363) | |||
| 63 | 63 | 222541 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | Permit Number 779491 | 6002580.9472199995 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | ||
| 129271 | 129271 | 64809 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1991 12:00:00 AM | Permit Number 29687 | 6002621.59304129 | 2100025.86145885 | 37.74641933227171 | -122.433662314673 | (37.7464193322717, -122.433662314673) | ||
| 34946 | 34946 | 204388 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991323.5733900005 | 2094297.8939200002 | 37.730044251421 | -122.47231171573601 | (37.730044251421, -122.472311715736) | |||
| 134916 | 134916 | 204386 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991247.05781 | 2094303.3222700001 | 37.730054727639896 | -122.472576632627 | (37.7300547276399, -122.472576632627) | |||
| 186708 | 186708 | 204387 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Rossmoor Dr | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5991259.598999999 | 2094303.40475 | 37.7300556800255 | -122.472533282603 | (37.7300556800255, -122.472533282603) | |||
| 165300 | 165300 | 222225 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Van Buren St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6002045.81113 | 2096484.61958 | 37.736663221216396 | -122.435400025297 | (37.7366632212164, -122.435400025297) | |||
| 167012 | 167012 | 222226 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Van Buren St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6002037.75303 | 2096506.9384299999 | 37.7367240459777 | -122.43542948168002 | (37.7367240459777, -122.43542948168) | |||
| 33320 | 33320 | 138039 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Wilmot St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003372.0036 | 2115027.1902 | 37.7876518850973 | -122.432138591007 | (37.7876518850973, -122.432138591007) | |||
| 75486 | 75486 | 138038 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1 Wilmot St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6003363.2427 | 2115025.1288 | 37.7876457283018 | -122.432168754725 | (37.7876457283018, -122.432168754725) | |||
| 20145 | 20145 | 3440 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Cameo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 5999495.83861 | 2099835.0042 | 37.7457174292197 | -122.44445706524401 | (37.7457174292197, -122.444457065244) | |||
| 53219 | 53219 | 204567 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Hillcrest Ct | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996869.14532 | 2096371.3768799999 | 37.73605692978511 | -122.453289725243 | (37.7360569297851, -122.453289725243) | |||
| 57089 | 57089 | 204566 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Hillcrest Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5996861.21135 | 2096373.66196 | 37.7360627493057 | -122.453317320954 | (37.7360627493057, -122.453317320954) | |||
| 162076 | 162076 | 205845 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Jules Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994459.492190001 | 2090019.5139099997 | 37.718477846645605 | -122.46116053335 | (37.7184778466456, -122.46116053335) | |||
| 32575 | 32575 | 204488 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993862.27446 | 2102337.63255 | 37.7522659605301 | -122.464118595998 | (37.7522659605301, -122.464118595998) | |||
| 66588 | 66588 | 204487 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5993872.61201 | 2102327.49327 | 37.7522387164587 | -122.464082111418 | (37.7522387164587, -122.464082111418) | |||
| 120162 | 120162 | 114792 | Planning Code 138.1 required 4 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | ||||
| 20698 | 20698 | 17233 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6001155.387569999 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | |||
| 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) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 40636 | 40636 | 175683 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Valmar Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6005492.68833 | 2092982.2771700001 | 37.727241719317796 | -122.42323378171999 | (37.7272417193178, -122.42323378172) | |||
| 168905 | 168905 | 175684 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Valmar Ter | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6005481.57404 | 2092966.57789 | 37.727197985294204 | -122.423271088287 | (37.7271979852942, -122.423271088287) | |||
| 187073 | 187073 | 220786 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 27th St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 6ft | 6005806.54234 | 2100249.31165 | 37.747213079126 | -122.42266498479601 | (37.747213079126, -122.422664984796) | |||
| 64910 | 64910 | 220816 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Alemany Blvd | 27 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 4ft | 6009324.41886 | 2095855.6736400002 | 37.735346953705104 | -122.410190239591 | (37.7353469537051, -122.410190239591) | |||
| 152233 | 152233 | 220815 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Alemany Blvd | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6009430.07123 | 2095925.78909 | 37.7355453971844 | -122.40982990642999 | (37.7355453971844, -122.40982990643) | |||
| 78555 | 78555 | 116671 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 38086 | 38086 | 188990 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Topeka Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6012468.19728 | 2095250.2531599998 | 37.7338603114111 | -122.399278475632 | (37.7338603114111, -122.399278475632) | |||
| 80772 | 80772 | 102447 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1001 Clement St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 5992369.44663 | 2113417.7931 | 37.782602976494296 | -122.47008771643999 | (37.7826029764943, -122.47008771644) | |||
| 40897 | 40897 | 222461 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1008 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6002464.472580001 | 2102612.29458 | 37.7535121492774 | -122.434390507519 | (37.7535121492774, -122.434390507519) | |||
| 167490 | 167490 | 175615 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011400.018519999 | 2090633.7825099998 | 37.7211248500058 | -122.40264697809098 | (37.7211248500058, -122.402646978091) | |||
| 186302 | 186302 | 175614 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100x Mansell St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 0ft | 6011421.832780001 | 2090628.0448200002 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | |||
| 161518 | 161518 | 62223 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.2412299998 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | |
| 61310 | 61310 | 125794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001288.01162 | 2121135.2831 | 37.8043047325274 | -122.439786873275 | (37.8043047325274, -122.439786873275) | |||
| 162193 | 162193 | 125795 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001298.49165 | 2121127.66063 | 37.8042843997778 | -122.439750059544 | (37.8042843997778, -122.439750059544) | |||
| 40021 | 40021 | 175705 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Dartmouth St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 6008531.54001 | 2093517.9032700001 | 37.728883464995704 | -122.412766304433 | (37.7288834649957, -122.412766304433) | |||
| 52715 | 52715 | 175752 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Dartmouth St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008529.08194 | 2093527.37027 | 37.7289093213844 | -122.41277547120501 | (37.7289093213844, -122.412775471205) | |||
| 135615 | 135615 | 175751 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Dartmouth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6008533.240069999 | 2093511.7463599998 | 37.7288666548595 | -122.412759992088 | (37.7288666548595, -122.412759992088) | |||
| 147465 | 147465 | 175706 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Dartmouth St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 5ft | 6008529.711130001 | 2093523.7775299998 | 37.7288994918046 | -122.412773042148 | (37.7288994918046, -122.412773042148) | |||
| 133865 | 133865 | 220820 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6005416.76341 | 2103047.49805 | 37.7548742543519 | -122.42421178725 | (37.7548742543519, -122.42421178725) | |||
| 51794 | 51794 | 246728 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 101 Ripley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6008612.87637 | 2099109.67638 | 37.7442418234114 | -122.412880303405 | (37.7442418234114, -122.412880303405) | |||
| 31126 | 31126 | 222212 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1012 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 6000957.79216 | 2096197.5485099999 | 37.7358131397705 | -122.439141199604 | (37.7358131397705, -122.439141199604) | ||||
| 25239 | 25239 | 183737 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1014 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989684.0603 | 2099734.5492 | 37.744876881917 | -122.47837703617901 | (37.744876881917, -122.478377036179) | |||
| 99982 | 99982 | 107195 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1017 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5992399.0 | 2113429.0 | 37.7826354559957 | -122.469986291665 | (37.7826354559957, -122.469986291665) | |||
| 157187 | 157187 | 30673 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1018 Minna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/30/1995 12:00:00 AM | 7 | Permit Number 34598 | 6007663.01696 | 2109836.11415 | 37.77364079062939 | -122.416924546537 | (37.7736407906294, -122.416924546537) | |
| 146462 | 146462 | 222341 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002527.89214 | 2102445.0384 | 37.753056503276206 | -122.43415923337 | (37.7530565032762, -122.43415923337) | |||
| 38447 | 38447 | 140861 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 102 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 0ft | 5996245.7331 | 2113752.0549 | 37.7837440946001 | -122.456701695076 | (37.7837440946001, -122.456701695076) | |||
| 155370 | 155370 | 222340 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1021 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6002531.2192 | 2102429.53375 | 37.753014120025504 | -122.434146619466 | (37.7530141200255, -122.434146619466) | |||
| 69031 | 69031 | 188857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Minna St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6007556.32266 | 2109725.24267 | 37.773330361749395 | -122.41728576102699 | (37.7733303617494, -122.417285761027) | |||
| 23673 | 23673 | 222238 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.45260686101801 | (37.7651059905631, -122.452606861018) | |||
| 44726 | 44726 | 222240 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5997291.73168 | 2106924.6305400003 | 37.7650577617289 | -122.452590061694 | (37.7650577617289, -122.452590061694) | |||
| 46926 | 46926 | 222239 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997289.37279 | 2106934.09863 | 37.7650836235347 | -122.452598903829 | (37.7650836235347, -122.452598903829) | |||
| 137055 | 137055 | 222237 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1022 Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997285.6403 | 2106951.23247 | 37.765130454832104 | -122.452613050173 | (37.7651304548321, -122.452613050173) | |||
| 165801 | 165801 | 54810 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1026 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/16/1972 12:00:00 AM | 11 | Permit Number 10663 | 6012161.953840001 | 2103585.9175400003 | 37.7567311880086 | -122.400922718734 | (37.7567311880086, -122.400922718734) | ||
| 3012 | 3012 | 222459 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 12 | Width 3ft | Permit Number 37768 | 6003745.35961 | 2108826.05534 | 37.7706462694291 | -122.430404237367 | (37.7706462694291, -122.430404237367) | |
| 169765 | 169765 | 222460 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 103 Germania St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6003758.15154 | 2108826.57064 | 37.7706484089138 | -122.430360026693 | (37.7706484089138, -122.430360026693) | |||
| 102786 | 102786 | 69410 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.43732980748699 | (37.7100096203988, -122.437329807487) | ||
| 20446 | 20446 | 4375 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | |||
| 73833 | 73833 | 220825 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1036 Hampshire St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010217.36135 | 2103168.8687299998 | 37.755477402687504 | -122.40761845823299 | (37.7554774026875, -122.407618458233) | |||
| 29194 | 29194 | 188256 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013789.26124 | 2089763.6189299999 | 37.7188686596462 | -122.39432710432301 | (37.7188686596462, -122.394327104323) | ||||
| 34280 | 34280 | 188251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | 6013763.34518 | 2089782.1261 | 37.718918036018295 | -122.394417981716 | (37.7189180360183, -122.394417981716) | ||||
| 41791 | 41791 | 188253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 6013773.56946 | 2089775.5723 | 37.718900608948395 | -122.394382181502 | (37.7189006089484, -122.394382181502) | ||||
| 48313 | 48313 | 188250 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | 6013748.16101 | 2089779.7890700002 | 37.7189107748964 | -122.39447030426099 | (37.7189107748964, -122.394470304261) | ||||
| 56612 | 56612 | 188254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | 6013780.02718 | 2089753.4923900003 | 37.718840340875204 | -122.39435831441001 | (37.7188403408752, -122.39435831441) | ||||
| 60286 | 60286 | 188255 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6013785.156280001 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | ||||
| 134087 | 134087 | 188252 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6013770.43233 | 2089778.01595 | 37.718907144335496 | -122.394393196412 | (37.7189071443355, -122.394393196412) | ||||
| 112450 | 112450 | 62848 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 105 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/18/1986 12:00:00 AM | Permit Number 23216 | 6008699.91517898 | 2098056.92560852 | 37.7413560867786 | -122.412504939408 | (37.7413560867786, -122.412504939408) | ||
| 68700 | 68700 | 248280 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006841.61034 | 2098924.32173 | 37.743633298045296 | -122.418991828932 | (37.7436332980453, -122.418991828932) | |||
| 85115 | 85115 | 55682 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/16/1987 12:00:00 AM | Permit Number 24542 | 6006870.669813201 | 2098947.4026548 | 37.7436983094089 | -122.41889298477899 | (37.7436983094089, -122.418892984779) | ||
| 62066 | 62066 | 188895 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1050 Wisconsin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6012767.38997 | 2102598.59008 | 37.7540539548395 | -122.398759597378 | (37.7540539548395, -122.398759597378) | |||
| 152097 | 152097 | 222320 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1058 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6009421.93272 | 2103019.3977799998 | 37.7550224311493 | -122.41035875275401 | (37.7550224311493, -122.410358752754) | |||
| 170498 | 170498 | 188892 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1058 Rhode Island St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6011884.213219999 | 2103471.07947 | 37.7564003714916 | -122.401875180806 | (37.7564003714916, -122.401875180806) | |||
| 29473 | 29473 | 47215 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.4762699995 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | |
| 57026 | 57026 | 217682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 106 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5992831.9496 | 2097739.0243 | 37.739579918492396 | -122.467347238041 | (37.7395799184924, -122.467347238041) | |||
| 158062 | 158062 | 140257 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1060 HAYES ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998994.5535 | 2110106.5947 | 37.77389204732071 | -122.44692943607001 | (37.7738920473207, -122.44692943607) | |||
| 70559 | 70559 | 54478 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 107 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10270 | 6012476.330519999 | 2095283.4732700002 | 37.7339519802024 | -122.399252687573 | (37.7339519802024, -122.399252687573) | ||
| 16821 | 16821 | 7409 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6010471.6875 | 2111110.7430000002 | 37.7772982123977 | -122.40729875221399 | (37.7772982123977, -122.407298752214) | |||
| 176867 | 176867 | 54479 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 108 Topeka Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1972 12:00:00 AM | 9 | Permit Number 10271 | 6012495.87675 | 2095234.91266 | 37.7338197321998 | -122.39918170227301 | (37.7338197321998, -122.399181702273) | ||
| 134111 | 134111 | 188871 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1081 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6012231.212730001 | 2103354.3709299997 | 37.7560992748753 | -122.40066692904301 | (37.7560992748753, -122.400666929043) |
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");