trees

484 rows where qSpecies_id = 56 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) ▼
819 20315 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 4 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
1295 19941 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 10 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
2286 20017 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
2572 20316 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 5 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
3457 20016 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY48 0 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
7537 19938 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
8170 19942 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 11 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
10058 20314 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
12313 20320 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 9 Sidewalk: Curb side : Cutout Tree DPW 1     42 60                      
13640 19939 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 8 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
17517 19940 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 STAIRWAY38 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 10ST                      
17932 20319 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 8 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
19409 20318 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 101X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     36 60                      
8037 257932 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
17952 176334 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 7 Side Yard : Yard Tree Private 2     34     6012223.87562 2087782.54699 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764) 10 3 8 309 1
36331 256763 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
45615 251302 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 1 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
64758 191722 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1100 25th St 1 Sidewalk: Curb side : Yard Tree Private 2     18     6014479.64038 2101959.5389 37.7523945096015 -122.392793471535 (37.7523945096015, -122.392793471535) 10 3 8 28856 1
112880 191737 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 2 Sidewalk: Curb side : Yard Tree Private 2     5     6010885.73151 2096220.33708 37.7364356342809 -122.404817839882 (37.7364356342809, -122.404817839882) 10 3 8 58 1
114444 176336 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 9 Side Yard : Yard Tree Private 2     31     6012249.60162 2087766.47281 37.7132991905898 -122.39950899437 (37.7132991905898, -122.39950899437) 10 3 8 309 1
119025 176335 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 287 Hester Ave 5 Side Yard : Yard Tree Private 2     17     6012233.93602 2087774.20569 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027) 10 3 8 309 1
124028 257931 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
130715 251303 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1 Cashmere St 2 Back Yard : Yard Tree Health Dept 13       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
137649 108201 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 2 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
146246 191736 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 200 Helena St 1 Sidewalk: Curb side : Yard Tree Private 2     57     6010895.57722 2096228.10312 37.7364575084979 -122.404784345514 (37.7364575084979, -122.404784345514) 10 3 8 58 1
152900 257934 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
154190 121341 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 401X Cargo Way 2 Side Yard : Yard Tree Private 2     18 3x3   6017217 2098844 37.7439915378474 -122.383110313195 (37.7439915378474, -122.383110313195) 10 3 8 58 1
165630 108200 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 90 Reuel Ct 1 Front Yard : Yard Tree Private 2         Permit Number 774102 6017404.09127 2096025.61699 37.7362631610075 -122.382267352258 (37.7362631610075, -122.382267352258) 10 3 8 58 1
170679 257933 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1039 Hudson Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6018789 2095103 37.7338062313868 -122.377415095373 (37.7338062313868, -122.377415095373) 10 3 8 58 1
173879 201514 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1001 Innes Ave 12 Front Yard : Yard Tree Private 2     75     6018663.55815 2094844.49481 37.7330895150748 -122.377830854436 (37.7330895150748, -122.377830854436) 10 3 8 58 1
177111 201510 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1001 Innes Ave 8 Front Yard : Yard Tree Private 2     38     6018594.17439 2094891.11142 37.7332136916637 -122.378073969944 (37.7332136916637, -122.378073969944) 10 3 8 58 1
168667 224263 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11 Germania St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004229.44428 2108900.23084 37.7708773466362 -122.428735070474 (37.7708773466362, -122.428735070474) 7 9 11 29492 10
170276 224264 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11 Germania St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004254.57068 2108904.38845 37.7708901844568 -122.42864845406 (37.7708901844568, -122.42864845406) 7 9 11 29492 10
7245 251144 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 3 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
8712 207757 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 8 Sidewalk: Property side : Yard Tree Private 2     24     5994806.26925 2105291.62903 37.7604312408178 -122.461068228734 (37.7604312408178, -122.461068228734) 15 5 4 56 12
10388 251145 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 200X Clarendon Ave 2 Sidewalk: Property side : Yard Tree Private 2       3x3   5996559 2104265 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022) 15 5 4 63 12
58186 105492 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1575 07TH AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 773490 5993962.3 2104771.9 37.7589555970933 -122.463949378571 (37.7589555970933, -122.463949378571) 1 8 4 56 12
59460 207755 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 6 Sidewalk: Property side : Yard Tree Private 2     43     5994788.04604 2105291.71815 37.7604304368423 -122.461131260407 (37.7604304368423, -122.461131260407) 15 5 4 56 12
66487 207756 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 7 Sidewalk: Property side : Yard Tree Private 2     49     5994800.39892 2105292.04488 37.7604320448233 -122.461088561491 (37.7604320448233, -122.461088561491) 15 5 4 56 12
77234 207754 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1364 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   5993663.75343 2106217.17575 37.7629067380829 -122.4650868556 (37.7629067380829, -122.4650868556) 1 8 11 56 12
90994 113367 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 6X Christopher Dr 1 Front Yard : Yard Tree DPW 1     25     5996701.11551 2103988.82524 37.7569629284433 -122.454420756361 (37.7569629284433, -122.454420756361) 1 5 4 63 12
111198 208961 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1575 07th Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 2ft   5993977.82871 2104681.32491 37.7587077962432 -122.463889098911 (37.7587077962432, -122.463889098911) 1 5 4 56 12
142172 207758 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 95 Kirkham St 9 Sidewalk: Property side : Yard Tree Private 2     45     5994815.67763 2105291.72467 37.7604320448236 -122.461035696659 (37.7604320448236, -122.461035696659) 15 5 4 56 12
186983 208979 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 46 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5992891.21268 2101728.13425 37.7505364203394 -122.467432335147 (37.7505364203394, -122.467432335147) 1 8 4 29491 12
74910 114400 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 3 Sidewalk: Property side : Cutout Tree Private 2     22 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
82854 114075 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 1 Sidewalk: Curb side : Yard Tree Private 2     26     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
119656 114409 Significant Tree 6 Eucalyptus globulus :: Blue Gum 56 500X ARBALLO DR 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5987859 2089716 37.7172624174607 -122.483953179035 (37.7172624174607, -122.483953179035) 1 8 4 64 14
123942 114396 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 3 Sidewalk: Curb side : Cutout Tree Private 2           5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
134035 114403 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 1X HIGUERA AVE 6 Sidewalk: Curb side : Cutout Tree Private 2     25 3x3   5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
139166 176348 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 0 Fuente Ave 2 Sidewalk: Curb side : Yard Tree Private 2     26     5989603.79735 2090546.09261 37.7196430676648 -122.477982952958 (37.7196430676648, -122.477982952958) 1 8 4 64 14
142283 114069 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 2 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     40     5988091 2090188 37.7185719141165 -122.483185851801 (37.7185719141165, -122.483185851801) 1 8 4 64 14
157123 66251 Permitted Site 7 Eucalyptus globulus :: Blue Gum 56 35 HIGUERA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2   10/24/1990 12:00:00 AM     Permit Number 29352 5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
158118 114076 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 24 HIGUERA AVE 2 Sidewalk: Curb side : Yard Tree Private 2     24     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
444 105900 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 1 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
18361 173682 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450x Raymond Ave 1 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6008515 2088365 37.7147337500707 -122.412459395375 (37.7147337500707, -122.412459395375) 9 7 8 309 18
50310 176345 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Raymond Ave 3 Sidewalk: Property side : Yard Tree Private 2     34     6008420.88631 2088405.51015 37.7148397004654 -122.412787554496 (37.7148397004654, -122.412787554496) 9 7 8 309 18
56734 173683 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450x Raymond Ave 2 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency     3x3   6008515 2088365 37.7147337500707 -122.412459395375 (37.7147337500707, -122.412459395375) 9 7 8 309 18
75661 176344 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Raymond Ave 2 Sidewalk: Property side : Yard Tree Private 2     8     6008453.92432 2088393.60062 37.7148088537086 -122.412672519523 (37.7148088537086, -122.412672519523) 9 7 8 309 18
83967 176343 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Raymond Ave 1 Sidewalk: Property side : Yard Tree Private 2     76     6008484.74111 2088383.42134 37.7147826330863 -122.412565284366 (37.7147826330863, -122.412565284366) 9 7 8 309 18
136862 105901 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 2 Unaccepted Street : Yard Tree DPW 1     30     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
189511 105902 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 11X ELLIOT ST 3 Unaccepted Street : Yard Tree DPW 1     40     6009059 2088845 37.716082244868 -122.410612975888 (37.716082244868, -122.410612975888) 9 7 8 309 18
34158 191733 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 5 Front Yard : Yard Tree Private 2     25     6009990.50539 2107548.56259 37.7674903487254 -122.408711960091 (37.7674903487254, -122.408711960091) 8 4 8 28853 19
42456 191735 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 8 Front Yard : Yard Tree Private 2     27     6010009.09697 2107534.42743 37.7674525780981 -122.408646656734 (37.7674525780981, -122.408646656734) 8 4 8 28853 19
51387 224267 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 3 Front Yard : Yard Tree Private 2     26     6011260.20343 2103721.90369 37.7570542343818 -122.40405088815 (37.7570542343818, -122.40405088815) 10 4 8 28859 19
52709 191734 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 7 Front Yard : Yard Tree Private 2     22     6009976.80194 2107534.39117 37.7674506697311 -122.408758358812 (37.7674506697311, -122.408758358812) 8 4 8 28853 19
68807 43994 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 141 Hampshire St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2000 12:00:00 AM 18   Permit Number 43551 6010001.85414 2107517.13485 37.7674046909874 -122.408670488759 (37.7674046909874, -122.408670488759) 8 4 8 28853 19
76221 224266 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 2 Front Yard : Yard Tree Private 2     28     6011271.09407 2103721.28577 37.7570531461907 -122.404013180481 (37.7570531461907, -122.404013180481) 10 4 8 28859 19
119427 191731 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 3 Front Yard : Yard Tree Private 2     24     6009975.96776 2107617.96239 37.7676800903972 -122.408767140702 (37.7676800903972, -122.408767140702) 8 4 8 28853 19
155844 191729 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 1 Front Yard : Yard Tree Private 2     24     6009963.10998 2107668.13664 37.7678171371844 -122.408815154618 (37.7678171371844, -122.408815154618) 8 4 8 28853 19
161936 191732 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 4 Front Yard : Yard Tree Private 2     18     6009982.19315 2107558.06249 37.7675159677065 -122.408741381426 (37.7675159677065, -122.408741381426) 8 4 8 28853 19
169543 224269 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 7 Front Yard : Yard Tree Private 2     23     6011241.96431 2103719.95233 37.7570478572995 -122.404113828986 (37.7570478572995, -122.404113828986) 10 4 8 28859 19
180221 191730 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 100 Hampshire St 2 Front Yard : Yard Tree Private 2     24     6009966.38063 2107638.17528 37.7677350533657 -122.408801727734 (37.7677350533657, -122.408801727734) 8 4 8 28853 19
190520 224268 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 2300 22nd St 6 Front Yard : Yard Tree Private 2     28     6011248.24436 2103720.25065 37.7570490273112 -122.40409213106 (37.7570490273112, -122.40409213106) 10 4 8 28859 19
1776 247999 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 450 Peralta Ave 3 Side Yard : Yard Tree Private 2     35     6009750 2099218 37.744603019334 -122.408955999129 (37.744603019334, -122.408955999129) 2 7 7 28859 2
4988 224247 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 701X Powhattan Ave 1 Sidewalk: Curb side : Yard Tree Private 2     46     6008745.22263 2098103.60695 37.7414868060782 -122.412351580256 (37.7414868060782, -122.412351580256) 10 7 7 28859 2
7655 224252 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 401x Powhattan Ave 4 Sidewalk: Property side : Yard Tree Private 2     35 Width 3ft   6008209.41115 2098117.01266 37.741493532991 -122.414205186423 (37.741493532991, -122.414205186423) 2 7 7 28859 2
11269 247818 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1158x Jarboe Ave 1 Unaccepted Street : Yard Tree Private 2     46     6009634.53348 2096844.36766 37.7380790724954 -122.409187798594 (37.7380790724954, -122.409187798594) 10 7 7 28859 2
15695 262389 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 67 Rosenkranz St 1 Side Yard : Yard Tree DPW 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
18334 224251 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 401X Powhattan Ave 3 Sidewalk: Property side : Yard Tree Private 2     21 Width 3ft   6008204.54136 2098121.72815 37.741506207147 -122.414222358085 (37.741506207147, -122.414222358085) 2 7 7 28859 2
20018 256139 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 888 Moultrie St 1 Unaccepted Street : Cutout Tree Private 2       3x3   6007515 2095179 37.7333873668614 -122.416398174089 (37.7333873668614, -122.416398174089) 2 7 7 28859 2
20776 247930 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 3 Side Yard : Yard Tree Private 2     18     6010384.98383 2098777.78466 37.7434298327179 -122.406729322818 (37.7434298327179, -122.406729322818) 10 7 7 28859 2
23613 248107 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 138 Rutledge St 1 Side Yard : Yard Tree Private 2     35     6010423.63855 2099478.50343 37.7453560168793 -122.406645033853 (37.7453560168793, -122.406645033853) 2 7 7 28859 2
35559 122678 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 701x Powhattan Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     36 3x3   6008711 2098131 37.741560100881 -122.412471846631 (37.741560100881, -122.412471846631) 10 7 7 28859 2
36885 246762 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 6 Front Yard : Yard Tree Private 2     38     6009259.9688 2098886.63063 37.743665689828 -122.410627040331 (37.743665689828, -122.410627040331) 2 7 7 28859 2
37673 246758 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 2 Front Yard : Yard Tree Private 2     45     6009165.37597 2098887.8964 37.7436638615084 -122.410954210088 (37.7436638615084, -122.410954210088) 2 7 7 28859 2
61418 224219 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 San Jose Ave 4 Front Yard : Yard Tree Private 2     7     6004118.53569 2095824.97349 37.7349694794509 -122.428186723249 (37.7349694794509, -122.428186723249) 2 7 5 28861 2
63828 247922 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 7 Side Yard : Yard Tree Private 2     24     6010270.94858 2098720.09099 37.7432650373678 -122.40711956383 (37.7432650373678, -122.40711956383) 10 7 7 28859 2
67100 247923 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 8 Side Yard : Yard Tree Private 2     17     6010288.87158 2098729.72842 37.7432925026595 -122.407058269637 (37.7432925026595, -122.407058269637) 10 7 7 28859 2
71078 247924 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 9 Side Yard : Yard Tree Private 2     23     6010297.69523 2098727.78354 37.7432876562154 -122.407027622545 (37.7432876562154, -122.407027622545) 10 7 7 28859 2
80374 248219 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Fair Ave 2 Side Yard : Yard Tree Private 2     38     6007128.32554 2099340.74379 37.7447928407342 -122.418029950029 (37.7447928407342, -122.418029950029) 2 7 7 28859 2
87775 246757 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 70 Waltham St 1 Front Yard : Yard Tree Private 2     27     6009117.20748 2098899.99025 37.7436943673943 -122.41112161979 (37.7436943673943, -122.41112161979) 2 7 7 28859 2
88934 247919 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 4 Side Yard : Yard Tree Private 2     22     6010242.48982 2098715.37522 37.7432504962209 -122.40721763491 (37.7432504962209, -122.40721763491) 10 7 7 28859 2
96359 122535 Undocumented 4 Eucalyptus globulus :: Blue Gum 56 199x Coso Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     21 3x3   6007478 2099565 37.7454282725128 -122.416836723884 (37.7454282725128, -122.416836723884) 2 7 7 28859 2
96951 247928 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1099 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     22     6010393.74755 2098772.89885 37.7434169076795 -122.406698675702 (37.7434169076795, -122.406698675702) 10 7 7 28859 2
97103 247917 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     32     6010231.88216 2098716.76824 37.7432537274832 -122.407254411775 (37.7432537274832, -122.407254411775) 10 7 7 28859 2
103652 247921 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1098 Esmeralda Ave 6 Side Yard : Yard Tree Private 2     38     6010260.8237 2098716.17835 37.7432537274883 -122.407154297447 (37.7432537274883, -122.407154297447) 10 7 7 28859 2
106673 256140 Property Tree 8 Eucalyptus globulus :: Blue Gum 56 892 Moultrie St 1 Side Yard : Yard Tree Private 2       3x3   6007512 2095150 37.7333075704823 -122.416406492547 (37.7333075704823, -122.416406492547) 2 7 7 28859 2
124057 224245 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 160 Coso Ave 2 Sidewalk: Curb side : Yard Tree Private 2     32     6007485.6356 2099587.10163 37.7454893881214 -122.416811886672 (37.7454893881214, -122.416811886672) 2 7 7 28859 2
128317 4837 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 127 Cortland Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6006404.24922 2097646.68025 37.7401005434118 -122.420413452032 (37.7401005434118, -122.420413452032) 2 7 7 28859 2
128484 224220 DPW Maintained 1 Eucalyptus globulus :: Blue Gum 56 1201 San Jose Ave 5 Front Yard : Yard Tree Private 2     46     6004122.93683 2095831.82479 37.7349885405914 -122.428171995061 (37.7349885405914, -122.428171995061) 2 7 5 28861 2

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