trees

Custom SQL query returning 101 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
50874 225889 8 474 3255x 24th St 7 Back Yard : Cutout Tree 3     18 Width 8ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
111666 225888 8 474 3255x 24th St 1 Front Yard : Cutout Tree 3     32 6x6   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
87602 253142 8 429 735 29th Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
163643 253143 8 429 735 29th Ave 2 Sidewalk: Property side : Cutout Tree 2       3x3   5986898 2110914 37.7754104499772 -122.488832209773 (37.7754104499772, -122.488832209773) 11 6 2 55 26
53937 94690 8 348 749 Congo St   Front Yard : Yard Tree 2   10/28/2010 12:00:00 AM     Permit Number 53820 6000274 2096023 37.735294937499 -122.441492809367 (37.735294937499, -122.441492809367) 9 7 4 63 40
10460 258772 8 337 20 Crestline Dr 1 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   5999139 2101332 37.7498074496931 -122.445798597569 (37.7498074496931, -122.445798597569) 2 5 5 63 38
9214 264784 8 330 67 Rosenkranz St 3 Side Yard : Yard Tree 1       3x3   6009267 2098344 37.7421761391661 -122.410564417702 (37.7421761391661, -122.410564417702) 10 7 7 28859 2
148738 252848 8 330 99 Reposa Way 1 Back Yard : Yard Tree 2       3x3   5998022 2098104 37.7408803073177 -122.44942865965 (37.7408803073177, -122.44942865965) 9 7 4 59 40
40665 97022 8 326 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
71527 97029 8 320 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
8082 96598 8 317 325 Sanchez St   Sidewalk: Property side : Cutout tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
19875 96597 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
21821 97236 8 317 125 Excelsior Ave   Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM     Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
33788 96601 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
35006 96602 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
53202 102251 8 317 125X Powhattan Ave 4 Front Yard : Yard Tree 2   01/07/2013 12:00:00 AM     Permit Number 768486 6007606 2098071 37.7413332800665 -122.416288322592 (37.7413332800665, -122.416288322592) 2 7 7 28859 2
120469 96606 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
136541 96599 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
138264 96604 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
142618 96600 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
184992 96603 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
186894 96605 8 317 325 Sanchez St   Sidewalk: Property side : Cutout Tree 4 FUF         6003898 2106263.7 37.7636193068731 -122.429693469686 (37.7636193068731, -122.429693469686) 8 4 5 28862 3
105239 110843 8 285 2037 TURK BLVD   Front Yard : Yard Tree 2     15     6000252 2111948 37.7790198360362 -122.442711981138 (37.7790198360362, -122.442711981138) 15 5 11 29490 16
117341 104397 8 285 350 Collingwood St 1 Front Yard : Yard Tree 2           6002086 2103822 37.7568122198273 -122.435785890783 (37.7568122198273, -122.435785890783) 2 4 5 28862 3
101831 120995 8 284 231 Delano Ave 1 Front Yard : Yard Landscaping 2       3x3   6000066 2092260 37.7249507611268 -122.44194193564 (37.7249507611268, -122.44194193564) 9 7 6 28861 25
137283 109242 8 284 2479 DIAMOND ST   Sidewalk: Curb side : Yard Landscaping 2           6002238.1 2097343.7 37.7390329760373 -122.434796615916 (37.7390329760373, -122.434796615916) 2 7 5 63 7
145213 256660 8 284 40X Miguel St 1 Back Yard : Yard Landscaping 2       3x3   6003624 2097154 37.7385906898162 -122.429991281012 (37.7385906898162, -122.429991281012) 2 7 5 63 7
39203 97052 8 281 795 Wisconsin St   Sidewalk: Property side : Yard Tree 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
103546 113379 8 272 140 CASTENADA AVE 1 Front Yard : Yard Tree 2     50     5994437 2101097 37.7488926059174 -122.462041158848 (37.7488926059174, -122.462041158848) 1 8 4 29491 40
120621 101625 8 272 64 Levant St 1 Front Yard : Cutout Tree 2         Permit Number 769362 6000275.9 2106473.5 37.7639895997076 -122.442236202383 (37.7639895997076, -122.442236202383) 15 5 5 28862 3
71797 256101 8 262 1255 Oak St 1 Back Yard : Cutout Tree 2       3x3   6001013 2109627 37.7726903083913 -122.439912920243 (37.7726903083913, -122.439912920243) 15 5 11 29492 9
90477 109091 8 250 4235 23rd St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
104074 97028 8 246 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
41321 97014 8 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
44692 97015 8 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
92080 97016 8 245 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
116957 97032 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
175634 97037 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
189767 97036 8 242 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
44517 251117 8 240 2024 Castro St 1 Back Yard : Yard Tree 2           6002622 2099601 37.7452527853239 -122.433630548541 (37.7452527853239, -122.433630548541) 2 7 5 63 22
171323 253471 8 240 17 Valletta Ct 1 Side Yard : Yard Tree 2       6x10   5999337 2096545 37.7366747995559 -122.444769861358 (37.7366747995559, -122.444769861358) 9 7 4 63 40
11932 252833 8 230 98 Prosper St 1 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
13841 252837 8 230 98 Prosper St 5 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
80203 253469 8 230 701 Stanyan St 5 Side Yard : Yard Tree 2           5997178 2108423 37.7691653834469 -122.453091601514 (37.7691653834469, -122.453091601514) 15 5 11 29492 9
103773 252839 8 230 99 Pond St 2 Sidewalk: Property side : Yard Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
136363 252834 8 230 98 Prosper St 2 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
183841 252835 8 230 98 Prosper St 3 Sidewalk: Property side : Cutout Tree 2           6003330 2106021 37.7629207320267 -122.431640673814 (37.7629207320267, -122.431640673814) 15 4 5 28862 3
7179 260247 8 224 568 Huron Ave 1 Sidewalk: Curb side : Cutout Tree 2           5998297.39121 2088148.96817 37.7135618752392 -122.447759972312 (37.7135618752392, -122.447759972312) 9 7 6 28861 25
162706 94228 8 216 1097 Church St   Front Yard : Yard Tree 2   06/25/2010 12:00:00 AM     Permit Number 53567 6004455 2102510 37.7533440588084 -122.427499544702 (37.7533440588084, -122.427499544702) 2 4 5 28862 22
24750 94468 8 204 4128 17th St   Sidewalk: Property side : Pot Tree 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
71699 94469 8 204 4128 17th St   Sidewalk: Property side : Pot Tree 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
104809 94487 8 204 4128 17th St   Sidewalk: Property side : Pot Tree 2         in landscaped area 6001502 2105859 37.7623721357484 -122.437951476108 (37.7623721357484, -122.437951476108) 15 5 5 28862 3
1694 100166 8 203 2340 Twin Peaks Blvd   Front Yard : Yard Tree 2         Permit Number 769026                    
41028 97042 8 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
120723 97043 8 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
175126 97044 8 186 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
9668 264919 8 183 1833 Page St 1 Sidewalk: Property side : Yard Tree 12       3x3   5997789 2108763 37.7701339345343 -122.451002717521 (37.7701339345343, -122.451002717521) 15 5 11 29492 9
35599 97045 8 181 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
2998 261600 8 180 451X Jersey St 1 Back Yard : Yard Tree 12       3x3   6002237 2101405 37.7501842910814 -122.435090813874 (37.7501842910814, -122.435090813874) 2 4 5 28862 22
173830 98139 8 175 556 Laidley St   Back Yard : Yard Tree 2       3x3   6003085 2096041 37.7355041065287 -122.431775438062 (37.7355041065287, -122.431775438062) 2 7 5 63 7
179653 97035 8 173 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
51341 97051 8 172 795 Wisconsin St   Sidewalk: Property side : Yard Tree 2 FUF 08/19/2011 12:00:00 AM     Permit Number 767554 6012787.8 2103832.3 37.7574425906128 -122.398775590174 (37.7574425906128, -122.398775590174) 10 3 8 28856 29
56664 97021 8 172 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1
149518 109194 8 172 4705 03rd St   Back Yard : Yard Tree 19     45     6015121.6 2095617 37.7350148477359 -122.390130397219 (37.7350148477359, -122.390130397219) 10 3 8 58 1
13403 261178 8 160 205 Leland Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6009827 2087549 37.7125667222905 -122.407867055005 (37.7125667222905, -122.407867055005) 9 7 8 309 39
30542 98548 8 155 132 Hamerton Ave 1 Front Yard : Yard Tree 2           6001332.8 2095440.7 37.7337563407686 -122.437790462907 (37.7337563407686, -122.437790462907) 9 7 5 63 40
35596 254587 8 155 1270 24th Ave 1 Back Yard : Cutout Tree 2       3x3   5988678 2106679 37.7638860263594 -122.482364481098 (37.7638860263594, -122.482364481098) 1 8 3 56 35
55834 121404 8 155 1900 08th Ave 1 Back Yard : Yard Tree 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
84644 118371 8 155 4808 25th St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5999981 2101110 37.7492459313263 -122.442870994168 (37.7492459313263, -122.442870994168) 2 4 5 28862 22
105934 99256 8 155 1466 York St   Back Yard : Yard Tree 2           6010099 2100741 37.7488043872035 -122.407856595429 (37.7488043872035, -122.407856595429) 2 4 7 28859 19
170932 102752 8 155 2452 Green St   Back Yard : Yard Tree 2           6001313 2117994 37.7956810212331 -122.43947508164 (37.7956810212331, -122.43947508164) 13 9 1 57 17
107546 112377 8 127 801 ULLOA ST 3 Sidewalk: Curb side : Cutout Tree 3     36     5993401 2098089 37.7405736985828 -122.465405140197 (37.7405736985828, -122.465405140197) 1 8 4 59 40
31670 104539 8 113 1101 Van Ness Ave 2 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
49750 104540 8 113 1101 Van Ness Ave 4 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
52825 104544 8 113 1101 Van Ness Ave 8 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
57437 108624 8 113 101 GENEBERN WAY 1 Front Yard : Yard Tree 2           6005050.2 2095237.8 37.733409902631 -122.424923866144 (37.733409902631, -122.424923866144) 2 7 7 28861 2
86207 104538 8 113 1101 Van Ness Ave 1 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
99497 104543 8 113 1101 Van Ness Ave 7 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
101786 104542 8 113 1101 Van Ness Ave 6 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
139843 108680 8 113 240 SANTA ANA AVE 1 Back Yard : Yard Tree 2           5992606.9 2095181.7 37.7325451527527 -122.46793939449 (37.7325451527527, -122.46793939449) 9 8 4 59 40
181064 104568 8 113 1101 Van Ness Ave 9 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
182344 104541 8 113 1101 Van Ness Ave 5 Front Yard : Yard Tree 2           6006375.5 2114401.9 37.7861048214583 -122.421702631224 (37.7861048214583, -122.421702631224) 13 9 11 28858 41
6335 262305 8 112 100 Saint Elmo Way 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994960 2094889 37.7318770738882 -122.459783023889 (37.7318770738882, -122.459783023889) 9 8 4 59 40
120627 100045 8 111 556 28th St   Front Yard : Yard Tree 2         Not sure which property tree is located on. 6002301 2099461 37.7448501592716 -122.434730501666 (37.7448501592716, -122.434730501666) 2 7 5 63 22
42557 101977 8 109 601 Grand View Ave   Front Yard : Yard Tree 2           6000076.2 2101609.9 37.7506239629918 -122.442577679409 (37.7506239629918, -122.442577679409) 2 4 5 28862 22
28928 116154 8 100 324 POPE ST 1 Back Yard : Yard Tree 2       3x3   6000502 2087202 37.7110874704678 -122.440072212787 (37.7110874704678, -122.440072212787) 9 7 6 28861 5
56024 105231 8 100 460X ROOSEVELT WAY 1 Front Yard : Yard Tree 2     9     6000051 2106345 37.7636239504047 -122.443004833609 (37.7636239504047, -122.443004833609) 15 5 5 29492 3
30353 105684 8 97 635 08TH ST 1 Front Yard : Pot Tree 2     10     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
33251 105685 8 97 635 08TH ST 2 Front Yard : Pot Tree 2     8     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
145638 105686 8 97 635 08TH ST 3 Front Yard : Pot Tree 2     6     6011418.5 2109097.9 37.7718243537934 -122.403881727597 (37.7718243537934, -122.403881727597) 14 2 9 28853 34
172414 256223 8 91 116X Brewster St 1 Sidewalk: Property side : Yard Tree 5       6x6   6010334 2099321 37.7449185312124 -122.406943891675 (37.7449185312124, -122.406943891675) 2 7 7 28859 2
34602 97033 8 89 61 Vicksburg St   Back Yard : Yard Tree 2         Possible significant tree; Nellie RoW; rear yard 6004120 2102703 37.753855038047 -122.428671801406 (37.753855038047, -122.428671801406) 2 4 5 28862 22
66704 107130 8 87 751 DOLORES ST 1 Front Yard : Cutout Tree 2           6005081.8 2103948.4 37.7573290011944 -122.425434294507 (37.7573290011944, -122.425434294507) 2 4 5 28859 19
150502 97162 8 82 478 10th Ave   Back Yard : Yard Tree 2         Tree in backyard on private property; not significant. 5992861.5 2112216.7 37.7793335349967 -122.468298031686 (37.7793335349967, -122.468298031686) 11 6 2 54 11
2474 256556 8 75 3401X 16th St 5 Side Yard : Yard Tree 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
34431 256554 8 75 3401X 16th St 3 Side Yard : Yard Tree 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
90011 256555 8 75 3401X 16th St 4 Side Yard : Yard Tree 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
175776 256557 8 75 3401X 16th St 6 Side Yard : Yard Tree 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176971 256553 8 75 3401X 16th St 2 Side Yard : Yard Tree 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
189291 256552 8 75 3401X 16th St 1 Side Yard : Yard Tree 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
28806 97041 8 73 195B Kiska Rd   Sidewalk: Property side : Cutout Tree 15 FUF         6019164.1 2093438.1 37.7292553954157 -122.376002845114 (37.7292553954157, -122.376002845114) 10 3 8 58 1