sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
16896 100001 2 32 501X 01st St 2 10 1 1         Address is 100 1st Street          
165598 176477 2 32 37 Seville St 1 1 1 1     7 Width 2ft   6002111.84755 2087511.4643599999 37.7120287084207 -122.434530308936 (37.7120287084207, -122.434530308936)
107056 104507 2 32 99x DICHIERA CT 1 1 1 1     18 3x3   5998517.0 2087907.0 37.7129100350962 -122.44698352706499 (37.7129100350962, -122.446983527065)
60199 30866 1 32 8 Tioga Ave 1 1 1 1   02/16/1995 12:00:00 AM 13   Permit Number 34703 6011319.26825 2088660.76535 37.7157028373837 -122.402787421618 (37.7157028373837, -122.402787421618)
35305 176450 2 32 306 Niagara Ave 1 9 1 1     6 Width 8ft   5998817.229619999 2090113.0618900002 37.718984525607 -122.446104420884 (37.718984525607, -122.446104420884)
60281 202078 2 32 1 Gould St 7 7 1 1     15     6012742.601 2090834.0731400002 37.721749674703496 -122.398020073164 (37.7217496747035, -122.398020073164)
11127 17225 3 32 1880X Alemany Blvd 2 1 1 2   03/06/1990 12:00:00 AM 20 3X3   6001020.116669999 2091172.22125 37.7220182913915 -122.438565764807 (37.7220182913915, -122.438565764807)
72441 176475 2 32 631 Hamilton St 2 1 1 1     53 Width 3ft   6009778.33855 2091470.0330700001 37.7233303456119 -122.40831163228201 (37.7233303456119, -122.408311632282)
67956 176458 2 32 457 Yale St 1 1 1 1     9 Width 2ft   6007542.94981 2091608.68611 37.723585627160794 -122.41604878674299 (37.7235856271608, -122.416048786743)
46699 176455 2 32 1535 Bacon St 1 1 1 1     8 Width 2ft   6007043.36789 2091721.1381400002 37.72386629477921 -122.41778372465099 (37.7238662947792, -122.417783724651)
61616 176459 2 32 413 Yale St 1 1 1 1     11 Width 2ft   6007513.47384 2091725.2307 37.7239039763787 -122.416158930301 (37.7239039763787, -122.416158930301)
63116 34940 1 32 448 Amherst St 1 1 1 1 1 02/19/2000 12:00:00 AM 6   Permit Number 38537 6007767.30311 2091743.1741799999 37.7239675143844 -122.415282750512 (37.7239675143844, -122.415282750512)
31530 176457 2 32 432 Amherst St 1 1 1 1     7 Width 2ft   6007753.63778 2091789.4964700001 37.7240939374796 -122.415333267232 (37.7240939374796, -122.415333267232)
158485 176456 2 32 418 Amherst St 1 9 1 1     9 Width 4ft   6007734.27889 2091838.5588099998 37.7242275641336 -122.415403659872 (37.7242275641336, -122.415403659872)
74833 176447 2 32 843 Cayuga Ave 1 9 1 1     5 Width 6ft   6001152.60647 2092059.5558 37.7244622467113 -122.438171314947 (37.7244622467113, -122.438171314947)
64822 176448 2 32 843 Cayuga Ave 2 9 1 1     6 Width 6ft   6001153.28465 2092061.4502700001 37.724467487066 -122.43816910622401 (37.724467487066, -122.438169106224)
30172 176454 2 32 1609 Burrows St 1 10 1 1     6 Width 2ft   6006663.80662 2092086.9978599998 37.7248494992863 -122.41912174768801 (37.7248494992863, -122.419121747688)
72845 176436 2 32 463 Hamilton St 1 1 1 1     10 Width 3ft   6009577.49826 2092143.36094 37.725167914146 -122.40905338952 (37.725167914146, -122.40905338952)
59721 176437 2 32 463 Hamilton St 2 1 1 1     7 Width 3ft   6009568.704580001 2092164.8194900001 37.725226342194794 -122.409085301949 (37.7252263421948, -122.409085301949)
184054 176438 2 32 457 Hamilton St 1 1 1 1     7 Width 2ft   6009565.15013 2092176.9971099999 37.725259580258204 -122.409098448262 (37.7252595802582, -122.409098448262)
111915 176439 2 32 457 Hamilton St 2 1 1 1     8 Width 2ft   6009562.305930001 2092184.9167799999 37.725281166673 -122.409108838997 (37.725281166673, -122.409108838997)
44703 176440 2 32 451 Hamilton St 1 1 1 1     10 Width 2ft   6009554.85724 2092203.7224400002 37.7253323857764 -122.40913591488399 (37.7253323857764, -122.409135914884)
56299 176441 2 32 451 Hamilton St 2 1 1 1     8 Width 2ft   6009551.98522 2092218.4392099997 37.725372634037 -122.409146881221 (37.725372634037, -122.409146881221)
185388 176449 2 32 817 Cayuga Ave 4 1 1 1     11 Width 3ft   6001220.52796 2092231.19277 37.7249373855418 -122.43794880828501 (37.7249373855418, -122.437948808285)
158913 62132 1 32 145 San Juan Ave 1 1 1 1 1 08/31/1985 12:00:00 AM 11   Permit Number 22246 6001265.02575 2092251.26554 37.724995031173 -122.437796421771 (37.724995031173, -122.437796421771)
54717 176442 2 32 439 Hamilton St 1 1 1 1     8 Width 2ft   6009537.48644 2092260.08015 37.7254861590383 -122.40919993944401 (37.7254861590383, -122.409199939444)
64350 176443 2 32 439 Hamilton St 2 1 1 1     6 Width 2ft   6009532.53015 2092277.47605 37.7255336468499 -122.409218299982 (37.7255336468499, -122.409218299982)
170010 176444 2 32 427 Hamilton St 1 1 1 1     11 Width 1ft   6009521.33765 2092315.76215 37.725638145367896 -122.409259692199 (37.7256381453679, -122.409259692199)
162841 62134 1 32 215 San Juan Ave 1 1 1 1 1 08/31/1985 12:00:00 AM 11   Permit Number 22242 6001128.8833099995 2092317.53271 37.725169243356795 -122.438271795315 (37.7251692433568, -122.438271795315)
13023 96561 2 32 421 Hamilton St 1 1 1 1     10 2x2   6009510.75375 2092344.78253 37.725717236250404 -122.40929832706101 (37.7257172362504, -122.409298327061)
12965 96562 2 32 421 Hamilton St 2 1 1 1     10 2x2   6009504.65574 2092358.16495 37.7257536399061 -122.40932035147199 (37.7257536399061, -122.409320351472)
170240 67288 1 32 78 Valmar Ter 1 1 1 1 1 06/22/1992 12:00:00 AM 10   Permit Number 30764 6005282.20957 2092652.1251400001 37.7263233136635 -122.423937939201 (37.7263233136635, -122.423937939201)
59193 190149 2 32 2399 Lane St 1 17 1 1     12     6013956.81212 2092846.6213599998 37.727343279763296 -122.393963643334 (37.7273432797633, -122.393963643334)
131235 190150 2 32 2399 Lane St 3 17 1 1     11     6013973.08997 2092870.4197900002 37.7274095301006 -122.393909035588 (37.7274095301006, -122.393909035588)
187632 68261 1 32 331 Holyoke St 1 1 1 1 1 08/09/1993 12:00:00 AM 4   Permit Number 32067 6009662.93548 2092873.24927 37.72717681975 -122.40880951134301 (37.72717681975, -122.408809511343)
152165 176453 2 32 140 Madison St 1 9 1 1     10 Width 2ft   6005488.1147 2093033.7267 37.7273827303155 -122.42325324845801 (37.7273827303155, -122.423253248458)
24553 218912 2 32 67 Lakewood Ave 1 1 1 1     3 Width 2ft   5993729.09341 2093249.4084299998 37.727304294154294 -122.463919522093 (37.7273042941543, -122.463919522093)
44328 176451 2 32 26 Edinburgh St 2 1 1 1     9 Width 3ft   6004464.43685 2093359.77432 37.7282201592217 -122.426815314696 (37.7282201592217, -122.426815314696)
40335 176452 2 32 302 Congdon St 2 1 1 1     4 Width 2ft   6004691.53481 2093582.22817 37.728843805794604 -122.42604605710501 (37.7288438057946, -122.426046057105)
34828 218916 2 32 544 Judson Ave 1 9 1 1     10 Width 8ft   5996794.9301 2093643.7566799999 37.728563285644604 -122.453349451027 (37.7285632856446, -122.453349451027)
188597 63627 1 32 67 University St 1 1 1 1   05/19/1987 12:00:00 AM 4   Permit Number 24270 6007827.91665 2093727.62728 37.7294198035797 -122.415213626819 (37.7294198035797, -122.415213626819)
38130 176461 2 32 55 University St 1 10 1 1     7 Width 2ft   6007804.4952 2093798.5187099997 37.7296131398345 -122.415299613696 (37.7296131398345, -122.415299613696)
171580 176462 2 32 49 University St 1 1 1 1     5 Width 2ft   6007792.32037 2093837.33535 37.7297190376839 -122.41534445031 (37.7297190376839, -122.41534445031)
57234 176460 2 32 44 University St 1 1 1 1     11 Width 3ft   6007750.308680001 2093850.57918 37.7297530410657 -122.41549062698999 (37.7297530410657, -122.41549062699)
50904 60868 1 32 37 Capistrano Ave 1 1 1 1   04/25/1983 12:00:00 AM 11   Permit Number 20650 6001292.560409999 2093871.7493599998 37.7294460754672 -122.437817248275 (37.7294460754672, -122.437817248275)
74714 176445 2 32 37 Capistrano Ave 2 1 1 1     11 Width 3ft   6001283.54641 2093883.1202 37.7294767846155 -122.43784922458 (37.7294767846155, -122.43784922458)
38704 52949 1 32 31 Capistrano Ave 1 1 1 1 1 08/03/2006 12:00:00 AM 14   Permit Number 48936 6001265.83557 2093905.19731 37.7295363961645 -122.437912033237 (37.7295363961645, -122.437912033237)
33976 218944 2 32 135 Colon Ave 2 1 1 1     7 Width 3ft   5996130.94498 2093909.94735 37.7292560999702 -122.455664103608 (37.7292560999702, -122.455664103608)
70146 176476 2 32 718 Sweeny St 1 1 1 1     11 Width 3ft   6007131.88508 2094081.13811 37.730351325829794 -122.417644925979 (37.7303513258298, -122.417644925979)
117025 176446 2 32 43 Gorham St 1 1 1 1     15 Width 3ft   6002168.44276 2094346.29605 37.7307988392865 -122.434823165056 (37.7307988392865, -122.434823165056)
46230 176467 2 32 131 Hale St 1 1 1 1     11 Width 3ft   6010016.33557 2094749.8963400002 37.732349484523894 -122.407720071722 (37.7323494845239, -122.407720071722)
179621 176466 2 32 254 Sweeny St 1 1 1 1     15 Width 3ft   6009274.61582 2094752.0999599998 37.732313985602396 -122.410284534429 (37.7323139856024, -122.410284534429)
182418 176465 2 32 217 Sweeny St 1 1 1 1     12 Width 3ft   6009430.63613 2094763.1944799998 37.732353193350704 -122.409745916959 (37.7323531933507, -122.409745916959)
130468 111177 2 32 211 Sweeny St 1 1 1 1     10 3x3   6009453.8507900005 2094770.8247200001 37.732375445275395 -122.409666196537 (37.7323754452754, -122.409666196537)
183005 176468 2 32 118 Hale St 1 1 1 1     10 Width 3ft   6010056.1152800005 2094810.2688799999 37.7325174814929 -122.407586798503 (37.7325174814929, -122.407586798503)
187826 176464 2 32 300 Gaven St 4 9 1 1     17 Width 4ft   6008910.663480001 2094859.0925900002 37.7325873561203 -122.41155036257099 (37.7325873561203, -122.411550362571)
148862 176463 2 32 300 Gaven St 3 9 1 1     25 Width 4ft   6008926.06204 2094862.35921 37.7325971892913 -122.41149735652 (37.7325971892913, -122.41149735652)
54987 176469 2 32 167 Sweeny St 1 1 1 1     9 Width 3ft   6009736.652980001 2094872.31447 37.7326699579377 -122.40869563649099 (37.7326699579377, -122.408695636491)
168230 176472 2 32 178 Sweeny St 1 10 1 1     15 Width 4ft   6009645.3136599995 2094885.75982 37.732701759760396 -122.40901236872699 (37.7327017597604, -122.409012368727)
76916 218961 2 32 387 Joost Ave 1 1 1 1     12 Width 3ft   5999533.62345 2094950.56733 37.7323080815474 -122.443975525052 (37.7323080815474, -122.443975525052)
65997 176471 2 32 138 Sweeny St 1 1 1 1     16 Width 3ft   6009867.29954 2094965.9555099998 37.7329343927939 -122.40825055931002 (37.7329343927939, -122.40825055931)
69664 176470 2 32 130 Sweeny St 1 1 1 1     16 Width 3ft   6009916.73377 2094983.66925 37.732985798939204 -122.408080900424 (37.7329857989392, -122.408080900424)
41511 176474 2 32 230 Gaven St 1 1 1 1     14 Width 3ft   6009301.38379 2094985.2153200002 37.732955570929 -122.410208443664 (37.732955570929, -122.410208443664)
164774 218960 2 32 374 Joost Ave 2 9 1 1     13     5999594.52291 2094990.63523 37.7324215723769 -122.44376785989901 (37.7324215723769, -122.443767859899)
65095 54543 1 32 147 Gaven St 1 1 1 1   07/18/1972 12:00:00 AM 9   Permit Number 10338 6009783.43308 2095111.41047 37.73332908455421 -122.408550765616 (37.7333290845542, -122.408550765616)
448 224849 2 32 4 Rotteck St 1 1 1 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
44706 176473 2 32 146 Gaven St 1 1 1 1     13 Width 3ft   6009765.775830001 2095153.6821 37.7334441645219 -122.40861479285499 (37.7334441645219, -122.408614792855)
462 187628 2 32 2 Rotteck St 1 1 1 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
160666 224905 2 32 426 Bosworth St 2 1 1 1     13 Width 3ft   6003200.720369999 2095197.1222400002 37.7331935693215 -122.431315130093 (37.7331935693215, -122.431315130093)
164292 224850 2 32 319 Bosworth St 1 1 1 1     16 Width 2ft   6003637.59911 2095225.12175 37.7332951990002 -122.42980671882499 (37.7332951990002, -122.429806718825)
184433 224906 2 32 410 Bosworth St 1 1 1 1     16 Width 3ft   6003435.91528 2095250.54652 37.7333535865804 -122.43050580859101 (37.7333535865804, -122.430505808591)
97686 2016 3 32 598 Bosworth St 1 1 1 2     6 3x3 Permit Number 772999 6002387.133452299 2095371.0933820999 37.7336251126369 -122.43414034926901 (37.7336251126369, -122.434140349269)
114573 4953 3 32 598 Bosworth St 2 1 1 2     12 3x3 Permit Number 772999 6002387.133452299 2095371.0933820999 37.7336251126369 -122.43414034926901 (37.7336251126369, -122.434140349269)
160053 224907 2 32 24 Cuvier St 1 1 1 1     11 Width 3ft   6003963.261390001 2095488.3476200001 37.734036394155 -122.42869957243799 (37.734036394155, -122.428699572438)
136586 224886 2 32 2830 Diamond St 1 1 1 1     21 Width 3ft   6002399.509869999 2095496.0741700002 37.7339689836782 -122.43410649173799 (37.7339689836782, -122.434106491738)
45382 190151 2 32 43 Bridgeview Dr 1 4 1 1     9 Width 2ft   6013910.41512 2095496.0882400002 37.7346155971136 -122.39430946233699 (37.7346155971136, -122.394309462337)
118765 105165 2 32 1600X OAKDALE AVE 4 1 1 19     16 3x3   6015006.0 2095503.0 37.734695414582795 -122.390522107646 (37.7346954145828, -122.390522107646)
39707 224908 2 32 22 Cuvier St 2 1 1 1     11 Width 3ft   6003958.12248 2095520.7076700001 37.7341249567003 -122.42871964530701 (37.7341249567003, -122.428719645307)
152138 224909 2 32 22 Cuvier St 1 1 1 1     11 Width 3ft   6003953.55531 2095536.32016 37.734167566584 -122.42873654804701 (37.734167566584, -122.428736548047)
54316 218958 2 32 806 Detroit St 1 1 1 1     6 Width 3ft   5999461.39114 2095552.35302 37.733956323011896 -122.44426847741501 (37.7339563230119, -122.444268477415)
186089 224910 2 32 14 Cuvier St 1 1 1 1     10 Width 3ft   6003951.88648 2095603.60095 37.7343522099779 -122.428747112408 (37.7343522099779, -122.428747112408)
56664 225334 2 32 536 Arlington St 1 1 1 1     16 Width 3ft   6003396.7885 2095656.62848 37.734466378904 -122.43067004818701 (37.734466378904, -122.430670048187)
1825 224880 2 32 691 Chenery St 1 1 1 1   10/19/2016 12:00:00 AM 15 Width 3ft Permit Number 779045 6002530.35822 2095666.1320599997 37.734443349068606 -122.43366625920099 (37.7344433490686, -122.433666259201)
136696 30564 1 32 633 Chenery St 1 1 1 1   01/25/1995 12:00:00 AM 9   Permit Number 34542 6002889.41967 2095678.38488 37.734497359672496 -122.43242574157401 (37.7344973596725, -122.432425741574)
28536 224881 2 32 631 Chenery St 1 1 1 1     10 Width 2ft   6002911.10799 2095680.3620099998 37.7345040182354 -122.43235089908801 (37.7345040182354, -122.432350899088)
49211 218959 2 32 113 Stillings Ave 5 9 1 1     3 Width 4ft   6000075.97071 2095686.0154799998 37.7343583730463 -122.44215328546998 (37.7343583730463, -122.44215328547)
74488 224879 2 32 670 Chenery St 1 1 1 1     15 Width 2ft   6002563.91545 2095705.58789 37.734553589773604 -122.433553059737 (37.7345535897736, -122.433553059737)
18294 4311 1 32 704 Chenery St 1 1 1 1     18 3X3   6002439.77272 2095706.35497 37.734548651581605 -122.433982316925 (37.7345486515816, -122.433982316925)
170502 224878 2 32 660 Chenery St 1 1 1 1     15 Width 2ft   6002621.84248 2095706.5467599998 37.7345595091169 -122.433352855352 (37.7345595091169, -122.433352855352)
132482 224877 2 32 654 Chenery St 1 1 1 1     15 Width 2ft   6002658.40723 2095708.2163200001 37.7345661676825 -122.433226558173 (37.7345661676825, -122.433226558173)
66006 224876 2 32 630 Chenery St 5 1 1 1     14 Width 3ft   6002697.41175 2095710.1050900002 37.7345735664086 -122.43309184153401 (37.7345735664086, -122.433091841534)
57548 224874 2 32 630 Chenery St 3 1 1 1     13 Width 1ft   6002734.235780001 2095711.23062 37.734578745619004 -122.432964609036 (37.734578745619, -122.432964609036)
184564 224875 2 32 630 Chenery St 4 1 1 1     13 Width 1ft   6002716.38989 2095711.8688299998 37.7345794857458 -122.43302635378201 (37.7345794857458, -122.433026353782)
36348 224873 2 32 630 Chenery St 2 1 1 1     13 Width 1ft   6002752.39129 2095712.47226 37.7345831846595 -122.432901928087 (37.7345831846595, -122.432901928087)
164620 224872 2 32 630 Chenery St 1 1 1 1     14 Width 1ft   6002774.43666 2095713.1357200001 37.734586256738 -122.432825757301 (37.734586256738, -122.432825757301)
57131 225337 2 32 3121 Castro St 4 1 1 1     17 Width 4ft   6002904.9845 2095758.9731299998 37.734719519198606 -122.432377682707 (37.7347195191986, -122.432377682707)
40783 190148 2 32 1711 Oakdale Ave 1 4 1 1     6 Width 3ft   6014397.54059 2095926.93864 37.735825689785706 -122.39265542203199 (37.7358256897857, -122.392655422032)
41209 218952 2 32 9 Burlwood Dr 2 1 1 1     7 Width 3ft   5996293.67263 2095955.2526 37.734881352179606 -122.45524929224301 (37.7348813521796, -122.455249292243)
60125 225338 2 32 3045 Castro St 2 1 1 1     19 Width 3ft   6002897.8907699995 2095961.4085900001 37.7352749584633 -122.432416662015 (37.7352749584633, -122.432416662015)
2140 225336 1 32 3030 Castro St 1 1 1 1   12/03/1980 12:00:00 AM 15 Width 2ft Permit Number 18789 6002856.92306 2096000.60547 37.7353802609748 -122.43256110120899 (37.7353802609748, -122.432561101209)
23385 225339 2 32 3033 Castro St 1 10 1 1     15 Width 3ft   6002890.27268 2096019.3333400001 37.73543357459229 -122.43244713645001 (37.7354335745923, -122.43244713645)
Powered by Datasette · Query took 19.378ms · Data source: data.sfgov.org