home / trees

trees

Custom SQL query returning 101 rows

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods
1 1 1 1 10 10th Ave 1 1 1 1     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496) 11 6 1 54 11
2 10 1 2 97 12th St 4 1 1 1     20 3X3   6007166.5822125 2109668.7679164 37.7731533608049 -122.418629924651 (37.7731533608049, -122.418629924651) 8 2 9 28853 19
3 1000 1 3 1726 Alemany Blvd 1 2 1 1     20 3X5PL   6001385.76767 2092068.0675700002 37.724498876108 -122.43736591900499 (37.724498876108, -122.437365919005) 9 7 6 28861 25
4 10000 1 4 136 Guerrero St 1 2 1 2     90 2X2   6005403.547780001 2108183.22689 37.7689750062251 -122.424622801709 (37.7689750062251, -122.424622801709) 8 4 5 28853 19
5 100000 2 5 600@Washington St Montgomery St 2 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
6 100001 3 6 501X 01st St 2 3 1 2         Address is 100 1st Street                    
7 100003 3 7 501X Mission St 2 3 1 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
8 100004 2 5 600@Washington St Montgomery St 8 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
9 100005 1 5 600@Washington St Montgomery St 7 2 1 2     14     6011805.4321099995 2117563.29295 37.795089953282705 -122.403138864979 (37.7950899532827, -122.403138864979) 3 1 10 28860 4
10 100006 1 5 600@Washington St Montgomery St 6 2 1 2     15     6011806.48185 2117548.03354 37.7950481132234 -122.403134158813 (37.7950481132234, -122.403134158813) 3 1 10 28860 4
11 100007 3 7 501X Mission St 3 3 1 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
12 100008 3 7 501X Mission St 4 3 1 2   06/26/2012 12:00:00 AM     Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
13 100009 2 5 600@Washington St Montgomery St 4 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
14 10001 1 4 145 Guerrero St 1 2 1 1     12 3X2   6005474.27283 2108090.23028 37.768723653813204 -122.42437155270201 (37.7687236538132, -122.424371552702) 8 4 5 28853 19
15 100010 3 6 501X Mission St 5 3 1 2         Permit Number 768978 6013380.8 2115570.5 37.789706063197606 -122.39754798333901 (37.7897060631976, -122.397547983339) 12 2 9 28855 6
16 100011 1 5 600@Washington St Montgomery St 5 2 1 2     15     6011807.60069 2117536.15907 37.7950155712566 -122.40312945177 (37.7950155712566, -122.40312945177) 3 1 10 28860 4
17 100012 1 5 600@Washington St Montgomery St 3 2 1 2     15     6011815.138830001 2117505.52997 37.794931892052105 -122.403101213045 (37.7949318920521, -122.403101213045) 3 1 10 28860 4
18 100014 1 5 600@Washington St Montgomery St 1 2 1 2     16     6011819.70044 2117479.02475 37.794859369806396 -122.403083563865 (37.7948593698064, -122.403083563865) 3 1 10 28860 4
19 100015 1 5 600 Montgomery St 14 2 1 2     19     6011789.640790001 2117672.98825 37.795390268386 -122.403201225768 (37.795390268386, -122.403201225768) 3 1 10 28860 4
20 100016 1 5 600 Montgomery St 13 2 1 2     14     6011790.6974 2117658.0677 37.7953493591435 -122.403196519624 (37.7953493591435, -122.403196519624) 3 1 10 28860 4
21 100017 1 5 600 Montgomery St 12 2 1 2     15     6011791.69231 2117640.10072 37.7953000816886 -122.40319181257799 (37.7953000816886, -122.403191812578) 3 1 10 28860 4
22 100018 1 5 600 Montgomery St 11 2 1 2     14     6011793.71356 2117622.4512099996 37.7952517332473 -122.40318357656099 (37.7952517332473, -122.403183576561) 3 1 10 28860 4
23 100019 2 5 600 Montgomery St 10 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
24 10002 1 8 145 Guerrero St 2 2 1 1   09/19/2014 12:50:00 PM 3 3X2   6005473.70519 2108134.2356 37.768844449829395 -122.424376646466 (37.7688444498294, -122.424376646466) 8 4 5 28853 19
25 100020 2 5 600 Montgomery St 9 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
26 100021 2 5 600 Montgomery St 8 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
27 100022 2 5 600 Montgomery St 7 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
28 100023 2 5 600 Montgomery St 6 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
29 100025 2 5 600 Montgomery St 5 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
30 100026 2 5 600 Montgomery St 4 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
31 100027 2 5 600 Montgomery St 3 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
32 100028 2 5 600 Montgomery St 2 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
33 100029 2 5 600 Montgomery St 1 2 1 2           6011817.0 2117412.0 37.7946751850939 -122.403088191063 (37.7946751850939, -122.403088191063) 3 1 10 28860 4
34 10003 1 8 145 Guerrero St 3 2 1 2     12 3X2   6005473.24802 2108147.80938 37.7688816943622 -122.424379193367 (37.7688816943622, -122.424379193367) 8 4 5 28853 19
35 100030 1 9 535@Clay Washington St 2 2 1 2     19     6012036.249419999 2117732.6252099997 37.795567786487496 -122.40235210926201 (37.7955677864875, -122.402352109262) 3 1 10 28860 4
36 100031 1 10 1199 Mason St 4 2 1 3   08/02/2012 12:00:00 AM 4 3x3 Permit Number 769129 6009418.42249 2117262.251 37.7941297732341 -122.411377035334 (37.7941297732341, -122.411377035334) 3 1 10 28857 21
37 100032 1 10 1199 Mason St 5 2 1 3   08/02/2012 12:00:00 AM   3x3 Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
38 100033 1 10 1199 Mason St 1 2 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
39 100034 1 10 1199@Washington Mason St 2 2 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
40 100035 1 10 1199@Washington Mason St 3 2 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
41 100036 1 10 1199@Washington Mason St 4 2 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
42 100037 1 10 1199@Washington Mason St 5 2 1 3   08/02/2012 12:00:00 AM     Permit Number 769129 6009411.0 2117399.5 37.794506209154704 -122.411412418869 (37.7945062091547, -122.411412418869) 3 1 10 28857 21
43 100038 1 11 1925 Gough St 1 2 1 2     6     6005164.06417 2116434.37592 37.791617104282395 -122.42603861878901 (37.7916171042824, -122.426038618789) 13 9 1 28858 27
44 100039 1 11 1925 Gough St 2 2 1 2     6     6005166.77799 2116408.4512099996 37.7915460749308 -122.426027382675 (37.7915460749308, -122.426027382675) 13 9 1 28858 27
45 10004 1 12 150 Guerrero St 1 2 1 1     28 3X3   6005403.33839 2108127.1988 37.768821154693896 -122.424619539876 (37.7688211546939, -122.424619539876) 8 4 5 28853 19
46 100040 1 11 1925 Gough St 3 2 1 2     6     6005169.80466 2116390.62846 37.7914973092018 -122.426015641131 (37.7914973092018, -122.426015641131) 13 9 1 28858 27
47 100041 1 11 1925 Gough St 4 2 1 2     8     6005173.38835 2116375.3440799997 37.791455544677206 -122.426002153097 (37.7914555446772, -122.426002153097) 13 9 1 28858 27
48 100042 1 11 1925 Gough St 5 2 1 2     8     6005174.91003 2116356.5458 37.79140401532911 -122.42599554934799 (37.7914040153291, -122.425995549348) 13 9 1 28858 27
49 100043 4 13 50 Bronte St 1 4 1 2   07/12/2012 12:00:00 AM     Permit Number 769001 6009337.0 2097155.0 37.7389153282678 -122.41023844976401 (37.7389153282678, -122.410238449764) 10 7 7 28859 2
50 100044 2 14 1250 De Haro St 1 2 1 2   06/27/2012 12:00:00 AM   3x3 Permit Number 768984 6012201.0 2102568.4 37.7539394855375 -122.400716201774 (37.7539394855375, -122.400716201774) 10 3 8 28856 29
51 100045 5 15 556 28th St   4 1 2         Not sure which property tree is located on. 6002301.0 2099461.0 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
52 100046 5 13 562 28th St   4 1 2   11/28/2012 12:00:00 AM 17   Permit Number 769057 6002262.0 2099459.0 37.7448424535299 -122.43486521318898 (37.7448424535299, -122.434865213189) 2 7 5 63 22
53 100047 1 16 191@ 23rd Ave 23rd Ave 4 2 1 2     1     5988664.0 2114068.0 37.7841733536199 -122.48295448443399 (37.7841733536199, -122.482954484434) 11 6 2 55 26
54 100048 2 17 1445 Cabrillo St 2 2 1 2   08/22/2012 12:00:00 AM   3x3 Permit Number 769137 5991161.0 2110614.0 37.7748345969519 -122.47406374416 (37.7748345969519, -122.47406374416) 11 6 2 54 26
55 100049 2 18 3233X Buchanan St 1 2 1 2     12 3x3 Permit Number 768990 6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
56 10005 1 5 156 Guerrero St 1 2 1 1     12 3X3   6005408.68432 2108096.72474 37.7687377821415 -122.424598880629 (37.7687377821415, -122.424598880629) 8 4 5 28853 19
57 100050 3 18 3233X Buchanan St 2 2 1 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
58 100051 3 18 3233X Buchanan St 3 2 1 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
59 100052 3 18 3233X Buchanan St 4 2 1 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
60 100053 3 18 3233X Buchanan St 5 2 1 2     12 3x3   6003300.0 2119605.0 37.800217292537106 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
61 100054 4 9 401X Tehama St 1 2 1 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
62 100055 4 9 401X Tehama St 2 2 1 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
63 100056 4 9 401X Tehama St 3 2 1 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011330.4 2112435.9 37.78098480794971 -122.404421471201 (37.7809848079497, -122.404421471201) 14 2 9 28853 34
64 100057 3 13 240 05th St 1 2 1 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351.0 2112431.0 37.780972504862596 -122.40434986022801 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
65 100058 3 13 240 05th St 2 2 1 2   06/28/2012 12:00:00 AM 12 3x3 Permit Number 769058 6011351.0 2112431.0 37.780972504862596 -122.40434986022801 (37.7809725048626, -122.404349860228) 14 2 9 28853 34
66 100059 6 9 260 05th St 2 2 1 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
67 10006 1 19 165 Guerrero St 1 2 1 2   01/25/1991 12:00:00 AM 6 3X2   6005478.902319999 2108028.91066 37.76855554623621 -122.42435117768999 (37.7685555462362, -122.42435117769) 8 4 5 28853 19
68 100060 6 9 260 05th St 3 2 1 2   03/12/2015 12:00:00 AM 3 3x3 Permit Number 773313 6011435.0 2112345.0 37.7807410625565 -122.404053207068 (37.7807410625565, -122.404053207068) 14 2 9 28853 34
69 100061 3 13 430X Clementina St 1 2 1 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
70 100062 3 13 430X Clementina St 2 2 1 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
71 100063 3 13 430X Clementina St 3 2 1 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
72 100064 3 13 430X Clementina St 4 2 1 2   06/28/2012 12:00:00 AM   3x3 Permit Number 768595 6011459.0 2112320.0 37.780673759287204 -122.40396841919399 (37.7806737592872, -122.403968419194) 14 2 9 28853 34
73 100065 2 20 322 Duncan St 1 2 1 2   06/29/2012 12:00:00 AM   3x3 Permit Number 58746 6004276.4 2099889.0 37.7461372993162 -122.427930429145 (37.7461372993162, -122.427930429145) 2 7 5 63 22
74 100066 3 9 93 Buena Vista Ter 2 2 1 2   06/29/2012 12:00:00 AM   2x2 Permit Number 768610 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
75 100067 3 21 93 Buena Vista Ter 1 2 1 2       2x2 On property line with 99 Buena Vista Ter 6001505.1 2107681.4 37.76737617437121 -122.438071302911 (37.7673761743712, -122.438071302911) 15 5 5 29492 3
76 100068 2 22 303 Serrano Dr 1 2 1 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990392.0 2090762.0 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247) 1 8 4 64 40
77 100069 2 1 619 Gonzalez Dr 1 2 1 2   07/13/2012 12:00:00 AM     Permit Number 769006 5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722) 1 8 4 64 40
78 10007 1 6 170 Guerrero St 1 2 1 1     20 3X3   6005407.88099 2108072.95104 37.7686724598889 -122.424599967939 (37.7686724598889, -122.424599967939) 8 4 5 28853 19
79 100070 5 13 331 Serrano Dr 1 4 1 2         Permit Number 777990 5990400.0 2090718.0 37.7201612636948 -122.47524333880699 (37.7201612636948, -122.475243338807) 1 8 4 64 40
80 100071 3 23 96X Douglass St 1 2 1 2       3x3 Address is 4200-4204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
81 100072 3 23 96X Douglass St 2 2 1 2       3x3 Address is 1200-1204 17th St 6001034.7 2105837.1 37.7622854187027 -122.439566119284 (37.7622854187027, -122.439566119284) 15 5 5 28862 3
82 100073 2 24 930@ Lorraine Ct Anza St 2 2 1 2   07/02/2012 12:00:00 AM   3x3 Permit Number 769060 5996162.0 2112255.0 37.7796287713947 -122.45688306406099 (37.7796287713947, -122.456883064061) 11 6 2 54 16
83 100074 3 13 701 Noe St   2 1 2           6003070.0 2104166.0 37.7578126071811 -122.43240742658399 (37.7578126071811, -122.432407426584) 2 4 5 28862 3
84 100075 3 13 707-709 Noe St   2 1 2       3x3   6003067.0 2104139.0 37.757738301523105 -122.43241587342699 (37.7577383015231, -122.432415873427) 2 4 5 28862 3
85 100076 1 25 262 17th Ave 1 2 1 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776532 5990584.51145 2113652.92092 37.783145223942 -122.47627994024201 (37.783145223942, -122.476279940242) 11 6 2 54 26
86 100077 3 26 260 Page St 1 2 1 2       3x3   6005310.0 2109942.0 37.7737988894613 -122.42507153447501 (37.7737988894613, -122.425071534475) 7 9 11 28852 10
87 100078 1 25 266 17th Ave 1 2 1 2   01/26/2016 12:00:00 AM 3 4x4 Permit Number 776410 5990586.53381 2113609.7978 37.7830269371305 -122.47626979286501 (37.7830269371305, -122.476269792865) 11 6 2 54 26
88 100079 1 27 1451 44th Ave 1 2 1 2     14 3x6   5982451.9345 2105243.3429 37.759579983868605 -122.503791871245 (37.7595799838686, -122.503791871245) 1 8 3 56 35
89 10008 1 6 170 Guerrero St 2 2 1 1     22 3X3   6005410.95643 2108039.08035 37.7685796327732 -122.424586920555 (37.7685796327732, -122.424586920555) 8 4 5 28853 19
90 100080 1 9 701X POLK ST 1 2 1 2   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774752 6007001.0 2113322.0 37.7831749319814 -122.419461922492 (37.7831749319814, -122.419461922492) 7 9 9 28858 36
91 100087 2 28 2028 Filbert St 1 2 1 2           6003216.8 2118972.8 37.798476716718895 -122.432957560795 (37.7984767167189, -122.432957560795) 13 9 1 57 17
92 100088 1 29 2034 Filbert St 1 2 1 2     11 3x3   6003201.40964 2118956.6592900003 37.7984315255609 -122.43300966237301 (37.7984315255609, -122.433009662373) 13 9 1 57 17
93 100089 1 29 2034 Filbert St 2 2 1 2     8 3x3   6003188.20593 2118955.0281 37.7984262977915 -122.43305523462601 (37.7984262977915, -122.433055234626) 13 9 1 57 17
94 10009 1 6 170 Guerrero St 3 2 1 1     22 3X3   6005412.73113 2108018.3838400003 37.7685229053392 -122.42457930959999 (37.7685229053392, -122.4245793096) 8 4 5 28853 19
95 100090 3 5 11X Shotwell St 1 2 1 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
96 100091 3 30 11X Shotwell St 2 2 1 2     5 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
97 100092 3 13 11X Shotwell St 4 2 1 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
98 100093 3 30 11X Shotwell St 5 2 1 2     10 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
99 100094 3 5 11X Shotwell St 6 2 1 2     12 3x3   6007856.7 2107724.0 37.7678523153445 -122.416104954993 (37.7678523153445, -122.416104954993) 8 4 7 28853 19
100 100095 2 13 4372 26th St 1 2 1 3 1 07/03/2012 12:00:00 AM   3x3 Permit Number 769070 6001507.0 2100613.7 37.747970090970504 -122.43755853273001 (37.7479700909705, -122.43755853273) 2 4 5 28862 22
101 100096 2 11 495 Jefferson St 1 2 1 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
Powered by Datasette · Query took 1.725ms