trees
221 rows where qSpecies_id = 153 sorted by PlotSize descending
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18603 | 175826 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6003554.6564 | 2087615.13702 | 37.7123951695857 | -122.429550938144 | (37.7123951695857, -122.429550938144) | 9 | 7 | 6 | 28861 | 5 | |||
| 55123 | 175827 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | Width 8ft | 6003539.76747 | 2087618.63679 | 37.7124039361582 | -122.42960264824 | (37.7124039361582, -122.42960264824) | 9 | 7 | 6 | 28861 | 5 | |||
| 165117 | 175825 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1669 Geneva Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 8ft | 6003581.23003 | 2087608.20421 | 37.7123776381814 | -122.429458597533 | (37.7123776381814, -122.429458597533) | 9 | 7 | 6 | 28861 | 5 | |||
| 22124 | 222872 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4250 26th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6002245.78823 | 2100636.8852 | 37.7480757286172 | -122.435005495434 | (37.7480757286172, -122.435005495434) | 2 | 4 | 5 | 28862 | 22 | |||
| 37804 | 188455 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011498.78949 | 2106422.93471 | 37.76448399066 | -122.403415778809 | (37.76448399066, -122.403415778809) | 8 | 3 | 8 | 28856 | 29 | |||
| 40010 | 188453 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011500.6075 | 2106371.58763 | 37.7643431046639 | -122.40340587818 | (37.7643431046639, -122.40340587818) | 8 | 3 | 8 | 28856 | 29 | |||
| 48148 | 188456 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011496.96392 | 2106445.77608 | 37.7645466059608 | -122.403423700042 | (37.7645466059608, -122.403423700042) | 8 | 3 | 8 | 28856 | 29 | |||
| 74126 | 188445 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011511.33671 | 2106160.81157 | 37.7637649602022 | -122.403353939635 | (37.7637649602022, -122.403353939635) | 8 | 3 | 8 | 28856 | 29 | |||
| 82479 | 188443 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011515.17164 | 2106121.75692 | 37.7636579390857 | -122.403337928096 | (37.7636579390857, -122.403337928096) | 8 | 3 | 8 | 28856 | 29 | |||
| 86079 | 188451 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011503.70347 | 2106326.77104 | 37.7642202212997 | -122.403392016924 | (37.7642202212997, -122.403392016924) | 8 | 3 | 8 | 28856 | 29 | |||
| 88822 | 188444 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6011513.49426 | 2106142.74637 | 37.7637154777208 | -122.403345206341 | (37.7637154777208, -122.403345206341) | 8 | 3 | 8 | 28856 | 29 | |||
| 98909 | 222860 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 2 Webster St | 6 | : | Tree | Private 2 | 5 | Width 4ft | 6004313.25978 | 2108595.11318 | 37.7700443109166 | -122.42842339964 | (37.7700443109166, -122.42842339964) | 7 | 9 | 5 | 28862 | 10 | |||
| 104503 | 222865 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6005579.30004 | 2102535.69949 | 37.7534781504092 | -122.423613303727 | (37.7534781504092, -122.423613303727) | 2 | 4 | 5 | 28859 | 19 | |||
| 105468 | 188446 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011512.27704 | 2106186.35742 | 37.763835155891 | -122.403352484549 | (37.763835155891, -122.403352484549) | 8 | 3 | 8 | 28856 | 29 | |||
| 106619 | 222866 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3625 23rd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6005593.12032 | 2102536.33181 | 37.7534806667087 | -122.423565555132 | (37.7534806667087, -122.423565555132) | 2 | 4 | 5 | 28859 | 19 | |||
| 110268 | 188447 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011509.63905 | 2106201.49872 | 37.7638765831644 | -122.40336267386 | (37.7638765831644, -122.40336267386) | 8 | 3 | 8 | 28856 | 29 | |||
| 119756 | 188450 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011505.24263 | 2106303.9355 | 37.7641576060043 | -122.403385086777 | (37.7641576060043, -122.403385086777) | 8 | 3 | 8 | 28856 | 29 | |||
| 140364 | 188454 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6011500.01929 | 2106398.96501 | 37.7644182439416 | -122.403409838819 | (37.7644182439416, -122.403409838819) | 8 | 3 | 8 | 28856 | 29 | |||
| 146826 | 188448 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011508.86092 | 2106242.57461 | 37.7639893248743 | -122.403368255061 | (37.7639893248743, -122.403368255061) | 8 | 3 | 8 | 28856 | 29 | |||
| 157286 | 188449 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6011506.74728 | 2106279.38998 | 37.7640902935593 | -122.403378155697 | (37.7640902935593, -122.403378155697) | 8 | 3 | 8 | 28856 | 29 | |||
| 161579 | 188452 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 401 Kansas St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6011502.89501 | 2106343.32084 | 37.7642656181765 | -122.403395977545 | (37.7642656181765, -122.403395977545) | 8 | 3 | 8 | 28856 | 29 | |||
| 3622 | 222861 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 77 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008184.4457 | 2107955.63736 | 37.7685067598049 | -122.414987714411 | (37.7685067598049, -122.414987714411) | 8 | 4 | 7 | 28853 | 19 | |||
| 6934 | 125964 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 954 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6007746.87512 | 2120288.68768 | 37.8023457186479 | -122.4173753605 | (37.8023457186479, -122.4173753605) | 5 | 1 | 1 | 308 | 32 | |||
| 10639 | 222877 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003276.24685 | 2105959.70039 | 37.7627493711059 | -122.43182221013 | (37.7627493711059, -122.43182221013) | 15 | 4 | 5 | 28862 | 3 | |||
| 18311 | 222868 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3665 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6005340.76956 | 2101936.52609 | 37.7518194920941 | -122.424395579917 | (37.7518194920941, -122.424395579917) | 2 | 4 | 5 | 28859 | 19 | |||
| 23578 | 188462 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6011845.31362 | 2109707.14292 | 37.7735210314987 | -122.402448188337 | (37.7735210314987, -122.402448188337) | 14 | 2 | 9 | 28853 | 34 | |||
| 25126 | 251400 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | Width 3ft | 5994375.43496 | 2086552.55756 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | 9 | 8 | 6 | 28861 | 25 | ||||
| 25953 | 205978 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 26 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5993683.84565 | 2099240.98688 | 37.7437530733501 | -122.464510801149 | (37.7437530733501, -122.464510801149) | 1 | 8 | 4 | 29491 | 40 | |||
| 31697 | 125961 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007947.13488 | 2120318.93587 | 37.802440037726 | -122.4166845058 | (37.802440037726, -122.4166845058) | 5 | 1 | 1 | 308 | 32 | |||
| 36778 | 188465 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 766 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6011787.2831 | 2109744.85419 | 37.7736213382813 | -122.402651578111 | (37.7736213382813, -122.402651578111) | 14 | 2 | 9 | 28853 | 34 | |||
| 44326 | 175834 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 5994720.17465 | 2086786.57384 | 37.7096159550821 | -122.460025390159 | (37.7096159550821, -122.460025390159) | 9 | 8 | 6 | 28861 | 25 | |||
| 48349 | 125953 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 251 Presidio Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5999000.41128 | 2115755.88881 | 37.7894038772406 | -122.447315856258 | (37.7894038772406, -122.447315856258) | 13 | 6 | 1 | 54 | 31 | |||
| 48900 | 222878 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003263.67356 | 2105959.60231 | 37.7627483890498 | -122.431865689655 | (37.7627483890498, -122.431865689655) | 15 | 4 | 5 | 28862 | 3 | |||
| 52841 | 222867 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3665 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6005333.3615 | 2101936.42428 | 37.7518187942162 | -122.424421190788 | (37.7518187942162, -122.424421190788) | 2 | 4 | 5 | 28859 | 19 | |||
| 64231 | 188461 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011834.92433 | 2109696.16508 | 37.7734903088701 | -122.40248335455 | (37.7734903088701, -122.40248335455) | 14 | 2 | 9 | 28853 | 34 | |||
| 71593 | 175832 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 4 | : | Tree | Private 2 | 5 | Width 3ft | 5994691.10568 | 2086786.70031 | 37.7096146303906 | -122.460125866041 | (37.7096146303906, -122.460125866041) | 9 | 8 | 6 | 28861 | 25 | |||
| 71955 | 188463 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6011854.34986 | 2109717.34943 | 37.7735495606877 | -122.402417648277 | (37.7735495606877, -122.402417648277) | 14 | 2 | 9 | 28853 | 34 | |||
| 73379 | 175833 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 5 | : | Tree | Private 2 | 5 | Width 3ft | 5994704.65642 | 2086785.934 | 37.709613305686 | -122.46007897717 | (37.709613305686, -122.46007897717) | 9 | 8 | 6 | 28861 | 25 | |||
| 73813 | 125965 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 960 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007714.84364 | 2120286.14045 | 37.8023369223605 | -122.417486024768 | (37.8023369223605, -122.417486024768) | 5 | 1 | 1 | 308 | 32 | |||
| 74236 | 222859 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 100 Church St | 4 | : | Tree | Private 2 | 9 | Width 3ft | 6004077.69446 | 2108250.00646 | 37.7690833988163 | -122.429213605151 | (37.7690833988163, -122.429213605151) | 7 | 9 | 5 | 28862 | 3 | |||
| 75950 | 175835 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994375.43496 | 2086552.55756 | 37.7089535675334 | -122.461199910156 | (37.7089535675334, -122.461199910156) | 9 | 8 | 6 | 28861 | 25 | |||
| 77523 | 222862 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008204.35624 | 2107957.35065 | 37.7685125829154 | -122.414918966632 | (37.7685125829154, -122.414918966632) | 8 | 4 | 7 | 28853 | 19 | |||
| 80337 | 125955 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 251 Presidio Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999006.9985 | 2115714.87548 | 37.789291641844 | -122.447290112255 | (37.789291641844, -122.447290112255) | 13 | 6 | 1 | 54 | 31 | |||
| 84919 | 188459 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 12 | : | Tree | Private 2 | 8 | Width 3ft | 6017898.8154 | 2096917.74741 | 37.7387400867836 | -122.380618860675 | (37.7387400867836, -122.380618860675) | 10 | 3 | 8 | 58 | 1 | |||
| 88567 | 188457 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6017980.56674 | 2096851.4508 | 37.7385625606061 | -122.380331593842 | (37.7385625606061, -122.380331593842) | 10 | 3 | 8 | 58 | 1 | |||
| 88876 | 188458 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1300 Evans Ave | 8 | : | Tree | Private 2 | 7 | Width 3ft | 6017965.45294 | 2096866.00027 | 37.7386016766138 | -122.38038486158 | (37.7386016766138, -122.38038486158) | 10 | 3 | 8 | 58 | 1 | |||
| 92213 | 222869 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997758.85551 | 2107160.25032 | 37.7657314672574 | -122.450991395353 | (37.7657314672574, -122.450991395353) | 15 | 5 | 11 | 29492 | 9 | |||
| 92393 | 222882 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1857 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6004605.27602 | 2097916.14759 | 37.7407388983737 | -122.426652754132 | (37.7407388983737, -122.426652754132) | 2 | 7 | 5 | 63 | 7 | |||
| 92683 | 222880 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003225.60952 | 2105960.03054 | 37.7627474070019 | -122.431997370179 | (37.7627474070019, -122.431997370179) | 15 | 4 | 5 | 28862 | 3 | |||
| 97583 | 205980 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 121 Sagamore St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5995564.77238 | 2087377.85645 | 37.7112880204943 | -122.457149074963 | (37.7112880204943, -122.457149074963) | 9 | 8 | 6 | 28861 | 24 | |||
| 103914 | 205976 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1701 Irving St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5990268.09461 | 2106501.35163 | 37.7634906193203 | -122.476851900801 | (37.7634906193203, -122.476851900801) | 1 | 8 | 3 | 56 | 12 | |||
| 104937 | 175831 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 3 | : | Tree | Private 2 | 5 | Width 3ft | 5994675.09306 | 2086785.58839 | 37.7096106562906 | -122.460181127555 | (37.7096106562906, -122.460181127555) | 9 | 8 | 6 | 28861 | 25 | |||
| 107571 | 175829 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 5994644.58104 | 2086786.22758 | 37.709610656267 | -122.460286627948 | (37.709610656267, -122.460286627948) | 9 | 8 | 6 | 28861 | 25 | |||
| 115792 | 175830 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 71 De Long St | 2 | : | Tree | Private 2 | 5 | Width 3ft | 5994659.60487 | 2086786.3953 | 37.7096119809882 | -122.460234715484 | (37.7096119809882, -122.460234715484) | 9 | 8 | 6 | 28861 | 25 | |||
| 116855 | 222881 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3844 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004001.37732 | 2104831.96458 | 37.7596939568222 | -122.429233822808 | (37.7596939568222, -122.429233822808) | 2 | 4 | 5 | 28862 | 3 | |||
| 117579 | 125963 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 954 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007766.23356 | 2120291.49428 | 37.8023545140073 | -122.417308569644 | (37.8023545140073, -122.417308569644) | 5 | 1 | 1 | 308 | 32 | |||
| 124409 | 125959 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007983.53221 | 2120324.66338 | 37.802457811042 | -122.416558958654 | (37.802457811042, -122.416558958654) | 5 | 1 | 1 | 308 | 32 | |||
| 126312 | 125956 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1047 Mason St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009450.24252 | 2117026.36812 | 37.7934838810207 | -122.411250263289 | (37.7934838810207, -122.411250263289) | 3 | 1 | 10 | 28857 | 21 | |||
| 127193 | 205979 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 44 Taraval St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993573.64628 | 2099229.5165 | 37.7437152253671 | -122.464891008423 | (37.7437152253671, -122.464891008423) | 1 | 8 | 4 | 29491 | 40 | |||
| 127308 | 125960 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 900 Lombard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007965.18699 | 2120322.02846 | 37.8024495444817 | -122.416622255608 | (37.8024495444817, -122.416622255608) | 5 | 1 | 1 | 308 | 32 | |||
| 128123 | 175839 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 728 Burrows St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009068.66668 | 2092869.3876 | 37.7271329121485 | -122.410863628551 | (37.7271329121485, -122.410863628551) | 9 | 3 | 7 | 309 | 28 | |||
| 135942 | 222863 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 75 14th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6008222.11657 | 2107958.04741 | 37.7685154940131 | -122.414857584305 | (37.7685154940131, -122.414857584305) | 8 | 4 | 7 | 28853 | 19 | |||
| 137598 | 125957 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1047 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6009453.06953 | 2117007.51923 | 37.7934322851104 | -122.411239149462 | (37.7934322851104, -122.411239149462) | 3 | 1 | 10 | 28857 | 21 | |||
| 140768 | 125958 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 941 Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007838.51696 | 2120251.34871 | 37.8022483508428 | -122.417055586769 | (37.8022483508428, -122.417055586769) | 5 | 1 | 10 | 308 | 32 | |||
| 147607 | 188460 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6011827.04267 | 2109686.99498 | 37.7734646898654 | -122.40250997357 | (37.7734646898654, -122.40250997357) | 14 | 2 | 9 | 28853 | 34 | |||
| 149476 | 125954 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 251 Presidio Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5999004.62741 | 2115731.3369 | 37.7893367050801 | -122.447299501178 | (37.7893367050801, -122.447299501178) | 13 | 6 | 1 | 54 | 31 | |||
| 158108 | 125962 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 952 Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007785.23718 | 2120295.43881 | 37.8023664138362 | -122.41724308731 | (37.8023664138362, -122.41724308731) | 5 | 1 | 1 | 308 | 32 | |||
| 162799 | 222875 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6003058.60804 | 2095498.12618 | 37.7340120027534 | -122.431827935223 | (37.7340120027534, -122.431827935223) | 2 | 7 | 5 | 63 | 7 | |||
| 168666 | 222879 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 3850 17th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003245.02631 | 2105961.0603 | 37.7627513352378 | -122.431930287959 | (37.7627513352378, -122.431930287959) | 15 | 4 | 5 | 28862 | 3 | |||
| 175081 | 188464 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 769 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6011863.90983 | 2109727.01208 | 37.7735766257899 | -122.402385258275 | (37.7735766257899, -122.402385258275) | 14 | 2 | 9 | 28853 | 34 | |||
| 177372 | 175828 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 490 Harkness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6010182.47488 | 2089702.17663 | 37.7184987999604 | -122.406790070203 | (37.7184987999604, -122.406790070203) | 10 | 7 | 8 | 309 | 39 | |||
| 180116 | 125952 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 2294 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6001994.86126 | 2118787.45338 | 37.7978984191288 | -122.437172562074 | (37.7978984191288, -122.437172562074) | 13 | 9 | 1 | 57 | 17 | |||
| 187258 | 222864 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1057 Treat Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008644.3268 | 2102383.5696 | 37.7532329691398 | -122.413002991602 | (37.7532329691398, -122.413002991602) | 2 | 4 | 7 | 28859 | 19 | |||
| 190723 | 175837 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5994356.88277 | 2086531.76861 | 37.7088954182656 | -122.461262522762 | (37.7088954182656, -122.461262522762) | 9 | 8 | 6 | 28861 | 25 | |||
| 191773 | 175838 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 101 Rhine St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 5994346.0156 | 2086520.62322 | 37.7088641902123 | -122.461299273568 | (37.7088641902123, -122.461299273568) | 9 | 8 | 6 | 28861 | 25 | |||
| 192537 | 222873 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 4354 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6000914.51326 | 2103313.56277 | 37.7553495604475 | -122.439800863126 | (37.7553495604475, -122.439800863126) | 2 | 4 | 5 | 28862 | 38 | |||
| 55650 | 222871 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 51 Gladys St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6005724.8358 | 2097421.61611 | 37.7394442577386 | -122.422746599186 | (37.7394442577386, -122.422746599186) | 2 | 7 | 7 | 28859 | 2 | |||
| 61416 | 123032 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 660 Funston Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 2ft | 5991952.29381 | 2110935.71162 | 37.7757637347805 | -122.47134996528 | (37.7757637347805, -122.47134996528) | 11 | 6 | 2 | 54 | 11 | |||
| 133095 | 222870 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 25 Prospect Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6007227.82526 | 2099384.75669 | 37.7449192898986 | -122.417689017034 | (37.7449192898986, -122.417689017034) | 2 | 7 | 7 | 28859 | 2 | |||
| 152486 | 222874 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 462 Douglass St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 2ft | 6001154.00187 | 2103552.82126 | 37.7560201354351 | -122.43898978707 | (37.7560201354351, -122.43898978707) | 2 | 4 | 5 | 28862 | 38 | |||
| 160240 | 188466 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 445 Tehama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 2ft | 6011029.5684 | 2112160.37935 | 37.7802114767035 | -122.405442792276 | (37.7802114767035, -122.405442792276) | 14 | 2 | 9 | 28853 | 34 | |||
| 59379 | 205977 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1624 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 5993106.31442 | 2104408.61975 | 37.7579087567066 | -122.466883344019 | (37.7579087567066, -122.466883344019) | 1 | 8 | 4 | 56 | 12 | |||
| 160314 | 222876 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 70 Natick St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6003060.85114 | 2095475.7145 | 37.7339505925395 | -122.431818580457 | (37.7339505925395, -122.431818580457) | 2 | 7 | 5 | 63 | 7 | |||
| 1716 | 182455 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1500 31st Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | FUF | 09/08/2020 12:00:00 AM | 3 | Width 0ft | 5986551.2997 | 2104640.4864 | 37.7581648905277 | -122.48957008427 | (37.7581648905277, -122.48957008427) | 1 | 8 | 3 | 56 | 35 | |
| 25429 | 247474 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 850 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002489.938 | 2109552.4307 | 37.7725695227328 | -122.434798704253 | (37.7725695227328, -122.434798704253) | 15 | 5 | 11 | 29492 | 9 | |||
| 56532 | 244481 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001413.516 | 2109405.0473 | 37.7721036727294 | -122.438511589285 | (37.7721036727294, -122.438511589285) | 15 | 5 | 11 | 29492 | 9 | |||
| 92772 | 244200 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 540 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6003980.524 | 2109759.8502 | 37.7732235602878 | -122.429657410606 | (37.7732235602878, -122.429657410606) | 7 | 9 | 11 | 29492 | 10 | |||
| 138124 | 247494 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002693.3039 | 2109766.0565 | 37.7731676302149 | -122.434110515465 | (37.7731676302149, -122.434110515465) | 15 | 5 | 11 | 29492 | 9 | |||
| 155577 | 184174 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1655 34th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5985601.1485 | 2103943.8243 | 37.7561965316146 | -122.492804758993 | (37.7561965316146, -122.492804758993) | 1 | 8 | 3 | 56 | 35 | |||
| 193714 | 247476 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 856 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | 15 | 5 | 11 | 29492 | 9 | |||
| 65403 | 116770 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 307 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 6x6 | 6013506.88243 | 2105617.60092 | 37.7623846762351 | -122.396413832751 | (37.7623846762351, -122.396413832751) | 10 | 3 | 8 | 28856 | 29 | |||
| 35999 | 115859 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 36425 | 115854 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 68626 | 115858 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 73325 | 115865 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 83759 | 115862 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 99443 | 115866 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 132403 | 115855 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 146222 | 115860 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 | ||||
| 147434 | 115861 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 451x KANSAS ST | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6011530 | 2106284 | 37.7641042503363 | -122.403298055195 | (37.7641042503363, -122.403298055195) | 8 | 3 | 8 | 28856 | 29 |
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) );