sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2252 252990 2 141 52 Pierce St 1 5 1 1       2x8   6002925.0 2108585.0 37.7699378868501 -122.433224642796 (37.7699378868501, -122.433224642796)
3368 253427 2 141 2 09th Ave 5 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3369 253425 2 141 2 09th Ave 3 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3370 253423 2 141 2 09th Ave 1 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
3380 253426 2 141 2 09th Ave 4 1 1 1       3x3   5993083.0 2114893.0 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285)
5256 253838 2 141 1458 46th Ave 1 1 1 1 1     5.5x4   5981900.0 2105162.0 37.759324170949604 -122.505694672765 (37.7593241709496, -122.505694672765)
8287 47845 1 141 8250on Geary 47th Ave 1 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
8319 47848 1 141 8250on Geary 47th Ave 5 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
9991 34375 1 141 157 Laidley St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38127 6003918.97921609 2097483.80532691 37.7395129612854 -122.428994891637 (37.7395129612854, -122.428994891637)
12078 47847 1 141 8250on Geary 47th Ave 6 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
12229 47849 1 141 8250on Geary 47th Ave 4 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
12714 47846 1 141 8250on Geary 47th Ave 2 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
16207 47844 1 141 8250on Geary 47th Ave 3 1 1 1   06/14/2002 12:00:00 AM     Permit Number 45605          
18031 96327 6 141 296 Randall St 1 9 1 1         Permit Number 767829 6003708.0 2097940.0 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294)
18680 122353 2 141 155 Appleton Ave 4 1 1 1       3x3   6006071.0 2097171.0 37.7387756468895 -122.421531918974 (37.7387756468895, -122.421531918974)
30540 37494 1 141 1050 Kirkham St 3 1 1 1 1 06/22/1998 12:00:00 AM     Permit Number 39963 5991661.12122197 2105245.54821547 37.7601232248942 -122.47194237971901 (37.7601232248942, -122.471942379719)
51436 38304 1 141 2000 Folsom St 12 1 1 1 1 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.765290989194895 -122.415396349695 (37.7652909891949, -122.415396349695)
53180 52915 1 141 3017th ST Ord St 1 1 1 1   07/26/2006 12:00:00 AM     Permit Number 48903 6000815.25066305 2106175.88788155 37.7632031545323 -122.44034940790199 (37.7632031545323, -122.440349407902)
56275 87953 1 141 495 Harkness Ave 3 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151.0 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171)
75291 38313 1 141 2000 Folsom St 15 1 1 1 1 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.765290989194895 -122.415396349695 (37.7652909891949, -122.415396349695)
76396 38314 1 141 2000 Folsom St 17 1 1 1 1 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.765290989194895 -122.415396349695 (37.7652909891949, -122.415396349695)
77802 34649 1 141 1735 27th Ave 1 1 1 1 1 07/28/1997 12:00:00 AM     Permit Number 40399 5987784.82467276 2103483.81569075 37.755060924081896 -122.485219205847 (37.7550609240819, -122.485219205847)
77886 39818 1 141 2101 46th Ave 2 1 1 1   01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713)
79153 100847 2 141 1 Estero Ave 5 9 1 1           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695)
79464 84884 1 141 2895 HARRISON St 1 1 1 1   04/03/2007 12:00:00 AM     Permit No. 49261 6009003.0 2101605.0 37.7511153190475 -122.41170761434401 (37.7511153190475, -122.411707614344)
80879 45274 1 141 635 Crescent Ave 4 1 1 1 1 06/12/2001 12:00:00 AM     Permit Number 44117 6007835.54663504 2095717.89639114 37.734885079654 -122.415328087742 (37.734885079654, -122.415328087742)
81792 85021 1 141 299 Maywood Dr 2 1 1 1           5994525.0 2094707.0 37.7313523209144 -122.46127371080699 (37.7313523209144, -122.461273710807)
81862 43115 1 141 200 Appleton Ave 4 1 1 1 1 12/13/2003 12:00:00 AM     Permit Number 42938 6005863.0139999995 2096788.574 37.7377138611244 -122.422223875233 (37.7377138611244, -122.422223875233)
82212 31943 1 141 1300 La Playa St 2 1 1 1 1 01/25/2011 12:00:00 AM   3x3 Permit Number 767126 5980916.9213303 2106151.77480086 37.761983899941 -122.50916807626999 (37.761983899941, -122.50916807627)
82793 95708 1 141 277 Athens St   1 1 1 1 09/07/2011 12:00:00 AM   3x3 Permit Number 767467 6004392.0 2091652.0 37.7235268927559 -122.42694415274201 (37.7235268927559, -122.426944152742)
84154 100531 2 141 689 Noe St 1 1 1 1       3x3   6003067.0 2104228.0 37.7579826742399 -122.432422230009 (37.7579826742399, -122.432422230009)
85007 39841 1 141 3151 Ortega St 4 1 1 1 1 01/06/1999 12:00:00 AM     Permit Number 41160 5984281.43555925 2102217.56111428 37.751379430941896 -122.49724128025 (37.7513794309419, -122.49724128025)
85547 105002 1 141 3418 26th St 1 1 1 1       4x6 Permit Number 768912 6006889.6 2100911.6 37.7490926180804 -122.41896681303899 (37.7490926180804, -122.418966813039)
85976 101171 2 141 420 Noe St 2 1 1 1       3x3   6002934.0 2105795.0 37.7622777366985 -122.432994152167 (37.7622777366985, -122.432994152167)
87119 112572 6 141 162 GRAND VIEW AVE 4 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
88355 39819 1 141 2101 46th Ave 3 1 1 1   01/06/1999 12:00:00 AM     Permit Number 41148 5981978.01419846 2100783.80216684 37.7473074654157 -122.505100399713 (37.7473074654157, -122.505100399713)
88393 48360 1 141 246 Jersey St 1 1 1 1   07/17/2002 12:00:00 AM     Permit Number 45771 6003531.328367599 2101591.65736703 37.7507702195134 -122.430628266841 (37.7507702195134, -122.430628266841)
88738 84911 1 141 5546 Anza St 5 1 1 1   04/03/2007 12:00:00 AM     Permit No. 49266 5981488.0 2111676.0 37.77718546664779 -122.507602896513 (37.7771854666478, -122.507602896513)
89829 48635 1 141 1436 17th Ave 1 1 1 1 1 08/30/2002 12:00:00 AM     Permit Number 45929 5990866.95707843 2105617.12188587 37.761097481488 -122.474716107382 (37.761097481488, -122.474716107382)
90911 87089 1 141 2533 Baker St 1 1 1 1       3x3 Permit Number 50041 5999658.0 2117512.0 37.7942632496373 -122.445166988043 (37.7942632496373, -122.445166988043)
92494 92495 1 141 3626 Vicente St 2 1 1 1 1 07/31/2009 12:00:00 AM   3x3 Permit Number 52865 5981730.0 2097424.0 37.7380677850415 -122.505708970967 (37.7380677850415, -122.505708970967)
93049 84597 1 141 495 Harkness Ave 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010148.19523638 2089662.82896813 37.7183888412655 -122.406905789617 (37.7183888412655, -122.406905789617)
93565 44342 1 141 187 Peralta Ave 1 1 1 1   06/11/2010 12:00:00 AM   3x3 Permit Number 53500 6009836.45355968 2099988.51839254 37.7467235364285 -122.40871140598699 (37.7467235364285, -122.408711405987)
93688 92427 1 141 1601 39th Ave 4 1 1 1 1 07/29/2009 12:00:00 AM   3x3 Permit Number 52817 5984021.0 2104223.4 37.75687164036479 -122.49829001409701 (37.7568716403648, -122.498290014097)
94222 92433 1 141 2367 42nd Ave 1 1 1 1 1 07/30/2009 12:00:00 AM   3x3 Permit Number 52823 5983266.6 2099037.7 37.7425888819276 -122.50051554919399 (37.7425888819276, -122.500515549194)
94939 96910 1 141 1399X 48TH AVE 1 1 1 1   08/08/2011 12:00:00 AM   3x3 Permit Number 768110 5981210.0 2105881.0 37.7612577047615 -122.50813435133699 (37.7612577047615, -122.508134351337)
96402 39743 1 141 3944 21st St 1 1 1 1 1 01/05/1999 12:00:00 AM     Permit Number 41110 6002294.13129656 2103577.97626079 37.7561540096169 -122.435048644634 (37.7561540096169, -122.435048644634)
96421 94199 1 141 355 Ocean Ave 7 1 1 1       3x3 Permit Number 53723 5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
97243 52914 1 141 3017th ST Ord St 2 1 1 1   07/26/2006 12:00:00 AM     Permit Number 48903 6000815.25066305 2106175.88788155 37.7632031545323 -122.44034940790199 (37.7632031545323, -122.440349407902)
97316 52308 1 141 464@ NOE 30th St 1 1 1 1 1 12/05/2005 12:00:00 AM     Permit Number 48468 6003585.05710238 2098376.65012733 37.7419456008039 -122.43021312904301 (37.7419456008039, -122.430213129043)
97394 58598 2 141 4966 17th St 1 10 1 1   04/19/1979 12:00:00 AM     Permit Number 17804 5997580.2349427 2105651.04183436 37.761577335837295 -122.45150033551 (37.7615773358373, -122.45150033551)
97832 91387 1 141 45 Rosewood Dr 1 1 1 1   03/12/2009 12:00:00 AM   3x3 Permit Number 52084 5994820.0 2095684.0 37.7340518973123 -122.460324610216 (37.7340518973123, -122.460324610216)
97897 87951 1 141 495 Harkness Ave 1 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151.0 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171)
98220 105004 1 141 3418 26th St 2 1 1 1       16x4 Permit Number 768912 6006889.6 2100911.6 37.7490926180804 -122.41896681303899 (37.7490926180804, -122.418966813039)
99720 39840 1 141 3151 Ortega St 3 1 1 1 1 01/06/1999 12:00:00 AM     Permit Number 41160 5984281.43555925 2102217.56111428 37.751379430941896 -122.49724128025 (37.7513794309419, -122.49724128025)
100652 101029 3 141 1010X Portola Dr 3 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
101064 37495 1 141 1050 Kirkham St 2 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42243 5991661.12122197 2105245.54821547 37.7601232248942 -122.47194237971901 (37.7601232248942, -122.471942379719)
101736 94195 1 141 355 Ocean Ave 3 1 1 1       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
102259 94194 1 141 355 Ocean Ave 2 1 1 1       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
102339 113744 6 141 909 ASHBURY ST 1 8 1 1       3x3   5999156.0 2107025.0 37.7654399906909 -122.44614926226002 (37.7654399906909, -122.44614926226)
102403 38373 1 141 3741 Noriega St 1 1 1 1 1 07/25/2014 12:00:00 AM     Permit Number 40432 5982426.74388672 2102835.76429046 37.7529679717779 -122.50370069063601 (37.7529679717779, -122.503700690636)
102533 112571 2 141 162 GRAND VIEW AVE 3 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
103769 34376 1 141 159 Laidley St 1 1 1 1 1 07/14/1997 12:00:00 AM     Permit Number 38128 6003933.5588278 2097472.84374368 37.73948368854229 -122.42894370039 (37.7394836885423, -122.42894370039)
103781 116969 2 141 2648 BRYANT ST 2 1 1 1       3x3   6009729.0 2101911.0 37.751996226816296 -122.409218610644 (37.7519962268163, -122.409218610644)
105205 80063 1 141 830 Teresita Blvd 1 1 1 1   10/25/2007 12:00:00 AM   3x3 Permit Number 49842 5999067.87770464 2095624.46606775 37.734131869592204 -122.44563415277 (37.7341318695922, -122.44563415277)
105312 122403 2 141 400X Circular Ave 1 5 1 1       3x3   5999746.0 2093731.0 37.7289715465039 -122.443153734972 (37.7289715465039, -122.443153734972)
105617 97301 1 141 1051 Portola Dr 4 9 1 1   09/20/2011 12:00:00 AM     Permit Number 768134 5995688.7 2098126.6 37.7408086112536 -122.457497926865 (37.7408086112536, -122.457497926865)
105655 100846 2 141 1 Estero Ave 4 9 1 1           5992057.7 2091642.6 37.7227959320346 -122.469580550695 (37.7227959320346, -122.469580550695)
106505 51283 1 141 3999 Mission St 1 1 1 1   08/24/2004 12:00:00 AM     Permit Number 47655 6004645.53227808 2095323.45859057 37.7336222359392 -122.426329013444 (37.7336222359392, -122.426329013444)
106648 51282 1 141 3999 Mission St 2 1 1 1   08/24/2004 12:00:00 AM     Permit Number 47655 6004645.53227808 2095323.45859057 37.7336222359392 -122.426329013444 (37.7336222359392, -122.426329013444)
106660 88115 1 141 4133 Kirkham St   1 1 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51116 5982072.0 2104866.0 37.758521560647395 -122.505077887073 (37.7585215606474, -122.505077887073)
106849 52483 1 141 650MAYFLOWER Peralta Ave 1 1 1 1 1 12/28/2005 12:00:00 AM     Permit Number 48593 6009757.299945901 2098381.34570201 37.742306158146796 -122.408871740084 (37.7423061581468, -122.408871740084)
107077 87952 1 141 495 Harkness Ave 2 1 1 1   06/19/2008 12:00:00 AM   3x3 Permit Number 50978 6010151.0 2089645.9 37.7183425147467 -122.406894902171 (37.7183425147467, -122.406894902171)
107765 82985 1 141 460 Ellsworth St 1 1 1 1   06/18/2008 12:00:00 AM   3x3 Permit Number 50922 6008017.64496893 2096716.02509924 37.737635955917604 -122.414769124009 (37.7376359559176, -122.414769124009)
108413 51417 1 141 5 Parnassus Ave 1 1 1 1   10/18/2004 12:00:00 AM     Permit Number 47742 5998697.89125775 2106894.30410502 37.765054960609206 -122.447724339473 (37.7650549606092, -122.447724339473)
109900 92405 1 141 1549 35th Ave 1 1 1 1 1 07/29/2009 12:00:00 AM   3x3 Permit Number 52804 5985246.8 2104672.6 37.7581768205908 -122.494083909336 (37.7581768205908, -122.494083909336)
109924 38307 1 141 2000 Folsom St 10 1 1 1 1 07/27/1998 12:00:00 AM     Permit Number 40376 6008042.39215173 2106787.37094181 37.765290989194895 -122.415396349695 (37.7652909891949, -122.415396349695)
110881 84885 1 141 2895 HARRISON St 2 1 1 1   04/03/2007 12:00:00 AM     Permit No. 49261 6009003.0 2101605.0 37.7511153190475 -122.41170761434401 (37.7511153190475, -122.411707614344)
110980 92426 1 141 1601 39th Ave 3 1 1 1 1 07/29/2009 12:00:00 AM   3x3 Permit Number 52817 5984021.0 2104223.4 37.75687164036479 -122.49829001409701 (37.7568716403648, -122.498290014097)
111863 88113 1 141 3345 Kirkham St 1 1 1 1   07/01/2008 12:00:00 AM   3x3 Permit Number 51115 5984516.0 2104948.0 37.7588902030811 -122.49663161711 (37.7588902030811, -122.49663161711)
112057 88275 1 141 1910 33rd Ave   1 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51266 5986038.6 2102202.7 37.7514414512274 -122.49116379172399 (37.7514414512274, -122.491163791724)
112460 45271 1 141 635 Crescent Ave 1 1 1 1   06/12/2001 12:00:00 AM     Permit Number 44117 6007835.54663504 2095717.89639114 37.734885079654 -122.415328087742 (37.734885079654, -122.415328087742)
112935 105001 1 141 3418 26th St 1 1 1 1       4x6   6006889.6 2100911.6 37.7490926180804 -122.41896681303899 (37.7490926180804, -122.418966813039)
113311 94193 1 141 355@ Delano Ave Ocean Ave 1 1 1 1       3x3   5999419.6 2091436.9 37.7226538624451 -122.444117342662 (37.7226538624451, -122.444117342662)
113590 121655 2 141 472 Dewey Blvd 1 1 1 1       3x3   5994766.0 2100099.0 37.746171285406106 -122.460831166054 (37.7461712854061, -122.460831166054)
114450 100532 2 141 685 Noe St 1 1 1 1       3x3   6003065.0 2104250.0 37.7580429675673 -122.432430718154 (37.7580429675673, -122.432430718154)
115060 39187 1 141 1189 South Van Ness Ave 1 1 1 1 1 11/19/1998 12:00:00 AM     Permit Number 40841 6007685.90483064 2102746.1551156 37.7541746987817 -122.41634309806801 (37.7541746987817, -122.416343098068)
115100 43116 1 141 200 Appleton Ave 5 1 1 1 1 12/13/2003 12:00:00 AM     Permit Number 42938 6005863.0139999995 2096788.574 37.7377138611244 -122.422223875233 (37.7377138611244, -122.422223875233)
115216 87092 1 141 2533 Baker St 4 1 1 1       3x3 Permit Number 50041 5999658.0 2117512.0 37.7942632496373 -122.445166988043 (37.7942632496373, -122.445166988043)
116601 37496 1 141 1050 Kirkham St 4 1 1 1 1 06/22/1998 12:00:00 AM     Permit Number 39963 5991661.12122197 2105245.54821547 37.7601232248942 -122.47194237971901 (37.7601232248942, -122.471942379719)
116722 94139 1 141 864 Ashbury St 1 1 1 1   06/11/2010 12:00:00 AM   3x3 Permit Number 53506 5999177.0 2107299.0 37.7661935250869 -122.44609633854601 (37.7661935250869, -122.446096338546)
117877 112570 2 141 162 GRAND VIEW AVE 2 8 1 1       3x3   6000754.0 2103380.0 37.7555228430156 -122.440360729392 (37.7555228430156, -122.440360729392)
118355 41859 1 141 1050 Kirkham St 1 1 1 1 1 06/20/2000 12:00:00 AM     Permit Number 42243 5991661.12122197 2105245.54821547 37.7601232248942 -122.47194237971901 (37.7601232248942, -122.471942379719)
118666 51416 1 141 611 Frederick St 1 1 1 1 1 10/18/2004 12:00:00 AM     Permit Number 47741 5996652.56500142 2107304.20235687 37.7660633258868 -122.454828195737 (37.7660633258868, -122.454828195737)
119290 92789 1 141 99 Buena Vista Ter 2 1 1 1       3x3 Permit Number 53006 6001506.4 2107657.3 37.7673100756575 -122.438065079874 (37.7673100756575, -122.438065079874)
119712 122589 2 141 2500X Lyon St 9 11 1 1       10x20   5999276.0 2117538.0 37.794312827392396 -122.446490617691 (37.7943128273924, -122.446490617691)
120307 87090 1 141 2533 Baker St 2 1 1 1       3x3 Permit Number 50041 5999658.0 2117512.0 37.7942632496373 -122.445166988043 (37.7942632496373, -122.445166988043)
120720 97410 1 141 4 Pacheco St 1 1 1 1           5995213.5 2099104.4 37.743466100167 -122.459211767689 (37.743466100167, -122.459211767689)
120845 92492 1 141 1936 Vicente St 1 1 1 1 1 07/31/2009 12:00:00 AM   3x3 Permit Number 52862 5986966.0 2097599.0 37.73885506412971 -122.487618605313 (37.7388550641297, -122.487618605313)
121468 115243 1 141 625 47th Ave 1 1 1 1   01/20/2016 12:00:00 AM     Permit Number 775511 5981292.5 2111469.1 37.776605861396796 -122.50826381996201 (37.7766058613968, -122.508263819962)
121469 45273 1 141 635 Crescent Ave 3 1 1 1   06/12/2001 12:00:00 AM     Permit Number 44117 6007835.54663504 2095717.89639114 37.734885079654 -122.415328087742 (37.734885079654, -122.415328087742)
Powered by Datasette · Query took 14.813ms · Data source: data.sfgov.org