trees

7,157 rows where qSpecies_id = 36 sorted by DBH

✎ View and edit SQL

This data as json, CSV (advanced)

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
174 113728 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 5 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
412 121036 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1830 Polk St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006566 2117108 37.7935458417616 -122.421235781398 (37.7935458417616, -122.421235781398) 13 9 10 28858 32
669 30402 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 8 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
731 262111 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2021 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991247 2101647 37.7502185858925 -122.473112177678 (37.7502185858925, -122.473112177678) 1 8 4 29491 12
959 49689 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2235 NOTES) Hayes St 20 Sidewalk: Curb side : Cutout Tree Private 2   05/21/2003 12:00:00 AM     Permit Number 46511 5997175.15188937 2109805.23760487 37.7729604879505 -122.453201252207 (37.7729604879505, -122.453201252207) 15 5 11 29492 16
989 40872 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3456 Washington St 8 Sidewalk: Curb side : Cutout Tree Private 2   09/22/1999 12:00:00 AM     Permit Number 41788 5998239.16759035 2115871.78992415 37.7896785829725 -122.449958017829 (37.7896785829725, -122.449958017829) 13 6 1 54 31
1385 101200 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 502 Irving St 2 Sidewalk: Curb side : Cutout Tree Private 2           5994231.2 2106687.3 37.7642302811549 -122.463158383346 (37.7642302811549, -122.463158383346) 11 5 11 56 12
1436 256792 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 120 Cedar St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006815 2114489 37.7863687502832 -122.420188259313 (37.7863687502832, -122.420188259313) 13 9 10 28858 36
1734 262292 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 6 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
1868 37331 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 700 Noe St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/15/1998 12:00:00 AM     Permit Number 39840 6003021.44463533 2104165.68333023 37.7578089842605 -122.432575328482 (37.7578089842605, -122.432575328482) 2 4 5 28862 3
2062 112894 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1x WEBSTER ST 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004219 2108568 37.7699645303419 -122.428747509741 (37.7699645303419, -122.428747509741) 7 9 5 28862 10
2158 95238 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1220 Noe St 5 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW     3x3   6002897.4 2101092.2 37.7493628934568 -122.432784769514 (37.7493628934568, -122.432784769514) 2 4 5 28862 22
2521 32694 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3732 23rd St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/29/1996 12:00:00 AM     Permit Number 37102 6004840.63533052 2102540.6946209 37.7534501432299 -122.426168121736 (37.7534501432299, -122.426168121736) 2 4 5 28862 22
2781 256736 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1266 Naples St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF         6000975.18369 2087214.83327 37.7111496346342 -122.438437697477 (37.7111496346342, -122.438437697477) 9 7 6 28861 5
3188 260646 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 2 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
4711 30383 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2800 Turk St 14 Sidewalk: Curb side : Cutout Tree Private 2   03/09/1956 12:00:00 AM     Permit Number 66 5997681.665837 2111673.48633421 37.7781192320704 -122.451583952943 (37.7781192320704, -122.451583952943) 15 6 2 54 16
4721 44169 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2100 Vallejo St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2000 12:00:00 AM     Permit Number 43638 6003503.99505303 2117958.62597334 37.795708342081 -122.431891323133 (37.795708342081, -122.431891323133) 13 9 1 57 17
5127 261795 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 555 Fulton St 15 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6005001.9506 2111591.9082 37.7783117284071 -122.426254616894 (37.7783117284071, -122.426254616894) 7 9 11 28852 10
5141 262445 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 99 Lyell St 2 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6003121 2094520 37.731329826937 -122.43154242119 (37.731329826937, -122.43154242119) 9 7 5 28861 25
5229 44454 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 95 Winding Way 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/23/2001 12:00:00 AM     Permit Number 43779 6002576.22413505 2086867.96270094 37.710288143695 -122.432879348949 (37.710288143695, -122.432879348949) 9 7 6 28861 5
5450 36847 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   1 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6208 47715 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 178 Lippard Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/22/2002 12:00:00 AM     Permit Number 45511 6001758.80730105 2095060.28518468 37.7327360238789 -122.436290415986 (37.7327360238789, -122.436290415986) 9 7 5 63 40
6426 36849 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   3 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6811 36853 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   7 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6838 256837 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1201x Franklin St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41
7030 260467 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 2 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
7367 262291 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
7471 96417 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2001 Market St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/20/2011 12:00:00 AM   3x3 Permit Number 767173 6004662.9 2108069.9 37.7686219813575 -122.427176582427 (37.7686219813575, -122.427176582427) 8 4 5 28862 3
7656 41147 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1571 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/18/1999 12:00:00 AM     Permit Number 41880 5998098.90766238 2108198.23177185 37.7686009624438 -122.449890046711 (37.7686009624438, -122.449890046711) 15 5 11 29492 9
7666 261515 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 622 41st Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   01/25/2020 11:20:00 AM   Width 4ft   5983216.44703 2111516.83265 37.7768501112803 -122.501611967936 (37.7768501112803, -122.501611967936) 11 6 2 55 26
7766 30822 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 151 Lippard Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/06/1995 12:00:00 AM     Permit Number 34679 6001848.24049432 2095191.22581593 37.7331006378237 -122.435990589821 (37.7331006378237, -122.435990589821) 9 7 5 63 40
7767 262288 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
7926 105855 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 4X Duncan St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006273.18234 2099962.59464 37.746452135478 -122.421031022521 (37.746452135478, -122.421031022521) 2 7 7 28859 2
9478 260514 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3025 22nd Ave 1 Sidewalk: Property side : Yard Tree Private 2       3x3   5989750.29916 2095052.76589 37.7320257582668 -122.477805820702 (37.7320257582668, -122.477805820702) 1 8 4 64 35
9493 116897 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 180 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5992666 2097552 37.7390568153225 -122.467907415395 (37.7390568153225, -122.467907415395) 1 8 4 59 40
9496 36851 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   5 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
9719 116812 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 3660x 23RD ST 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005401 2102665 37.7538231135776 -122.42423909942 (37.7538231135776, -122.42423909942) 2 4 5 28859 19
9892 258923 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 900 Hyde St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007771 2115657 37.7896296127826 -122.416963519552 (37.7896296127826, -122.416963519552) 13 1 10 28858 21
10213 260647 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3905 Sacramento St 3 Sidewalk: Property side : Cutout Tree Private 2       3x3   5996106 2114850 37.7867507340863 -122.457264569448 (37.7867507340863, -122.457264569448) 11 6 1 54 31
10403 58111 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 424 Irving St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/18/1978 12:00:00 AM     Permit Number 17089 5994475.54876777 2106701.69853806 37.7642838888462 -122.462314301289 (37.7642838888462, -122.462314301289) 11 5 11 56 12
10726 113513 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 352 TURK ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6008306 2113136 37.7827376375446 -122.414933965724 (37.7827376375446, -122.414933965724) 7 10 9 28852 36
11037 262112 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2021 16th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991247 2101647 37.7502185858925 -122.473112177678 (37.7502185858925, -122.473112177678) 1 8 4 29491 12
11210 262290 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
11236 36848 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   2 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11314 36850 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   4 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11320 87812 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 4850 Funston Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/03/2008 12:00:00 AM   3x3 Permit Number 50626                    
11479 110887 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 800 INDIANA ST 21 Sidewalk: Property side : Yard Tree Private 2           6014913.4 2104437.2 37.7592217202179 -122.391466645187 (37.7592217202179, -122.391466645187) 10 3 8 28856 29
11867 262287 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
12611 121264 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 3053 Turk Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 778943 5996367 2111408 37.7773149020317 -122.456112630584 (37.7773149020317, -122.456112630584) 11 6 2 54 16
12719 49732 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1300@ REVERE Griffith St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
12732 36844 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   8 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
12786 261612 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1900x Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
12805 47349 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 247 Jules Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/13/2002 12:00:00 AM     Permit Number 45275 5994440.83573449 2091551.9214492 37.7226843967426 -122.461336047264 (37.7226843967426, -122.461336047264) 9 8 4 28861 24
13629 37178 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 83 Tiffany Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/08/1998 12:00:00 AM     Permit Number 39751 6006286.91240997 2099581.31244652 37.7454059949527 -122.420956479029 (37.7454059949527, -122.420956479029) 2 7 7 28859 2
13682 49599 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2540 Post St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/13/2003 12:00:00 AM   3x3 Permit Number 46468 6000006.86571427 2113723.38602572 37.7838806119089 -122.44368757451 (37.7838806119089, -122.44368757451) 15 6 11 29490 31
14597 106873 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 38 08th St 4 Front Yard : Cutout Tree Private 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
14960 45753 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 806 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2001 12:00:00 AM     Permit Number 44399 6011825.65444004 2104622.45579414 37.7595585281932 -122.402158643537 (37.7595585281932, -122.402158643537) 10 3 8 28856 29
15016 261205 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 2301 Leavenworth St 2 Side Yard : Yard Tree Private 2       3x3   6007514 2120271 37.8022840477627 -122.418179969724 (37.8022840477627, -122.418179969724) 5 1 1 28858 32
15148 260466 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1 Masonic Ave 1 Side Yard : Yard Tree Private 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15614 261796 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 555 Fulton St 16 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6005001.9506 2111591.9082 37.7783117284071 -122.426254616894 (37.7783117284071, -122.426254616894) 7 9 11 28852 10
15741 259561 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 198 Public Park 2 Unaccepted Street : Yard Tree Private 2       3x3   5994123 2098483 37.7416971373248 -122.462937339952 (37.7416971373248, -122.462937339952) 1 8 4 59 40
16042 256809 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
16905 35711 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 271 Collingwood St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/26/1998 12:00:00 AM     Permit Number 40008 6002102.4473232 2104292.82421891 37.7581059239319 -122.435762694984 (37.7581059239319, -122.435762694984) 2 4 5 28862 3
17094 58287 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 335 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/1978 12:00:00 AM     Permit Number 17301 6002954.56301529 2106290.38431517 37.7636391085514 -122.432958425945 (37.7636391085514, -122.432958425945) 15 4 5 28862 3
18011 262289 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18034 255666 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 275 Bright St 1 Sidewalk: Curb side : Cutout Tree Private 2       4x4   5993722 2089019 37.7156882061667 -122.463637144214 (37.7156882061667, -122.463637144214) 9 8 6 64 24
18045 36852 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36   6 Sidewalk: Curb side : Cutout Tree Private 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
18057 108119 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 600X 14TH ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004785.9 2107807.3 37.7679078999373 -122.42673243214 (37.7679078999373, -122.42673243214) 8 4 5 28862 3
18974 101400 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2101X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002392.4 2115430.1 37.7887025838749 -122.435556659004 (37.7887025838749, -122.435556659004) 13 9 1 29490 27
19144 30721 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 273 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/1995 12:00:00 AM     Permit Number 34621 6005264.06153495 2109890.21668057 37.7736541098939 -122.42522675761 (37.7736541098939, -122.42522675761) 7 9 11 28852 10
19287 102886 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 2940 16th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007175 2106758 37.7651615533416 -122.418394378814 (37.7651615533416, -122.418394378814) 8 4 7 28853 19
19585 261797 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 555 Fulton St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6005132 2111588 37.7783083474557 -122.425804449276 (37.7783083474557, -122.425804449276) 7 9 11 28852 10
19899 109490 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1315x PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6007628 2115744 37.789860448493 -122.417464454457 (37.789860448493, -122.417464454457) 13 1 10 28858 21
19958 104685 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 7 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
20163 38425 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 677 Arguello Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2   08/18/1998 12:00:00 AM     Permit Number 40455 5995620.12653978 2111585.65414661 37.7777597947005 -122.458709155257 (37.7777597947005, -122.458709155257) 11 6 2 54 11
20298 113730 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 1580 Valencia St 7 Front Yard : Yard Tree Private 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
20484 33494 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 5 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/25/1996 12:00:00 AM     Permit Number 37616 6007093.40063792 2099746.03320147 37.745903708668 -122.418179442359 (37.745903708668, -122.418179442359) 2 7 7 28859 2
20610 97345 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 2201X Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1           6002913.40766 2114711.00908 37.7867577207832 -122.433702635665 (37.7867577207832, -122.433702635665) 13 9 11 29490 27
20656 47603 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 482 Gates St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/2002 12:00:00 AM     Permit Number 45439 6008187.89387255 2096604.2720309 37.7373386707457 -122.414172586256 (37.7373386707457, -122.414172586256) 2 7 7 28859 2
21132 47057 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2675 Bush St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/02/2002 12:00:00 AM     Permit Number 45044 6000718.46465966 2114463.14192168 37.7859523514262 -122.44127880812 (37.7859523514262, -122.44127880812) 15 6 1 29490 27
21238 43371 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 581 Alvarado St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/17/2000 12:00:00 AM     Permit Number 43119 6002618.618393 2102657.68804229 37.753645537433 -122.433860682931 (37.753645537433, -122.433860682931) 2 4 5 28862 22
21264 256802 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
21294 98016 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1561@21st Ave Taraval St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5988339.7 2098919.1 37.7425597372021 -122.482965774008 (37.7425597372021, -122.482965774008) 1 8 3 29491 35
21702 256807 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1098x Geary St 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006524 2114353 37.7859789268864 -122.421185386363 (37.7859789268864, -122.421185386363) 13 9 9 28858 36
22063 93539 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 325 China Basin St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/08/2010 12:00:00 AM   3x3 Permit Number 53240 6016190.6 2109941.9 37.774407241214 -122.387433446454 (37.774407241214, -122.387433446454) 14 3 9 310 20
22086 38009 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2427 15th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/08/1998 12:00:00 AM     Permit Number 40220 5991681.4745323 2098905.82627882 37.7427171753014 -122.471410041699 (37.7427171753014, -122.471410041699) 1 8 4 29491 40
22189 99108 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1642 Clay St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006878.8 2116741.3 37.7925566043485 -122.420127429765 (37.7925566043485, -122.420127429765) 13 9 10 28858 32
22225 88126 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2202 Sutter St   Sidewalk: Curb side : Cutout Tree Private 2   07/02/2008 12:00:00 AM   3x3 Permit Number 51132 6002003.4 2114360.3 37.7857430855157 -122.436825926477 (37.7857430855157, -122.436825926477) 13 6 1 29490 27
22394 61961 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 101 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/05/2008 12:00:00 AM   3x3 Permit Number 51629 6003797.06082137 2108782.38494948 37.7705292896917 -122.4302222862 (37.7705292896917, -122.4302222862) 15 9 11 29492 10
22439 52788 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1990 Green St 4 Sidewalk: Curb side : Cutout Tree Private 2   05/25/2006 12:00:00 AM     Permit Number 48829 6003521.84777488 2118307.58529234 37.7966675065401 -122.43185447841 (37.7966675065401, -122.43185447841) 13 9 1 57 17
22612 91357 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 2121 Leavenworth St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/24/2009 12:00:00 AM   3x3 Permit Number 52063 6007640 2119628 37.8005256228645 -122.41769834526 (37.8005256228645, -122.41769834526) 5 1 1 28858 32
22661 87370 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 176 Edgewood Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/15/2008 12:00:00 AM   3x3 Permit Number 50350 5996633.3 2106059.5 37.7626445866283 -122.454804890054 (37.7626445866283, -122.454804890054) 15 5 11 29492 12
22773 50259 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 122 Cuvier St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/27/2003 12:00:00 AM     Permit Number 46965 6003984.04556278 2095181.6765625 37.7331955208977 -122.42860586219 (37.7331955208977, -122.42860586219) 9 7 5 28861 25
22846 105861 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 2 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
23579 255888 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 50 Columbia Square St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
23771 105863 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 3615-3623X Cesar Chavez St 4 Front Yard : Yard Tree Private 2           6005538 2100417 37.7476583584974 -122.423605504909 (37.7476583584974, -122.423605504909) 2 7 5 28859 22
24273 35313 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 3637 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/20/1998 12:00:00 AM     Permit Number 38780 6005411.11195628 2104860.60189435 37.759852294152 -122.424360282422 (37.759852294152, -122.424360282422) 2 4 5 28859 19
24311 46249 Permitted Site 7 Pittosporum undulatum :: Victorian Box 36 1675 Hawes St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
24833 104679 Significant Tree 6 Pittosporum undulatum :: Victorian Box 36 33 08th St 1 Front Yard : Yard Tree Private 2         Permit Number 770764 6008457.3 2111569.1 37.7784438055662 -122.414299630615 (37.7784438055662, -122.414299630615) 8 2 9 28853 34
24889 256834 Undocumented 4 Pittosporum undulatum :: Victorian Box 36 1201x Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006137 2114500 37.7863607279306 -122.422534752155 (37.7863607279306, -122.422534752155) 13 9 11 28858 41

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);