1,377 rows where qSpecies_id = 61

View and edit SQL

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)
19333 244143 DPW Maintained 1 Tristania conferta :: 61 423 Rose St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004418.4707 2109613.03 37.7728452161751 -122.428132029093 (37.7728452161751, -122.428132029093) 7 9 11 28852 10
19450 200924 DPW Maintained 1 Tristania conferta :: 61 4100 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6015492.5641 2097476.9144 37.7401423621251 -122.38897764491 (37.7401423621251, -122.38897764491) 10 3 8 58 1
19570 7045 DPW Maintained 1 Tristania conferta :: 61 1300 Fell St 4 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2010 12:00:00 AM 12 3X3   6001075.5825 2110054.6953 37.7738682146278 -122.439727109686 (37.7738682146278, -122.439727109686) 15 5 11 29492 10
19744 138921 DPW Maintained 1 Tristania conferta :: 61 631 BUCHANAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004505.2517 2110712.757 37.7758697074358 -122.427910221054 (37.7758697074358, -122.427910221054) 7 9 11 28852 10
19778 137930 DPW Maintained 1 Tristania conferta :: 61 1977 PINE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6004477.3196 2115333.9095 37.7885566643943 -122.428336281189 (37.7885566643943, -122.428336281189) 13 9 11 28858 27
19889 248530 DPW Maintained 1 Tristania conferta :: 61 35 Beulah St 5 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5997722.0136 2107803.8234 37.7674964457612 -122.451165239168 (37.7674964457612, -122.451165239168) 15 5 11 29492 9
19972 200895 DPW Maintained 1 Tristania conferta :: 61 4247 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6015445.3265 2097019.6548 37.7388842023405 -122.389109055705 (37.7388842023405, -122.389109055705) 10 3 8 58 1
20396 246241 DPW Maintained 1 Tristania conferta :: 61 1395 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999547.9215 2107815.4823 37.7676328306769 -122.444850527256 (37.7676328306769, -122.444850527256) 15 5 11 29492 9
20401 140131 Permitted Site 7 Tristania conferta :: 61 501 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2   01/11/2002 12:00:00 AM 5 Width 0ft   6005847.0047 2111508.1975 37.7781296085056 -122.423325305774 (37.7781296085056, -122.423325305774) 7 9 11 28852 10
20510 142108 DPW Maintained 1 Tristania conferta :: 61 758 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6001607.3106 2111115.6492 37.7768115789366 -122.437963788403 (37.7768115789366, -122.437963788403) 15 5 11 29492 10
20544 200187 DPW Maintained 1 Tristania conferta :: 61 2999 Ingalls St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6014602.6431 2090373.0881 37.720587322073 -122.391558129174 (37.720587322073, -122.391558129174) 10 3 8 58 1
20668 142244 DPW Maintained 1 Tristania conferta :: 61 419 Linden St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6005364 2110769 37.7760726809274 -122.424943590033 (37.7760726809274, -122.424943590033) 7 9 11 28852 10
20708 200514 DPW Maintained 1 Tristania conferta :: 61 5701 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6013926.9791 2092225.4991 37.7256361452498 -122.39402331403 (37.7256361452498, -122.39402331403) 10 3 8 58 1
21270 139936 DPW Maintained 1 Tristania conferta :: 61 800 GOUGH ST 10 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6005717.7716 2112456.4224 37.7807259079437 -122.423839812492 (37.7807259079437, -122.423839812492) 7 9 11 28852 41
21423 143427 DPW Maintained 1 Tristania conferta :: 61 855 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6010650.0101 2116903.247 37.7932130339503 -122.407090272453 (37.7932130339503, -122.407090272453) 3 1 10 28857 4
21688 24501 DPW Maintained 1 Tristania conferta :: 61 901 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/24/1995 12:00:00 AM 6 3X3   6003042.5941 2110274.0021 37.7745821407981 -122.43293857186 (37.7745821407981, -122.43293857186) 15 5 11 29492 10
21708 30437 DPW Maintained 1 Tristania conferta :: 61 567 Union St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/11/1956 12:00:00 AM 12   Permit Number 90 6010234.0616 2119544.2672 37.8004413456091 -122.40871589046 (37.8004413456091, -122.40871589046) 3 1 10 308 23
21816 29421 DPW Maintained 1 Tristania conferta :: 61 2501X Ingalls St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 4 3x3   6015238.3862 2091224.5002 37.7229603992916 -122.389419974154 (37.7229603992916, -122.389419974154) 10 3 8 58 1
21861 22334 DPW Maintained 1 Tristania conferta :: 61 5201 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/17/2015 02:59:00 PM 3 3X3   6014532.0059 2093984.9826 37.7305009408534 -122.392054756971 (37.7305009408534, -122.392054756971) 10 3 8 58 1
22006 6951 DPW Maintained 1 Tristania conferta :: 61 603 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/11/1990 12:00:00 AM 6 3x3   6004469.2574 2110472.8506 37.7752089468863 -122.428017634821 (37.7752089468863, -122.428017634821) 7 9 11 28852 10
22022 30026 DPW Maintained 1 Tristania conferta :: 61 6190X 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 3 3x3   6013442.0581 2091191.4573 37.7227699118645 -122.395627242562 (37.7227699118645, -122.395627242562) 10 3 8 58 1
22324 141816 DPW Maintained 1 Tristania conferta :: 61 1218 EDDY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004565.725 2112968.4018 37.7820665729689 -122.427861790691 (37.7820665729689, -122.427861790691) 7 9 11 29490 41
22349 29469 DPW Maintained 1 Tristania conferta :: 61 1609 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 8 3X3   6016821.7398 2093350.8961 37.7288867261126 -122.384094597711 (37.7288867261126, -122.384094597711) 10 3 8 58 1
22456 25279 DPW Maintained 1 Tristania conferta :: 61 1940 Ocean Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   5993856.5207 2092712.5569 37.7258375734043 -122.463440067194 (37.7258375734043, -122.463440067194) 9 8 4 59 40
22745 200928 DPW Maintained 1 Tristania conferta :: 61 4101 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015535.5503 2097321.9752 37.7397193134396 -122.388818200912 (37.7397193134396, -122.388818200912) 10 3 8 58 1
22953 244944 DPW Maintained 1 Tristania conferta :: 61 333 Fell St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6005861.1541 2110670.4754 37.775830225555 -122.423216794436 (37.775830225555, -122.423216794436) 7 9 11 28852 10
23140 142358 DPW Maintained 1 Tristania conferta :: 61 1135 ELLIS ST 11 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6005410.0165 2113384.468 37.7832567141838 -122.424970534924 (37.7832567141838, -122.424970534924) 7 9 11 28858 41
23142 22404 DPW Maintained 1 Tristania conferta :: 61 5800 03rd St 4 Sidewalk: Curb side : Cutout Tree DPW 1     4 3X3   6013789.3037 2092097.7658 37.7252777625947 -122.394490310229 (37.7252777625947, -122.394490310229) 10 3 8 58 1
23279 22495 DPW Maintained 1 Tristania conferta :: 61 6315 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1   06/07/2011 12:00:00 AM 1 3x3   6013233.044 2090405.2973 37.7205996457096 -122.396294690849 (37.7205996457096, -122.396294690849) 10 3 8 58 1
23304 29532 DPW Maintained 1 Tristania conferta :: 61 2302X Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 6 3X3   6015618.3638 2091811.707 37.7245938134403 -122.388147417672 (37.7245938134403, -122.388147417672) 10 3 8 58 1
23416 201883 DPW Maintained 1 Tristania conferta :: 61 199 Folsom St 8 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6015205.3081 2115545.7503 37.7897395282145 -122.391233582889 (37.7897395282145, -122.391233582889) 6 2 9 28855 6
23965 141511 DPW Maintained 1 Tristania conferta :: 61 29 KITTREDGE TER 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   5997955.5108 2111504.1279 37.7776698962407 -122.450624415537 (37.7776698962407, -122.450624415537) 15 6 2 54 16
24168 142357 DPW Maintained 1 Tristania conferta :: 61 1135 ELLIS ST 10 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005388.7452 2113384.468 37.7832555126318 -122.425044125193 (37.7832555126318, -122.425044125193) 7 9 11 28858 41
24345 29560 DPW Maintained 1 Tristania conferta :: 61 3100X Ingalls St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 16 3X3   6014251.2078 2089975.3633 37.7194757354442 -122.39274513029 (37.7194757354442, -122.39274513029) 10 3 8 58 1
24535 141271 DPW Maintained 1 Tristania conferta :: 61 381 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997841.2227 2112537.9666 37.7805020054221 -122.45109434754 (37.7805020054221, -122.45109434754) 15 6 2 54 16
24537 142352 DPW Maintained 1 Tristania conferta :: 61 1135 ELLIS ST 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005138.142 2113344.5842 37.783131842304 -122.425908272817 (37.783131842304, -122.425908272817) 7 9 11 28858 41
24618 51914 DPW Maintained 1 Tristania conferta :: 61 1738 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2008 12:00:00 AM 3 3x3 Permit Number 50190 6004049.1514 2119767.1187 37.8007048866604 -122.43013406377 (37.8007048866604, -122.43013406377) 13 9 1 57 17
24694 200893 DPW Maintained 1 Tristania conferta :: 61 825 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6015466.1111 2097093.8178 37.7390889909368 -122.389042368279 (37.7390889909368, -122.389042368279) 10 3 8 58 1
24711 138398 DPW Maintained 1 Tristania conferta :: 61 2445 PINE ST 16 Sidewalk: Curb side : Cutout Tree DPW 1     1 Width 0ft   6002388.1124 2115043.7135 37.7876414218449 -122.435543840756 (37.7876414218449, -122.435543840756) 13 6 11 29490 27
24759 200143 DPW Maintained 1 Tristania conferta :: 61 6215 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 0ft   6013445.5739 2090955.2697 37.7221215837156 -122.395598549244 (37.7221215837156, -122.395598549244) 10 3 8 58 1
24778 115380 Permitted Site 7 Tristania conferta :: 61 1657X York St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/28/2016 12:00:00 AM 3   Permit Number 775521 6010720.61658 2099977.21326 37.7467419766429 -122.405653246985 (37.7467419766429, -122.405653246985) 2 7 7 28859 2
25002 141440 DPW Maintained 1 Tristania conferta :: 61 10 Roselyn Ter 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5998236.4031 2111655.6366 37.7781019737431 -122.449663638425 (37.7781019737431, -122.449663638425) 15 6 2 54 16
25025 12266 DPW Maintained 1 Tristania conferta :: 61 649 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/1991 12:00:00 AM 16 3X3   6004915.2268 2111219.2684 37.7772836485499 -122.426528085844 (37.7772836485499, -122.426528085844) 7 9 11 28852 10
25063 139453 DPW Maintained 1 Tristania conferta :: 61 901 SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6001959.1383 2111617.5381 37.7782096409436 -122.436782648878 (37.7782096409436, -122.436782648878) 15 5 11 29490 41
25196 138756 DPW Maintained 1 Tristania conferta :: 61 2323 SUTTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6001466.9262 2114221.5245 37.7853315391503 -122.438672022334 (37.7853315391503, -122.438672022334) 15 6 11 29490 13
25766 245935 DPW Maintained 1 Tristania conferta :: 61 188 Beulah St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   5997227.0394 2107780.5055 37.7674040687868 -122.452875596673 (37.7674040687868, -122.452875596673) 15 5 11 29492 9
25849 10432 DPW Maintained 1 Tristania conferta :: 61 1441 Haight St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/18/1999 12:00:00 AM 18 3X3   5999180.1356 2108696.8663 37.7700318922285 -122.446186054388 (37.7700318922285, -122.446186054388) 15 5 11 29492 9
25859 140097 DPW Maintained 1 Tristania conferta :: 61 515 GOUGH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6005837.56 2111570.1127 37.7782990795293 -122.423362381053 (37.7782990795293, -122.423362381053) 7 9 11 28852 10
25862 29433 DPW Maintained 1 Tristania conferta :: 61 2401X Ingalls St 6 Sidewalk: Curb side : Cutout Tree DPW 1   08/19/2011 12:00:00 AM 3 3x3   6015500.9632 2091579.7516 37.7239504043026 -122.388537076537 (37.7239504043026, -122.388537076537) 10 3 8 58 1
26175 138912 DPW Maintained 1 Tristania conferta :: 61 719 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6004292.6341 2110798.4737 37.7760930338959 -122.428651831595 (37.7760930338959, -122.428651831595) 7 9 11 28852 10
26320 6186 DPW Maintained 1 Tristania conferta :: 61 1100 Ellis St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005445.8524 2113436.2606 37.783400948036 -122.424850242823 (37.783400948036, -122.424850242823) 7 9 11 28858 41
26470 200925 DPW Maintained 1 Tristania conferta :: 61 4100 03rd St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/26/2017 12:00:00 AM 3 Width 0ft   6015478.3928 2097437.2349 37.7400326248174 -122.389023874228 (37.7400326248174, -122.389023874228) 10 3 8 58 1
26472 6077 DPW Maintained 1 Tristania conferta :: 61 1966 Eddy St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/06/2007 12:00:00 AM 18 4X4   6001073.8278 2112479.7581 37.7805267238289 -122.439907091482 (37.7805267238289, -122.439907091482) 15 5 11 29490 41
26474 6905 DPW Maintained 1 Tristania conferta :: 61 333 Fell St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 3X3   6005791.8208 2110660.0754 37.7757977566382 -122.423455896757 (37.7757977566382, -122.423455896757) 7 9 11 28852 10
26557 7067 DPW Maintained 1 Tristania conferta :: 61 1600 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1   07/26/2016 12:00:00 AM 3 3x3   5999719.0796 2109864.829 37.7732695858551 -122.444405811275 (37.7732695858551, -122.444405811275) 15 5 11 29492 16
26593 65948 DPW Maintained 1 Tristania conferta :: 61 550 Larkin St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/04/1990 12:00:00 AM 12   Permit Number 28969 6007606.7794 2113206.8791 37.7828929393541 -122.417358003683 (37.7828929393541, -122.417358003683) 7 9 9 28852 36
26636 29439 DPW Maintained 1 Tristania conferta :: 61 2303X Ingalls St 5 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 6 3X3   6015640.8979 2091772.6846 37.7244879141293 -122.388066797622 (37.7244879141293, -122.388066797622) 10 3 8 58 1
26662 139042 DPW Maintained 1 Tristania conferta :: 61 1434 BAKER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6000193.0745 2113977.6097 37.7845892631082 -122.443061626662 (37.7845892631082, -122.443061626662) 15 6 11 29490 13
26711 6184 DPW Maintained 1 Tristania conferta :: 61 1100 Ellis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6005484.2824 2113445.6337 37.7834288547985 -122.424717956993 (37.7834288547985, -122.424717956993) 7 9 11 28858 41
26846 15288 DPW Maintained 1 Tristania conferta :: 61 1600 Mission St 7 Sidewalk: Curb side : Cutout Tree DPW 1   04/12/1995 12:00:00 AM 8 3X3   6006995.5283 2109306.0347 37.7721477499918 -122.419195888407 (37.7721477499918, -122.419195888407) 8 2 9 28853 19
26936 10692 DPW Maintained 1 Tristania conferta :: 61 1249 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6001880.3859 2110463.9678 37.7750377503654 -122.436972474402 (37.7750377503654, -122.436972474402) 15 5 11 29492 10
27028 68142 DPW Maintained 1 Tristania conferta :: 61 2532 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/20/1993 12:00:00 AM 1   Permit Number 31896 6000452.2737 2114128.7986 37.785019164077 -122.442175744115 (37.785019164077, -122.442175744115) 15 6 1 29490 27
27103 200991 DPW Maintained 1 Tristania conferta :: 61 75 Folsom St 6 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6015446.9463 2115775.0495 37.7903825381625 -122.390413559192 (37.7903825381625, -122.390413559192) 6 2 9 28855 6
27170 68157 DPW Maintained 1 Tristania conferta :: 61 1515 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/1994 12:00:00 AM 8   Permit Number 33474 6005184.9642 2114742.2338 37.7869720870456 -122.425845804507 (37.7869720870456, -122.425845804507) 13 9 11 28858 13
27181 9604 DPW Maintained 1 Tristania conferta :: 61 1355 Golden Gate Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003125.8375 2112021.5623 37.7793852280154 -122.432775482637 (37.7793852280154, -122.432775482637) 15 9 11 29490 41
27258 139975 DPW Maintained 1 Tristania conferta :: 61 1000 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6001951.2709 2111948.8589 37.7791189172983 -122.436833589276 (37.7791189172983, -122.436833589276) 15 5 11 29490 41
27373 139930 DPW Maintained 1 Tristania conferta :: 61 800 GOUGH ST 4 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005698.3365 2112597.5586 37.7811123361694 -122.423917086976 (37.7811123361694, -122.423917086976) 7 9 11 28852 41
27421 140039 DPW Maintained 1 Tristania conferta :: 61 555 GOUGH ST 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005821.2941 2111685.5479 37.7786151184258 -122.423426859428 (37.7786151184258, -122.423426859428) 7 9 11 28852 10
27583 140342 DPW Maintained 1 Tristania conferta :: 61 1335 LAGUNA ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6004604.4556 2113518.6258 37.7835795423556 -122.42776701682 (37.7835795423556, -122.42776701682) 7 9 11 29490 41
27653 141272 DPW Maintained 1 Tristania conferta :: 61 365 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5997908.5687 2112548.4577 37.7805346667324 -122.450862123717 (37.7805346667324, -122.450862123717) 15 6 2 54 16
27716 15565 DPW Maintained 1 Tristania conferta :: 61 2871 Mission St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2005 12:00:00 AM 3 4X4   6007116.1618 2101629.0258 37.7510752616521 -122.418234216284 (37.7510752616521, -122.418234216284) 2 4 7 28859 19
27759 245990 DPW Maintained 1 Tristania conferta :: 61 1250 Waller St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2010 12:00:00 AM 11 Width 0ft Permit Number 53135 5999824.4044 2108487.46 37.7694936874367 -122.443942497819 (37.7694936874367, -122.443942497819) 15 5 11 29492 9
27995 139342 DPW Maintained 1 Tristania conferta :: 61 1400 GEARY BLVD 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005040.0715 2114155.1684 37.7853519625541 -122.426305287483 (37.7853519625541, -122.426305287483) 13 9 11 28858 13
28057 29382 DPW Maintained 1 Tristania conferta :: 61 3199X Ingalls St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/28/2006 12:00:00 AM 4 3x3   6014237.1991 2089885.2205 37.7192274430768 -122.392787250675 (37.7192274430768, -122.392787250675) 10 3 8 58 1
28143 7043 Permitted Site 7 Tristania conferta :: 61 1300 Fell St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/07/2010 12:00:00 AM 12 3X3   6001130.7028 2110062.144 37.773891804124 -122.439536974078 (37.773891804124, -122.439536974078) 15 5 11 29492 10
28152 138780 DPW Maintained 1 Tristania conferta :: 61 1600 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6003615.8018 2114245.3723 37.785519029862 -122.431239269571 (37.785519029862, -122.431239269571) 13 9 11 29490 13
28177 22470 DPW Maintained 1 Tristania conferta :: 61 6227 03rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/12/1995 12:00:00 AM 5 3x3   6013423.3351 2090899.6727 37.7219676884588 -122.395671530407 (37.7219676884588, -122.395671530407) 10 3 8 58 1
28272 141813 DPW Maintained 1 Tristania conferta :: 61 631 WILLOW ST 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6004531.7581 2113098.1631 37.7824209436961 -122.42798855036 (37.7824209436961, -122.42798855036) 7 9 11 29490 41
28616 248567 DPW Maintained 1 Tristania conferta :: 61 809 Shrader St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5997620.5658 2107720.8482 37.7672628081675 -122.451510146252 (37.7672628081675, -122.451510146252) 15 5 11 29492 9
29000 142193 DPW Maintained 1 Tristania conferta :: 61 1642 FELL ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999555.7794 2109844.0818 37.7732033006663 -122.444969195074 (37.7732033006663, -122.444969195074) 15 5 11 29492 16
29504 138720 DPW Maintained 1 Tristania conferta :: 61 2921 PINE ST 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/22/2016 03:10:00 PM 2 Width 0ft   5999959.1608 2114707.5789 37.7865802293131 -122.443923351787 (37.7865802293131, -122.443923351787) 15 6 1 29490 31
29646 10511 DPW Maintained 1 Tristania conferta :: 61 1800 Haight St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/10/2007 12:00:00 AM 6 3X3   5997484.5237 2108509.319 37.7694199557275 -122.452037587086 (37.7694199557275, -122.452037587086) 15 5 11 29492 9
29736 12282 DPW Maintained 1 Tristania conferta :: 61 745 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x10   6004875.3929 2111529.8441 37.7781341613075 -122.426688006249 (37.7781341613075, -122.426688006249) 7 9 11 28852 10
30175 139929 DPW Maintained 1 Tristania conferta :: 61 800 GOUGH ST 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6005694.4032 2112619.0761 37.7811711958921 -122.423932224805 (37.7811711958921, -122.423932224805) 7 9 11 28852 41
30192 184232 DPW Maintained 1 Tristania conferta :: 61 1500 Kirkham St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   5983211.3452 2104903.2019 37.7586906757833 -122.501140335143 (37.7586906757833, -122.501140335143) 1 8 3 56 35
30243 13145 DPW Maintained 1 Tristania conferta :: 61 1801 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/02/1996 12:00:00 AM 8 3X3   6003646.5026 2119634.2054 37.8003171280845 -122.431517900376 (37.8003171280845, -122.431517900376) 13 9 1 57 17
30290 13100 DPW Maintained 1 Tristania conferta :: 61 1501 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/12/2017 12:00:00 AM 8 3X3   6005075.7106 2119828.8842 37.800932566852 -122.426586143087 (37.800932566852, -122.426586143087) 13 9 1 57 17
30389 29432 DPW Maintained 1 Tristania conferta :: 61 2401X Ingalls St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/28/2006 12:00:00 AM 3 3X3   6015452.0518 2091514.7509 37.7237692145382 -122.38870162152 (37.7237692145382, -122.38870162152) 10 3 8 58 1
30412 139853 DPW Maintained 1 Tristania conferta :: 61 735 GOUGH ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005744.0619 2112263.2548 37.7801970011251 -122.423735122838 (37.7801970011251, -122.423735122838) 7 9 11 28852 41
30494 199816 DPW Maintained 1 Tristania conferta :: 61 2240 Ingalls St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6015734.8816 2091975.4915 37.7250499884833 -122.387756049526 (37.7250499884833, -122.387756049526) 10 3 8 58 1
30683 6223 DPW Maintained 1 Tristania conferta :: 61 1220 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1   05/13/1997 12:00:00 AM 12 3X4   6005122.7706 2113389.4093 37.7832540522328 -122.425964643575 (37.7832540522328, -122.425964643575) 7 9 11 28858 41
30694 248608 DPW Maintained 1 Tristania conferta :: 61 432 Frederick St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   5997774.403 2107510.382 37.7666937298525 -122.450962870008 (37.7666937298525, -122.450962870008) 15 5 11 29492 9
31069 50648 DPW Maintained 1 Tristania conferta :: 61 821 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2003 12:00:00 AM 4   Permit Number 47233 6012137.5662 2112614.0037 37.7815189132409 -122.401641589024 (37.7815189132409, -122.401641589024) 6 2 9 28856 34
31234 141807 DPW Maintained 1 Tristania conferta :: 61 1398 WILLOW ST 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6004301.1437 2113069.4068 37.7823289364611 -122.428784324512 (37.7823289364611, -122.428784324512) 7 9 11 29490 41
31384 61393 DPW Maintained 1 Tristania conferta :: 61 926 Taraval St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/11/2008 12:00:00 AM 3 3x3 Permit Number 50349 5990253.2983 2099081.9773 37.7431181185655 -122.476361078322 (37.7431181185655, -122.476361078322) 1 8 3 29491 35
31489 8187 DPW Maintained 1 Tristania conferta :: 61 1255 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6001743.6158 2111134.8252 37.7768719817661 -122.437493642173 (37.7768719817661, -122.437493642173) 15 5 11 29492 10
31759 141280 DPW Maintained 1 Tristania conferta :: 61 327 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   5998124.1433 2112580.2694 37.7806343517008 -122.450118646064 (37.7806343517008, -122.450118646064) 15 6 2 54 16
31794 13264 DPW Maintained 1 Tristania conferta :: 61 2460 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1993 12:00:00 AM 19 3X3   6000672.0217 2119297.5934 37.7992238445501 -122.441786579885 (37.7992238445501, -122.441786579885) 13 9 1 57 17
31804 7089 DPW Maintained 1 Tristania conferta :: 61 1874 Fell St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/25/2009 12:00:00 AM 3 3x3   5998459.5467 2109686.5004 37.7727079965007 -122.448749840415 (37.7727079965007, -122.448749840415) 15 5 11 29492 16
31903 138226 DPW Maintained 1 Tristania conferta :: 61 101 Anza St 8 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5998572.2138 2112635.4321 37.7808114442344 -122.448572536471 (37.7808114442344, -122.448572536471) 15 6 2 54 16

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)
);