sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19020 25 3 37 736 14th St 1 1 1 2   07/17/1995 12:00:00 AM 0     6003903.525084401 2107767.6234363 37.7677490306877 -122.429781635515 (37.7677490306877, -122.429781635515)
126224 28 1 37 742 14th St 1 1 1 1   06/15/2011 12:00:00 AM 3 3x3   6003863.8671794 2107765.4342001 37.76774077377821 -122.42991865118601 (37.7677407737782, -122.429918651186)
17593 35 1 37 765 14th St 1 1 1 1     3 3X3   6003712.362269999 2107704.7999 37.767565705622296 -122.430438361268 (37.7675657056223, -122.430438361268)
116627 63 3 37 847 14th St 1 1 1 2   04/07/2015 12:00:00 AM 3 3X3   6003197.9718305 2107678.5983679 37.7674646107508 -122.43221569826001 (37.7674646107508, -122.43221569826)
18609 192 3 37 385X Guerrero St 1 1 1 2   10/09/2013 12:00:00 AM 3 3X3   6005547.989469999 2106715.71324 37.7649537200544 -122.424018813443 (37.7649537200544, -122.424018813443)
17890 193 3 37 423X Guerrero St 1 1 1 2   03/24/2008 12:00:00 AM 3 3X3   6005562.55526 2106507.52991 37.764382920371496 -122.423953628772 (37.7643829203715, -122.423953628772)
17148 197 3 37 300 Castro St 1 1 1 2     12 3X3   6002246.85388 2106423.49653 37.7639644352284 -122.43541568967899 (37.7639644352284, -122.435415689679)
12865 210 1 37 2929 19th Ave 1 1 1 1   11/28/2006 12:00:00 AM 3 2X3   5990521.9439 2095739.47468 37.7339560397287 -122.475188219755 (37.7339560397287, -122.475188219755)
11340 237 1 37 3007 19th Ave 1 1 1 1   03/18/2006 12:00:00 AM 6 2   5990538.44703 2095140.6475 37.732312768812896 -122.47508746420799 (37.7323127688129, -122.475087464208)
97846 238 3 37 3007 19th Ave 2 1 1 2   03/18/2006 12:00:00 AM 6 2   5990525.395690001 2095120.4577099998 37.7322565763444 -122.47513111186001 (37.7322565763444, -122.47513111186)
12218 246 1 37 3039 19th Ave 1 1 1 1   03/18/2006 12:00:00 AM 6 2   5990544.75562 2094979.28403 37.7318700712305 -122.47505387905599 (37.7318700712305, -122.475053879056)
82798 265 1 37 3201X 19th Ave 4 1 1 1   03/18/2006 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
129124 266 3 37 3201X 19th Ave 5 1 1 2   02/18/1999 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
128857 267 3 37 3201X 19th Ave 6 1 1 2   03/18/2006 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
139213 268 1 37 3201X 19th Ave 7 1 1 1   03/18/2006 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
111882 269 3 37 3201X 19th Ave 8 1 1 2   03/18/2006 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
145883 271 3 37 3201X 19th Ave 10 1 1 2   03/18/2006 12:00:00 AM 6 3X3   5990532.43506 2093914.7774599998 37.728946491022604 -122.475018795259 (37.7289464910226, -122.475018795259)
12177 287 3 37 3355 19th Ave 3 1 1 2   02/27/1998 12:00:00 AM 6 2   5990530.52606 2093814.1828 37.7286701727855 -122.475018054542 (37.7286701727855, -122.475018054542)
141431 317 1 37 3498X 19th Ave 2 1 1 1   02/24/2008 12:00:00 AM 3 2   5990579.05408 2092494.4249099998 37.725049260991604 -122.474754004974 (37.7250492609916, -122.474754004974)
79259 329 3 37 3454X 19th Ave 1 1 1 2   11/15/1995 12:00:00 AM 3 2   5990579.05408 2092494.4249099998 37.725049260991604 -122.474754004974 (37.7250492609916, -122.474754004974)
144000 335 3 37 3590X 19th Ave 2 1 1 2   11/07/2015 01:03:00 PM 3 3x18   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
96255 338 3 37 3590X 19th Ave 6 1 1 2   03/18/1999 12:00:00 AM   2   5990537.683837099 2091850.0721832002 37.723277631918 -122.474850005229 (37.723277631918, -122.474850005229)
127778 341 3 37 3590X 19th Ave 10 1 1 2   03/10/2013 12:00:00 AM 10 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
110799 342 3 37 3590X 19th Ave 11 1 1 2   03/09/2013 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
84381 343 3 37 3590X 19th Ave 12 1 1 2   03/09/2013 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
126668 344 3 37 3590X 19th Ave 13 1 1 2   02/24/2008 12:00:00 AM 3 2X2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
119861 345 3 37 3590X 19th Ave 14 1 1 2     3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
98859 346 3 37 3590X 19th Ave 15 1 1 2   11/07/2015 01:09:00 PM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
115580 347 3 37 3590X 19th Ave 16 1 1 2   02/24/2008 12:00:00 AM 25 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
129471 349 3 37 3590X 19th Ave 18 1 1 2   03/23/2006 12:00:00 AM 3 3X3   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
94449 351 3 37 3590X 19th Ave 21 1 1 2   02/22/2008 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
104889 352 3 37 3590X 19th Ave 20 1 1 2   05/18/1994 12:00:00 AM 3 2   5990537.68384 2091850.07218 37.7232776319094 -122.474850005219 (37.7232776319094, -122.474850005219)
22038 354 3 37 3690X 19th Ave 1 1 1 2   11/10/1995 12:00:00 AM 24 2   5990504.49839 2091477.17058 37.722251813860204 -122.474937513077 (37.7222518138602, -122.474937513077)
113903 355 3 37 3690X 19th Ave 3 1 1 2   03/09/2013 12:00:00 AM 2 2   5990489.7429471 2091103.3809490001 37.7212246253597 -122.47496124712299 (37.7212246253597, -122.474961247123)
98926 357 3 37 3690X 19th Ave 4 2 1 2   03/09/2013 12:00:00 AM 2 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
108637 360 3 37 3690X 19th Ave 6 1 1 2   03/09/2013 12:00:00 AM 2 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
83114 366 3 37 3690X 19th Ave 13 1 1 2     3 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
110873 367 3 37 3690X 19th Ave 15 1 1 2   05/12/1994 12:00:00 AM 12 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
79963 368 3 37 3690X 19th Ave 17 1 1 2   11/07/2015 01:12:00 PM 3 2   5990489.74295 2091103.38095 37.7212246253626 -122.474961247113 (37.7212246253626, -122.474961247113)
120248 383 3 37 3721X 19th Ave 2 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
85567 384 3 37 3721X 19th Ave 5 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
125863 385 3 37 3721X 19th Ave 6 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
86727 387 3 37 3721X 19th Ave 7 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
114841 388 3 37 3721X 19th Ave 9 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
80402 389 3 37 3721X 19th Ave 10 1 1 2   03/18/2006 12:00:00 AM 3 2   5990351.3309 2090950.31436 37.72079632016629 -122.475428522866 (37.7207963201663, -122.475428522866)
89509 399 1 37 3790X 19th Ave 10 1 1 1   02/24/2008 12:00:00 AM 3 2   5990543.5477982005 2090571.3277717 37.719766857298396 -122.474736447703 (37.7197668572984, -122.474736447703)
16908 406 1 37 3822 19th Ave 1 1 1 1   03/10/2007 12:00:00 AM 3 2x5   5990686.0398699995 2090357.61675 37.7191883155766 -122.47422832208599 (37.7191883155766, -122.474228322086)
21232 409 1 37 3838 19th Ave 1 1 1 1   02/24/2008 12:00:00 AM 3 2X3   5990744.200019999 2090277.4187900003 37.7189714809286 -122.474021438444 (37.7189714809286, -122.474021438444)
21161 419 1 37 3874 19th Ave 1 1 1 1   02/24/2008 12:00:00 AM 3 2X3   5990927.36264 2090022.7346400002 37.718282789105295 -122.47336975731501 (37.7182827891053, -122.473369757315)
78172 442 3 37 700x 23rd Ave 2 11 1 2     12     5988814.32729 2110443.9038299997 37.7742313463884 -122.482168813724 (37.7742313463884, -122.482168813724)
144664 449 3 37 700x 23rd Ave 9 11 1 2     12 8-HOA   5988819.75093 2110337.06115 37.7739383014913 -122.482142223603 (37.7739383014913, -122.482142223603)
120774 452 3 37 740x 23rd Ave 15 11 1 2     12     5988823.98791 2110205.31094 37.773576798380205 -122.482117913396 (37.7735767983802, -122.482117913396)
90389 464 3 37 760x 23rd Ave 18 11 1 2     6     5988827.211759999 2110098.29514 37.7732831501538 -122.48209892030701 (37.7732831501538, -122.482098920307)
94915 465 3 37 760x 23rd Ave 17 11 1 2     12 8-HOA   5988826.12619 2110109.25362 37.773313175965 -122.482103478364 (37.773313175965, -122.482103478364)
122619 478 3 37 2300X Lake St 1 1 1 2     30 3X3   5988301.98955 2114692.83548 37.7858679033343 -122.484252736316 (37.7858679033343, -122.484252736316)
86609 685 1 37 2340X Lake St 3 1 1 1   05/15/2008 12:00:00 AM 3 4X4   5988222.7193 2114685.44657 37.7858429996456 -122.484526443804 (37.7858429996456, -122.484526443804)
84299 699 1 37 2551X Lake St 1 1 1 1     3 3X3   5987474.44326 2114604.18984 37.785576288970795 -122.487109266635 (37.7855762889708, -122.487109266635)
139749 819 3 37 1410 45th Ave 1 1 1 2   02/25/2008 12:00:00 AM 3 3X3   5982179.061767 2105489.8566905 37.7602407921924 -122.50475385101299 (37.7602407921924, -122.504753851013)
21813 851 3 37 362 Alemany Blvd 1 1 1 2   06/11/1992 12:00:00 AM 18 3X3   6008418.030180001 2095243.6630400002 37.7336156580305 -122.413280706764 (37.7336156580305, -122.413280706764)
11213 893 1 37 1162X Alemany Blvd 1 1 1 1   05/14/1997 12:00:00 AM 8 3X6   6003397.35641 2094349.3863099997 37.730877020048 -122.430574836985 (37.730877020048, -122.430574836985)
11380 928 1 37 1285 Alemany Blvd 1 1 1 1   06/15/1992 12:00:00 AM 10 3X4   6002746.05074 2094024.26586 37.729947394457604 -122.432803287742 (37.7299473944576, -122.432803287742)
11225 952 1 37 1500 Alemany Blvd 1 1 1 1     12 6x6   6002047.349219999 2093382.65925 37.7281460362049 -122.435172906015 (37.7281460362049, -122.435172906015)
9439 995 1 37 1682 Alemany Blvd 1 1 1 1   08/12/2011 12:00:00 AM 3 4x4   6001498.326169999 2092340.4216099998 37.725253096867206 -122.436996309494 (37.7252530968672, -122.436996309494)
11881 1007 3 37 1827 Alemany Blvd 1 1 1 2   03/06/2006 12:00:00 AM 10 3X3   6001335.27273 2091591.54514 37.723187582737395 -122.43750636433701 (37.7231875827374, -122.437506364337)
12617 1019 3 37 1868 Alemany Blvd 1 1 1 2   06/13/1997 12:00:00 AM 12 3X3   6001068.280809999 2091265.41408 37.722276917520496 -122.43840594717 (37.7222769175205, -122.43840594717)
125827 1028 3 37 1989X Alemany Blvd 5 1 1 2     10 3X3   6000752.12664 2090469.86783 37.7200745396752 -122.439441815719 (37.7200745396752, -122.439441815719)
10581 1040 3 37 2003X Alemany Blvd 2 1 1 2     25 4X4   6000664.666119999 2090352.04738 37.7197460535115 -122.439735693745 (37.7197460535115, -122.439735693745)
17836 1046 3 37 2009X Alemany Blvd 2 1 1 2   06/15/1992 12:00:00 AM 12 4X4   6000674.20134 2090359.18139 37.7197661846273 -122.43970324513701 (37.7197661846273, -122.439703245137)
12030 1064 1 37 2073X Alemany Blvd 1 1 1 1   06/15/1992 12:00:00 AM 12 3X3   6000384.95261 2090073.81885 37.7189661758191 -122.44068261512399 (37.7189661758191, -122.440682615124)
13084 1106 1 37 2355 Alemany Blvd 1 1 1 1   06/15/1992 12:00:00 AM 10 3x3   5999402.478519999 2089142.52516 37.716353057130604 -122.44401175335699 (37.7163530571306, -122.444011753357)
125777 1112 1 37 2385 Alemany Blvd 1 1 1 1   06/15/1992 12:00:00 AM 10 3x3   5999333.8364 2089049.0837 37.7160925721821 -122.44424230229299 (37.7160925721821, -122.444242302293)
98603 1122 3 37 2454 Alemany Blvd 1 1 1 2   09/07/2011 12:00:00 AM 3 3x3   5999000.36988 2088909.59415 37.7156905350991 -122.445384893004 (37.7156905350991, -122.445384893004)
12429 1133 3 37 2566 Alemany Blvd 1 1 1 2   05/15/1997 12:00:00 AM 10 3X3   5998552.75251 2088645.69218 37.7149403579834 -122.44691307777599 (37.7149403579834, -122.446913077776)
4075 1149 3 37 2678 Alemany Blvd 1 1 1 2   10/05/2017 08:44:00 AM 3 3X3   5998020.45993 2088357.3562599998 37.7141182292418 -122.448732141877 (37.7141182292418, -122.448732141877)
4414 1175 3 37 2900 Alemany Blvd 10 1 1 2   10/11/2017 10:42:00 AM 3 3X3   5996816.67595 2087452.1631200002 37.711563867747 -122.452827563661 (37.711563867747, -122.452827563661)
12019 1187 3 37 3022 Alemany Blvd 1 1 1 2   02/18/1998 12:00:00 AM 20 3X3   5996561.5746 2087275.10705 37.7110630910694 -122.45369647960399 (37.7110630910694, -122.453696479604)
11067 1190 1 37 3034 Alemany Blvd 1 1 1 1   02/23/2005 12:00:00 AM 3 3X3   5996528.95527 2087256.53034 37.7110102136125 -122.45380787863199 (37.7110102136125, -122.453807878632)
12413 1191 1 37 3044 Alemany Blvd 1 1 1 1   02/18/1998 12:00:00 AM 12 3X3   5996503.24503 2087241.9631400001 37.710968741375105 -122.45389568755199 (37.7109687413751, -122.453895687552)
13225 1194 1 37 3051 Alemany Blvd 1 1 1 1   12/02/1998 12:00:00 AM 6 3X3   5996527.0746 2087144.8903599998 37.7107035681781 -122.453806321904 (37.7107035681781, -122.453806321904)
11552 1195 1 37 3062-3062 Alemany Blvd 1 1 1 1   02/18/1998 12:00:00 AM 8 3x3   5996475.62372 2087226.6805900002 37.710925195309294 -122.453990049815 (37.7109251953093, -122.453990049815)
12871 1197 3 37 3080 Alemany Blvd 2 1 1 2   09/25/2015 12:00:00 AM 3 3X3   5996407.37603 2087190.7232 37.7108225512021 -122.454223333055 (37.7108225512021, -122.454223333055)
20467 1216 1 37 3501 Alemany Blvd 1 1 1 1   01/25/2000 12:00:00 AM 8 3X3   5993668.38843 2087432.7738400002 37.711329717576 -122.46370738819999 (37.711329717576, -122.4637073882)
139038 1224 3 37 3600X Alemany Blvd 5 1 1 2   12/02/1998 12:00:00 AM 15 3X5   5993524.054670201 2087589.4711722 37.7117516532039 -122.46421760708901 (37.7117516532039, -122.464217607089)
113065 1228 3 37 3600X Alemany Blvd 9 1 1 2   12/02/1998 12:00:00 AM 12 3X5   5993524.054670201 2087589.4711722 37.7117516532039 -122.46421760708901 (37.7117516532039, -122.464217607089)
115339 1229 3 37 3600X Alemany Blvd 10 1 1 2   12/02/1998 12:00:00 AM 12 3X5   5993524.054670201 2087589.4711722 37.7117516532039 -122.46421760708901 (37.7117516532039, -122.464217607089)
125751 1231 1 37 3601X Alemany Blvd 2 1 1 1   06/15/1992 12:00:00 AM 15 3X3   5993438.31243 2087500.5986099998 37.71150268788671 -122.464507504506 (37.7115026878867, -122.464507504506)
11711 1236 1 37 3702X Alemany Blvd 1 1 1 1   04/22/2008 12:00:00 AM 3 3X5   5993199.6595 2087639.3681700001 37.711869955605394 -122.465342418633 (37.7118699556054, -122.465342418633)
138419 1282 3 37 3995X Alemany Blvd 20 1 1 2   01/19/2000 12:00:00 AM 3 3X3   5992394.0 2087287.0 37.7108559409462 -122.468101362588 (37.7108559409462, -122.468101362588)
17127 1361 3 37 14 Amethyst Way 1 1 1 2   08/29/2016 12:00:00 AM 3 3X3   5999192.9019 2100038.7006099997 37.746259440735294 -122.445519216737 (37.7462594407353, -122.445519216737)
19259 1364 3 37 25 Amethyst Way 1 1 1 2     12 1X1   5999126.95834 2100012.88601 37.746184795201 -122.445745384538 (37.746184795201, -122.445745384538)
17550 1369 3 37 34 Amethyst Way 1 1 1 2   12/02/1997 12:00:00 AM 3     5999059.98844 2100047.12811 37.746274991794294 -122.445979419622 (37.7462749917943, -122.445979419622)
18338 1372 1 37 44 Amethyst Way 1 1 1 1   12/02/1997 12:00:00 AM 3 3X3   5998995.9428900005 2100044.21237 37.74626332849721 -122.44620067084401 (37.7462633284972, -122.446200670844)
23285 1681 3 37 405 Balboa St 1 1 1 2     3 3X3   5994319.83202 2111404.8234200003 37.7771884605269 -122.46319416353901 (37.7771884605269, -122.463194163539)
21455 1939 3 37 209 Berkeley Way 1 1 1 2   01/02/2016 08:31:00 AM 3 3x3   6000815.48464 2097758.14469 37.740090072596004 -122.439745061994 (37.740090072596, -122.439745061994)
7561 2191 1 37 1059 Broderick St 1 1 1 1   04/09/1998 12:00:00 AM 6 4X4   6000860.0298 2112380.5159 37.780242057456704 -122.440639597689 (37.7802420574567, -122.440639597689)
9487 2233 1 37 1217 Broderick St 1 1 1 1   03/25/1993 12:00:00 AM 9 4X4   6000793.5299 2112868.6894 37.781578670102704 -122.440904680944 (37.7815786701027, -122.440904680944)
18549 2328 1 37 2308 Bryant St 1 1 1 1   04/01/2016 12:00:00 AM 3 3X3   6009637.87747 2103837.38143 37.7572805334784 -122.409669683221 (37.7572805334784, -122.409669683221)
13925 2497 3 37 1500 Burke Ave 1 1 1 2     12 3X3   6016766.5915 2098782.9536200003 37.7437990179202 -122.384663486948 (37.7437990179202, -122.384663486948)
9416 2543 1 37 1580 Burke Ave 2 1 1 1     3 3X3   6016211.0400559995 2099180.9466222 37.7448610852571 -122.386612216975 (37.7448610852571, -122.386612216975)
18505 2550 3 37 50 Burnside Ave 1 1 1 2   01/01/1999 12:00:00 AM 3 3x3   6001174.5251400005 2095817.91912 37.7347830958454 -122.438364680879 (37.7347830958454, -122.438364680879)
104777 3759 3 37 1062 Carolina St 1 11 1 2     12 18   6012453.5755993 2103020.9691678 37.755196225865895 -122.39987450779499 (37.7551962258659, -122.399874507795)
Powered by Datasette · Query took 23.113ms · Data source: data.sfgov.org