2,984 rows where qSpecies_id = 44 sorted by Fire Prevention Districts descending

View and edit SQL

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)
1726 179199 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 65 Blythdale Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   6006710.21835 2086918.77417 37.710661269476 -122.41859498419 (37.710661269476, -122.41859498419) 9 7 8 309 39
2406 71438 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 671 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6003019.09073 2089456.91868 37.717421959831 -122.431533418034 (37.717421959831, -122.431533418034) 9 7 6 28861 5
2510 179262 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 705 Peru Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6005334.00984 2092468.15203 37.7258210881568 -122.423745792743 (37.7258210881568, -122.423745792743) 9 7 7 309 5
2773 71586 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 121 Goethe St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9 3x3   5994945.16185 2086428.98532 37.7086470380903 -122.459221923276 (37.7086470380903, -122.459221923276) 9 8 6 28861 25
3349 179251 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 689 Athens St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6002976.09571 2089391.08009 37.7172387445483 -122.431677333844 (37.7172387445483, -122.431677333844) 9 7 6 28861 5
3515 40789 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 27 Urbano Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/16/1999 12:00:00 AM     Permit Number 41740 5993852.22414759 2092279.20351858 37.7246474428237 -122.463423485902 (37.7246474428237, -122.463423485902) 9 8 4 59 40
3653 16338 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 862X Monterey Blvd 8 Median : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 5   5996505.10477 2094713.35848 37.7314835390346 -122.454428620411 (37.7314835390346, -122.454428620411) 9 7 4 59 40
4750 113090 Section 806 (d) 5 Pyrus calleryana :: Ornamental Pear 44 1213 Silver Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/2015 12:00:00 AM 3 3x3   6008675.52728 2094042.60872 37.7303322746045 -122.41230559973 (37.7303322746045, -122.41230559973) 9 3 7 309 28
5879 213844 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 15 Cresta Vista Dr 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5995181.09817 2096185.33307 37.7354492003227 -122.459112479366 (37.7354492003227, -122.459112479366) 9 7 4 59 40
6156 49713 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 20 Arco Way 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2003 12:00:00 AM     Permit Number 46525 5999460.35062419 2093111.47695612 37.7272541884473 -122.444096744934 (37.7272541884473, -122.444096744934) 9 7 6 28861 25
6448 71319 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 582 Moscow St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003518.59818 2089824.00632 37.7184582009508 -122.429833021282 (37.7184582009508, -122.429833021282) 9 7 6 28861 5
6515 16335 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 862X Monterey Blvd 5 Median : Cutout Tree DPW 1   04/22/2008 12:00:00 AM 3 5   5996588.55754 2094717.49275 37.7314996764704 -122.454140408353 (37.7314996764704, -122.454140408353) 9 7 4 59 40
6761 179217 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 2055 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6005575.94717 2088046.16302 37.7136929155569 -122.42259534402 (37.7136929155569, -122.42259534402) 9 7 8 309 18
8536 65203 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 319 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/24/1989 12:00:00 AM 13 6x7 Permit Number 27189 6003782.01447 2091682.57324 37.7235763299662 -122.429054942226 (37.7235763299662, -122.429054942226) 9 7 6 28861 5
9150 179209 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1772 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   6006471.88428 2087727.6982 37.7128689836826 -122.419476073376 (37.7128689836826, -122.419476073376) 9 7 8 309 39
9962 36495 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 98 Westwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39378 5995169.4338934 2093305.35572926 37.7275408124282 -122.458944352189 (37.7275408124282, -122.458944352189) 9 7 4 28861 40
10073 72254 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 435 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   10     6003385.22958 2091049.68788 37.7218160986223 -122.430381423381 (37.7218160986223, -122.430381423381) 9 7 6 28861 5
10349 73404 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1817 Silliman St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   11     6005442.66502 2092673.38524 37.7263907466339 -122.423384762607 (37.7263907466339, -122.423384762607) 9 7 7 309 5
10597 16342 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 890X Monterey Blvd 4 Median : Cutout Tree DPW 1     6 5   5996198.48565 2094691.84744 37.7314068853067 -122.455487100866 (37.7314068853067, -122.455487100866) 9 7 4 59 40
11179 31164 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 543 Ramsell St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 5   Permit Number 34865 5992980.10658 2090785.65178 37.7204962284105 -122.46632976451 (37.7204962284105, -122.46632976451) 9 8 6 64 24
12032 213817 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 385 Bright St 3 : Tree Private 2     1 Width 3ft   5993748.87526 2089757.7092 37.7177180733139 -122.463597832781 (37.7177180733139, -122.463597832781) 9 8 6 64 24
13466 213778 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401x Monterey Blvd 13 Median : Cutout Tree DPW 1     12 Width 4ft   5998914.18909 2094690.21596 37.7315578635039 -122.446098323489 (37.7315578635039, -122.446098323489) 9 7 4 59 40
13598 16007 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 1 Median : Cutout Tree DPW 1     16 8   6001364.53052 2094649.25854 37.7315850293086 -122.437624100898 (37.7315850293086, -122.437624100898) 9 7 4 63 40
13637 264750 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 190 Hahn St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007495 2087369 37.7119416475568 -122.415914457568 (37.7119416475568, -122.415914457568) 9 7 8 309 39
15170 16113 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 300X Monterey Blvd 11 Median : Cutout Tree DPW 1   04/24/1998 12:00:00 AM 3 5   5999657.47743 2094677.00137 37.7315639977654 -122.443527690574 (37.7315639977654, -122.443527690574) 9 7 4 63 40
16119 40698 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 100 Oxford St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/10/1999 12:00:00 AM     Permit Number 41678 6006308.40202986 2093422.77537775 37.7284972327963 -122.420445112942 (37.7284972327963, -122.420445112942) 9 7 7 309 5
17520 213830 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 30 Valdez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996396.4936 2093898.82307 37.7292407908227 -122.454745280694 (37.7292407908227, -122.454745280694) 9 7 4 28861 40
18036 72269 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 550 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     6003171.66265 2090288.8451 37.719714892907 -122.431065391947 (37.719714892907, -122.431065391947) 9 7 6 28861 5
18256 59759 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 351 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/14/1981 12:00:00 AM 5   Permit Number 19197 6003911.2246 2091379.68793 37.722751987086 -122.428586705712 (37.722751987086, -122.428586705712) 9 7 6 28861 5
19056 88335 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 554 Naples St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/2008 12:00:00 AM 7 3x3 Permit Number 51323 6002930.31412 2090411.63192 37.7200383592665 -122.431908410163 (37.7200383592665, -122.431908410163) 9 7 6 28861 5
19578 264751 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 190 Hahn St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6007495 2087369 37.7119416475568 -122.415914457568 (37.7119416475568, -122.415914457568) 9 7 8 309 39
20854 112967 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 701 Sunnydale Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009490.41259 2086583.85945 37.7098977936089 -122.408962356547 (37.7098977936089, -122.408962356547) 9 7 8 309 39
21163 179247 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 353 Prague St 1 Sidewalk: Curb side : Pot Tree Private 2     11 Width 3ft   6003781.05276 2089121.49913 37.7165441288874 -122.428875768522 (37.7165441288874, -122.428875768522) 9 7 6 28861 5
21440 16115 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 300X Monterey Blvd 13 Median : Cutout Tree DPW 1   04/24/1998 12:00:00 AM 3 5   5999569.73094 2094680.41978 37.7315683792686 -122.443831291781 (37.7315683792686, -122.443831291781) 9 7 4 63 40
22274 187491 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 750 Velasco Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3     6006526.88476 2086669.88596 37.7099675513223 -122.419210983794 (37.7099675513223, -122.419210983794) 9 7 8 309 39
23143 36490 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 95 Westwood Dr 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39377 5995116.30141704 2093273.83949404 37.7274512220857 -122.459125749197 (37.7274512220857, -122.459125749197) 9 7 4 28861 40
23832 159219 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 366 Ellington Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   10/05/2017 09:32:00 AM 3 Width 0ft   5998673.37335 2087760.724 37.7125173271842 -122.446432534932 (37.7125173271842, -122.446432534932) 9 7 6 28861 25
23980 213788 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 409 Edna St 4 Sidewalk: Property side : Yard Tree Private 2     4     5998741.33387 2094177.61147 37.7301404995723 -122.446659047172 (37.7301404995723, -122.446659047172) 9 7 4 28861 40
24132 213828 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 15 Valdez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5996363.06932 2093853.42788 37.729114229233 -122.454857552056 (37.729114229233, -122.454857552056) 9 7 4 28861 40
24184 179246 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 542 London St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6001466.17705 2090619.88816 37.7205270733374 -122.436984324988 (37.7205270733374, -122.436984324988) 9 7 6 28861 5
24561 40408 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 1434 Plymouth Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/03/1999 12:00:00 AM     Permit Number 41510 5995916.82585047 2093587.1639469 37.7283575243545 -122.45638099687 (37.7283575243545, -122.45638099687) 9 7 4 28861 40
25565 213780 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401 Detroit St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5999412.88001 2094425.91408 37.730860618202 -122.444355271001 (37.730860618202, -122.444355271001) 9 7 4 59 40
25944 216706 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 231 Faxon Ave 1 Sidewalk: Curb side : Yard Tree Private 2   10/06/2017 08:40:00 AM 3 Width 3ft   5994712.86869 2090137.86358 37.7188173847876 -122.460293291921 (37.7188173847876, -122.460293291921) 9 8 6 28861 24
26953 213801 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 25 Josiah Ave 1 : Tree Private 2     5 Width 3ft   5996904.0394 2089968.34068 37.718477713562 -122.452707098549 (37.718477713562, -122.452707098549) 9 8 6 28861 24
28587 34529 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 426 Vienna St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/22/1997 12:00:00 AM 9   Permit Number 38238 6003601.04008 2090970.70967 37.7216114641874 -122.429629792483 (37.7216114641874, -122.429629792483) 9 7 6 28861 5
28864 179222 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1825 Sunnydale Ave 1 Sidewalk: Property side : Yard Tree Private 2     14 Width 10ft   6006153.59555 2087799.59528 37.7130484649775 -122.420581285317 (37.7130484649775, -122.420581285317) 9 7 8 309 39
29357 112968 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 701 Sunnydale Ave 8 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009509.44133 2086572.73329 37.7098683093484 -122.408895804893 (37.7098683093484, -122.408895804893) 9 7 8 309 39
30761 27346 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 13 Median : Cutout Tree DPW 1   06/06/2018 12:00:00 AM 3 4   6000818.28486 2094659.29899 37.7315815246675 -122.439513294113 (37.7315815246675, -122.439513294113) 9 7 4 63 40
32119 179245 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 917 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6001629.43176 2088767.70804 37.7154506782843 -122.436287521258 (37.7154506782843, -122.436287521258) 9 7 6 28861 5
32704 179253 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 670 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6002287.48871 2089896.42298 37.7185872473948 -122.434093625141 (37.7185872473948, -122.434093625141) 9 7 6 28861 5
32795 16016 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 10 Median : Cutout Tree DPW 1     3 4   6000925.30606 2094658.03828 37.7315841533775 -122.43914321141 (37.7315841533775, -122.43914321141) 9 7 4 63 40
32825 213802 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 225 Lakeview Ave 1 : Tree Private 2     3 Width 3ft   5996992.87522 2089478.65733 37.7171382471177 -122.452364714964 (37.7171382471177, -122.452364714964) 9 8 6 28861 24
33651 179230 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1725 Sunnydale Ave 3 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   6006577.912 2087637.98608 37.7126286245794 -122.41910324684 (37.7126286245794, -122.41910324684) 9 7 8 309 39
34105 16009 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 3 Median : Cutout Tree DPW 1   04/06/1998 12:00:00 AM 3 4   6001288.33709 2094653.38984 37.7315920404307 -122.437887811771 (37.7315920404307, -122.437887811771) 9 7 4 63 40
34531 213851 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 27 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5997419.29957 2093714.39076 37.7287929985961 -122.451196073839 (37.7287929985961, -122.451196073839) 9 7 4 28861 40
35037 108336 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 1099 CAPITOL AVE 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995030 2091211 37.7217821988442 -122.459274772662 (37.7217821988442, -122.459274772662) 9 8 6 28861 24
35479 179254 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 408 Athens St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6003875.22303 2090897.22828 37.7214252217842 -122.428676780004 (37.7214252217842, -122.428676780004) 9 7 6 28861 5
35967 179259 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 92 Rotteck St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6003365.89575 2094523.159 37.7313523783026 -122.430695997238 (37.7313523783026, -122.430695997238) 9 7 5 28861 25
36149 47952 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 284 Los Palmos Dr 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/05/2002 12:00:00 AM     Permit Number 45682 5997872.43575123 2096301.72488979 37.7359231369177 -122.449815943227 (37.7359231369177, -122.449815943227) 9 7 4 59 40
36746 213782 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 611 Joost Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 1ft   5998003.03381 2094973.8225 37.7322845049128 -122.449268775443 (37.7322845049128, -122.449268775443) 9 7 4 59 40
36760 16015 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 9 Median : Cutout Tree DPW 1     12 4   6000956.04768 2094656.76286 37.7315824005883 -122.439036840479 (37.7315824005883, -122.439036840479) 9 7 4 63 40
37027 213827 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 35 Valdez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5996363.86002 2093927.01219 37.7293163194736 -122.454860133084 (37.7293163194736, -122.454860133084) 9 7 4 28861 40
37093 213813 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401 Victoria St 6 : Tree Private 2     1 Width 2ft   5993229.42561 2089937.26728 37.7181811522081 -122.465406358618 (37.7181811522081, -122.465406358618) 9 8 6 64 24
37201 43723 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 677 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43363 5995255.48905656 2089886.97227481 37.7181596949046 -122.458399531016 (37.7181596949046, -122.458399531016) 9 8 6 28861 24
37395 179242 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 750 Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   5998956.14465 2090272.2611 37.7194295820854 -122.445635689757 (37.7194295820854, -122.445635689757) 9 7 6 28861 25
38695 213807 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 235 Vernon St 1 : Tree Private 2     1 Width 3ft   5992444.29236 2089435.87285 37.7167591325169 -122.468083752765 (37.7167591325169, -122.468083752765) 9 8 6 64 24
38924 213795 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 777 Lakeview Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5994288.82384 2089913.08592 37.7181757976619 -122.461742746332 (37.7181757976619, -122.461742746332) 9 8 6 28861 24
39122 179219 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1901 Sunnydale Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6005910.8454 2087904.73001 37.7133234587798 -122.421427773984 (37.7133234587798, -122.421427773984) 9 7 8 309 18
39601 43714 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 322 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43355 5994772.66402913 2090734.25116914 37.7204583622432 -122.460129788058 (37.7204583622432, -122.460129788058) 9 8 6 28861 24
39957 213814 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401 Victoria St 7 : Tree Private 2     1 Width 2ft   5993228.63608 2089930.24948 37.7181618374874 -122.465408578152 (37.7181618374874, -122.465408578152) 9 8 6 64 24
39998 107899 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 101X Shields St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/04/2014 12:00:00 AM 3   Permit Number 770994 5993727.26625 2089799.61042 37.7178318788778 -122.463675564283 (37.7178318788778, -122.463675564283) 9 8 6 64 24
40019 67900 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 27 Gennessee St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/22/1993 12:00:00 AM     Permit Number 31602 5997414.12131199 2093627.0661451 37.7285529294243 -122.451207680238 (37.7285529294243, -122.451207680238) 9 7 4 28861 40
40354 213819 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 279 Bright St 1 : Tree Private 2     4 Width 3ft   5993740.04713 2089048.21868 37.7157694735569 -122.463576884881 (37.7157694735569, -122.463576884881) 9 8 6 64 24
40819 84206 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 655 Sunnydale Ave 5 Sidewalk: Curb side : Cutout Tree Private 2   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009700.46384 2086497.50664 37.7096724504982 -122.40823029041 (37.7096724504982, -122.40823029041) 9 7 8 309 39
40961 179225 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1801 Sunnydale Ave 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6006308.59662 2087739.45788 37.7128920746867 -122.420041283778 (37.7128920746867, -122.420041283778) 9 7 8 309 39
41915 43713 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 319 Faxon Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43354 5994720.21130865 2090709.86528617 37.7203883873178 -122.460309333031 (37.7203883873178, -122.460309333031) 9 8 6 28861 24
42268 179185 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1500 Sunnydale Ave 3 Sidewalk: Property side : Yard Tree Private 2     4 Width 6ft   6007214.91098 2087479.51248 37.7122293408956 -122.416890351634 (37.7122293408956, -122.416890351634) 9 7 8 309 39
42789 179195 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 178 Brookdale Ave 2 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6005631.15518 2087152.0442 37.7112409697606 -122.422341035527 (37.7112409697606, -122.422341035527) 9 7 8 309 18
42875 16013 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 100X Monterey Blvd 7 Median : Cutout Tree DPW 1     3 4   6001154.39221 2094654.56847 37.7315876589354 -122.438350968922 (37.7315876589354, -122.438350968922) 9 7 4 63 40
42894 108457 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 90-98X Prague St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 3x3   6004660.96159 2090620.79395 37.7207106312606 -122.425941029771 (37.7207106312606, -122.425941029771) 9 7 6 28861 5
45201 179243 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 760 Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2     12 Width 2ft   5998936.4786 2090234.74893 37.7193254594704 -122.445700971549 (37.7193254594704, -122.445700971549) 9 7 6 28861 25
50828 179224 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1801 Sunnydale Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6006288.05669 2087748.67118 37.7129162151802 -122.420112930068 (37.7129162151802, -122.420112930068) 9 7 8 309 39
51515 84511 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 670 Edinburg St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3 3x3   6002290 2089910 37.7186246694004 -122.434085914673 (37.7186246694004, -122.434085914673) 9 7 6 28861 5
52018 213777 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401x Monterey Blvd 12 Median : Cutout Tree DPW 1     4 Width 4ft   5998950.72386 2094690.09449 37.7315596162741 -122.445972007429 (37.7315596162741, -122.445972007429) 9 7 4 59 40
53404 179208 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1750 Sunnydale Ave 3 Sidewalk: Property side : Yard Tree Private 2     10 Width 10ft   6006534.03686 2087707.31011 37.7128165028568 -122.419259808007 (37.7128165028568, -122.419259808007) 9 7 8 309 39
54923 179232 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 441 Otsego Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 2ft   6000113.20507 2091231.68489 37.7221299332307 -122.4417049887 (37.7221299332307, -122.4417049887) 9 7 6 28861 25
55184 53980 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 314 San Leandro Way 1 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2016 12:00:00 AM     Permit Number 777049 5992334.38859686 2094817.59997169 37.731529684404 -122.468855037458 (37.731529684404, -122.468855037458) 9 8 4 59 40
55694 179203 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 145 Blythdale Ave 1 Sidewalk: Property side : Yard Tree Private 2     5 Width 6ft   6005739.90981 2087176.84104 37.711315190824 -122.421966912161 (37.711315190824, -122.421966912161) 9 7 8 309 39
58465 43705 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 283 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/25/2000 12:00:00 AM     Permit Number 43348 5993731.55292772 2089058.73633294 37.7157978630843 -122.463607007411 (37.7157978630843, -122.463607007411) 9 8 6 64 24
58605 36494 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 98 Westwood Dr 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39378 5995169.4338934 2093305.35572926 37.7275408124282 -122.458944352189 (37.7275408124282, -122.458944352189) 9 7 4 28861 40
60381 179212 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1800 Sunnydale Ave 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 10ft   6006336.27941 2087779.02675 37.7130022821103 -122.419948408995 (37.7130022821103, -122.419948408995) 9 7 8 309 39
60535 112962 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 701 Sunnydale Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009373.36818 2086623.06286 37.7099988810277 -122.409369650496 (37.7099988810277, -122.409369650496) 9 7 8 309 39
62240 36482 Permitted Site 7 Pyrus calleryana :: Ornamental Pear 44 30 Valdez Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/18/1998 12:00:00 AM     Permit Number 39373 5996408.11327443 2093887.34669761 37.729209945951 -122.454704281902 (37.729209945951, -122.454704281902) 9 7 4 28861 40
62631 16048 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 200X Monterey Blvd 6 Median : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 6 4   6000504.30929 2094664.85106 37.7315788950381 -122.440599164328 (37.7315788950381, -122.440599164328) 9 7 4 63 40
63357 213810 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 462 Ramsell St 1 : Tree Private 2     1 Width 3ft   5993006.0749 2090264.25766 37.7190661048825 -122.466202130045 (37.7190661048825, -122.466202130045) 9 8 6 64 24
63808 112964 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 701 Sunnydale Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6009407.05623 2086613.17163 37.7099736091697 -122.409252520091 (37.7099736091697, -122.409252520091) 9 7 8 309 39
64621 179213 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 1800 Sunnydale Ave 3 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6006300.8377 2087791.60426 37.7130348204719 -122.420071799571 (37.7130348204719, -122.420071799571) 9 7 8 309 39
65915 108334 Undocumented 4 Pyrus calleryana :: Ornamental Pear 44 1099 CAPITOL AVE 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995030 2091211 37.7217821988442 -122.459274772662 (37.7217821988442, -122.459274772662) 9 8 6 28861 24
65985 213776 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 401x Monterey Blvd 11 Median : Cutout Tree DPW 1     1 Width 4ft   5998982.76667 2094689.74714 37.7315604922086 -122.445861204645 (37.7315604922086, -122.445861204645) 9 7 4 59 40
66702 52519 DPW Maintained 1 Pyrus calleryana :: Ornamental Pear 44 52 Navajo Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/28/2005 12:00:00 AM 3   Permit Number 48620 5999464.55592 2090507.11816 37.7201034593997 -122.443895170628 (37.7201034593997, -122.443895170628) 9 7 6 28861 25

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