sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
57453 175343 2 12 19 Rhine St 2 2 1 1     9 Width 3ft   5994542.86208 2086742.78517 37.709485521912605 -122.460635037876 (37.7094855219126, -122.460635037876)
187533 175341 2 12 18 Rhine St 2 4 1 1     7 Width 3ft   5994500.0272699995 2086747.2122099998 37.709495213017 -122.460783401753 (37.709495213017, -122.460783401753)
187124 175340 2 12 18 Rhine St 1 4 1 1     4 Width 3ft   5994510.0494800005 2086755.6303299998 37.7095189038466 -122.460749373209 (37.7095189038466, -122.460749373209)
31303 57950 1 12 18 Byron Ct 1 1 1 1   08/11/2010 12:00:00 AM 7   Permit Number 53675 5999217.95376 2086673.30833 37.7095626181023 -122.44447220083099 (37.7095626181023, -122.444472200831)
52663 175540 2 12 100 Winding Way 8 1 1 1     2 Width 3ft   6002098.18365 2086653.46706 37.709672060177205 -122.434516226437 (37.7096720601772, -122.434516226437)
112299 175539 2 12 100 Winding Way 7 1 1 1     2 Width 3ft   6002109.51722 2086657.56891 37.7096839663235 -122.43447734874901 (37.7096839663235, -122.434477348749)
36293 71578 2 12 94X De Long St 1 1 1 1 1 09/30/1995 12:00:00 AM 13     5994610.40755 2086820.2353700001 37.709702067873 -122.460407199135 (37.709702067873, -122.460407199135)
166302 175335 2 12 114 De Long St 2 4 1 1     10 Width 3ft   5994496.623790001 2086824.0668400002 37.7097060419715 -122.46080073078699 (37.7097060419715, -122.460800730787)
186035 175334 2 12 114 De Long St 1 4 1 1     12 Width 3ft   5994510.66891 2086823.77253 37.709706041981704 -122.460752167376 (37.7097060419817, -122.460752167376)
31818 175337 2 12 114 De Long St 4 4 1 1     14 Width 3ft   5994455.45704 2086824.9295299998 37.7097060419823 -122.46094307188801 (37.7097060419823, -122.460943071888)
39699 175336 2 12 114 De Long St 3 4 1 1     9 Width 3ft   5994472.9026 2086825.04671 37.709707367568996 -122.460882785837 (37.709707367569, -122.460882785837)
57361 175538 2 12 100 Winding Way 6 1 1 1     1 Width 3ft   6002134.19074 2086666.27286 37.7097092660433 -122.43439269468 (37.7097092660433, -122.43439269468)
180604 175537 2 12 100 Winding Way 5 1 1 1     2 Width 3ft   6002143.87727 2086669.6862400002 37.7097191882713 -122.434359460221 (37.7097191882713, -122.434359460221)
111474 98267 1 12 98X De Long St 1 1 1 1 1     3x3   5994599.8 2086859.2 37.7098084453918 -122.460446681932 (37.7098084453918, -122.460446681932)
25284 175279 2 12 526 Lathrop Ave 16 1 1 1     2 Width 3ft   6013138.73238 2086502.48989 37.7098780615819 -122.396347291017 (37.7098780615819, -122.396347291017)
11333 26173 3 12 1815 Geneva Ave 1 1 1 2   02/07/1997 12:00:00 AM 16 2X3   6005106.30691 2086667.8505900002 37.709881856719605 -122.42412063198299 (37.7098818567196, -122.424120631983)
134606 44739 1 12 227 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 11   Permit Number 43856 5992060.248430001 2086948.89288 37.709908299502004 -122.469230282263 (37.709908299502, -122.469230282263)
162646 187512 2 12 1888 Geneva Ave 12 4 1 1     4 Width 3ft   6004972.0075900005 2086680.68467 37.7099095126929 -122.424585708258 (37.7099095126929, -122.424585708258)
149056 175278 2 12 526 Lathrop Ave 13 1 1 1     1 Width 3ft   6013077.46081 2086521.95754 37.709928106177 -122.39656042222201 (37.709928106177, -122.396560422222)
170289 187511 2 12 1888 Geneva Ave 11 4 1 1     5 Width 3ft   6004958.741090001 2086695.30162 37.7099488984891 -122.42463259891599 (37.7099488984891, -122.424632598916)
164843 187510 2 12 1888 Geneva Ave 10 4 1 1     5 Width 3ft   6004948.81965 2086709.68307 37.709987826555704 -122.424667911703 (37.7099878265557, -122.424667911703)
46718 175277 2 12 526 Lathrop Ave 9 1 1 1     2 Width 3ft   6012970.32425 2086556.9358700002 37.7100181867499 -122.396933159753 (37.7100181867499, -122.396933159753)
185618 78542 2 12 918 Huron Ave 1 1 1 1 1 10/21/2000 12:00:00 AM 11     5996973.29255 2086886.4307 37.710019470088206 -122.452245463059 (37.7100194700882, -122.452245463059)
153430 187509 2 12 1888 Geneva Ave 9 4 1 1     5 Width 3ft   6004937.85944 2086722.41778 37.7100221743453 -122.424706697651 (37.7100221743453, -122.424706697651)
129674 44736 1 12 219 Saint Charles Ave 1 1 1 1 1 04/03/2001 12:00:00 AM 11   Permit Number 43853 5992060.83811 2086996.78191 37.7100398253609 -122.469231727479 (37.7100398253609, -122.469231727479)
171461 175276 2 12 526 Lathrop Ave 6 1 1 1     1 Width 3ft   6012912.96497 2086574.92244 37.7100643813264 -122.39713266623899 (37.7100643813264, -122.397132666239)
162385 187507 2 12 1888 Geneva Ave 7 4 1 1     4 Width 3ft   6004913.95724 2086749.2623400001 37.7100945337938 -122.424791216847 (37.7100945337938, -122.424791216847)
94038 31044 1 12 1170 Prague St 1 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34802 6000764.32963575 2086845.61786645 37.710123855039896 -122.439140013916 (37.7101238550399, -122.439140013916)
127451 31045 1 12 1170 Prague St 2 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34802 6000764.32963575 2086845.61786645 37.710123855039896 -122.439140013916 (37.7101238550399, -122.439140013916)
92243 31043 1 12 1160 Prague St 2 1 1 1   03/13/1995 12:00:00 AM     Permit Number 34801 6000799.02081427 2086846.59721813 37.7101285180714 -122.43902018475201 (37.7101285180714, -122.439020184752)
99233 31042 1 12 1160 Prague St 1 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34801 6000799.02081427 2086846.59721813 37.7101285180714 -122.43902018475201 (37.7101285180714, -122.439020184752)
105127 31041 1 12 1150 Prague St 1 1 1 1 1 03/13/1995 12:00:00 AM     Permit Number 34800 6000833.71199279 2086847.57656981 37.7101331809809 -122.43890035557199 (37.7101331809809, -122.438900355572)
26977 175275 2 12 526 Lathrop Ave 2 1 1 1     1 Width 3ft   6012824.28041 2086603.35832 37.7101375232094 -122.39744117239599 (37.7101375232094, -122.397441172396)
169545 187506 2 12 1888 Geneva Ave 6 4 1 1     9 Width 3ft   6004893.16086 2086772.3737400002 37.7101568181467 -122.424864736445 (37.7101568181467, -122.424864736445)
80792 108763 1 12 500X Lathrop Ave 2 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
84811 108770 1 12 500X Lathrop Ave 9 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
97559 108774 1 12 500X Lathrop Ave 13 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
103669 108777 1 12 500X Lathrop Ave 16 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
128675 108767 1 12 500X Lathrop Ave 6 1 1 1 1 01/06/2015 12:00:00 AM 3   Permit Number 773822 6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
150929 187505 2 12 1888 Geneva Ave 5 4 1 1     9 Width 3ft   6004874.161669999 2086793.27995 37.710213148986504 -122.42493188792 (37.7102131489865, -122.42493188792)
29342 78567 2 12 40 Sears St 1 1 1 1 1 10/21/2000 12:00:00 AM 0     5996717.44875 2086996.04025 37.7103057728767 -122.453137611232 (37.7103057728767, -122.453137611232)
166288 44417 1 12 848 Prague St 1 1 1 1 1 03/23/2001 12:00:00 AM 10   Permit Number 43767 6002130.68513 2086945.75609 37.710476466874496 -122.43442477978 (37.7104764668745, -122.43442477978)
184512 175307 2 12 1742 Geneva Ave 8 1 1 1     8 Width 3ft   6004766.21251 2086895.4758400002 37.710487658948296 -122.42531224987101 (37.7104876589483, -122.425312249871)
59346 44416 1 12 842 Prague St 1 1 1 1 1 03/23/2001 12:00:00 AM 13   Permit Number 43766 6002162.64544 2086961.7492400003 37.7105221947079 -122.43431546089501 (37.7105221947079, -122.434315460895)
68384 175306 2 12 1742 Geneva Ave 7 1 1 1     8 Width 3ft   6004746.19153 2086909.36885 37.71052467505 -122.425382434757 (37.71052467505, -122.425382434757)
130893 175305 2 12 1742 Geneva Ave 6 1 1 1     9 Width 3ft   6004724.37554 2086923.7481799999 37.710562925021 -122.425458858251 (37.710562925021, -122.425458858251)
170312 44447 1 12 59 Winding Way 2 1 1 1 1 03/23/2001 12:00:00 AM 5   Permit Number 43776 6002676.42201 2086971.7309400002 37.7105787512666 -122.432540451876 (37.7105787512666, -122.432540451876)
149762 175304 2 12 1742 Geneva Ave 5 1 1 1     9 Width 3ft   6004677.62307 2086954.36825 37.7106443595226 -122.425622622982 (37.7106443595226, -122.425622622982)
135283 175303 2 12 1742 Geneva Ave 4 1 1 1     8 Width 3ft   6004651.78459 2086970.6278900001 37.710687544962795 -122.425713083103 (37.7106875449628, -122.425713083103)
35600 44400 1 12 1127 Munich St 2 1 1 1 1 03/23/2001 12:00:00 AM 12   Permit Number 43754 6001650.52714 2087033.38345 37.7106898049515 -122.43609057243 (37.7106898049515, -122.43609057243)
66725 44399 1 12 1127 Munich St 1 1 1 1 1 03/23/2001 12:00:00 AM 12   Permit Number 43754 6001633.42416 2087033.93549 37.710690349047496 -122.43614972354601 (37.7106903490475, -122.436149723546)
87283 25772 1 12 1750X Geneva Ave 8 1 1 1   01/15/1997 12:00:00 AM 10 3x3   6004521.41969 2087037.70187 37.710864348182604 -122.42616842571998 (37.7108643481826, -122.42616842572)
104229 25771 1 12 1750X Geneva Ave 7 1 1 1   01/15/1997 12:00:00 AM 12 3x3   6004521.41969 2087037.70187 37.710864348182604 -122.42616842571998 (37.7108643481826, -122.42616842572)
117289 25773 1 12 1750X Geneva Ave 9 1 1 1   02/07/1997 12:00:00 AM 12 3x3   6004521.41969 2087037.70187 37.710864348182604 -122.42616842571998 (37.7108643481826, -122.42616842572)
124578 25770 1 12 1750X Geneva Ave 6 1 1 1   01/15/1997 12:00:00 AM 13 3x3   6004521.41969 2087037.70187 37.710864348182604 -122.42616842571998 (37.7108643481826, -122.42616842572)
125364 25769 1 12 1750X Geneva Ave 5 1 1 1   08/09/2005 12:00:00 AM 12 3x3   6004521.41969 2087037.70187 37.710864348182604 -122.42616842571998 (37.7108643481826, -122.42616842572)
165968 175302 2 12 1742 Geneva Ave 3 1 1 1     10 Width 3ft   6004474.571269999 2087047.63134 37.7108889643141 -122.42633105133301 (37.7108889643141, -122.426331051333)
150849 175301 2 12 1742 Geneva Ave 2 1 1 1     7 Width 3ft   6004419.64861 2087071.12111 37.7109503574482 -122.426522548479 (37.7109503574482, -122.426522548479)
21239 84843 1 12 1201 Sunnydale Ave 3 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
79491 84845 1 12 1201 Sunnydale Ave 5 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
81431 84842 1 12 1201 Sunnydale Ave 2 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
87070 84841 1 12 1201 Sunnydale Ave 1 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
87386 84850 1 12 1201 Sunnydale Ave 10 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
92583 84844 1 12 1201 Sunnydale Ave 4 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
97949 84848 1 12 1201 Sunnydale Ave 8 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
104326 84846 1 12 1201 Sunnydale Ave 6 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
109985 86777 1 12 1201SAWYER Sunnydale Ave   1 1 1         Permit Number 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
113092 84847 1 12 1201 Sunnydale Ave 7 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
119080 86779 1 12 1201SAWYER Sunnydale Ave   1 1 1   04/16/2007 12:00:00 AM     Permit Number 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
144491 84849 1 12 1201 Sunnydale Ave 9 1 1 1   04/16/2007 12:00:00 AM     Permit No. 49246 6008311.7 2086994.1 37.7109581313437 -122.41306521032699 (37.7109581313437, -122.413065210327)
30286 175300 2 12 1742 Geneva Ave 1 1 1 1     10 Width 3ft   6004400.88871 2087080.49473 37.710975034844104 -122.42658805420099 (37.7109750348441, -122.426588054201)
187451 44412 1 12 33 Naylor St 1 1 1 1 1 03/23/2001 12:00:00 AM 13   Permit Number 43763 6002334.21635 2087134.94604 37.7110074922697 -122.43373484600201 (37.7110074922697, -122.433734846002)
132141 175546 2 12 298 Cordova St 1 2 1 1     7 Width 8ft   6001847.622269999 2087157.43402 37.7110416161394 -122.435418236567 (37.7110416161394, -122.435418236567)
180720 44398 1 12 1076 Munich St 1 1 1 1 1 03/23/2001 12:00:00 AM 14   Permit Number 43753 6002036.48794 2087189.47909 37.7111403293394 -122.43476776231701 (37.7111403293394, -122.434767762317)
82315 86984 1 12 301 Executive Park Blvd 2 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
90476 86989 1 12 301 Executive Park Blvd 7 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
95722 86990 1 12 301 Executive Park Blvd 8 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
113172 86995 1 12 301 Executive Park Blvd 13 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
113470 86985 1 12 301 Executive Park Blvd 3 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
113734 86996 1 12 301 Executive Park Blvd 14 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
12448 25779 3 12 1711 Geneva Ave 1 1 1 2   04/18/1997 12:00:00 AM 18 2X3   6004456.9664199995 2087146.9586900002 37.711160700777604 -122.426398965455 (37.7111607007776, -122.426398965455)
12925 25778 3 12 1707 Geneva Ave 1 1 1 2   04/18/1997 12:00:00 AM 18 2X3   6004431.84726 2087156.7380099997 37.711186132712704 -122.426486479377 (37.7111861327127, -122.426486479377)
11870 25764 1 12 1686 Geneva Ave 1 1 1 1   01/15/1997 12:00:00 AM 16 2X3   6004225.91042 2087173.5217 37.7112205731354 -122.427199443002 (37.7112205731354, -122.427199443002)
170322 188198 2 12 251 Executive Park Blvd 2 2 1 1     3 Width 3ft   6014615.61789 2086983.20072 37.711280074094205 -122.39127643847999 (37.7112800740942, -122.39127643848)
49729 188199 2 12 251 Executive Park Blvd 3 2 1 1     3 Width 3ft   6014599.16354 2086984.8296400001 37.7112836335959 -122.39133342311399 (37.7112836335959, -122.391333423114)
60247 188200 2 12 251 Executive Park Blvd 7 2 1 1     4 Width 3ft   6014523.7676099995 2086992.1522 37.711299555189 -122.39159452417101 (37.711299555189, -122.391594524171)
184907 188201 2 12 251 Executive Park Blvd 8 2 1 1     3 Width 3ft   6014503.81395 2086993.06554 37.711300955448706 -122.39166355343399 (37.7113009554487, -122.391663553434)
12519 25762 1 12 1676 Geneva Ave 1 1 1 1   01/15/1997 12:00:00 AM 18 2X3   6004168.351919999 2087205.26365 37.711304474489495 -122.427400639338 (37.7113044744895, -122.427400639338)
150513 188202 2 12 251 Executive Park Blvd 13 2 1 1     5 Width 3ft   6014410.24908 2087000.56675 37.711316358145794 -122.39198746407101 (37.7113163581458, -122.391987464071)
185082 188203 2 12 251 Executive Park Blvd 14 2 1 1     2 Width 3ft   6014389.30237 2087003.03012 37.7113219591221 -122.39206003394399 (37.7113219591221, -122.392060033944)
84764 25767 1 12 1750X Geneva Ave 3 1 1 1   01/15/1997 12:00:00 AM 10 3x3   6004169.70325 2087219.02605 37.7113423395092 -122.427396948573 (37.7113423395092, -122.427396948573)
89760 25768 1 12 1750X Geneva Ave 4 1 1 1   01/15/1997 12:00:00 AM 13 3x3   6004169.70325 2087219.02605 37.7113423395092 -122.427396948573 (37.7113423395092, -122.427396948573)
99636 25765 1 12 1750X Geneva Ave 1 1 1 1   01/15/1997 12:00:00 AM 11 3X3   6004169.70325 2087219.02605 37.7113423395092 -122.427396948573 (37.7113423395092, -122.427396948573)
109727 25766 1 12 1750X Geneva Ave 2 1 1 1   01/15/1997 12:00:00 AM 10 3X3   6004169.70325 2087219.02605 37.7113423395092 -122.427396948573 (37.7113423395092, -122.427396948573)
12207 25780 3 12 1679 Geneva Ave 1 1 1 2   12/11/1997 12:00:00 AM 16 2X3   6004231.29582 2087263.70147 37.711468491959295 -122.427187249092 (37.7114684919593, -122.427187249092)
20613 30097 3 12 400X Brotherhood Way 1 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
80021 30103 3 12 400X Brotherhood Way 4 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
89698 30131 3 12 400X Brotherhood Way 16 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
93772 30118 3 12 400X Brotherhood Way 10 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
94101 30115 3 12 400X Brotherhood Way 9 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
96343 30122 3 12 400X Brotherhood Way 11 1 1 2   03/10/2007 12:00:00 AM 3     5993855.385701 2087505.2120740002 37.711539389410504 -122.463066335527 (37.7115393894105, -122.463066335527)
Powered by Datasette · Query took 21.034ms · Data source: data.sfgov.org