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)
61885 105866 6 58 3555 Cesar Chavez St 1 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
73380 105869 6 28 3555 Cesar Chavez St 4 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
76185 105867 6 28 3555 Cesar Chavez St 2 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
145596 105870 6 28 3555 Cesar Chavez St 5 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
178545 105871 6 28 3555 Cesar Chavez St 6 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
186539 105868 6 28 3555 Cesar Chavez St 3 Front Yard : Yard Tree 2           6006336.4 2100501.8 37.7479362343406 -122.420850697466 (37.7479362343406, -122.420850697466) 2 7 7 28859 2
100702 109040 6 113 654 Precita Ave   Front Yard : Yard Tree 2     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152) 2 7 7 28859 2
8163 82435 6 15 51 Peralta Ave 1 Front Yard : Yard Tree 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
168346 251480 6 15 51 Peralta Ave 1 Front Yard : Yard Tree 2       3x3   6010641 2100362 37.7477940646116 -122.405955656592 (37.7477940646116, -122.405955656592) 2 7 7 28859 2
48619 253373 6 22 78 Peralta Ave 1 Front Yard : Yard Tree 2       3x3   6010457 2100357 37.7477700431666 -122.406591570174 (37.7477700431666, -122.406591570174) 2 7 7 28859 2
174 113728 6 36 1580 Valencia St 5 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
20298 113730 6 36 1580 Valencia St 7 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
41027 113738 6 36 1580 Valencia St 15 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
42851 113727 6 36 1580 Valencia St 4 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
61015 113741 6 11 1580 Valencia St 1 Front Yard : Yard Tree 2     18     6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
61399 113734 6 36 1580 Valencia St 11 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
67938 113739 6 36 1580 Valencia St 16 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
86304 113736 6 36 1580 Valencia St 13 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
87807 113732 6 17 1580 Valencia St 9 Front Yard : Yard Tree 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
98904 113735 6 36 1580 Valencia St 12 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
105980 113733 6 36 1580 Valencia St 10 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
117937 113726 6 36 1580 Valencia St 3 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
124470 105858 6 70 1580 Valencia St 18 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
128240 113740 6 36 1580 Valencia St 17 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
159232 105859 6 70 1580 Valencia St 18 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185143 113737 6 17 1580 Valencia St 14 Front Yard : Yard Tree 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
185504 113729 6 17 1580 Valencia St 6 Front Yard : Yard Tree 2   10/08/2015 12:00:00 AM     Permit Number 775128 6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
192790 113731 6 36 1580 Valencia St 8 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
22846 105861 6 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23771 105863 6 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
35675 105864 6 36 3615-3623X Cesar Chavez St 5 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
75419 105862 6 36 3615-3623X Cesar Chavez St 3 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
126862 105865 6 36 3615-3623X Cesar Chavez St 6 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
182948 105860 6 36 3615-3623X Cesar Chavez St 1 Front Yard : Yard Tree 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
10910 120918 6 17 555x SAN JOSE AVE 2 Front Yard : Yard Tree 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
98953 114193 6 17 555x SAN JOSE AVE 1 Front Yard : Yard Tree 2   11/07/2016 12:00:00 AM 3 3x3 Permit Number 778877 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
109570 114194 6 11 555x SAN JOSE AVE 2 Front Yard : Yard Tree 2   11/23/2015 12:00:00 AM 30 3x3 Permit Number 777057 6006305 2100249 37.747240333103 -122.420941331562 (37.747240333103, -122.420941331562) 2 7 7 28859 2
191007 96222 6 17 176 Holladay Ave 1 Sidewalk: Property side : Cutout Tree 2   05/18/2011 12:00:00 AM 18 3x3 Permit Number 767739 6010842.9 2100101.6 37.7470903528282 -122.405239158587 (37.7470903528282, -122.405239158587) 2 7 7 28859 2
170923 109294 6 53 370 27TH ST 1 Sidewalk: Curb side : Cutout Tree 2     18     6004104.9 2100171.3 37.7469027259862 -122.428543573264 (37.7469027259862, -122.428543573264) 2 7 5 63 22
51024 105872 6 70 595X San Jose Ave 6 Front Yard : Yard Tree 2           6006124.47156 2100100.14306 37.7468214281195 -122.421555015777 (37.7468214281195, -122.421555015777) 2 7 7 28859 2
9889 116075 6 17 88 MONTCALM ST 1 Front Yard : Yard Tree 2           6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
145228 173889 6 182 190 Holladay Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 779949 6010824 2099939 37.7466428319545 -122.405293064953 (37.7466428319545, -122.405293064953) 2 7 7 28859 2
14497 251425 6 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
30295 251424 6 41 5016 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree 2       3x3   5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
167870 251608 6 41 56R Amber Dr 1 Back Yard : Yard Tree 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
177581 251609 6 41 56R Amber Dr 2 Back Yard : Yard Tree 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
190882 251610 6 41 56R Amber Dr 3 Back Yard : Yard Tree 2           5999423 2100048 37.7462981080439 -122.44472423658 (37.7462981080439, -122.44472423658) 2 7 5 63 22
7196 251612 6 15 60R Amber Dr 1 Back Yard : Yard Tree 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
77182 251613 6 41 60R Amber Dr 2 Back Yard : Yard Tree 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
7000 251607 6 15 52 Amber Dr 2 Back Yard : Yard Tree 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
34770 251426 6 15 5020 Diamond Heights Blvd 1 Sidewalk: Property side : Yard Tree 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
169643 251606 6 15 52R Amber Dr 1 Back Yard : Yard Tree 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
34428 251636 6 15 22R Amethyst Way 1 Back Yard : Yard Tree 2           5999148 2100052 37.7462933941297 -122.445675437709 (37.7462933941297, -122.445675437709) 2 7 5 63 22
39032 251604 6 15 48R Amber Dr 1 Back Yard : Yard Tree 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
54862 251605 6 95 48R Amber Dr 2 Back Yard : Yard Tree 2           5999482 2100041 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345) 2 7 5 63 22
20228 251632 6 41 14R Amethyst Way 1 Back Yard : Yard Tree 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
153865 251633 6 41 14R Amethyst Way 2 Back Yard : Yard Tree 2           5999202 2100044 37.7462745109784 -122.445488137723 (37.7462745109784, -122.445488137723) 2 7 5 63 22
20385 251602 6 95 44R Amber Dr 1 Back Yard : Yard Tree 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
52672 251603 6 41 44R Amber Dr 2 Back Yard : Yard Tree 2           5999509 2100035 37.7462673204657 -122.444425925791 (37.7462673204657, -122.444425925791) 2 7 5 63 22
42469 251630 6 41 8R Amethyst Way 2 Back Yard : Yard Tree 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
98838 251629 6 41 8R Amethyst Way 1 Back Yard : Yard Tree 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
102716 251631 6 41 8R Amethyst Way 3 Back Yard : Yard Tree 2           5999237 2100032 37.7462435599048 -122.445366249721 (37.7462435599048, -122.445366249721) 2 7 5 63 22
113435 251621 6 41 72R Amber Dr 4 Back Yard : Yard Tree 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
122354 251619 6 41 72R Amber Dr 2 Back Yard : Yard Tree 2           5999318 2100030 37.746242691915 -122.445086018875 (37.746242691915, -122.445086018875) 2 7 5 63 22
12676 251651 6 50 3237 Harrison St 1 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 782183 6009049 2099828 37.7462386522881 -122.411423013741 (37.7462386522881, -122.411423013741) 2 7 7 28859 2
177584 234000 6 143 749 27th St 2 Front Yard : Yard Tree 2     10 Width 10ft   6001659.60779 2099970.43439 37.7462125114091 -122.436984776447 (37.7462125114091, -122.436984776447) 2 7 5 63 22
111349 251628 6 41 2R Amethyst Way 3 Back Yard : Yard Tree 2           5999263 2100016 37.7462011119367 -122.44527519505 (37.7462011119367, -122.44527519505) 2 7 5 63 22
145363 251626 6 41 2R Amethyst Way 1 Back Yard : Yard Tree 2           5999263 2100016 37.7462011119367 -122.44527519505 (37.7462011119367, -122.44527519505) 2 7 5 63 22
23740 255978 6 56 36 Amber Dr 1 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
30833 258289 6 56 36 Amber Dr 6 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
82626 258290 6 56 36 Amber Dr 7 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
104555 258287 6 56 36 Amber Dr 4 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
128772 258286 6 56 36 Amber Dr 3 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
134246 258292 6 56 36 Amber Dr 9 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
145770 258288 6 56 36 Amber Dr 5 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
147696 258285 6 56 36 Amber Dr 2 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
159425 258291 6 56 36 Amber Dr 8 Front Yard : Yard Tree 2       3x3   5999567 2100009 37.7461992398699 -122.444223501473 (37.7461992398699, -122.444223501473) 2 7 5 63 22
156992 253621 6 63 200x Montcalm St 1 Back Yard : Yard Tree 2       3x3   6010036 2099760 37.7461072494139 -122.408005278478 (37.7461072494139, -122.408005278478) 2 7 7 28859 2
22628 101981 6 93 25X Tiffany Ave 4 Front Yard : Yard Tree 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
152685 101980 6 93 25X Tiffany Ave 3 Front Yard : Yard Tree 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
170620 101979 6 93 25X Tiffany Ave 2 Front Yard : Yard Tree 2           6006415.7 2099833.4 37.7461054290546 -122.420529042399 (37.7461054290546, -122.420529042399) 2 7 7 28859 2
39481 101978 6 93 25X Tiffany Ave 1 Front Yard : Yard Tree 2     12     6006502 2099737 37.7458455996049 -122.420223786963 (37.7458455996049, -122.420223786963) 2 7 7 28859 2
66441 109838 6 63 200x MONTCALM ST 1 Sidewalk: Curb side : Cutout Tree 2     30 3x3   6009924 2099647 37.7457907048197 -122.408384592716 (37.7457907048197, -122.408384592716) 2 7 7 28859 2
41386 121194 6 43 255x Red Rock Way 1 Front Yard : Yard Tree 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
116253 121195 6 62 255x Red Rock Way 2 Front Yard : Yard Tree 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
171448 121196 6 62 255x Red Rock Way 3 Front Yard : Yard Tree 2       3x3 Permit Number 775289 5999917 2099808 37.7456673038035 -122.442998816589 (37.7456673038035, -122.442998816589) 2 7 5 63 22
104794 115276 6 15 598X PORTOLA DR 1 Sidewalk: Curb side : Yard Tree 2       3x3   5997411 2099824 37.7455680371271 -122.451665301061 (37.7455680371271, -122.451665301061) 1 7 4 59 40
18320 261763 6 15 315 Montcalm St 1 Front Yard : Yard Tree 2       3x3   6009577 2099558 37.7455268923792 -122.409578193595 (37.7455268923792, -122.409578193595) 2 7 7 28859 2
2175 121189 6 41 1000x Duncan St 10 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
42733 121190 6 62 1000x Duncan St 11 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
52280 121184 6 62 1000x Duncan St 5 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
57354 121187 6 62 1000x Duncan St 8 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67180 121191 6 62 1000x Duncan St 12 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
67746 121188 6 62 1000x Duncan St 9 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
88321 121186 6 62 1000x Duncan St 7 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
88853 121193 6 62 1000x Duncan St 14 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
110196 121181 6 62 1000x Duncan St 2 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
113996 121192 6 62 1000x Duncan St 13 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
114919 121183 6 62 1000x Duncan St 4 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
122047 121185 6 62 1000x Duncan St 6 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22
154884 121182 6 62 1000x Duncan St 3 Sidewalk: Curb side : Cutout Tree 2       3x3 Permit Number 775289 5999834 2099740 37.7454758595085 -122.443280934089 (37.7454758595085, -122.443280934089) 2 7 5 63 22