trees

3,587 rows where qSpecies_id = 28 sorted by Neighborhoods (old)

✎ View and edit SQL

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) ▼
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
100 255131 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree DPW 1                              
1723 19755 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 13 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
1845 20002 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 22 Sidewalk: Curb side : Cutout Tree DPW 1     6 2                      
2868 255125 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 3 Sidewalk: Property side : Yard Tree DPW 1                              
3319 255128 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 6 Sidewalk: Property side : Yard Tree DPW 1                              
3449 19754 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY15 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3                      
4083 19998 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 100 STAIRWAY46 18 Sidewalk: Curb side : Cutout Tree DPW 1     12 40                      
5059 255129 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 7 Sidewalk: Property side : Yard Tree DPW 1                              
5129 255126 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 4 Sidewalk: Property side : Yard Tree DPW 1                              
5510 104813 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 1601X Portola Dr 5 Front Yard : Yard Tree Private 2                              
6473 48743 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
7374 48751 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   9 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8604 48746 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
8612 255133 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 11 Sidewalk: Property side : Yard Tree DPW 1                              
8893 50823 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
9839 48748 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   6 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10173 48744 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   2 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
10238 255130 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 8 Sidewalk: Property side : Yard Tree DPW 1                              
10360 30354 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   02/17/1956 12:00:00 AM     Permit Number 43                    
10635 255127 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 5 Sidewalk: Property side : Yard Tree DPW 1                              
11935 50824 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   1 Sidewalk: Curb side : Cutout Tree Private 2   03/19/2004 12:00:00 AM     Permit Number 47344                    
12040 48742 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   10 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
12785 48747 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
12883 255123 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 1 Sidewalk: Property side : Yard Tree DPW 1                              
15071 48749 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   7 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
15641 48745 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   3 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
17595 255124 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 2 Sidewalk: Property side : Yard Tree DPW 1                              
18540 48750 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28   8 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 46023                    
19147 255132 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Brotherhood Way 10 Sidewalk: Property side : Yard Tree DPW 1                              
3464 26465 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300X Keith St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017600.4401851 2096710.4383408 37.7381543871139 -122.381636098386 (37.7381543871139, -122.381636098386) 10 3 8 58 1
5281 189460 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 400 Keith St 6 : Tree Private 2     23 Width 3ft   6017666.55512 2096787.33958 37.7383691928822 -122.38141284964 (37.7383691928822, -122.38141284964) 10 3 8 58 1
6508 14990 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Mendell St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016422.44289 2097376.45794 37.7399180286864 -122.385755471644 (37.7399180286864, -122.385755471644) 10 3 8 58 1
10052 14948 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016767.4558 2097838.85848 37.7412067724716 -122.384594749942 (37.7412067724716, -122.384594749942) 10 3 8 58 1
11953 189434 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 301 Mendell St 3 : Tree Private 2     12 Width 3ft   6016859.57023 2097844.08748 37.7412262239015 -122.384276612087 (37.7412262239015, -122.384276612087) 10 3 8 58 1
15723 105168 Significant Tree 6 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 2 Front Yard : Cutout Tree Arts Commission 19     23 3x3 Permit Number 770204 6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1
16946 189444 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 201 Mendell St 7 : Tree Private 2     18 Width 4ft   6017009.92172 2098163.28563 37.7421109895326 -122.383778964147 (37.7421109895326, -122.383778964147) 10 3 8 58 1
19665 189518 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 131 Acacia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6018139.6232 2096213.22199 37.736818885776 -122.379737317327 (37.736818885776, -122.379737317327) 10 3 8 58 1
19926 1838 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2201X Bay Shore Blvd 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6011226.77764 2087216.18178 37.7117311371657 -122.403005565662 (37.7117311371657, -122.403005565662) 10 3 8 309 1
20216 121344 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 399X Cargo Way 3 Sidewalk: Curb side : Cutout Tree DPW 1     28 3x3   6017829 2098352 37.7426744040176 -122.380959936377 (37.7426744040176, -122.380959936377) 10 3 8 58 1
20983 26458 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Keith St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017771.22225 2096841.34416 37.7385232566369 -122.381054711725 (37.7385232566369, -122.381054711725) 10 3 8 58 1
21101 189529 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 213 Acacia Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017810.85672 2096234.27169 37.7368585440828 -122.380875482215 (37.7368585440828, -122.380875482215) 10 3 8 58 1
21189 14933 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016941.57525 2098184.84614 37.7421664120423 -122.384016788063 (37.7421664120423, -122.384016788063) 10 3 8 58 1
21663 189513 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 130 Acacia Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6018133.38456 2096174.43393 37.7367120373179 -122.379756193195 (37.7367120373179, -122.379756193195) 10 3 8 58 1
21966 14887 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 151 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/28/2006 12:00:00 AM 3 3x3   6017068.53164 2098456.8281 37.7429202372855 -122.383596739007 (37.7429202372855, -122.383596739007) 10 3 8 58 1
22384 14951 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 225 Mendell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017001.18429 2098171.14482 37.7421320862857 -122.383809722815 (37.7421320862857, -122.383809722815) 10 3 8 58 1
22869 12149 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1400X La Salle Ave 29 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016248.95724 2095649.36964 37.735166191751 -122.386234942494 (37.735166191751, -122.386234942494) 10 3 8 58 1
23098 189496 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210 Acacia Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017841.42794 2096187.45373 37.736731678516 -122.380766529361 (37.736731678516, -122.380766529361) 10 3 8 58 1
23280 22237 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 4445 03rd St 6 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6015309.22014 2096468.43632 37.7373631231169 -122.389541166269 (37.7373631231169, -122.389541166269) 10 3 8 58 1
23920 189446 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 175 Mendell St 3 : Tree Private 2     28 Width 4ft   6017051.6761 2098373.04051 37.7426892419063 -122.383649189252 (37.7426892419063, -122.383649189252) 10 3 8 58 1
24017 14992 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 500 Mendell St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016399.93011 2097341.84893 37.7398217535785 -122.385830900501 (37.7398217535785, -122.385830900501) 10 3 8 58 1
24024 54655 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 280 Peninsula Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   07/27/1972 12:00:00 AM 18   Permit Number 10479 6012382.77536 2087271.8623 37.7119485104815 -122.399014002112 (37.7119485104815, -122.399014002112) 10 3 8 309 1
24625 199947 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1322 Shafter Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6016399.8746 2093108.561 37.7281979890567 -122.385536147419 (37.7281979890567, -122.385536147419) 10 3 8 58 1
24726 14899 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 160 Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6016997.24223 2098390.01536 37.7427328424729 -122.383838589425 (37.7427328424729, -122.383838589425) 10 3 8 58 1
24749 201463 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 221 Catalina St 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 5ft   6017910.15961 2096044.43658 37.736342774794 -122.380518954089 (37.736342774794, -122.380518954089) 10 3 8 58 1
25171 189501 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210 Acacia Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6017983.54314 2096181.73638 37.7367238220386 -122.380274772865 (37.7367238220386, -122.380274772865) 10 3 8 58 1
26716 26466 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300X Keith St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6017600.4401851 2096710.4383408 37.7381543871139 -122.381636098386 (37.7381543871139, -122.381636098386) 10 3 8 58 1
27332 14938 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016907.69513 2098053.92414 37.741805053675 -122.384124820925 (37.741805053675, -122.384124820925) 10 3 8 58 1
29045 54788 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 266 Tocoloma Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1972 12:00:00 AM 17   Permit Number 10637 6012648.47164 2087248.62221 37.7118995001448 -122.398094045129 (37.7118995001448, -122.398094045129) 10 3 8 309 1
29446 50634 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 2900 Jennings St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/14/2004 12:00:00 AM     Permit Number 47740 6014120.76360854 2090918.26429059 37.7220575083684 -122.393261977074 (37.7220575083684, -122.393261977074) 10 3 8 58 1
30405 189433 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 301 Mendell St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6016822.99867 2097792.72493 37.7410831705501 -122.384399488272 (37.7410831705501, -122.384399488272) 10 3 8 58 1
31310 189515 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 130 Acacia Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6018172.45187 2096173.93541 37.7367128233477 -122.379621084471 (37.7367128233477, -122.379621084471) 10 3 8 58 1
32193 189448 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 151 Mendell St 5 : Tree Private 2     27 Width 4ft   6017089.46767 2098534.02953 37.7431333739056 -122.383529720639 (37.7431333739056, -122.383529720639) 10 3 8 58 1
32440 201455 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 131 Catalina St 1 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6018178.0225 2096034.88004 37.7363313120402 -122.379592166743 (37.7363313120402, -122.379592166743) 10 3 8 58 1
33489 201470 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 300 Catalina St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6017720.50763 2095978.01132 37.7361499169812 -122.381170049779 (37.7361499169812, -122.381170049779) 10 3 8 58 1
34548 3784 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 35 Cashmere St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/31/2014 10:43:00 AM 3 3X4   6017319.3126468 2095790.6090322 37.7356131929747 -122.382544123056 (37.7356131929747, -122.382544123056) 10 3 8 58 1
35100 12154 Permitted Site 7 Corymbia ficifolia :: Red Flowering Gum 28 1400X La Salle Ave 34 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016226.76201 2095667.61701 37.7352150668321 -122.386312951947 (37.7352150668321, -122.386312951947) 10 3 8 58 1
36856 27673 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 39 Osceola Dr 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6017176.7218855 2094308.8587774 37.7315367226818 -122.382934029479 (37.7315367226818, -122.382934029479) 10 3 8 58 1
37800 26456 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 401X Keith St 4 Sidewalk: Curb side : Cutout Tree DPW 1   06/13/1997 12:00:00 AM 6 3x3   6017743.98861 2096808.93299 37.7384327587528 -122.381146620635 (37.7384327587528, -122.381146620635) 10 3 8 58 1
38666 14980 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 495X Mendell St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016593.75941 2097492.39708 37.7402458525216 -122.385171201108 (37.7402458525216, -122.385171201108) 10 3 8 58 1
38895 176008 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 280 Hester Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6012207.9471 2087849.83115 37.7135257540887 -122.399658816915 (37.7135257540887, -122.399658816915) 10 3 8 309 1
39682 14902 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 175 Mendell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017111.44356 2098535.62444 37.7431389677975 -122.383453844133 (37.7431389677975, -122.383453844133) 10 3 8 58 1
39734 189451 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 110 Mendell St 2 : Tree Private 2     12 Width 3ft   6016996.37271 2098457.91162 37.742919223749 -122.383846322475 (37.742919223749, -122.383846322475) 10 3 8 58 1
40258 121362 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 399X Cargo Way 20 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6017829 2098352 37.7426744040176 -122.380959936377 (37.7426744040176, -122.380959936377) 10 3 8 58 1
41429 12150 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1400X La Salle Ave 30 Sidewalk: Curb side : Cutout Tree DPW 1   05/17/1996 12:00:00 AM 2 3X3   6016234.16268 2095665.57813 37.735209878118 -122.386287222793 (37.735209878118, -122.386287222793) 10 3 8 58 1
41725 201465 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 221 Catalina St 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 5ft   6017857.70241 2096046.34832 37.7363451292113 -122.380700455256 (37.7363451292113, -122.380700455256) 10 3 8 58 1
42389 189495 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 210 Acacia Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6017824.48788 2096188.08048 37.7367324645202 -122.380825142688 (37.7367324645202, -122.380825142688) 10 3 8 58 1
44960 14934 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016937.56123 2098168.30957 37.7421207840608 -122.384029516163 (37.7421207840608, -122.384029516163) 10 3 8 58 1
45121 121357 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 399X Cargo Way 15 Sidewalk: Curb side : Cutout Tree DPW 1     16 3x3   6017829 2098352 37.7426744040176 -122.380959936377 (37.7426744040176, -122.380959936377) 10 3 8 58 1
46590 14983 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 495X Mendell St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016593.75941 2097492.39708 37.7402458525216 -122.385171201108 (37.7402458525216, -122.385171201108) 10 3 8 58 1
46933 201458 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 131 Catalina St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   6018111.78468 2096036.16184 37.7363311780414 -122.37982126995 (37.7363311780414, -122.37982126995) 10 3 8 58 1
47033 201457 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 131 Catalina St 3 Sidewalk: Curb side : Yard Tree Private 2     6 Width 5ft   6018132.65618 2096036.7926 37.736334061269 -122.37974915152 (37.736334061269, -122.37974915152) 10 3 8 58 1
47802 121347 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 399X Cargo Way 6 Sidewalk: Curb side : Cutout Tree DPW 1     17 3x3   6017829 2098352 37.7426744040176 -122.380959936377 (37.7426744040176, -122.380959936377) 10 3 8 58 1
49715 54763 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 158 Nueva Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/09/1972 12:00:00 AM 18   Permit Number 10612 6012922.81222 2087247.37446 37.7119113504878 -122.397145753168 (37.7119113504878, -122.397145753168) 10 3 8 309 1
49894 189430 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 3650 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6015877.12097 2098780.53074 37.7437431340426 -122.387738924624 (37.7437431340426, -122.387738924624) 10 3 8 58 1
50208 14947 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 200X Mendell St 15 Sidewalk: Curb side : Cutout Tree DPW 1     19 3X3   6016779.80003 2097854.44087 37.7412502412046 -122.384553152708 (37.7412502412046, -122.384553152708) 10 3 8 58 1
50281 189514 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 130 Acacia Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6018158.36109 2096173.36001 37.7367104662145 -122.379669762974 (37.7367104662145, -122.379669762974) 10 3 8 58 1
51176 14889 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 151 Mendell St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6017309.26732 2098441.11643 37.7428903993232 -122.382763240232 (37.7428903993232, -122.382763240232) 10 3 8 58 1
51417 4775 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 45 Commer Ct 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6016568.5126436 2094686.5715083 37.73254022254 -122.385063053335 (37.73254022254, -122.385063053335) 10 3 8 58 1
51553 189489 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 5 Cashmere St 4 Sidewalk: Curb side : Cutout Tree Private 2     29 Width 4ft   6017243.61446 2095819.28747 37.7356877562737 -122.382807838415 (37.7356877562737, -122.382807838415) 10 3 8 58 1
51784 121350 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 399X Cargo Way 9 Sidewalk: Curb side : Cutout Tree DPW 1     9 3x3   6017829 2098352 37.7426744040176 -122.380959936377 (37.7426744040176, -122.380959936377) 10 3 8 58 1
52761 189493 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1556 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 3ft   6015494.57113 2096576.90512 37.7376712317453 -122.388907886803 (37.7376712317453, -122.388907886803) 10 3 8 58 1
52772 14952 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 255 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017079.55386 2097902.22905 37.741398029861 -122.38352002608 (37.741398029861, -122.38352002608) 10 3 8 58 1
53239 14886 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 110 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/21/2008 12:00:00 AM 12 3x3   6017031.41664 2098528.69249 37.7431155108007 -122.383730076065 (37.7431155108007, -122.383730076065) 10 3 8 58 1
54227 189507 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 12 Ironwood Way 1 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6018046.04082 2096060.30667 37.7363938482047 -122.380050253535 (37.7363938482047, -122.380050253535) 10 3 8 58 1
54893 176012 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 460 Peninsula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     28 Width 4ft   6012147.1719 2086483.56891 37.7097708812792 -122.399773002936 (37.7097708812792, -122.399773002936) 10 3 8 309 1
54922 108321 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 1350X Keith St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4   6016155.336 2094757.7583 37.7327128234907 -122.386496479231 (37.7327128234907, -122.386496479231) 10 3 8 58 1
55224 14962 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 385 Mendell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016787.68352 2097759.85667 37.7409909681193 -122.384519307613 (37.7409909681193, -122.384519307613) 10 3 8 58 1
55465 199744 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 2301 Keith St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6014576.6362 2092566.7568 37.726609256129 -122.391801334681 (37.726609256129, -122.391801334681) 10 3 8 58 1
57045 105169 Property Tree 8 Corymbia ficifolia :: Red Flowering Gum 28 4755X 03RD ST 3 Front Yard : Cutout Tree Arts Commission 19     23 4x4   6015032 2095658 37.7351224553975 -122.390443042679 (37.7351224553975, -122.390443042679) 10 3 8 58 1

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);