sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
78823 12380 3 11   1 1 1 2   09/17/2013 12:00:00 AM 3 3x3   6004345.46385 2113763.0093400003 37.7842359045501 -122.42868045552099 (37.7842359045501, -122.428680455521)
109669 14676 3 254   1 1 1 2   05/12/2011 12:00:00 AM 3 4x4   6005306.03378 2112177.46067 37.7799366952092 -122.425244357372 (37.7799366952092, -122.425244357372)
21876 3876 3 22 1 Castro St 1 1 1 2     12 3X3   6001972.79866 2108696.56564 37.7701901557853 -122.43652626967199 (37.7701901557853, -122.436526269672)
13586 12949 3 15 1 Lindsay Cir 1 1 1 2     6 3X3   6016403.18992 2095651.77267 37.7351813255446 -122.38570186665501 (37.7351813255446, -122.385701866655)
10396 9301 3 108 1 Mansell St 3 1 1 2     12 3X3   6011832.7040800005 2090706.21234 37.7213478755834 -122.401156387751 (37.7213478755834, -122.401156387751)
10817 9300 3 2 1 Mansell St 2 1 1 2   06/10/1992 12:00:00 AM 12 3X3   6011786.56982 2090691.5636900002 37.7213050795375 -122.40131483301901 (37.7213050795375, -122.401314833019)
11461 9299 3 2 1 Mansell St 1 1 1 2     6 3X3   6011744.95061 2090679.05023 37.7212683980005 -122.401457820749 (37.7212683980005, -122.401457820749)
13384 13425 3 15 1 Market St 9 1 1 2   02/10/2007 12:00:00 AM 25 4x4   6014152.78687 2117194.5214299997 37.7942082021958 -122.39499075902599 (37.7942082021958, -122.394990759026)
13475 13427 3 15 1 Market St 11 1 1 2     30 4x4   6014172.84776 2117212.91542 37.7942598232708 -122.394922634488 (37.7942598232708, -122.394922634488)
13620 13426 3 15 1 Market St 10 1 1 2   10/29/2003 12:00:00 AM 8 4x4   6014161.01916 2117188.17749 37.7941912409866 -122.394961829643 (37.7941912409866, -122.394961829643)
14334 13428 3 15 1 Market St 12 1 1 2   10/29/2003 12:00:00 AM 6 4x4   6014180.24954 2117205.51401 37.7942399123011 -122.394896504683 (37.7942399123011, -122.394896504683)
14650 13430 3 15 1 Market St 14 1 1 2     20 4x4   6014204.722019999 2117228.6530400002 37.7943048073789 -122.394813447799 (37.7943048073789, -122.394813447799)
14759 13420 3 15 1 Market St 4 1 1 2   05/18/1991 12:00:00 AM 30 4x4   6014066.39965 2117110.5956099997 37.7939729575322 -122.395283788713 (37.7939729575322, -122.395283788713)
15013 13423 3 15 1 Market St 7 1 1 2   12/12/2002 12:00:00 AM 20 4x4   6014116.98151 2117144.48589 37.7940688252683 -122.39511114407699 (37.7940688252683, -122.395111144077)
15024 13424 3 15 1 Market St 8 1 1 2   01/02/2003 12:00:00 AM 20 4x4   6014140.16579 2117170.60528 37.7941418322359 -122.395032753763 (37.7941418322359, -122.395032753763)
15548 13429 3 15 1 Market St 13 1 1 2     25 4x4   6014197.04513 2117235.7914400003 37.7943239809064 -122.39484051109501 (37.7943239809064, -122.394840511095)
15704 13419 3 15 1 Market St 3 1 1 2   09/10/1991 12:00:00 AM 20 4x4   6014048.53109 2117080.6085599996 37.7938896263516 -122.395343514492 (37.7938896263516, -122.395343514492)
15964 13422 3 15 1 Market St 6 1 1 2   02/10/2007 12:00:00 AM 3 4x4   6014092.01898 2117123.77404 37.7940105671925 -122.39519606616999 (37.7940105671925, -122.39519606617)
16385 27316 3 15 1 Market St 1 1 1 2     35 4x4   6014028.45913 2117061.6774 37.7938365294714 -122.39541163905199 (37.7938365294714, -122.395411639052)
16449 13418 3 15 1 Market St 2 1 1 2     40 4x4   6014042.20206 2117087.71971 37.7939087999011 -122.395365912104 (37.7939087999011, -122.395365912104)
16600 13421 3 15 1 Market St 5 1 1 2   01/02/1991 12:00:00 AM 30 4x4   6014072.44813 2117102.953 37.793952309100206 -122.395262324595 (37.7939523091002, -122.395262324595)
76817 90411 3 37 1 McCoppin St 4 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006552.3 2109010.7 37.771311860318 -122.420708085152 (37.771311860318, -122.420708085152)
77634 90408 3 37 1 McCoppin St 1 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
104896 90409 3 37 1 McCoppin St 2 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
109635 90410 3 37 1 McCoppin St 3 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006661.144462001 2109154.301371 37.7717122894321 -122.420341780693 (37.7717122894321, -122.420341780693)
19459 15076 3 75 1 Minerva St 2 11 1 2     6 11   5995952.59829 2089005.6317099999 37.7157797770894 -122.455926258705 (37.7157797770894, -122.455926258705)
21404 15067 3 75 1 Minerva St 9 11 1 2     3 11   5996019.74584 2089003.9616 37.7157790450506 -122.455694046564 (37.7157790450506, -122.455694046564)
77416 107558 3 17 1 Newhall St 9 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
81584 107564 3 17 1 Newhall St 8 7 1 2   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
83430 107562 3 17 1 Newhall St 2 7 1 2   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
84607 107559 3 17 1 Newhall St 10 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
98961 107560 3 17 1 Newhall St 11 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
103606 107561 3 17 1 Newhall St 12 7 1 2   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
112266 107554 3 17 1 Newhall St 1 1 1 2       3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
120274 107563 3 17 1 Newhall St 5 7 1 2   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
123339 107555 3 17 1 Newhall St 3 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
125335 107556 3 17 1 Newhall St 6 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
142291 107557 3 17 1 Newhall St 7 1 1 2   11/12/2014 12:00:00 AM 3 3x3 Permit Number 774049 6018726.0 2097063.0 37.739184535220005 -122.37776889284599 (37.73918453522, -122.377768892846)
2209 189798 3 32 1 Potrero Ave 2 1 1 2     17 Width 3ft   6010293.93626 2108038.50565 37.7688526102954 -122.407696978027 (37.7688526102954, -122.407696978027)
1952 139587 3 37 1 Saint Joseph's Ave 4 1 1 2     11 Width 0ft   6000732.3602 2112121.031 37.7795223070318 -122.441062642932 (37.7795223070318, -122.441062642932)
83347 22801 3 17 1 Turquoise Way 1 1 1 2   06/12/1997 12:00:00 AM 3 2x2   5998832.3639752995 2099992.0164602003 37.746110667966704 -122.446762549602 (37.7461106679667, -122.446762549602)
111961 1 3 3 10 10th Ave 1 11 1 2     3 16   5992719.40718 2114869.71245 37.7866097734767 -122.46898271049601 (37.7866097734767, -122.468982710496)
107859 1389 3 44 10 Ardath Ct 1 1 1 2   03/11/2006 12:00:00 AM 3 3X4   6017228.6912616 2095462.3520099 37.7347068580177 -122.38283460251301 (37.7347068580177, -122.382834602513)
17205 26909 3 39 10 Caine Ave 5 11 1 2     18 10   5997629.54091 2089680.9775599998 37.71773022584279 -122.45017865014299 (37.7177302258428, -122.450178650143)
17237 26912 3 39 10 Caine Ave 8 11 1 2     50 10   5997598.31865 2089637.50605 37.7176090763688 -122.450283439137 (37.7176090763688, -122.450283439137)
19068 26911 3 103 10 Caine Ave 7 11 1 2     18 10   5997609.86555 2089654.4499099997 37.7176562610968 -122.450244747607 (37.7176562610968, -122.450244747607)
19083 26913 3 39 10 Caine Ave 9 11 1 2     24 10   5997584.35365 2089616.43233 37.717550413599795 -122.45033019131 (37.7175504135998, -122.45033019131)
19195 26910 3 39 10 Caine Ave 6 11 1 2     12 10   5997620.43146 2089669.0920400003 37.7176970696553 -122.45020928103399 (37.7176970696553, -122.450209281034)
19203 26914 3 224 10 Caine Ave 10 11 1 2     12 10   5997577.15723 2089606.82913 37.7175236335794 -122.45035437405599 (37.7175236335794, -122.450354374056)
19342 26905 3 39 10 Caine Ave 1 11 1 2     12 10   5997683.40035 2089758.8108400002 37.7179470200262 -122.449998089654 (37.7179470200262, -122.449998089654)
19833 26915 3 180 10 Caine Ave 11 11 1 2   01/26/1999 12:00:00 AM 3 10   5997570.4467 2089598.1443599998 37.7174994031582 -122.450376943463 (37.7174994031582, -122.450376943463)
20603 26906 3 39 10 Caine Ave 2 11 1 2     24 10   5997668.873459999 2089736.17467 37.717884035095295 -122.450046671911 (37.7178840350953, -122.450046671911)
21305 26908 3 39 10 Caine Ave 4 11 1 2     18 10   5997639.65043 2089696.09364 37.7177723096208 -122.45014479517 (37.7177723096208, -122.45014479517)
21645 26907 3 39 10 Caine Ave 3 11 1 2     18 10   5997653.71656 2089718.57825 37.717834852078205 -122.45009779478701 (37.7178348520782, -122.450097794787)
88204 14623 3 18 10 Matthew Ct 2 1 1 2   02/12/1998 12:00:00 AM 6 3X4   6018016.8978124 2094239.2837711999 37.7313920698281 -122.38002451510201 (37.7313920698281, -122.380024515102)
13724 4898 3 28 10 Rosie Lee Ln 4 1 1 2     6 3X4   6017985.0017 2094485.55993 37.7320665362465 -122.380151894906 (37.7320665362465, -122.380151894906)
14426 4895 3 39 10 Rosie Lee Ln 1 1 1 2   04/19/1993 12:00:00 AM 12 3X4   6018140.882180001 2094365.07214 37.7317442992597 -122.379604608867 (37.7317442992597, -122.379604608867)
16623 4897 3 28 10 Rosie Lee Ln 3 1 1 2     12 3X4   6018099.28954 2094405.0263599998 37.731851711585996 -122.37975117949 (37.731851711586, -122.37975117949)
23034 4896 3 28 10 Rosie Lee Ln 2 1 1 2   01/11/1999 12:00:00 AM 6 3X4   6018106.77773 2094390.5453599999 37.731812362636205 -122.37972428526699 (37.7318123626362, -122.379724285267)
110441 28300 3 43 100 Broad St 2 1 1 2     13 3X3   5995887.0 2088090.0 37.713261901345 -122.45608683538099 (37.713261901345, -122.456086835381)
14267 3797 3 11 100 Cashmere St 2 1 1 2     18 3X3   6016837.41936 2095915.09048 37.7359283617946 -122.384218895383 (37.7359283617946, -122.384218895383)
23210 3796 3 11 100 Cashmere St 1 1 1 2     1 3X3   6016917.42909 2095896.09045 37.735880614983294 -122.38394094461901 (37.7358806149833, -122.383940944619)
7160 4592 3 32 100 Columbus Ave 3 1 1 2   03/23/2016 01:42:00 PM 3 3x3   6011401.079390001 2118088.92644 37.796510626729706 -122.40457501395299 (37.7965106267297, -122.404575013953)
22996 4591 3 11 100 Columbus Ave 2 1 1 2     2 3x2   6011425.16703 2118064.77563 37.796445660597 -122.40448996415199 (37.796445660597, -122.404489964152)
17252 24963 3 100 100 Dolores St 4 11 1 2     90 20   6004800.736959999 2107633.50365 37.7674315357679 -122.42666873508999 (37.7674315357679, -122.42666873509)
19333 24968 3 100 100 Dolores St 9 11 1 2     90 20   6004810.58196 2107534.1310400004 37.767159239034704 -122.426627605497 (37.7671592390347, -122.426627605497)
19334 24962 3 100 100 Dolores St 3 11 1 2   04/21/2005 12:00:00 AM 30 20   6004805.8872 2107667.07109 37.76752399506629 -122.42665331171999 (37.7675239950663, -122.42665331172)
19826 24965 3 100 100 Dolores St 6 11 1 2     90 20   6004804.04595 2107595.6918 37.767327900586 -122.42665459683799 (37.767327900586, -122.426654596838)
20452 24966 3 100 100 Dolores St 7 11 1 2     90 20   6004812.73188 2107584.41194 37.76729741985871 -122.426623750096 (37.7672974198587, -122.426623750096)
21578 5327 3 32 100 Dolores St 1 1 1 2     90 3X3   6004755.67064 2107733.77413 37.7677043064343 -122.426831755188 (37.7677043064343, -122.426831755188)
22009 24961 3 100 100 Dolores St 1 11 1 2   04/21/2005 12:00:00 AM 90 20   6004800.95891 2107734.51921 37.76770891277079 -122.42667516163999 (37.7677089127708, -122.42667516164)
19241 116677 3 58 100 Esmeralda Ave 16 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
78555 116671 3 28 100 Esmeralda Ave 7 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
82247 116682 3 108 100 Esmeralda Ave 21 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
86166 116675 3 180 100 Esmeralda Ave 14 14 1 2     14     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
89602 116672 3 3 100 Esmeralda Ave 9 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
92622 116679 3 211 100 Esmeralda Ave 18 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
95944 116681 3 38 100 Esmeralda Ave 20 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
113837 116669 3 47 100 Esmeralda Ave 6 14 1 2     20     6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
123800 116680 3 132 100 Esmeralda Ave 19 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
126736 116670 3 180 100 Esmeralda Ave 8 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
127057 116678 3 58 100 Esmeralda Ave 17 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
138825 116683 3 108 100 Esmeralda Ave 22 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
143384 116676 3 338 100 Esmeralda Ave 15 14 1 2           6006917.389830001 2098966.37493 37.7437530336215 -122.41873278303999 (37.7437530336215, -122.41873278304)
84722 8291 3 3 100 Garcia Ave 1 11 1 2     6 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
87594 8293 3 3 100 Garcia Ave 3 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
95088 8292 3 3 100 Garcia Ave 2 11 1 2     18 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
117295 8294 3 3 100 Garcia Ave 4 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
128632 8295 3 3 100 Garcia Ave 5 11 1 2     24 8   5995006.6013281 2099280.197711 37.743936899881 -122.45993989851101 (37.743936899881, -122.459939898511)
4690 253527 3 79 100 Haight St 2 1 1 2   10/19/2017 09:54:00 AM 3 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
20140 10246 3 79 100 Haight St 1 1 1 2     30 3X3   6005589.149 2109643.5092 37.7729950707153 -122.424084680793 (37.7729950707153, -122.424084680793)
9933 11201 3 241 100 Idora Ave 4 11 1 2     3 8   5995318.65927 2099418.1217 37.7443335470614 -122.458870864793 (37.7443335470614, -122.458870864793)
18799 11188 3 35 100 Idora Ave 1 11 1 2     24 8   5995291.088769999 2099424.10153 37.7443483813689 -122.45896663000299 (37.7443483813689, -122.458966630003)
18983 11186 3 35 100 Idora Ave 2 11 1 2     18 8   5995298.39303 2099423.25523 37.7443464775133 -122.458941312315 (37.7443464775133, -122.458941312315)
20854 11187 3 5 100 Idora Ave 3 11 1 2     12 8   5995309.2253 2099420.08132 37.7443383854121 -122.458903627104 (37.7443383854121, -122.458903627104)
21814 11202 3 306 100 Idora Ave 5 11 1 2     3 8   5995328.17404 2099416.28223 37.744329043248 -122.458837831796 (37.744329043248, -122.458837831796)
16854 11488 3 36 100 Jennings St 2 1 1 2   01/05/1993 12:00:00 AM 6 4X4   6018872.157000001 2097296.32677 37.7398332567899 -122.377279727371 (37.7398332567899, -122.377279727371)
16881 11487 3 11 100 Jennings St 1 1 1 2     12 4X4   6018880.35523 2097308.40588 37.7398668752499 -122.37725221891 (37.7398668752499, -122.37725221891)
80072 11492 3 50 100 Jennings St 6 1 1 2   01/13/2000 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
81124 11506 3 36 100 Jennings St 20 1 1 2     6 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
85301 11491 3 50 100 Jennings St 5 1 1 2   01/13/2000 12:00:00 AM 3 4X4   6018974.640384 2097432.5118216 37.7402128389975 -122.376934824049 (37.7402128389975, -122.376934824049)
Powered by Datasette · Query took 120.011ms · Data source: data.sfgov.org