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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14482 | 175650 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990453.87404 | 2090277.74723 | 37.7189555611377 | -122.475024995517 | (37.7189555611377, -122.475024995517) | 1 | 8 | 4 | 64 | 14 | |||
| 75316 | 175649 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | 1 | 8 | 4 | 64 | 14 | |||
| 165584 | 175648 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990403.32902 | 2090274.19266 | 37.7189428716957 | -122.475199448694 | (37.7189428716957, -122.475199448694) | 1 | 8 | 4 | 64 | 14 | |||
| 172655 | 175651 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Cardenas Ave | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 5990482.39675 | 2090282.34445 | 37.7189698369625 | -122.47492674008 | (37.7189698369625, -122.47492674008) | 1 | 8 | 4 | 64 | 14 | |||
| 19661 | 175653 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988966.88544 | 2089648.46014 | 37.7171414055178 | -122.480118843736 | (37.7171414055178, -122.480118843736) | 1 | 8 | 4 | 64 | 14 | ||||
| 55188 | 175656 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 5990014.12726 | 2089314.59531 | 37.716285489253 | -122.476474690052 | (37.716285489253, -122.476474690052) | 1 | 8 | 4 | 64 | 14 | ||||
| 68279 | 175655 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5989994.06268 | 2089291.62254 | 37.7162212479866 | -122.476542364932 | (37.7162212479866, -122.476542364932) | 1 | 8 | 4 | 64 | 14 | ||||
| 189118 | 175652 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5988848.34422 | 2089725.76423 | 37.7173467747095 | -122.480534235175 | (37.7173467747095, -122.480534235175) | 1 | 8 | 4 | 64 | 14 | ||||
| 192880 | 175657 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 5990127.49163 | 2089397.98883 | 37.7165210414792 | -122.476088939347 | (37.7165210414792, -122.476088939347) | 1 | 8 | 4 | 64 | 14 | ||||
| 193028 | 175654 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 5989491.89044 | 2089216.44658 | 37.7159856948481 | -122.478272601196 | (37.7159856948481, -122.478272601196) | 1 | 8 | 4 | 64 | 14 | ||||
| 45211 | 123902 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5992691.42698 | 2114893.08742 | 37.7866723380473 | -122.469081216144 | (37.7866723380473, -122.469081216144) | 11 | 6 | 1 | 54 | 11 | |||
| 59533 | 123901 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 4ft | 5992691.28495 | 2114901.15699 | 37.7866944866565 | -122.469082295037 | (37.7866944866565, -122.469082295037) | 11 | 6 | 1 | 54 | 11 | |||
| 86783 | 123904 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 4ft | 5992691.51284 | 2114864.97618 | 37.7865951572882 | -122.469078872446 | (37.7865951572882, -122.469078872446) | 11 | 6 | 1 | 54 | 11 | |||
| 154678 | 123903 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 10th Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 5992691.069 | 2114886.79849 | 37.7866550496941 | -122.46908199679 | (37.7866550496941, -122.46908199679) | 11 | 6 | 1 | 54 | 11 | |||
| 193645 | 245947 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Beulah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5997917.0355 | 2107832.895 | 37.7675874329446 | -122.450492783652 | (37.7675874329446, -122.450492783652) | 15 | 5 | 11 | 29492 | 9 | |||
| 125054 | 185069 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Crestlake Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5989172.3574 | 2096041.2974 | 37.7347064531394 | -122.479876179257 | (37.7347064531394, -122.479876179257) | 1 | 8 | 3 | 64 | 35 | |||
| 157572 | 185124 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Crestlake Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 5989228.6057 | 2096039.1748 | 37.7347038927408 | -122.479681556653 | (37.7347038927408, -122.479681556653) | 1 | 8 | 3 | 64 | 35 | |||
| 137754 | 205760 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Malta Dr | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 6ft | 5999813.17886 | 2095831.7198 | 37.7347434627438 | -122.443072299967 | (37.7347434627438, -122.443072299967) | 9 | 7 | 4 | 63 | 40 | |||
| 160261 | 205761 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Malta Dr | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 6ft | 5999812.15419 | 2095813.64108 | 37.7346937644012 | -122.443074544653 | (37.7346937644012, -122.443074544653) | 9 | 7 | 4 | 63 | 40 | |||
| 132980 | 175590 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Moneta Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 4ft | 5997972.2511 | 2088063.00237 | 37.7133072440178 | -122.448877579363 | (37.7133072440178, -122.448877579363) | 9 | 7 | 6 | 28861 | 25 | |||
| 26819 | 64809 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Newburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/22/1991 12:00:00 AM | Permit Number 29687 | 6002621.59304129 | 2100025.86145885 | 37.7464193322717 | -122.433662314673 | (37.7464193322717, -122.433662314673) | 2 | 7 | 5 | 63 | 22 | ||
| 62700 | 222541 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Newburg St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | Permit Number 779491 | 6002580.94722 | 2099999.66602 | 37.7463450993615 | -122.433800991143 | (37.7463450993615, -122.433800991143) | 2 | 7 | 5 | 63 | 22 | ||
| 108103 | 204388 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Rossmoor Dr | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991323.57339 | 2094297.89392 | 37.730044251421 | -122.472311715736 | (37.730044251421, -122.472311715736) | 9 | 8 | 4 | 64 | 40 | |||
| 112606 | 204387 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Rossmoor Dr | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991259.599 | 2094303.40475 | 37.7300556800255 | -122.472533282603 | (37.7300556800255, -122.472533282603) | 9 | 8 | 4 | 64 | 40 | |||
| 127854 | 204386 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Rossmoor Dr | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 3ft | 5991247.05781 | 2094303.32227 | 37.7300547276399 | -122.472576632627 | (37.7300547276399, -122.472576632627) | 9 | 8 | 4 | 64 | 40 | |||
| 72066 | 222226 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Van Buren St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6002037.75303 | 2096506.93843 | 37.7367240459777 | -122.43542948168 | (37.7367240459777, -122.43542948168) | 2 | 7 | 5 | 63 | 7 | |||
| 182235 | 222225 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Van Buren St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002045.81113 | 2096484.61958 | 37.7366632212164 | -122.435400025297 | (37.7366632212164, -122.435400025297) | 2 | 7 | 5 | 63 | 7 | |||
| 5040 | 138039 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Wilmot St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003372.0036 | 2115027.1902 | 37.7876518850973 | -122.432138591007 | (37.7876518850973, -122.432138591007) | 13 | 9 | 11 | 29490 | 27 | |||
| 52872 | 138038 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Wilmot St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003363.2427 | 2115025.1288 | 37.7876457283018 | -122.432168754725 | (37.7876457283018, -122.432168754725) | 13 | 9 | 11 | 29490 | 27 | |||
| 17947 | 222204 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1 Worth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6000891.10082 | 2103189.05131 | 37.7550063494651 | -122.439872903318 | (37.7550063494651, -122.439872903318) | 2 | 4 | 5 | 28862 | 22 | |||
| 123795 | 3440 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Cameo Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 5999495.83861 | 2099835.0042 | 37.7457174292197 | -122.444457065244 | (37.7457174292197, -122.444457065244) | 2 | 7 | 5 | 63 | 22 | |||
| 172037 | 204566 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Hillcrest Ct | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996861.21135 | 2096373.66196 | 37.7360627493057 | -122.453317320954 | (37.7360627493057, -122.453317320954) | 9 | 7 | 4 | 59 | 40 | |||
| 175830 | 204567 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Hillcrest Ct | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996869.14532 | 2096371.37688 | 37.7360569297851 | -122.453289725243 | (37.7360569297851, -122.453289725243) | 9 | 7 | 4 | 59 | 40 | |||
| 57577 | 205845 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Jules Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5994459.49219 | 2090019.51391 | 37.7184778466456 | -122.46116053335 | (37.7184778466456, -122.46116053335) | 9 | 8 | 6 | 28861 | 24 | |||
| 27096 | 204488 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 3ft | 5993862.27446 | 2102337.63255 | 37.7522659605301 | -122.464118595998 | (37.7522659605301, -122.464118595998) | 1 | 8 | 4 | 29491 | 40 | |||
| 35507 | 204487 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5993872.61201 | 2102327.49327 | 37.7522387164587 | -122.464082111418 | (37.7522387164587, -122.464082111418) | 1 | 8 | 4 | 29491 | 40 | |||
| 164050 | 114792 | Planning Code 138.1 required 2 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Linares Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x10 | 5993887.4 | 2102332.1 | 37.7522522176371 | -122.464031307011 | (37.7522522176371, -122.464031307011) | 1 | 8 | 4 | 29491 | 40 | ||||
| 146859 | 17233 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Ora Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 2X2 | 6001155.38757 | 2098531.68959 | 37.7422333863766 | -122.438625231576 | (37.7422333863766, -122.438625231576) | 2 | 7 | 5 | 63 | 7 | |||
| 28561 | 188269 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6017903.32503 | 2094505.01761 | 37.7321154566611 | -122.380435623808 | (37.7321154566611, -122.380435623808) | 10 | 3 | 8 | 58 | 1 | |||
| 34680 | 4896 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.54536 | 37.7318123626362 | -122.379724285267 | (37.7318123626362, -122.379724285267) | 10 | 3 | 8 | 58 | 1 | ||
| 37266 | 4898 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | 10 | 3 | 8 | 58 | 1 | |||
| 55242 | 188270 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6017725.6269 | 2094584.88968 | 37.7323249627215 | -122.381055522912 | (37.7323249627215, -122.381055522912) | 10 | 3 | 8 | 58 | 1 | |||
| 180093 | 4897 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018099.28954 | 2094405.02636 | 37.731851711586 | -122.37975117949 | (37.731851711586, -122.37975117949) | 10 | 3 | 8 | 58 | 1 | |||
| 63343 | 175683 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Valmar Ter | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 10 | Width 3ft | 6005492.68833 | 2092982.27717 | 37.7272417193178 | -122.42323378172 | (37.7272417193178, -122.42323378172) | 9 | 7 | 6 | 28861 | 5 | |||
| 104326 | 175684 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 10 Valmar Ter | 3 | Sidewalk: Curb side : Pot | Tree | Private 2 | 6 | Width 3ft | 6005481.57404 | 2092966.57789 | 37.7271979852942 | -122.423271088287 | (37.7271979852942, -122.423271088287) | 9 | 7 | 6 | 28861 | 5 | |||
| 29895 | 220786 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 27th St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 6005806.54234 | 2100249.31165 | 37.747213079126 | -122.422664984796 | (37.747213079126, -122.422664984796) | 2 | 7 | 5 | 28859 | 22 | |||
| 30977 | 220816 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Alemany Blvd | 27 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 4ft | 6009324.41886 | 2095855.67364 | 37.7353469537051 | -122.410190239591 | (37.7353469537051, -122.410190239591) | 10 | 7 | 7 | 28859 | 2 | |||
| 160009 | 220815 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Alemany Blvd | 20 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6009430.07123 | 2095925.78909 | 37.7355453971844 | -122.40982990643 | (37.7355453971844, -122.40982990643) | 10 | 7 | 7 | 28859 | 2 | |||
| 49756 | 116671 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
| 181059 | 188990 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100 Topeka Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6012468.19728 | 2095250.25316 | 37.7338603114111 | -122.399278475632 | (37.7338603114111, -122.399278475632) | 10 | 3 | 8 | 58 | 1 | |||
| 135065 | 102447 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1001 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5992369.44663 | 2113417.7931 | 37.7826029764943 | -122.47008771644 | (37.7826029764943, -122.47008771644) | 11 | 6 | 2 | 54 | 11 | |||
| 186369 | 222461 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1008 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6002464.47258 | 2102612.29458 | 37.7535121492774 | -122.434390507519 | (37.7535121492774, -122.434390507519) | 2 | 4 | 5 | 28862 | 22 | |||
| 154934 | 175615 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 12 | Median : Cutout | Tree | DPW 1 | 8 | Width 0ft | 6011400.01852 | 2090633.78251 | 37.7211248500058 | -122.402646978091 | (37.7211248500058, -122.402646978091) | 10 | 3 | 8 | 309 | 28 | |||
| 194040 | 175614 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 100x Mansell St | 10 | Median : Cutout | Tree | DPW 1 | 12 | Width 0ft | 6011421.83278 | 2090628.04482 | 37.7211103133815 | -122.402571168832 | (37.7211103133815, -122.402571168832) | 10 | 7 | 8 | 309 | 28 | |||
| 32059 | 62223 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2010 12:00:00 AM | 3 | Permit Number 53519 | 6001462.98995 | 2093679.24123 | 37.7289271819206 | -122.437214279825 | (37.7289271819206, -122.437214279825) | 9 | 7 | 6 | 28861 | 25 | |
| 175589 | 125795 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Cervantes Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 6001298.49165 | 2121127.66063 | 37.8042843997778 | -122.439750059544 | (37.8042843997778, -122.439750059544) | 13 | 9 | 1 | 57 | 17 | |||
| 184537 | 125794 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Cervantes Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 6001288.01162 | 2121135.2831 | 37.8043047325274 | -122.439786873275 | (37.8043047325274, -122.439786873275) | 13 | 9 | 1 | 57 | 17 | |||
| 144796 | 175751 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008533.24007 | 2093511.74636 | 37.7288666548595 | -122.412759992088 | (37.7288666548595, -122.412759992088) | 9 | 3 | 7 | 309 | 28 | |||
| 151773 | 175752 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 5ft | 6008529.08194 | 2093527.37027 | 37.7289093213844 | -122.412775471205 | (37.7289093213844, -122.412775471205) | 9 | 3 | 7 | 309 | 28 | |||
| 153674 | 175705 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 5ft | 6008531.54001 | 2093517.90327 | 37.7288834649957 | -122.412766304433 | (37.7288834649957, -122.412766304433) | 9 | 3 | 7 | 309 | 28 | |||
| 174838 | 175706 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Dartmouth St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 5ft | 6008529.71113 | 2093523.77753 | 37.7288994918046 | -122.412773042148 | (37.7288994918046, -122.412773042148) | 9 | 3 | 7 | 309 | 28 | |||
| 21131 | 220820 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005416.76341 | 2103047.49805 | 37.7548742543519 | -122.42421178725 | (37.7548742543519, -122.42421178725) | 2 | 4 | 5 | 28859 | 19 | |||
| 150093 | 246728 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 101 Ripley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6008612.87637 | 2099109.67638 | 37.7442418234114 | -122.412880303405 | (37.7442418234114, -122.412880303405) | 2 | 7 | 7 | 28859 | 2 | |||
| 152635 | 222212 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1012 Chenery St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6000957.79216 | 2096197.54851 | 37.7358131397705 | -122.439141199604 | (37.7358131397705, -122.439141199604) | 2 | 7 | 5 | 63 | 7 | ||||
| 161559 | 183737 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1014 Santiago St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5989684.0603 | 2099734.5492 | 37.744876881917 | -122.478377036179 | (37.744876881917, -122.478377036179) | 1 | 8 | 3 | 29491 | 35 | |||
| 80636 | 107195 | Undocumented 4 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1017 CLEMENT ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 5992399 | 2113429 | 37.7826354559957 | -122.469986291665 | (37.7826354559957, -122.469986291665) | 11 | 6 | 2 | 54 | 11 | |||
| 155675 | 30673 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1018 Minna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/30/1995 12:00:00 AM | 7 | Permit Number 34598 | 6007663.01696 | 2109836.11415 | 37.7736407906294 | -122.416924546537 | (37.7736407906294, -122.416924546537) | 8 | 2 | 9 | 28853 | 19 | |
| 95136 | 222341 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1019 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002527.89214 | 2102445.0384 | 37.7530565032762 | -122.43415923337 | (37.7530565032762, -122.43415923337) | 2 | 4 | 5 | 28862 | 22 | |||
| 58704 | 140861 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 102 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 0ft | 5996245.7331 | 2113752.0549 | 37.7837440946001 | -122.456701695076 | (37.7837440946001, -122.456701695076) | 11 | 6 | 1 | 54 | 31 | |||
| 138918 | 222340 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1021 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6002531.2192 | 2102429.53375 | 37.7530141200255 | -122.434146619466 | (37.7530141200255, -122.434146619466) | 2 | 4 | 5 | 28862 | 22 | |||
| 119379 | 188857 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Minna St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6007556.32266 | 2109725.24267 | 37.7733303617494 | -122.417285761027 | (37.7733303617494, -122.417285761027) | 8 | 2 | 9 | 28853 | 19 | |||
| 135274 | 222238 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997287.2431 | 2106942.28914 | 37.7651059905631 | -122.452606861018 | (37.7651059905631, -122.452606861018) | 15 | 5 | 11 | 29492 | 9 | |||
| 150920 | 222239 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997289.37279 | 2106934.09863 | 37.7650836235347 | -122.452598903829 | (37.7650836235347, -122.452598903829) | 15 | 5 | 11 | 29492 | 9 | |||
| 155109 | 222240 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997291.73168 | 2106924.63054 | 37.7650577617289 | -122.452590061694 | (37.7650577617289, -122.452590061694) | 15 | 5 | 11 | 29492 | 9 | |||
| 181250 | 222237 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1022 Stanyan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997285.6403 | 2106951.23247 | 37.7651304548321 | -122.452613050173 | (37.7651304548321, -122.452613050173) | 15 | 5 | 11 | 29492 | 9 | |||
| 139532 | 54810 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1026 De Haro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/16/1972 12:00:00 AM | 11 | Permit Number 10663 | 6012161.95384 | 2103585.91754 | 37.7567311880086 | -122.400922718734 | (37.7567311880086, -122.400922718734) | 10 | 3 | 8 | 28856 | 29 | ||
| 156980 | 222459 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 103 Germania St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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) | 15 | 9 | 11 | 29492 | 10 | |
| 180101 | 222460 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 103 Germania St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6003758.15154 | 2108826.57064 | 37.7706484089138 | -122.430360026693 | (37.7706484089138, -122.430360026693) | 15 | 9 | 11 | 29492 | 10 | |||
| 98494 | 69410 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1033 Prague St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/1994 12:00:00 AM | Permit Number 33515 | 6001287.00169166 | 2086793.18756043 | 37.7100096203988 | -122.437329807487 | (37.7100096203988, -122.437329807487) | 9 | 7 | 6 | 28861 | 5 | ||
| 23298 | 4375 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1035 Chenery St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6000885.93841 | 2096177.1796 | 37.7357531225975 | -122.43938816603 | (37.7357531225975, -122.43938816603) | 2 | 7 | 5 | 63 | 7 | |||
| 88993 | 220825 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1036 Hampshire St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010217.36135 | 2103168.86873 | 37.7554774026875 | -122.407618458233 | (37.7554774026875, -122.407618458233) | 2 | 4 | 7 | 28859 | 19 | |||
| 13274 | 188254 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013780.02718 | 2089753.49239 | 37.7188403408752 | -122.39435831441 | (37.7188403408752, -122.39435831441) | 10 | 3 | 8 | 58 | 1 | ||||
| 28748 | 188256 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6013789.26124 | 2089763.61893 | 37.7188686596462 | -122.394327104323 | (37.7188686596462, -122.394327104323) | 10 | 3 | 8 | 58 | 1 | ||||
| 47417 | 188251 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6013763.34518 | 2089782.1261 | 37.7189180360183 | -122.394417981716 | (37.7189180360183, -122.394417981716) | 10 | 3 | 8 | 58 | 1 | ||||
| 62000 | 188252 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6013770.43233 | 2089778.01595 | 37.7189071443355 | -122.394393196412 | (37.7189071443355, -122.394393196412) | 10 | 3 | 8 | 58 | 1 | ||||
| 100463 | 188253 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6013773.56946 | 2089775.5723 | 37.7189006089484 | -122.394382181502 | (37.7189006089484, -122.394382181502) | 10 | 3 | 8 | 58 | 1 | ||||
| 143096 | 188255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6013785.15628 | 2089757.61987 | 37.718851959233 | -122.394340873848 | (37.718851959233, -122.394340873848) | 10 | 3 | 8 | 58 | 1 | ||||
| 185550 | 188250 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1039 Jamestown Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6013748.16101 | 2089779.78907 | 37.7189107748964 | -122.394470304261 | (37.7189107748964, -122.394470304261) | 10 | 3 | 8 | 58 | 1 | ||||
| 5949 | 222255 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 105 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6008701 | 2098012 | 37.7412327917956 | -122.412498013553 | (37.7412327917956, -122.412498013553) | 10 | 7 | 7 | 28859 | 2 | |||
| 146344 | 62848 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 105 Banks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/18/1986 12:00:00 AM | Permit Number 23216 | 6008699.91517898 | 2098056.92560852 | 37.7413560867786 | -122.412504939408 | (37.7413560867786, -122.412504939408) | 10 | 7 | 7 | 28859 | 2 | ||
| 62154 | 55682 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/16/1987 12:00:00 AM | Permit Number 24542 | 6006870.6698132 | 2098947.4026548 | 37.7436983094089 | -122.418892984779 | (37.7436983094089, -122.418892984779) | 2 | 7 | 7 | 28859 | 2 | ||
| 118251 | 248280 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 105 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006841.61034 | 2098924.32173 | 37.7436332980453 | -122.418991828932 | (37.7436332980453, -122.418991828932) | 2 | 7 | 7 | 28859 | 2 | |||
| 34694 | 188895 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1050 Wisconsin St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 6012767.38997 | 2102598.59008 | 37.7540539548395 | -122.398759597378 | (37.7540539548395, -122.398759597378) | 10 | 3 | 8 | 28856 | 29 | |||
| 51276 | 222320 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1058 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6009421.93272 | 2103019.39778 | 37.7550224311493 | -122.410358752754 | (37.7550224311493, -122.410358752754) | 2 | 4 | 7 | 28859 | 19 | |||
| 130830 | 188892 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1058 Rhode Island St | 1 | : | Tree | Private 2 | 10 | Width 4ft | 6011884.21322 | 2103471.07947 | 37.7564003714916 | -122.401875180806 | (37.7564003714916, -122.401875180806) | 10 | 3 | 8 | 28856 | 29 | |||
| 12837 | 47215 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 Cambridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 6 | Permit Number 45166 | 6006633.47627 | 2094299.61445 | 37.7309231552671 | -122.419383490876 | (37.7309231552671, -122.419383490876) | 9 | 7 | 7 | 309 | 5 | |
| 48867 | 217682 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 106 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 5992831.9496 | 2097739.0243 | 37.7395799184924 | -122.467347238041 | (37.7395799184924, -122.467347238041) | 1 | 8 | 4 | 59 | 40 | |||
| 73733 | 140257 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1060 HAYES ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5998994.5535 | 2110106.5947 | 37.7738920473207 | -122.44692943607 | (37.7738920473207, -122.44692943607) | 15 | 5 | 11 | 29492 | 16 | |||
| 124267 | 54478 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 107 Topeka Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/13/1972 12:00:00 AM | 10 | Permit Number 10270 | 6012476.33052 | 2095283.47327 | 37.7339519802024 | -122.399252687573 | (37.7339519802024, -122.399252687573) | 10 | 3 | 8 | 58 | 1 | ||
| 191984 | 7409 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 1074 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6010471.6875 | 2111110.743 | 37.7772982123977 | -122.407298752214 | (37.7772982123977, -122.407298752214) | 14 | 2 | 9 | 28853 | 34 |
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) );