sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3087 19650 3 36 100 STAIRWAY5 49 1 1 2     12 60ST            
4862 19656 3 36 100 STAIRWAY5 55 1 1 2     18 60ST            
5896 19680 3 36 100 STAIRWAY5 79 1 1 2     12 60ST            
5976 19649 3 36 100 STAIRWAY5 48 1 1 2     12 60ST            
6914 19672 3 36 100 STAIRWAY5 71 1 1 2     12 60ST            
7103 19675 3 36 100 STAIRWAY5 74 1 1 2     12 60ST            
7153 19677 3 36 100 STAIRWAY5 76 1 1 2     12 60ST            
7446 19683 3 36 100 STAIRWAY5 82 1 1 2     12 60ST            
9546 19678 3 36 100 STAIRWAY5 77 1 1 2     12 60ST            
9875 19651 3 36 100 STAIRWAY5 50 1 1 2     12 60ST            
10475 19661 3 36 100 STAIRWAY5 60 1 1 2     12 60ST            
12748 19671 3 36 100 STAIRWAY5 70 1 1 2     12 60ST            
14057 19674 3 36 100 STAIRWAY5 73 1 1 2     12 60ST            
14729 19657 3 36 100 STAIRWAY5 56 1 1 2     18 60ST            
15686 19660 3 36 100 STAIRWAY5 59 1 1 2     18 60ST            
16120 19653 3 36 100 STAIRWAY5 52 1 1 2     12 60ST            
12006 1294 3 36 4000X Alemany Blvd 2 11 1 2     25 10   5991953.08243 2087152.92109 37.7104623187479 -122.469615507754 (37.7104623187479, -122.469615507754)
10605 1293 3 36 4000X Alemany Blvd 1 11 1 2     50 10   5991961.87152 2087160.6390900002 37.7104840184951 -122.46958569253701 (37.7104840184951, -122.469585692537)
169310 176391 2 36 1669 Geneva Ave 1 2 1 1     17 Width 8ft   6003898.25323 2087460.6657900002 37.711990473755606 -122.42835236038401 (37.7119904737556, -122.428352360384)
11298 25444 1 36 2155 Bay Shore Blvd 2 1 1 1     5 3x3   6011824.01572 2087503.73336 37.7125540294141 -122.40096152627399 (37.7125540294141, -122.400961526274)
133709 176392 2 36 1669 Geneva Ave 2 2 1 1     20 Width 8ft   6003793.19406 2087522.42519 37.712154106300396 -122.428719874622 (37.7121541063004, -122.428719874622)
75412 176393 2 36 1669 Geneva Ave 3 2 1 1     13 Width 8ft   6003772.59409 2087534.0234400001 37.712184786677206 -122.42879190044901 (37.7121847866772, -122.428791900449)
178569 176383 2 36 199 Peninsula Ave 1 7 1 1     17     6012515.53938 2087594.1826400002 37.7128409356448 -122.39857773288799 (37.7128409356448, -122.398577732888)
100565 176384 2 36 199 Peninsula Ave 2 7 1 1     10     6012519.05604 2087598.31836 37.712852487431796 -122.398565868123 (37.7128524874318, -122.398565868123)
158262 176380 2 36 229 Hester Ave 1 7 1 1     38     6012521.81555 2087619.26728 37.7129101627473 -122.398557799413 (37.7129101627473, -122.398557799413)
82185 111319 2 36 200x PENINSULA AVE 2 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
87976 111318 2 36 200x PENINSULA AVE 1 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
122748 111320 2 36 200x PENINSULA AVE 3 14 1 1           6012569.0 2087626.0 37.71293127807179 -122.398395185538 (37.7129312780718, -122.398395185538)
4566 176382 2 36 2112 Bay Shore Blvd 1 1 1 1     31 Width 3ft   6011978.0 2087840.0 37.7134859388755 -122.40045291074101 (37.7134859388755, -122.400452910741)
38240 176381 2 36 2020 Bay Shore Blvd 1 1 1 1     29 Width 4ft   6012133.88275 2088039.9913700002 37.714043767182105 -122.39992815667699 (37.7140437671821, -122.399928156677)
109964 1773 3 36 2000X Bay Shore Blvd 14 1 1 2     36 4X4   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
83866 11477 3 36 10X Jennings St 3 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
112318 11486 3 36 10X Jennings St 12 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
118292 11478 3 36 10X Jennings St 4 1 1 2     12 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
124892 11481 3 36 10X Jennings St 7 1 1 2     18 3X3   6012892.419875 2089345.335603 37.7176702433836 -122.397397833393 (37.7176702433836, -122.397397833393)
78413 51528 1 36 2900 Hawes St 2 1 1 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
81696 51527 1 36 2900 Hawes St 1 1 1 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
137668 200250 2 36 917 Ingerson Ave 1 19 1 1     5 Width 0ft   6014641.601 2089467.7692 37.7181036570096 -122.391360208379 (37.7181036570096, -122.391360208379)
42536 176390 3 36 700x Mansell St 37 11 1 2     21 Width 0ft   6009150.9462 2089957.5754799999 37.7191423008581 -122.410373676998 (37.7191423008581, -122.410373676998)
33628 176389 3 36 700x Mansell St 16 11 1 2     38 Width 0ft   6009439.980830001 2090047.93275 37.719406601704 -122.40938096396499 (37.719406601704, -122.409380963965)
10973 55642 1 36 422 Russia Ave 1 1 1 1   04/01/2015 12:00:00 AM 3 4x4 Permit Number 775006 6002423.93112 2090348.58782 37.719836534298 -122.433654298202 (37.719836534298, -122.433654298202)
67100 176388 3 36 100x Mansell St 8 11 1 2     32 Width 0ft   6011438.192840001 2090648.2271599998 37.7211666433202 -122.40251603501001 (37.7211666433202, -122.40251603501)
89868 36789 1 36 1314 Donner Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
117616 36790 1 36 1314 Donner Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
54771 176387 3 36 100x Mansell St 4 11 1 2     32 Width 0ft   6011480.82156 2090667.2216900003 37.7212211781905 -122.402370013862 (37.7212211781905, -122.402370013862)
78284 36808 1 36 1290 Egbert Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
95666 36809 1 36 1290 Egbert Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
70249 176386 3 36 10x Mansell St 10 11 1 2     8 Width 0ft   6011666.66331 2090722.9963200002 37.7213846965192 -122.40173152668501 (37.7213846965192, -122.401731526685)
162071 176385 3 36 10x Mansell St 9 11 1 2     15 Width 0ft   6011675.69162 2090725.79104 37.7213928740681 -122.401700514484 (37.7213928740681, -122.401700514484)
83231 36833 1 36 2715 Ingalls St 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
146328 36834 1 36 2715 Ingalls St 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
65172 200147 2 36 2911 Keith St 1 1 1 1     25 Width 0ft   6013569.8497 2091214.9407 37.7228415002198 -122.39518713528 (37.7228415002198, -122.39518713528)
62706 200148 2 36 2911 Keith St 2 1 1 1     23 Width 0ft   6013582.2773 2091230.6387 37.722885294900706 -122.395145274417 (37.7228852949007, -122.395145274417)
60842 200145 2 36 2905 Keith St 1 1 1 1     21 Width 0ft   6013593.3967 2091246.9908 37.7229308128444 -122.395107981509 (37.7229308128444, -122.395107981509)
15306 22434 3 36 6000 03rd St 3 1 1 2     18 3X3   6013550.0151 2091475.3264 37.7235553639507 -122.395273931127 (37.7235553639507, -122.395273931127)
13479 22442 1 36 6025 03rd St 6 1 1 1     24 3X3   6013654.8805 2091521.7057 37.7236885437418 -122.394914674123 (37.7236885437418, -122.394914674123)
96253 41569 1 36 63 Ruth St 1 1 1 1   05/05/2000 12:00:00 AM     Permit Number 42084 6001453.1346338 2091658.26221962 37.723377473003104 -122.437103713844 (37.7233774730031, -122.437103713844)
42622 200508 2 36 5999 03rd St 1 1 1 1     21 Width 0ft   6013714.4021 2091674.1069999998 37.7241103165863 -122.394719584244 (37.7241103165863, -122.394719584244)
16658 22427 3 36 5919 03rd St 2 1 1 2     18 3X3   6013743.1817 2091759.1378 37.724345394142 -122.39462604842699 (37.724345394142, -122.394626048427)
70753 206290 1 36 519 Faxon Ave 1 1 1 1   12/15/1989 12:00:00 AM 13 Width 3ft Permit Number 28366 5994747.213769999 2092021.25084 37.7239906908132 -122.460310960879 (37.7239906908132, -122.460310960879)
128360 106364 6 36 155 BORICA ST 1 7 1 1           5992696.0 2092292.5 37.724617268406604 -122.467421338179 (37.7246172684066, -122.467421338179)
78803 105667 2 36 301X DORADO TER 1 19 1 1           5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
85276 105668 2 36 301X DORADO TER 2 19 1 1     12     5994306.4 2092922.0 37.726438562961896 -122.461900058607 (37.7264385629619, -122.461900058607)
28308 67884 1 36 5X Lisbon St 1 1 1 1   03/03/1993 12:00:00 AM 15   Permit Number 31577 6003921.69231 2093425.09481 37.72836881267121 -122.428696258429 (37.7283688126712, -122.428696258429)
156597 176395 2 36 5 Lisbon St 2 1 1 1     17 Width 4ft   6003928.40899 2093435.3216799998 37.728397273506 -122.42867376727699 (37.728397273506, -122.428673767277)
20112 29963 3 36 500X Junipero Serra Blvd 6 11 1 2   03/09/2013 12:00:00 AM 3 3x3   5991394.8537099995 2093447.95886 37.7277146673841 -122.47200336878099 (37.7277146673841, -122.472003368781)
11921 61836 1 36 209 Theresa St 1 1 1 1   03/01/1985 12:00:00 AM 14 3x3 Permit Number 21875 6001956.61236 2093885.6272599997 37.7295219188836 -122.435522552544 (37.7295219188836, -122.435522552544)
111415 11292 3 36 1199X Ingalls St 4 1 1 2   04/13/1990 12:00:00 AM 30 3X3   6017612.0195749 2093925.7037957 37.730508696225705 -122.38140247160801 (37.7305086962257, -122.381402471608)
85513 11303 3 36 1201X Ingalls St 2 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017591.0151778 2093928.8426978001 37.7305161553992 -122.38147530581499 (37.7305161553992, -122.381475305815)
96922 11305 3 36 1201X Ingalls St 4 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017591.0151778 2093928.8426978001 37.7305161553992 -122.38147530581499 (37.7305161553992, -122.381475305815)
101060 11326 3 36 1223 Ingalls St 4 1 1 2   05/03/1993 12:00:00 AM 50 3X3   6017540.6929483 2093936.3628531997 37.730534025837706 -122.38164980170299 (37.7305340258377, -122.381649801703)
124644 11327 3 36 1223 Ingalls St 5 1 1 2   05/03/1993 12:00:00 AM 40 3X3   6017540.6929483 2093936.3628531997 37.730534025837706 -122.38164980170299 (37.7305340258377, -122.381649801703)
24830 199390 2 36 1201 Ingalls St 6 1 1 1     18 Width 3ft   6018025.5889 2093953.39853 37.730607564281605 -122.379974610641 (37.7306075642816, -122.379974610641)
37403 11269 3 36 1176X Ingalls St 8 1 1 2   04/03/1990 12:00:00 AM 3 3x3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
85383 11265 3 36 1176X Ingalls St 4 1 1 2   11/02/1992 12:00:00 AM 20 3X3   6017716.362196 2093961.1645628002 37.7306118245585 -122.381044204671 (37.7306118245585, -122.381044204671)
131752 199391 2 36 1201 Ingalls St 7 1 1 1     20 Width 3ft   6018044.87708 2093963.65233 37.7306367832528 -122.379908639985 (37.7306367832528, -122.379908639985)
95268 11318 3 36 1216X Ingalls St 9 1 1 2   05/10/1990 12:00:00 AM 60 3X3   6017561.7867095005 2093983.7658262001 37.7306653497809 -122.38158017208 (37.7306653497809, -122.38158017208)
186929 199392 2 36 1199 Ingalls St 1 1 1 1     22 Width 3ft   6018085.49835 2093997.2932900002 37.730731395525396 -122.379770541 (37.7307313955254, -122.379770541)
4693 253655 2 36 1048 Ingalls St 1 7 1 1       3x3   6018024.0 2094000.0 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658)
135013 199393 2 36 1199 Ingalls St 2 1 1 1     12 Width 3ft   6018101.32261 2094012.4303700002 37.730773831851 -122.37971688473999 (37.730773831851, -122.37971688474)
103086 11230 3 36 1050X Ingalls St 16 1 1 2   04/13/1990 12:00:00 AM 45 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
128599 11231 3 36 1050X Ingalls St 17 1 1 2   04/02/1990 12:00:00 AM 50 3X4   6018085.661882901 2094069.8743192002 37.7309306978843 -122.379775016493 (37.7309306978843, -122.379775016493)
181793 206291 3 36 500x Junipero Serra Blvd 38 11 1 2     7 Width 0ft   5991445.95006 2094262.4550299998 37.7299540269465 -122.471886066612 (37.7299540269465, -122.471886066612)
18780 16006 1 36 95 Monterey Blvd 1 1 1 1     18 3x3   6001386.18936 2094608.8979 37.7314754397255 -122.43754633291799 (37.7314754397255, -122.437546332918)
18348 16020 3 36 107 Monterey Blvd 1 1 1 2     18 3x3   6001336.16248 2094611.17288 37.731478841871706 -122.437719447913 (37.7314788418717, -122.437719447913)
22088 16025 3 36 131 Monterey Blvd 1 1 1 2     18 4X4   6001203.7257900005 2094613.91575 37.7314788418574 -122.438177502293 (37.7314788418574, -122.438177502293)
20184 16030 3 36 147 Monterey Blvd 1 1 1 2     24 3X3   6001102.99289 2094615.6926099998 37.731477991115796 -122.438525881668 (37.7314779911158, -122.438525881668)
20016 16033 1 36 159 Monterey Blvd 1 1 1 1     18 3X4   6001012.52549 2094617.56697 37.7314779911003 -122.438838778307 (37.7314779911003, -122.438838778307)
161708 206289 2 36 155 Monterey Blvd 1 1 1 1     23 Width 3ft   6001037.098230001 2094617.6771900002 37.7314796917331 -122.438753833738 (37.7314796917331, -122.438753833738)
19938 16038 3 36 163 Monterey Blvd 1 1 1 2     12 3X3   6000989.84379 2094618.6563099998 37.7314796917131 -122.43891727113301 (37.7314796917131, -122.438917271133)
124037 10826 3 36 1139X Hudson Ave 33 1 1 2   03/29/1990 12:00:00 AM 12 3X4   6017834.53501 2094620.0550099998 37.732427530713004 -122.380681442077 (37.732427530713, -122.380681442077)
21993 16119 3 36 301 Monterey Blvd 1 1 1 2     18 3x3   6000050.07874 2094632.71852 37.7314647899581 -122.442167217764 (37.7314647899581, -122.442167217764)
182167 199388 2 36 1333 Hudson Ave 7 1 1 1     22 Width 3ft   6017834.132540001 2094632.9776599999 37.73246299156 -122.380683731476 (37.73246299156, -122.380683731476)
17352 16120 3 36 303 Monterey Blvd 1 1 1 2     18 3x3   6000032.3049 2094633.40383 37.7314656586952 -122.44222871430401 (37.7314656586952, -122.442228714304)
143617 16166 3 36 405 Monterey Blvd 1 1 1 2     18 3X3   5999388.049433099 2094640.7964516003 37.7314492181413 -122.44445655139799 (37.7314492181413, -122.444456551398)
34483 201405 2 36 1051 Ingalls St 17 1 1 1     16 Width 3ft   6018105.253280001 2094684.7781099998 37.732620184068296 -122.379749990578 (37.7326201840683, -122.379749990578)
94 201404 2 36 1051 Ingalls St 16 1 1 1   04/02/1990 12:00:00 AM 14 Width 3ft   6018112.6185 2094686.77545 37.732626074632705 -122.379724665662 (37.7326260746327, -122.379724665662)
70451 176394 2 36 148 Milton St 1 17 1 1     21     6003833.54644 2094691.18415 37.731840220943205 -122.42909121820801 (37.7318402209432, -122.429091218208)
52077 218791 2 36 138 Monterey Blvd 1 1 1 1     23 Width 3ft   6001157.9301 2094692.71106 37.731692590921995 -122.438341469381 (37.731692590922, -122.438341469381)
17573 16029 3 36 146 Monterey Blvd 1 1 1 2     12 3X3   6001109.44487 2094693.26414 37.7316913516547 -122.43850913181002 (37.7316913516547, -122.43850913181)
98031 16026 3 36 134 Monterey Blvd 1 1 1 2     12 3X3   6001180.6151014995 2094696.8372785 37.7317052108344 -122.438263338431 (37.7317052108344, -122.438263338431)
Powered by Datasette · Query took 9.666ms · Data source: data.sfgov.org