sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
362 187139 3 47 2301 Sunset Blvd 1 9 1 1     39 Width 0ft   5984937.035 2099496.8257 37.7439474344515 -122.494773601416 (37.7439474344515, -122.494773601416)
682 251365 5 47 138x Gladeview Way 2 9 1 1                    
712 251366 5 47 138x Gladeview Way 3 9 1 1                    
713 251364 5 47 138x Gladeview Way 1 9 1 1                    
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)
869 124177 3 47 8X Almaden Ct 1 9 1 2     10 Width 9ft   5995876.0 2112606.0 37.7805760973259 -122.457897862346 (37.7805760973259, -122.457897862346)
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)
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)
1736 251677 2 47 772x Panorama Dr 1 9 1 1       3x3   5996636.0 2102785.0 37.7536537924326 -122.454558985212 (37.7536537924326, -122.454558985212)
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
3142 217765 2 47 470 West Portal Ave 4 9 1 1     42 Width 10ft   5991548.70787 2096139.0246599999 37.7351125606845 -122.471667523249 (37.7351125606845, -122.471667523249)
9640 114128 2 47 1200X JUNIPERO SERRA BLVD 21 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9648 114133 2 47 1200X JUNIPERO SERRA BLVD 26 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9649 114125 2 47 1200X JUNIPERO SERRA BLVD 18 9 1 1     18     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9650 114131 2 47 1200X JUNIPERO SERRA BLVD 24 9 1 1     30     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9662 114130 2 47 1200X JUNIPERO SERRA BLVD 23 9 1 1     24     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9664 114135 2 47 1200X JUNIPERO SERRA BLVD 30 9 1 1     28     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9666 114127 2 47 1200X JUNIPERO SERRA BLVD 20 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9669 114126 2 47 1200X JUNIPERO SERRA BLVD 19 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9671 114132 2 47 1200X JUNIPERO SERRA BLVD 25 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9673 114129 2 47 1200X JUNIPERO SERRA BLVD 22 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9678 114134 2 47 1200X JUNIPERO SERRA BLVD 28 9 1 1     36     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9720 173652 2 47 65 ZIRCON PL 2 9 1 1           6002398.2 2098694.7 37.7427515964219 -122.43433962698201 (37.7427515964219, -122.434339626982)
18889 106642 2 47 4540X 17TH ST 1 9 1 1     24     5999139.0 2105833.0 37.762166086231204 -122.446122313424 (37.7621660862312, -122.446122313424)
23418 186415 2 47 1601 Sunset Blvd 3 9 1 1     2 Width 0ft   5984728.3813 2104210.7037 37.756878233428004 -122.49584272637699 (37.756878233428, -122.495842726377)
23551 181443 2 47 1400 Sunset Blvd 3 9 1 1     35 Width 0ft   5984892.2857 2105061.2409 37.759223169955796 -122.495338616437 (37.7592231699558, -122.495338616437)
23770 186402 2 47 1801 Sunset Blvd 69 9 1 1     99 Width 0ft   5984820.6527 2102319.266 37.7516902715465 -122.495384132242 (37.7516902715465, -122.495384132242)
23880 187141 2 47 2301 Sunset Blvd 3 9 1 1     52 Width 0ft   5984898.7676 2099479.6664 37.7438980796356 -122.494904654416 (37.7438980796356, -122.494904654416)
24028 186361 2 47 1801 Sunset Blvd 28 9 1 1     99 Width 0ft   5984795.4735 2102590.7965 37.752434345234 -122.495491228463 (37.752434345234, -122.495491228463)
24265 184994 2 47 2701 Sunset Blvd 20 9 1 1     52 Width 0ft   5984981.6045 2096535.6021 37.735819319769895 -122.494401253367 (37.7358193197699, -122.494401253367)
24469 186067 2 47 1901 Sunset Blvd 13 9 1 1     51 Width 0ft   5984814.1882 2102091.1256 37.751063482205 -122.495389663196 (37.751063482205, -122.495389663196)
24694 206882 2 47 355 Parnassus Ave 10 9 1 1     24 Width 5ft   5996132.622880001 2106470.43448 37.7637441750665 -122.456566260324 (37.7637441750665, -122.456566260324)
24834 185543 2 47 2201 Sunset Blvd 27 9 1 1     46 Width 0ft   5984873.6046 2099981.069 37.7452733220295 -122.49502862542 (37.7452733220295, -122.49502862542)
25143 126422 2 47 71 MacOndray Ln 3 9 1 1     40     6008381.99212 2119124.63634 37.7991852374601 -122.415095094385 (37.7991852374601, -122.415095094385)
25480 181380 2 47 1500 Sunset Blvd 13 9 1 1     20 Width 0ft   5984920.3702 2104474.5517 37.757613928882606 -122.49519822357901 (37.7576139288826, -122.495198223579)
25632 185934 2 47 2000 Sunset Blvd 77 9 1 1     25 Width 0ft   5984996.9702 2101528.251 37.74952868337 -122.494716099913 (37.74952868337, -122.494716099913)
25740 187008 2 47 2501 Sunset Blvd 27 9 1 1     99 Width 0ft   5984967.4388 2098043.05 37.739957538540295 -122.49456132318899 (37.7399575385403, -122.494561323189)
25920 205918 2 47 506 Congo St 4 9 1 1     33 Width 5ft   6000129.127169999 2095289.54923 37.7332727986918 -122.441941059826 (37.7332727986918, -122.441941059826)
25921 181412 2 47 1500 Sunset Blvd 45 9 1 1     10 Width 0ft   5984910.1084 2104727.9008 37.758308954313996 -122.495252395507 (37.758308954314, -122.495252395507)
26008 186451 2 47 1601 Sunset Blvd 39 9 1 1     41 Width 0ft   5984745.9677 2103899.5919999997 37.7560250369708 -122.495758958747 (37.7560250369708, -122.495758958747)
26145 185549 2 47 2201 Sunset Blvd 33 9 1 1     70 Width 0ft   5984904.1167 2099896.1658 37.745041987094396 -122.49491686223999 (37.7450419870944, -122.49491686224)
26275 223757 2 47 5745 Diamond Heights Blvd 1 9 1 1     13 Width 10ft   6000755.6342 2096957.8752099997 37.7378893137452 -122.439894635432 (37.7378893137452, -122.439894635432)
26631 185883 2 47 2000 Sunset Blvd 26 9 1 1     4 Width 0ft   5985034.4251 2101120.3406 37.7484108651264 -122.494556514447 (37.7484108651264, -122.494556514447)
26684 185578 2 47 2201 Sunset Blvd 62 9 1 1     80 Width 0ft   5984888.727999999 2099615.9854 37.744271786934796 -122.49494941784201 (37.7442717869348, -122.494949417842)
26770 186065 2 47 1901 Sunset Blvd 11 9 1 1     13 Width 0ft   5984846.241 2102114.0204 37.751128221750704 -122.49528051122299 (37.7511282217507, -122.495280511223)
26964 186346 2 47 1801 Sunset Blvd 13 9 1 1     47 Width 0ft   5984814.4902 2102762.482 37.752906859827704 -122.49543812761401 (37.7529068598277, -122.495438127614)
27038 119401 2 47 3150 Cabrillo St 2 9 1 1     10 Width 3ft   5985750.26334 2110481.7384 37.774156534172505 -122.492770599571 (37.7741565341725, -122.492770599571)
27053 187052 2 47 2501 Sunset Blvd 71 9 1 1     40 Width 0ft   5984975.6777 2097633.6281 37.7388338582522 -122.494502663013 (37.7388338582522, -122.494502663013)
27316 187183 2 47 2301 Sunset Blvd 45 9 1 1     10 Width 0ft   5984940.3895 2099200.21 37.74313320442471 -122.494740138503 (37.7431332044247, -122.494740138503)
27513 186961 2 47 2800 Sunset Blvd 35 9 1 1     39 Width 0ft   5985200.1141 2096126.2386 37.7347081021486 -122.493615636331 (37.7347081021486, -122.493615636331)
27837 187145 2 47 2301 Sunset Blvd 7 9 1 1     43 Width 0ft   5984892.4139 2099447.2487 37.743808697483395 -122.49492423393801 (37.7438086974834, -122.494924233938)
27914 186438 2 47 1601 Sunset Blvd 26 9 1 1     38 Width 0ft   5984733.406 2103998.8295 37.756296779959996 -122.495809720693 (37.75629677996, -122.495809720693)
28097 184746 2 47 1301 Sunset Blvd 12 9 1 1     73 Width 0ft   5984670.325 2106153.0915 37.7622080878104 -122.49618680876499 (37.7622080878104, -122.496186808765)
28368 185036 2 47 2701 Sunset Blvd 62 9 1 1     1 Width 0ft   5984991.2351 2096277.6682 37.7351116657323 -122.494348950198 (37.7351116657323, -122.494348950198)
28570 187221 2 47 2401 Sunset Blvd 4 9 1 1     73 Width 0ft   5984920.4721 2098768.3716 37.7419463270938 -122.494777174832 (37.7419463270938, -122.494777174832)
28666 223807 2 47 177 Moffitt St 6 9 1 1     4 Width 2ft   6002423.3723 2097053.0195400002 37.7382453517447 -122.434135255635 (37.7382453517447, -122.434135255635)
28910 114708 2 47 500X CONGO ST 2 9 1 1       3x10   6000185.0 2095264.0 37.733205830187 -122.441746059696 (37.733205830187, -122.441746059696)
29069 186197 2 47 1701 Sunset Blvd 8 9 1 1     66 Width 0ft   5984786.367000001 2103519.1304 37.7549827606067 -122.49559118568399 (37.7549827606067, -122.495591185684)
29091 186379 2 47 1801 Sunset Blvd 46 9 1 1     80 Width 0ft   5984812.5721 2102477.6444 37.7521246619181 -122.495423755128 (37.7521246619181, -122.495423755128)
29197 186442 2 47 1601 Sunset Blvd 30 9 1 1     40 Width 0ft   5984767.7413 2103942.7205 37.756144730979294 -122.49568684061 (37.7561447309793, -122.49568684061)
29359 181512 2 47 1400 Sunset Blvd 72 9 1 1     9 Width 0ft   5984867.501 2105563.3396 37.760600341747896 -122.495461364037 (37.7606003417479, -122.495461364037)
30477 206884 2 47 355 Parnassus Ave 8 9 1 1     20 Width 5ft   5996099.70651 2106459.36925 37.7637119028988 -122.456679306927 (37.7637119028988, -122.456679306927)
30529 102468 2 47 50 Saint Germain Ave 1 9 1 1           5998217.7 2104179.8 37.757574157371295 -122.44918961776699 (37.7575741573713, -122.449189617767)
30698 186366 2 47 1801 Sunset Blvd 33 9 1 1     2 Width 0ft   5984834.9283 2102546.5983 37.7523152993529 -122.49535152997 (37.7523152993529, -122.49535152997)
31264 185017 2 47 2701 Sunset Blvd 43 9 1 1     4 Width 0ft   5985031.8513 2096412.4973 37.735484247333396 -122.494218462115 (37.7354842473334, -122.494218462115)
31709 185542 2 47 2201 Sunset Blvd 26 9 1 1     17 Width 0ft   5984918.1788 2099988.2327 37.745295600955295 -122.494875025672 (37.7452956009553, -122.494875025672)
32009 185077 2 47 2801 Sunset Blvd 5 9 1 1     4 Width 0ft   5985040.4352 2096082.543 37.7345787830951 -122.49416447312599 (37.7345787830951, -122.494164473126)
32582 181404 2 47 1500 Sunset Blvd 37 9 1 1     21 Width 0ft   5984893.3996 2104690.5846 37.7582055161201 -122.49530742906799 (37.7582055161201, -122.495307429068)
32968 187010 2 47 2501 Sunset Blvd 29 9 1 1     2 Width 0ft   5984953.6513 2098022.8732 37.7399013315107 -122.494607506859 (37.7399013315107, -122.494607506859)
33235 186398 2 47 1801 Sunset Blvd 65 9 1 1     48 Width 0ft   5984807.1851 2102369.0959 37.751826302179104 -122.495434378973 (37.7518263021791, -122.495434378973)
34251 185991 2 47 2001 Sunset Blvd 50 9 1 1     49 Width 0ft   5984838.2048 2101005.2084 37.748083257257704 -122.495226540797 (37.7480832572577, -122.495226540797)
34543 123503 2 47 2550 Fulton St 2 9 1 1     11 Width 1ft   5995405.4626400005 2110341.7489400003 37.774332019483296 -122.459361641514 (37.7743320194833, -122.459361641514)
34630 205915 2 47 506 Congo St 1 9 1 1     8 Width 5ft   6000129.85009 2095267.01455 37.7332109649183 -122.44193694363199 (37.7332109649183, -122.441936943632)
34686 185644 2 47 2100 Sunset Blvd 24 9 1 1     15 Width 0ft   5985051.8314 2100455.4756 37.746586345742 -122.49444732076401 (37.746586345742, -122.494447320764)
34831 186018 2 47 1900 Sunset Blvd 13 9 1 1     49 Width 0ft   5985010.437999999 2101834.6115 37.7503706537303 -122.49469211198401 (37.7503706537303, -122.494692111984)
35059 181449 2 47 1400 Sunset Blvd 9 9 1 1     23 Width 0ft   5984873.9061 2105087.418 37.759293968823705 -122.49540411159401 (37.7592939688237, -122.495404111594)
35232 186940 2 47 2800 Sunset Blvd 14 9 1 1     49 Width 0ft   5985184.4751 2095979.7701 37.734305023711 -122.49365891568 (37.734305023711, -122.49365891568)
35634 187197 2 47 2301 Sunset Blvd 59 9 1 1     35 Width 0ft   5984932.9821 2099043.9135 37.7427036229391 -122.49475423012899 (37.7427036229391, -122.494754230129)
35760 223799 2 47 8 Laidley St 1 9 1 1     34     6003000.19412 2098305.51493 37.741717135947205 -122.43223031618601 (37.7417171359472, -122.432230316186)
35832 185569 2 47 2201 Sunset Blvd 53 9 1 1     36 Width 0ft   5984875.7272 2099710.7055 37.74453110155571 -122.495001354066 (37.7445311015557, -122.495001354066)
36089 206844 2 47 488 Ralston St 2 9 1 1     8 Width 5ft   5992249.47453 2091186.11142 37.72155360809921 -122.46888442997299 (37.7215536080992, -122.468884429973)
36102 186350 2 47 1801 Sunset Blvd 17 9 1 1     32 Width 0ft   5984802.9731 2102707.5748 37.7527554254133 -122.49547390604499 (37.7527554254133, -122.495473906045)
36127 184802 2 47 1301 Sunset Blvd 63 9 1 1     31 Width 0ft   5984710.1955 2105740.9062 37.7610786777919 -122.496018504161 (37.7610786777919, -122.496018504161)
36628 186839 2 47 1200 Sunset Blvd 83 9 1 1     2 Width 0ft   5984830.1212 2106502.1656 37.7631759062792 -122.49565989156099 (37.7631759062792, -122.495659891561)
36835 205892 2 47 25 Stanford Heights Ave 4 9 1 1     6 Width 3ft   5997819.94601 2095725.4811900002 37.734337906251504 -122.44995590246 (37.7343379062515, -122.44995590246)
37438 223805 2 47 177 Moffitt St 4 9 1 1     4 Width 2ft   6002415.23965 2097063.15602 37.7382727226024 -122.434164098718 (37.7382727226024, -122.434164098718)
37595 205891 2 47 25 Stanford Heights Ave 3 9 1 1     8 Width 3ft   5997820.03941 2095729.96315 37.73435021798711 -122.44995590246201 (37.7343502179871, -122.449955902462)
37975 206886 2 47 355 Parnassus Ave 6 9 1 1     22 Width 5ft   5996058.56562 2106445.76375 37.76367218344 -122.456820615576 (37.76367218344, -122.456820615576)
38102 187181 2 47 2301 Sunset Blvd 43 9 1 1     30 Width 0ft   5984923.7228 2099208.7285 37.7431556183483 -122.49479839457199 (37.7431556183483, -122.494798394572)
38104 186079 2 47 1901 Sunset Blvd 25 9 1 1     9 Width 0ft   5984809.2191 2101997.6508 37.7508065351253 -122.495399953486 (37.7508065351253, -122.495399953486)
38149 186297 2 47 1800 Sunset Blvd 35 9 1 1     30 Width 0ft   5984967.576 2102696.5961 37.7527349178342 -122.494903878472 (37.7527349178342, -122.494903878472)
38386 186162 2 47 1700 Sunset Blvd 47 9 1 1     20 Width 0ft   5984944.9381 2103398.2721 37.75466020146371 -122.495033898572 (37.7546602014637, -122.495033898572)
38529 184787 2 47 1301 Sunset Blvd 48 9 1 1     43 Width 0ft   5984684.7543 2105859.3786 37.7614024796931 -122.49611523377199 (37.7614024796931, -122.496115233772)
38550 205889 2 47 25 Stanford Heights Ave 1 9 1 1     11 Width 3ft   5997824.88709 2095746.51675 37.734395947598 -122.449940335175 (37.734395947598, -122.449940335175)
38624 223803 2 47 177 Moffitt St 2 9 1 1     4 Width 2ft   6002410.1357 2097069.9071099998 37.7382909698537 -122.43418222813 (37.7382909698537, -122.43418222813)
38774 185685 2 47 2101 Sunset Blvd 17 9 1 1     43 Width 0ft   5984846.0505 2100610.3074 37.7469994262442 -122.49517029441002 (37.7469994262442, -122.49517029441)
Powered by Datasette · Query took 7.476ms · Data source: data.sfgov.org