sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
7848 51578 1 55   1 1 1 1   02/04/2005 12:00:00 AM     Permit Number 47872          
10202 173900 5 55 601x Hearst Ave 1 1 1 1                    
10204 173902 2 55 601x Hearst Ave 2 1 1 1                    
12636 99746 2 55 4250 Clipper St 1 1 1 1       3x3            
45077 177085 2 55 466 Tocoloma Ave 2 1 1 1     15 Width 3ft   6012392.66028 2086405.7608400001 37.7095709179289 -122.39891908764099 (37.7095709179289, -122.398919087641)
125956 40954 1 55 117 Gillette Ave 1 1 1 1         Permit Number 41809 6013102.88048258 2086808.22702407 37.7107155607107 -122.396492619427 (37.7107155607107, -122.396492619427)
86603 114790 2 55 100x GILLETTE AVE 1 1 1 1       3x3   6013060.0 2086881.0 37.7109129945759 -122.39664592325 (37.7109129945759, -122.39664592325)
10409 104687 2 55 540 Blanken Ave 2 1 1 1     12 3x3   6013068.15068 2086901.5117 37.7109697693033 -122.396619189338 (37.7109697693033, -122.396619189338)
159795 177087 2 55 201 Nueva Ave 1 1 1 1     5 Width 3ft   6012854.2238300005 2086908.7049900002 37.710977612288794 -122.397359080471 (37.7109776122888, -122.397359080471)
11719 54938 1 55 540 Blanken Ave 1 1 1 1   09/13/1972 12:00:00 AM 14 4x3 Permit Number 10816 6013051.4266099995 2086907.8440900003 37.7109862260136 -122.39667743572599 (37.7109862260136, -122.396677435726)
37951 177075 2 55 601 Blanken Ave 1 1 1 1     14 Width 3ft   6013151.428830001 2086913.1361599998 37.711006322265 -122.396332172488 (37.711006322265, -122.396332172488)
65681 54939 1 55 537 Blanken Ave 1 1 1 1   09/13/1972 12:00:00 AM 7   Permit Number 10817 6013054.91789 2086947.83958 37.7110962400835 -122.396668170907 (37.7110962400835, -122.396668170907)
156751 54754 1 55 525 Blanken Ave 1 1 1 1   08/08/1972 12:00:00 AM 16   Permit Number 10602 6013004.6612 2086964.21665 37.7111384110727 -122.396843018889 (37.7111384110727, -122.396843018889)
36952 177076 2 55 490 Blanken Ave 1 1 1 1     14 Width 3ft   6012816.17748 2087024.5576799999 37.711293602592896 -122.397498698426 (37.7112936025929, -122.397498698426)
151424 177077 2 55 490 Blanken Ave 2 1 1 1     14 Width 3ft   6012777.255059999 2087037.0196900002 37.7113256535156 -122.39763409854099 (37.7113256535156, -122.397634098541)
173389 177078 2 55 490 Blanken Ave 3 1 1 1     14 Width 3ft   6012757.34984 2087044.1812200001 37.71134420923121 -122.397703398489 (37.7113442092312, -122.397703398489)
156887 177079 2 55 411 Blanken Ave 1 1 1 1     12 Width 3ft   6012724.51952 2087052.8334599999 37.7113661383121 -122.397817475721 (37.7113661383121, -122.397817475721)
55331 177080 2 55 411 Blanken Ave 3 1 1 1     12 Width 3ft   6012673.3507900005 2087069.8441 37.7114099964555 -122.397995521673 (37.7114099964555, -122.397995521673)
30331 177074 2 55 250 Blanken Ave 3 1 1 1     11 Width 3ft   6012293.95082 2087148.96015 37.711606095404704 -122.399312384552 (37.7116060954047, -122.399312384552)
37287 177073 2 55 250 Blanken Ave 1 1 1 1     13 Width 3ft   6012250.9341 2087164.6168900002 37.7116466881279 -122.399462161252 (37.7116466881279, -122.399462161252)
36975 177081 2 55 299 Blanken Ave 3 1 1 1     13 Width 3ft   6012270.95689 2087199.0340099998 37.711742306725995 -122.39939537131 (37.711742306726, -122.39939537131)
144898 31669 1 55 301 Wheeler Ave 1 1 1 1   06/12/1995 12:00:00 AM     Permit Number 35177 6012138.91947495 2087210.17556421 37.7117655390688 -122.399852513423 (37.7117655390688, -122.399852513423)
59510 177072 2 55 140 Blanken Ave 2 1 1 1     12 Width 3ft   6012065.17517 2087224.72612 37.7118013805076 -122.400108416784 (37.7118013805076, -122.400108416784)
136655 177082 2 55 199 Blanken Ave 1 1 1 1     10 Width 3ft   6012090.15374 2087257.68783 37.7118932795125 -122.40002439671999 (37.7118932795125, -122.40002439672)
135468 177083 2 55 199 Blanken Ave 2 1 1 1     10 Width 3ft   6012071.18023 2087265.13818 37.7119126788116 -122.400090497793 (37.7119126788116, -122.400090497793)
35900 177084 2 55 199 Blanken Ave 4 1 1 1     9 Width 3ft   6012033.75638 2087275.42031 37.71193882479629 -122.400220567635 (37.7119388247963, -122.400220567635)
82585 44826 1 55 129 Leland Ave 1 1 1 1   04/20/2001 12:00:00 AM     Permit Number 43918 6010308.29040288 2087358.77915196 37.7120713475932 -122.40619016379601 (37.7120713475932, -122.406190163796)
29104 207851 2 55 266 Sadowa St 1 1 1 1     6 Width 3ft   5994330.673359999 2087784.2357400001 37.712332889716 -122.46144384316099 (37.712332889716, -122.461443843161)
72357 177142 2 55 417 Rolph St 1 1 1 1     1 Width 6ft   6002087.33741 2087757.61933 37.71270320445571 -122.434632613123 (37.7127032044557, -122.434632613123)
127035 117422 2 55 50 VERNON ST 1 1 1 1       3x3   5992487.0 2088224.0 37.713434088528295 -122.467848042178 (37.7134340885283, -122.467848042178)
11054 1139 3 55 2627 Alemany Blvd 1 1 1 2     12 1X1   5998352.02606 2088442.52333 37.7143710331717 -122.447592253902 (37.7143710331717, -122.447592253902)
186701 177068 2 55 26 Curtis St 1 1 1 1     13 Width 4ft   6000490.27056 2088504.66061 37.7146636177052 -122.440206107549 (37.7146636177052, -122.440206107549)
11402 1130 3 55 2554 Alemany Blvd 1 1 1 2     20 3X3   5998598.100380001 2088668.31183 37.7150050570134 -122.446757963627 (37.7150050570134, -122.446757963627)
159944 101866 1 55 851 Lisbon St 1 1 1 1   01/09/2013 12:00:00 AM 2 3x3 Permit Number 769709 6001077.037690001 2088890.9773 37.71575774639479 -122.438205662778 (37.7157577463948, -122.438205662778)
21740 26336 1 55 2564 San Jose Ave 1 1 1 1     12 3X3   5997739.3987300005 2089429.54745 37.7170461430363 -122.449780813452 (37.7170461430363, -122.449780813452)
34600 177041 2 55 36 Rome St 1 1 1 1     8 Width 6ft   5999256.2594099995 2089431.5407 37.7171382857881 -122.444537916099 (37.7171382857881, -122.444537916099)
177936 177040 2 55 50 Rome St 1 1 1 1     5 Width 6ft   5999261.0565599995 2089438.38497 37.7171573523208 -122.444521826318 (37.7171573523208, -122.444521826318)
24017 65613 1 55 743 Madrid St 1 1 1 1 1 02/07/1990 12:00:00 AM 18   Permit Number 28520 6001843.34769 2089618.0611400001 37.71779771097221 -122.43560893330299 (37.7177977109722, -122.435608933303)
53693 207848 2 55 833 Plymouth Ave 1 1 1 1     2 Width 2ft   5995895.43899 2089793.88094 37.717940843481706 -122.45618078484199 (37.7179408434817, -122.456180784842)
20442 19325 3 55 212 Shields St 1 1 1 2     15 3X4   5993418.3820400005 2089852.67557 37.717959779598 -122.464747082736 (37.717959779598, -122.464747082736)
146527 177089 2 55 545 Wilde Ave 1 1 1 1     4 Width 3ft   6009804.5393 2089523.18108 37.717986161204706 -122.408083826812 (37.7179861612047, -122.408083826812)
102900 52416 1 55 734 Madrid St 1 1 1 1 1 12/21/2005 12:00:00 AM     Permit Number 48535 6001832.35713287 2089688.63788093 37.717990874718 -122.43565196916799 (37.717990874718, -122.435651969168)
48436 177044 2 55 87 Seneca Ave 5 1 1 1     5 Width 1ft   6000253.62595 2089858.9653200002 37.7183687570946 -122.44112115243999 (37.7183687570946, -122.44112115244)
160832 177043 2 55 87 Seneca Ave 4 1 1 1     3 Width 1ft   6000241.05575 2089872.3479 37.7184047866172 -122.441165561868 (37.7184047866172, -122.441165561868)
135805 207849 2 55 48 Granada Ave 1 1 1 1     14 Width 3ft   5995641.83079 2090207.60009 37.7190622575991 -122.45708730146099 (37.7190622575991, -122.457087301461)
139428 67005 1 55 48 Granada Ave 1 1 1 1 1 02/20/1992 12:00:00 AM     Permit Number 30360 5995649.51069731 2090220.09677054 37.7190970115741 -122.457061658607 (37.7190970115741, -122.457061658607)
149265 62617 1 55 608 Paris St 1 1 1 1   02/26/1986 12:00:00 AM 7   Permit Number 22927 6001463.88334 2090119.9381900001 37.719154192602 -122.43695648018101 (37.719154192602, -122.436956480181)
40485 177065 2 55 626 Madrid St 2 1 1 1     7 Width 2ft   6002192.98275 2090253.20784 37.7195615351173 -122.43444578884599 (37.7195615351173, -122.434445788846)
77111 177066 2 55 573 Edinburgh St 1 1 1 1     12 Width 5ft   6002664.89947 2090416.35383 37.720036274630104 -122.432826194382 (37.7200362746301, -122.432826194382)
148258 177067 2 55 573 Edinburgh St 2 1 1 1     11 Width 5ft   6002673.20995 2090427.0269900002 37.720066052099206 -122.432798229977 (37.7200660520992, -122.432798229977)
143643 65177 1 55 573 Edinburg St 1 1 1 1 1 07/29/1989 12:00:00 AM     Permit Number 27158 6002678.99460756 2090431.51316854 37.7200786982312 -122.43277855471001 (37.7200786982312, -122.43277855471)
177409 207847 2 55 400 Grafton Ave 1 1 1 1     11 Width 3ft   5995588.095430001 2090580.79577 37.7200838784522 -122.457300026187 (37.7200838784522, -122.457300026187)
104680 67018 1 55 400 Grafton Ave 1 1 1 1 1 02/20/1992 12:00:00 AM     Permit Number 30374 5995620.26197767 2090586.55623665 37.7201015427641 -122.457189254526 (37.7201015427641, -122.457189254526)
143521 67985 1 55 212 Grafton Ave 1 1 1 1 1 03/22/1993 12:00:00 AM     Permit Number 31709 5996176.45016211 2090576.83582112 37.7201067800111 -122.455266009291 (37.7201067800111, -122.455266009291)
66634 207845 2 55 125 Granada Ave 1 1 1 1     10 Width 4ft   5995607.338719999 2090657.41082 37.7202953504384 -122.457239048555 (37.7202953504384, -122.457239048555)
182678 67465 1 55 937 Olmstead St 1 1 1 1   09/01/1992 12:00:00 AM 9   Permit Number 30978 6008961.1272 2090382.77007 37.7202991536555 -122.41105982826001 (37.7202991536555, -122.41105982826)
98762 207846 2 55 160 Granada Ave 1 1 1 1     12 Width 3ft   5995656.91883 2090949.83096 37.721101114209205 -122.45708880872401 (37.7211011142092, -122.457088808724)
142846 67008 1 55 163 Granada Ave 1 1 1 1 1 02/20/1992 12:00:00 AM     Permit Number 30363 5995610.42846311 2090973.17671265 37.721162546103 -122.457251199338 (37.721162546103, -122.457251199338)
177872 207844 2 55 163 Granada Ave 1 1 1 1     9 Width 3ft   5995613.369530001 2090975.38331 37.721168773811 -122.457241192529 (37.721168773811, -122.457241192529)
147795 207843 2 55 173 Granada Ave 1 1 1 1     12 Width 3ft   5995613.80856 2091011.1988 37.721267139854795 -122.457242264538 (37.7212671398548, -122.457242264538)
44078 66992 1 55 173 Granada Ave 1 1 1 1 1 02/12/1992 12:00:00 AM     Permit Number 30345 5995611.62082258 2091036.47990525 37.721336430114796 -122.457251654811 (37.7213364301148, -122.457251654811)
181443 207842 2 55 193 Granada Ave 1 1 1 1     6 Width 3ft   5995618.109069999 2091172.31825 37.7217097825699 -122.457239048551 (37.7217097825699, -122.457239048551)
2689 207839 2 55 626X Holloway Ave 2 1 1 1     12 Width 3ft   5994826.85492 2091253.8672900002 37.721888220645 -122.459980091334 (37.721888220645, -122.459980091334)
91855 122410 6 55 499x Ocean Ave 7 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
91870 122411 6 55 499x Ocean Ave 8 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
99827 122418 6 55 499x Ocean Ave 15 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
109913 122413 6 55 499x Ocean Ave 10 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
110638 122414 6 55 499x Ocean Ave 11 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
112319 122417 6 55 499x Ocean Ave 14 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
112873 122416 6 55 499x Ocean Ave 13 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
116737 122415 6 55 499x Ocean Ave 12 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
122326 122412 6 55 499x Ocean Ave 9 1 1 6       3x3   5998874.0 2091543.0 37.722914047867604 -122.446010982458 (37.7229140478676, -122.446010982458)
188009 177141 2 55 355 Naples St 2 1 1 1     3 Width 3ft   6003671.36983 2091507.3370599998 37.7230889064227 -122.429424930532 (37.7230889064227, -122.429424930532)
60851 177046 2 55 317 Otsego Ave 1 1 1 1     18 Width 3ft   6000299.83904 2091602.15468 37.7231577908794 -122.441086408025 (37.7231577908794, -122.441086408025)
11106 25304 3 55 292 Ocean Ave 1 1 1 2     12 5x9   5999755.51283 2091622.1717 37.7231817335313 -122.44296946786501 (37.7231817335313, -122.442969467865)
13198 25303 3 55 286 Ocean Ave 3 1 1 2     18 5x9   5999775.2112 2091625.73202 37.7231926324273 -122.4429016302 (37.7231926324273, -122.4429016302)
97971 62791 1 55 292 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23147 5999722.02733953 2091630.11110927 37.7232016241068 -122.44308579022301 (37.7232016241068, -122.443085790223)
55936 177099 2 55 377 Delano Ave 1 1 1 1     13 Width 3ft   5999714.66231 2091641.03543 37.7232311998395 -122.44311203381099 (37.7232311998395, -122.443112033811)
104134 62790 1 55 199 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23146 6000313.64252899 2091641.02456839 37.7232653049393 -122.441041479459 (37.7232653049393, -122.441041479459)
41100 177100 2 55 377 Delano Ave 2 1 1 1     12 Width 3ft   5999723.90595 2091657.9425099997 37.7232781498534 -122.443081294068 (37.7232781498534, -122.443081294068)
169770 177045 2 55 21 Wanda St 1 1 1 1     16 Width 2ft   6000634.5733900005 2091639.69962 37.7232799412972 -122.43993199059099 (37.7232799412972, -122.439931990591)
12673 25310 3 55 197 Ocean Ave 1 1 1 2     12 3X3   6000354.040159999 2091646.91959 37.7232837922084 -122.440902255631 (37.7232837922084, -122.440902255631)
42836 67278 1 55 58 Ina Ct 1 1 1 1 1 06/18/1992 12:00:00 AM 3   Permit Number 30752 6004928.68664 2091573.7324299999 37.7233423191649 -122.42508335531001 (37.7233423191649, -122.42508335531)
106537 62784 1 55 137 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23140 6000712.17881294 2091681.24596218 37.723398435511896 -122.439666701145 (37.7233984355119, -122.439666701145)
106547 62782 1 55 131 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23138 6000753.3579224 2091686.36985433 37.7234148482869 -122.439524720053 (37.7234148482869, -122.439524720053)
119329 62781 1 55 127 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23137 6000780.81066937 2091689.78578334 37.7234257900447 -122.43943006593099 (37.7234257900447, -122.439430065931)
82598 62789 1 55 196 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23145 6000321.17614419 2091703.51030925 37.7234373055999 -122.44101991790899 (37.7234373055999, -122.441019917909)
13006 25299 3 55 190 Ocean Ave 1 1 1 2     12 3x3   6000418.66631 2091706.69164 37.7234515931109 -122.44068314123001 (37.7234515931109, -122.44068314123)
108690 62788 1 55 190 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23144 6000370.84981794 2091713.58104778 37.723467786704504 -122.440848927652 (37.7234677867045, -122.440848927652)
178387 62826 1 55 170 Ocean Ave 1 1 1 1 1 07/08/1986 12:00:00 AM 8   Permit Number 23191 6000498.4193400005 2091715.9404799999 37.723481529728495 -122.44040811326299 (37.7234815297285, -122.440408113263)
11709 25297 1 55 164 Ocean Ave 1 1 1 1     12 3x3   6000520.37509 2091718.7559 37.723490510352995 -122.440332418218 (37.723490510353, -122.440332418218)
172527 177103 2 55 154 Ocean Ave 2 1 1 1     12 Width 2ft   6000580.38347 2091726.23406 37.723514460202395 -122.440125516598 (37.7235144602024, -122.440125516598)
142722 62787 1 55 164 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23143 6000550.01003757 2091735.82644797 37.723539069470206 -122.44023119939699 (37.7235390694702, -122.440231199397)
11537 25293 3 55 144 Ocean Ave 1 1 1 2     12 2X2   6000659.82425 2091738.03378 37.7235513818789 -122.43985175036998 (37.7235513818789, -122.43985175037)
94190 62786 1 55 154 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23142 6000618.91780925 2091744.38237049 37.723566485054 -122.439993611308 (37.723566485054, -122.439993611308)
10599 25290 1 55 136 Ocean Ave 2 1 1 1     6 3X3   6000711.5604 2091742.5944599998 37.7235668493142 -122.439673234935 (37.7235668493142, -122.439673234935)
111795 25294 3 55 150 Ocean Ave 1 1 1 2     12 3X3   6000635.349880001 2091747.8935900002 37.7235770614816 -122.439937060329 (37.7235770614816, -122.439937060329)
10803 25289 3 55 136 Ocean Ave 1 1 1 2     6 3X3   6000745.99488 2091748.7856599998 37.72358580881671 -122.439554644937 (37.7235858088167, -122.439554644937)
73882 177102 2 55 130 Ocean Ave 2 1 1 1     6 Width 4ft   6000764.64112 2091750.39808 37.72359129737671 -122.439490303855 (37.7235912973767, -122.439490303855)
140867 62785 1 55 144 Ocean Ave 1 1 1 1 1 06/24/1986 12:00:00 AM     Permit Number 23141 6000686.30847209 2091752.62403135 37.7235929509131 -122.43976124488998 (37.7235929509131, -122.43976124489)
32505 177101 2 55 130 Ocean Ave 1 1 1 1     11 Width 4ft   6000792.03134 2091751.28395 37.7235952885821 -122.439395684376 (37.7235952885821, -122.439395684376)
Powered by Datasette · Query took 105.74ms · Data source: data.sfgov.org