sf-trees

Data source: data.sfgov.org

Custom SQL query returning 51 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3060 203634 1 42 432 Flood Ave 3 1 1 1   06/23/2000 12:00:00 AM 11 Width 2ft Permit Number 42544 5997859.0322900005 2094116.10367 37.7299211747225 -122.449704832412 (37.7299211747225, -122.449704832412)
6851 20056 3 42 100 STAIRWAY54 3 1 1 2     6 15ST            
8970 10634 3 42 830 Hayes St 3 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003840.507 2110782.2115 37.7760227838468 -122.43021469913201 (37.7760227838468, -122.430214699132)
19697 85509 1 42 1 Nebraska St 3 9 1 1         Permit Number 49678 6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
31523 188515 2 42 1401 25th St 3 9 1 1     1     6014455.23285 2101981.54762 37.752453585184604 -122.39287941707799 (37.7524535851846, -122.392879417078)
33547 137666 2 42 1901 GOLDEN GATE AVE 3 1 1 1     5 Width 0ft   6000398.0082 2111639.7629 37.7781818179135 -122.442184748811 (37.7781818179135, -122.442184748811)
42347 203665 2 42 123 Detroit St 3 1 1 1     8 Width 2ft   5999403.44951 2093584.38933 37.728549449599704 -122.444327421686 (37.7285494495997, -122.444327421686)
42359 138339 2 42 2250 Sutter St 3 1 1 1     7 Width 0ft   6001909.1348 2114331.7204 37.7856592553419 -122.437150009777 (37.7856592553419, -122.437150009777)
43667 203624 2 42 15 Teresita Blvd 3 1 1 1     1 Width 3ft   5997319.6106 2099609.0427 37.7449725828299 -122.45196580449199 (37.7449725828299, -122.451965804492)
45531 220666 2 42 1 Dorland St 3 1 1 1     8 Width 3ft   6005487.19676 2105743.72088 37.7622814268651 -122.42415994852199 (37.7622814268651, -122.424159948522)
48501 188519 2 42 1451 Rhode Island St 3 2 1 1     13     6012046.50101 2101636.39558 37.7513717861857 -122.401185012303 (37.7513717861857, -122.401185012303)
54358 219993 2 42 101 Prospect Ave 3 10 1 1     13     6006993.27252 2098944.7494 37.7436979269164 -122.418468865069 (37.7436979269164, -122.418468865069)
61990 140718 2 42 556 SCOTT ST 3 1 1 1     12 Width 0ft   6002160.0013 2110449.3533 37.7750135114472 -122.436004179308 (37.7750135114472, -122.436004179308)
64061 32346 1 42 1201 35th Ave 3 1 1 1 1 10/23/1996 12:00:00 AM     Permit Number 37068 5985179.95256355 2107022.76154853 37.7646257968319 -122.494488338591 (37.7646257968319, -122.494488338591)
66468 203632 2 42 1400 Monterey Blvd 3 9 1 1     9 Width 10ft   5993831.29855 2094857.6984 37.7317261536347 -122.463682879865 (37.7317261536347, -122.463682879865)
69010 188521 2 42 495 Connecticut St 3 4 1 1     7 Width 3ft   6013271.447919999 2104826.1277799997 37.7601983604744 -122.397172617724 (37.7601983604744, -122.397172617724)
69034 220048 2 42 1401 Rivoli St 3 1 1 1     3 Width 5ft   5997746.6978 2105897.5577 37.7622637372081 -122.450942387687 (37.7622637372081, -122.450942387687)
70350 35250 1 42 1385 Greenwich St 3 1 1 1 1 02/17/1998 12:00:00 AM 8   Permit Number 38738 6006287.30636 2119683.41372 37.800601562682296 -122.42238315976999 (37.8006015626823, -122.42238315977)
70549 40816 1 42 1770 Scott St 3 1 1 1   08/26/1999 12:00:00 AM 8   Permit Number 41760 6001593.7276 2114497.5525 37.7860966539785 -122.438253110129 (37.7860966539785, -122.438253110129)
82962 29220 3 42 1902X 41st Ave 3 1 1 2     6 3X3   5983534.517682901 2102185.1808128003 37.7512467209802 -122.499821775189 (37.7512467209802, -122.499821775189)
84795 49477 1 42 560@ Pacific Davis St 3 1 1 1   04/14/2003 12:00:00 AM     Permit Number 46402 6013205.44581331 2118473.26826983 37.7976666140298 -122.39835845145001 (37.7976666140298, -122.39835845145)
92174 50672 1 42 3305 Washington St 3 1 1 1         Permit Number 47252 5998970.56266258 2115921.05690667 37.789855679639295 -122.447431022041 (37.7898556796393, -122.447431022041)
94988 117034 2 42 2220x SUTTER ST 3 1 1 1       3x3   6001781.0 2114465.0 37.786017922595605 -122.437602866759 (37.7860179225956, -122.437602866759)
95511 49584 1 42 400REVISED Alemany Blvd 3 1 1 1   05/29/2003 12:00:00 AM 8   Permit Number 46462 6008204.64175087 2095122.01632245 37.7332696598424 -122.414009852171 (37.7332696598424, -122.414009852171)
99251 19283 3 42 1770 Scott St 3 1 1 2     8 3X3   6001619.01622 2114490.46983 37.786078645055 -122.43816511087601 (37.786078645055, -122.438165110876)
101744 39506 1 42 216 Jersey St 3 1 1 1 1 12/28/1998 12:00:00 AM     Permit Number 40959 6003716.05884842 2101601.85489178 37.7508086831914 -122.42999018002399 (37.7508086831914, -122.429990180024)
102717 42112 1 42 100@ Detroit Judson Ave 3 1 1 1 1 06/21/2000 12:00:00 AM     Permit Number 42411 5999403.96940848 2093509.81726433 37.7283447217324 -122.444320267584 (37.7283447217324, -122.444320267584)
103294 43707 1 42 503 Capitol Ave 3 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43349 5995017.92037976 2088722.8136211003 37.7149495354327 -122.459136447344 (37.7149495354327, -122.459136447344)
108504 85500 1 42 1 Nebraska St 3 1 1 1           6009335.0 2098038.0 37.7413397420659 -122.410307693317 (37.7413397420659, -122.410307693317)
113556 45337 1 42 1239 17th St 3 1 1 1 1 07/08/1998 12:00:00 AM     Permit Number 44167 6013665.22038022 2106606.66789645 37.7651092465016 -122.39593550872 (37.7651092465016, -122.39593550872)
121928 43149 1 42 301 Gambier St 3 1 1 1   07/11/2000 12:00:00 AM     Permit Number 42961 6006052.5972483 2092387.2151737 37.7256393916299 -122.421255939073 (37.7256393916299, -122.421255939073)
127101 36920 1 42 699 Alvarado St 3 1 1 1 1 05/27/1998 12:00:00 AM     Permit Number 39565 6001900.0 2102596.0 37.7534353511669 -122.43634140628299 (37.7534353511669, -122.436341406283)
129705 220028 2 42 685 Alvarado St 3 1 1 1     8 Width 3ft   6001938.58535 2102624.90259 37.7535169030985 -122.436210038379 (37.7535169030985, -122.436210038379)
130794 188513 2 42 55 Mississippi St 3 1 1 1     8 Width 3ft   6013999.87449 2106891.97216 37.7659112417232 -122.39479799565399 (37.7659112417232, -122.394797995654)
135843 250193 2 42 11 Alta St 3 13 1 1     35 Width 0ft   6011782.399230001 2119949.71509 37.8016412059365 -122.403386530161 (37.8016412059365, -122.403386530161)
142538 23664 3 42 311 Virginia Ave 3 11 1 2     12 12   6006938.1768512 2098312.3803834 37.7419584813283 -122.41861453896999 (37.7419584813283, -122.41861453897)
145318 50662 1 42 1 Santa Ynez Ave 3 1 1 1         Permit Number 47244 6000978.87890111 2091807.60057831 37.723760552916296 -122.43875382021002 (37.7237605529163, -122.43875382021)
148974 174958 2 42 60 Onondaga Ave 3 1 1 1     8 Width 3ft   6000890.31977 2091107.65045 37.7218336102096 -122.439009814053 (37.7218336102096, -122.439009814053)
149098 75250 2 42 101 De Long St 3 1 1 1 1 09/30/1995 12:00:00 AM 6     5994476.95751 2086787.3271700002 37.7096040318843 -122.460866039547 (37.7096040318843, -122.460866039547)
151048 220044 2 42 10 Arbor St 3 1 1 1     6 Width 2ft   6002160.56118 2096968.3315700002 37.7379978987733 -122.43503787010201 (37.7379978987733, -122.435037870102)
151268 203651 2 42 1390 Monterey Blvd 3 9 1 1     10 Width 3ft   5993846.97887 2094818.6059299998 37.731619718855704 -122.46362583408701 (37.7316197188557, -122.463625834087)
152716 40191 1 42 600 Silliman St 3 1 1 1   04/30/1999 12:00:00 AM 8   Permit Number 41375 6008969.320719999 2093798.8519 37.7296794522306 -122.411272698701 (37.7296794522306, -122.411272698701)
154629 113718 1 42 1342 Cabrillo St 3 1 1 1 1   14     5991385.6612 2110673.31757 37.7750104780928 -122.473290929077 (37.7750104780928, -122.473290929077)
166210 203659 2 42 628 Edna St 3 1 1 1     12 Width 3ft   5998583.28764 2094893.18321 37.7320962615306 -122.44725691200199 (37.7320962615306, -122.447256912002)
169866 188508 2 42 101 Pennsylvania Ave 3 7 1 1     3     6014332.46782 2106283.64375 37.764259392178005 -122.393605035044 (37.764259392178, -122.393605035044)
172105 182147 2 42 1690 21st Ave 3 1 1 1     8 Width 0ft   5989680.1915 2103890.3009 37.756287254354 -122.478694280415 (37.756287254354, -122.478694280415)
174353 138350 2 42 2499 Bush St 3 1 1 1     10 Width 0ft   6001659.5245 2114595.4043 37.786369071961104 -122.438032482637 (37.7863690719611, -122.438032482637)
174458 203224 2 42 30 Northgate Dr 3 1 1 1     7 Width 2ft   5994449.32754 2093942.03458 37.7292475573046 -122.461479885289 (37.7292475573046, -122.461479885289)
176295 249709 2 42 2901 Broadway 3 7 1 1     8     5999701.30683 2117014.48804 37.7928996850292 -122.44498136009899 (37.7928996850292, -122.444981360099)
186513 103886 1 42 1750 Fulton St 3 1 1 1   06/18/2013 12:00:00 AM 11 3x3 Permit Number 770207 5999354.6 2110868.3 37.7760040584969 -122.44573877005101 (37.7760040584969, -122.445738770051)
187109 142298 2 42 1501 GROVE ST 3 1 1 1     7 Width 0ft   6000546.8174 2110627.5355 37.775410978082 -122.44159730622299 (37.775410978082, -122.441597306223)
Powered by Datasette · Query took 10.694ms · Data source: data.sfgov.org