sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3132 253339 7 47 2019X 24th Ave 1 9 1 13       3x3   5988853.0 2101569.0 37.7498655183494 -122.481384971136 (37.7498655183494, -122.481384971136)
17977 116827 2 15 111 BAY ST 14 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
78641 116976 2 218 100x CARGO WAY 7 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
79463 116977 2 5 100x CARGO WAY 117 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
83489 116828 2 15 111 BAY ST 15 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
83621 116826 2 15 111 BAY ST 13 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
85395 116822 2 15 111 BAY ST 9 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
92074 116820 2 15 111 BAY ST 7 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
93526 116831 2 15 111 BAY ST 18 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
94354 116825 2 15 111 BAY ST 12 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
99346 116823 2 15 111 BAY ST 10 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
107057 116830 2 15 111 BAY ST 17 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
110974 116818 2 15 111 BAY ST 5 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
111971 116809 2 15 111 BAY ST 1 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
126108 116824 2 15 111 BAY ST 11 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
127145 116817 2 15 111 BAY ST 4 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
139776 116829 2 15 111 BAY ST 16 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
140503 116975 2 218 100x CARGO WAY 6 7 1 13 2         6019010.0 2097405.0 37.7401392444118 -122.376810655394 (37.7401392444118, -122.376810655394)
144844 116816 2 15 111 BAY ST 3 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
144887 116832 2 15 2 Midway St 7 7 1 13           6010125.275107 2121295.55695439 37.8052438606833 -122.409215987298 (37.8052438606833, -122.409215987298)
146001 116815 2 15 111 BAY ST 2 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
9947 11824 1 12 1299X Junipero Serra Blvd 14 2 1 13   03/13/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
2320 1739 1 15 111 Bay St 2 1 1 13   08/19/2006 12:00:00 AM 3     6010211.1306 2121614.8438 37.8061253525476 -122.408941413862 (37.8061253525476, -122.408941413862)
13422 29844 1 21 1700X Evans Ave 10 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014896.13106 2099120.97008 37.74462351995 -122.39115477280001 (37.74462351995, -122.3911547728)
13529 29838 1 21 1700X Evans Ave 5 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014986.46906 2099054.93467 37.7444472132656 -122.39083778516 (37.7444472132656, -122.39083778516)
14328 29834 1 21 1700X Evans Ave 1 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015058.47657 2099001.06615 37.7443032965649 -122.390585032484 (37.7443032965649, -122.390585032484)
15770 29836 1 21 1700X Evans Ave 3 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015024.36841 2099025.2141299997 37.744367709607296 -122.390704659402 (37.7443677096073, -122.390704659402)
15882 29835 1 21 1700X Evans Ave 2 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015037.39009 2099016.77397 37.744345257128295 -122.390659043104 (37.7443452571283, -122.390659043104)
16061 29846 1 21 1700X Evans Ave 11 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014879.93963 2099132.42343 37.7446540699209 -122.391211560464 (37.7446540699209, -122.391211560464)
16509 29837 1 21 1700X Evans Ave 4 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6015003.68842 2099041.04772 37.744410037986704 -122.39077727337099 (37.7444100379867, -122.390777273371)
16702 29840 1 21 1700X Evans Ave 7 1 1 13   09/11/2006 12:00:00 AM 3 4X4   6014944.2776 2099085.41213 37.7445285569526 -122.390985805465 (37.7445285569526, -122.390985805465)
19844 27797 1 60 899X Junipero Serra Blvd 3 1 1 13   03/17/2001 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
77637 11714 1 12 899X Junipero Serra Blvd 1 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
79410 24459 1 12 1199X Junipero Serra Blvd 3 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
79858 87631 1 12 900X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
79921 1719 1 15 50X Bay St 1 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
81955 87698 1 12 799X Junipero Serra Blvd 4 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
82768 87696 1 12 699X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991401.754733999 2093132.8495200002 37.726849855022394 -122.471956555148 (37.7268498550224, -122.471956555148)
83233 28848 1 60 899X Junipero Serra Blvd 15 1 1 13   03/08/2005 12:00:00 AM 3 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
86548 24457 1 12 999X Junipero Serra Blvd 13 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
86590 87630 1 12 900X Junipero Serra Blvd 2 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
87918 87702 1 12 799X Junipero Serra Blvd 28 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
89108 27799 1 60 899X Junipero Serra Blvd 23 1 1 13   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
89131 11698 1 12 799X Junipero Serra Blvd 19 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
90644 87708 1 12 999X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
92092 24393 1 12 699X Junipero Serra Blvd 6 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
94232 87707 1 12 999X Junipero Serra Blvd 5 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
94360 24461 1 12 1199X Junipero Serra Blvd 7 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
95006 87704 1 12 899X Junipero Serra Blvd 10 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
96617 1732 1 15 50X Bay St 14 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
96704 87703 1 12 899X Junipero Serra Blvd 6 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
97337 87706 1 12 999X Junipero Serra Blvd 2 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
98322 87710 1 12 999X Junipero Serra Blvd 12 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
100974 87629 1 12 900X Junipero Serra Blvd 1 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
101722 24397 1 12 699X Junipero Serra Blvd 17 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
101927 11761 1 12 999X Junipero Serra Blvd 3 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991260.9047733005 2090529.2081036 37.719692749400394 -122.47225375374799 (37.7196927494004, -122.472253753748)
101990 87697 1 12 699X Junipero Serra Blvd 12 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991401.754733999 2093132.8495200002 37.726849855022394 -122.471956555148 (37.7268498550224, -122.471956555148)
104270 75029 2 80 141X Arleta Ave 1 1 1 13 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104340 74892 2 80 141X Arleta Ave 2 1 1 13 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104595 87713 1 12 1199X Junipero Serra Blvd 11 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991170.4069529995 2089609.549246 37.717162354271395 -122.47249955747499 (37.7171623542714, -122.472499557475)
109059 11648 1 60 699X Junipero Serra Blvd 3 1 1 13   01/28/2000 12:00:00 AM 3 3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
110010 87700 1 12 799X Junipero Serra Blvd 25 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
117628 27826 1 60 799X Junipero Serra Blvd 26 1 1 13   03/08/2005 12:00:00 AM 3 3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
118719 87632 1 12 900X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991221.225523001 2091214.4658080002 37.7215720016004 -122.472440839907 (37.7215720016004, -122.472440839907)
118758 1733 1 15 50X Bay St 15 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
124387 24396 1 12 699X Junipero Serra Blvd 14 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
124401 1735 1 15 50X Bay St 17 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
124553 87699 1 12 799X Junipero Serra Blvd 14 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991351.334229 2092039.32129 37.7238443805247 -122.472051185335 (37.7238443805247, -122.472051185335)
125010 24410 1 12 1199X Junipero Serra Blvd 4 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
125164 1721 1 15 50X Bay St 3 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
125710 85667 1 254 639 Bryant St 3 1 1 13   04/23/2007 12:00:00 AM 3 3x3   6012912.0 2111624.0 37.77884377468779 -122.39889289846501 (37.7788437746878, -122.398892898465)
125729 24394 1 12 699X Junipero Serra Blvd 11 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
128386 87705 1 12 899X Junipero Serra Blvd 19 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991284.231533 2091244.7238979999 37.7216587293859 -122.472225251777 (37.7216587293859, -122.472225251777)
128581 11651 1 12 699X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991405.981861901 2093130.1790735 37.7268427672434 -122.47194174766199 (37.7268427672434, -122.471941747662)
138768 87709 1 12 999X Junipero Serra Blvd 8 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991255.914982 2090529.5269799998 37.719693336177 -122.47227102474 (37.719693336177, -122.47227102474)
139141 11725 1 12 899X Junipero Serra Blvd 20 1 1 13   01/18/2008 12:00:00 AM 3 3x3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
142437 1720 1 15 50X Bay St 2 1 1 13   08/19/2006 12:00:00 AM 3 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
143977 11717 1 60 899X Junipero Serra Blvd 5 1 1 13   03/08/2005 12:00:00 AM 3 3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
18608 24390 1 60 501X Junipero Serra Blvd 6 1 1 13   06/22/1995 12:00:00 AM 6 3   5991485.44871 2094112.7680400002 37.7295453093597 -122.471738611958 (37.7295453093597, -122.471738611958)
77359 12466 1 47 307 Lake Merced Blvd 11 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
79934 12458 1 47 307 Lake Merced Blvd 3 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
81281 12469 1 47 307 Lake Merced Blvd 14 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
83384 17658 1 85 1000X Phelps St 3 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
85296 12456 1 47 307 Lake Merced Blvd 1 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
88676 11697 1 60 799X Junipero Serra Blvd 21 1 1 13   06/21/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
90084 24402 1 60 899X Junipero Serra Blvd 17 1 1 13   03/01/2000 12:00:00 AM 6 3X3   5991288.7107407 2091242.502063 37.7216528879997 -122.47220960661998 (37.7216528879997, -122.47220960662)
93559 12463 1 47 307 Lake Merced Blvd 8 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
96556 24460 1 60 1199X Junipero Serra Blvd 9 1 1 13   06/22/1995 12:00:00 AM 6 3x3   5991174.554565701 2089606.7568954 37.7171549272284 -122.472485017828 (37.7171549272284, -122.472485017828)
100881 12467 1 47 307 Lake Merced Blvd 12 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
101961 12461 1 47 307 Lake Merced Blvd 6 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
102952 1725 1 15 50X Bay St 7 1 1 13   12/15/1992 12:00:00 AM 6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
104025 17656 1 85 1000X Phelps St 1 1 1 13   11/15/1992 12:00:00 AM 6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
104630 11816 1 2 1201X Junipero Serra Blvd 2 1 1 13     6 3X3   5991184.5559808 2089595.7938424998 37.7171254042551 -122.47244964923901 (37.7171254042551, -122.472449649239)
104908 17662 1 85 1000X Phelps St 7 1 1 13     6 3X3   6014635.9682774 2097168.9021451 37.739249105451 -122.391917896407 (37.739249105451, -122.391917896407)
107737 1722 1 15 50X Bay St 4 1 1 13     6 3x9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
108403 12459 1 47 307 Lake Merced Blvd 4 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
109450 24400 1 60 799X Junipero Serra Blvd 22 1 1 13   06/15/1995 12:00:00 AM 6 3x3   5991356.324435 2092039.0089713002 37.7238438117461 -122.472033912425 (37.7238438117461, -122.472033912425)
111079 12465 1 47 307 Lake Merced Blvd 10 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
112155 1731 1 15 50X Bay St 13 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
112223 1724 1 15 50X Bay St 6 1 1 13     6 3X9   6010708.099243 2121736.3211997 37.8064867247361 -122.407230131732 (37.8064867247361, -122.407230131732)
113400 12491 1 47 307 Lake Merced Blvd 36 1 1 13     6 90M   5985224.7663097 2094165.6248746999 37.7293262181041 -122.49338600271003 (37.7293262181041, -122.49338600271)
Powered by Datasette · Query took 4.39ms · Data source: data.sfgov.org