trees

Custom SQL query returning 39 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
22364 114870 2 84 2326 Cecelia Ave 2 Sidewalk: Curb side : Cutout Tree 2   12/16/2015 12:00:00 AM 3 3x4   5991484.88147917 2099641.61135178 37.744726077495 -122.472143418263 (37.744726077495, -122.472143418263) 1 8 4 29491 40
26702 117483 2 163 601 PACHECO ST 5 Sidewalk: Property side : Cutout Tree 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
32475 255482 2 13 1559 07th Ave 1 Sidewalk: Curb side : Cutout Tree 2   05/30/2018 12:00:00 AM 3 3x5   5993958 2104895 37.7592933500003 -122.463973185629 (37.7592933500003, -122.463973185629) 1 8 4 56 12
137347 116851 2 9 83 Panorama Dr 3 Front Yard : Yard Tree 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
160718 117479 2 163 601 PACHECO ST 1 Sidewalk: Property side : Cutout Tree 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
164050 114792 2 67 10 Linares Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x10   5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
164459 116850 2 9 83 Panorama Dr 2 Front Yard : Yard Tree 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
166329 117480 2 163 601 PACHECO ST 2 Sidewalk: Property side : Cutout Tree 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
183437 116849 2 16 83 Panorama Dr 1 Front Yard : Yard Tree 2   05/03/2016 12:00:00 AM 3     5997625.8 2100317.8 37.7469361901044 -122.450958160054 (37.7469361901044, -122.450958160054) 1 5 4 59 38
184372 117482 2 163 601 PACHECO ST 4 Sidewalk: Property side : Cutout Tree 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
187328 117481 2 163 601 PACHECO ST 3 Sidewalk: Property side : Cutout Tree 2       3x9   5993107 2101833 37.7508368102529 -122.466693753982 (37.7508368102529, -122.466693753982) 1 8 4 29491 12
1560 258220 2 13 477 Eucalyptus Dr 2 Sidewalk: Property side : Cutout Tree 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
18060 258219 2 13 477 Eucalyptus Dr 1 Sidewalk: Property side : Cutout Tree 2   07/03/2019 12:00:00 AM 3 3x3 Permit Number 774069 5989683 2094686 37.7310148065902 -122.478011682019 (37.7310148065902, -122.478011682019) 1 8 4 64 14
8046 261018 2 22 79 Cragmont Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 774761 5992858 2101375 37.749564886931 -122.467521508976 (37.749564886931, -122.467521508976) 1 8 4 29491 12
11989 261017 2 22 79 Cragmont Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/15/2019 12:00:00 AM 3 3x3 Permit Number 774761 5992858 2101375 37.749564886931 -122.467521508976 (37.749564886931, -122.467521508976) 1 8 4 29491 12
106240 122625 2 64 189 Country Club Dr 1 Sidewalk: Property side : Cutout Tree 2   11/15/2016 12:00:00 AM 3 4x5 Permit Number 774974 5984222 2094938 37.7313882480876 -122.496909587532 (37.7313882480876, -122.496909587532) 1 8 4 64 35
178269 122626 2 64 330 Country Club Dr 1 Sidewalk: Property side : Cutout Tree 2   11/15/2016 12:00:00 AM 3 3x5 Permit Number 774975 5984613 2095517 37.7330009316807 -122.495600537949 (37.7330009316807, -122.495600537949) 1 8 4 64 35
171095 122627 2 14 34 Country Club Dr 1 Sidewalk: Property side : Cutout Tree 2   11/15/2016 12:00:00 AM 3 3x4 Permit Number 775279 5984731 2094410 37.7299683129055 -122.495110985344 (37.7299683129055, -122.495110985344) 1 8 4 64 35
120310 173614 2 149 2955 20th Ave 2 Sidewalk: Property side : Yard Tree 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
146537 173613 2 149 2955 20th Ave 1 Sidewalk: Property side : Yard Tree 2   12/12/2016 12:00:00 AM 3 3x6 Permit Number 776469 5990236.78382 2095590.44954 37.7335303227244 -122.476163213901 (37.7335303227244, -122.476163213901) 1 8 4 64 35
186896 114793 2 17 10 Linares Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x10 Permit Number 777094 5993887.4 2102332.1 37.7522522176371 -122.464031307011 (37.7522522176371, -122.464031307011) 1 8 4 29491 40
31798 154902 2 8 1101X Ortega St 3 Sidewalk: Curb side : Cutout Tree 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
34999 154898 2 8 1101X Ortega St 4 Sidewalk: Curb side : Cutout Tree 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
86852 154903 2 8 1101X Ortega St 2 Sidewalk: Curb side : Cutout Tree 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
160246 254370 2 8 1101X Ortega St 1 Sidewalk: Curb side : Cutout Tree 2   02/06/2018 12:00:00 AM 3 4x4 Permit Number 778565 5990408 2102358 37.7521221923779 -122.476065384407 (37.7521221923779, -122.476065384407) 1 8 4 29491 12
51709 173899 2 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
68264 173898 2 31 1762 12th Ave 1 Sidewalk: Property side : Cutout Tree 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
38353 256715 2 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
67232 256000 2 1 8 Springfield Dr 1 Sidewalk: Property side : Yard Tree 2   08/21/2018 12:00:00 AM 3 6x10 Permit Number 780036 5986792.13129 2095812.03329 37.733938381975 -122.488088482457 (37.733938381975, -122.488088482457) 1 8 4 64 35
95904 256882 2 14 3075 25th Ave 2 Sidewalk: Property side : Yard Tree 2   12/21/2018 12:00:00 AM 3 3x10 Permit Number 781920 5988824.60597 2094879.63635 37.7314966214822 -122.480993433312 (37.7314966214822, -122.480993433312) 1 8 4 64 35
140218 256881 2 14 3075 25th Ave 1 Sidewalk: Property side : Yard Tree 2   12/21/2018 12:00:00 AM 3 3x10 Permit Number 781920 5988824.60597 2094879.63635 37.7314966214822 -122.480993433312 (37.7314966214822, -122.480993433312) 1 8 4 64 35
1992 260845 2 146 6 Cragmont Ave 1 Sidewalk: Property side : Yard Tree 2   10/15/2019 12:00:00 AM 3 4x4 Permit Number 782122 5992584.1181 2101828.636 37.7507946382458 -122.468501593976 (37.7507946382458, -122.468501593976) 1 8 4 29491 12
16662 260846 2 146 6 Cragmont Ave 2 Sidewalk: Property side : Yard Tree 2   10/15/2019 12:00:00 AM 3 4x4 Permit Number 782122 5992584.1181 2101828.636 37.7507946382458 -122.468501593976 (37.7507946382458, -122.468501593976) 1 8 4 29491 12
6656 258684 2 224 222 Eucalyptus Dr 2 Sidewalk: Property side : Yard Tree 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
8278 258683 2 224 222 Eucalyptus Dr 1 Sidewalk: Property side : Yard Tree 2   06/06/2019 12:00:00 AM 3 4x4 Permit Number 782190 5990522.43491 2094710.12159 37.7311297256611 -122.475111403646 (37.7311297256611, -122.475111403646) 1 8 4 64 35
2574 216200 2 1 1650 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/11/2020 12:00:00 AM 3 4x4 Permit Number 784456 5992806.74011 2104217.97153 37.7573679916535 -122.467905522425 (37.7573679916535, -122.467905522425) 1 8 4 56 12
4912 261377 2 183 3015 25th Ave 2 Sidewalk: Property side : Yard Tree 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
17863 261376 2 183 3015 25th Ave 1 Sidewalk: Property side : Yard Tree 2   01/08/2020 12:00:00 AM 3 4x10 Permit Number 784883 5988814.87181 2095155.07295 37.7322523337557 -122.481047245899 (37.7322523337557, -122.481047245899) 1 8 4 64 35
4685 163919 2 8 528 Kirkham St 1 Sidewalk: Curb side : Cutout Tree 2   05/18/2020 12:00:00 AM 3 4x4 Permit Number 785290 5993187.06549 2105302.66577 37.7603682343238 -122.466669061634 (37.7603682343238, -122.466669061634) 1 8 4 56 12