trees

Custom SQL query returning 52 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
26011 100148 8 17 209 Vicksburg St   Back Yard : Yard Tree 2           6004141 2102142 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
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
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
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
39751 96590 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
44908 96593 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
63210 96591 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
81530 96594 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
94159 97024 8 50 1455 Alabama St   Sidewalk: Curb side : Cutout Tree 2   08/16/2011 12:00:00 AM     Permit Number 768189 6009349 2100759.5 37.7488131674601 -122.410451409671 (37.7488131674601, -122.410451409671) 2 4 7 28859 19
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
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
122314 97023 8 50 1443 Alabama St   Sidewalk: Curb side : Cutout Tree 2   08/16/2011 12:00:00 AM     Permit Number 768190 6009347.4 2100788.9 37.7488938036461 -122.410459018192 (37.7488938036461, -122.410459018192) 2 4 7 28859 19
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
145479 96592 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
149268 106458 8 17 71 HANCOCK ST   Back Yard : Yard Tree 2           6003861.6 2105050 37.7602847161222 -122.429732794413 (37.7602847161222, -122.429732794413) 2 4 5 28862 3
156111 96589 8 8 450 Church St   Sidewalk: Property side : Cutout Tree 4 FUF         6004088.8 2106523.6 37.7643437320395 -122.429052084094 (37.7643437320395, -122.429052084094) 8 4 5 28862 3
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
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
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
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
32266 108871 8 17 99x OAKWOOD ST 1 Back Yard : Yard Tree 2           6005305 2104962 37.7601247169433 -122.424734485609 (37.7601247169433, -122.424734485609) 2 4 5 28859 19
57789 121199 8 41 72 Fountain St 1 Back Yard : Yard Tree 2           6000322 2101283 37.7497403826665 -122.441704227556 (37.7497403826665, -122.441704227556) 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
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
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
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
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
122810 251512 8 60 4116x 18th St 1 Back Yard : Yard Tree 3       3x3   6002190 2105341 37.7609889340227 -122.43553488468 (37.7609889340227, -122.43553488468) 15 4 5 28862 3
142995 108574 8 17 1891 15th St 1 Back Yard : Yard Tree 2       7x8   6004884.86016 2107160.44126 37.7661373754728 -122.426344078904 (37.7661373754728, -122.426344078904) 8 4 5 28853 19
158127 104008 8 15 357 Collingwood St 1 Back Yard : Yard Tree 2     36     6002124 2103789 37.7567237682266 -122.435652112093 (37.7567237682266, -122.435652112093) 2 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
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
154580 224422 8 38 3255x 24th St 2 Front Yard : Cutout Tree 3     16 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
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
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
141413 224714 8 38 3255x 24th St 3 Front Yard : Cutout Tree 3     11 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
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
68467 224715 8 38 3255x 24th St 4 Front Yard : Cutout Tree 3     12 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
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
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
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
42570 224716 8 38 3255x 24th St 5 Front Yard : Cutout Tree 3     13 Width 3ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
99978 234895 8 59 3255x 24th St 6 Side Yard : Cutout Tree 2     40 Width 10ft   6007298 2102020 37.7521590216883 -122.417633107694 (37.7521590216883, -122.417633107694) 2 4 7 28859 19
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
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