sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3168 33093 1 15   9 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
4009 34002 1 15   1 1 1 1         Permit Number 37940          
4171 39901 1 15   3 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
5912 35691 1 15   1 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
6766 33092 1 15   8 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7580 33091 1 15   2 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7627 33085 1 15   10 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
7750 33087 1 15   6 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
8822 36564 1 15   1 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
10191 35689 1 15   12 1 1 1   04/10/1998 12:00:00 AM     Permit Number 38993          
10366 46719 1 15   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
10578 39903 1 15   1 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
10962 33089 1 15   4 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
11036 36559 1 15   8 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
11116 34003 1 15   2 1 1 1         Permit Number 37940          
12200 46197 1 15   2 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
12311 39902 1 15   2 1 1 1   01/03/2002 12:00:00 AM     Permit Number 41185          
12475 36562 1 15   3 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
13380 36560 1 15   7 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
13386 46196 1 15   3 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
13673 33088 1 15   5 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14741 33082 1 15   7 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
14773 46721 1 15   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
15188 34004 1 15   3 1 1 1         Permit Number 37940          
15368 33086 1 15   1 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
15698 46198 1 15   1 1 1 1   12/31/2001 12:00:00 AM     Permit Number 44518          
15858 33090 1 15   3 1 1 1   11/05/1996 12:00:00 AM     Permit Number 37336          
16147 36565 1 15   6 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16437 36563 1 15   2 1 1 1   05/19/1998 12:00:00 AM     Permit Number 39428          
16615 46720 1 15   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
81010 34857 1 15   7 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
86858 34858 1 15   4 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
89396 34859 1 15   1 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
90532 34860 1 15   5 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
103571 34855 1 15   3 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
113996 34861 1 15   2 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
127906 34856 1 15   6 1 1 1         Permit Number 38478 6007910.36416897 2111288.85125958 37.777643571368706 -122.41617183970699 (37.7776435713687, -122.416171839707)
24035 178607 2 15 0 Gonzalez Dr 1 2 1 1     2     5990327.66617 2089955.55198 37.7180635775375 -122.47543773036101 (37.7180635775375, -122.475437730361)
63730 178606 2 15 0 Gonzalez Dr 3 2 1 1     2     5989765.07873 2089203.5232 37.715966065363205 -122.47732740025499 (37.7159660653632, -122.477327400255)
146394 178605 2 15 0 Gonzalez Dr 6 2 1 1     2     5988508.8443599995 2089780.72483 37.71747794624039 -122.48171173733299 (37.7174779462404, -122.481711737333)
148106 178604 2 15 0 Gonzalez Dr 1 2 1 1     2     5988124.07873 2089803.3530000001 37.7175176953569 -122.48304333649999 (37.7175176953569, -122.4830433365)
35905 195913 2 15 1 Ardath Ct 18 1 1 1     3 Width 3ft   6017397.96951 2095379.8404599999 37.7344896488605 -122.382243605578 (37.7344896488605, -122.382243605578)
47367 195914 2 15 1 Ardath Ct 19 1 1 1     3 Width 3ft   6017370.42366 2095423.7832799999 37.7346087856535 -122.382341897873 (37.7346087856535, -122.382341897873)
47956 195906 2 15 1 Ardath Ct 9 1 1 1     5 Width 3ft   6017536.5163900005 2095200.72855 37.734005494361895 -122.381752144972 (37.7340054943619, -122.381752144972)
56264 195915 2 15 1 Ardath Ct 20 1 1 1     4 Width 3ft   6017365.99395 2095418.6411400002 37.7345944216785 -122.382356855387 (37.7345944216785, -122.382356855387)
60850 195910 2 15 1 Ardath Ct 15 1 1 1     7 Width 3ft   6017434.18901 2095336.95373 37.734373890838 -122.38211539910499 (37.734373890838, -122.382115399105)
62718 195916 2 15 1 Ardath Ct 23 1 1 1     3 Width 3ft   6017317.30726 2095456.23934 37.734694969487 -122.382527798526 (37.734694969487, -122.382527798526)
75761 195904 2 15 1 Ardath Ct 5 1 1 1     5 Width 3ft   6017314.87785 2095412.28408 37.7345741428666 -122.382533140509 (37.7345741428666, -122.382533140509)
115835 195911 2 15 1 Ardath Ct 16 1 1 1     3 Width 3ft   6017428.56702 2095333.9897 37.7343654417004 -122.382134630227 (37.7343654417004, -122.382134630227)
125312 195917 2 15 1 Ardath Ct 24 1 1 1     4 Width 3ft   6017301.45491 2095451.6349 37.734681450894705 -122.382582285768 (37.7346814508947, -122.382582285768)
136950 195918 2 15 1 Ardath Ct 25 1 1 1     4 Width 3ft   6017279.62246 2095456.9975299998 37.7346949695032 -122.382658141758 (37.7346949695032, -122.382658141758)
148682 195912 2 15 1 Ardath Ct 17 1 1 1     5 Width 3ft   6017403.30116 2095383.73362 37.7345006331863 -122.382225442864 (37.7345006331863, -122.382225442864)
149855 195901 2 15 1 Ardath Ct 2 1 1 1     6 Width 3ft   6017261.3966 2095426.5921599998 37.7346104754941 -122.38271904027599 (37.7346104754941, -122.382719040276)
150878 195909 2 15 1 Ardath Ct 12 1 1 1     6 Width 3ft   6017488.13797 2095238.32055 37.7341060430571 -122.38192201971 (37.7341060430571, -122.38192201971)
156048 195905 2 15 1 Ardath Ct 7 1 1 1     4 Width 3ft   6017408.623790001 2095295.0022200001 37.7342572883311 -122.382200869793 (37.7342572883311, -122.382200869793)
158074 195903 2 15 1 Ardath Ct 4 1 1 1     5 Width 3ft   6017292.8048 2095421.03653 37.7345969559879 -122.38261006402 (37.7345969559879, -122.38261006402)
170411 195908 2 15 1 Ardath Ct 11 1 1 1     3 Width 3ft   6017495.96555 2095243.39437 37.734120407024704 -122.38189530983699 (37.7341204070247, -122.381895309837)
177087 195907 2 15 1 Ardath Ct 10 1 1 1     4 Width 3ft   6017530.876630001 2095227.61395 37.7340790049315 -122.381773512858 (37.7340790049315, -122.381773512858)
184843 195902 2 15 1 Ardath Ct 3 1 1 1     7 Width 3ft   6017277.44673 2095425.6538 37.734608785648206 -122.382663483745 (37.7346087856482, -122.382663483745)
77230 235587 2 15 1 Capp St 1 1 1 1     22 Width 3ft   6007111.06981 2107271.06482 37.76656670991979 -122.41865188518 (37.7665667099198, -122.41865188518)
50779 134383 2 15 1 Cedar St 1 1 1 1     13 Width 4ft   6007352.8337199995 2114556.88578 37.7865854379092 -122.41833230212099 (37.7865854379092, -122.418332302121)
13586 12949 3 15 1 Lindsay Cir 1 1 1 2     6 3X3   6016403.18992 2095651.77267 37.7351813255446 -122.38570186665501 (37.7351813255446, -122.385701866655)
43171 105076 2 15 1 MATEO ST 1 1 1 1     22 3x3   6003644.6 2096720.9 37.7374026627639 -122.42988917159799 (37.7374026627639, -122.429889171598)
13384 13425 3 15 1 Market St 9 1 1 2   02/10/2007 12:00:00 AM 25 4x4   6014152.78687 2117194.5214299997 37.7942082021958 -122.39499075902599 (37.7942082021958, -122.394990759026)
13475 13427 3 15 1 Market St 11 1 1 2     30 4x4   6014172.84776 2117212.91542 37.7942598232708 -122.394922634488 (37.7942598232708, -122.394922634488)
13620 13426 3 15 1 Market St 10 1 1 2   10/29/2003 12:00:00 AM 8 4x4   6014161.01916 2117188.17749 37.7941912409866 -122.394961829643 (37.7941912409866, -122.394961829643)
14334 13428 3 15 1 Market St 12 1 1 2   10/29/2003 12:00:00 AM 6 4x4   6014180.24954 2117205.51401 37.7942399123011 -122.394896504683 (37.7942399123011, -122.394896504683)
14650 13430 3 15 1 Market St 14 1 1 2     20 4x4   6014204.722019999 2117228.6530400002 37.7943048073789 -122.394813447799 (37.7943048073789, -122.394813447799)
14759 13420 3 15 1 Market St 4 1 1 2   05/18/1991 12:00:00 AM 30 4x4   6014066.39965 2117110.5956099997 37.7939729575322 -122.395283788713 (37.7939729575322, -122.395283788713)
15013 13423 3 15 1 Market St 7 1 1 2   12/12/2002 12:00:00 AM 20 4x4   6014116.98151 2117144.48589 37.7940688252683 -122.39511114407699 (37.7940688252683, -122.395111144077)
15024 13424 3 15 1 Market St 8 1 1 2   01/02/2003 12:00:00 AM 20 4x4   6014140.16579 2117170.60528 37.7941418322359 -122.395032753763 (37.7941418322359, -122.395032753763)
15548 13429 3 15 1 Market St 13 1 1 2     25 4x4   6014197.04513 2117235.7914400003 37.7943239809064 -122.39484051109501 (37.7943239809064, -122.394840511095)
15704 13419 3 15 1 Market St 3 1 1 2   09/10/1991 12:00:00 AM 20 4x4   6014048.53109 2117080.6085599996 37.7938896263516 -122.395343514492 (37.7938896263516, -122.395343514492)
15964 13422 3 15 1 Market St 6 1 1 2   02/10/2007 12:00:00 AM 3 4x4   6014092.01898 2117123.77404 37.7940105671925 -122.39519606616999 (37.7940105671925, -122.39519606617)
16385 27316 3 15 1 Market St 1 1 1 2     35 4x4   6014028.45913 2117061.6774 37.7938365294714 -122.39541163905199 (37.7938365294714, -122.395411639052)
16449 13418 3 15 1 Market St 2 1 1 2     40 4x4   6014042.20206 2117087.71971 37.7939087999011 -122.395365912104 (37.7939087999011, -122.395365912104)
16600 13421 3 15 1 Market St 5 1 1 2   01/02/1991 12:00:00 AM 30 4x4   6014072.44813 2117102.953 37.793952309100206 -122.395262324595 (37.7939523091002, -122.395262324595)
179006 238635 2 15 1 Mateo St 1 1 1 1     21 Width 4ft   6003627.19927 2096721.571 37.7374035197462 -122.429949381872 (37.7374035197462, -122.429949381872)
70378 133453 2 15 1 Presidio Ave 2 1 1 1     8 Width 3ft   5998880.22963 2116633.28355 37.79180610312579 -122.44779486036 (37.7918061031258, -122.44779486036)
149655 133452 2 15 1 Presidio Ave 1 1 1 1     8 Width 3ft   5998879.78479 2116645.46463 37.791839523718 -122.44779727682301 (37.791839523718, -122.447797276823)
179370 238646 2 15 1 Roanoke St 1 1 1 1     10 Width 3ft   6003249.79131 2096430.02106 37.736581609537 -122.43123345187401 (37.736581609537, -122.431233451874)
63754 250007 2 15 1 Starr King Way 2 4 1 1     18 Width 3ft   6005970.87651 2113821.19628 37.784487527310795 -122.423061232398 (37.7844875273108, -122.423061232398)
169165 250006 2 15 1 Starr King Way 1 4 1 1     11 Width 3ft   6005940.10765 2113829.6095 37.784508891608 -122.423168280499 (37.784508891608, -122.423168280499)
30194 234648 2 15 10 Ford St 1 1 1 1     14 Width 3ft   6003406.84007 2105674.0833799997 37.761972537618604 -122.431350145198 (37.7619725376186, -122.431350145198)
23718 195634 2 15 10 King St 3 1 1 1     9 Width 4ft   6015922.53539 2112520.9791099997 37.7814739683895 -122.388540802429 (37.7814739683895, -122.388540802429)
29798 195642 2 15 10 King St 11 1 1 1     10 Width 4ft   6015873.18226 2112320.09829 37.7809196595661 -122.388697514702 (37.7809196595661, -122.388697514702)
42669 195637 2 15 10 King St 6 1 1 1     9 Width 4ft   6015914.47489 2112443.6683400003 37.781261243656296 -122.388563289988 (37.7812612436563, -122.388563289988)
43502 195640 2 15 10 King St 9 1 1 1     9 Width 4ft   6015892.82601 2112367.4405 37.7810507393377 -122.38863286241998 (37.7810507393377, -122.38863286242)
45064 195644 2 15 10 King St 13 1 1 1     11 Width 4ft   6015847.2765 2112274.5008099996 37.7807930233285 -122.38878395211799 (37.7807930233285, -122.388783952118)
49801 195645 2 15 10 King St 14 1 1 1     12 Width 4ft   6015833.63304 2112252.7275900003 37.7807324827572 -122.38882963140101 (37.7807324827572, -122.388829631401)
51639 195632 2 15 10 King St 1 1 1 1     10 Width 4ft   6015928.19981 2112561.72047 37.7815861489313 -122.388524050751 (37.7815861489313, -122.388524050751)
75144 195643 2 15 10 King St 12 1 1 1     11 Width 4ft   6015861.55733 2112297.6774 37.7808574525459 -122.388736165764 (37.7808574525459, -122.388736165764)
75905 195641 2 15 10 King St 10 1 1 1     11 Width 4ft   6015884.8235 2112343.32817 37.7809840887822 -122.388658863641 (37.7809840887822, -122.388658863641)
77086 195646 2 15 10 King St 15 1 1 1     9 Width 4ft   6015816.94411 2112231.01553 37.7806719412978 -122.38888585071699 (37.7806719412978, -122.388885850717)
135257 195639 2 15 10 King St 8 1 1 1     10 Width 4ft   6015901.23898 2112391.74663 37.7811179447654 -122.388605454684 (37.7811179447654, -122.388605454684)
147693 195635 2 15 10 King St 4 1 1 1     8 Width 4ft   6015919.251069999 2112489.08509 37.781386212554295 -122.388549937747 (37.7813862125543, -122.388549937747)
150021 195633 2 15 10 King St 2 1 1 1     9 Width 4ft   6015927.61372 2112541.10483 37.7815295105284 -122.388524638927 (37.7815295105284, -122.388524638927)
156723 195636 2 15 10 King St 5 1 1 1     9 Width 4ft   6015918.13161 2112463.82242 37.7813167848887 -122.388552046646 (37.7813167848887, -122.388552046646)
175749 195638 2 15 10 King St 7 1 1 1     9 Width 4ft   6015907.59674 2112414.88075 37.781181818212794 -122.388585075135 (37.7811818182128, -122.388585075135)
58215 238639 2 15 10 Mateo St 1 1 1 1     23 Width 4ft   6003641.796019999 2096645.51755 37.7371955209567 -122.429893490793 (37.7371955209567, -122.429893490793)
164325 52073 1 15 10 Normandie Ter 1 1 1 1   10/11/2005 12:00:00 AM 5   Permit Number 48268 6000955.032430001 2117341.04068 37.793867787207496 -122.4406668518 (37.7938677872075, -122.4406668518)
Powered by Datasette · Query took 63.366ms · Data source: data.sfgov.org