sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
103089 467 1 62 2490 Bryant St 2 1 1 1   06/02/1992 12:00:00 AM 12 4X4   6009704.8170941 2102845.1135009998 37.7545597392567 -122.409368154592 (37.7545597392567, -122.409368154592)
141568 535 1 62 2578X Bryant St 2 1 1 1     12 3x3   6009729.93179 2102266.32124 37.7529719120351 -122.409240459881 (37.7529719120351, -122.409240459881)
6547 1660 3 62 1400X Fell St 1 1 1 2     18 3X3   6000641.8596 2109991.603 37.7736702824704 -122.441222896356 (37.7736702824704, -122.441222896356)
8814 1661 3 62 1400X Fell St 2 1 1 2     18 3X3   6000589.0817 2109986.3904 37.773652963463796 -122.441405088647 (37.7736529634638, -122.441405088647)
8492 1663 3 62 1400X Fell St 4 1 1 2     18 3X3   6000501.7702 2109972.7072 37.773610418483 -122.44170612948601 (37.773610418483, -122.441706129486)
551 1664 3 62 1400X Fell St 5 1 1 2     18 3X3   6000454.8566 2109968.1462 37.7735952220186 -122.441868082855 (37.7735952220186, -122.441868082855)
7804 1666 3 62 1400X Fell St 7 1 1 2     18 3X3   6000356.4682 2109956.4177 37.7735574116821 -122.44220758007401 (37.7735574116821, -122.442207580074)
19304 2308 1 62 2205 Bryant St 1 1 1 1   04/16/1990 12:00:00 AM 26 5x5   6009667.68521 2104459.2052 37.7589895916184 -122.40961048355 (37.7589895916184, -122.40961048355)
21487 2309 3 62 2213 Bryant St 1 1 1 2     12 3X3   6009668.22468 2104416.43849 37.7588721941234 -122.409605599315 (37.7588721941234, -122.409605599315)
18776 2310 3 62 2227 Bryant St 1 1 1 2     12 3x3   6009672.2386 2104377.81978 37.758766380788 -122.409588991562 (37.758766380788, -122.409588991562)
9681 2312 1 62 2237 Bryant St 1 1 1 1   04/16/1997 12:00:00 AM 10 3X3   6009676.496040001 2104323.4439 37.7586173154622 -122.409570429529 (37.7586173154622, -122.409570429529)
17519 2314 3 62 2253 Bryant St 1 1 1 2     12 3x3   6009680.74998 2104241.2199 37.7583917852794 -122.409549914219 (37.7583917852794, -122.409549914219)
17537 2317 1 62 2266 Bryant St 1 1 1 1     12 4X4   6009618.58082 2104167.6101900004 37.758186185862606 -122.409759727848 (37.7581861858626, -122.409759727848)
17638 2318 1 62 2270 Bryant St 1 1 1 1     18 5X5   6009620.42845 2104139.7744 37.7581098586044 -122.40975137312999 (37.7581098586044, -122.40975137313)
9106 2321 1 62 2287 Bryant St 1 1 1 1   09/20/1996 12:00:00 AM 10 3X3   6009681.0 2104027.0 37.7578035997437 -122.409533930525 (37.7578035997437, -122.409533930525)
17558 2327 1 62 2301 Bryant St 1 1 1 1     12 5X5   6009698.3897 2103901.33897 37.757459537241395 -122.409464921063 (37.7574595372414, -122.409464921063)
19596 2329 1 62 2309 Bryant St 1 1 1 1     12 4X4   6009696.95759 2103872.6762900003 37.7573807557313 -122.409467851061 (37.7573807557313, -122.409467851061)
21137 2330 3 62 2312 Bryant St 1 1 1 2     18 4X4   6009640.84961 2103785.73358 37.7571388866594 -122.409655759023 (37.7571388866594, -122.409655759023)
21051 2331 1 62 2311 Bryant St 1 1 1 1     12 3X3   6009700.99321 2103848.9649799997 37.7573158759309 -122.409452220849 (37.7573158759309, -122.409452220849)
20167 2332 3 62 2318 Bryant St 1 1 1 2     18 6X6   6009643.236190001 2103731.69198 37.7569906343237 -122.409643691024 (37.7569906343237, -122.409643691024)
20799 2336 3 62 2350 Bryant St 1 1 1 2     12 4x4   6009647.84885 2103642.0545799998 37.7567447686625 -122.40962141212201 (37.7567447686625, -122.409621412122)
112335 2341 3 62 2372 Bryant St 1 1 1 2     18 3x3   6009654.94661 2103556.3659 37.756509884537 -122.409590817662 (37.756509884537, -122.409590817662)
17542 2343 3 62 2385 Bryant St 1 1 1 2     23 3X3   6009722.48016 2103476.08894 37.7562932460395 -122.40935159661501 (37.7562932460395, -122.409351596615)
20543 2353 3 62 2413 Bryant St 1 1 1 2   10/03/2013 12:00:00 AM 3 4X4   6009731.35926 2103287.7886799998 37.7557767132463 -122.409307601761 (37.7557767132463, -122.409307601761)
21374 2362 3 62 2473 Bryant St 1 1 1 2     18 3X3   6009749.23862 2102948.41566 37.7548458726476 -122.40922182173 (37.7548458726476, -122.40922182173)
19206 2364 3 62 2483 Bryant St 1 1 1 2     18 3X3   6009753.556480001 2102901.70574 37.754717859559996 -122.40920359338499 (37.75471785956, -122.409203593385)
119180 2371 3 62 2520 BRYANT ST 1 1 1 2     12 3X3   6009678.5 2102633.3 37.753976672205894 -122.40944421875601 (37.7539766722059, -122.409444218756)
17261 2372 1 62 2527 Bryant St 1 1 1 1     18 3x3   6009769.958330001 2102611.45041 37.753921802157706 -122.40912639109699 (37.7539218021577, -122.409126391097)
123006 2373 3 62 2530 Bryant St 1 1 1 2     12 3X3   6009713.5161975 2102600.278568 37.7538879646488 -122.409320793751 (37.7538879646488, -122.409320793751)
17278 2375 3 62 2547 Bryant St 1 1 1 2     18 3X3   6009774.35605 2102523.0562 37.753679337750604 -122.409104945855 (37.7536793377506, -122.409104945855)
21566 2377 1 62 2553 Bryant St 1 1 1 1     12 3X3   6009776.86013 2102474.30381 37.7535456148439 -122.409092846361 (37.7535456148439, -122.409092846361)
18551 2379 1 62 2565 Bryant St 1 1 1 1     18 4X4   6009779.24964 2102431.71295 37.753428803702 -122.40908157785101 (37.753428803702, -122.409081577851)
21060 2380 3 62 2566 Bryant St 1 1 1 2     6 3x3   6009717.08187 2102390.53262 37.7533122488659 -122.409293662278 (37.7533122488659, -122.409293662278)
17306 2392 3 62 2655 Bryant St 1 1 1 2     18 3X3   6009810.34614 2101884.53168 37.751928107698 -122.408935435327 (37.751928107698, -122.408935435327)
18300 2394 3 62 2661 Bryant St 1 1 1 2     18 7X6   6009814.716440001 2101845.61428 37.7518214939686 -122.408917576591 (37.7518214939686, -122.408917576591)
20430 2398 1 62 2700 Bryant St 1 1 1 1     12 3X3   6009763.2742 2101575.57486 37.7510771440053 -122.409076419352 (37.7510771440053, -122.409076419352)
21741 2404 1 62 2724 Bryant St 1 1 1 1     12 3x3   6009770.26673 2101463.3127900003 37.750769288979605 -122.409044318046 (37.7507692889796, -122.409044318046)
18504 2406 1 62 2729 Bryant St 1 1 1 1     12 3X3   6009835.509980001 2101434.53387 37.7506939230859 -122.408816669975 (37.7506939230859, -122.408816669975)
19144 2409 1 62 2743 Bryant St 1 1 1 1   09/30/1996 12:00:00 AM 8 3X3   6009838.5674 2101356.55662 37.7504799860819 -122.40880059638901 (37.7504799860819, -122.408800596389)
18937 2410 3 62 2753 Bryant St 1 1 1 2   07/04/2003 12:00:00 AM 3 3x3   6009844.62689 2101286.4895200003 37.7502879367387 -122.40877469949 (37.7502879367387, -122.40877469949)
21572 2411 1 62 2759 Bryant St 1 1 1 1   01/26/1999 12:00:00 AM 6 4X4   6009845.01424 2101254.8528 37.7502010910033 -122.408771128311 (37.7502010910033, -122.408771128311)
10217 2412 3 62 2770 Bryant St 1 1 1 2   09/18/1996 12:00:00 AM 6 3X3   6009783.25197 2101219.12721 37.7500995368852 -122.40898218658998 (37.7500995368852, -122.40898218659)
21126 2414 3 62 2786 Bryant St 1 1 1 2     12 3X3   6009786.496590001 2101143.3199400003 37.749891568653496 -122.408965618395 (37.7498915686535, -122.408965618395)
104820 2417 3 62 2818 Bryant St 1 1 1 2     12 3x3   6009805.0388946 2100942.8610594 37.7493421915499 -122.408887356555 (37.7493421915499, -122.408887356555)
21155 2419 3 62 2822 Bryant St 1 1 1 2     12 3x3   6009803.315230001 2100866.84766 37.7491333789981 -122.408887954717 (37.7491333789981, -122.408887954717)
19477 2420 1 62 2825 Bryant St 1 1 1 1   09/18/1996 12:00:00 AM 12 3X3   6009867.3992099995 2100896.25477 37.74921771384761 -122.40866842482201 (37.7492177138476, -122.408668424822)
20689 2421 1 62 2834 Bryant St 1 1 1 1     16 3x3   6009805.25518 2100829.83171 37.7490318500391 -122.408878635061 (37.7490318500391, -122.408878635061)
21122 2423 1 62 2840 Bryant St 1 1 1 1     10 3X3   6009807.43229 2100804.44049 37.748962253304 -122.408869315378 (37.748962253304, -122.408869315378)
18250 2427 1 62 2884 Bryant St 1 1 1 1     18 4X4   6009813.095380001 2100671.03054 37.7485962562324 -122.408840321235 (37.7485962562324, -122.408840321235)
139460 2739 3 62 2290X Bush St 1 1 1 2   05/12/1992 12:00:00 AM 8 3x3   6002556.047619999 2114770.51181 37.7869008162884 -122.434943272404 (37.7869008162884, -122.434943272404)
21192 3896 3 62 60 Castro St 1 1 1 2     12 5X5   6002168.7084800005 2107927.71258 37.7680902055206 -122.435793601904 (37.7680902055206, -122.435793601904)
17562 4250 1 62 4047 Cesar Chavez St 1 1 1 1     12 3X3   6003586.97779 2100377.2494099997 37.747438891704505 -122.43034919167201 (37.7474388917045, -122.430349191672)
17242 4298 3 62 4350 Cesar Chavez St 1 1 1 2     6 3X3   6001589.80492 2100313.4171 37.7471502929454 -122.437250699681 (37.7471502929454, -122.437250699681)
20957 4302 3 62 4378 Cesar Chavez St 1 1 1 2     12 3X3   6001457.95867 2100305.5079 37.747121080269295 -122.437706046203 (37.7471210802693, -122.437706046203)
17564 4458 1 62 1420 Church St 1 1 1 1   07/28/1994 12:00:00 AM 3 3X3   6004503.18681 2100562.9723099996 37.7480006990827 -122.427194227854 (37.7480006990827, -122.427194227854)
3829 4634 3 62 500X Columbus Ave 1 11 1 2   08/19/2006 12:00:00 AM 8 3   6010031.5482 2119295.5915 37.799747198685004 -122.40939911161502 (37.799747198685, -122.409399111615)
5524 4635 3 62 500X Columbus Ave 2 11 1 2   01/05/1990 12:00:00 AM 35 3   6010009.8735 2119314.4873 37.7997978674726 -122.409475448708 (37.7997978674726, -122.409475448708)
7577 4636 3 62 500X Columbus Ave 3 11 1 2     45 3   6009974.2224 2119345.7236 37.7998816370329 -122.409601021151 (37.7998816370329, -122.409601021151)
8911 4637 3 62 500X Columbus Ave 4 11 1 2     60 3   6009937.8119 2119380.0857 37.7999739465801 -122.409729442456 (37.7999739465801, -122.409729442456)
7107 4638 3 62 500X Columbus Ave 5 11 1 2     60 3   6009905.4204 2119408.7236 37.8000507639755 -122.40984355245001 (37.8000507639755, -122.40984355245)
7946 4639 3 62 500X Columbus Ave 6 11 1 2     75 3   6009873.723999999 2119435.9713 37.8001238030697 -122.40995515916201 (37.8001238030697, -122.409955159162)
7649 4666 3 62 600X Columbus Ave 1 11 1 2   10/03/2012 12:00:00 AM 60 3 Permit Number 769286 6009738.4106 2119565.7843 37.8004726529456 -122.41043256902 (37.8004726529456, -122.41043256902)
6589 4667 3 62 600X Columbus Ave 2 11 1 2   10/03/2012 12:00:00 AM 12 3 Permit Number 769286 6009690.8519 2119608.7257 37.80058789320879 -122.410600176031 (37.8005878932088, -122.410600176031)
6297 4668 3 62 600X Columbus Ave 3 11 1 2     60 3   6009590.6555 2119701.3035 37.8008364710267 -122.41095344028601 (37.8008364710267, -122.410953440286)
1597 4669 3 62 600X Columbus Ave 4 11 1 2   06/25/2014 12:00:00 AM 8 3 Permit Number 769286 6009537.0943 2119751.1708 37.8009703907309 -122.411142309711 (37.8009703907309, -122.411142309711)
85181 4670 3 62 610X Columbus Ave 5 11 1 2   02/13/2003 12:00:00 AM 12 3   6009783.7006387 2119558.1544154 37.800454241984404 -122.41027530758998 (37.8004542419844, -122.41027530759)
5830 4674 3 62 700X Columbus Ave 1 11 1 2   09/05/1991 12:00:00 AM 15 3x4   6009400.8826 2119872.8379 37.8012968187356 -122.411622263241 (37.8012968187356, -122.411622263241)
82870 4675 3 62 700X Columbus Ave 2 11 1 2   04/06/2013 12:00:00 AM 3 3x3   6009477.5527626 2119836.3917306997 37.8012010470299 -122.41135437342 (37.8012010470299, -122.41135437342)
8177 4676 3 62 700X Columbus Ave 3 11 1 2     24 3x4   6009334.3928 2119933.7869 37.8014604396574 -122.411856657471 (37.8014604396574, -122.411856657471)
9026 4677 3 62 700X Columbus Ave 4 11 1 2     24 3x3   6009299.7627 2119967.4935 37.8015510467699 -122.411978876948 (37.8015510467699, -122.411978876948)
5646 4679 3 62 700X Columbus Ave 6 11 1 2   08/19/2006 12:00:00 AM 6 3x3   6009212.7257 2120043.2180000003 37.801754083871295 -122.412285420728 (37.8017540838713, -122.412285420728)
6099 4714 3 62 1000X Columbus Ave 1 11 1 2     80 3   6008373.9156 2120808.2881 37.8038076701269 -122.415242289828 (37.8038076701269, -122.415242289828)
8454 4715 3 62 1000X Columbus Ave 2 11 1 2   08/19/2006 12:00:00 AM 6 3   6008330.3273 2120843.4941 37.803901887177204 -122.415395624015 (37.8039018871772, -122.415395624015)
5299 4716 3 62 1000X Columbus Ave 3 11 1 2     70 3   6008306.8566 2120868.0824 37.803968081269204 -122.415478587922 (37.8039680812692, -122.415478587922)
6383 4717 3 62 1000X Columbus Ave 4 11 1 2   08/19/2006 12:00:00 AM 6 3   6008242.0329 2120925.0825 37.804120945419 -122.415706953629 (37.804120945419, -122.415706953629)
1851 4718 3 62 1000X Columbus Ave 5 11 1 2     80 3   6008205.1504 2120957.4944 37.804207866952204 -122.415836885075 (37.8042078669522, -122.415836885075)
124851 4719 3 62 1000X Columbus Ave 6 11 1 2     70 3   6008486.129587 2120728.7244 37.803595514004 -122.41484833114401 (37.803595514004, -122.414848331144)
7655 4730 3 62 1175X Columbus Ave 1 11 1 2     100 3x3   6007911.57425 2121225.41132 37.8049269905411 -122.41687182377 (37.8049269905411, -122.41687182377)
1594 4731 3 62 1175X Columbus Ave 2 11 1 2     14 3x3   6007886.219880001 2121257.05551 37.8050124513131 -122.416961809043 (37.8050124513131, -122.416961809043)
8587 4732 3 62 1100X Columbus Ave 3 11 1 2     14 3x3   6008014.3541 2121137.2157 37.8046906082857 -122.41650989053801 (37.8046906082857, -122.416509890538)
8565 4733 3 62 1100X Columbus Ave 4 11 1 2     20 3x3   6007980.3619 2121165.8966 37.80476744709579 -122.416629557244 (37.8047674470958, -122.416629557244)
7054 4734 3 62 1100X Columbus Ave 5 11 1 2     60 3x3   6007950.0877 2121194.0464 37.80484303663339 -122.416736319981 (37.8048430366334, -122.416736319981)
87462 4736 3 62 1100X Columbus Ave 7 11 1 2     60 3x3   6008154.5819477 2121037.0963081 37.804423590750396 -122.41601752221001 (37.8044235907504, -122.41601752221)
92762 9859 1 62 1350X Gough St 1 1 1 1     12 4X4   6005510.31895 2114302.95438 37.785784315765206 -122.424688888506 (37.7857843157652, -122.424688888506)
80190 9860 1 62 1350X Gough St 2 1 1 1     6 4X4   6005510.31895 2114302.95438 37.785784315765206 -122.424688888506 (37.7857843157652, -122.424688888506)
80526 9862 1 62 1350X Gough St 4 1 1 1     6 4X4   6005510.31895 2114302.95438 37.785784315765206 -122.424688888506 (37.7857843157652, -122.424688888506)
123013 10137 3 62 900 Guerrero St 3 1 1 2     3 4x4   6005656.6056289 2103722.2710656 37.7567405635363 -122.423430312617 (37.7567405635363, -122.423430312617)
18117 11765 3 62 800X Junipero Serra Blvd 3 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991272.34511 2091581.45548 37.7225826231682 -122.47229087392 (37.7225826231682, -122.47229087392)
20128 11766 3 62 800X Junipero Serra Blvd 4 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991273.54078 2091606.60865 37.72265175674929 -122.47228857348101 (37.7226517567493, -122.472288573481)
21942 11767 3 62 800X Junipero Serra Blvd 5 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991276.05264 2091631.0711599998 37.7227190701221 -122.472281672976 (37.7227190701221, -122.472281672976)
88746 11784 3 62 810X Junipero Serra Blvd 16 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991252.992504 2092079.9575241 37.7239502662313 -122.472394094235 (37.7239502662313, -122.472394094235)
81460 12262 1 62 630 Laguna St 1 1 1 1     12 3X3   6005027.40572 2111152.82001 37.7771075385512 -122.426135290831 (37.7771075385512, -122.426135290831)
127535 12849 3 62 2412 Lake St 1 1 1 2   02/02/2010 12:00:00 AM 12 3X3   5987958.93678 2114680.36581 37.7858136848869 -122.48543867329501 (37.7858136848869, -122.485438673295)
122592 12943 3 62 725X Dolores St 3 1 1 2     90     6005046.7981655 2104134.69405 37.7578385432445 -122.425568603003 (37.7578385432445, -122.425568603003)
7156 13002 3 62 359 Lombard St 1 1 1 2   08/23/1995 12:00:00 AM 8 3X3   6010611.1408 2120633.1017 37.8034521300977 -122.40748784681101 (37.8034521300977, -122.407487846811)
14635 15136 1 62 766 Mission St 1 1 1 1   07/04/2008 12:00:00 AM 3 3x3   6011623.78991 2113963.56505 37.7851958099766 -122.40351399557699 (37.7851958099766, -122.403513995577)
103617 15137 3 62 780X Mission St 1 1 1 2     12 3x3   6011914.84635 2114325.58433 37.7862060830296 -122.40253249015801 (37.7862060830296, -122.402532490158)
2178 18161 1 62 1450 Post St 1 1 1 1     6 4X4   6005286.1585 2114461.6714 37.7862074506483 -122.425475720608 (37.7862074506483, -122.425475720608)
5713 18162 1 62 1450 Post St 2 1 1 1     6 4X4   6005249.8968 2114455.0784 37.7861872990315 -122.425600707285 (37.7861872990315, -122.425600707285)
4082 18163 1 62 1450 Post St 3 1 1 1     6 4X4   6005210.3387 2114450.1336 37.7861714865556 -122.425737215933 (37.7861714865556, -122.425737215933)
8468 18164 1 62 1450 Post St 4 1 1 1     12 4X4   6005185.0654 2114447.3865 37.78616251551679 -122.42582445934299 (37.7861625155168, -122.425824459343)
Powered by Datasette · Query took 7.691ms · Data source: data.sfgov.org