sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
94709 117610 2 98 391 NEVADA ST 1 14 2 1       3x3   6008958.0 2096497.0 37.737087351465796 -122.41150238578501 (37.7370873514658, -122.411502385785)
84069 30163 3 98 410X Mansell St 20 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
97737 30166 3 98 410X Mansell St 25 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
100801 30165 3 98 410X Mansell St 22 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
107074 30054 3 98 610X Junipero Serra Blvd 7 11 1 2           5991361.953164 2093442.6103069999 37.7276980777014 -122.47211671569599 (37.7276980777014, -122.472116715696)
108499 30139 3 98 410X Mansell St 1 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
109841 30145 3 98 410X Mansell St 7 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
122746 30141 3 98 410X Mansell St 3 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139594 30164 3 98 410X Mansell St 21 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
139595 30143 3 98 410X Mansell St 5 11 1 2     0 POT   6010678.994322 2090457.6265959998 37.720600879856704 -122.405126964413 (37.7206008798567, -122.405126964413)
142517 102267 3 98 100X Casitas Ave 1 11 1 2     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065)
142952 102268 3 98 100X Casitas Ave 2 11 1 2     8 6x3   5995287.9 2097019.1 37.7377446590015 -122.458803572065 (37.7377446590015, -122.458803572065)
90472 120871 2 98 1387 08th Ave 1 10 2 1           5993606.0 2106068.0 37.762493810072606 -122.465275766733 (37.7624938100726, -122.465275766733)
2015 251655 3 98 300x Chester Ave 1 9 1 2       3x3   5991691.0 2087193.0 37.710557214846794 -122.47052422929701 (37.7105572148468, -122.470524229297)
31687 187056 2 98 2501 Sunset Blvd 75 9 1 1     2 Width 0ft   5984980.0493 2097557.2924 37.7386245167659 -122.49448192258001 (37.7386245167659, -122.49448192258)
31848 184755 2 98 1301 Sunset Blvd 25 9 1 1     3 Width 0ft   5984688.1718 2106071.0721 37.7619839309054 -122.496119032944 (37.7619839309054, -122.496119032944)
32844 184753 2 98 1301 Sunset Blvd 21 9 1 1     1 Width 0ft   5984707.1578 2106087.4001 37.76202987507679 -122.496054573405 (37.7620298750768, -122.496054573405)
34598 187054 2 98 2501 Sunset Blvd 73 9 1 1     2 Width 0ft   5984950.4566 2097599.3275 37.738738201883294 -122.494587336532 (37.7387382018833, -122.494587336532)
36265 181582 2 98 1200 Sunset Blvd 72 9 1 1     5 Width 0ft   5984863.0361 2106906.9776 37.7642893338004 -122.49557591115601 (37.7642893338004, -122.495575911156)
40776 181577 2 98 1200 Sunset Blvd 59 9 1 1     6 Width 0ft   5984846.2035 2106866.5794 37.76417742600729 -122.49563114953699 (37.7641774260073, -122.495631149537)
41030 185311 2 98 2601 Sunset Blvd 36 9 1 1     4 Width 0ft   5984965.5883 2097247.7465 37.737773740404 -122.49450910826799 (37.737773740404, -122.494509108268)
42436 187055 2 98 2501 Sunset Blvd 74 9 1 1     2 Width 0ft   5984955.8371 2097567.7171 37.738651723125294 -122.49456640389 (37.7386517231253, -122.49456640389)
47657 184756 2 98 1301 Sunset Blvd 29 9 1 1     2 Width 0ft   5984687.2225 2106057.4022 37.761946341588 -122.496121307582 (37.761946341588, -122.496121307582)
50614 184751 2 98 1301 Sunset Blvd 18 9 1 1     2 Width 0ft   5984675.641 2106097.6525 37.7620561792493 -122.4961643326 (37.7620561792493, -122.4961643326)
51487 186362 2 98 1801 Sunset Blvd 29 9 1 1     8 Width 0ft   5984819.5753 2102574.8802 37.7523920547151 -122.49540670794501 (37.7523920547151, -122.495406707945)
51786 185555 2 98 2201 Sunset Blvd 39 9 1 1     3 Width 0ft   5984902.7901 2099826.3861 37.7448503133319 -122.49491630522101 (37.7448503133319, -122.494916305221)
52950 185897 2 98 2000 Sunset Blvd 40 9 1 1     2 Width 0ft   5985016.2502 2101239.5934 37.7487372369942 -122.494628152274 (37.7487372369942, -122.494628152274)
55306 187251 2 98 2401 Sunset Blvd 34 9 1 1     3 Width 0ft   5984973.9834 2098481.6163 37.7411621065182 -122.494571017919 (37.7411621065182, -122.494571017919)
57230 181567 2 98 1300 Sunset Blvd 62 9 1 1     3 Width 0ft   5984855.7554 2106265.0899 37.7625264639896 -122.49555374589599 (37.7625264639896, -122.495553745896)
59344 185312 2 98 2601 Sunset Blvd 37 9 1 1     3 Width 0ft   5984965.1696 2097238.5346 37.737748422490604 -122.494509877006 (37.7377484224906, -122.494509877006)
64376 187053 2 98 2501 Sunset Blvd 72 9 1 1     2 Width 0ft   5984954.1557 2097623.876 37.7388058219757 -122.494576356208 (37.7388058219757, -122.494576356208)
70454 186363 2 98 1801 Sunset Blvd 30 9 1 1     9 Width 0ft   5984829.0026 2102575.9576 37.752395564949104 -122.49537418673401 (37.7523955649491, -122.495374186734)
71197 186427 2 98 1601 Sunset Blvd 15 9 1 1     3 Width 0ft   5984725.0315 2104075.456 37.7565066846119 -122.495844334494 (37.7565066846119, -122.495844334494)
73198 187253 2 98 2401 Sunset Blvd 36 9 1 1     3 Width 0ft   5984962.1374 2098459.5582 37.741100847588896 -122.494610350765 (37.7411008475889, -122.494610350765)
77017 184752 2 98 1301 Sunset Blvd 20 9 1 1     1 Width 0ft   5984700.7025 2106093.8553 37.7620472211463 -122.496077375707 (37.7620472211463, -122.496077375707)
84132 112917 3 98 480X BEACON ST 1 9 1 2           6002571.0 2098077.0 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676)
129188 105003 2 98 607 CONGO ST   9 2 1           6000094.1 2095817.0 37.73471905904071 -122.44210000591002 (37.7347190590407, -122.44210000591)
131967 181355 2 98 2300 Sunset Blvd 53 9 1 1     3 Width 0ft   5985079.1419 2099429.3232 37.7437704079628 -122.49427726096201 (37.7437704079628, -122.494277260962)
148012 185313 2 98 2601 Sunset Blvd 38 9 1 1     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.49444731702299 (37.7377379790483, -122.494447317023)
150729 186250 2 98 1701 Sunset Blvd 61 9 1 1     3 Width 0ft   5984767.3503 2103112.4152 37.753864919503 -122.495626952484 (37.753864919503, -122.495626952484)
164218 185692 2 98 2101 Sunset Blvd 24 9 1 1     3 Width 0ft   5984851.9348 2100530.8696 37.746781656202295 -122.495144090409 (37.7467816562023, -122.495144090409)
167803 187122 2 98 2600 Sunset Blvd 58 9 1 1     2 Width 0ft   5985165.8082 2097341.5801 37.7380430985113 -122.49382377418101 (37.7380430985113, -122.493823774181)
172267 186364 2 98 1801 Sunset Blvd 31 9 1 1     4 Width 0ft   5984815.8043 2102571.1093 37.7523814800587 -122.495419470402 (37.7523814800587, -122.495419470402)
176597 186340 2 98 1801 Sunset Blvd 7 9 1 1     2 Width 0ft   5984827.0787 2102831.0491 37.7530958632805 -122.495399651332 (37.7530958632805, -122.495399651332)
177379 181571 2 98 1200 Sunset Blvd 30 9 1 1     3 Width 0ft   5984860.385 2106736.0056 37.7638197374851 -122.49557246911101 (37.7638197374851, -122.495572469111)
179154 184750 2 98 1301 Sunset Blvd 17 9 1 1     2 Width 0ft   5984665.0089 2106100.6902 37.7620638971415 -122.496201328503 (37.7620638971415, -122.496201328503)
179730 184869 2 98 1201 Sunset Blvd 58 9 1 1     3 Width 0ft   5984640.7069 2106821.7773 37.764042376179205 -122.496338586447 (37.7640423761792, -122.496338586447)
181183 184754 2 98 1301 Sunset Blvd 23 9 1 1     2 Width 0ft   5984657.4145 2106082.8434 37.762014449980704 -122.496226277389 (37.7620144499807, -122.496226277389)
182690 181343 2 98 2500 Sunset Blvd 20 9 1 1     3 Width 0ft   5985164.5677 2097705.9234 37.739043415002705 -122.493854905389 (37.7390434150027, -122.493854905389)
183333 187234 2 98 2401 Sunset Blvd 17 9 1 1     3 Width 0ft   5984956.0101 2098625.8109 37.7415569740276 -122.494643790117 (37.7415569740276, -122.494643790117)
184478 187025 2 98 2501 Sunset Blvd 44 9 1 1     2 Width 0ft   5984975.6777 2097882.1396 37.7395162040617 -122.494520977899 (37.7395162040617, -122.494520977899)
185026 187377 2 98 2200 Sunset Blvd 63 9 1 1     3 Width 0ft   5985052.2703 2100029.8298 37.7454176637381 -122.49441443213001 (37.7454176637381, -122.49441443213)
88899 119673 2 98 1207 De Haro St 1 7 1 1           6012287.0 2102743.0 37.7544236952833 -122.40043105492799 (37.7544236952833, -122.400431054928)
119638 109607 5 98 775 Congo St 1 7 2 1           6000381.8 2095947.7 37.7350943222142 -122.44111470541901 (37.7350943222142, -122.441114705419)
139298 92611 1 98 3856 23rd St   6 2 1   08/31/2009 12:00:00 AM     Permit Number 52924 6004067.0 2102488.0 37.753261698893496 -122.428839761175 (37.7532616988935, -122.428839761175)
1718 251667 2 98 1090x Eucalyptus Dr 1 5 1 1       3x3   5988120.0 2094796.0 37.731225993649296 -122.483423232518 (37.7312259936493, -122.483423232518)
1720 251666 2 98 76 Denslowe Dr 1 5 1 1       3x3   5990680.0 2091936.0 37.723521814492294 -122.474364317808 (37.7235218144923, -122.474364317808)
28447 116579 6 98 3000x 19TH AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
79808 37377 1 98 755 Morse St 11 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
84241 37371 1 98 755 Morse St 5 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
119565 99732 2 98 4150 Ocean Ave 1 5 2 1           5986619.2 2095203.6 37.7322576937009 -122.48864164528798 (37.7322576937009, -122.488641645288)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
128554 93164 1 98 201 Upper Ter 2 5 2 1   12/22/2009 12:00:00 AM   1x2   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
139023 37379 1 98 755 Morse St 13 5 1 1 1 06/15/1998 12:00:00 AM 2 3x3 Permit Number 39872 5998400.39464019 2087052.25152553 37.7105564274343 -122.447325069993 (37.7105564274343, -122.447325069993)
144925 93163 1 98 201 Upper Ter 1 5 2 1   12/22/2009 12:00:00 AM   1x15   5999670.5 2106448.3 37.763885884820205 -122.444328283325 (37.7638858848202, -122.444328283325)
586 237035 3 98 150 Octavia St 2 4 1 2   04/12/2017 02:27:00 PM 3 Width 4ft   6005709.86547 2109855.10938 37.7735828886787 -122.423682154918 (37.7735828886787, -122.423682154918)
622 237036 3 98 150 Octavia St 4 4 1 2   04/13/2017 02:42:00 PM 3 Width 4ft   6005705.053180001 2109878.39065 37.7736465417793 -122.423700457022 (37.7736465417793, -122.423700457022)
643 239154 3 98 150 Octavia St 6 4 1 2   04/13/2017 02:47:00 PM 3 Width 4ft   6005701.84613 2109911.12293 37.773736235682 -122.42371387848999 (37.773736235682, -122.42371387849)
92261 117511 3 98 2634 37TH AVE 1 3 2 2     20 3x3   5984921.0 2097163.0 37.737538439530795 -122.49465702329901 (37.7375384395308, -122.494657023299)
2066 252868 2 98 15 Foerster St 2 2 1 1       Width 3ft   5998080.65269 2093664.7185 37.7286944544712 -122.44890616611099 (37.7286944544712, -122.448906166111)
79695 114527 2 98 1 TIOGA AVE 3 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
94733 114528 2 98 1 TIOGA AVE 4 2 1 1           6011351.0 2088602.0 37.715543251319204 -122.402673611341 (37.7155432513192, -122.402673611341)
150740 184164 2 98 1595 44th Ave 1 2 1 1     1 Width 0ft   5982483.9557 2104274.5677 37.7569218843537 -122.503609385397 (37.7569218843537, -122.503609385397)
659 244390 2 98 250 Octavia St 2 1 1 1   04/15/2017 01:00:00 PM 3 Width 0ft   6005651.6782 2110185.3753 37.774486434317105 -122.423906923072 (37.7744864343171, -122.423906923072)
660 244391 2 98 250 Octavia St 3 1 1 1   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.42391334778499 (37.774530388668, -122.423913347785)
664 244393 2 98 250 Octavia St 5 1 1 1   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501)
668 244392 2 98 250 Octavia St 4 1 1 1   04/15/2017 01:27:00 PM 3 Width 0ft   6005647.8593 2110218.2181 37.774576397101995 -122.42392246931401 (37.774576397102, -122.423922469314)
825 244349 2 98 300 Octavia St 4 1 1 2   04/19/2017 02:48:00 PM 3 Width 0ft   6005619.6911 2110403.6421 37.77508393621179 -122.424033097665 (37.7750839362118, -122.424033097665)
831 244348 3 98 300 Octavia St 3 1 1 2   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681)
852 244300 3 98 350 Octavia St 3 1 1 2   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.775453085580295 -122.424102299872 (37.7754530855803, -122.424102299872)
856 244351 3 98 300 Octavia St 6 1 1 2   04/20/2017 07:17:00 AM 3 Width 0ft   6005616.3861 2110436.6924 37.7751744977295 -122.42404688124701 (37.7751744977295, -122.424046881247)
863 244299 3 98 350 Octavia St 2 1 1 2   04/20/2017 11:32:00 AM 3 Width 0ft   6005603.4021 2110525.6921 37.7754181362545 -122.424098126533 (37.7754181362545, -122.424098126533)
866 244301 3 98 350 Octavia St 4 1 1 2   04/20/2017 11:53:00 AM 3 Width 0ft   6005600.097 2110553.5487 37.775494437113295 -122.42411154116199 (37.7754944371133, -122.424111541162)
1090 184622 2 98 1778 40th Ave 1 1 1 1     7 Width 0ft   5983811.7777 2103069.4322 37.7536908962098 -122.498928317229 (37.7536908962098, -122.498928317229)
1092 139390 2 98 432 OCTAVIA ST 5 1 1 1   05/02/2017 03:33:00 PM 3 Width 0ft   6005538.2982 2110931.9956 37.776530070945796 -122.424352241322 (37.7765300709458, -122.424352241322)
1585 23896 3 98 1581 Webster St 3 1 1 2   05/24/2017 12:00:00 AM 3 3x3   6003535.353102201 2114132.0136397 37.7852032161945 -122.43150950273301 (37.7852032161945, -122.431509502733)
1666 251642 2 98 2253 Broderick St 4 1 2 1       3x3   6000298.51737 2116393.24113 37.7912279703404 -122.442870356286 (37.7912279703404, -122.442870356286)
9895 24292 3 98 403 Winfield St 1 1 1 2   10/28/1992 12:00:00 AM 3 3X3            
18786 97930 2 98 1615 Grant Ave 2 1 1 1       3x3   6010461.1 2120070.1 37.801897866839 -122.40796734514 (37.801897866839, -122.40796734514)
19473 61098 1 98 806 Shotwell St 1 1 1 1 1 09/24/1988 12:00:00 AM   3x3 Permit Number 25594 6007925.06671696 2103219.75918175 37.7554885536992 -122.41554954379299 (37.7554885536992, -122.415549543793)
32955 184206 2 98 1484 41st Ave 1 1 1 1     6 Width 0ft   5983432.9268 2105012.9881 37.759005126774895 -122.500382134012 (37.7590051267749, -122.500382134012)
44081 56991 1 98 4160 26th St 1 1 1 1   08/27/1974 12:00:00 AM     Permit Number 767882 6002854.60493399 2100676.90172362 37.74822015482471 -122.432903090117 (37.7482201548247, -122.432903090117)
57510 182676 2 98 1715 24th Ave 1 1 1 1     2 Width 0ft   5988712.3482 2103638.8826 37.7555406843938 -122.482022959471 (37.7555406843938, -122.482022959471)
59434 182677 2 98 1715 24th Ave 2 1 1 1     1 Width 0ft   5988712.8958 2103624.6472 37.755501629655704 -122.482020022938 (37.7555016296557, -122.482020022938)
78136 21133 3 98 2292X Sunset Blvd 2 1 1 2     12     5984947.8628076 2099601.6268993 37.7442358239277 -122.49474388696001 (37.7442358239277, -122.49474388696)
79258 114185 2 98 2200 HAYES ST 1 1 1 1       3x3   5997096.0 2109871.0 37.7731365175856 -122.45347979574801 (37.7731365175856, -122.453479795748)
79753 107409 2 98 125 VILLA TER 1 1 2 1           5999028.2 2104385.8 37.758186107000796 -122.44640141076401 (37.7581861070008, -122.446401410764)
80823 98972 3 98 825 Shotwell St 6 1 1 4 2   0 5x5   6008234.2 2102998.9 37.754899496003105 -122.414464835105 (37.7548994960031, -122.414464835105)
82634 26499 3 98 2710 Harrison St 3 1 1 2     3 4x3   6008889.7812 2102567.01926 37.7537504562032 -122.41216712165199 (37.7537504562032, -122.412167121652)
82971 102755 2 98 61 Jordan Ave 2 1 1 1     0 3x3   5996159.1 2114114.4 37.7847340229516 -122.457027629275 (37.7847340229516, -122.457027629275)
Powered by Datasette · Query took 2.516ms · Data source: data.sfgov.org