sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5120 253810 2 3 281 Ralston St 5 9 1 1       3x6   5992187.95019 2089731.22021 37.7175552771373 -122.46899127483299 (37.7175552771373, -122.468991274833)
5078 253759 2 22 330 Twin Peaks Blvd 3 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5072 253758 2 22 330 Twin Peaks Blvd 2 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
5061 253757 2 22 330 Twin Peaks Blvd 1 9 1 1       3x6 Permit Number 780692 5998725.10706 2103975.38052 37.75704188115579 -122.44742009249201 (37.7570418811558, -122.447420092492)
4921 253716 2 21 2959 21st Ave 2 9 1 1       5x15   5989962.0 2095532.0 37.733353897105495 -122.477108940264 (37.7333538971055, -122.477108940264)
4919 253715 2 231 2959 21st Ave 1 9 1 1       5x15   5989962.0 2095532.0 37.733353897105495 -122.477108940264 (37.7333538971055, -122.477108940264)
4764 253679 2 39 94 Teresita Blvd 1 9 1 1       4x8   5997405.0 2099153.0 37.7437252916895 -122.45163765514201 (37.7437252916895, -122.451637655142)
4725 253667 2 226 2 Cabrillo St 2 9 1 1       Width 3ft   5995617.0 2110854.0 37.775750686051005 -122.458666990683 (37.775750686051, -122.458666990683)
4659 253652 6 3 131 Font Blvd 2 9 1 1       10x10   5990844.0 2088883.0 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248)
4344 253624 2 44 735 Teresita Blvd 1 9 1 1       3x3   5998960.0 2095994.0 37.735140362702396 -122.446033688862 (37.7351403627024, -122.446033688862)
3523 253474 4 16 134 Lunado Way 1 9 1 1       3x2   5991633.0 2092401.0 37.7248537561355 -122.471103859098 (37.7248537561355, -122.471103859098)
3577 253466 2 141 98X Marston Ave 5 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3544 253465 2 38 98X Marston Ave 4 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3585 253464 2 38 98X Marston Ave 3 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3567 253463 2 38 98X Marston Ave 2 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3561 253462 2 38 98X Marston Ave 1 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
2503 253120 1 3 815 Buena Vista Ave West 1 9 1 1       10x100   6000071.60031 2108311.04493 37.769023393565604 -122.44307478834801 (37.7690233935656, -122.443074788348)
3147 253098 6 3 1290 Portola Dr 2 9 1 2   08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
2399 253072 2 3 1350 46th Ave 1 9 1 1       5x10 Permit Number 780489 5981849.666569999 2105897.22193 37.761339917853896 -122.50592325662 (37.7613399178539, -122.50592325662)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
1680 251668 2 40 301x Laguna Honda Blvd 1 9 1 1       3x3   5995349.0 2100852.0 37.7482723626065 -122.458869747183 (37.7482723626065, -122.458869747183)
2015 251655 3 98 300x Chester Ave 1 9 1 2       3x3   5991691.0 2087193.0 37.710557214846794 -122.47052422929701 (37.7105572148468, -122.470524229297)
1500 251574 3 5 191 Portola Dr 1 9 1 2       3x3   5999731.0 2100707.0 37.748125134697 -122.443706547761 (37.748125134697, -122.443706547761)
1438 251533 2 60 1201X Pierce St 1 9 1 1       3x3   6002292.0 2112799.0 37.7814725496882 -122.43571571002899 (37.7814725496882, -122.435715710029)
1029 251428 2 47 5030 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1034 251427 2 3 5028 Diamond Heights Blvd 1 9 1 1       3x3   5999606.0 2100130.0 37.7465337016449 -122.44409733772801 (37.7465337016449, -122.444097337728)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
818 251389 2 3 202x Mangels Ave 1 9 1 1       3x3   5999774.0 2095231.0 37.7330917931436 -122.44316462438499 (37.7330917931436, -122.443164624385)
782 251385 2 47 138x Gladeview Way 2 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
784 251384 2 47 138x Gladeview Way 1 9 1 1       3x3   5997939.0 2102166.0 37.7520288182083 -122.45000833213699 (37.7520288182083, -122.450008332137)
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
545 251322 2 95 828 Foerster St 6 9 1 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
251 251258 2 65 1748x Eucalyptus Dr 2 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
241 251257 2 65 1748x Eucalyptus Dr 1 9 1 1       3x3   5986101.0 2094852.0 37.7312620395563 -122.490407299046 (37.7312620395563, -122.490407299046)
24522 251177 2 17 178 Bluxome St 1 9 1 1       3x3   6012557.0 2110038.0 37.7744691941496 -122.400009583897 (37.7744691941496, -122.400009583897)
22896 251145 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
22892 251144 6 103 200X Clarendon Ave 1 9 1 1       3x3   5996559.0 2104265.0 37.7577130831875 -122.454932197022 (37.7577130831875, -122.454932197022)
156361 250992 2 12 401 45th Ave 3 9 1 1     5 Width 6ft   5981868.90383 2112895.86911 37.7805572993057 -122.50637573525299 (37.7805572993057, -122.506375735253)
56135 250989 2 39 401 45th Ave 2 9 1 1     10     5981864.98937 2112954.2603599997 37.7807173939441 -122.506393608376 (37.7807173939441, -122.506393608376)
25083 250988 2 39 401 45th Ave 1 9 1 1     6     5981857.67732 2112961.27677 37.780736228431394 -122.50641942431999 (37.7807362284314, -122.50641942432)
26191 250755 2 21 2930 Lake St 1 9 1 1     4 Width 10ft   5986296.61932 2114541.51737 37.78533546029529 -122.491179523725 (37.7853354602953, -122.491179523725)
148512 250682 2 12 760 El Camino Del Mar 3 9 1 1     8 Width 4ft   5986116.1315 2114915.54539 37.7863518857815 -122.491831493528 (37.7863518857815, -122.491831493528)
57095 250681 2 12 760 El Camino Del Mar 2 9 1 1     7 Width 4ft   5986129.95377 2114905.93928 37.786326318052204 -122.49178296523701 (37.7863263180522, -122.491782965237)
40537 250680 2 12 760 El Camino Del Mar 1 9 1 1     8 Width 4ft   5986144.61668 2114895.8917799997 37.7862995875046 -122.491731496117 (37.7862995875046, -122.491731496117)
148317 250651 2 3 142 El Camino Del Mar 3 9 1 1     23 Width 4ft   5988051.29763 2115371.58762 37.78771696311829 -122.48516986981501 (37.7877169631183, -122.485169869815)
70053 250650 2 3 142 El Camino Del Mar 2 9 1 1     15 Width 4ft   5988068.63131 2115372.88737 37.787721541568 -122.48510999475401 (37.787721541568, -122.485109994754)
71820 250649 2 3 142 El Camino Del Mar 1 9 1 1     15 Width 4ft   5988079.239440001 2115372.9404 37.7877223050946 -122.485073297006 (37.7877223050946, -122.485073297006)
36196 250612 2 34 2201 Golden Gate Ave 37 9 1 1     32 Width 7ft   5998863.03763 2111421.5701099997 37.7774951176523 -122.447479040039 (37.7774951176523, -122.447479040039)
163635 250611 2 11 2201 Golden Gate Ave 36 9 1 1     5     5998832.7511599995 2111418.50425 37.7774849687826 -122.447583589827 (37.7774849687826, -122.447583589827)
31539 250610 2 11 2201 Golden Gate Ave 35 9 1 1     4     5998818.59622 2111415.77935 37.777476677952706 -122.44763236005899 (37.7774766779527, -122.447632360059)
185930 250609 2 11 2201 Golden Gate Ave 34 9 1 1     5     5998802.7301 2111413.8391299997 37.7774704438335 -122.447687106294 (37.7774704438335, -122.447687106294)
166559 250608 2 11 2201 Golden Gate Ave 33 9 1 1     5     5998787.15443 2111411.5145799997 37.777463171018205 -122.447740820088 (37.7774631710182, -122.447740820088)
169943 250607 2 11 2201 Golden Gate Ave 32 9 1 1     5     5998769.74892 2111409.2448299997 37.7774559440593 -122.447800867812 (37.7774559440593, -122.447800867812)
186988 250606 2 11 2201 Golden Gate Ave 31 9 1 1     5     5998755.1093 2111407.10323 37.777449227027795 -122.447851356665 (37.7774492270278, -122.447851356665)
152639 250605 2 11 2201 Golden Gate Ave 30 9 1 1     5     5998735.90805 2111405.0281 37.777442431746 -122.44791763041401 (37.777442431746, -122.447917630414)
149775 250604 2 11 2201 Golden Gate Ave 29 9 1 1     5     5998717.2926900005 2111402.6365099996 37.7774348009994 -122.44798185458099 (37.7774348009994, -122.447981854581)
164454 250603 2 11 2201 Golden Gate Ave 28 9 1 1     6     5998697.83635 2111399.4102 37.7774248302192 -122.448048927835 (37.7774248302192, -122.448048927835)
45361 250602 2 11 2201 Golden Gate Ave 27 9 1 1     5     5998679.25957 2111396.77415 37.7774165303825 -122.448113000908 (37.7774165303825, -122.448113000908)
44611 250601 2 11 2201 Golden Gate Ave 26 9 1 1     5     5998661.06901 2111393.5225 37.7774065623113 -122.44817569357201 (37.7774065623113, -122.448175693572)
50865 250599 2 34 2201 Golden Gate Ave 24 9 1 1     9 Width 10ft   5998631.4294 2111385.5677400003 37.7773830261474 -122.44827765331499 (37.7773830261474, -122.448277653315)
176192 250598 2 34 2201 Golden Gate Ave 23 9 1 1     26 Width 10ft   5998612.86839 2111383.01591 37.7773749583343 -122.448341677839 (37.7773749583343, -122.448341677839)
62280 250596 2 34 2201 Golden Gate Ave 21 9 1 1     23 Width 10ft   5998572.26922 2111378.3859099997 37.7773599243436 -122.44848178950899 (37.7773599243436, -122.448481789509)
137941 250595 2 34 2201 Golden Gate Ave 20 9 1 1     39     5998510.6665900005 2111373.95167 37.777344226694495 -122.44869457271099 (37.7773442266945, -122.448694572711)
52572 250594 2 34 2201 Golden Gate Ave 19 9 1 1     11 Width 7ft   5998426.00628 2111357.0235599997 37.7772929050689 -122.448986219244 (37.7772929050689, -122.448986219244)
162932 250593 2 34 2201 Golden Gate Ave 18 9 1 1     26 Width 7ft   5998409.0493 2111353.9501099996 37.7772834963756 -122.44904465719499 (37.7772834963756, -122.449044657195)
33389 250592 2 34 2201 Golden Gate Ave 17 9 1 1     23 Width 7ft   5998381.460969999 2111351.09812 37.7772740876697 -122.44913988818999 (37.7772740876697, -122.44913988819)
30950 250591 2 34 2201 Golden Gate Ave 16 9 1 1     25 Width 7ft   5998359.83298 2111349.05645 37.7772672447332 -122.44921455891199 (37.7772672447332, -122.449214558912)
131820 250590 2 34 2201 Golden Gate Ave 15 9 1 1     52     5998102.22715 2111312.63197 37.7771524948281 -122.45010307019501 (37.7771524948281, -122.450103070195)
52831 250589 2 34 2201 Golden Gate Ave 14 9 1 1     12     5997875.419290001 2111281.04875 37.7770527941865 -122.450885388659 (37.7770527941865, -122.450885388659)
23707 250588 2 34 2201 Golden Gate Ave 13 9 1 1     49     5997756.4661 2111264.0896400004 37.7769994185268 -122.45129565939399 (37.7769994185268, -122.451295659394)
65004 250587 2 34 2201 Golden Gate Ave 12 9 1 1     8 Width 8ft   5997646.23108 2111248.80698 37.776951143824 -122.451675891826 (37.776951143824, -122.451675891826)
70548 250586 2 34 2201 Golden Gate Ave 11 9 1 1     16 Width 8ft   5997628.86615 2111246.4251 37.7769436093046 -122.451735790285 (37.7769436093046, -122.451735790285)
24475 250585 2 34 2201 Golden Gate Ave 10 9 1 1     16 Width 8ft   5997613.33684 2111244.7016 37.7769379876264 -122.451789386298 (37.7769379876264, -122.451789386298)
25484 250584 2 34 2201 Golden Gate Ave 9 9 1 1     13     5997564.36038 2111236.37019 37.7769123065995 -122.451958208801 (37.7769123065995, -122.451958208801)
71537 250581 2 34 2201 Golden Gate Ave 6 9 1 1     30     5997509.5198800005 2111229.44513 37.776890150891795 -122.45214741807699 (37.7768901508918, -122.452147418077)
55672 250580 2 34 2201 Golden Gate Ave 5 9 1 1     19 Width 8ft   5997493.10232 2111228.13721 37.7768856192175 -122.45220411672399 (37.7768856192175, -122.452204116724)
26036 250579 2 34 2201 Golden Gate Ave 4 9 1 1     13 Width 8ft   5997478.12296 2111225.14885 37.7768765558548 -122.452255718936 (37.7768765558548, -122.452255718936)
177444 250578 2 34 2201 Golden Gate Ave 3 9 1 1     20 Width 8ft   5997460.213380001 2111222.95498 37.7768695060652 -122.452317514945 (37.7768695060652, -122.452317514945)
169298 250577 2 34 2201 Golden Gate Ave 2 9 1 1     21 Width 8ft   5997444.6396 2111219.7245400003 37.776859743909895 -122.452371155927 (37.7768597439099, -122.452371155927)
60845 250576 2 34 2201 Golden Gate Ave 1 9 1 1     30 Width 8ft   5997348.720930001 2111207.04633 37.7768194372103 -122.452702050664 (37.7768194372103, -122.452702050664)
50298 250575 2 34 600 Parker Ave 12 9 1 1     43     5997256.45682 2111186.28266 37.776757138456794 -122.453019719107 (37.7767571384568, -122.453019719107)
161181 250574 2 34 600 Parker Ave 11 9 1 1     33     5997258.88405 2111163.19525 37.77669388555061 -122.453009655693 (37.7766938855506, -122.453009655693)
72328 250573 2 34 600 Parker Ave 10 9 1 1     9     5997263.272609999 2111141.17003 37.7766336615401 -122.45299288421002 (37.7766336615401, -122.45299288421)
1387 250572 2 34 600 Parker Ave 9 9 1 1   05/15/2017 12:00:00 AM 3   Permit Number 779711 5997267.39343 2111112.94332 37.7765563945078 -122.45297659119 (37.7765563945078, -122.45297659119)
176048 250571 2 34 600 Parker Ave 8 9 1 1     11     5997270.54496 2111084.7365 37.7764791265377 -122.45296365267299 (37.7764791265377, -122.452963652673)
23781 250570 2 34 600 Parker Ave 7 9 1 1     24     5997272.199569999 2111059.97973 37.7764112457195 -122.452956141515 (37.7764112457195, -122.452956141515)
69246 250569 2 34 600 Parker Ave 6 9 1 1     31     5997276.1967400005 2111033.33857 37.7763383251004 -122.452940390794 (37.7763383251004, -122.452940390794)
146510 250568 2 34 600 Parker Ave 5 9 1 1     24     5997280.420030001 2111005.26169 37.7762614753232 -122.452923754242 (37.7762614753232, -122.452923754242)
Powered by Datasette · Query took 23.566ms · Data source: data.sfgov.org