trees
85 rows where qSpecies_id = 342
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11276 | 224168 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 4 | Front Yard : Yard | Tree | Private 2 | 15 | 6005196.72716 | 2097351.97741 | 37.7392232349721 | -122.424567616605 | (37.7392232349721, -122.424567616605) | 2 | 7 | 5 | 28859 | 7 | ||||
14504 | 224186 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 114 | Front Yard : Yard | Tree | Private 2 | 11 | 6005021.67933 | 2096895.74066 | 37.7379606245711 | -122.425140399306 | (37.7379606245711, -122.425140399306) | 2 | 7 | 5 | 63 | 7 | ||||
15798 | 224162 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 46 | Front Yard : Yard | Tree | Private 2 | 28 | 6005300.77911 | 2097165.72139 | 37.7387176936575 | -122.42419460841 | (37.7387176936575, -122.42419460841) | 2 | 7 | 5 | 28859 | 2 | ||||
20281 | 224164 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 52 | Front Yard : Yard | Tree | Private 2 | 29 | 6005313.41335 | 2097243.15255 | 37.7389310155447 | -122.42415643038 | (37.7389310155447, -122.42415643038) | 2 | 7 | 5 | 28859 | 2 | ||||
22065 | 140562 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 50 FRIENDSHIP CT | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003698.0051 | 2111675.0182 | 37.778466137811 | -122.430771378102 | (37.778466137811, -122.430771378102) | 15 | 9 | 11 | 29492 | 41 | |||
28253 | 224167 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 55 | Front Yard : Yard | Tree | Private 2 | 12 | 6005322.68661 | 2097288.32306 | 37.7390555671726 | -122.424127579224 | (37.7390555671726, -122.424127579224) | 2 | 7 | 5 | 28859 | 2 | ||||
32046 | 224170 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 26 | 6005176.87602 | 2097331.19848 | 37.7391650596173 | -122.424634775269 | (37.7391650596173, -122.424634775269) | 2 | 7 | 5 | 28859 | 7 | ||||
34444 | 224165 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 53 | Front Yard : Yard | Tree | Private 2 | 22 | 6005321.90882 | 2097262.13604 | 37.7389836196021 | -122.424128406627 | (37.7389836196021, -122.424128406627) | 2 | 7 | 5 | 28859 | 2 | ||||
34598 | 224194 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 2225 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6008175.61352 | 2105396.16244 | 37.7614785391143 | -122.41483709778 | (37.7614785391143, -122.41483709778) | 2 | 4 | 7 | 28859 | 19 | |||
39829 | 224158 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 34 | Front Yard : Yard | Tree | Private 2 | 18 | 6005277.24886 | 2097096.91085 | 37.7385274267852 | -122.424271072354 | (37.7385274267852, -122.424271072354) | 2 | 7 | 5 | 28859 | 2 | ||||
49865 | 224166 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 54 | Front Yard : Yard | Tree | Private 2 | 23 | 6005319.06099 | 2097274.78712 | 37.7390181958231 | -122.424139152593 | (37.7390181958231, -122.424139152593) | 2 | 7 | 5 | 28859 | 2 | ||||
56586 | 201540 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 601 Innes Ave | 9 | Front Yard : Yard | Tree | Private 2 | 15 | 6020451.57641 | 2093498.37325 | 37.729491685489 | -122.371556038992 | (37.729491685489, -122.371556038992) | 10 | 3 | 8 | 58 | 1 | ||||
60074 | 98947 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 7 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
63678 | 224156 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 31 | Front Yard : Yard | Tree | Private 2 | 24 | 6005265.82753 | 2097067.08344 | 37.7384448825138 | -122.424308441006 | (37.7384448825138, -122.424308441006) | 2 | 7 | 5 | 28859 | 2 | ||||
65350 | 217814 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1x Junipero Serra Blvd | 1 | Median : Yard | Tree | DPW 1 | 39 | 5991642.1645 | 2095884.13354 | 37.734418100596 | -122.47132584741 | (37.734418100596, -122.47132584741) | 1 | 8 | 4 | 59 | 40 | ||||
67511 | 224187 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 116 | Front Yard : Yard | Tree | Private 2 | 30 | 6004997.70734 | 2096883.03935 | 37.7379243953992 | -122.425222378807 | (37.7379243953992, -122.425222378807) | 2 | 7 | 5 | 63 | 7 | ||||
67653 | 224145 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 3 | Front Yard : Yard | Tree | Private 2 | 19 | 6005225.59899 | 2097508.48475 | 37.7396545992744 | -122.424478920077 | (37.7396545992744, -122.424478920077) | 2 | 7 | 5 | 28859 | 7 | ||||
68919 | 224146 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 5 | Front Yard : Yard | Tree | Private 2 | 27 | 6005217.03419 | 2097472.38406 | 37.739554991259 | -122.424505966303 | (37.739554991259, -122.424505966303) | 2 | 7 | 5 | 28859 | 7 | ||||
75889 | 224153 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 14 | 6005254.46527 | 2097034.26055 | 37.7383541166515 | -122.424345392346 | (37.7383541166515, -122.424345392346) | 2 | 7 | 5 | 28859 | 2 | ||||
79137 | 224147 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 9 | 6005213.24935 | 2097462.22432 | 37.7395268811665 | -122.424518330164 | (37.7395268811665, -122.424518330164) | 2 | 7 | 5 | 28859 | 7 | ||||
79549 | 224176 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 24 | Front Yard : Yard | Tree | Private 2 | 47 | 6005145.89638 | 2097244.79572 | 37.738926067473 | -122.424735743967 | (37.738926067473, -122.424735743967) | 2 | 7 | 5 | 28859 | 7 | ||||
82220 | 224169 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 6 | Front Yard : Yard | Tree | Private 2 | 16 | 6005180.12445 | 2097345.47549 | 37.7392044445233 | -122.424624558983 | (37.7392044445233, -122.424624558983) | 2 | 7 | 5 | 28859 | 7 | ||||
84257 | 191720 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 347 San Bruno Ave | 1 | Front Yard : Yard | Tree | Private 2 | 16 | 6010935.60067 | 2106668.2935 | 37.7651262181339 | -122.40538098547 | (37.7651262181339, -122.40538098547) | 8 | 4 | 8 | 28853 | 19 | ||||
85051 | 224143 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 1 | Front Yard : Yard | Tree | Private 2 | 47 | Width 8ft | 6005228.63249 | 2097540.97061 | 37.7397439694151 | -122.424470741631 | (37.7397439694151, -122.424470741631) | 2 | 7 | 5 | 63 | 7 | |||
85614 | 126580 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 641 Hayes St | 1 | : | Tree | Private 2 | 14 | Width 4ft | 6004785.6384 | 2110864.8252 | 37.7763031076359 | -122.426951124001 | (37.7763031076359, -122.426951124001) | 7 | 9 | 11 | 28852 | 10 | |||
90652 | 224178 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 71 | Front Yard : Yard | Tree | Private 2 | 29 | 6005061.63649 | 2097066.04261 | 37.7384304924721 | -122.425014361121 | (37.7384304924721, -122.425014361121) | 2 | 7 | 5 | 63 | 7 | ||||
90807 | 224160 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 39 | Front Yard : Yard | Tree | Private 2 | 36 | 6005289.79018 | 2097128.15539 | 37.7386139254032 | -122.424229931984 | (37.7386139254032, -122.424229931984) | 2 | 7 | 5 | 28859 | 2 | ||||
92383 | 224171 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 10 | Front Yard : Yard | Tree | Private 2 | 21 | 6005186.5177 | 2097320.17892 | 37.7391353469165 | -122.424600655002 | (37.7391353469165, -122.424600655002) | 2 | 7 | 5 | 28859 | 7 | ||||
92951 | 4899 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 15 Beatrice Ln | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018011.4321332 | 2094063.1260405 | 37.7309080736078 | -122.380031174991 | (37.7309080736078, -122.380031174991) | 10 | 3 | 8 | 58 | 1 | |||
93341 | 207751 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 85 Santa Clara Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 19 | Width 10ft | 5993313.21582 | 2096962.37597 | 37.7374752083007 | -122.465626831936 | (37.7374752083007, -122.465626831936) | 1 | 8 | 4 | 59 | 40 | |||
98132 | 224193 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 2225 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 4ft | 6008187.76273 | 2105171.00978 | 37.7608610043537 | -122.414779143636 | (37.7608610043537, -122.414779143636) | 2 | 4 | 7 | 28859 | 19 | |||
100147 | 191718 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 75 Sheridan St | 1 | : | Tree | Private 2 | 4 | Width 3ft | 6009227.35445 | 2109332.40911 | 37.7723456040855 | -122.411477649676 | (37.7723456040855, -122.411477649676) | 8 | 2 | 9 | 28853 | 34 | |||
100705 | 247578 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 300x Alemany Blvd | 2 | Median : Yard | Tree | DPW 1 | 43 | 6008699.14197 | 2095317.61632 | 37.733834496346 | -122.412314043462 | (37.733834496346, -122.412314043462) | 9 | 7 | 7 | 28859 | 2 | ||||
107977 | 217773 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 470 West Portal Ave | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 22 | 5991489.41962 | 2096094.44039 | 37.7349867131592 | -122.471869253786 | (37.7349867131592, -122.471869253786) | 1 | 8 | 4 | 29491 | 40 | ||||
108767 | 224175 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 15 | Front Yard : Yard | Tree | Private 2 | 32 | 6005162.03275 | 2097288.22011 | 37.7390462124081 | -122.424683040083 | (37.7390462124081, -122.424683040083) | 2 | 7 | 5 | 28859 | 7 | ||||
110042 | 224149 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 18 | Front Yard : Yard | Tree | Private 2 | 19 | 6005218.4143 | 2096950.28714 | 37.7381215087866 | -122.42446406776 | (37.7381215087866, -122.42446406776) | 2 | 7 | 5 | 28859 | 2 | ||||
111565 | 106793 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 199X ARLINGTON ST | 49 | Median : Cutout | Tree | DPW 1 | 9 | 6005045 | 2097131 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | 2 | 7 | 5 | 63 | 7 | ||||
111691 | 224190 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 121 | Front Yard : Yard | Tree | Private 2 | 5 | 6004977.04425 | 2096823.5682 | 37.7377599336767 | -122.425289590543 | (37.7377599336767, -122.425289590543) | 2 | 7 | 5 | 63 | 7 | ||||
112102 | 224182 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 88 | Front Yard : Yard | Tree | Private 2 | 8 | 6005012.77869 | 2096942.55547 | 37.7380886646675 | -122.42517450342 | (37.7380886646675, -122.42517450342) | 2 | 7 | 5 | 63 | 7 | ||||
113104 | 10822 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1139X Hudson Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6017749.90001 | 2094652.60701 | 37.7325122409909 | -122.380976310482 | (37.7325122409909, -122.380976310482) | 10 | 3 | 8 | 58 | 1 | |||
114980 | 224183 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 103 | Front Yard : Yard | Tree | Private 2 | 35 | 6005049.34094 | 2096969.13034 | 37.7381636986871 | -122.425049979695 | (37.7381636986871, -122.425049979695) | 2 | 7 | 5 | 63 | 7 | ||||
115385 | 224151 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 22 | Front Yard : Yard | Tree | Private 2 | 13 | 6005242.25427 | 2097000.59076 | 37.7382609774519 | -122.424385217901 | (37.7382609774519, -122.424385217901) | 2 | 7 | 5 | 28859 | 2 | ||||
115746 | 224191 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 122 | Front Yard : Yard | Tree | Private 2 | 3 | 6005002.17778 | 2096858.81533 | 37.7378581342538 | -122.425205199076 | (37.7378581342538, -122.425205199076) | 2 | 7 | 5 | 63 | 7 | ||||
116176 | 107435 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 418 19th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Dept of Real Estate | 32 | 3x3 | 5990007.15475 | 2112492.97382 | 37.7799268338278 | -122.478192501966 | (37.7799268338278, -122.478192501966) | 11 | 6 | 2 | 55 | 26 | ||
118104 | 224148 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 8 | Front Yard : Yard | Tree | Private 2 | 30 | 6005206.54925 | 2097441.52928 | 37.7394696788827 | -122.424540024521 | (37.7394696788827, -122.424540024521) | 2 | 7 | 5 | 28859 | 7 | ||||
118213 | 202062 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1 Hwy 101 S On Ramp | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | Width 9ft | 6012907.59941 | 2090167.98565 | 37.7199299208095 | -122.397403024054 | (37.7199299208095, -122.397403024054) | 10 | 3 | 8 | 58 | 1 | |||
120091 | 224181 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 80 | Front Yard : Yard | Tree | Private 2 | 9 | 6005034.65052 | 2097002.30081 | 37.7382539474614 | -122.425103131407 | (37.7382539474614, -122.425103131407) | 2 | 7 | 5 | 63 | 7 | ||||
122078 | 224173 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 12 | Front Yard : Yard | Tree | Private 2 | 13 | 6005172.79089 | 2097320.31387 | 37.7391349422206 | -122.424648125733 | (37.7391349422206, -122.424648125733) | 2 | 7 | 5 | 28859 | 7 | ||||
122857 | 224154 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 27 | Front Yard : Yard | Tree | Private 2 | 16 | 6005257.81407 | 2097043.24951 | 37.7383789874109 | -122.424334452981 | (37.7383789874109, -122.424334452981) | 2 | 7 | 5 | 28859 | 2 | ||||
127787 | 224159 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 36 | Front Yard : Yard | Tree | Private 2 | 14 | 6005282.42958 | 2097112.86963 | 37.738571538533 | -122.424254294602 | (37.738571538533, -122.424254294602) | 2 | 7 | 5 | 28859 | 2 | ||||
128156 | 12045 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1250X La Salle Ave | 27 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | |||
128770 | 224188 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 117 | Front Yard : Yard | Tree | Private 2 | 15 | 6005014.01111 | 2096876.39929 | 37.7379070843395 | -122.425165536288 | (37.7379070843395, -122.425165536288) | 2 | 7 | 5 | 63 | 7 | ||||
136483 | 224155 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 29 | Front Yard : Yard | Tree | Private 2 | 12 | 6005261.11834 | 2097051.37634 | 37.7384014884399 | -122.424323606271 | (37.7384014884399, -122.424323606271) | 2 | 7 | 5 | 28859 | 2 | ||||
136555 | 224152 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 24 | Front Yard : Yard | Tree | Private 2 | 39 | 6005249.86613 | 2097022.14713 | 37.7383205962226 | -122.424360432602 | (37.7383205962226, -122.424360432602) | 2 | 7 | 5 | 28859 | 2 | ||||
137234 | 207752 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 301 Santa Clara Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 37 | Width 10ft | 5993138.90515 | 2095971.95987 | 37.7347457173476 | -122.466157547934 | (37.7347457173476, -122.466157547934) | 9 | 8 | 4 | 59 | 40 | |||
142829 | 126579 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 430 Spruce St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 2ft | 5997231.05437 | 2114862.97961 | 37.7868509240779 | -122.453373105896 | (37.7868509240779, -122.453373105896) | 11 | 6 | 1 | 54 | 31 | |||
144354 | 224179 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 75 | Front Yard : Yard | Tree | Private 2 | 16 | 6005053.30155 | 2097043.93815 | 37.7383693277877 | -122.425041607006 | (37.7383693277877, -122.425041607006) | 2 | 7 | 5 | 63 | 7 | ||||
147668 | 224161 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 42 | Front Yard : Yard | Tree | Private 2 | 30 | 6005298.24567 | 2097155.96857 | 37.7386907715633 | -122.424202674429 | (37.7386907715633, -122.424202674429) | 2 | 7 | 5 | 28859 | 2 | ||||
149141 | 224185 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 113 | Front Yard : Yard | Tree | Private 2 | 13 | 6005009.48199 | 2096913.00579 | 37.7380073416725 | -122.425183799719 | (37.7380073416725, -122.425183799719) | 2 | 7 | 5 | 63 | 7 | ||||
151977 | 224157 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 32 | Front Yard : Yard | Tree | Private 2 | 17 | 6005270.06313 | 2097077.82282 | 37.7384746096031 | -122.424294559949 | (37.7384746096031, -122.424294559949) | 2 | 7 | 5 | 28859 | 2 | ||||
154603 | 201539 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 601 Innes Ave | 8 | Front Yard : Yard | Tree | Private 2 | 19 | 6020431.26381 | 2093508.99897 | 37.7295197461253 | -122.371626997282 | (37.7295197461253, -122.371626997282) | 10 | 3 | 8 | 58 | 1 | ||||
155098 | 224184 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 108 | Front Yard : Yard | Tree | Private 2 | 29 | 6005030.14843 | 2096951.46948 | 37.7381141217706 | -122.425115081608 | (37.7381141217706, -122.425115081608) | 2 | 7 | 5 | 63 | 7 | ||||
156354 | 202063 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1 Hwy 101 S On Ramp | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 9ft | 6012938.96015 | 2090178.72082 | 37.7199611434755 | -122.3972953725 | (37.7199611434755, -122.3972953725) | 10 | 3 | 8 | 58 | 1 | |||
161791 | 224172 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 11 | Front Yard : Yard | Tree | Private 2 | 8 | 6005187.68118 | 2097311.50559 | 37.7391115976179 | -122.424596015405 | (37.7391115976179, -122.424596015405) | 2 | 7 | 5 | 28859 | 7 | ||||
164545 | 224174 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 13 | Front Yard : Yard | Tree | Private 2 | 21 | 6005169.04255 | 2097308.79446 | 37.7391031008258 | -122.424660266574 | (37.7391031008258, -122.424660266574) | 2 | 7 | 5 | 28859 | 7 | ||||
166444 | 191719 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 347 San Bruno Ave | 2 | Front Yard : Yard | Tree | Private 2 | 18 | 6010935.25482 | 2106677.51067 | 37.7651515070597 | -122.405382830852 | (37.7651515070597, -122.405382830852) | 8 | 4 | 8 | 28853 | 19 | ||||
166611 | 202064 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1 Hwy 101 S On Ramp | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | Width 9ft | 6012962.66083 | 2090186.66523 | 37.7199842767271 | -122.397214003644 | (37.7199842767271, -122.397214003644) | 10 | 3 | 8 | 58 | 1 | |||
167475 | 114995 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 199x ARLINGTON ST | 44 | Median : Cutout | Tree | DPW 1 | 20 | 3x3 | 6005045 | 2097131 | 37.7386079110333 | -122.425076502639 | (37.7386079110333, -122.425076502639) | 2 | 7 | 5 | 63 | 7 | |||
168973 | 224195 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 2225 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 4ft | 6008171.99351 | 2105432.87403 | 37.7615791372817 | -122.414852216256 | (37.7615791372817, -122.414852216256) | 2 | 4 | 7 | 28859 | 19 | |||
169904 | 224150 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 20 | Front Yard : Yard | Tree | Private 2 | 24 | 6005234.008 | 2096984.22045 | 37.7382155626033 | -122.424412565406 | (37.7382155626033, -122.424412565406) | 2 | 7 | 5 | 28859 | 2 | ||||
176793 | 98949 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 401 Grove St | 9 | Front Yard : Yard | Tree | Private 2 | 6005778.2 | 2111279 | 37.7774964045324 | -122.423547027313 | (37.7774964045324, -122.423547027313) | 7 | 9 | 11 | 28852 | 10 | |||||
177819 | 224177 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 26 | Front Yard : Yard | Tree | Private 2 | 26 | 6005139.54292 | 2097232.52287 | 37.7388920101547 | -122.424756838454 | (37.7388920101547, -122.424756838454) | 2 | 7 | 5 | 63 | 7 | ||||
179237 | 115750 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
179411 | 12047 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1250X La Salle Ave | 29 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6017218.4556902 | 2094518.641349 | 37.7321150500381 | -122.382804339533 | (37.7321150500381, -122.382804339533) | 10 | 3 | 8 | 58 | 1 | |||
179970 | 224189 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 119 | Front Yard : Yard | Tree | Private 2 | 31 | 6004983.70643 | 2096876.20955 | 37.737904851335 | -122.425270300995 | (37.737904851335, -122.425270300995) | 2 | 7 | 5 | 63 | 7 | ||||
180538 | 116957 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 10x Yerba Buena Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5993642.27748 | 2097056.19499 | 37.7377517864641 | -122.46449593033 | (37.7377517864641, -122.46449593033) | 1 | 8 | 4 | 59 | 40 | |||||
181161 | 224192 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1200 San Jose Ave | 7 | Front Yard : Yard | Tree | Private 2 | 23 | Width 9ft | 6004059.13086 | 2095959.78716 | 37.7353362859469 | -122.428401712471 | (37.7353362859469, -122.428401712471) | 2 | 7 | 5 | 28861 | 7 | |||
182061 | 224180 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 79 | Front Yard : Yard | Tree | Private 2 | 18 | 6005045.53711 | 2097024.85946 | 37.7383165034054 | -122.425067095563 | (37.7383165034054, -122.425067095563) | 2 | 7 | 5 | 63 | 7 | ||||
186574 | 11206 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001X Ingalls St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X4 | 6018170.9910099 | 2094117.1281791 | 37.7310651541831 | -122.379483297777 | (37.7310651541831, -122.379483297777) | 10 | 3 | 8 | 58 | 1 | |||
187330 | 202066 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1 Hwy 101 S On Ramp | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | Width 9ft | 6012981.8772 | 2090193.58175 | 37.7200043379011 | -122.39714806353 | (37.7200043379011, -122.39714806353) | 10 | 3 | 8 | 58 | 1 | |||
188246 | 115749 | Significant Tree 6 | Eucalyptus camaldulensis :: River Red Gum 342 | 100 Yerba Buena Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5994139.5 | 2096643.4 | 37.7366470041966 | -122.462746867769 | (37.7366470041966, -122.462746867769) | 9 | 8 | 4 | 59 | 40 | |||||
188450 | 194257 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 250 10th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2018 12:00:00 AM | 3 | Width 3ft | 6008632.52119 | 2109679.15079 | 37.7732642930403 | -122.413559768166 | (37.7732642930403, -122.413559768166) | 8 | 2 | 9 | 28853 | 34 | ||
188744 | 224144 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1000 San Jose Ave | 2 | Front Yard : Yard | Tree | Private 2 | 26 | Width 8ft | 6005224.54254 | 2097524.65139 | 37.7396989295563 | -122.424483722467 | (37.7396989295563, -122.424483722467) | 2 | 7 | 5 | 63 | 7 | |||
192025 | 224163 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 1001 San Jose Ave | 51 | Front Yard : Yard | Tree | Private 2 | 17 | 6005311.47546 | 2097220.22735 | 37.738867958693 | -122.424161500755 | (37.738867958693, -122.424161500755) | 2 | 7 | 5 | 28859 | 2 | ||||
192370 | 207753 | DPW Maintained 1 | Eucalyptus camaldulensis :: River Red Gum 342 | 601 Saint Francis Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 31 | Width 8ft | 5993435.94824 | 2096116.49805 | 37.7351597166396 | -122.465141071201 | (37.7351597166396, -122.465141071201) | 1 | 8 | 4 | 59 | 40 |
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) );