sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3317 253413 2 29 2433 23rd Ave 1 1 1 9 3     3x3   5989193.66308 2098780.80152 37.7422296590049 -122.48000293550501 (37.7422296590049, -122.480002935505)
114637 106120 1 37 849X Cabrillo St 2 1 1 9 3     6x9   5992954.7 2110649.6 37.775036084258794 -122.46786160539301 (37.7750360842588, -122.467861605393)
107477 106680 1 17 2200 LYON ST 2 1 1 9 3 06/24/2014 12:00:00 AM 20 3x3 Permit Number 773028 5999398.2 2116386.7 37.7911586409716 -122.445984946853 (37.7911586409716, -122.445984946853)
119175 108830 1 18 46 Ney St   1 1 9 1     3x3   6003763.1265 2093992.4287599998 37.7299176091889 -122.429284866217 (37.7299176091889, -122.429284866217)
100382 115402 1 229 218 Richland Ave 1 1 1 9   01/29/2016 12:00:00 AM 3   Permit Number 776284 6005779.9 2096086.1 37.7357803359495 -122.42246134044301 (37.7357803359495, -122.422461340443)
100902 27706 1 15 1801 The Embarcadero 1 1 1 9     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)
107973 27707 1 15 1801 The Embarcadero 2 1 1 9     6     6008269.247115 2122709.555122 37.8090221854411 -122.415739206432 (37.8090221854411, -122.415739206432)
50106 28049 1 127 1800 The Embarcadero 5 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
80340 28045 1 127 1800 The Embarcadero 1 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
87468 28050 1 127 1800 The Embarcadero 6 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
88591 28047 1 127 1800 The Embarcadero 3 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
89860 28053 1 127 1800 The Embarcadero 9 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
95965 28046 1 127 1800 The Embarcadero 2 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
112403 28055 1 127 1800 The Embarcadero 11 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
121432 28052 1 127 1800 The Embarcadero 8 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
124163 28048 1 127 1800 The Embarcadero 4 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
143432 28051 1 127 1800 The Embarcadero 7 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
144070 28054 1 127 1800 The Embarcadero 10 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.5553900003 37.808912348093 -122.41573688061001 (37.808912348093, -122.41573688061)
83311 27705 1 15 1501X The Embarcadero 2 1 1 9     6     6010670.1386196995 2122042.3573555 37.807324899499 -122.407383090822 (37.807324899499, -122.407383090822)
94559 27704 1 15 1501X The Embarcadero 1 1 1 9     6     6010670.1386196995 2122042.3573555 37.807324899499 -122.407383090822 (37.807324899499, -122.407383090822)
69372 25749 1 100 1301X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
89841 25748 1 100 1301X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
101776 25752 1 100 1301X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
112942 25754 1 100 1301X The Embarcadero 7 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
117219 25750 1 100 1301X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
141888 25751 1 100 1301X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
146321 25753 1 100 1301X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011423.5148387 2121491.4283584 37.805854321699 -122.40473704035801 (37.805854321699, -122.404737040358)
114566 114692 1 48 391 Girard St 2 1 1 9 3 12/01/2015 12:00:00 AM     Permit Number 774511 6010909.5 2092975.0 37.7275259502006 -122.404507285761 (37.7275259502006, -122.404507285761)
77648 25821 1 15 1300X The Embarcadero 17 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
86828 25818 1 15 1300X The Embarcadero 14 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
91091 25822 1 15 1300X The Embarcadero 18 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
92547 25817 1 15 1300X The Embarcadero 13 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
94071 25815 1 15 1300X The Embarcadero 11 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
104305 25814 1 15 1300X The Embarcadero 10 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
107397 25804 1 100 1300X The Embarcadero 6 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
109799 25803 1 100 1300X The Embarcadero 5 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
112571 25823 1 15 1300X The Embarcadero 19 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
112807 25802 1 100 1300X The Embarcadero 4 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
116959 25819 1 15 1300X The Embarcadero 15 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
116990 25800 1 100 1300X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
125869 25816 1 15 1300X The Embarcadero 12 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
127310 25820 1 15 1300X The Embarcadero 16 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
139560 25824 1 15 1300X The Embarcadero 20 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
140551 25801 1 100 1300X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6011529.7175275 2121574.5346243 37.8060884463757 -122.404375360949 (37.8060884463757, -122.404375360949)
7856 28033 1 15 1500 The Embarcadero 1 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011830.13261 2121113.3124599997 37.80483882640021 -122.403303252939 (37.8048388264002, -122.403303252939)
3878 28034 1 15 1500 The Embarcadero 2 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011851.06099 2121093.24306 37.8047848895665 -122.403229415001 (37.8047848895665, -122.403229415001)
2826 28035 1 15 1500 The Embarcadero 3 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011869.41049 2121075.03017 37.804735906188796 -122.403164632367 (37.8047359061888, -122.403164632367)
8683 28036 1 15 1500 The Embarcadero 4 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011891.7394900005 2121054.53142 37.8046808685929 -122.40308591740101 (37.8046808685929, -122.403085917401)
8279 28037 1 15 1500 The Embarcadero 5 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011908.75369 2121039.95348 37.8046417912539 -122.403026011743 (37.8046417912539, -122.403026011743)
7651 28038 1 15 1500 The Embarcadero 6 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011930.42206 2121019.16916 37.80458593256979 -122.402949563068 (37.8045859325698, -122.402949563068)
19725 114507 2 82 10 LOMBARD ST 2 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
89465 114506 2 22 10 LOMBARD ST 1 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
125405 114508 2 22 10 LOMBARD ST 3 16 1 9       4x4   6011932.0 2120995.0 37.8045196580749 -122.402942401468 (37.8045196580749, -122.402942401468)
4234 28039 1 15 1500 The Embarcadero 7 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011949.43377 2121001.73319 37.8045391192453 -122.402882543817 (37.8045391192453, -122.402882543817)
1123 28040 1 15 1500 The Embarcadero 8 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011973.34792 2120976.9306 37.8044723526732 -122.40279804081499 (37.8044723526732, -122.402798040815)
6942 28041 1 15 1500 The Embarcadero 9 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6011990.996730001 2120961.47906 37.804430911926495 -122.40273587786501 (37.8044309119265, -122.402735877865)
8754 28042 1 15 1500 The Embarcadero 10 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012004.18493 2120947.51548 37.804393307678 -122.4026892561 (37.804393307678, -122.4026892561)
5630 28043 1 15 1500 The Embarcadero 11 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012024.04433 2120930.34171 37.8043472614676 -122.402619322118 (37.8043472614676, -122.402619322118)
7341 28044 1 15 1500 The Embarcadero 12 1 1 9   02/05/2001 12:00:00 AM 12 3X3   6012052.65409 2120901.81041 37.8042705187194 -122.402518307585 (37.8042705187194, -122.402518307585)
81176 27963 1 100 1101X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
105106 25746 1 100 1101X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
111083 25747 1 100 1101X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012183.0853805 2120808.9629681 37.8040228629879 -122.402060405747 (37.8040228629879, -122.402060405747)
4067 25799 1 100 1300X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012220.09673 2120843.1378 37.8041187644177 -122.401934728525 (37.8041187644177, -122.401934728525)
7283 25805 1 15 1300X The Embarcadero 1 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012220.3272400005 2120713.92747 37.803763997176794 -122.401924842279 (37.8037639971768, -122.401924842279)
92956 25834 1 15 1100X The Embarcadero 10 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
94571 25828 1 15 1100X The Embarcadero 4 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
102728 25833 1 15 1100X The Embarcadero 9 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
103830 27697 1 100 1100X The Embarcadero 2 11 1 9     36 10   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
110224 25829 1 15 1100X The Embarcadero 5 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
121837 25825 1 15 1100X The Embarcadero 1 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
125465 25826 1 15 1100X The Embarcadero 2 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
125913 25830 1 15 1100X The Embarcadero 6 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
126784 25835 1 15 1100X The Embarcadero 11 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
128178 25831 1 15 1100X The Embarcadero 7 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
142639 25836 1 15 1100X The Embarcadero 12 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
143685 25832 1 15 1100X The Embarcadero 8 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
145325 25827 1 15 1100X The Embarcadero 3 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012224.999683401 2120852.6389045 37.8041451257683 -122.401918429695 (37.8041451257683, -122.401918429695)
3657 25806 1 15 1300X The Embarcadero 2 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012234.78854 2120695.21971 37.8037134372885 -122.401873481994 (37.8037134372885, -122.401873481994)
5672 25807 1 15 1300X The Embarcadero 3 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012251.480269999 2120666.53325 37.8036356027669 -122.40181370136801 (37.8036356027669, -122.401813701368)
4885 25808 1 15 1300X The Embarcadero 4 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012265.91209 2120646.37252 37.803581051681704 -122.401762341075 (37.8035810516817, -122.401762341075)
127945 25787 1 100 800X The Embarcadero 1 11 1 9   08/30/1996 12:00:00 AM 36 10   6012271.38601 2120709.8440099997 37.803755634424206 -122.401747862284 (37.8037556344242, -122.401747862284)
5815 25809 1 15 1300X The Embarcadero 5 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012278.63673 2120626.00413 37.8035258351232 -122.40171687406 (37.8035258351232, -122.40171687406)
8337 25810 1 15 1300X The Embarcadero 6 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012292.79565 2120604.39505 37.803467291949204 -122.401666356441 (37.8034672919492, -122.401666356441)
3114 25811 1 15 1300X The Embarcadero 7 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012315.257619999 2120560.3270799997 37.8033475454092 -122.401585526252 (37.8033475454092, -122.401585526252)
123015 25788 1 100 800X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6012327.37501 2120629.11501 37.8035370964877 -122.401548430804 (37.8035370964877, -122.401548430804)
76348 27944 1 100 999 The Embarcadero 1 11 1 9     24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
83420 27948 1 100 999 The Embarcadero 5 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
91110 27949 1 100 999 The Embarcadero 6 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
98325 27947 1 100 999 The Embarcadero 4 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
106831 27951 1 100 999 The Embarcadero 8 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
114665 27950 1 100 999 The Embarcadero 7 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
116513 27946 1 100 999 The Embarcadero 3 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
144240 27945 1 100 999 The Embarcadero 2 11 1 9   02/01/2001 12:00:00 AM 24 4X4   6012331.2461069 2120536.8810451 37.8032840604314 -122.401528548359 (37.8032840604314, -122.401528548359)
5784 25812 1 15 1300X The Embarcadero 8 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012332.091990001 2120538.6639799997 37.803289003136 -122.401525746517 (37.803289003136, -122.401525746517)
8734 25813 1 15 1300X The Embarcadero 9 1 1 9   10/15/1995 12:00:00 AM 6 4X4   6012345.50187 2120516.10099 37.8032277988787 -122.401477754221 (37.8032277988787, -122.401477754221)
139789 25846 1 15 800X The Embarcadero 10 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012374.25001 2120498.90601 37.803182189640296 -122.40137706066601 (37.8031821896403, -122.401377060666)
120825 25789 1 100 800X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6012378.15701 2120553.5940099997 37.8033325675946 -122.40136738582899 (37.8033325675946, -122.401367385829)
87777 25847 1 15 800X The Embarcadero 11 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012388.5730099995 2120483.28101 37.803140086302705 -122.401326396519 (37.8031400863027, -122.401326396519)
86353 25848 1 15 800X The Embarcadero 12 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012397.68801 2120467.65601 37.803097692384604 -122.401293754953 (37.8030976923846, -122.401293754953)
108668 25856 1 15 800X The Embarcadero 20 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012409.40701 2120449.4270099998 37.803048293782 -122.401251919072 (37.803048293782, -122.401251919072)
96916 25857 1 15 800X The Embarcadero 21 1 1 9   10/30/1995 12:00:00 AM 6 4X4   6012423.72901 2120427.29201 37.8029883154529 -122.40120080081999 (37.8029883154529, -122.40120080082)
Powered by Datasette · Query took 10.803ms · Data source: data.sfgov.org