sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
29562 193317 2 88 136 Hawthorne St 3 4 1 1     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699)
160737 193316 2 88 136 Hawthorne St 2 4 1 1     9 Width 2ft   6013300.831040001 2113672.81478 37.784491007704396 -122.39769151127301 (37.7844910077044, -122.397691511273)
72263 193315 2 88 136 Hawthorne St 1 4 1 1     9 Width 2ft   6013291.138730001 2113684.88595 37.7845236126199 -122.39772589056001 (37.7845236126199, -122.39772589056)
77905 89162 1 88 370 03rd St 1 1 1 1   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
94680 89190 1 88 370 03rd St 7 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
101412 89164 1 88 370 03rd St 3 1 1 1   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
102499 89170 1 88 370 03rd St 9 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
106643 89194 1 88 370 03rd St   1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
108377 89188 1 88 370 03rd St 5 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
110669 89185 1 88 370 03rd St 2 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
115103 89172 1 88 370 03rd St 11 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
116964 89192 1 88 370 03rd St 9 1 1 1   10/07/2008 12:00:00 AM   3x3 Permit Number 51807 6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
118087 89184 1 88 370 03rd St 1 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
121536 89171 1 88 370 03rd St 10 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
122431 89187 1 88 370 03rd St 4 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
123609 89169 1 88 370 03rd St 8 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
123890 89193 1 88 370 03rd St   1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
140338 89189 1 88 370 03rd St 6 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
143973 89191 1 88 370 03rd St 8 1 1 1       3x3   6013271.0 2113050.0 37.782779240858495 -122.39775101659401 (37.7827792408585, -122.397751016594)
138212 94884 1 88 2010 Quesada Ave 1 1 1 1 1 11/23/2010 12:00:00 AM 5 3x3 Permit Number 53951 6013072.55459 2096282.04692 37.736727066797 -122.397261344859 (37.736727066797, -122.397261344859)
188017 94885 1 88 2010 Quesada Ave 2 1 1 1 1 11/23/2010 12:00:00 AM 3 3x3 Permit Number 53951 6013050.0613 2096298.0841299999 37.736769849332 -122.39734023878599 (37.736769849332, -122.397340238786)
42297 80634 2 88 577 Arkansas St 1 1 1 1 1 10/05/2002 12:00:00 AM 1     6013018.0309 2104352.7115 37.758884352052604 -122.398015861652 (37.7588843520526, -122.398015861652)
75334 193343 2 88 698 Arkansas St 1 4 1 1     4 Width 3ft   6012989.114019999 2103849.31958 37.757500537346395 -122.39808055528299 (37.7575005373464, -122.398080555283)
179016 56947 1 88 690 Arkansas St 1 1 1 1   08/27/1974 12:00:00 AM 5   Permit Number 14199 6012986.78866 2103864.51855 37.7575421408828 -122.398089663624 (37.7575421408828, -122.398089663624)
169605 193341 2 88 1751 22nd St 6 17 1 1     2 Width 4ft   6012847.48484 2103764.38864 37.757259446178104 -122.398564409431 (37.7572594461781, -122.398564409431)
63323 96333 1 88 11 Robblee Ave 1 1 1 1   04/28/2011 12:00:00 AM 3 3x3 Permit Number 767342 6012676.77436 2095976.0416 37.7358647977189 -122.398608271155 (37.7358647977189, -122.398608271155)
25430 113267 1 88 83 Exeter St 1 1 1 1   09/16/2015 12:00:00 AM 2   Permit Number 774551 6012507.044369999 2090789.37208 37.7216138123142 -122.398831200496 (37.7216138123142, -122.398831200496)
94923 88503 1 88 7 Wheat St   1 1 1   07/18/2008 12:00:00 AM   3x3 Permit Number 51441 6012178.0 2091435.0 37.723368235520205 -122.400013942822 (37.7233682355202, -122.400013942822)
181062 31608 1 88 5 Lucerne St 5 1 1 1   06/06/1995 12:00:00 AM 4   Permit Number 35133 6012020.8525 2109827.45516 37.7738611793697 -122.401849428724 (37.7738611793697, -122.401849428724)
78394 95830 1 88 5 Lucerne St 1 1 1 1 1 08/29/2011 12:00:00 AM   3x3 Permit Number 767564 6011975.0 2109856.0 37.7739369979495 -122.402010048031 (37.7739369979495, -122.402010048031)
31120 131005 2 88 1109 Sansome St 3 1 1 1     6 Width 3ft   6011966.28047 2119507.31076 37.8004367394276 -122.40271908303001 (37.8004367394276, -122.40271908303)
74720 131004 2 88 1109 Sansome St 2 1 1 1     5 Width 3ft   6011962.5768099995 2119524.82057 37.8004846103385 -122.402733131341 (37.8004846103385, -122.402733131341)
53332 131003 2 88 1109 Sansome St 1 1 1 1     7 Width 3ft   6011959.67514 2119544.33527 37.8005380309676 -122.40274454551901 (37.8005380309676, -122.402744545519)
76734 88076 1 88 674 Thornton Ave 1 1 1 1   06/24/2008 12:00:00 AM 5 3x3 Permit Number 51071 6011923.037330001 2094336.6439200002 37.731321332804605 -122.40109909554701 (37.7313213328046, -122.401099095547)
123330 84225 1 88 1361 Brussels St 1 1 1 1   06/05/2008 12:00:00 AM   3x3 Permit Number 50686 6011917.47723073 2088615.29524593 37.7156113688947 -122.400716532679 (37.7156113688947, -122.400716532679)
136360 74692 2 88 200 Green St 3 1 1 1 1 10/21/1995 12:00:00 AM 6     6011876.44918 2119465.43765 37.8003167500634 -122.403026990216 (37.8003167500634, -122.403026990216)
16330 107963 1 88 33 03rd St 3 1 1 1   11/10/2014 12:00:00 AM 3 3x3 Permit Number 770900 6011844.7795 2114609.58385 37.786981966990105 -122.40279488510201 (37.7869819669901, -122.402794885102)
66302 61318 1 88 1419 Kansas St 1 1 1 1 1 06/02/2014 12:00:00 AM 1   Permit Number 772899 6011764.55732 2101642.9103 37.751373940974204 -122.402160470048 (37.7513739409742, -122.402160470048)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
182061 115977 4 88 2x Olmstead St 2 1 1 1     1 3x3   6011639.0005 2091249.90123 37.722829925953896 -122.40186416949 (37.7228299259539, -122.40186416949)
172623 115978 4 88 2x Olmstead St 3 1 1 1     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721001 (37.7228154963084, -122.40191601721)
171742 115979 4 88 2x Olmstead St 4 1 1 1     1 3x3   6011610.19593 2091240.25279 37.722801825729604 -122.401963063449 (37.7228018257296, -122.401963063449)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
2310 102805 1 88 600 Kansas St 3 1 1 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011492.26434 2105507.65774 37.7619704808857 -122.403373953167 (37.7619704808857, -122.403373953167)
2327 53079 1 88 600 Kansas St 2 1 1 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.70702 2105522.9440900004 37.7620123668039 -122.4033804148 (37.7620123668039, -122.4033804148)
2326 32310 1 88 600 Kansas St 1 1 1 1   07/11/2017 12:00:00 AM 3 3x3 Permit Number 780021 6011490.21346 2105535.41825 37.762046590490705 -122.40338299943899 (37.7620465904907, -122.403382999439)
73543 193322 2 88 2111 18th St 4 1 1 1     5 Width 4ft   6011436.66428 2105551.33646 37.762087307318104 -122.403569326371 (37.7620873073181, -122.403569326371)
72311 193321 2 88 2111 18th St 3 1 1 1     3 Width 4ft   6011418.14714 2105550.13938 37.7620829860523 -122.403633286154 (37.7620829860523, -122.403633286154)
155809 193320 2 88 2111 18th St 2 1 1 1     4 Width 4ft   6011400.26798 2105549.24377 37.762079528159795 -122.403695060604 (37.7620795281598, -122.403695060604)
136274 193319 2 88 2111 18th St 1 1 1 1     4 Width 4ft   6011383.02095 2105548.33564 37.762076071170895 -122.403754647862 (37.7620760711709, -122.403754647862)
165775 249954 2 88 303 Filbert St 1 17 1 1     3 Width 0ft   6011374.5207 2120037.6372700003 37.8018598293151 -122.404804177386 (37.8018598293151, -122.404804177386)
64441 249953 2 88 303 Filbert St 2 17 1 1     4 Width 0ft   6011372.652369999 2120041.55492 37.8018704817969 -122.40481091868901 (37.8018704817969, -122.404810918689)
71813 249952 2 88 303 Filbert St 3 17 1 1     2 Width 0ft   6011371.46837 2120040.8031 37.801868351303796 -122.40481496294399 (37.8018683513038, -122.404814962944)
28898 250221 2 88 312 Filbert St 2 17 1 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
10319 109211 1 88 819 Brussels St 1 1 1 1   02/04/2015 12:00:00 AM 3 3x3 Permit Number 773413 6011187.7232800005 2090968.5283099997 37.722032138266 -122.403404362845 (37.722032138266, -122.403404362845)
110088 114688 1 88 231 Dwight St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774702 6010865.8 2091429.3 37.723279336417704 -122.404549596707 (37.7232793364177, -122.404549596707)
75481 249813 2 88 260 Chestnut St 3 7 1 1     3 Width 0ft   6010621.11973 2121031.8935700003 37.8045476726861 -122.407481446514 (37.8045476726861, -122.407481446514)
10963 108843 1 88 420 Woolsey St 2 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010519.109209999 2091869.71455 37.7244692416558 -122.40577905416201 (37.7244692416558, -122.405779054162)
145458 108842 1 88 420 Woolsey St 1 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010509.54502 2091864.19266 37.7244535448266 -122.405811727659 (37.7244535448266, -122.405811727659)
154138 177445 2 88 15 Karen Ct 4 1 1 1     1 Width 5ft   6010506.33995 2091553.32971 37.723599800462296 -122.405800920297 (37.7235998004623, -122.405800920297)
40468 114753 1 88 10 Karen Ct 1 1 1 1   12/04/2015 12:00:00 AM 1   Permit Number 777133 6010495.976919999 2091580.43732 37.723673652787596 -122.40583865223101 (37.7236736527876, -122.405838652231)
161633 177444 2 88 15 Karen Ct 3 1 1 1     2 Width 4ft   6010486.61044 2091547.46792 37.7235826018289 -122.40586870937 (37.7235826018289, -122.40586870937)
90740 18413 3 88 799X Potrero Ave 5 1 1 2   03/05/2013 12:00:00 AM 3 4X4   6010481.346466599 2104567.7087473 37.759333078347105 -122.406804093165 (37.7593330783471, -122.406804093165)
10309 108845 1 88 420 Woolsey St 4 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 772583 6010479.05335 2091857.99264 37.7244348155857 -122.405916697196 (37.7244348155857, -122.405916697196)
79562 114722 1 88 465 Woolsey St 6 1 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788.0 37.724241933851296 -122.405954818575 (37.7242419338513, -122.405954818575)
96881 114721 1 88 465 Woolsey St 4 1 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788.0 37.724241933851296 -122.405954818575 (37.7242419338513, -122.405954818575)
143971 114720 1 88 465 Woolsey St 2 1 1 1   12/02/2015 12:00:00 AM     Permit Number 774759 6010466.6 2091788.0 37.724241933851296 -122.405954818575 (37.7242419338513, -122.405954818575)
124483 37803 1 88 465 Woolsey St 8 1 1 1 1 12/02/2015 12:00:00 AM     Permit Number 774759 6010402.90992445 2091781.87036726 37.7242215408534 -122.406174555323 (37.7242215408534, -122.406174555323)
40529 230283 2 88 626 Potrero Ave 1 1 1 1     1 Width 3ft   6010353.7895 2105370.3020900004 37.761529680867 -122.40730182853201 (37.761529680867, -122.407301828532)
9341 116840 1 88 636 POTRERO AVE 2 1 1 1     4 3x3   6010345.0 2105335.0 37.761432257364994 -122.40732973919701 (37.761432257365, -122.407329739197)
132124 193349 2 88 2501 18th St 13 1 1 1     1 Width 5ft   6010309.72434 2105489.81742 37.761855376635104 -122.407462658778 (37.7618553766351, -122.407462658778)
153057 112790 2 88 20 Joice St 1 20 1 1     11 3x3   6010307.8181300005 2116296.03331 37.791526616311295 -122.40823143793502 (37.7915266163113, -122.408231437935)
116356 26561 3 88 430 Bay Shore Blvd 2 1 1 2   03/10/2007 12:00:00 AM 3 3X3   6010306.750370901 2097855.6706051 37.740893529599106 -122.406934857164 (37.7408935295991, -122.406934857164)
56518 177443 2 88 63 Karen Ct 1 1 1 1     1 Width 2ft   6010306.59987 2091507.00491 37.7234614298874 -122.40648812732799 (37.7234614298874, -122.406488127328)
45642 131006 2 88 25 Joice St 1 1 1 1     13 Width 3ft   6010297.06637 2116294.60935 37.7915221044126 -122.40826853856599 (37.7915221044126, -122.408268538566)
120377 114754 1 88 83 Karen Ct   1 1 1   12/04/2015 12:00:00 AM     Permit Number 777134 6010271.6 2091687.4 37.723954799188704 -122.406621822462 (37.7239547991887, -122.406621822462)
160433 177442 2 88 67 Karen Ct 1 1 1 1     1 Width 2ft   6010267.21749 2091493.9064200001 37.723423260860706 -122.40662334309799 (37.7234232608607, -122.406623343098)
41960 177441 2 88 71 Karen Ct 2 1 1 1     1 Width 2ft   6010258.66598 2091491.8701799999 37.7234171913236 -122.406652760812 (37.7234171913236, -122.406652760812)
54565 177434 2 88 131 Brussels St 1 1 1 1     1 Width 4ft   6010258.4147 2094004.87757 37.7303173692474 -122.40683065573099 (37.7303173692474, -122.406830655731)
149083 177440 2 88 71 Karen Ct 1 1 1 1     1 Width 2ft   6010238.57006 2091486.2001099999 37.7234004981218 -122.406721829644 (37.7234004981218, -122.406721829644)
66196 107892 1 88 162 Brewster St   8 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
55956 246808 2 88 162 Brewster St 1 4 1 1     1 Width 2ft   6010230.46229 2099004.5054099998 37.744043711743004 -122.407279600877 (37.744043711743, -122.407279600877)
37514 193348 2 88 2501 18th St 7 1 1 1     1 Width 5ft   6010227.27367 2105486.95448 37.7618429003376 -122.407747622459 (37.7618429003376, -122.407747622459)
15251 108093 1 88 2501X 18th St 5 1 1 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010203.41719 2105485.67353 37.7618380476045 -122.40783004261999 (37.7618380476045, -122.40783004262)
57885 230313 2 88 968 Hampshire St 1 1 1 1     2 Width 3ft   6010194.52879 2103588.6082900004 37.756628635618604 -122.40772701540399 (37.7566286356186, -122.407727015404)
37487 177439 2 88 79 Karen Ct 1 1 1 1     1 Width 2ft   6010188.86492 2091471.00105 37.7233559834822 -122.406892581232 (37.7233559834822, -122.406892581232)
15441 108091 1 88 2501X 18th St 3 1 1 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010179.28671 2105483.3887400003 37.7618304231561 -122.407913339641 (37.7618304231561, -122.407913339641)
176355 177438 2 88 83 Karen Ct 1 1 1 1     1 Width 2ft   6010165.7616 2091462.99776 37.723332715313894 -122.406971881647 (37.7233327153139, -122.406971881647)
16791 108089 1 88 2501X 18th St 1 1 1 1   11/20/2014 12:00:00 AM 3   Permit Number 773081 6010157.47788 2105483.07585 37.761828343024604 -122.407988746007 (37.7618283430246, -122.407988746007)
171865 114755 1 88 89 Karen Ct 1 1 1 1   12/04/2015 12:00:00 AM 1   Permit Number 777135 6010155.72688 2091460.8073900002 37.723326139481294 -122.407006415641 (37.7233261394813, -122.407006415641)
150867 230315 2 88 131 Peralta Ave 2 1 1 1     1 Width 3ft   6010141.9244099995 2100150.42012 37.7471851875523 -122.407666527004 (37.7471851875523, -122.407666527004)
146648 230316 2 88 131 Peralta Ave 1 1 1 1     1 Width 3ft   6010129.26175 2100145.52723 37.7471710439032 -122.407709968747 (37.7471710439032, -122.407709968747)
36033 177437 2 88 93 Karen Ct 1 1 1 1     1 Width 2ft   6010115.68283 2091447.6223799998 37.72328769526371 -122.407143912081 (37.7232876952637, -122.407143912081)
75167 177436 2 88 99 Karen Ct 2 1 1 1     1 Width 2ft   6010107.2934 2091444.47715 37.7232785896114 -122.40717269128099 (37.7232785896114, -122.407172691281)
149661 95133 1 88 450@ Wayland Somerset St 2 1 1 1   01/04/2010 12:00:00 AM 1 3x3 Permit Number 54066 6010089.84133 2092358.2905700002 37.725786753837 -122.407297408351 (37.725786753837, -122.407297408351)
174665 177435 2 88 99 Karen Ct 1 1 1 1     1 Width 2ft   6010088.68836 2091439.3296700001 37.72326341446679 -122.407236642978 (37.7232634144668, -122.407236642978)
188778 230303 2 88 2784 23rd St 2 1 1 1     6 Width 3ft   6010083.7548 2102826.7491599997 37.7545305388726 -122.40805638669501 (37.7545305388726, -122.408056386695)
151893 230300 2 88 1225 York St 1 1 1 1     3 Width 3ft   6010064.03861 2101924.1335400003 37.7520510531386 -122.408060919271 (37.7520510531386, -122.408060919271)
40091 95676 1 88 232 Goettingen St 1 1 1 1 1 03/08/2011 12:00:00 AM 3 3x3 Permit Number 767428 6010063.65694 2093465.1071400002 37.7288243741431 -122.407465923318 (37.7288243741431, -122.407465923318)
147644 230301 2 88 1083 York St 1 1 1 1     8 Width 3ft   6010010.1738 2102926.1510900003 37.754799354323 -122.40831786097999 (37.754799354323, -122.40831786098)
51443 105800 1 88 207 Raymond Ave 1 1 1 1   02/27/2014 12:00:00 AM 3   Permit Number 769635 6010004.04754 2087785.0667299998 37.713224823850005 -122.407271751589 (37.71322482385, -122.407271751589)
Powered by Datasette · Query took 11.374ms · Data source: data.sfgov.org