trees

Custom SQL query returning 101 rows (hide)

Query parameters

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