Street_Tree_List

Data source: data.sfgov.org

711 rows where qSpecies = 36 sorted by qLegalStatus

View and edit SQL

Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant

Link rowid TreeID qLegalStatus ▼ qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
1150 246081 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1390 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     26 Width 0ft   5999109.7278 2108387.5264 37.769178502070204 -122.44640733565201 (37.7691785020702, -122.446407335652)
2951 246120 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1285 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/1979 12:00:00 AM 17 Width 0ft Permit Number 17675 5999562.003 2108407.0589 37.769257954715705 -122.44484435027799 (37.7692579547157, -122.444844350278)
3022 246073 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1209 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/29/1979 12:00:00 AM 18 Width 0ft Permit Number 17669 5999896.6292 2108453.3917 37.7694042640863 -122.44369022814199 (37.7694042640863, -122.443690228142)
4178 246147 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1504 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   5998476.2094 2108299.706 37.768901165807705 -122.448592305739 (37.7689011658077, -122.448592305739)
4228 248327 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   5998303.294 2108219.7591 37.768671763303104 -122.449184645334 (37.7686717633031, -122.449184645334)
4288 248328 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 Width 0ft   5998322.9779 2108222.7874 37.768681204074895 -122.44911677876101 (37.7686812040749, -122.449116778761)
4294 248325 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1979 12:00:00 AM 19 Width 0ft Permit Number 17699 5998266.3488 2108214.611 37.7686555147255 -122.44931206435 (37.7686555147255, -122.44931206435)
4299 248326 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5998285.1242 2108217.0336 37.768663240508 -122.44924729658001 (37.768663240508, -122.44924729658)
5622 87285 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1820 Webster St 1 Front Yard : Cutout 8 Tree 1 Private 1     24 3x3 Permit Number 50302 6003460.507999999 2115059.4384 37.7877454479518 -122.43183468665801 (37.7877454479518, -122.431834686658)
7110 10652 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 931 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6003404.4622 2110674.9336 37.775703518104 -122.431715431116 (37.775703518104, -122.431715431116)
7855 10655 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 937 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6003345.7495 2110667.1791 37.775678897926 -122.43191797899799 (37.775678897926, -122.431917978998)
7947 2629 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1872 Bush St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6004578.2934 2115053.5876 37.787792683911 -122.427966943787 (37.787792683911, -122.427966943787)
9063 4830 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     44 5x5   6006270.256805 2097668.3997492 37.740152628556 -122.42087828555401 (37.740152628556, -122.420878285554)
9234 4832 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 104X CORTLAND AVE 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     48 3X3   6006272.0 2097672.0 37.7401626122958 -122.420872513823 (37.7401626122958, -122.420872513823)
9298 17755 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6005983.055346799 2115593.0882202997 37.789353391125104 -122.42314508816901 (37.7893533911251, -122.423145088169)
9377 17756 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6005973.81147 2115593.81965 37.7893548777914 -122.423177122971 (37.7893548777914, -122.423177122971)
9401 4822 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 60 Cortland Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     75 3X3   6006061.0289274 2097780.9763268996 37.7404499429552 -122.421609705422 (37.7404499429552, -122.421609705422)
9504 17758 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 8 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6005894.5926 2115584.1297299997 37.7893238007876 -122.423450522313 (37.7893238007876, -122.423450522313)
9564 17759 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 9 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6005845.8328233 2115574.0220236 37.7892932953595 -122.42361850671999 (37.7892932953595, -122.42361850672)
10033 54506 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1215 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/1972 12:00:00 AM   5x5 Permit Number 10300 5995769.71808299 2107217.0895637 37.7657734551651 -122.457875462722 (37.7657734551651, -122.457875462722)
10973 55642 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 422 Russia Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/01/2015 12:00:00 AM 3 4x4 Permit Number 775006 6002423.93112 2090348.58782 37.719836534298 -122.433654298202 (37.719836534298, -122.433654298202)
11298 25444 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2155 Bay Shore Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     5 3x3   6011824.01572 2087503.73336 37.7125540294141 -122.40096152627399 (37.7125540294141, -122.400961526274)
11921 61836 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 209 Theresa St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/01/1985 12:00:00 AM 14 3x3 Permit Number 21875 6001956.61236 2093885.6272599997 37.7295219188836 -122.435522552544 (37.7295219188836, -122.435522552544)
13479 22442 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 6025 03rd St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     24 3X3   6013654.8805 2091521.7057 37.7236885437418 -122.394914674123 (37.7236885437418, -122.394914674123)
13488 3672 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 108 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6017032.375109999 2098991.89434 37.7443874218329 -122.383759005485 (37.7443874218329, -122.383759005485)
13710 3708 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 401X Cargo Way 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6016594.5506 2099214.51013 37.744974467789504 -122.385288434823 (37.7449744677895, -122.385288434823)
13776 3680 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 116 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6016866.69606 2099115.15257 37.7447167041098 -122.384340477447 (37.7447167041098, -122.384340477447)
13880 3671 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 107 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6017047.36981 2098978.83891 37.7443524031345 -122.38370624765 (37.7443524031345, -122.38370624765)
13891 26809 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1471 McKinnon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6016061.043 2095379.9811 37.7344161021924 -122.38686585494 (37.7344161021924, -122.38686585494)
14381 3679 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 115 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6016884.1224 2099103.28613 37.744685084848896 -122.384279393677 (37.7446850848489, -122.384279393677)
14752 3664 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 100 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6017168.62408 2098888.98032 37.744112371380204 -122.383280718132 (37.7441123713802, -122.383280718132)
15305 3683 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 119 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6016838.589430001 2099135.269 37.7447703855426 -122.384439066524 (37.7447703855426, -122.384439066524)
15310 3668 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 104 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     12 3X3   6017100.61527 2098941.7519 37.7442535127858 -122.38351955288 (37.7442535127858, -122.38351955288)
15340 3684 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 120 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6016817.82171 2099151.7639099997 37.744814528777795 -122.384512026728 (37.7448145287778, -122.384512026728)
15381 3665 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 101 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6017153.34624 2098900.7145700003 37.74414374693129 -122.383334362693 (37.7441437469313, -122.383334362693)
15426 3670 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 106 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6017067.53558 2098965.3092900002 37.744316368207706 -122.383635576218 (37.7443163682077, -122.383635576218)
15773 3675 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 111 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3X3   6016978.81066 2099030.1280400003 37.74448944274229 -122.383946883753 (37.7444894427423, -122.383946883753)
16319 26014 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Oakdale Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/19/2004 12:00:00 AM 3 3X3   6014769.7753099995 2095716.92157 37.735269692036205 -122.39135377296002 (37.7352696920362, -122.39135377296)
16445 3669 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 105 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     17 3X3   6017084.9315599995 2098953.56707 37.7442850879842 -122.383574606702 (37.7442850879842, -122.383574606702)
16591 3678 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 114 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6016900.5532599995 2099090.71493 37.7446514753884 -122.384221703094 (37.7446514753884, -122.384221703094)
16743 3677 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 113 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9   03/07/2006 12:00:00 AM 3 3x3   6016945.8178 2099054.7063700003 37.7445551058345 -122.38406267865801 (37.7445551058345, -122.384062678658)
17950 4408 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1091 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4x4   6004454.91155 2102571.21825 37.7535121447905 -122.42750421154301 (37.7535121447905, -122.427504211543)
18729 4825 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 72 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     80 3X3   6006134.02134 2097745.6697400003 37.7403571145946 -122.421354819194 (37.7403571145946, -122.421354819194)
18780 16006 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 95 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3   6001386.18936 2094608.8979 37.7314754397255 -122.43754633291799 (37.7314754397255, -122.437546332918)
19493 4411 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1101 Church St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 4X4   6004460.022890001 2102441.95426 37.7531575052231 -122.42747732723801 (37.7531575052231, -122.427477327238)
20016 16033 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 159 Monterey Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X4   6001012.52549 2094617.56697 37.7314779911003 -122.438838778307 (37.7314779911003, -122.438838778307)
21392 4831 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 101 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6006324.12928 2097690.18327 37.74021547767221 -122.420693562078 (37.7402154776722, -122.420693562078)
22192 4813 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 29 Cortland Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 3x3   6005915.07365 2097910.62237 37.740797690665396 -122.422123570454 (37.7407976906654, -122.422123570454)
22379 17784 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1798X Pine St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6005418.97388 2115516.65721 37.7891116821071 -122.42509130621599 (37.7891116821071, -122.425091306216)
24596 138923 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 970 HAYES ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     25 Width 0ft   6003200.9063 2110690.9965 37.7757360824046 -122.432420728644 (37.7757360824046, -122.432420728644)
28308 67884 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 5X Lisbon St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/03/1993 12:00:00 AM 15   Permit Number 31577 6003921.69231 2093425.09481 37.72836881267121 -122.428696258429 (37.7283688126712, -122.428696258429)
28860 51570 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 227 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 02/04/2005 12:00:00 AM 17   Permit Number 47867 5988337.51894 2114460.53389 37.7852321378524 -122.48411277430401 (37.7852321378524, -122.484112774304)
40659 62578 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 739 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/1986 12:00:00 AM 9   Permit Number 22783 6011302.7424099995 2104925.74778 37.7603620991639 -122.403988486898 (37.7603620991639, -122.403988486898)
50076 58511 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1430 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   03/30/1979 12:00:00 AM     Permit Number 17687 5998871.25967783 2108358.36156462 37.7690847998305 -122.447230081169 (37.7690847998305, -122.447230081169)
57547 38224 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1099 Mississippi St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 10/05/2002 12:00:00 AM 14   Permit Number 40351 6014264.59569 2102044.43409 37.7526156672934 -122.39354307806101 (37.7526156672934, -122.393543078061)
62464 62579 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 741 Vermont St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 03/01/1986 12:00:00 AM 10   Permit Number 22784 6011303.77085 2104898.93824 37.7602885436105 -122.40398304329399 (37.7602885436105, -122.403983043294)
69275 116508 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1500x Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5998488.0 2108327.0 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995)
70753 206290 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 519 Faxon Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   12/15/1989 12:00:00 AM 13 Width 3ft Permit Number 28366 5994747.213769999 2092021.25084 37.7239906908132 -122.460310960879 (37.7239906908132, -122.460310960879)
78284 36808 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1290 Egbert Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
78413 51528 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2900 Hawes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
81696 51527 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2900 Hawes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   01/14/2005 12:00:00 AM     Permit Number 47830 6014679.41969777 2089453.24857655 37.7180658851091 -122.39122846992599 (37.7180658851091, -122.391228469926)
82988 107948 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2200 JERROLD AVE 4 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815)
83231 36833 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2715 Ingalls St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)
84347 106497 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1890 Page St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 772114 5997541.6 2108881.8 37.770445962098705 -122.451867038975 (37.7704459620987, -122.451867038975)
84902 3682 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 100X Cargo Way 118 Sidewalk: Curb side : Cutout 1 Tree 1 Port 9     18 3X3   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
86521 54509 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1291 Arguello Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/12/1972 12:00:00 AM   6x5 Permit Number 10303 5995784.13645716 2106797.98257299 37.7646235238936 -122.457795263133 (37.7646235238936, -122.457795263133)
87130 10269 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 215X Haight St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     80 6X12   6005099.693995 2109521.3764509996 37.7726320769714 -122.42576907222299 (37.7726320769714, -122.425769072223)
89868 36789 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1314 Donner Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
90901 116512 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5998383.76026587 2108237.92603054 37.768726247134204 -122.448907628846 (37.7687262471342, -122.448907628846)
93165 95079 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1110 Mariposa St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   6013929.4 2106263.3 37.7641811276583 -122.394997717565 (37.7641811276583, -122.394997717565)
95397 105511 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 400X Steiner St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1         Permit Number 772834 6003196.1616 2109801.36502 37.7732931051579 -122.432373588443 (37.7732931051579, -122.432373588443)
95666 36809 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1290 Egbert Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39532 6014916.278192299 2090716.3266444001 37.721547191141205 -122.39049795372 (37.7215471911412, -122.39049795372)
96253 41569 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 63 Ruth St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   05/05/2000 12:00:00 AM     Permit Number 42084 6001453.1346338 2091658.26221962 37.723377473003104 -122.437103713844 (37.7233774730031, -122.437103713844)
96814 10650 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 923 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3X3   6003416.95187 2110680.8277 37.7757204098004 -122.431672647172 (37.7757204098004, -122.431672647172)
97104 50378 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1620 Montgomery St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
98225 107945 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2200 JERROLD AVE 1 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815)
99078 116513 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5998383.76026587 2108237.92603054 37.768726247134204 -122.448907628846 (37.7687262471342, -122.448907628846)
99312 20132 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 990X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6003116.52257 2110682.58178 37.7757081923636 -122.43271203162901 (37.7757081923636, -122.432712031629)
106685 120529 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1390 Waller St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634)
108308 107950 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2200 JERROLD AVE 6 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815)
111141 2204 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1120 Broderick St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 5x9   6000904.16856 2112542.81493 37.7806902026292 -122.440498545519 (37.7806902026292, -122.440498545519)
111273 62887 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 149 Prentiss St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   07/21/1986 12:00:00 AM 18 3x3 Permit Number 23260 6008863.78099283 2097860.37589342 37.7408255991868 -122.411924460546 (37.7408255991868, -122.411924460546)
116654 28140 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 525X Eugenia Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     60 4X4   6007061.2074168 2097884.914897 37.7407916822017 -122.418158839049 (37.7407916822017, -122.418158839049)
116970 34459 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1960 Jones St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/21/2015 12:00:00 AM     Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
117255 107946 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2200 JERROLD AVE 2 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815)
117616 36790 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1314 Donner Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39526 6015468.42166203 2090653.62366449 37.7214056358126 -122.388584951991 (37.7214056358126, -122.388584951991)
118094 107951 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2200 JERROLD AVE 7 Sidewalk: Property side : Cutout 5 Tree 1 Private 1       3x3   6012443.5 2099218.7 37.7447554536478 -122.399642400815 (37.7447554536478, -122.399642400815)
119460 20127 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 999X Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 3x3   6003226.6736 2110648.3783 37.7756205244718 -122.432328548686 (37.7756205244718, -122.432328548686)
119889 116514 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4x4   5998383.76026587 2108237.92603054 37.768726247134204 -122.448907628846 (37.7687262471342, -122.448907628846)
120244 34458 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1960 Jones St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/21/2015 12:00:00 AM   3x3 Permit Number 42077 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
123002 48545 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 501X Mariposa St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   08/22/2002 12:00:00 AM   3x3 Permit Number 45866 6013823.0 2112518.0 37.7813492145506 -122.39580402612101 (37.7813492145506, -122.395804026121)
123678 97297 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 450 06th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5994062.8 2112448.2 37.7800384821655 -122.46415907596202 (37.7800384821655, -122.464159075962)
125997 34460 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1960 Jones St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 12/21/2015 12:00:00 AM   3x3 Permit Number 38200 6008233.26269903 2119182.7725058 37.7993365057546 -122.415613869084 (37.7993365057546, -122.415613869084)
128144 50377 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1620 Montgomery St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   10/01/2003 12:00:00 AM     Permit Number 47039 6011351.83248495 2120835.88186523 37.804050345434 -122.404938924734 (37.804050345434, -122.404938924734)
132884 102293 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 801 Cesar Chavez St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6016486.61621 2101147.40436 37.7502758246674 -122.385796353939 (37.7502758246674, -122.385796353939)
133143 102290 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 801 Cesar Chavez St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 3x3   6016394.11438 2101141.39793 37.7502542130621 -122.386115815616 (37.7502542130621, -122.386115815616)
139546 17753 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1634 Pine St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3X3   6006028.796019999 2115599.444 37.7893734236606 -122.422987282423 (37.7893734236606, -122.422987282423)
141205 58522 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 1525 Waller St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/02/1979 12:00:00 AM   4x4 Permit Number 17699 5998383.76026587 2108237.92603054 37.768726247134204 -122.448907628846 (37.7687262471342, -122.448907628846)
146060 106499 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 420X Shrader St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1           5997462.73555 2109001.92463 37.770771276139705 -122.452148498658 (37.7707712761397, -122.452148498658)
146328 36834 Permitted Site 1 Eucalyptus sideroxylon :: Red Ironbark 36 2715 Ingalls St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/26/1998 12:00:00 AM     Permit Number 39537 6015005.69395491 2090908.83002417 37.7220807273762 -122.390202307194 (37.7220807273762, -122.390202307194)

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 497.396ms · Data source: data.sfgov.org